SHOW FULL COLUMNS FROM `wbt_user_token` [ RunTime:0.000696s ]
SELECT * FROM `wbt_user_token` WHERE `token` IS NULL AND `expire_time` > 1784314621 LIMIT 1 [ RunTime:0.000194s ]
SELECT * FROM `wbt_user_token` WHERE `token` IS NULL AND `expire_time` > 1784314621 LIMIT 1 [ RunTime:0.000181s ]
SHOW FULL COLUMNS FROM `wbt_brand` [ RunTime:0.000715s ]
SHOW FULL COLUMNS FROM `wbt_goods_cate` [ RunTime:0.000753s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 97 [ RunTime:0.000202s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 1 [ RunTime:0.000217s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 29 [ RunTime:0.000160s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 31 [ RunTime:0.000150s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 32 [ RunTime:0.000120s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 33 [ RunTime:0.000108s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 34 [ RunTime:0.000106s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 120 [ RunTime:0.000104s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 121 [ RunTime:0.000103s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 122 [ RunTime:0.000143s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 148 [ RunTime:0.000117s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 149 [ RunTime:0.000100s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 150 [ RunTime:0.000101s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 2 [ RunTime:0.000103s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 36 [ RunTime:0.000115s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 37 [ RunTime:0.000127s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 38 [ RunTime:0.000122s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 39 [ RunTime:0.000107s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 93 [ RunTime:0.000101s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 141 [ RunTime:0.000118s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 142 [ RunTime:0.000108s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 152 [ RunTime:0.000132s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 310 [ RunTime:0.000130s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 4 [ RunTime:0.000108s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 46 [ RunTime:0.000120s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 47 [ RunTime:0.000105s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 48 [ RunTime:0.000101s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 49 [ RunTime:0.000131s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 50 [ RunTime:0.000119s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 51 [ RunTime:0.000104s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 52 [ RunTime:0.000104s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 53 [ RunTime:0.000101s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 54 [ RunTime:0.000100s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 118 [ RunTime:0.000110s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 119 [ RunTime:0.000124s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 153 [ RunTime:0.000116s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 154 [ RunTime:0.000102s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 311 [ RunTime:0.000103s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 312 [ RunTime:0.000097s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 5 [ RunTime:0.000103s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 55 [ RunTime:0.000151s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 56 [ RunTime:0.000119s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 57 [ RunTime:0.000105s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 58 [ RunTime:0.000101s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 59 [ RunTime:0.000101s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 60 [ RunTime:0.000098s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 61 [ RunTime:0.000114s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 108 [ RunTime:0.000126s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 109 [ RunTime:0.000108s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 144 [ RunTime:0.000102s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 155 [ RunTime:0.000101s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 156 [ RunTime:0.000109s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 157 [ RunTime:0.000105s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 158 [ RunTime:0.000131s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 159 [ RunTime:0.000135s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 160 [ RunTime:0.000106s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 161 [ RunTime:0.000110s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 7 [ RunTime:0.000107s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 62 [ RunTime:0.000161s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 64 [ RunTime:0.000116s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 65 [ RunTime:0.000104s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 66 [ RunTime:0.000103s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 67 [ RunTime:0.000111s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 70 [ RunTime:0.000103s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 71 [ RunTime:0.000125s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 72 [ RunTime:0.000134s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 73 [ RunTime:0.000112s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 74 [ RunTime:0.000102s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 75 [ RunTime:0.000100s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 76 [ RunTime:0.000101s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 78 [ RunTime:0.000135s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 79 [ RunTime:0.000125s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 80 [ RunTime:0.000110s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 81 [ RunTime:0.000102s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 82 [ RunTime:0.000101s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 83 [ RunTime:0.000100s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 84 [ RunTime:0.000101s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 85 [ RunTime:0.000118s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 86 [ RunTime:0.000127s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 87 [ RunTime:0.000106s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 88 [ RunTime:0.000108s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 89 [ RunTime:0.000102s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 90 [ RunTime:0.000100s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 111 [ RunTime:0.000124s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 112 [ RunTime:0.000112s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 113 [ RunTime:0.000118s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 114 [ RunTime:0.000102s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 115 [ RunTime:0.000099s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 116 [ RunTime:0.000100s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 117 [ RunTime:0.000102s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 131 [ RunTime:0.000102s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 139 [ RunTime:0.000123s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 140 [ RunTime:0.000120s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 163 [ RunTime:0.000104s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 165 [ RunTime:0.000101s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 235 [ RunTime:0.000100s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 238 [ RunTime:0.000101s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 247 [ RunTime:0.000120s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 143 [ RunTime:0.000117s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 248 [ RunTime:0.000129s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 249 [ RunTime:0.000107s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 309 [ RunTime:0.000101s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 313 [ RunTime:0.000100s ]
SELECT `id`,`pid` FROM `wbt_goods_cate` WHERE `pid` = 164 [ RunTime:0.000098s ]
SHOW FULL COLUMNS FROM `wbt_brand_cate_relation` [ RunTime:0.000587s ]
SELECT `id`,`cate_id`,`title`,`title_en`,`first_letter`,`logo`,`image`,`info`,`info_en` FROM `wbt_brand` WHERE `status` = 1 AND `id` IN (SELECT `brand_id` FROM `wbt_brand_cate_relation` WHERE `cate_id` IN (97,1,29,31,32,33,34,120,121,122,148,149,150,2,36,37,38,39,93,141,142,152,310,4,46,47,48,49,50,51,52,53,54,118,119,153,154,311,312,5,55,56,57,58,59,60,61,108,109,144,155,156,157,158,159,160,161,7,62,64,65,66,67,70,71,72,73,74,75,76,78,79,80,81,82,83,84,85,86,87,88,89,90,111,112,113,114,115,116,117,131,139,140,163,165,235,238,247,143,248,249,309,313,164)) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000474s ]
SELECT `cate_id` FROM `wbt_brand_cate_relation` WHERE `brand_id` = 1 [ RunTime:0.000206s ]
SELECT `cate_id` FROM `wbt_brand_cate_relation` WHERE `brand_id` = 7 [ RunTime:0.000126s ]
SELECT `cate_id` FROM `wbt_brand_cate_relation` WHERE `brand_id` = 5 [ RunTime:0.000095s ]
SELECT `cate_id` FROM `wbt_brand_cate_relation` WHERE `brand_id` = 4 [ RunTime:0.000097s ]
SELECT `cate_id` FROM `wbt_brand_cate_relation` WHERE `brand_id` = 2 [ RunTime:0.000086s ]
SELECT `cate_id` FROM `wbt_brand_cate_relation` WHERE `brand_id` = 3 [ RunTime:0.000079s ]
SELECT `cate_id` FROM `wbt_brand_cate_relation` WHERE `brand_id` = 6 [ RunTime:0.000135s ]
SELECT `cate_id` FROM `wbt_brand_cate_relation` WHERE `brand_id` = 8 [ RunTime:0.000099s ]
SELECT `cate_id` FROM `wbt_brand_cate_relation` WHERE `brand_id` = 10 [ RunTime:0.000084s ]
SELECT `cate_id` FROM `wbt_brand_cate_relation` WHERE `brand_id` = 21 [ RunTime:0.000078s ]
SELECT `cate_id` FROM `wbt_brand_cate_relation` WHERE `brand_id` = 20 [ RunTime:0.000075s ]
SELECT `cate_id` FROM `wbt_brand_cate_relation` WHERE `brand_id` = 19 [ RunTime:0.000075s ]
SELECT `cate_id` FROM `wbt_brand_cate_relation` WHERE `brand_id` = 18 [ RunTime:0.000082s ]
SELECT `cate_id` FROM `wbt_brand_cate_relation` WHERE `brand_id` = 17 [ RunTime:0.000093s ]
SELECT `cate_id` FROM `wbt_brand_cate_relation` WHERE `brand_id` = 16 [ RunTime:0.000100s ]
SELECT `cate_id` FROM `wbt_brand_cate_relation` WHERE `brand_id` = 12 [ RunTime:0.000081s ]
SELECT `cate_id` FROM `wbt_brand_cate_relation` WHERE `brand_id` = 11 [ RunTime:0.000075s ]
SELECT `id`,`pid`,`name`,`name_en`,`pe_logo`,`logo`,`logo_active`,`image`,`face_right`,`face_wrong`,`main_brand_id`,`main_brand_info` FROM `wbt_goods_cate` WHERE `status` = 1 AND `pid` = 97 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000337s ]
SELECT `b`.`id`,`b`.`title`,`b`.`title_en`,`b`.`first_letter`,`b`.`logo`,`b`.`image`,`b`.`info` FROM `wbt_brand` `b` RIGHT JOIN `wbt_brand_cate_relation` `bcr` ON `bcr`.`brand_id`=`b`.`id` WHERE `b`.`id` > '0' AND `bcr`.`cate_id` = '1' AND `b`.`first_letter` = 'P' ORDER BY `bcr`.`sort` DESC,`b`.`sort` DESC,`b`.`id` DESC [ RunTime:0.000249s ]
SELECT `b`.`id`,`b`.`title`,`b`.`title_en`,`b`.`first_letter`,`b`.`logo`,`b`.`image`,`b`.`info` FROM `wbt_brand` `b` RIGHT JOIN `wbt_brand_cate_relation` `bcr` ON `bcr`.`brand_id`=`b`.`id` WHERE `b`.`id` > '0' AND `bcr`.`cate_id` = '2' AND `b`.`first_letter` = 'P' ORDER BY `bcr`.`sort` DESC,`b`.`sort` DESC,`b`.`id` DESC [ RunTime:0.000237s ]
SELECT `b`.`id`,`b`.`title`,`b`.`title_en`,`b`.`first_letter`,`b`.`logo`,`b`.`image`,`b`.`info` FROM `wbt_brand` `b` RIGHT JOIN `wbt_brand_cate_relation` `bcr` ON `bcr`.`brand_id`=`b`.`id` WHERE `b`.`id` > '0' AND `bcr`.`cate_id` = '4' AND `b`.`first_letter` = 'P' ORDER BY `bcr`.`sort` DESC,`b`.`sort` DESC,`b`.`id` DESC [ RunTime:0.000243s ]
SELECT `b`.`id`,`b`.`title`,`b`.`title_en`,`b`.`first_letter`,`b`.`logo`,`b`.`image`,`b`.`info` FROM `wbt_brand` `b` RIGHT JOIN `wbt_brand_cate_relation` `bcr` ON `bcr`.`brand_id`=`b`.`id` WHERE `b`.`id` > '0' AND `bcr`.`cate_id` = '5' AND `b`.`first_letter` = 'P' ORDER BY `bcr`.`sort` DESC,`b`.`sort` DESC,`b`.`id` DESC [ RunTime:0.000207s ]
SELECT `b`.`id`,`b`.`title`,`b`.`title_en`,`b`.`first_letter`,`b`.`logo`,`b`.`image`,`b`.`info` FROM `wbt_brand` `b` RIGHT JOIN `wbt_brand_cate_relation` `bcr` ON `bcr`.`brand_id`=`b`.`id` WHERE `b`.`id` > '0' AND `bcr`.`cate_id` = '7' AND `b`.`first_letter` = 'P' ORDER BY `bcr`.`sort` DESC,`b`.`sort` DESC,`b`.`id` DESC [ RunTime:0.000228s ]
SELECT `b`.`id`,`b`.`title`,`b`.`title_en`,`b`.`first_letter`,`b`.`logo`,`b`.`image`,`b`.`info` FROM `wbt_brand` `b` RIGHT JOIN `wbt_brand_cate_relation` `bcr` ON `bcr`.`brand_id`=`b`.`id` WHERE `b`.`id` > '0' AND `bcr`.`cate_id` = '164' AND `b`.`first_letter` = 'P' ORDER BY `bcr`.`sort` DESC,`b`.`sort` DESC,`b`.`id` DESC [ RunTime:0.000230s ]
SELECT `b`.`id`,`b`.`title`,`b`.`title_en`,`b`.`first_letter`,`b`.`logo`,`b`.`image`,`b`.`info` FROM `wbt_brand` `b` RIGHT JOIN `wbt_brand_cate_relation` `bcr` ON `bcr`.`brand_id`=`b`.`id` WHERE `b`.`id` > '0' AND `bcr`.`cate_id` = '143' AND `b`.`first_letter` = 'P' ORDER BY `bcr`.`sort` DESC,`b`.`sort` DESC,`b`.`id` DESC [ RunTime:0.000191s ]
