您好,欢迎来到
金丰正阳商城
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-12-27 02:37:58 HTTP/1.1 GET : http://shop.jfzy-china.com/?id=24&page=1
- 运行时间 : 0.182759s [ 吞吐率:5.47req/s ] 内存消耗:7,093.05kb 文件加载:166
- 查询信息 : 44 queries
- 缓存信息 : 54 reads,9 writes
- 会话信息 : SESSION_ID=0126925f987c3142b7ca56a5deab0f46
- CONNECT:[ UseTime:0.000449s ] mysql:host=127.0.0.1;port=3306;dbname=shop_jfzy_china_;charset=utf8mb4
- SHOW FULL COLUMNS FROM `sxo_navigation` [ RunTime:0.000640s ]
- 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.000400s ]
- 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.000312s ]
- 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.000278s ]
- 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.000358s ]
- SHOW FULL COLUMNS FROM `sxo_quick_nav` [ RunTime:0.000516s ]
- 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.000247s ]
- SHOW FULL COLUMNS FROM `sxo_goods_category` [ RunTime:0.000555s ]
- 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.000306s ]
- 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.000240s ]
- 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.000280s ]
- 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.000278s ]
- 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.000194s ]
- 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.000192s ]
- 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.000232s ]
- 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.000220s ]
- 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.000230s ]
- SHOW FULL COLUMNS FROM `sxo_slide` [ RunTime:0.000559s ]
- 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.000262s ]
- SHOW FULL COLUMNS FROM `sxo_article` [ RunTime:0.000556s ]
- 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.000249s ]
- SHOW FULL COLUMNS FROM `sxo_article_category` [ RunTime:0.000469s ]
- SELECT `name`,`id` FROM `sxo_article_category` WHERE `id` = 24 [ 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 `pid` = 0 AND `is_home_recommended` = 1 AND `is_enable` = 1 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000326s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 3 AND `is_enable` = 1 [ RunTime:0.000195s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (236,237,238,239,240) AND `is_enable` = 1 [ RunTime:0.000203s ]
- SHOW FULL COLUMNS FROM `sxo_goods` [ RunTime:0.000642s ]
- 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.000298s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 1 AND `is_enable` = 1 [ RunTime:0.000159s ]
- 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.000309s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 52 AND `is_enable` = 1 [ RunTime:0.000163s ]
- 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.000225s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 54 AND `is_enable` = 1 [ RunTime:0.000172s ]
- 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.000281s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 55 AND `is_enable` = 1 [ RunTime:0.000142s ]
- 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.000189s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 56 AND `is_enable` = 1 [ RunTime:0.000150s ]
- 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.000248s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 57 AND `is_enable` = 1 [ RunTime:0.000160s ]
- 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.000202s ]
- 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.001025s ]
- SHOW FULL COLUMNS FROM `sxo_link` [ RunTime:0.000529s ]
- SELECT * FROM `sxo_link` WHERE `is_enable` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000215s ]
0.191809s