基本
文件
流程
错误
SQL
调试
- 请求信息 : 2023-03-24 21:39:36 HTTP/1.1 GET : https://www.on-bright-gz.com/mobile/Productlist/index.html?cat_id=69
- 运行时间 : 0.055457s [ 吞吐率：18.03req/s ] 内存消耗：1,155.67kb 文件加载：169
- 查询信息 : 80 queries
- 缓存信息 : 3 reads,3 writes
- 会话信息 : SESSION_ID=12cfe3c2c3f1f60b50cb53555d254b0b
- CONNECT:[ UseTime:0.000686s ] mysql:host=localhost:3306;port=3306;dbname=angbao;charset=utf8
- SHOW FULL COLUMNS FROM `ecs_shop_config` [ RunTime:0.000845s ]
- SELECT `code`,`value` FROM `ecs_shop_config` WHERE `parent_id` > 0 [ RunTime:0.000378s ]
- INSERT INTO angbao.ecs_sessions (sesskey, expiry, ip, data) VALUES ('02037168a15547e8d77d139f7b4d67da', '1679665176', '34.232.63.94', 'a:0:{}') [ RunTime:0.001952s ]
- SELECT * FROM ecs_nav WHERE `type` = 'top' and ifshow = '1' ORDER BY type, vieworder [ RunTime:0.000344s ]
- SELECT * FROM ecs_article_cat WHERE show_in_nav = 1 ORDER BY sort_order ASC [ RunTime:0.000325s ]
- select article_id,cat_id,title from ecs_article where is_open = 1 and cat_id = 118 [ RunTime:0.000307s ]
- select article_id,cat_id,title from ecs_article where is_open = 1 and cat_id = 119 [ RunTime:0.000204s ]
- select article_id,cat_id,title from ecs_article where is_open = 1 and cat_id = 148 [ RunTime:0.000270s ]
- select article_id,cat_id,title from ecs_article where is_open = 1 and cat_id = 27 [ RunTime:0.000237s ]
- select article_id,cat_id,title from ecs_article where is_open = 1 and cat_id = 28 [ RunTime:0.000206s ]
- select article_id,cat_id,title from ecs_article where is_open = 1 and cat_id = 226 [ RunTime:0.000296s ]
- select article_id,cat_id,title from ecs_article where is_open = 1 and cat_id = 232 [ RunTime:0.000264s ]
- select article_id,cat_id,title from ecs_article where is_open = 1 and cat_id = 233 [ RunTime:0.000278s ]
- select article_id,cat_id,title from ecs_article where is_open = 1 and cat_id = 185 [ RunTime:0.000252s ]
- select article_id,cat_id,title from ecs_article where is_open = 1 and cat_id = 177 [ RunTime:0.000206s ]
- select article_id,cat_id,title from ecs_article where is_open = 1 and cat_id = 178 [ RunTime:0.000295s ]
- select article_id,cat_id,title from ecs_article where is_open = 1 and cat_id = 179 [ RunTime:0.000232s ]
- select article_id,cat_id,title from ecs_article where is_open = 1 and cat_id = 186 [ RunTime:0.000228s ]
- select article_id,cat_id,title from ecs_article where is_open = 1 and cat_id = 187 [ RunTime:0.000244s ]
- select article_id,cat_id,title from ecs_article where is_open = 1 and cat_id = 188 [ RunTime:0.000275s ]
- select article_id,cat_id,title from ecs_article where is_open = 1 and cat_id = 206 [ RunTime:0.000224s ]
- select article_id,cat_id,title from ecs_article where is_open = 1 and cat_id = 207 [ RunTime:0.000240s ]
- select article_id,cat_id,title from ecs_article where is_open = 1 and cat_id = 211 [ RunTime:0.000219s ]
- SHOW FULL COLUMNS FROM `ecs_article` [ RunTime:0.000684s ]
- 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.000418s ]
- select * from ecs_category where is_display = 1 order by sort_order asc [ RunTime:0.000393s ]
- 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.000377s ]
- 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.000380s ]
- 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.000293s ]
- SELECT g.goods_id, g.goods_name, g.cat_id, g.goods_img, g.show_img FROM ecs_goods AS g WHERE g.is_display = 1 AND g.is_delete='0' AND g.cat_id IN ('69') ORDER BY g.sort_order asc [ RunTime:0.000307s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '143' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000335s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '146' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000284s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '149' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000362s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '56' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000280s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '141' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000263s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '144' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000253s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '145' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000364s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '345' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000236s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '346' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000265s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '347' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000338s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '349' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000282s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '367' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000267s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '139' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000273s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '67' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000217s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '354' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000214s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '353' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000219s ]
- SELECT g.goods_id, g.goods_name, g.cat_id, g.goods_img, g.show_img FROM ecs_goods AS g WHERE g.is_display = 1 AND g.is_delete='0' AND g.cat_id IN ('70') ORDER BY g.sort_order asc [ RunTime:0.000245s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '134' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000245s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '170' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000216s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '171' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000231s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '135' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000210s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '188' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000208s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '357' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000205s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '358' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000279s ]
- SELECT g.goods_id, g.goods_name, g.cat_id, g.goods_img, g.show_img FROM ecs_goods AS g WHERE g.is_display = 1 AND g.is_delete='0' AND g.cat_id IN ('67') ORDER BY g.sort_order asc [ RunTime:0.000253s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '137' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000232s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '168' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000216s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '351' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000225s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '352' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000218s ]
- SELECT g.goods_id, g.goods_name, g.cat_id, g.goods_img, g.show_img FROM ecs_goods AS g WHERE g.is_display = 1 AND g.is_delete='0' AND g.cat_id IN ('68') ORDER BY g.sort_order asc [ RunTime:0.000234s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '182' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000207s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '153' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000210s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '356' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000214s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '140' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000203s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '183' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000248s ]
- SELECT g.goods_id, g.goods_name, g.cat_id, g.goods_img, g.show_img FROM ecs_goods AS g WHERE g.is_display = 1 AND g.is_delete='0' AND g.cat_id IN ('73') ORDER BY g.sort_order asc [ RunTime:0.000222s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '361' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000203s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '362' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000275s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '363' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000269s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '364' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000215s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '365' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000219s ]
- SELECT g.goods_id, g.goods_name, g.cat_id, g.goods_img, g.show_img FROM ecs_goods AS g WHERE g.is_display = 1 AND g.is_delete='0' AND g.cat_id IN ('66') ORDER BY g.sort_order asc [ RunTime:0.000245s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '350' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000206s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '132' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000249s ]
- SELECT g.goods_id, g.goods_name, g.cat_id, g.goods_img, g.show_img FROM ecs_goods AS g WHERE g.is_display = 1 AND g.is_delete='0' AND g.cat_id IN ('71') ORDER BY g.sort_order asc [ RunTime:0.000282s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '359' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000208s ]
- SELECT g.goods_id, g.goods_name, g.cat_id, g.goods_img, g.show_img FROM ecs_goods AS g WHERE g.is_display = 1 AND g.is_delete='0' AND g.cat_id IN ('72') ORDER BY g.sort_order asc [ RunTime:0.000229s ]
- SELECT img_id, img_url, thumb_url, img_desc,img_original FROM ecs_goods_gallery WHERE goods_id = '360' ORDER BY img_sort asc LIMIT 7 [ RunTime:0.000304s ]
- SELECT * FROM ecs_ad where position_id = '32' and enabled = 1 and start_time <= '1679636376' AND end_time >= '1679636376' ORDER BY ad_id desc [ RunTime:0.000605s ]
0.066098s
