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.00017 |
0.00038 |
0.00027 |
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'
|
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.00077 |
0.00077 |
0.00077 |
SELECT product_variant, category_variants FROM cscart_ec_vendor_filter_map
|
1 |
0.00021 |
0.00021 |
0.00021 |
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.00069 |
0.00069 |
0.00069 |
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT a.code, b.state FROM cscart_states as a LEFT JOIN cscart_state_descriptions as b ON b.state_id = a.state_id AND b.lang_code = 'en' WHERE a.country_code = '' ORDER BY b.state
|
1 |
0.00032 |
0.00032 |
0.00032 |
SELECT cscart_promotions.*, cscart_promotion_descriptions.name, cscart_promotion_descriptions.detailed_description, cscart_promotion_descriptions.short_description FROM cscart_promotions LEFT JOIN cscart_promotion_descriptions ON cscart_promotion_descriptions.promotion_id = cscart_promotions.promotion_id AND cscart_promotion_descriptions.lang_code = 'en' LEFT JOIN cscart_storefronts_promotions AS storefronts_promotions ON storefronts_promotions.promotion_id = cscart_promotions.promotion_id WHERE 1 AND IF(from_date, from_date <= 1727848257, 1) AND IF(to_date, to_date >= 1727848257, 1) AND status IN ('A', 'H') AND cscart_promotions.zone = 'cart' AND (storefronts_promotions.storefront_id = 1 OR storefronts_promotions.storefront_id IS NULL) ORDER BY cscart_promotions.stop_other_rules desc, cscart_promotions.priority asc
|
1 |
0.00110 |
0.00110 |
0.00110 |
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'payment' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '6' ORDER BY cscart_images_links.position, cscart_images_links.pair_id;SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'payment' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '6' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00062 |
0.00062 |
0.00062 |
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'payment' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '1' ORDER BY cscart_images_links.position, cscart_images_links.pair_id;SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'payment' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '1' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00099 |
0.00099 |
0.00099 |
SELECT cscart_payments.*, cscart_payment_descriptions.*, IF (ISNULL(cscart_addons.status), "A", cscart_addons.status) AS processor_status, cscart_payment_processors.type AS processor_type, cscart_payment_processors.processor_script AS processor_script FROM cscart_payments LEFT JOIN cscart_payment_descriptions ON cscart_payment_descriptions.payment_id = cscart_payments.payment_id AND cscart_payment_descriptions.lang_code = 'en' LEFT JOIN cscart_payment_processors ON cscart_payment_processors.processor_id = cscart_payments.processor_id LEFT JOIN cscart_addons ON cscart_payment_processors.addon = cscart_addons.addon LEFT JOIN cscart_storefronts_payments AS storefronts_payments ON storefronts_payments.payment_id = cscart_payments.payment_id WHERE cscart_payments.status = 'A' AND (cscart_payments.usergroup_ids = '' OR FIND_IN_SET(0, cscart_payments.usergroup_ids) OR FIND_IN_SET(1, cscart_payments.usergroup_ids)) AND (storefronts_payments.storefront_id = 1 OR storefronts_payments.storefront_id IS NULL) HAVING processor_status = 'A' ORDER BY cscart_payments.position
|
1 |
0.00224 |
0.00224 |
0.00224 |
SELECT order_id ,send_time FROM cscart_order_delivery_confirmation_request_data
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT order_id FROM cscart_orders WHERE order_confirmation =0 AND status='E' AND order_status_update_timestamp>0
|
1 |
0.00027 |
0.00027 |
0.00027 |
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.00030 |
0.00030 |
0.00030 |
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.00022 |
0.00022 |
0.00022 |
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.00039 |
0.00039 |
0.00039 |
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.00071 |
0.00071 |
0.00071 |
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.00031 |
0.00031 |
0.00031 |
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.00054 |
0.00054 |
0.00054 |
SELECT COUNT(DISTINCT storefronts.storefront_id) FROM cscart_storefronts AS storefronts WHERE 1 = 1
|
1 |
0.00035 |
0.00035 |
0.00035 |
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'
|
1 |
0.00018 |
0.00018 |
0.00018 |
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 ('checkout.cart') ORDER BY l.object_ids desc LIMIT 1
|
1 |
0.04561 |
0.04561 |
0.04561 |
SELECT * FROM cscart_bm_layouts WHERE 1 AND storefront_id = 1 AND layout_id = 1928
|
1 |
0.00025 |
0.00025 |
0.00025 |
SELECT * FROM cscart_abt__ut2_settings WHERE lang_code = 'en'
|
1 |
0.00038 |
0.00038 |
0.00038 |
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'
|
1 |
0.00033 |
0.00033 |
0.00033 |
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts WHERE 1 AND is_default = 1 AND theme_name = 'vivashop' AND storefront_id = 1
|
1 |
0.00029 |
0.00029 |
0.00029 |
SELECT default_langsf FROM cscart_storefronts WHERE storefront_id = 1
|
1 |
0.00016 |
0.00016 |
0.00016 |
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.00046 |
0.00046 |
0.00046 |
SELECT * FROM cscart_seo_names WHERE name = 'checkout-cart'
|
1 |
0.00025 |
0.00025 |
0.00025 |
SELECT type FROM cscart_seo_names WHERE name = 'checkout-cart'
|
1 |
0.00031 |
0.00031 |
0.00031 |
SET time_zone = '+02:00'
|
1 |
0.00010 |
0.00010 |
0.00010 |
SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'
|
1 |
0.00019 |
0.00019 |
0.00019 |