Queries
max count: 2
| Query |
Count |
Min time |
Max time |
Average time |
SELECT * FROM cscart_aprilhybrid_auth_providers WHERE 1 AND status = 'A' ORDER BY position
|
2 |
0.00059 |
0.01375 |
0.00717 |
SELECT data FROM cscart_aprilstorage_data WHERE data_key = 'store_mode'
|
1 |
0.00092 |
0.00092 |
0.00092 |
SELECT storefronts.* FROM cscart_aprilstorefronts 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.00035 |
0.00035 |
0.00035 |
SET time_zone = '+05:30'
|
1 |
0.00628 |
0.00628 |
0.00628 |
SELECT type FROM cscart_aprilseo_names WHERE name = 'sitemap'
|
1 |
0.00062 |
0.00062 |
0.00062 |
SELECT * FROM cscart_aprilseo_names WHERE name = 'sitemap'
|
1 |
0.00145 |
0.00145 |
0.00145 |
SELECT cscart_aprillanguages.lang_code, cscart_aprillanguages.name FROM cscart_aprillanguages WHERE 1 AND cscart_aprillanguages.status = 'A'
|
1 |
0.00074 |
0.00074 |
0.00074 |
SELECT storefronts.* FROM cscart_aprilstorefronts AS storefronts WHERE 1 = 1 AND storefronts.is_default IN ('Y') GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc
|
1 |
0.00059 |
0.00059 |
0.00059 |
SELECT redirect_id, src, type, object_id, dest, lang_code FROM cscart_aprilseo_redirects WHERE src = '/sitemap'
|
1 |
0.00037 |
0.00037 |
0.00037 |
SELECT cscart_aprilbm_layouts.* FROM cscart_aprilbm_layouts WHERE 1 AND is_default = 1 AND theme_name = 'nova_theme' AND storefront_id = 1
|
1 |
0.00056 |
0.00056 |
0.00056 |
SELECT data FROM cscart_aprilstorage_data WHERE data_key = 'cart_products_next_check'
|
1 |
0.00099 |
0.00099 |
0.00099 |
SELECT data FROM cscart_aprilstorage_data WHERE data_key = 'dev_mode'
|
1 |
0.00042 |
0.00042 |
0.00042 |
SELECT COUNT(DISTINCT storefronts.storefront_id) FROM cscart_aprilstorefronts AS storefronts WHERE 1 = 1
|
1 |
0.00057 |
0.00057 |
0.00057 |
SELECT cscart_aprilsettings_sections.name, cscart_aprilsettings_sections.section_id, cscart_aprilsettings_sections.position, cscart_aprilsettings_sections.type , cscart_aprilsettings_sections.name as description, CONCAT('settings.manage?section_id=', cscart_aprilsettings_sections.name) as href FROM cscart_aprilsettings_sections WHERE 1 AND (FIND_IN_SET('STOREFRONT', cscart_aprilsettings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_aprilsettings_sections.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_aprilsettings_sections.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_aprilsettings_sections.edition_type)) ORDER BY cscart_aprilsettings_sections.position
|
1 |
0.00681 |
0.00681 |
0.00681 |
SELECT object_id FROM cscart_aprilsettings_objects LEFT JOIN cscart_aprilsettings_sections ON cscart_aprilsettings_objects.section_id = cscart_aprilsettings_sections.section_id WHERE cscart_aprilsettings_objects.name = 'color_schema' AND cscart_aprilsettings_sections.name = 'vendor_panel_configurator'
|
1 |
0.00076 |
0.00076 |
0.00076 |
SELECT cscart_aprilsettings_objects.object_id as object_id, cscart_aprilsettings_objects.type as object_type, cscart_aprilsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_aprilsettings_objects.value END) AS value FROM cscart_aprilsettings_objects LEFT JOIN cscart_aprilsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_aprilsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1 AND (FIND_IN_SET('STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_aprilsettings_objects.edition_type)) AND cscart_aprilsettings_objects.object_id = 5963 ORDER BY cscart_aprilsettings_objects.position
|
1 |
0.00047 |
0.00047 |
0.00047 |
SELECT object_id FROM cscart_aprilsettings_objects LEFT JOIN cscart_aprilsettings_sections ON cscart_aprilsettings_objects.section_id = cscart_aprilsettings_sections.section_id WHERE cscart_aprilsettings_objects.name = 'sidebar_color' AND cscart_aprilsettings_sections.name = 'vendor_panel_configurator'
|
1 |
0.00050 |
0.00050 |
0.00050 |
SELECT cscart_aprilsettings_objects.object_id as object_id, cscart_aprilsettings_objects.type as object_type, cscart_aprilsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_aprilsettings_objects.value END) AS value FROM cscart_aprilsettings_objects LEFT JOIN cscart_aprilsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_aprilsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1 AND (FIND_IN_SET('STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_aprilsettings_objects.edition_type)) AND cscart_aprilsettings_objects.object_id = 5964 ORDER BY cscart_aprilsettings_objects.position
|
1 |
0.00029 |
0.00029 |
0.00029 |
SELECT object_id FROM cscart_aprilsettings_objects LEFT JOIN cscart_aprilsettings_sections ON cscart_aprilsettings_objects.section_id = cscart_aprilsettings_sections.section_id WHERE cscart_aprilsettings_objects.name = 'element_color' AND cscart_aprilsettings_sections.name = 'vendor_panel_configurator'
|
1 |
0.00026 |
0.00026 |
0.00026 |
SELECT cscart_aprilsettings_objects.object_id as object_id, cscart_aprilsettings_objects.type as object_type, cscart_aprilsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_aprilsettings_objects.value END) AS value FROM cscart_aprilsettings_objects LEFT JOIN cscart_aprilsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_aprilsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1 AND (FIND_IN_SET('STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_aprilsettings_objects.edition_type)) AND cscart_aprilsettings_objects.object_id = 5965 ORDER BY cscart_aprilsettings_objects.position
|
1 |
0.00022 |
0.00022 |
0.00022 |
SELECT object_id FROM cscart_aprilsettings_objects LEFT JOIN cscart_aprilsettings_sections ON cscart_aprilsettings_objects.section_id = cscart_aprilsettings_sections.section_id WHERE cscart_aprilsettings_objects.name = 'sidebar_background_image' AND cscart_aprilsettings_sections.name = 'vendor_panel_configurator'
|
1 |
0.00020 |
0.00020 |
0.00020 |
SELECT cscart_aprilsettings_objects.object_id as object_id, cscart_aprilsettings_objects.type as object_type, cscart_aprilsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_aprilsettings_objects.value END) AS value FROM cscart_aprilsettings_objects LEFT JOIN cscart_aprilsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_aprilsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1 AND (FIND_IN_SET('STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_aprilsettings_objects.edition_type)) AND cscart_aprilsettings_objects.object_id = 5966 ORDER BY cscart_aprilsettings_objects.position
|
1 |
0.00027 |
0.00027 |
0.00027 |
SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.image_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'vendor_panel' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '0' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id;SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.detailed_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'vendor_panel' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '0' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id
|
1 |
0.00044 |
0.00044 |
0.00044 |
SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.image_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'vendor_panel' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '1' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id;SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.detailed_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'vendor_panel' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '1' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id
|
1 |
0.00036 |
0.00036 |
0.00036 |
SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.image_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'vendor_panel' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '2' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id;SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.detailed_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'vendor_panel' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '2' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id
|
1 |
0.00029 |
0.00029 |
0.00029 |
SELECT * FROM cscart_aprilbm_layouts WHERE 1 AND storefront_id = 1 AND layout_id = 1
|
1 |
0.00057 |
0.00057 |
0.00057 |
SELECT * FROM cscart_aprilbm_locations as l LEFT JOIN cscart_aprilbm_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 ('sitemap.view') ORDER BY l.object_ids desc LIMIT 1
|
1 |
0.00029 |
0.00029 |
0.00029 |
SELECT * FROM cscart_aprilbm_locations as l LEFT JOIN cscart_aprilbm_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 ('sitemap') ORDER BY l.object_ids desc LIMIT 1
|
1 |
0.00019 |
0.00019 |
0.00019 |
SELECT * FROM cscart_aprilbm_locations as l LEFT JOIN cscart_aprilbm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 1 AND l.is_default = 1 ORDER BY l.is_default desc
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT data FROM cscart_aprilstorage_data WHERE data_key = 'cache_id'
|
1 |
0.00036 |
0.00036 |
0.00036 |
SELECT * FROM cscart_aprilsettings_sections WHERE name = 'pwa' AND type = 'ADDON' AND (FIND_IN_SET('STOREFRONT', cscart_aprilsettings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_aprilsettings_sections.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_aprilsettings_sections.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_aprilsettings_sections.edition_type))
|
1 |
0.00027 |
0.00027 |
0.00027 |
SELECT cscart_aprilsettings_objects.object_id as object_id, name, section_id, section_tab_id, type, position, is_global, cscart_aprilsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_aprilsettings_objects.value END) AS value FROM cscart_aprilsettings_objects LEFT JOIN cscart_aprilsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_aprilsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1 AND section_id = 19 AND (FIND_IN_SET('STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_aprilsettings_objects.edition_type)) AND cscart_aprilsettings_objects.type <> 'H' ORDER BY cscart_aprilsettings_objects.position
|
1 |
0.00040 |
0.00040 |
0.00040 |
SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.detailed_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'manifest_icon' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '1' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id
|
1 |
0.00091 |
0.00091 |
0.00091 |
SELECT * FROM cscart_aprilsettings_sections WHERE name = 'Sitemap' AND type = 'CORE' AND (FIND_IN_SET('STOREFRONT', cscart_aprilsettings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_aprilsettings_sections.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_aprilsettings_sections.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_aprilsettings_sections.edition_type))
|
1 |
0.00043 |
0.00043 |
0.00043 |
SELECT cscart_aprilsettings_objects.object_id as object_id, name, section_id, section_tab_id, type, position, is_global, cscart_aprilsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_aprilsettings_objects.value END) AS value FROM cscart_aprilsettings_objects LEFT JOIN cscart_aprilsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_aprilsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1 AND section_id = 8 AND (FIND_IN_SET('STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_aprilsettings_objects.edition_type)) AND cscart_aprilsettings_objects.type <> 'H' ORDER BY cscart_aprilsettings_objects.position
|
1 |
0.00057 |
0.00057 |
0.00057 |
SELECT category_id FROM cscart_aprilcategories WHERE category_type = 'D'
|
1 |
0.00035 |
0.00035 |
0.00035 |
SELECT cscart_aprilcategories.category_id,cscart_aprilcategories.parent_id,cscart_aprilcategories.id_path,cscart_aprilcategory_descriptions.category,cscart_aprilcategories.position,cscart_aprilcategories.status,cscart_aprilcategories.company_id,cscart_aprilcategories.storefront_id,cscart_aprilseo_names.name as seo_name,cscart_aprilseo_names.path as seo_path FROM cscart_aprilcategories LEFT JOIN cscart_aprilcategory_descriptions ON cscart_aprilcategories.category_id = cscart_aprilcategory_descriptions.category_id AND cscart_aprilcategory_descriptions.lang_code = 'en' LEFT JOIN cscart_aprilseo_names ON cscart_aprilseo_names.object_id = cscart_aprilcategories.category_id AND cscart_aprilseo_names.type = 'c' AND cscart_aprilseo_names.dispatch = '' AND cscart_aprilseo_names.lang_code = 'en' WHERE 1=1 AND (cscart_aprilcategories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_aprilcategories.usergroup_ids) OR FIND_IN_SET(1, cscart_aprilcategories.usergroup_ids)) AND cscart_aprilcategories.status IN ('A') AND cscart_aprilcategories.category_id != 264 AND cscart_aprilcategories.parent_id != 264 AND cscart_aprilcategories.storefront_id IN (0, 1) ORDER BY cscart_aprilcategories.is_trash asc, cscart_aprilcategories.position asc, cscart_aprilcategory_descriptions.category asc
|
1 |
0.00273 |
0.00273 |
0.00273 |
SELECT category_id, parent_id FROM cscart_aprilcategories WHERE parent_id IN(235, 216, 204, 242, 229, 222, 251, 210, 168, 198, 166, 212, 176, 178, 190, 224, 255, 246, 167, 182, 175, 230, 220, 252, 197, 211, 213, 236, 185, 169, 243, 191, 247, 209, 217, 203, 225, 193, 223, 199, 215, 221, 214, 231, 240, 208, 179, 249, 253, 226, 186, 218, 174, 244, 219, 234, 194, 200, 180, 238, 232, 202, 227, 248, 187, 181, 195, 177, 228, 237, 196, 188, 241, 254, 189, 245, 250, 165, 170, 171, 172, 201, 263) AND category_id != 264
|
1 |
0.00091 |
0.00091 |
0.00091 |
SELECT company_id FROM cscart_aprilstorefronts_companies WHERE storefront_id = 1
|
1 |
0.00041 |
0.00041 |
0.00041 |
SELECT cscart_aprilpages.*, cscart_aprilpage_descriptions.page, cscart_aprilseo_names.name as seo_name, cscart_aprilseo_names.path as seo_path FROM cscart_aprilpages LEFT JOIN cscart_aprilpage_descriptions ON cscart_aprilpages.page_id = cscart_aprilpage_descriptions.page_id AND cscart_aprilpage_descriptions.lang_code = 'en' LEFT JOIN cscart_aprilseo_names ON cscart_aprilseo_names.object_id = cscart_aprilpages.page_id AND cscart_aprilseo_names.type = 'a' AND cscart_aprilseo_names.dispatch = '' AND cscart_aprilseo_names.lang_code = 'en' WHERE 1 AND cscart_aprilpages.status IN ('A') AND cscart_aprilpages.page_type IN ('T', 'B', 'F') AND (cscart_aprilpages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_aprilpages.usergroup_ids) OR FIND_IN_SET(1, cscart_aprilpages.usergroup_ids)) AND (cscart_aprilpages.use_avail_period = 'N' OR (cscart_aprilpages.use_avail_period = 'Y' AND cscart_aprilpages.avail_from_timestamp <= 1777123741 AND (cscart_aprilpages.avail_till_timestamp >= 1777123741 OR cscart_aprilpages.avail_till_timestamp = 0))) ORDER BY cscart_aprilpages.position asc, cscart_aprilpages.parent_id asc, cscart_aprilpage_descriptions.page asc
|
1 |
0.00124 |
0.00124 |
0.00124 |
SELECT CONCAT(u.firstname, ' ', u.lastname) as author, b.page_id FROM cscart_aprilblog_authors as b LEFT JOIN cscart_aprilusers as u ON b.user_id = u.user_id WHERE b.page_id IN (7, 8, 10, 9)
|
1 |
0.00056 |
0.00056 |
0.00056 |
SELECT s.*, cscart_aprilcommon_descriptions.object as section FROM cscart_aprilsitemap_sections AS s LEFT JOIN cscart_aprilcommon_descriptions ON s.section_id = cscart_aprilcommon_descriptions.object_id AND cscart_aprilcommon_descriptions.object_holder = "sitemap_sections" AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE status = 'A' ORDER BY s.position
|
1 |
0.00065 |
0.00065 |
0.00065 |
SELECT link_id, link_href, section_id, status, position, link_type, description, object as link FROM cscart_aprilsitemap_links LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilsitemap_links.link_id AND cscart_aprilcommon_descriptions.object_holder = 'sitemap_links' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE section_id = 2 ORDER BY position, link
|
1 |
0.00078 |
0.00078 |
0.00078 |
SELECT privilege FROM cscart_aprilusergroup_privileges WHERE usergroup_id IN (0, 1)
|
1 |
0.00039 |
0.00039 |
0.00039 |
SELECT c.* FROM cscart_aprilbm_containers as c WHERE 1 AND c.location_id = 1 AND c.company_id = 0
|
1 |
0.00098 |
0.00098 |
0.00098 |
SELECT layout_id FROM cscart_aprilbm_locations WHERE location_id = 1
|
1 |
0.00028 |
0.00028 |
0.00028 |
SELECT c.*, IF (c.location_id != 1, 0, 1) as `default` FROM cscart_aprilbm_containers as c INNER JOIN cscart_aprilbm_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.00107 |
0.00107 |
0.00107 |
SELECT * FROM cscart_aprilbm_containers as c LEFT JOIN cscart_aprilbm_grids as g ON g.container_id = c.container_id WHERE 1 AND g.container_id IN (1, 2, 3, 4) ORDER BY g.order, g.parent_id, g.grid_id ASC
|
1 |
0.00224 |
0.00224 |
0.00224 |
SELECT cscart_aprilbm_snapping.grid_id as grid_id,cscart_aprilbm_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_aprilbm_block_statuses.object_ids as object_ids,cscart_aprilbm_snapping.*,cscart_aprilbm_blocks.*,cscart_aprilbm_blocks_descriptions.* FROM cscart_aprilbm_snapping LEFT JOIN cscart_aprilbm_blocks ON cscart_aprilbm_blocks.block_id = cscart_aprilbm_snapping.block_id LEFT JOIN cscart_aprilbm_block_statuses ON cscart_aprilbm_snapping.snapping_id = cscart_aprilbm_block_statuses.snapping_id AND cscart_aprilbm_block_statuses.object_type LIKE '' LEFT JOIN cscart_aprilbm_blocks_descriptions ON cscart_aprilbm_blocks.block_id = cscart_aprilbm_blocks_descriptions.block_id LEFT JOIN cscart_aprilbm_blocks_content AS default_content ON cscart_aprilbm_blocks.block_id = default_content.block_id AND cscart_aprilbm_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_aprilbm_blocks_content AS dynamic_object_content ON cscart_aprilbm_blocks.block_id = dynamic_object_content.block_id AND cscart_aprilbm_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_aprilbm_snapping.grid_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 15, 20, 13, 14, 16, 17, 18, 19, 21, 22) AND cscart_aprilbm_blocks_descriptions.lang_code='en' ORDER BY cscart_aprilbm_snapping.order, cscart_aprilbm_snapping.block_id
|
1 |
0.00188 |
0.00188 |
0.00188 |
SELECT data FROM cscart_aprilstorage_data WHERE data_key = 'restrictions'
|
1 |
0.00043 |
0.00043 |
0.00043 |