您好，欢迎来到
金丰正阳商城
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-12-27 02:57:50 HTTP/1.1 GET : http://shop.jfzy-china.com/?id=24&page=0
- 运行时间 : 0.179288s [ 吞吐率：5.58req/s ] 内存消耗：7,092.99kb 文件加载：166
- 查询信息 : 44 queries
- 缓存信息 : 54 reads,9 writes
- 会话信息 : SESSION_ID=e9af992d32cd7d52b243da6019bff54f
- CONNECT:[ UseTime:0.000456s ] mysql:host=127.0.0.1;port=3306;dbname=shop_jfzy_china_;charset=utf8mb4
- SHOW FULL COLUMNS FROM `sxo_navigation` [ RunTime:0.000622s ]
- 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.000388s ]
- 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.000366s ]
- 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.000293s ]
- 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.000305s ]
- SHOW FULL COLUMNS FROM `sxo_quick_nav` [ RunTime:0.000535s ]
- 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.000275s ]
- SHOW FULL COLUMNS FROM `sxo_goods_category` [ RunTime:0.000544s ]
- 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.000319s ]
- 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.000270s ]
- 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.000251s ]
- 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.000181s ]
- 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.000164s ]
- 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.000181s ]
- 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.000176s ]
- 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.000162s ]
- SHOW FULL COLUMNS FROM `sxo_slide` [ RunTime:0.000534s ]
- 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.000249s ]
- SHOW FULL COLUMNS FROM `sxo_article` [ RunTime:0.000580s ]
- 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.000224s ]
- SHOW FULL COLUMNS FROM `sxo_article_category` [ RunTime:0.000391s ]
- SELECT `name`,`id` FROM `sxo_article_category` WHERE `id` = 24 [ RunTime:0.000175s ]
- 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.000313s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 3 AND `is_enable` = 1 [ RunTime:0.000190s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (236,237,238,239,240) AND `is_enable` = 1 [ RunTime:0.000188s ]
- SHOW FULL COLUMNS FROM `sxo_goods` [ RunTime:0.000619s ]
- 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.000504s ]
- 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.000245s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 1 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` = '1' AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 8 [ RunTime:0.001584s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 52 AND `is_enable` = 1 [ RunTime:0.000170s ]
- 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.000213s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 54 AND `is_enable` = 1 [ RunTime:0.000145s ]
- 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.000221s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 55 AND `is_enable` = 1 [ RunTime:0.000164s ]
- 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.000199s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 56 AND `is_enable` = 1 [ RunTime:0.000134s ]
- 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.000234s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 57 AND `is_enable` = 1 [ RunTime:0.000134s ]
- 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.000201s ]
- 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.001004s ]
- SHOW FULL COLUMNS FROM `sxo_link` [ RunTime:0.000543s ]
- SELECT * FROM `sxo_link` WHERE `is_enable` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000205s ]
0.188223s
