Queries
max count: 11
Query |
Count |
Min time |
Max time |
Average time |
SELECT FOUND_ROWS()
|
11 |
0.00009 |
0.00011 |
0.00010 |
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 125
|
11 |
0.00019 |
0.00043 |
0.00028 |
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 = 'theme_name'
|
5 |
0.00023 |
0.00032 |
0.00027 |
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 2 WHERE 1 AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 75 ORDER BY cscart_settings_objects.position
|
5 |
0.00023 |
0.00026 |
0.00025 |
SELECT * FROM cscart_bm_layouts WHERE 1 AND cscart_bm_layouts.company_id = 2 AND is_default = 1 AND theme_name = 'responsive'
|
4 |
0.00019 |
0.00023 |
0.00021 |
SELECT * FROM cscart_logos WHERE IF(layout_id = 0, 1, IF(layout_id = 10, 1, 0)) AND IF(style_id = '', 1, IF(style_id = 'Byggbay', 1, 0)) AND company_id = 2
|
4 |
0.00020 |
0.00023 |
0.00021 |
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, 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 = 'se' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (78, 76, 79, 80) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
4 |
0.00048 |
0.00054 |
0.00051 |
SELECT id, placeholder, type, no_pagination FROM cscart_image_gallery_settings WHERE placeholder <> ''
|
4 |
0.00216 |
0.06614 |
0.01817 |
SELECT gallery_id, placeholder, no_pagination FROM cscart_image_gallery_ext_settings WHERE placeholder <> '' AND status='A'
|
4 |
0.00014 |
0.00040 |
0.00025 |
SELECT cscart_languages.* FROM cscart_languages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_languages.lang_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A'
|
3 |
0.00024 |
0.00041 |
0.00031 |
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, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 2 WHERE 1 AND section_id = '317' AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.type <> 'H' ORDER BY cscart_settings_objects.position
|
3 |
0.00085 |
0.00090 |
0.00087 |
SELECT * FROM cscart_settings_sections WHERE name = 'social_buttons' AND type = 'ADDON' AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_sections.edition_type))
|
3 |
0.00028 |
0.00050 |
0.00037 |
SELECT cscart_sd_labels_custom.*, cscart_sd_labels_custom_descriptions.* FROM cscart_sd_labels_custom LEFT JOIN cscart_sd_labels_custom_descriptions ON cscart_sd_labels_custom_descriptions.label_code = cscart_sd_labels_custom.label_code AND cscart_sd_labels_custom_descriptions.lang_code = 'se' WHERE 1 AND cscart_sd_labels_custom.used = 'Y' ORDER BY cscart_sd_labels_custom_descriptions.name asc
|
2 |
0.00031 |
0.00038 |
0.00035 |
SELECT * FROM cscart_bm_layouts WHERE 1 AND cscart_bm_layouts.company_id = 2 AND layout_id = 10
|
2 |
0.00018 |
0.00024 |
0.00021 |
SELECT page_type FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 125
|
2 |
0.00029 |
0.00033 |
0.00031 |
SELECT COUNT(*) FROM cscart_access_restriction WHERE type='d' AND status = 'A'
|
2 |
0.00012 |
0.00012 |
0.00012 |
SELECT a.item_id, b.reason FROM cscart_access_restriction as a LEFT JOIN cscart_access_restriction_reason_descriptions as b ON a.item_id = b.item_id AND a.type = b.type AND lang_code = 'se' WHERE ip_from <= 3628718252 AND ip_to >= 3628718252 AND a.type IN ('ips', 'ipr', 'ipb') AND status = 'A'
|
2 |
0.00018 |
0.00019 |
0.00018 |
DELETE FROM cscart_access_restriction WHERE (type = 'ipb' OR type = 'aab') AND expires < 1751344653
|
2 |
0.00012 |
0.00013 |
0.00012 |
SELECT * FROM cscart_access_restriction_block WHERE ip >= 3628718252
|
2 |
0.00011 |
0.00013 |
0.00012 |
SELECT * FROM cscart_image_gallery_settings WHERE id=125 AND type='C'
|
2 |
0.00021 |
0.00022 |
0.00021 |
DELETE FROM cscart_access_restriction_block WHERE expires < 1751344653
|
2 |
0.00011 |
0.00013 |
0.00012 |
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 70
|
2 |
0.00023 |
0.00029 |
0.00026 |
SELECT thread_id, type, object_type, object_id FROM cscart_discussion WHERE thread_id = 9459 AND cscart_discussion.company_id = 2
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'se' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id AND cscart_seo_names.type = 'a' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'se' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE 1 AND cscart_pages.parent_id IN (125) AND cscart_pages.status IN ('A') AND cscart_pages.page_type IN ('B') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (use_avail_period = 'N' OR (use_avail_period = 'Y' AND avail_from_timestamp <= 1751344653 AND avail_till_timestamp >= 1751344653)) ORDER BY cscart_pages.timestamp desc LIMIT 0, 10
|
1 |
0.00053 |
0.00053 |
0.00053 |
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 67
|
1 |
0.00025 |
0.00025 |
0.00025 |
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 433
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT c.* FROM cscart_bm_containers as c WHERE 1 AND c.location_id = 433
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cache_id'
|
1 |
0.00026 |
0.00026 |
0.00026 |
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN(0, 1)
|
1 |
0.00026 |
0.00026 |
0.00026 |
SELECT value FROM cscart_form_options WHERE element_type = 'U' AND page_id = 125
|
1 |
0.00020 |
0.00020 |
0.00020 |
SELECT COUNT(DISTINCT(cscart_pages.page_id)) FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'se' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id AND cscart_seo_names.type = 'a' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'se' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE 1 AND cscart_pages.parent_id IN (125) AND cscart_pages.status IN ('A') AND cscart_pages.page_type IN ('B') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (use_avail_period = 'N' OR (use_avail_period = 'Y' AND avail_from_timestamp <= 1751344653 AND avail_till_timestamp >= 1751344653)) ORDER BY cscart_pages.timestamp desc
|
1 |
0.00047 |
0.00047 |
0.00047 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 69 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'se'
|
1 |
0.00027 |
0.00027 |
0.00027 |
SELECT company_id FROM cscart_companies WHERE status = 'A' ORDER BY company_id LIMIT 1
|
1 |
0.00030 |
0.00030 |
0.00030 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 67 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'se'
|
1 |
0.00027 |
0.00027 |
0.00027 |
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 68
|
1 |
0.00021 |
0.00021 |
0.00021 |
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id AND cscart_seo_names.type = 'a' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'se' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE cscart_pages.page_id = 55 AND cscart_page_descriptions.lang_code = 'se' AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND cscart_pages.page_type IN ('T', 'L', 'B', 'F')
|
1 |
0.00039 |
0.00039 |
0.00039 |
SELECT company FROM cscart_companies WHERE company_id = 1
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 68 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'se'
|
1 |
0.00027 |
0.00027 |
0.00027 |
SELECT c.*, IF (c.location_id != 433, 0, 1) as `default` FROM cscart_bm_containers as c INNER JOIN cscart_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 10 WHERE 1 AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER')
|
1 |
0.00196 |
0.00196 |
0.00196 |
SELECT * FROM cscart_bm_containers as c LEFT JOIN cscart_bm_grids as g ON g.container_id = c.container_id WHERE 1 AND g.container_id IN (1530, 1531, 1580, 1533) ORDER BY g.order, g.parent_id, g.grid_id ASC
|
1 |
0.00052 |
0.00052 |
0.00052 |
SELECT thread_id, type, object_type FROM cscart_discussion WHERE 1 AND object_id = 125 AND object_type = 'A' AND cscart_discussion.company_id = 2
|
1 |
0.00027 |
0.00027 |
0.00027 |
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, 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 = 'se' WHERE cscart_images_links.object_type = 'pages_gallery' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 125 ORDER BY cscart_images_links.position DESC, cscart_images_links.pair_id
|
1 |
0.00033 |
0.00033 |
0.00033 |
SELECT * FROM cscart_hybrid_auth_providers WHERE 1 AND company_id = 2 AND status = 'A' ORDER BY `position`;
|
1 |
0.00031 |
0.00031 |
0.00031 |
SELECT COUNT(*) FROM cscart_discussion_posts LEFT JOIN cscart_discussion_messages ON cscart_discussion_messages.post_id = cscart_discussion_posts.post_id WHERE cscart_discussion_posts.thread_id = 9459 AND cscart_discussion_messages.message <> '' AND cscart_discussion_posts.status = 'A'
|
1 |
0.00025 |
0.00025 |
0.00025 |
SELECT cscart_discussion_posts.* , cscart_discussion_messages.message FROM cscart_discussion_posts LEFT JOIN cscart_discussion_messages ON cscart_discussion_messages.post_id = cscart_discussion_posts.post_id WHERE cscart_discussion_posts.thread_id = 9459 AND cscart_discussion_messages.message <> '' AND cscart_discussion_posts.status = 'A' ORDER BY cscart_discussion_posts.timestamp DESC LIMIT 0, 10
|
1 |
0.00026 |
0.00026 |
0.00026 |
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 46
|
1 |
0.00030 |
0.00030 |
0.00030 |
SELECT a.*, b.description FROM cscart_currencies as a LEFT JOIN cscart_currency_descriptions as b ON a.currency_code = b.currency_code AND lang_code = 'se' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = a.currency_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'currencies') WHERE 1 AND status IN ('A') ORDER BY a.position
|
1 |
0.00042 |
0.00042 |
0.00042 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 46 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'se'
|
1 |
0.00025 |
0.00025 |
0.00025 |
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 45
|
1 |
0.00020 |
0.00020 |
0.00020 |
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 69
|
1 |
0.00021 |
0.00021 |
0.00021 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 45 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'se'
|
1 |
0.00030 |
0.00030 |
0.00030 |
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 30
|
1 |
0.00019 |
0.00019 |
0.00019 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 125 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en'
|
1 |
0.00029 |
0.00029 |
0.00029 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 30 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'se'
|
1 |
0.00026 |
0.00026 |
0.00026 |
SELECT COUNT(*) FROM cscart_pages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 2
|
1 |
0.00027 |
0.00027 |
0.00027 |
SELECT cscart_bm_snapping.grid_id as grid_id,cscart_bm_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_bm_block_statuses.object_ids as object_ids,cscart_bm_snapping.*,cscart_bm_blocks.*,cscart_bm_blocks_descriptions.* FROM cscart_bm_snapping LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_bm_snapping.block_id LEFT JOIN cscart_bm_block_statuses ON cscart_bm_snapping.snapping_id = cscart_bm_block_statuses.snapping_id AND cscart_bm_block_statuses.object_type LIKE 'pages' LEFT JOIN cscart_bm_blocks_descriptions ON cscart_bm_blocks.block_id = cscart_bm_blocks_descriptions.block_id LEFT JOIN cscart_bm_blocks_content AS default_content ON cscart_bm_blocks.block_id = default_content.block_id AND cscart_bm_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_bm_blocks_content AS dynamic_object_content ON cscart_bm_blocks.block_id = dynamic_object_content.block_id AND cscart_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 125 AND dynamic_object_content.object_type like 'pages' WHERE cscart_bm_snapping.grid_id IN (1958, 1959, 1960, 1961, 1962, 2010, 2011, 2045, 2050, 1964, 2052, 1965, 2051, 2210, 1945, 1947, 1956, 1950, 1948, 1952, 1957, 1955, 1949, 1953, 1946, 1954, 2207) AND cscart_bm_blocks_descriptions.lang_code='se' AND cscart_bm_blocks.company_id = 2 ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id
|
1 |
0.00211 |
0.00211 |
0.00211 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 2 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'se'
|
1 |
0.00027 |
0.00027 |
0.00027 |
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'store_mode'
|
1 |
0.00028 |
0.00028 |
0.00028 |
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'se' AND lang.name = 'filter_description_label10'
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT SQL_CALC_FOUND_ROWS cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, 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 = 'se' WHERE cscart_images_links.object_type = 'pages_gallery' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = 125 ORDER BY cscart_images_links.position DESC, cscart_images_links.pair_id DESC LIMIT 0, 12
|
1 |
0.00031 |
0.00031 |
0.00031 |
SELECT entry_page FROM cscart_companies WHERE company_id = 2 AND redirect_customer != 'Y'
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 125 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'se'
|
1 |
0.00034 |
0.00034 |
0.00034 |
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, IF(cscart_settings_vendor_values.value IS NULL, cscart_settings_objects.value, cscart_settings_vendor_values.value) as value FROM cscart_settings_objects LEFT JOIN cscart_settings_vendor_values ON cscart_settings_vendor_values.object_id = cscart_settings_objects.object_id AND company_id = 2 WHERE 1 AND section_id = '287' AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.type <> 'H' ORDER BY cscart_settings_objects.position
|
1 |
0.00038 |
0.00038 |
0.00038 |
SELECT * FROM cscart_settings_sections WHERE name = 'seo' AND type = 'ADDON' AND (FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_sections.edition_type))
|
1 |
0.00025 |
0.00025 |
0.00025 |
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_languages.lang_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A'
|
1 |
0.00026 |
0.00026 |
0.00026 |
SELECT * FROM cscart_seo_names WHERE name = 'groese-des-dachfensters-se' AND lang_code = 'se'
|
1 |
0.00040 |
0.00040 |
0.00040 |
SELECT type FROM cscart_seo_names WHERE name = 'groese-des-dachfensters-se' AND ( cscart_seo_names.company_id = 2 OR cscart_seo_names.company_id = 0)
|
1 |
0.00055 |
0.00055 |
0.00055 |
SET time_zone = '+02:00'
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT company_id FROM cscart_companies WHERE 1 AND status IN ('A', 'P', 'N')
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT a.*, b.description FROM cscart_currencies as a LEFT JOIN cscart_currency_descriptions as b ON a.currency_code = b.currency_code AND lang_code = 'se' WHERE 1 AND a.is_primary = 'Y' ORDER BY a.position
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT company_id FROM cscart_companies WHERE 1 AND company_id IN (2) AND status IN ('A', 'P', 'N')
|
1 |
0.00022 |
0.00022 |
0.00022 |
SELECT company_id, storefront, secure_storefront, redirect_customer FROM cscart_companies WHERE company_id = 2
|
1 |
0.00022 |
0.00022 |
0.00022 |
SELECT company_id, secure_storefront FROM cscart_companies WHERE secure_storefront RLIKE '^(www[0-9]*.)?byggbay.se'
|
1 |
0.00023 |
0.00023 |
0.00023 |
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, cscart_settings_objects.value AS value FROM cscart_settings_objects WHERE 1 AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 294 ORDER BY cscart_settings_objects.position
|
1 |
0.00020 |
0.00020 |
0.00020 |
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 = 'cdn'
|
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, cscart_settings_objects.value AS value FROM cscart_settings_objects WHERE 1 AND (FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 2725 ORDER BY cscart_settings_objects.position
|
1 |
0.00021 |
0.00021 |
0.00021 |
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 = 'storage'
|
1 |
0.00025 |
0.00025 |
0.00025 |
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('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_sections.edition_type)) ORDER BY cscart_settings_sections.position
|
1 |
0.00062 |
0.00062 |
0.00062 |
SELECT a.*, b.description FROM cscart_currencies as a LEFT JOIN cscart_currency_descriptions as b ON a.currency_code = b.currency_code AND lang_code = 'se' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = a.currency_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'currencies') WHERE 1 AND status IN ('A', 'H') ORDER BY a.position
|
1 |
0.00031 |
0.00031 |
0.00031 |
SELECT companies.* FROM cscart_companies AS companies WHERE companies.company_id = 2
|
1 |
0.00030 |
0.00030 |
0.00030 |
SELECT description FROM cscart_image_gallery_settings_description WHERE id = 125 AND lang_code = 'se' AND type = 'C'
|
1 |
0.00018 |
0.00018 |
0.00018 |
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'se' AND lang.name = 'filter_description_label8'
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT CONCAT(u.firstname, ' ', u.lastname) FROM cscart_blog_authors as b LEFT JOIN cscart_users as u ON b.user_id = u.user_id WHERE b.page_id = 125
|
1 |
0.00033 |
0.00033 |
0.00033 |
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, 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 = 'se' WHERE cscart_images_links.object_type = 'blog' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 125 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00036 |
0.00036 |
0.00036 |
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id AND cscart_seo_names.type = 'a' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'se' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 2 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE cscart_pages.page_id = 125 AND cscart_page_descriptions.lang_code = 'se' AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND cscart_pages.page_type IN ('T', 'L', 'B', 'F')
|
1 |
0.00053 |
0.00053 |
0.00053 |
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, 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 = 'se' WHERE cscart_images_links.object_type = 'jsonld_company_logo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 2 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00034 |
0.00034 |
0.00034 |
SELECT cscart_images_links.*, cscart_images.image_path, cscart_common_descriptions.description AS alt, cscart_images.image_x, cscart_images.image_y, 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 = 'se' WHERE cscart_images_links.object_type = 'jsonld_company_logo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = 2 ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00041 |
0.00041 |
0.00041 |
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'se' AND lang.name = 'filter_description_label6'
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT addon FROM cscart_addons WHERE unmanaged = 1 AND status = 'A' ORDER BY priority
|
1 |
0.00022 |
0.00022 |
0.00022 |
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'se' AND lang.name = 'filter_description_label9'
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'se' AND lang.name = 'filter_description_label4'
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cart_products_next_check'
|
1 |
0.00022 |
0.00022 |
0.00022 |
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'se' AND lang.name = 'filter_description_label1'
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'se' AND lang.name = 'filter_description_label5'
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'se' AND lang.name = 'filter_description_label7'
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'se' AND lang.name = 'filter_description_label3'
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT IF(cscart_ult_language_values.value IS NULL, lang.value, cscart_ult_language_values.value) as value FROM cscart_language_values lang LEFT JOIN cscart_ult_language_values ON cscart_ult_language_values.name = lang.name AND company_id = 2 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'se' AND lang.name = 'filter_description_label2'
|
1 |
0.00023 |
0.00023 |
0.00023 |
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 = 'se' WHERE l.layout_id = 10 AND l.dispatch = 'pages.view?page_type=B' AND (FIND_IN_SET(125, l.object_ids) OR l.object_ids = '') ORDER BY l.object_ids desc LIMIT 1
|
1 |
0.00032 |
0.00032 |
0.00032 |
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'dev_mode'
|
1 |
0.05147 |
0.05147 |
0.05147 |
SELECT cscart_gdpr_tracking_codes.* FROM cscart_gdpr_tracking_codes WHERE cscart_gdpr_tracking_codes.enable = 'Y' ORDER BY position
|
1 |
0.00018 |
0.00018 |
0.00018 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 70 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'se'
|
1 |
0.00034 |
0.00034 |
0.00034 |