您好,欢迎来到
外包时代商城
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-10-06 11:19:49 HTTP/1.1 GET : http://www.wbsd.cn/
- 运行时间 : 0.307939s [ 吞吐率:3.25req/s ] 内存消耗:3,915.44kb 文件加载:171
- 查询信息 : 83 queries
- 缓存信息 : 52 reads,10 writes
- 会话信息 : SESSION_ID=4b1cf9966bd8b61fa4288c4e281a0d74
- CONNECT:[ UseTime:0.011607s ] mysql:host=127.0.0.1;port=3306;dbname=wbsd801;charset=utf8mb4
- SHOW FULL COLUMNS FROM `sxo_navigation` [ RunTime:0.001063s ]
- 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.000199s ]
- 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 (54,17) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000186s ]
- 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.000216s ]
- 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.000257s ]
- SHOW FULL COLUMNS FROM `sxo_quick_nav` [ RunTime:0.000653s ]
- 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.000220s ]
- SHOW FULL COLUMNS FROM `sxo_goods_category` [ RunTime:0.000766s ]
- 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.000224s ]
- 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.000277s ]
- 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 (58,59,60,61,62,63,64,65,66,67,102) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000365s ]
- 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.000257s ]
- 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 (872,873,874,875,876,896,899) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000226s ]
- 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.000262s ]
- 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,241,242,243,244,245) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000456s ]
- 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` = 2 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` IN (304,305,306,307,308,309,310,311,188,189,190,191,192) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000400s ]
- 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` = 7 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` IN (908,452,453,454,455,456,457,458) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000262s ]
- 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.000242s ]
- 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 (512,513,514,515,516,517,518,519,520,511) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000254s ]
- 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` = 53 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000263s ]
- 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 (572,573,574,575,576,577,578,579) 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 `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 54 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` IN (639,640,641,642,643,644,645,646) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000328s ]
- 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.000222s ]
- 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 (736,737,738,739,740,741,742,743,744,745,746,747) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000297s ]
- 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.000204s ]
- 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 (798,799,800,801,802,803,804,805) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000331s ]
- SHOW FULL COLUMNS FROM `sxo_slide` [ RunTime:0.001068s ]
- 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.000236s ]
- SHOW FULL COLUMNS FROM `sxo_app_home_nav` [ RunTime:0.000881s ]
- SELECT `id`,`name`,`images_url`,`event_value`,`event_type`,`bg_color`,`is_need_login` FROM `sxo_app_home_nav` WHERE `platform` = 'pc' AND `is_enable` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000239s ]
- SHOW FULL COLUMNS FROM `sxo_article` [ RunTime:0.001132s ]
- 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.001167s ]
- SHOW FULL COLUMNS FROM `sxo_article_category` [ RunTime:0.000768s ]
- SELECT `name`,`id` FROM `sxo_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 `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.000286s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 1 AND `is_enable` = 1 [ RunTime:0.000256s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (58,59,60,61,62,63,64,65,66,67,102) AND `is_enable` = 1 [ RunTime:0.000263s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (68,69,70,904,905,906,907,914,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,90,91,92,93,94,95,96,97,98,99,100,101) AND `is_enable` = 1 [ RunTime:0.000341s ]
- SHOW FULL COLUMNS FROM `sxo_goods` [ RunTime:0.001179s ]
- 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 ('1','58','59','60','61','62','63','64','65','66','67','102','68','69','70','904','905','906','907','914','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','175','176','177','178','179','180','181','182','183','184','185','186','187','90','91','92','93','94','95','96','97','98','99','100','101') AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 40 [ RunTime:0.000385s ]
- 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 (58,59,60,61,62,63) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000263s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 57 AND `is_enable` = 1 [ RunTime:0.000224s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (872,873,874,875,876,896,899) AND `is_enable` = 1 [ RunTime:0.000232s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (877,878,879,880,916,881,882,883,884,885,886,887,888,889,890,891,892,897,898,902,903,910,911,912,913,900) AND `is_enable` = 1 [ RunTime:0.000233s ]
- 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 ('57','872','873','874','875','876','896','899','877','878','879','880','916','881','882','883','884','885','886','887','888','889','890','891','892','897','898','902','903','910','911','912','913','900') AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 40 [ RunTime:0.000278s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 3 AND `is_enable` = 1 [ RunTime:0.000225s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (236,237,238,239,240,241,242,243,244,245) AND `is_enable` = 1 [ RunTime:0.000184s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303) AND `is_enable` = 1 [ RunTime:0.000254s ]
- 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','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','267','268','269','270','271','272','273','274','275','276','277','278','279','280','281','282','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303') AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 40 [ RunTime:0.000261s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 2 AND `is_enable` = 1 [ RunTime:0.000208s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (188,189,190,191,192,304,305,306,307,308,309,310,311) AND `is_enable` = 1 [ RunTime:0.000295s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451) AND `is_enable` = 1 [ RunTime:0.000462s ]
- 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 ('2','188','189','190','191','192','304','305','306','307','308','309','310','311','193','194','195','196','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','222','223','224','225','226','227','228','229','230','231','232','233','234','235','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','353','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412','413','414','415','416','417','418','419','420','421','422','423','424','425','426','427','428','429','430','431','432','433','434','435','436','437','438','439','440','441','442','443','444','445','446','447','448','449','450','451') AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 40 [ RunTime:0.000368s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 7 AND `is_enable` = 1 [ RunTime:0.000219s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (452,453,454,455,456,457,458,908) AND `is_enable` = 1 [ RunTime:0.000231s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,909,915) AND `is_enable` = 1 [ RunTime:0.000288s ]
- 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 ('7','452','453','454','455','456','457','458','908','459','460','461','462','463','464','465','466','467','468','469','470','471','472','473','474','475','476','477','478','479','480','481','482','483','484','485','486','487','488','489','490','491','492','493','494','495','496','497','498','499','500','501','502','503','504','505','506','507','508','509','510','909','915') AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 40 [ RunTime:0.000244s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 52 AND `is_enable` = 1 [ RunTime:0.000206s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (511,512,513,514,515,516,517,518,519,520) AND `is_enable` = 1 [ RunTime:0.000214s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571) AND `is_enable` = 1 [ RunTime:0.000243s ]
- 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 ('52','511','512','513','514','515','516','517','518','519','520','521','522','523','524','525','526','527','528','529','530','531','532','533','534','535','536','537','538','539','540','541','542','543','544','545','546','547','548','549','550','551','552','553','554','555','556','557','558','559','560','561','562','563','564','565','566','567','568','569','570','571') AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 40 [ RunTime:0.000235s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 53 AND `is_enable` = 1 [ RunTime:0.000205s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (572,573,574,575,576,577,578,579) AND `is_enable` = 1 [ RunTime:0.000224s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,901,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638) AND `is_enable` = 1 [ RunTime:0.000255s ]
- 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 ('53','572','573','574','575','576','577','578','579','580','581','582','583','584','585','586','587','588','589','590','591','592','593','594','595','596','597','598','599','600','601','602','603','604','605','901','606','607','608','609','610','611','612','613','614','615','616','617','618','619','620','621','622','623','624','625','626','627','628','629','630','631','632','633','634','635','636','637','638') AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 40 [ RunTime:0.000271s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 54 AND `is_enable` = 1 [ RunTime:0.000222s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (639,640,641,642,643,644,645,646) AND `is_enable` = 1 [ RunTime:0.000252s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,689,690,691,692,693,694,695,696,697,698,699,700,701,702,703,704,705,706,707,708,709,710,711,712,713,714,715,716,717,718,719,720,721,722,723,724,725,726,727,728,729,730,731,732,733,734,735) AND `is_enable` = 1 [ RunTime:0.000267s ]
- 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 ('54','639','640','641','642','643','644','645','646','647','648','649','650','651','652','653','654','655','656','657','658','659','660','661','662','663','664','665','666','667','668','669','670','671','672','673','674','675','676','677','678','679','680','681','682','683','684','685','686','687','688','689','690','691','692','693','694','695','696','697','698','699','700','701','702','703','704','705','706','707','708','709','710','711','712','713','714','715','716','717','718','719','720','721','722','723','724','725','726','727','728','729','730','731','732','733','734','735') AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 40 [ RunTime:0.000292s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 55 AND `is_enable` = 1 [ RunTime:0.000199s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (736,737,738,739,740,741,742,743,744,745,746,747) AND `is_enable` = 1 [ RunTime:0.000224s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (748,749,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,778,779,780,781,782,783,784,785,786,787,788,789,790,791,792,793,794,795,796,797) AND `is_enable` = 1 [ RunTime:0.000239s ]
- 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 ('55','736','737','738','739','740','741','742','743','744','745','746','747','748','749','750','751','752','753','754','755','756','757','758','759','760','761','762','763','764','765','766','767','768','769','770','771','772','773','774','775','776','777','778','779','780','781','782','783','784','785','786','787','788','789','790','791','792','793','794','795','796','797') AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 40 [ RunTime:0.000399s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 56 AND `is_enable` = 1 [ RunTime:0.000270s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (798,799,800,801,802,803,804,805) AND `is_enable` = 1 [ RunTime:0.000254s ]
- SELECT `id` FROM `sxo_goods_category` WHERE `pid` IN (806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,868,869,870,871) AND `is_enable` = 1 [ RunTime:0.000335s ]
- 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 ('56','798','799','800','801','802','803','804','805','806','807','808','809','810','811','812','813','814','815','816','817','818','819','820','821','822','823','824','825','826','827','828','829','830','831','832','833','834','835','836','837','838','839','840','841','842','843','844','845','846','847','848','849','850','851','852','853','854','855','856','857','858','859','860','861','862','863','864','865','866','867','868','869','870','871') AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 40 [ RunTime:0.000297s ]
- SELECT * FROM `sxo_goods` WHERE `id` IN (302,301,299,298,297,296,290,289,288,282,281,280,279,278,277,276,274,273,266,259,250,249,248,247,246,245,244,243,242,241,240,239,238,237,236,235,234,233,232,231,292,291,284,275,272,271,270,269,268,267,265,264,263,262,261,260,258,257,256,255,254,253,252,251,228,216,215,214,213,212,211,210,131,89,88,87,86,85,84,83,295,294,293,287,286,186,185,184,183,182,181,180,179,178,177,176,175,174,173,172,171,170,169,168,167,166,165,164,163,162,161,160,159,158,157,156,155,154,153,152,200,199,198,197,196,195,136,94,93,92,91,44,35,283,192,31,300,285,43,219,218,217,90) AND `is_shelves` = 1 ORDER BY `id` DESC [ RunTime:0.001157s ]
- SHOW FULL COLUMNS FROM `sxo_link` [ RunTime:0.001392s ]
- SELECT * FROM `sxo_link` WHERE `is_enable` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000313s ]
0.312760s