Queries
max count: 1
| Query |
Count |
Min time |
Max time |
Average time |
SELECT storefronts.* FROM cscart_storefronts AS storefronts WHERE 1 = 1 AND (storefronts.url = 'vietpom.pxs.one' OR storefronts.url = 'www.vietpom.pxs.one' OR storefronts.url LIKE 'www_.vietpom.pxs.one' OR storefronts.url LIKE 'vietpom.pxs.one/%' OR storefronts.url LIKE 'www.vietpom.pxs.one/%' OR storefronts.url LIKE 'www_.vietpom.pxs.one/%') GROUP BY storefronts.storefront_id ORDER BY storefronts.url = 'vietpom.pxs.one' DESC, storefronts.url = 'www.vietpom.pxs.one' DESC, storefronts.url LIKE 'www_.vietpom.pxs.one' DESC, storefronts.url LIKE 'vietpom.pxs.one/%' DESC, storefronts.url LIKE 'www.vietpom.pxs.one/%' DESC, storefronts.url LIKE 'www_.vietpom.pxs.one/%' desc
|
1 |
0.00052 |
0.00052 |
0.00052 |
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)
|
1 |
0.00020 |
0.00020 |
0.00020 |
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'vi' WHERE cscart_images_links.object_type = 'static_data_type' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '35688' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00029 |
0.00029 |
0.00029 |
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'vi' WHERE cscart_images_links.object_type = 'static_data_type' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '35684' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00037 |
0.00037 |
0.00037 |
SELECT sd.param_id, sd.param, cscart_static_data_descriptions.descr, sd.param_2, sd.param_3, sd.param_4, sd.param_5, sd.param_6, sd.status, sd.position, sd.parent_id, sd.id_path, sd.class, sd.mobile_app_link_type, sd.mobile_app_link FROM cscart_static_data AS sd LEFT JOIN cscart_static_data_descriptions ON sd.param_id = cscart_static_data_descriptions.param_id AND cscart_static_data_descriptions.lang_code = 'vi' WHERE sd.section = 'A' AND sd.status = 'A' AND sd.param_5 = '12' ORDER BY sd.position
|
1 |
0.00097 |
0.00097 |
0.00097 |
SELECT status FROM cscart_menus WHERE menu_id = 12
|
1 |
0.00029 |
0.00029 |
0.00029 |
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 '' 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 = 0 AND dynamic_object_content.object_type like '' WHERE cscart_bm_snapping.grid_id IN (2203, 2204, 2205, 2206, 2207, 2208, 2210, 2211, 2214, 2220, 2209, 2212, 2413, 2213, 2219, 2215, 2216, 2217, 2218, 2378, 2379, 2380, 2381) AND cscart_bm_blocks_descriptions.lang_code='vi' ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id
|
1 |
0.00121 |
0.00121 |
0.00121 |
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 (1163, 1164, 1165, 1054) ORDER BY g.order, g.parent_id, g.grid_id ASC
|
1 |
0.00047 |
0.00047 |
0.00047 |
SELECT c.*, IF (c.location_id != 230, 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 = 8 WHERE 1 AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0
|
1 |
0.00034 |
0.00034 |
0.00034 |
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 230
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT c.* FROM cscart_bm_containers as c WHERE 1 AND c.location_id = 230 AND c.company_id = 0
|
1 |
0.00028 |
0.00028 |
0.00028 |
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'
|
1 |
0.00027 |
0.00027 |
0.00027 |
SELECT * FROM cscart_mailing_lists LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_mailing_lists.list_id AND cscart_common_descriptions.object_holder = 'mailing_lists' AND cscart_common_descriptions.lang_code = 'vi' WHERE 1 AND cscart_mailing_lists.status = 'A'
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT a.country_code, a.code, b.state FROM cscart_states as a LEFT JOIN cscart_state_descriptions as b ON b.state_id = a.state_id AND b.lang_code = 'vi' WHERE a.status = 'A' ORDER BY a.country_code, b.state
|
1 |
0.00260 |
0.00260 |
0.00260 |
SELECT a.code, b.country FROM cscart_countries as a LEFT JOIN cscart_country_descriptions as b ON b.code = a.code AND b.lang_code = 'vi' WHERE a.status = 'A' ORDER BY b.country
|
1 |
0.00108 |
0.00108 |
0.00108 |
SELECT cscart_profile_fields.*, cscart_profile_field_descriptions.description , cscart_profile_fields.profile_required as required FROM cscart_profile_fields LEFT JOIN cscart_profile_field_descriptions ON cscart_profile_field_descriptions.object_id = cscart_profile_fields.field_id AND cscart_profile_field_descriptions.object_type = 'F' AND lang_code = 'vi' WHERE 1=1 AND cscart_profile_fields.profile_type = 'U' AND cscart_profile_fields.profile_show = 'Y' AND cscart_profile_fields.field_type != 'E' ORDER BY cscart_profile_fields.position
|
1 |
0.00049 |
0.00049 |
0.00049 |
SELECT * FROM cscart_hybrid_auth_providers WHERE 1 AND status = 'A' ORDER BY position
|
1 |
0.00019 |
0.00019 |
0.00019 |
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 = 'vi' WHERE l.layout_id = 8 AND l.dispatch IN ('profiles.add') ORDER BY l.object_ids desc LIMIT 1
|
1 |
0.00043 |
0.00043 |
0.00043 |
SELECT * FROM cscart_bm_layouts WHERE 1 AND storefront_id = 1 AND layout_id = 8
|
1 |
0.00024 |
0.00024 |
0.00024 |
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts WHERE 1 AND is_default = 1 AND theme_name = 'vietpom_theme' AND storefront_id = 1
|
1 |
0.00025 |
0.00025 |
0.00025 |
SELECT storefronts.* FROM cscart_storefronts AS storefronts WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc
|
1 |
0.00034 |
0.00034 |
0.00034 |
SET time_zone = '+07:00'
|
1 |
0.00010 |
0.00010 |
0.00010 |
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'vi' WHERE cscart_images_links.object_type = 'static_data_type' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '35690' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00028 |
0.00028 |
0.00028 |