您好，欢迎来到
虾啦啦
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2022-11-29 04:41:08 HTTP/1.1 GET : https://www.xialala.cc/
- 运行时间 : 0.176899s [ 吞吐率：5.65req/s ] 内存消耗：1,858.07kb 文件加载：170
- 查询信息 : 100 queries
- 缓存信息 : 58 reads,9 writes
- 会话信息 : SESSION_ID=941516b652b1d9e42fbabe1701647fd8
- CONNECT:[ UseTime:0.000402s ] mysql:host=127.0.0.1;port=3306;dbname=www_xialala_cc;charset=utf8mb4
- SHOW FULL COLUMNS FROM `xll_navigation` [ RunTime:0.000529s ]
- SELECT `id`,`pid`,`name`,`url`,`value`,`data_type`,`is_new_window_open` FROM `xll_navigation` WHERE `nav_type` = 'header' AND `is_show` = 1 AND `pid` = 0 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000357s ]
- SELECT `id`,`pid`,`name`,`url`,`value`,`data_type`,`is_new_window_open` FROM `xll_navigation` WHERE `nav_type` = 'header' AND `is_show` = 1 AND `pid` = 54 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000238s ]
- SELECT `id`,`pid`,`name`,`url`,`value`,`data_type`,`is_new_window_open` FROM `xll_navigation` WHERE `nav_type` = 'footer' AND `is_show` = 1 AND `pid` = 0 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000262s ]
- SELECT `id`,`pid`,`name`,`url`,`value`,`data_type`,`is_new_window_open` FROM `xll_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.000291s ]
- SHOW FULL COLUMNS FROM `xll_quick_nav` [ RunTime:0.000468s ]
- SELECT `id`,`name`,`images_url`,`event_value`,`event_type`,`bg_color` FROM `xll_quick_nav` WHERE `platform` = 'pc' AND `is_enable` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000286s ]
- SHOW FULL COLUMNS FROM `xll_goods_category` [ RunTime:0.000526s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `pid` = 0 AND `is_enable` = 1 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000371s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` = 304 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000523s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` IN (312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,926,928,930,931,932,934,935,936,937,938,939,941,942,943,945,946,947,948,949,950) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000570s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` = 305 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000357s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` IN (336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000329s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` = 306 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000332s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` IN (359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,922) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000317s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` = 307 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000295s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` IN (375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000340s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` = 308 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000337s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` IN (391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000332s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` = 309 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000332s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` IN (408,409,410,411,412,413,414,415,416,417,418,419) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000286s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` = 310 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000330s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` IN (420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000312s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` = 311 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 `xll_goods_category` WHERE `is_enable` = 1 AND `pid` IN (438,439,440,441,442,443,444,445,446,447,448,449,450,451) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000294s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` = 188 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000266s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` IN (193,194,195,196,197,198) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000258s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` = 189 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000237s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` IN (199,200,201,202) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000225s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` = 190 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000286s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` IN (203,204,205,206,207,208,209,210) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000351s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` = 191 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000290s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` IN (211,212,213,214,215,216,217,218,219) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000252s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` = 192 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000326s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` IN (220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235) 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 `xll_goods_category` WHERE `is_enable` = 1 AND `pid` = 924 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000227s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` = 925 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000190s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` = 951 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000203s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `is_enable` = 1 AND `pid` = 952 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000222s ]
- SHOW FULL COLUMNS FROM `xll_slide` [ RunTime:0.000639s ]
- SELECT `name`,`images_url`,`event_value`,`event_type`,`bg_color` FROM `xll_slide` WHERE `platform` = 'pc' AND `is_enable` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000346s ]
- SHOW FULL COLUMNS FROM `xll_article` [ RunTime:0.000538s ]
- SELECT `id`,`title`,`title_color`,`article_category_id` FROM `xll_article` WHERE `is_enable` = 1 AND `is_home_recommended` = 1 ORDER BY `id` DESC LIMIT 0,9 [ RunTime:0.000312s ]
- SHOW FULL COLUMNS FROM `xll_article_category` [ RunTime:0.000392s ]
- SELECT `name`,`id` FROM `xll_article_category` WHERE `id` IN (24,18,17) [ RunTime:0.000229s ]
- SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `xll_goods_category` WHERE `pid` = 0 AND `is_home_recommended` = 1 AND `is_enable` = 1 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000403s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` = 304 AND `is_enable` = 1 [ RunTime:0.000398s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` IN (312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,926,928,930,931,932,934,935,936,937,938,939,941,942,943,945,946,947,948,949,950) AND `is_enable` = 1 [ RunTime:0.000538s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` IN (927,929,933,940,944) AND `is_enable` = 1 [ RunTime:0.000279s ]
- SHOW FULL COLUMNS FROM `xll_goods` [ RunTime:0.000657s ]
- SELECT `g`.`id` FROM `xll_goods` `g` INNER JOIN `xll_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('304','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','926','928','930','931','932','934','935','936','937','938','939','941','942','943','945','946','947','948','949','950','927','929','933','940','944') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,8 [ RunTime:0.000632s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` = 305 AND `is_enable` = 1 [ RunTime:0.000308s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` IN (336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358) AND `is_enable` = 1 [ RunTime:0.000350s ]
- SELECT `g`.`id` FROM `xll_goods` `g` INNER JOIN `xll_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('305','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','353','354','355','356','357','358') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,8 [ RunTime:0.000452s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` = 306 AND `is_enable` = 1 [ RunTime:0.000331s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` IN (359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,922) AND `is_enable` = 1 [ RunTime:0.000318s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` = 923 AND `is_enable` = 1 [ RunTime:0.000202s ]
- SELECT `g`.`id` FROM `xll_goods` `g` INNER JOIN `xll_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('306','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','922','923') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,8 [ RunTime:0.000390s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` = 307 AND `is_enable` = 1 [ RunTime:0.000256s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` IN (375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390) AND `is_enable` = 1 [ RunTime:0.000261s ]
- SELECT `g`.`id` FROM `xll_goods` `g` INNER JOIN `xll_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('307','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,8 [ RunTime:0.000332s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` = 308 AND `is_enable` = 1 [ RunTime:0.000258s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` IN (391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407) AND `is_enable` = 1 [ RunTime:0.000262s ]
- SELECT `g`.`id` FROM `xll_goods` `g` INNER JOIN `xll_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('308','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,8 [ RunTime:0.000361s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` = 309 AND `is_enable` = 1 [ RunTime:0.000255s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` IN (408,409,410,411,412,413,414,415,416,417,418,419) AND `is_enable` = 1 [ RunTime:0.000228s ]
- SELECT `g`.`id` FROM `xll_goods` `g` INNER JOIN `xll_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('309','408','409','410','411','412','413','414','415','416','417','418','419') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,8 [ RunTime:0.000320s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` = 310 AND `is_enable` = 1 [ RunTime:0.000271s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` IN (420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437) AND `is_enable` = 1 [ RunTime:0.000281s ]
- SELECT `g`.`id` FROM `xll_goods` `g` INNER JOIN `xll_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('310','420','421','422','423','424','425','426','427','428','429','430','431','432','433','434','435','436','437') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,8 [ RunTime:0.000340s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` = 311 AND `is_enable` = 1 [ RunTime:0.000276s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` IN (438,439,440,441,442,443,444,445,446,447,448,449,450,451) AND `is_enable` = 1 [ RunTime:0.000234s ]
- SELECT `g`.`id` FROM `xll_goods` `g` INNER JOIN `xll_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('311','438','439','440','441','442','443','444','445','446','447','448','449','450','451') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,8 [ RunTime:0.000315s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` = 188 AND `is_enable` = 1 [ RunTime:0.000212s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` IN (193,194,195,196,197,198) AND `is_enable` = 1 [ RunTime:0.000203s ]
- SELECT `g`.`id` FROM `xll_goods` `g` INNER JOIN `xll_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('188','193','194','195','196','197','198') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,8 [ RunTime:0.000310s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` = 189 AND `is_enable` = 1 [ RunTime:0.000236s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` IN (199,200,201,202) AND `is_enable` = 1 [ RunTime:0.000217s ]
- SELECT `g`.`id` FROM `xll_goods` `g` INNER JOIN `xll_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('189','199','200','201','202') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,8 [ RunTime:0.000268s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` = 190 AND `is_enable` = 1 [ RunTime:0.000218s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` IN (203,204,205,206,207,208,209,210) AND `is_enable` = 1 [ RunTime:0.000229s ]
- SELECT `g`.`id` FROM `xll_goods` `g` INNER JOIN `xll_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('190','203','204','205','206','207','208','209','210') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,8 [ RunTime:0.000283s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` = 191 AND `is_enable` = 1 [ RunTime:0.000218s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` IN (211,212,213,214,215,216,217,218,219) AND `is_enable` = 1 [ RunTime:0.000239s ]
- SELECT `g`.`id` FROM `xll_goods` `g` INNER JOIN `xll_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('191','211','212','213','214','215','216','217','218','219') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,8 [ RunTime:0.000284s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` = 192 AND `is_enable` = 1 [ RunTime:0.000224s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` IN (220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235) AND `is_enable` = 1 [ RunTime:0.000265s ]
- SELECT `g`.`id` FROM `xll_goods` `g` INNER JOIN `xll_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('192','220','221','222','223','224','225','226','227','228','229','230','231','232','233','234','235') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,8 [ RunTime:0.000350s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` = 924 AND `is_enable` = 1 [ RunTime:0.000180s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` = 925 AND `is_enable` = 1 [ RunTime:0.000168s ]
- SELECT `g`.`id` FROM `xll_goods` `g` INNER JOIN `xll_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('924','925') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,8 [ RunTime:0.000245s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` = 951 AND `is_enable` = 1 [ RunTime:0.000184s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` = 952 AND `is_enable` = 1 [ RunTime:0.000204s ]
- SELECT `id` FROM `xll_goods_category` WHERE `pid` = 953 AND `is_enable` = 1 [ RunTime:0.000163s ]
- SELECT `g`.`id` FROM `xll_goods` `g` INNER JOIN `xll_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `gci`.`category_id` IN ('951','952','953') AND `g`.`is_shelves` = '1' AND `g`.`is_delete_time` = '0' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 0,8 [ RunTime:0.000280s ]
- SELECT * FROM `xll_goods` WHERE `id` IN (890,889,888,887,886,885,884,883,156,145,401) AND `is_shelves` = 1 ORDER BY `id` DESC [ RunTime:0.000721s ]
- SHOW FULL COLUMNS FROM `xll_brand` [ RunTime:0.000385s ]
- SELECT `name`,`id` FROM `xll_brand` WHERE `id` IN (10,7) [ RunTime:0.000178s ]
- SHOW FULL COLUMNS FROM `xll_link` [ RunTime:0.000499s ]
- SELECT * FROM `xll_link` WHERE `is_enable` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000228s ]
0.185407s
