您好，欢迎来到
金丰正阳商城
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-12-27 02:30:52 HTTP/1.1 GET : http://shop.jfzy-china.com/?id=24&page=2
- 运行时间 : 0.181541s [ 吞吐率：5.51req/s ] 内存消耗：7,092.88kb 文件加载：166
- 查询信息 : 44 queries
- 缓存信息 : 54 reads,9 writes
- 会话信息 : SESSION_ID=e182e81767f9be170a7f947326b577ad
- CONNECT:[ UseTime:0.000318s ] mysql:host=127.0.0.1;port=3306;dbname=shop_jfzy_china_;charset=utf8mb4
- SHOW FULL COLUMNS FROM `sxo_navigation` [ RunTime:0.000616s ]
- SELECT `id`,`pid`,`name`,`url`,`value`,`data_type`,`is_new_window_open` FROM `sxo_navigation` WHERE `nav_type` = 'header' AND `is_show` = 1 AND `pid` = 0 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000390s ]
- SELECT `id`,`pid`,`name`,`url`,`value`,`data_type`,`is_new_window_open` FROM `sxo_navigation` WHERE `nav_type` = 'header' AND `is_show` = 1 AND `pid` IN (56,57,58,59,60,61,62,63) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000303s ]
- SELECT `id`,`pid`,`name`,`url`,`value`,`data_type`,`is_new_window_open` FROM `sxo_navigation` WHERE `nav_type` = 'footer' AND `is_show` = 1 AND `pid` = 0 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000257s ]
- SELECT `id`,`pid`,`name`,`url`,`value`,`data_type`,`is_new_window_open` FROM `sxo_navigation` WHERE `nav_type` = 'footer' AND `is_show` = 1 AND `pid` IN (34,35,36,37,55) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000311s ]
- SHOW FULL COLUMNS FROM `sxo_quick_nav` [ RunTime:0.000527s ]
- SELECT `id`,`name`,`images_url`,`event_value`,`event_type`,`bg_color` FROM `sxo_quick_nav` WHERE `platform` = 'pc' AND `is_enable` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000272s ]
- SHOW FULL COLUMNS FROM `sxo_goods_category` [ RunTime:0.000684s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `pid` = 0 AND `is_enable` = 1 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000272s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 3 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000209s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` IN (236,237,238,239,240) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000209s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 1 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000180s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 52 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000170s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 54 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000161s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 55 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000167s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 56 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000265s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 57 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000216s ]
- SHOW FULL COLUMNS FROM `sxo_slide` [ RunTime:0.000647s ]
- SELECT `name`,`images_url`,`event_value`,`event_type`,`bg_color` FROM `sxo_slide` WHERE `platform` = 'pc' AND `is_enable` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000322s ]
- SHOW FULL COLUMNS FROM `sxo_article` [ RunTime:0.000601s ]
- SELECT `id`,`title`,`title_color`,`article_category_id` FROM `sxo_article` WHERE `is_enable` = 1 AND `is_home_recommended` = 1 ORDER BY `id` DESC LIMIT 0,9 [ RunTime:0.000244s ]
- SHOW FULL COLUMNS FROM `sxo_article_category` [ RunTime:0.000404s ]
- SELECT `name`,`id` FROM `sxo_article_category` WHERE `id` = 24 [ RunTime:0.000178s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `pid` = 0 AND `is_home_recommended` = 1 AND `is_enable` = 1 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000298s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 3 AND `is_enable` = 1 [ RunTime:0.000255s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (236,237,238,239,240) AND `is_enable` = 1 [ RunTime:0.000213s ]
- SHOW FULL COLUMNS FROM `sxo_goods` [ RunTime:0.000699s ]
- SELECT `g`.`id` FROM `sxo_goods` `g` INNER JOIN `sxo_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('3','236','237','238','239','240') AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 8 [ RunTime:0.000537s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `id` IN (236,237,238,239,240) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000272s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 1 AND `is_enable` = 1 [ RunTime:0.000151s ]
- SELECT `g`.`id` FROM `sxo_goods` `g` INNER JOIN `sxo_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` = '1' AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 8 [ RunTime:0.000297s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 52 AND `is_enable` = 1 [ RunTime:0.000176s ]
- SELECT `g`.`id` FROM `sxo_goods` `g` INNER JOIN `sxo_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` = '52' AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 8 [ RunTime:0.000242s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 54 AND `is_enable` = 1 [ RunTime:0.000154s ]
- SELECT `g`.`id` FROM `sxo_goods` `g` INNER JOIN `sxo_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` = '54' AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 8 [ RunTime:0.000336s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 55 AND `is_enable` = 1 [ RunTime:0.000176s ]
- SELECT `g`.`id` FROM `sxo_goods` `g` INNER JOIN `sxo_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` = '55' AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 8 [ RunTime:0.000223s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 56 AND `is_enable` = 1 [ RunTime:0.000162s ]
- SELECT `g`.`id` FROM `sxo_goods` `g` INNER JOIN `sxo_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` = '56' AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 8 [ RunTime:0.000250s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 57 AND `is_enable` = 1 [ RunTime:0.000165s ]
- SELECT `g`.`id` FROM `sxo_goods` `g` INNER JOIN `sxo_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` = '57' AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 8 [ RunTime:0.000225s ]
- SELECT * FROM `sxo_goods` WHERE `id` IN (73,72,71,70,69,68,67,66,115,112,111,110,109,108,107,106,76,75,74,114,96,95,94,93,92,91,90,87,86,85,84,83,82,81,80,113) AND `is_shelves` = 1 ORDER BY `id` DESC [ RunTime:0.001048s ]
- SHOW FULL COLUMNS FROM `sxo_link` [ RunTime:0.000602s ]
- SELECT * FROM `sxo_link` WHERE `is_enable` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000216s ]
0.190406s
