基本
文件
流程
错误
SQL
调试
- 请求信息 : 2022-09-28 07:16:33 HTTP/1.1 GET : https://www.on-bright-gz.com/mobile/Article/detail.html?id=355
- 运行时间 : 0.061930s [ 吞吐率：16.15req/s ] 内存消耗：1,160.95kb 文件加载：169
- 查询信息 : 58 queries
- 缓存信息 : 4 reads,4 writes
- 会话信息 : SESSION_ID=d5249d2ee4bcbb40ba21f915b1d7c86c
- CONNECT:[ UseTime:0.000706s ] mysql:host=localhost:3306;port=3306;dbname=angbao;charset=utf8
- SHOW FULL COLUMNS FROM `ecs_shop_config` [ RunTime:0.000966s ]
- SELECT `code`,`value` FROM `ecs_shop_config` WHERE `parent_id` > 0 [ RunTime:0.000374s ]
- INSERT INTO angbao.ecs_sessions (sesskey, expiry, ip, data) VALUES ('344c06ef22d4273d78636209e40f7674', '1664320593', '100.25.42.211', 'a:0:{}') [ RunTime:0.007767s ]
- SELECT * FROM ecs_nav WHERE `type` = 'top' and ifshow = '1' ORDER BY type, vieworder [ RunTime:0.000400s ]
- SELECT * FROM ecs_article_cat WHERE show_in_nav =1 ORDER BY sort_order ASC [ RunTime:0.000398s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=118 [ RunTime:0.000349s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=119 [ RunTime:0.000259s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=148 [ RunTime:0.000303s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=27 [ RunTime:0.000246s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=28 [ RunTime:0.000278s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=226 [ RunTime:0.000245s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=232 [ RunTime:0.000230s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=185 [ RunTime:0.000285s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=177 [ RunTime:0.000285s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=178 [ RunTime:0.000242s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=179 [ RunTime:0.000262s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=186 [ RunTime:0.000275s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=187 [ RunTime:0.000302s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=188 [ RunTime:0.000243s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=206 [ RunTime:0.000233s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=207 [ RunTime:0.000261s ]
- select article_id,cat_id,title from ecs_article where is_open=1 and cat_id=211 [ RunTime:0.000284s ]
- SHOW FULL COLUMNS FROM `ecs_article` [ RunTime:0.000692s ]
- SELECT `content` FROM `ecs_article` WHERE `article_id` = 289 LIMIT 1 [ RunTime:0.000293s ]
- 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.000330s ]
- 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 = '355'
GROUP BY a.article_id [ RunTime:0.000621s ]
- SHOW FULL COLUMNS FROM `ecs_article_cat` [ RunTime:0.000564s ]
- SELECT `parent_id` FROM `ecs_article_cat` WHERE `cat_id` = 355 LIMIT 1 [ RunTime:0.000344s ]
- SELECT COUNT(*) AS think_count FROM `ecs_article_cat` WHERE `parent_id` = 0 [ RunTime:0.000271s ]
- 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.000377s ]
- SHOW FULL COLUMNS FROM `ecs_category` [ RunTime:0.000685s ]
- SELECT COUNT(*) AS think_count FROM `ecs_category` WHERE `parent_id` = 0 AND `is_show` = 1 [ RunTime:0.000284s ]
- 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.000229s ]
- SELECT COUNT(*) AS think_count FROM `ecs_category` WHERE `parent_id` = 50 AND `is_show` = 1 [ RunTime:0.000234s ]
- 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.000243s ]
- SELECT COUNT(*) AS think_count FROM `ecs_category` WHERE `parent_id` = 52 AND `is_show` = 1 [ RunTime:0.000293s ]
- SELECT COUNT(*) AS think_count FROM `ecs_category` WHERE `parent_id` = 47 AND `is_show` = 1 [ RunTime:0.000316s ]
- 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.000275s ]
- SELECT COUNT(*) AS think_count FROM `ecs_category` WHERE `parent_id` = 48 AND `is_show` = 1 [ RunTime:0.000248s ]
- 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.000266s ]
- 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.000306s ]
- 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.000360s ]
- 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.000335s ]
- 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.000288s ]
- 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.000563s ]
- 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.000441s ]
- SELECT library, number FROM ecs_template WHERE theme = 'default' AND filename = 'index' AND remarks='' [ RunTime:0.000321s ]
- 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.000609s ]
- 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 <= '1664291793' AND promote_end_date >= '1664291793' ORDER BY g.sort_order, g.last_update DESC LIMIT 4 [ RunTime:0.000518s ]
- 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 = '355' AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 [ RunTime:0.000453s ]
- SELECT act_id, act_name, act_type, start_time, end_time FROM ecs_goods_activity WHERE is_finished = 0 AND start_time <= '1664291793' AND end_time >= '1664291793' [ RunTime:0.000442s ]
- SELECT act_id, act_range, act_range_ext, act_name, start_time, end_time FROM ecs_favourable_activity WHERE start_time <= '1664291793' AND end_time >= '1664291793' [ RunTime:0.000357s ]
- select cat_id,parent_id,show_in_nav,is_nav,url from ecs_article_cat where cat_id = 218 [ RunTime:0.000366s ]
- select add_time from ecs_article where article_id = '355' [ RunTime:0.000368s ]
- select article_id,title from ecs_article where add_time > '1623312000' AND is_open = 1 AND cat_id=218 order by add_time asc LIMIT 1 [ RunTime:0.000390s ]
- select article_id,title from ecs_article where add_time < '1623312000' AND is_open = 1 AND cat_id=218 order by add_time desc LIMIT 1 [ RunTime:0.000364s ]
- SELECT id, number, type FROM ecs_template WHERE filename = 'article' AND type > 0 AND remarks ='' AND theme='default' [ RunTime:0.000328s ]
- select * from ecs_article_cat where tag = 1 and parent_id = 218 order by sort_order limit 6 [ RunTime:0.000358s ]
0.073093s
