Queries
max count: 2
| Query |
Count |
Min time |
Max time |
Average time |
SELECT page_type FROM cscart_pages WHERE page_id = 30
|
2 |
0.00006 |
0.00018 |
0.00012 |
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 privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)
|
1 |
0.00006 |
0.00006 |
0.00006 |
SELECT 1 FROM cscart_lock_keys WHERE key_id = '63e7d4c9c35c4348c3f2cb8456ea217d91b2946ae38cd260f2d3e1e9caba42f0' AND token = 'IGXtcADLMDBku1LZ+qmUPhDvZ7sWVoYSIWJ113SrtFA=' AND expiry_at > UNIX_TIMESTAMP(NOW())
|
1 |
0.00058 |
0.00058 |
0.00058 |
DELETE FROM cscart_lock_keys WHERE key_id = '63e7d4c9c35c4348c3f2cb8456ea217d91b2946ae38cd260f2d3e1e9caba42f0' AND token = 'IGXtcADLMDBku1LZ+qmUPhDvZ7sWVoYSIWJ113SrtFA='
|
1 |
0.00075 |
0.00075 |
0.00075 |
UPDATE cscart_lock_keys SET expiry_at = UNIX_TIMESTAMP(NOW()) + 30, token = 'IGXtcADLMDBku1LZ+qmUPhDvZ7sWVoYSIWJ113SrtFA=' WHERE key_id = '63e7d4c9c35c4348c3f2cb8456ea217d91b2946ae38cd260f2d3e1e9caba42f0' AND (token = 'IGXtcADLMDBku1LZ+qmUPhDvZ7sWVoYSIWJ113SrtFA=' OR expiry_at <= UNIX_TIMESTAMP(NOW()))
|
1 |
0.00091 |
0.00091 |
0.00091 |
INSERT INTO cscart_lock_keys (key_id, token, expiry_at) VALUES ('63e7d4c9c35c4348c3f2cb8456ea217d91b2946ae38cd260f2d3e1e9caba42f0', 'IGXtcADLMDBku1LZ+qmUPhDvZ7sWVoYSIWJ113SrtFA=', UNIX_TIMESTAMP(NOW()) + 300)
|
1 |
0.04358 |
0.04358 |
0.04358 |
SELECT quickpay_id FROM cscart_jp_cc_quickpay WHERE user_id =0 AND payment_method ='remise_cc'
|
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 '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 = 30 AND dynamic_object_content.object_type like 'pages' WHERE cscart_bm_snapping.grid_id IN (1, 2, 3, 4, 5, 6, 9, 7, 8, 12, 15, 20, 13, 14, 16, 17, 18, 19, 21, 22, 76, 77, 78) AND cscart_bm_blocks_descriptions.lang_code='ja' ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id
|
1 |
0.00154 |
0.00154 |
0.00154 |
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, 51, 4) ORDER BY g.order, g.parent_id, g.grid_id ASC
|
1 |
0.00007 |
0.00007 |
0.00007 |
SELECT c.*, IF (c.location_id != 13, 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.00009 |
0.00009 |
0.00009 |
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 13
|
1 |
0.00004 |
0.00004 |
0.00004 |
SELECT c.* FROM cscart_bm_containers as c WHERE 1 AND c.location_id = 13 AND c.company_id = 0
|
1 |
0.00007 |
0.00007 |
0.00007 |
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'
|
1 |
0.00038 |
0.00038 |
0.00038 |
SELECT usergroup_ids FROM cscart_pages WHERE page_id = 30
|
1 |
0.00012 |
0.00012 |
0.00012 |
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'
|
1 |
0.00003 |
0.00003 |
0.00003 |
SELECT f.*, d.description FROM cscart_form_options as f LEFT JOIN cscart_form_descriptions as d ON d.object_id=f.element_id AND d.lang_code = 'ja' WHERE f.page_id = 30 AND f.status = 'A' ORDER BY f.position
|
1 |
0.00093 |
0.00093 |
0.00093 |
SELECT cscart_pages.*, cscart_page_descriptions.* FROM cscart_pages INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id WHERE cscart_pages.page_id = 30 AND cscart_page_descriptions.lang_code = 'ja' 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') AND (cscart_pages.addon_rank_ids = '' OR FIND_IN_SET(0, cscart_pages.addon_rank_ids))
|
1 |
0.00040 |
0.00040 |
0.00040 |
select ru.user_id ,ru.rank_id ,ru.order_cnt ,ru.order_amount ,ru.confirmed_date ,ru.target_order_ids ,ru.coupon_ids ,ru.email_sent_time ,rmr.name as rank_name ,rmr.low_sales_cnt ,rmr.low_sales_price ,reu.user_id as exclusion_user_id ,ippan_ug.status as ippan_status ,inryo_ug.status as inryo_status ,shuhan_ug.status as shuhan_status ,tonya_ug.status as tonya_status from cscart_rank_user as ru left join cscart_rank_mst_rank as rmr on ru.rank_id = rmr.id left join cscart_rank_exclusion_user as reu on ru.user_id = reu.user_id left join cscart_usergroup_links as ippan_ug on ru.user_id = ippan_ug.user_id and ippan_ug.usergroup_id = 7 and ippan_ug.status = 'A' left join cscart_usergroup_links as inryo_ug on ru.user_id = inryo_ug.user_id and inryo_ug.usergroup_id = 8 and inryo_ug.status = 'A' left join cscart_usergroup_links as shuhan_ug on ru.user_id = shuhan_ug.user_id and shuhan_ug.usergroup_id = 9 and shuhan_ug.status = 'A' left join cscart_usergroup_links as tonya_ug on ru.user_id = tonya_ug.user_id and tonya_ug.usergroup_id = 10 and tonya_ug.status = 'A' where ru.user_id = 0
|
1 |
0.00033 |
0.00033 |
0.00033 |
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 ('pages.view') AND (FIND_IN_SET(30, l.object_ids) OR l.object_ids = '') ORDER BY l.object_ids desc LIMIT 1
|
1 |
0.00111 |
0.00111 |
0.00111 |
SELECT * FROM cscart_bm_layouts WHERE 1 AND storefront_id = 1 AND layout_id = 1
|
1 |
0.00006 |
0.00006 |
0.00006 |
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'
|
1 |
0.00005 |
0.00005 |
0.00005 |
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'
|
1 |
0.00005 |
0.00005 |
0.00005 |
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 |
SELECT company_id FROM cscart_pages WHERE page_id = '30'
|
1 |
0.00040 |
0.00040 |
0.00040 |
SET time_zone = '+09:00'
|
1 |
0.00005 |
0.00005 |
0.00005 |
SELECT object_id, thread_id, type, object_type FROM cscart_discussion WHERE 1 AND object_id = 30 AND object_type = 'A'
|
1 |
0.00033 |
0.00033 |
0.00033 |