Queries
max count: 5
| Query |
Count |
Min time |
Max time |
Average time |
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 = 1 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.00011 |
0.00014 |
0.00012 |
SELECT FOUND_ROWS()
|
5 |
0.00003 |
0.00006 |
0.00004 |
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.00011 |
0.00012 |
0.00012 |
SELECT * FROM cscart_bm_layouts WHERE 1 AND cscart_bm_layouts.company_id = 1 AND is_default = 1 AND theme_name = 'energot'
|
4 |
0.00009 |
0.00010 |
0.00010 |
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 = 'ro' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (7, 25, 24, 23) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
4 |
0.00022 |
0.00031 |
0.00026 |
SELECT * FROM cscart_logos WHERE IF(layout_id = 0, 1, IF(layout_id = 3, 1, 0)) AND IF(style_id = '', 1, IF(style_id = 'mnm', 1, 0)) AND company_id = 1
|
4 |
0.00013 |
0.00015 |
0.00014 |
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 55
|
4 |
0.00012 |
0.00028 |
0.00019 |
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.00022 |
0.00025 |
0.00023 |
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 = 1 WHERE 1 AND section_id = '20' 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.00027 |
0.00030 |
0.00028 |
SELECT * FROM cscart_bm_layouts WHERE 1 AND cscart_bm_layouts.company_id = 1 AND layout_id = 3
|
2 |
0.00009 |
0.00010 |
0.00010 |
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A'
|
2 |
0.00013 |
0.00014 |
0.00014 |
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE page_id = 55
|
2 |
0.00022 |
0.00022 |
0.00022 |
SELECT lang.name, 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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'ro' AND lang.name IN ('no_image', 'no_image')
|
1 |
0.00025 |
0.00025 |
0.00025 |
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 = 'ro' WHERE cscart_images_links.object_type = 'promo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (615) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00066 |
0.00066 |
0.00066 |
SELECT lang.name, 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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'ro' AND lang.name IN ('continue', 'select', 'select_country', 'select_state', 'submit', 'continue', 'select', 'select_country', 'select_state', 'submit')
|
1 |
0.00045 |
0.00045 |
0.00045 |
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 = 'ro' WHERE cscart_images_links.object_type = 'promo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (616) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00020 |
0.00020 |
0.00020 |
SELECT cscart_banners.banner_id, cscart_banners.type, cscart_banners.target, cscart_banners.status, cscart_banners.position, cscart_banner_descriptions.banner, cscart_banner_descriptions.description, cscart_banner_descriptions.url, cscart_banner_images.banner_image_id, cscart_banners.company_id FROM cscart_banners LEFT JOIN cscart_banner_descriptions ON cscart_banner_descriptions.banner_id = cscart_banners.banner_id AND cscart_banner_descriptions.lang_code = 'ro'LEFT JOIN cscart_banner_images ON cscart_banner_images.banner_id = cscart_banners.banner_id AND cscart_banner_images.lang_code = 'ro' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_banners.banner_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'banners') WHERE 1 AND cscart_banners.status = 'A' AND (cscart_banners.type != 'G' OR cscart_banner_images.banner_image_id IS NOT NULL) AND cscart_banners.banner_id IN (224) ORDER BY cscart_banners.position asc
|
1 |
0.00034 |
0.00034 |
0.00034 |
SELECT cscart_banners.banner_id, cscart_banners.type, cscart_banners.target, cscart_banners.status, cscart_banners.position, cscart_banner_descriptions.banner, cscart_banner_descriptions.description, cscart_banner_descriptions.url, cscart_banner_images.banner_image_id, cscart_banners.company_id FROM cscart_banners LEFT JOIN cscart_banner_descriptions ON cscart_banner_descriptions.banner_id = cscart_banners.banner_id AND cscart_banner_descriptions.lang_code = 'ro'LEFT JOIN cscart_banner_images ON cscart_banner_images.banner_id = cscart_banners.banner_id AND cscart_banner_images.lang_code = 'ro' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_banners.banner_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'banners') WHERE 1 AND cscart_banners.status = 'A' AND (cscart_banners.type != 'G' OR cscart_banner_images.banner_image_id IS NOT NULL) AND cscart_banners.banner_id IN (225) ORDER BY cscart_banners.position asc
|
1 |
0.00020 |
0.00020 |
0.00020 |
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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'ro' AND lang.name = 'root_page'
|
1 |
0.00010 |
0.00010 |
0.00010 |
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 (321, 322, 323, 148) ORDER BY g.order, g.parent_id, g.grid_id ASC
|
1 |
0.00032 |
0.00032 |
0.00032 |
SELECT c.*, IF (c.location_id != 81, 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 = 3 WHERE 1 AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER')
|
1 |
0.00054 |
0.00054 |
0.00054 |
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 81
|
1 |
0.00008 |
0.00008 |
0.00008 |
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 = 55 AND dynamic_object_content.object_type like 'pages' WHERE cscart_bm_snapping.grid_id IN (125, 131, 126, 132, 130, 351, 431, 127, 128, 129, 325, 331, 413, 414, 415, 416, 412, 428, 429, 430) AND cscart_bm_blocks_descriptions.lang_code='ro' AND cscart_bm_blocks.company_id = 1 ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id
|
1 |
0.00101 |
0.00101 |
0.00101 |
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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'ro' AND lang.name = 'root_level'
|
1 |
0.00029 |
0.00029 |
0.00029 |
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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'ro' AND lang.name = 'all_filters'
|
1 |
0.00010 |
0.00010 |
0.00010 |
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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'ro' AND lang.name = 'all_pages'
|
1 |
0.00019 |
0.00019 |
0.00019 |
SELECT lang.name, 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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'ro' AND lang.name IN ('posted_by', 'posted_by')
|
1 |
0.00034 |
0.00034 |
0.00034 |
SELECT cscart_banners.banner_id, cscart_banners.type, cscart_banners.target, cscart_banners.status, cscart_banners.position, cscart_banner_descriptions.banner, cscart_banner_descriptions.description, cscart_banner_descriptions.url, cscart_banner_images.banner_image_id, cscart_banners.company_id FROM cscart_banners LEFT JOIN cscart_banner_descriptions ON cscart_banner_descriptions.banner_id = cscart_banners.banner_id AND cscart_banner_descriptions.lang_code = 'ro'LEFT JOIN cscart_banner_images ON cscart_banner_images.banner_id = cscart_banners.banner_id AND cscart_banner_images.lang_code = 'ro' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_banners.banner_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'banners') WHERE 1 AND cscart_banners.status = 'A' AND (cscart_banners.type != 'G' OR cscart_banner_images.banner_image_id IS NOT NULL) AND cscart_banners.banner_id IN (226) ORDER BY cscart_banners.position asc
|
1 |
0.00031 |
0.00031 |
0.00031 |
SELECT lang.name, 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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'ro' AND lang.name IN ('get_the_latest_news', 'email', 'enter_email', 'go', 'get_the_latest_news', 'email', 'enter_email', 'go')
|
1 |
0.00051 |
0.00051 |
0.00051 |
SELECT lang.name, 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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'ro' AND lang.name IN ('orders', 'profile_details', 'sign_in', 'create_account', 'wishlist', 'view_comparison_list', 'orders', 'profile_details', 'sign_in', 'create_account', 'wishlist', 'view_comparison_list')
|
1 |
0.00096 |
0.00096 |
0.00096 |
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 = 'ro' WHERE cscart_images_links.object_type = 'promo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (621) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00018 |
0.00018 |
0.00018 |
SELECT lang.name, 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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'ro' AND lang.name IN ('choose_your_country', 'choose_your_country')
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT lang.name, 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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'ro' AND lang.name IN ('cannot_buy', 'no_products_selected', 'error_no_items_selected', 'delete_confirmation', 'text_out_of_stock', 'items', 'text_required_group_product', 'save', 'close', 'notice', 'warning', 'error', 'empty', 'text_are_you_sure_to_proceed', 'text_invalid_url', 'error_validator_email', 'error_validator_phone', 'error_validator_integer', 'error_validator_multiple', 'error_validator_password', 'error_validator_required', 'error_validator_zipcode', 'error_validator_message', 'text_page_loading', 'error_ajax', 'text_changes_not_saved', 'text_data_changed', 'placing_order', 'file_browser', 'browse', 'more', 'text_no_products_found', 'cookie_is_disabled', 'cannot_buy', 'no_products_selected', 'error_no_items_selected', 'delete_confirmation', 'text_out_of_stock', 'items', 'text_required_group_product', 'save', 'close', 'notice', 'warning', 'error', 'empty', 'text_are_you_sure_to_proceed', 'text_invalid_url', 'error_validator_email', 'error_validator_phone', 'error_validator_integer', 'error_validator_multiple', 'error_validator_password', 'error_validator_required', 'error_validator_zipcode', 'error_validator_message', 'text_page_loading', 'error_ajax', 'text_changes_not_saved', 'text_data_changed', 'placing_order', 'file_browser', 'browse', 'more', 'text_no_products_found', 'cookie_is_disabled')
|
1 |
0.00115 |
0.00115 |
0.00115 |
SELECT lang.name, 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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'ro' AND lang.name IN ('error_validator_recaptcha', 'error_validator_recaptcha')
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT lang.name, 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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'ro' AND lang.name IN ('error_validator_email_not_match', 'error_validator_email_not_match')
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT cscart_banners.banner_id, cscart_banners.type, cscart_banners.target, cscart_banners.status, cscart_banners.position, cscart_banner_descriptions.banner, cscart_banner_descriptions.description, cscart_banner_descriptions.url, cscart_banner_images.banner_image_id, cscart_banners.company_id FROM cscart_banners LEFT JOIN cscart_banner_descriptions ON cscart_banner_descriptions.banner_id = cscart_banners.banner_id AND cscart_banner_descriptions.lang_code = 'ro'LEFT JOIN cscart_banner_images ON cscart_banner_images.banner_id = cscart_banners.banner_id AND cscart_banner_images.lang_code = 'ro' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_banners.banner_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'banners') WHERE 1 AND cscart_banners.status = 'A' AND (cscart_banners.type != 'G' OR cscart_banner_images.banner_image_id IS NOT NULL) AND cscart_banners.banner_id IN (230) ORDER BY cscart_banners.position asc
|
1 |
0.00017 |
0.00017 |
0.00017 |
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 = 'ro' WHERE cscart_images_links.object_type = 'promo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (620) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00019 |
0.00019 |
0.00019 |
SELECT cscart_banners.banner_id, cscart_banners.type, cscart_banners.target, cscart_banners.status, cscart_banners.position, cscart_banner_descriptions.banner, cscart_banner_descriptions.description, cscart_banner_descriptions.url, cscart_banner_images.banner_image_id, cscart_banners.company_id FROM cscart_banners LEFT JOIN cscart_banner_descriptions ON cscart_banner_descriptions.banner_id = cscart_banners.banner_id AND cscart_banner_descriptions.lang_code = 'ro'LEFT JOIN cscart_banner_images ON cscart_banner_images.banner_id = cscart_banners.banner_id AND cscart_banner_images.lang_code = 'ro' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_banners.banner_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'banners') WHERE 1 AND cscart_banners.status = 'A' AND (cscart_banners.type != 'G' OR cscart_banner_images.banner_image_id IS NOT NULL) AND cscart_banners.banner_id IN (227) ORDER BY cscart_banners.position asc
|
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 = 'ro' WHERE cscart_images_links.object_type = 'promo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (617) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00025 |
0.00025 |
0.00025 |
SELECT c.* FROM cscart_bm_containers as c WHERE 1 AND c.location_id = 81
|
1 |
0.00032 |
0.00032 |
0.00032 |
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 = 'ro' WHERE cscart_images_links.object_type = 'promo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (618) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00020 |
0.00020 |
0.00020 |
SELECT cscart_banners.banner_id, cscart_banners.type, cscart_banners.target, cscart_banners.status, cscart_banners.position, cscart_banner_descriptions.banner, cscart_banner_descriptions.description, cscart_banner_descriptions.url, cscart_banner_images.banner_image_id, cscart_banners.company_id FROM cscart_banners LEFT JOIN cscart_banner_descriptions ON cscart_banner_descriptions.banner_id = cscart_banners.banner_id AND cscart_banner_descriptions.lang_code = 'ro'LEFT JOIN cscart_banner_images ON cscart_banner_images.banner_id = cscart_banners.banner_id AND cscart_banner_images.lang_code = 'ro' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_banners.banner_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'banners') WHERE 1 AND cscart_banners.status = 'A' AND (cscart_banners.type != 'G' OR cscart_banner_images.banner_image_id IS NOT NULL) AND cscart_banners.banner_id IN (228) ORDER BY cscart_banners.position asc
|
1 |
0.00019 |
0.00019 |
0.00019 |
SELECT cscart_banners.banner_id, cscart_banners.type, cscart_banners.target, cscart_banners.status, cscart_banners.position, cscart_banner_descriptions.banner, cscart_banner_descriptions.description, cscart_banner_descriptions.url, cscart_banner_images.banner_image_id, cscart_banners.company_id FROM cscart_banners LEFT JOIN cscart_banner_descriptions ON cscart_banner_descriptions.banner_id = cscart_banners.banner_id AND cscart_banner_descriptions.lang_code = 'ro'LEFT JOIN cscart_banner_images ON cscart_banner_images.banner_id = cscart_banners.banner_id AND cscart_banner_images.lang_code = 'ro' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_banners.banner_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'banners') WHERE 1 AND cscart_banners.status = 'A' AND (cscart_banners.type != 'G' OR cscart_banner_images.banner_image_id IS NOT NULL) AND cscart_banners.banner_id IN (229) ORDER BY cscart_banners.position asc
|
1 |
0.00021 |
0.00021 |
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 = 'ro' WHERE cscart_images_links.object_type = 'promo' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (619) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00019 |
0.00019 |
0.00019 |
SELECT lang.name, 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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'ro' AND lang.name IN ('blog', 'blog.read_more', 'blog', 'blog.read_more')
|
1 |
0.00063 |
0.00063 |
0.00063 |
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN(0, 1)
|
1 |
0.00011 |
0.00011 |
0.00011 |
SELECT company_id, storefront, secure_storefront, redirect_customer FROM cscart_companies WHERE company_id = 1
|
1 |
0.00010 |
0.00010 |
0.00010 |
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 = 1 WHERE 1 AND section_id = '50' 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.00026 |
0.00026 |
0.00026 |
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.00034 |
0.00034 |
0.00034 |
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 55 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'ro'
|
1 |
0.00020 |
0.00020 |
0.00020 |
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 = 'ro' 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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'currencies') WHERE 1 AND status IN ('A', 'H') ORDER BY a.position
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT company_id, secure_storefront FROM cscart_companies WHERE secure_storefront RLIKE '^(www[0-9]*.)?echilipir.ro'
|
1 |
0.00019 |
0.00019 |
0.00019 |
SELECT companies.* FROM cscart_companies AS companies WHERE companies.company_id = 1
|
1 |
0.00010 |
0.00010 |
0.00010 |
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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'languages') WHERE 1 AND cscart_languages.status = 'A'
|
1 |
0.00019 |
0.00019 |
0.00019 |
SELECT * FROM cscart_seo_names WHERE name = 'rent-a-car-deva' AND lang_code = 'ro'
|
1 |
0.00026 |
0.00026 |
0.00026 |
SELECT company_id FROM cscart_companies WHERE 1 AND status IN ('A', 'P', 'N')
|
1 |
0.00006 |
0.00006 |
0.00006 |
SELECT company_id FROM cscart_companies WHERE 1 AND company_id IN (1) AND status IN ('A', 'P', 'N')
|
1 |
0.00009 |
0.00009 |
0.00009 |
SELECT entry_page FROM cscart_companies WHERE company_id = 1 AND redirect_customer != 'Y'
|
1 |
0.00006 |
0.00006 |
0.00006 |
SELECT company_id FROM cscart_companies
|
1 |
0.00005 |
0.00005 |
0.00005 |
SELECT type FROM cscart_seo_names WHERE name = 'rent-a-car-deva' AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0)
|
1 |
0.00036 |
0.00036 |
0.00036 |
SET time_zone = '+03:00'
|
1 |
0.00006 |
0.00006 |
0.00006 |
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.00014 |
0.00014 |
0.00014 |
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.00019 |
0.00019 |
0.00019 |
SELECT company_id FROM cscart_companies WHERE status = 'A' ORDER BY company_id LIMIT 1
|
1 |
0.00008 |
0.00008 |
0.00008 |
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'store_mode'
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT addon FROM cscart_addons WHERE unmanaged = 1 AND status = 'A' ORDER BY priority
|
1 |
0.00027 |
0.00027 |
0.00027 |
SELECT cscart_tags.tag_id, cscart_tag_links.object_id, cscart_tag_links.object_type, cscart_tags.tag, cscart_tags.status, COUNT(cscart_tag_links.tag_id) as popularity FROM cscart_tags LEFT JOIN cscart_tag_links ON cscart_tag_links.tag_id = cscart_tags.tag_id WHERE 1 AND cscart_tags.company_id = 1 AND cscart_tag_links.object_type = 'A' AND cscart_tags.status IN ('A') AND cscart_tag_links.object_id = 55 GROUP BY cscart_tags.tag_id ORDER BY cscart_tags.tag asc
|
1 |
0.00022 |
0.00022 |
0.00022 |
SELECT value FROM cscart_form_options WHERE element_type = 'U' AND page_id = 55
|
1 |
0.00155 |
0.00155 |
0.00155 |
SELECT lang.name, 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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'ro' AND lang.name IN ('on_site_template_editing', 'on_site_live_editing')
|
1 |
0.00029 |
0.00029 |
0.00029 |
SELECT company_id, storefront FROM cscart_companies WHERE FIND_IN_SET('US', countries_list) LIMIT 1
|
1 |
0.00011 |
0.00011 |
0.00011 |
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.00061 |
0.00061 |
0.00061 |
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 = 1 AND cscart_ult_language_values.lang_code = lang.lang_code WHERE lang.lang_code = 'ro' AND lang.name = 'home'
|
1 |
0.00159 |
0.00159 |
0.00159 |
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 = 291 ORDER BY cscart_settings_objects.position
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cart_products_next_check'
|
1 |
0.00009 |
0.00009 |
0.00009 |
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.00022 |
0.00022 |
0.00022 |
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'dev_mode'
|
1 |
0.00009 |
0.00009 |
0.00009 |
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 = 'ro' 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 = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages') WHERE cscart_pages.page_id = 55 AND cscart_page_descriptions.lang_code = 'ro' 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.00180 |
0.00180 |
0.00180 |
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 = 'ro' WHERE l.layout_id = 3 AND l.dispatch = 'pages.view' AND (FIND_IN_SET(55, l.object_ids) OR l.object_ids = '') ORDER BY l.object_ids desc LIMIT 1
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT `data` FROM cscart_storage_data WHERE `data_key` = 'cache_id'
|
1 |
0.00017 |
0.00017 |
0.00017 |