基本
文件
流程
錯(cuò)誤
SQL
調(diào)試
- 請求信息 : 2024-11-27 18:53:00 HTTP/1.1 GET : http://www.bbbcw.com/business/product/189/0-0-0-0-0-0-3.html
- 運(yùn)行時(shí)間 : 0.067268s [ 吞吐率:14.87req/s ] 內(nèi)存消耗:4,590.12kb 文件加載:159
- 查詢信息 : 15 queries
- 緩存信息 : 0 reads,0 writes
- 會話信息 : SESSION_ID=0b280867bed24cb42dea93caace98c7a
- CONNECT:[ UseTime:0.001132s ] mysql:host=rm-2ze549cs5t9yk8dn9.mysql.rds.aliyuncs.com;port=3306;dbname=public;charset=utf8
- SHOW FULL COLUMNS FROM `xkyx_shopapp` [ RunTime:0.001408s ]
- SELECT `id`,`title`,`pc_bg`,`first_city`,`secondary_city`,`city`,`key`,`shop_code` FROM `xkyx_shopapp` WHERE `id` = 189 LIMIT 1 [ RunTime:0.000736s ]
- SHOW FULL COLUMNS FROM `xkyx_region` [ RunTime:0.000828s ]
- SELECT `name` FROM `xkyx_region` WHERE `id` IN (1,45052,41) ORDER BY FIELD(id,1,45052,41) [ RunTime:0.000551s ]
- SHOW FULL COLUMNS FROM `xkyx_goods` [ RunTime:0.000823s ]
- SELECT COUNT(`id`) AS think_count FROM `xkyx_goods` WHERE `sid` = 189 AND `use_shop` = 1 LIMIT 1 [ RunTime:0.000886s ]
- SHOW FULL COLUMNS FROM `xkyx_exashop` [ RunTime:0.000762s ]
- SELECT `capital`,`person`,`licadd`,`range`,`credit`,`registration_authority`,`enterprise_scale`,`taxpayer_qualification`,`enterprise_name`,`establishment_time`,`registration_status` FROM `xkyx_exashop` WHERE `sid` = 189 LIMIT 1 [ RunTime:0.000683s ]
- SELECT `b`.`id`,`b`.`title` FROM `xkyx_goods` `g` INNER JOIN `xkyx_brand` `b` ON `g`.`brand`=`b`.`id` WHERE `g`.`sid` = '189' GROUP BY `g`.`brand` LIMIT 5 [ RunTime:0.001092s ]
- SELECT `g_c` FROM `xkyx_goods` WHERE `sid` = 189 GROUP BY `g_c` [ RunTime:0.000918s ]
- SHOW FULL COLUMNS FROM `xkyx_classify` [ RunTime:0.000544s ]
- SELECT * FROM `xkyx_classify` WHERE `id` IN (1,3,12) [ RunTime:0.000452s ]
- SELECT `b`.`title`,`b`.`id` FROM `xkyx_goods` `g` INNER JOIN `xkyx_brand` `b` ON `g`.`brand`=`b`.`id` WHERE `g`.`sid` = '189' GROUP BY `brand` [ RunTime:0.001125s ]
- SELECT COUNT(*) AS think_count FROM `xkyx_goods` `g` LEFT JOIN `xkyx_brand` `b` ON `g`.`brand`=`b`.`id` LEFT JOIN `xkyx_br_address` `br` ON `br`.`id`=`b`.`address` LEFT JOIN `xkyx_picture` `pic` ON `pic`.`id`=`g`.`pic` INNER JOIN `xkyx_goods_price` `gp` ON `g`.`id`=`gp`.`goods_id` INNER JOIN `xkyx_price` `p` ON `p`.`id`=`gp`.`price_id` INNER JOIN `xkyx_shopapp` `s` ON `g`.`sid`=`s`.`id` WHERE `g`.`sid` = '189' AND `g`.`use_shop` = '1' AND `p`.`default` = '1' LIMIT 1 [ RunTime:0.005678s ]
- SELECT `g`.`id`,`g`.`title`,`g`.`sid`,`g`.`brand`,`pic`.`path`,`g`.`mod`,`g`.`meter`,b.title as brandTitle,gp.value as price,s.title as shopTitle FROM `xkyx_goods` `g` LEFT JOIN `xkyx_brand` `b` ON `g`.`brand`=`b`.`id` LEFT JOIN `xkyx_br_address` `br` ON `br`.`id`=`b`.`address` LEFT JOIN `xkyx_picture` `pic` ON `pic`.`id`=`g`.`pic` INNER JOIN `xkyx_goods_price` `gp` ON `g`.`id`=`gp`.`goods_id` INNER JOIN `xkyx_price` `p` ON `p`.`id`=`gp`.`price_id` INNER JOIN `xkyx_shopapp` `s` ON `g`.`sid`=`s`.`id` WHERE `g`.`sid` = '189' AND `g`.`use_shop` = '1' AND `p`.`default` = '1' ORDER BY g.id desc LIMIT 36,18 [ RunTime:0.002066s ]