Queries
max count: 2
| Query |
Count |
Min time |
Max time |
Average time |
SELECT * FROM cscart_multi_dechybrid_auth_providers WHERE 1 AND status = 'A' ORDER BY position
|
2 |
0.00010 |
0.00035 |
0.00023 |
SELECT data FROM cscart_multi_decstorage_data WHERE data_key = 'store_mode'
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT storefronts.* FROM cscart_multi_decstorefronts AS storefronts WHERE 1 = 1 AND (storefronts.url = 'vishal.ecarter.co' OR storefronts.url = 'www.vishal.ecarter.co' OR storefronts.url LIKE 'www_.vishal.ecarter.co' OR storefronts.url LIKE 'vishal.ecarter.co/%' OR storefronts.url LIKE 'www.vishal.ecarter.co/%' OR storefronts.url LIKE 'www_.vishal.ecarter.co/%') GROUP BY storefronts.storefront_id ORDER BY storefronts.url = 'vishal.ecarter.co' DESC, storefronts.url = 'www.vishal.ecarter.co' DESC, storefronts.url LIKE 'www_.vishal.ecarter.co' DESC, storefronts.url LIKE 'vishal.ecarter.co/%' DESC, storefronts.url LIKE 'www.vishal.ecarter.co/%' DESC, storefronts.url LIKE 'www_.vishal.ecarter.co/%' desc
|
1 |
0.00022 |
0.00022 |
0.00022 |
SET time_zone = '+08:00'
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT cscart_multi_declanguages.lang_code, cscart_multi_declanguages.name FROM cscart_multi_declanguages WHERE 1 AND cscart_multi_declanguages.status = 'A'
|
1 |
0.00036 |
0.00036 |
0.00036 |
SELECT storefronts.* FROM cscart_multi_decstorefronts AS storefronts WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT cscart_multi_decbm_layouts.* FROM cscart_multi_decbm_layouts WHERE 1 AND is_default = 1 AND theme_name = 'nova_theme' AND storefront_id = 1
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT data FROM cscart_multi_decstorage_data WHERE data_key = 'cart_products_next_check'
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT ec_timezone FROM cscart_multi_decstorefronts WHERE storefront_id = 1
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT data FROM cscart_multi_decstorage_data WHERE data_key = 'dev_mode'
|
1 |
0.00020 |
0.00020 |
0.00020 |
SELECT COUNT(DISTINCT storefronts.storefront_id) FROM cscart_multi_decstorefronts AS storefronts WHERE 1 = 1
|
1 |
0.00028 |
0.00028 |
0.00028 |
SELECT cscart_multi_decsettings_sections.name, cscart_multi_decsettings_sections.section_id, cscart_multi_decsettings_sections.position, cscart_multi_decsettings_sections.type , cscart_multi_decsettings_sections.name as description, CONCAT('settings.manage?section_id=', cscart_multi_decsettings_sections.name) as href FROM cscart_multi_decsettings_sections WHERE 1 AND (FIND_IN_SET('STOREFRONT', cscart_multi_decsettings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_multi_decsettings_sections.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_multi_decsettings_sections.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_multi_decsettings_sections.edition_type)) ORDER BY cscart_multi_decsettings_sections.position
|
1 |
0.00030 |
0.00030 |
0.00030 |
SELECT object_id FROM cscart_multi_decsettings_objects LEFT JOIN cscart_multi_decsettings_sections ON cscart_multi_decsettings_objects.section_id = cscart_multi_decsettings_sections.section_id WHERE cscart_multi_decsettings_objects.name = 'color_schema' AND cscart_multi_decsettings_sections.name = 'vendor_panel_configurator'
|
1 |
0.00019 |
0.00019 |
0.00019 |
SELECT cscart_multi_decsettings_objects.object_id as object_id, cscart_multi_decsettings_objects.type as object_type, cscart_multi_decsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_multi_decsettings_objects.value END) AS value FROM cscart_multi_decsettings_objects LEFT JOIN cscart_multi_decsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_multi_decsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1 AND (FIND_IN_SET('STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_multi_decsettings_objects.edition_type)) AND cscart_multi_decsettings_objects.object_id = 5961 ORDER BY cscart_multi_decsettings_objects.position
|
1 |
0.00018 |
0.00018 |
0.00018 |
SELECT object_id FROM cscart_multi_decsettings_objects LEFT JOIN cscart_multi_decsettings_sections ON cscart_multi_decsettings_objects.section_id = cscart_multi_decsettings_sections.section_id WHERE cscart_multi_decsettings_objects.name = 'sidebar_color' AND cscart_multi_decsettings_sections.name = 'vendor_panel_configurator'
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT cscart_multi_decsettings_objects.object_id as object_id, cscart_multi_decsettings_objects.type as object_type, cscart_multi_decsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_multi_decsettings_objects.value END) AS value FROM cscart_multi_decsettings_objects LEFT JOIN cscart_multi_decsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_multi_decsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1 AND (FIND_IN_SET('STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_multi_decsettings_objects.edition_type)) AND cscart_multi_decsettings_objects.object_id = 5962 ORDER BY cscart_multi_decsettings_objects.position
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT object_id FROM cscart_multi_decsettings_objects LEFT JOIN cscart_multi_decsettings_sections ON cscart_multi_decsettings_objects.section_id = cscart_multi_decsettings_sections.section_id WHERE cscart_multi_decsettings_objects.name = 'element_color' AND cscart_multi_decsettings_sections.name = 'vendor_panel_configurator'
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT cscart_multi_decsettings_objects.object_id as object_id, cscart_multi_decsettings_objects.type as object_type, cscart_multi_decsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_multi_decsettings_objects.value END) AS value FROM cscart_multi_decsettings_objects LEFT JOIN cscart_multi_decsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_multi_decsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1 AND (FIND_IN_SET('STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_multi_decsettings_objects.edition_type)) AND cscart_multi_decsettings_objects.object_id = 5963 ORDER BY cscart_multi_decsettings_objects.position
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT object_id FROM cscart_multi_decsettings_objects LEFT JOIN cscart_multi_decsettings_sections ON cscart_multi_decsettings_objects.section_id = cscart_multi_decsettings_sections.section_id WHERE cscart_multi_decsettings_objects.name = 'sidebar_background_image' AND cscart_multi_decsettings_sections.name = 'vendor_panel_configurator'
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT cscart_multi_decsettings_objects.object_id as object_id, cscart_multi_decsettings_objects.type as object_type, cscart_multi_decsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_multi_decsettings_objects.value END) AS value FROM cscart_multi_decsettings_objects LEFT JOIN cscart_multi_decsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_multi_decsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1 AND (FIND_IN_SET('STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_multi_decsettings_objects.edition_type)) AND cscart_multi_decsettings_objects.object_id = 5964 ORDER BY cscart_multi_decsettings_objects.position
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.image_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'vendor_panel' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '0' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id;SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.detailed_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'vendor_panel' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '0' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id
|
1 |
0.00035 |
0.00035 |
0.00035 |
SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.image_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'vendor_panel' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '1' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id;SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.detailed_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'vendor_panel' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '1' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id
|
1 |
0.00029 |
0.00029 |
0.00029 |
SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.image_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'vendor_panel' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '2' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id;SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.detailed_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'vendor_panel' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '2' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id
|
1 |
0.00026 |
0.00026 |
0.00026 |
SELECT * FROM cscart_multi_decbm_layouts WHERE 1 AND storefront_id = 1 AND layout_id = 1
|
1 |
0.00021 |
0.00021 |
0.00021 |
SELECT * FROM cscart_multi_decbm_locations as l LEFT JOIN cscart_multi_decbm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 1 AND l.dispatch IN ('index.index') ORDER BY l.object_ids desc LIMIT 1
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT data FROM cscart_multi_decstorage_data WHERE data_key = 'cache_id'
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT privilege FROM cscart_multi_decusergroup_privileges WHERE usergroup_id IN (0, 1)
|
1 |
0.00030 |
0.00030 |
0.00030 |
SELECT c.* FROM cscart_multi_decbm_containers as c WHERE 1 AND c.location_id = 2 AND c.company_id = 0
|
1 |
0.00049 |
0.00049 |
0.00049 |
SELECT layout_id FROM cscart_multi_decbm_locations WHERE location_id = 2
|
1 |
0.00011 |
0.00011 |
0.00011 |
SELECT c.*, IF (c.location_id != 2, 0, 1) as `default` FROM cscart_multi_decbm_containers as c INNER JOIN cscart_multi_decbm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 1 WHERE 1 AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0
|
1 |
0.00021 |
0.00021 |
0.00021 |
SELECT * FROM cscart_multi_decbm_containers as c LEFT JOIN cscart_multi_decbm_grids as g ON g.container_id = c.container_id WHERE 1 AND g.container_id IN (1, 2, 7, 4) ORDER BY g.order, g.parent_id, g.grid_id ASC
|
1 |
0.00045 |
0.00045 |
0.00045 |
SELECT cscart_multi_decbm_snapping.grid_id as grid_id,cscart_multi_decbm_snapping.block_id as block_id,IFNULL(dynamic_object_content.content, default_content.content) as content,IFNULL(dynamic_object_content.object_id, default_content.object_id) AS object_id,IFNULL(dynamic_object_content.object_type, default_content.object_type) AS object_type,cscart_multi_decbm_block_statuses.object_ids as object_ids,cscart_multi_decbm_snapping.*,cscart_multi_decbm_blocks.*,cscart_multi_decbm_blocks_descriptions.* FROM cscart_multi_decbm_snapping LEFT JOIN cscart_multi_decbm_blocks ON cscart_multi_decbm_blocks.block_id = cscart_multi_decbm_snapping.block_id LEFT JOIN cscart_multi_decbm_block_statuses ON cscart_multi_decbm_snapping.snapping_id = cscart_multi_decbm_block_statuses.snapping_id AND cscart_multi_decbm_block_statuses.object_type LIKE '' LEFT JOIN cscart_multi_decbm_blocks_descriptions ON cscart_multi_decbm_blocks.block_id = cscart_multi_decbm_blocks_descriptions.block_id LEFT JOIN cscart_multi_decbm_blocks_content AS default_content ON cscart_multi_decbm_blocks.block_id = default_content.block_id AND cscart_multi_decbm_blocks_descriptions.lang_code = default_content.lang_code AND default_content.snapping_id = 0 AND default_content.object_id = 0 AND default_content.object_type like '' LEFT JOIN cscart_multi_decbm_blocks_content AS dynamic_object_content ON cscart_multi_decbm_blocks.block_id = dynamic_object_content.block_id AND cscart_multi_decbm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 0 AND dynamic_object_content.object_type like '' WHERE cscart_multi_decbm_snapping.grid_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 12, 15, 20, 13, 14, 16, 17, 18, 19, 21, 22, 23, 24, 25, 26, 27, 28) AND cscart_multi_decbm_blocks_descriptions.lang_code='en' ORDER BY cscart_multi_decbm_snapping.order, cscart_multi_decbm_snapping.block_id
|
1 |
0.00173 |
0.00173 |
0.00173 |
SELECT name, path FROM cscart_multi_decseo_names WHERE `object_id` = 15 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en'
|
1 |
0.00045 |
0.00045 |
0.00045 |
SELECT name, path FROM cscart_multi_decseo_names WHERE `object_id` = 20 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en'
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT data FROM cscart_multi_decstorage_data WHERE data_key = 'restrictions'
|
1 |
0.00032 |
0.00032 |
0.00032 |