Queries
max count: 2
Query |
Count |
Min time |
Max time |
Average time |
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages WHERE 1 AND cscart_languages.status = 'A'
|
2 |
0.00026 |
0.00050 |
0.00038 |
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'
|
1 |
0.00060 |
0.00060 |
0.00060 |
SELECT COUNT(DISTINCT storefronts.storefront_id) FROM cscart_storefronts AS storefronts WHERE 1 = 1
|
1 |
0.00030 |
0.00030 |
0.00030 |
SELECT product_variant, category_variants FROM cscart_ec_vendor_filter_map
|
1 |
0.00019 |
0.00019 |
0.00019 |
SELECT cscart_profile_field_values.value_id, cscart_profile_field_descriptions.description FROM cscart_profile_field_values LEFT JOIN cscart_profile_field_descriptions ON cscart_profile_field_values.value_id = cscart_profile_field_descriptions.object_id WHERE cscart_profile_field_descriptions.lang_code = 'en' AND cscart_profile_field_descriptions. object_type = 'V' AND cscart_profile_field_values.field_id = 62
|
1 |
0.00073 |
0.00073 |
0.00073 |
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)
|
1 |
0.00027 |
0.00027 |
0.00027 |
SELECT order_id ,send_time FROM cscart_order_delivery_confirmation_request_data
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT order_id FROM cscart_orders WHERE order_confirmation =0 AND status='E' AND order_status_update_timestamp>0
|
1 |
0.00021 |
0.00021 |
0.00021 |
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_settings_objects.value END) AS value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_settings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1 AND (FIND_IN_SET('STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 6508 ORDER BY cscart_settings_objects.position
|
1 |
0.00039 |
0.00039 |
0.00039 |
SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'wk_order_confirm_data_tpl_data'
|
1 |
0.00034 |
0.00034 |
0.00034 |
SELECT a.usergroup_id, a.status, a.type, b.usergroup, a.use_as_user_type, a.need_activate_user, a.notice_email, a.position FROM cscart_usergroups as a LEFT JOIN cscart_usergroup_descriptions as b ON b.usergroup_id = a.usergroup_id AND b.lang_code = 'en' WHERE 1 AND a.status = 'A' AND a.type IN ('A', 'C', 'V') AND a.use_as_user_type = 'Y' ORDER BY position
|
1 |
0.00033 |
0.00033 |
0.00033 |
SELECT cscart_settings_objects.object_id as object_id, name, section_id, section_tab_id, type, position, is_global, cscart_settings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_settings_objects.value END) AS value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_settings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1 AND section_id = 558 AND (FIND_IN_SET('STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_settings_objects.edition_type)) AND cscart_settings_objects.type <> 'H' ORDER BY cscart_settings_objects.position
|
1 |
0.00084 |
0.00084 |
0.00084 |
SELECT * FROM cscart_settings_sections WHERE name = 'cp_power_blog' AND type = 'ADDON' AND (FIND_IN_SET('STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_settings_sections.edition_type))
|
1 |
0.00036 |
0.00036 |
0.00036 |
SELECT cscart_settings_sections.name, cscart_settings_sections.section_id, cscart_settings_sections.position, cscart_settings_sections.type , cscart_settings_sections.name as description, CONCAT('settings.manage?section_id=', cscart_settings_sections.name) as href FROM cscart_settings_sections WHERE 1 AND (FIND_IN_SET('STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_settings_sections.edition_type)) ORDER BY cscart_settings_sections.position
|
1 |
0.00062 |
0.00062 |
0.00062 |
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 1928 AND l.dispatch IN ('auth') ORDER BY l.object_ids desc LIMIT 1
|
1 |
0.04135 |
0.04135 |
0.04135 |
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'
|
1 |
0.00027 |
0.00027 |
0.00027 |
SELECT storefronts.* FROM cscart_storefronts AS storefronts WHERE 1 = 1 AND (storefronts.url = 'dev-webmarco.com' OR storefronts.url = 'www.dev-webmarco.com' OR storefronts.url LIKE 'www_.dev-webmarco.com' OR storefronts.url LIKE 'dev-webmarco.com/%' OR storefronts.url LIKE 'www.dev-webmarco.com/%' OR storefronts.url LIKE 'www_.dev-webmarco.com/%') GROUP BY storefronts.storefront_id ORDER BY storefronts.url = 'dev-webmarco.com' DESC, storefronts.url = 'www.dev-webmarco.com' DESC, storefronts.url LIKE 'www_.dev-webmarco.com' DESC, storefronts.url LIKE 'dev-webmarco.com/%' DESC, storefronts.url LIKE 'www.dev-webmarco.com/%' DESC, storefronts.url LIKE 'www_.dev-webmarco.com/%' desc
|
1 |
0.00057 |
0.00057 |
0.00057 |
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 1928 AND l.dispatch IN ('auth.login_form') ORDER BY l.object_ids desc LIMIT 1
|
1 |
0.04782 |
0.04782 |
0.04782 |
SELECT * FROM cscart_bm_layouts WHERE 1 AND storefront_id = 1 AND layout_id = 1928
|
1 |
0.00026 |
0.00026 |
0.00026 |
SELECT * FROM cscart_abt__ut2_settings WHERE lang_code = 'en'
|
1 |
0.00049 |
0.00049 |
0.00049 |
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'
|
1 |
0.00018 |
0.00018 |
0.00018 |
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'
|
1 |
0.00041 |
0.00041 |
0.00041 |
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts WHERE 1 AND is_default = 1 AND theme_name = 'vivashop' AND storefront_id = 1
|
1 |
0.00035 |
0.00035 |
0.00035 |
SELECT default_langsf FROM cscart_storefronts WHERE storefront_id = 1
|
1 |
0.00022 |
0.00022 |
0.00022 |
SELECT storefronts.* FROM cscart_storefronts AS storefronts WHERE 1 = 1 AND storefronts.is_default IN ('Y') GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc
|
1 |
0.00051 |
0.00051 |
0.00051 |
SELECT * FROM cscart_seo_names WHERE name = 'auth-loginform'
|
1 |
0.00027 |
0.00027 |
0.00027 |
SELECT type FROM cscart_seo_names WHERE name = 'auth-loginform'
|
1 |
0.00034 |
0.00034 |
0.00034 |
SET time_zone = '+02:00'
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'
|
1 |
0.00016 |
0.00016 |
0.00016 |