基本
文件
流程
错误
SQL
调试
- 请求信息 : 2022-08-14 00:13:55 HTTP/1.1 GET : https://www.on-bright-gz.com/mobile/Article/detail.html?id=358
- 运行时间 : 0.054275s [ 吞吐率:18.42req/s ] 内存消耗:1,179.37kb 文件加载:169
- 查询信息 : 59 queries
- 缓存信息 : 4 reads,4 writes
- 会话信息 : SESSION_ID=cb50cf60d97e3d983c030eaaaff41a8f
- CONNECT:[ UseTime:0.000757s ] mysql:host=localhost:3306;port=3306;dbname=angbao;charset=utf8
- SHOW FULL COLUMNS FROM `ecs_shop_config` [ RunTime:0.000891s ]
- SELECT `code`,`value` FROM `ecs_shop_config` WHERE `parent_id` > 0 [ RunTime:0.000420s ]
- INSERT INTO angbao.ecs_sessions (sesskey, expiry, ip, data) VALUES ('0f48c69de8ef2409ffd48d5db46e4083', '1660407235', '44.200.175.255', 'a:0:{}') [ RunTime:0.002051s ]
- SELECT * FROM ecs_nav WHERE `type` = 'top' and ifshow = '1' ORDER BY type, vieworder [ RunTime:0.000436s ]
- SELECT * FROM ecs_article_cat WHERE show_in_nav =1 ORDER BY sort_order ASC [ RunTime:0.000473s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=118 [ RunTime:0.000391s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=119 [ RunTime:0.000305s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=148 [ RunTime:0.000285s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=27 [ RunTime:0.000247s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=28 [ RunTime:0.000199s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=226 [ RunTime:0.000264s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=232 [ RunTime:0.000229s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=185 [ RunTime:0.000206s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=177 [ RunTime:0.000245s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=178 [ RunTime:0.000238s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=179 [ RunTime:0.000330s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=186 [ RunTime:0.000283s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=187 [ RunTime:0.000288s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=188 [ RunTime:0.000287s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=206 [ RunTime:0.000217s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=207 [ RunTime:0.000278s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=211 [ RunTime:0.000257s ]
- SHOW FULL COLUMNS FROM `ecs_article` [ RunTime:0.000726s ]
- SELECT `content` FROM `ecs_article` WHERE `article_id` = 289 LIMIT 1 [ RunTime:0.000302s ]
- SELECT SUM(goods_number) AS number, SUM(goods_price * goods_number) AS amount FROM ecs_cart WHERE user_id = '0' AND rec_type = '0' [ RunTime:0.000368s ]
- SELECT a.*, IFNULL(AVG(r.comment_rank), 0) AS comment_rank
FROM ecs_article AS a
LEFT JOIN ecs_comment AS r ON r.id_value = a.article_id AND comment_type = 1
WHERE a.is_open = 1 AND a.article_id = '358'
GROUP BY a.article_id [ RunTime:0.000529s ]
- SHOW FULL COLUMNS FROM `ecs_article_cat` [ RunTime:0.000598s ]
- SELECT `parent_id` FROM `ecs_article_cat` WHERE `cat_id` = 358 LIMIT 1 [ RunTime:0.000304s ]
- SELECT COUNT(*) AS think_count FROM `ecs_article_cat` WHERE `parent_id` = 0 [ RunTime:0.000268s ]
- select a.cat_id, a.cat_name, b.cat_id as child_id, b.cat_name as child_name, b.sort_order as child_order from ecs_article_cat as a left join ecs_article_cat as b on b.parent_id = a.cat_id where a.parent_id = '0' AND a.cat_type = 1 ORDER BY a.sort_order ASC, a.cat_id ASC, child_order ASC [ RunTime:0.000418s ]
- SHOW FULL COLUMNS FROM `ecs_category` [ RunTime:0.000706s ]
- SELECT COUNT(*) AS think_count FROM `ecs_category` WHERE `parent_id` = 0 AND `is_show` = 1 [ RunTime:0.000287s ]
- SELECT cat_id,cat_name ,parent_id,is_show FROM ecs_category WHERE parent_id = '0' AND is_show = 1 ORDER BY sort_order ASC, cat_id ASC [ RunTime:0.000256s ]
- SELECT COUNT(*) AS think_count FROM `ecs_category` WHERE `parent_id` = 50 AND `is_show` = 1 [ RunTime:0.000245s ]
- SELECT cat_id, cat_name, parent_id, is_show FROM ecs_category WHERE parent_id = '50' AND is_show = 1 ORDER BY sort_order ASC, cat_id ASC [ RunTime:0.000257s ]
- SELECT COUNT(*) AS think_count FROM `ecs_category` WHERE `parent_id` = 52 AND `is_show` = 1 [ RunTime:0.000229s ]
- SELECT COUNT(*) AS think_count FROM `ecs_category` WHERE `parent_id` = 47 AND `is_show` = 1 [ RunTime:0.000287s ]
- SELECT cat_id, cat_name, parent_id, is_show FROM ecs_category WHERE parent_id = '47' AND is_show = 1 ORDER BY sort_order ASC, cat_id ASC [ RunTime:0.000248s ]
- SELECT COUNT(*) AS think_count FROM `ecs_category` WHERE `parent_id` = 48 AND `is_show` = 1 [ RunTime:0.000282s ]
- SELECT c.cat_id, c.cat_name, c.sort_order, a.article_id, a.title, a.file_url, a.open_type FROM ecs_article AS a LEFT JOIN ecs_article_cat AS c ON a.cat_id = c.cat_id WHERE c.cat_type = 5 AND a.is_open = 1 ORDER BY c.sort_order ASC, a.article_id [ RunTime:0.000264s ]
- SELECT c.cat_id, c.cat_name, c.measure_unit, c.parent_id, c.is_show, c.show_in_nav, c.grade, c.sort_order, COUNT(s.cat_id) AS has_children
FROM ecs_category AS c
LEFT JOIN ecs_category AS s ON s.parent_id = c.cat_id
GROUP BY c.cat_id
ORDER BY c.parent_id, c.sort_order ASC [ RunTime:0.000368s ]
- SELECT cat_id, COUNT(*) AS goods_num FROM ecs_goods WHERE is_delete = 0 AND is_on_sale = 1 GROUP BY cat_id [ RunTime:0.000414s ]
- SELECT gc.cat_id, COUNT(*) AS goods_num FROM ecs_goods_cat AS gc ,ecs_goods AS g
WHERE g.goods_id = gc.goods_id AND g.is_delete = 0 AND g.is_on_sale = 1 GROUP BY gc.cat_id [ RunTime:0.000503s ]
- SELECT goods_id FROM ecs_goods_cat AS g WHERE g.cat_id IN ('50','52','39','46','40','41','42','43','44','45','47','48','35','38','31','32','33','34','30','51','54','57','58','59','60','55','56','61','62','63','36','37','49','20','17','18','19','16','25','27','53','64','65','69','70','67','68','73','66','71','72','74') [ RunTime:0.000305s ]
- SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number FROM ecs_goods AS g,ecs_order_info AS o,ecs_order_goods AS og WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.cat_id IN ('50','52','39','46','40','41','42','43','44','45','47','48','35','38','31','32','33','34','30','51','54','57','58','59','60','55','56','61','62','63','36','37','49','20','17','18','19','16','25','27','53','64','65','69','70','67','68','73','66','71','72','74') OR g.goods_id IN ('53') ) AND g.goods_number > 0 AND og.order_id = o.order_id AND og.goods_id = g.goods_id AND (o.order_status = '1' OR o.order_status = '5') AND (o.pay_status = '2' OR o.pay_status = '1') AND (o.shipping_status = '1' OR o.shipping_status = '2') GROUP BY g.goods_id ORDER BY goods_number DESC, g.goods_id DESC LIMIT 10 [ RunTime:0.000574s ]
- SELECT g.goods_id, g.is_best, g.is_new, g.is_hot, g.is_promote, b.brand_name,g.sort_order FROM ecs_goods AS g LEFT JOIN ecs_brand AS b ON b.brand_id = g.brand_id WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND (g.is_best = 1 OR g.is_new =1 OR g.is_hot = 1) ORDER BY g.sort_order, g.last_update DESC [ RunTime:0.000361s ]
- SELECT library, number FROM ecs_template WHERE theme = 'default' AND filename = 'index' AND remarks='' [ RunTime:0.000296s ]
- SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.shop_price AS org_price, g.promote_price, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price, promote_start_date, promote_end_date, g.goods_brief, g.goods_thumb, g.goods_img, g.show_img, RAND() AS rnd FROM ecs_goods AS g LEFT JOIN ecs_member_price AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' WHERE g.goods_id IN ('185','151','181') ORDER BY g.sort_order, g.last_update DESC [ RunTime:0.000586s ]
- SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.shop_price AS org_price, g.promote_price, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price, promote_start_date, promote_end_date, g.goods_brief, g.goods_thumb, goods_img, b.brand_name, g.is_best, g.is_new, g.is_hot, g.is_promote, RAND() AS rnd FROM ecs_goods AS g LEFT JOIN ecs_brand AS b ON b.brand_id = g.brand_id LEFT JOIN ecs_member_price AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND g.is_promote = 1 AND promote_start_date <= '1660378435' AND promote_end_date >= '1660378435' ORDER BY g.sort_order, g.last_update DESC LIMIT 4 [ RunTime:0.000504s ]
- SELECT g.goods_id, g.goods_name, g.goods_thumb, g.goods_img,IFNULL(mp.user_price, g.shop_price * '1') AS shop_price,
g.shop_price AS org_price, g.market_price, g.promote_price, g.promote_start_date, g.promote_end_date
FROM ecs_goods_article ga
LEFT JOIN ecs_goods AS g ON g.goods_id = ga.goods_id
LEFT JOIN ecs_member_price AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0'
WHERE ga.article_id = '358' AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 [ RunTime:0.000515s ]
- SELECT act_id, act_name, act_type, start_time, end_time FROM ecs_goods_activity WHERE is_finished = 0 AND start_time <= '1660378435' AND end_time >= '1660378435' [ RunTime:0.000453s ]
- SELECT act_id, act_range, act_range_ext, act_name, start_time, end_time FROM ecs_favourable_activity WHERE start_time <= '1660378435' AND end_time >= '1660378435' [ RunTime:0.000404s ]
- select cat_id,parent_id,show_in_nav,is_nav,url from ecs_article_cat where cat_id = 230 [ RunTime:0.000331s ]
- select cat_id,parent_id,show_in_nav,is_nav,url from ecs_article_cat where cat_id = 129 [ RunTime:0.000248s ]
- select add_time from ecs_article where article_id = '358' [ RunTime:0.000383s ]
- select article_id,title from ecs_article where add_time > '1642060800' AND is_open = 1 AND cat_id=230 order by add_time asc LIMIT 1 [ RunTime:0.000227s ]
- select article_id,title from ecs_article where add_time < '1642060800' AND is_open = 1 AND cat_id=230 order by add_time desc LIMIT 1 [ RunTime:0.000214s ]
- SELECT id, number, type FROM ecs_template WHERE filename = 'article' AND type > 0 AND remarks ='' AND theme='default' [ RunTime:0.000355s ]
- select * from ecs_article_cat where tag = 1 and parent_id = 129 order by sort_order limit 6 [ RunTime:0.000301s ]

0.064997s