Queries
max count: 2
| Query |
Count |
Min time |
Max time |
Average time |
SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 12
|
2 |
0.00017 |
0.00026 |
0.00022 |
SELECT storefronts.* FROM cscart_storefronts AS storefronts WHERE 1 = 1 AND (storefronts.url = 'biobronz.com' OR storefronts.url = 'www.biobronz.com' OR storefronts.url LIKE 'www_.biobronz.com' OR storefronts.url LIKE 'biobronz.com/%' OR storefronts.url LIKE 'www.biobronz.com/%' OR storefronts.url LIKE 'www_.biobronz.com/%') GROUP BY storefronts.storefront_id ORDER BY storefronts.url = 'biobronz.com' DESC, storefronts.url = 'www.biobronz.com' DESC, storefronts.url LIKE 'www_.biobronz.com' DESC, storefronts.url LIKE 'biobronz.com/%' DESC, storefronts.url LIKE 'www.biobronz.com/%' DESC, storefronts.url LIKE 'www_.biobronz.com/%' desc
|
1 |
0.00039 |
0.00039 |
0.00039 |
SELECT link_id FROM cscart_open_graph_data WHERE object_url = 'index.php?activate_redirect=0&dispatch=index.index' AND object_type = 0 AND cscart_open_graph_data.company_id = 12
|
1 |
0.00015 |
0.00015 |
0.00015 |
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 (2746, 2747, 3875, 3867, 3869, 3868, 3870, 3871, 3872, 3873, 3874, 2737) AND cscart_bm_blocks_descriptions.lang_code='en' AND cscart_bm_blocks.company_id = 12 ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id
|
1 |
0.00073 |
0.00073 |
0.00073 |
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 (3069, 3066, 3071, 3072) ORDER BY g.order, g.parent_id, g.grid_id ASC
|
1 |
0.00032 |
0.00032 |
0.00032 |
SELECT c.*, IF (c.location_id != 768, 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 = 40 WHERE 1 AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER')
|
1 |
0.00040 |
0.00040 |
0.00040 |
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 768
|
1 |
0.00009 |
0.00009 |
0.00009 |
SELECT c.* FROM cscart_bm_containers as c WHERE 1 AND c.location_id = 768
|
1 |
0.00019 |
0.00019 |
0.00019 |
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT events.event, events.use_event, events.params, events.extra FROM cscart_cp_gtm_events as events WHERE 1 AND events.company_id = 12 AND events.status = 'A' ORDER BY events.event asc
|
1 |
0.00014 |
0.00014 |
0.00014 |
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)
|
1 |
0.00017 |
0.00017 |
0.00017 |
SELECT * FROM cscart_hybrid_auth_providers WHERE 1 AND company_id = 12 AND status = 'A' ORDER BY position
|
1 |
0.00013 |
0.00013 |
0.00013 |
SELECT * FROM cscart_bm_layouts WHERE 1 AND storefront_id = 12 AND layout_id = 40
|
1 |
0.00029 |
0.00029 |
0.00029 |
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 = 'en' WHERE l.layout_id = 40 AND l.dispatch IN ('index.index') ORDER BY l.object_ids desc LIMIT 1
|
1 |
0.00072 |
0.00072 |
0.00072 |
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'
|
1 |
0.00016 |
0.00016 |
0.00016 |
SELECT cscart_payments.*, cscart_payment_descriptions.*, IF (ISNULL(cscart_addons.status), "A", cscart_addons.status) AS processor_status, cscart_payment_processors.type AS processor_type, cscart_payment_processors.processor_script AS processor_script FROM cscart_payments LEFT JOIN cscart_payment_descriptions ON cscart_payment_descriptions.payment_id = cscart_payments.payment_id AND cscart_payment_descriptions.lang_code = 'en' LEFT JOIN cscart_payment_processors ON cscart_payment_processors.processor_id = cscart_payments.processor_id LEFT JOIN cscart_addons ON cscart_payment_processors.addon = cscart_addons.addon LEFT JOIN cscart_storefronts_payments AS storefronts_payments ON storefronts_payments.payment_id = cscart_payments.payment_id WHERE cscart_payments.status = 'A' AND (storefronts_payments.storefront_id = 12 OR storefronts_payments.storefront_id IS NULL) AND cscart_payment_processors.processor_script IN ('stripe.php') HAVING processor_status = 'A' ORDER BY cscart_payments.position
|
1 |
0.00059 |
0.00059 |
0.00059 |
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'
|
1 |
0.00008 |
0.00008 |
0.00008 |
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'
|
1 |
0.00011 |
0.00011 |
0.00011 |
SELECT storefronts.* FROM cscart_storefronts AS storefronts LEFT JOIN cscart_storefronts_companies AS companies ON storefronts.storefront_id = companies.storefront_id WHERE 1 = 1 AND (companies.company_id IN ('12') ) GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc
|
1 |
0.00026 |
0.00026 |
0.00026 |
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts WHERE 1 AND is_default = 1 AND theme_name = 'airy_mobile' AND storefront_id = 12
|
1 |
0.00028 |
0.00028 |
0.00028 |
SELECT storefronts.* FROM cscart_storefronts AS storefronts WHERE 1 = 1 AND storefronts.storefront_id IN (12) GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc
|
1 |
0.00027 |
0.00027 |
0.00027 |
SELECT companies.* FROM cscart_companies AS companies WHERE companies.company_id = 12
|
1 |
0.00020 |
0.00020 |
0.00020 |
SET time_zone = '+01:00'
|
1 |
0.00006 |
0.00006 |
0.00006 |
SELECT entry_page FROM cscart_companies WHERE company_id = 12 AND redirect_customer != 'Y'
|
1 |
0.00015 |
0.00015 |
0.00015 |
SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'
|
1 |
0.00016 |
0.00016 |
0.00016 |