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 = 'edev.sms-refactory.com' OR storefronts.url = 'www.edev.sms-refactory.com' OR storefronts.url LIKE 'www_.edev.sms-refactory.com' OR storefronts.url LIKE 'edev.sms-refactory.com/%' OR storefronts.url LIKE 'www.edev.sms-refactory.com/%' OR storefronts.url LIKE 'www_.edev.sms-refactory.com/%') GROUP BY storefronts.storefront_id ORDER BY storefronts.url = 'edev.sms-refactory.com' DESC, storefronts.url = 'www.edev.sms-refactory.com' DESC, storefronts.url LIKE 'www_.edev.sms-refactory.com' DESC, storefronts.url LIKE 'edev.sms-refactory.com/%' DESC, storefronts.url LIKE 'www.edev.sms-refactory.com/%' DESC, storefronts.url LIKE 'www_.edev.sms-refactory.com/%' desc
|
1 |
0.00006 |
0.00006 |
0.00006 |
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 = 'ja' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (4, 5) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00007 |
0.00007 |
0.00007 |
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 (1, 2, 3, 4, 5, 6, 9, 7, 8, 10, 11, 12, 15, 20, 13, 14, 16, 17, 18, 19, 21, 22) AND cscart_bm_blocks_descriptions.lang_code='ja' ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id
|
1 |
0.00008 |
0.00008 |
0.00008 |
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 (1, 2, 3, 4) ORDER BY g.order, g.parent_id, g.grid_id ASC
|
1 |
0.00006 |
0.00006 |
0.00006 |
SELECT c.*, IF (c.location_id != 1, 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 = 1 WHERE 1 AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0
|
1 |
0.00004 |
0.00004 |
0.00004 |
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 1
|
1 |
0.00003 |
0.00003 |
0.00003 |
SELECT c.* FROM cscart_bm_containers as c WHERE 1 AND c.location_id = 1 AND c.company_id = 0
|
1 |
0.00005 |
0.00005 |
0.00005 |
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'
|
1 |
0.00005 |
0.00005 |
0.00005 |
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)
|
1 |
0.00008 |
0.00008 |
0.00008 |
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 = 'ja' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (6, 7) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00006 |
0.00006 |
0.00006 |
SELECT * FROM cscart_logos WHERE layout_id IN (1, 0) AND style_id IN ('Bright_theme', '') AND storefront_id IN (1, 0) AND company_id = 2
|
1 |
0.00006 |
0.00006 |
0.00006 |
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 = 'ja' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (12, 13) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
|
1 |
0.00006 |
0.00006 |
0.00006 |
SELECT * FROM cscart_logos WHERE layout_id IN (1, 0) AND style_id IN ('Bright_theme', '') AND storefront_id IN (1, 0) AND company_id = 3
|
1 |
0.00004 |
0.00004 |
0.00004 |
SELECT * FROM cscart_profile_fields WHERE profile_type = 'S' AND is_default = 'Y'
|
1 |
0.00008 |
0.00008 |
0.00008 |
SELECT * FROM cscart_logos WHERE layout_id IN (1, 0) AND style_id IN ('Bright_theme', '') AND storefront_id IN (1, 0) AND company_id = 1
|
1 |
0.00004 |
0.00004 |
0.00004 |
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'
|
1 |
0.00004 |
0.00004 |
0.00004 |
SELECT a.object_id, COUNT(b.post_id) as total_items FROM cscart_discussion as a LEFT JOIN cscart_discussion_posts as b ON a.thread_id=b.thread_id WHERE a.object_type = 'M' AND b.status = 'A' GROUP BY a.object_id
|
1 |
0.00004 |
0.00004 |
0.00004 |
SELECT cscart_companies.company_id, cscart_companies.lang_code, cscart_companies.email, cscart_companies.company, cscart_companies.timestamp, cscart_companies.status, cscart_company_descriptions.company_description, cscart_vendor_plan_descriptions.plan, AVG(cscart_discussion_rating.rating_value) AS average_rating, CONCAT(cscart_companies.company_id, '_', IF (cscart_discussion_rating.thread_id, cscart_discussion_rating.thread_id, '0')) AS company_thread_ids FROM cscart_companies LEFT JOIN cscart_company_descriptions ON cscart_company_descriptions.company_id = cscart_companies.company_id AND cscart_company_descriptions.lang_code = 'ja' LEFT JOIN cscart_vendor_plan_descriptions ON cscart_companies.plan_id = cscart_vendor_plan_descriptions.plan_id AND cscart_vendor_plan_descriptions.lang_code = 'ja' LEFT JOIN cscart_discussion ON cscart_discussion.object_id = cscart_companies.company_id AND cscart_discussion.object_type = 'M' LEFT JOIN cscart_discussion_posts ON cscart_discussion_posts.thread_id = cscart_discussion.thread_id AND cscart_discussion_posts.status = 'A' LEFT JOIN cscart_discussion_rating ON cscart_discussion.thread_id = cscart_discussion_rating.thread_id AND cscart_discussion_rating.post_id = cscart_discussion_posts.post_id WHERE 1 AND cscart_companies.status = 'A' GROUP BY company_thread_ids ORDER BY cscart_companies.company desc LIMIT 0, 10
|
1 |
0.00133 |
0.00133 |
0.00133 |
SELECT COUNT(DISTINCT(cscart_companies.company_id)) FROM cscart_companies LEFT JOIN cscart_company_descriptions ON cscart_company_descriptions.company_id = cscart_companies.company_id AND cscart_company_descriptions.lang_code = 'ja' LEFT JOIN cscart_vendor_plan_descriptions ON cscart_companies.plan_id = cscart_vendor_plan_descriptions.plan_id AND cscart_vendor_plan_descriptions.lang_code = 'ja' LEFT JOIN cscart_discussion ON cscart_discussion.object_id = cscart_companies.company_id AND cscart_discussion.object_type = 'M' LEFT JOIN cscart_discussion_posts ON cscart_discussion_posts.thread_id = cscart_discussion.thread_id AND cscart_discussion_posts.status = 'A' LEFT JOIN cscart_discussion_rating ON cscart_discussion.thread_id = cscart_discussion_rating.thread_id AND cscart_discussion_rating.post_id = cscart_discussion_posts.post_id WHERE 1 AND cscart_companies.status = 'A'
|
1 |
0.00004 |
0.00004 |
0.00004 |
SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1
|
1 |
0.00004 |
0.00004 |
0.00004 |
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 = 'ja' WHERE l.layout_id = 1 AND l.is_default = 1 ORDER BY l.is_default desc
|
1 |
0.00004 |
0.00004 |
0.00004 |
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 = 'ja' WHERE l.layout_id = 1 AND l.dispatch IN ('companies') ORDER BY l.object_ids desc LIMIT 1
|
1 |
0.00004 |
0.00004 |
0.00004 |
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 = 'ja' WHERE l.layout_id = 1 AND l.dispatch IN ('companies.catalog') ORDER BY l.object_ids desc LIMIT 1
|
1 |
0.00005 |
0.00005 |
0.00005 |
SELECT * FROM cscart_bm_layouts WHERE 1 AND storefront_id = 1 AND layout_id = 1
|
1 |
0.00005 |
0.00005 |
0.00005 |
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'
|
1 |
0.00004 |
0.00004 |
0.00004 |
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'
|
1 |
0.00004 |
0.00004 |
0.00004 |
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts WHERE 1 AND is_default = 1 AND theme_name = 'bright_theme' AND storefront_id = 1
|
1 |
0.00004 |
0.00004 |
0.00004 |
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.00005 |
0.00005 |
0.00005 |
SET time_zone = '+09:00'
|
1 |
0.00004 |
0.00004 |
0.00004 |
SELECT quickpay_id FROM cscart_jp_cc_quickpay WHERE user_id =0 AND payment_method ='remise_cc'
|
1 |
0.00004 |
0.00004 |
0.00004 |