SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001295s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.83' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.021652s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001609s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.007686s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001574s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.006399s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001237s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002855s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001260s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.024247s ]
UPDATE `stock_search` SET `count` = 4178 , `updatetime` = '2026-06-08 16:53:38' WHERE `partno` = '210' [ RunTime:0.034447s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.014000s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.012410s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.003439s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001679s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.039665s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '210%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 2380,20 [ RunTime:0.102050s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('37979585','37979538','37977746','37977679','37974770','37974769','37974768','37974767','37974766','37948214','37948128','37947818','37947738','37944090','37944089','37944042','37944041','37942674','37942576','37942528') ORDER BY FIELD(s.id, 37979585,37979538,37977746,37977679,37974770,37974769,37974768,37974767,37974766,37948214,37948128,37947818,37947738,37944090,37944089,37944042,37944041,37942674,37942576,37942528) [ RunTime:0.035076s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37979585 LIMIT 4 [ RunTime:0.029987s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37979585 ORDER BY `minOrder` ASC [ RunTime:0.025691s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37979585 ORDER BY `unit` DESC [ RunTime:0.010448s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37979585 LIMIT 2 [ RunTime:0.033224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37979585 ORDER BY `minOrder` ASC [ RunTime:0.032766s ]
select * from pdf where partno='21013' and brandshort='80/20, LLC' limit 1 [ RunTime:0.045164s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21013' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.023468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37979538 LIMIT 4 [ RunTime:0.039576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37979538 ORDER BY `minOrder` ASC [ RunTime:0.020923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37979538 ORDER BY `unit` DESC [ RunTime:0.018629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37979538 LIMIT 2 [ RunTime:0.011771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37979538 ORDER BY `minOrder` ASC [ RunTime:0.002010s ]
select * from pdf where partno='21014' and brandshort='80/20, LLC' limit 1 [ RunTime:0.018303s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21014' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.016564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37977746 LIMIT 4 [ RunTime:0.014046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37977746 ORDER BY `minOrder` ASC [ RunTime:0.017838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37977746 ORDER BY `unit` DESC [ RunTime:0.013433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37977746 LIMIT 2 [ RunTime:0.007261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37977746 ORDER BY `minOrder` ASC [ RunTime:0.007068s ]
select * from pdf where partno='21003' and brandshort='80/20, LLC' limit 1 [ RunTime:0.002329s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21003' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.010883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37977679 LIMIT 4 [ RunTime:0.019542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37977679 ORDER BY `minOrder` ASC [ RunTime:0.025030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37977679 ORDER BY `unit` DESC [ RunTime:0.011572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37977679 LIMIT 2 [ RunTime:0.017766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37977679 ORDER BY `minOrder` ASC [ RunTime:0.002665s ]
select * from pdf where partno='21004' and brandshort='80/20, LLC' limit 1 [ RunTime:0.002436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21004' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.002834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37974770 LIMIT 4 [ RunTime:0.001397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37974770 ORDER BY `minOrder` ASC [ RunTime:0.001679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37974770 ORDER BY `unit` DESC [ RunTime:0.009895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37974770 LIMIT 2 [ RunTime:0.009814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37974770 ORDER BY `minOrder` ASC [ RunTime:0.000491s ]
select * from pdf where partno='21010000' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.005273s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21010000' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.006810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37974769 LIMIT 4 [ RunTime:0.006236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37974769 ORDER BY `minOrder` ASC [ RunTime:0.014034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37974769 ORDER BY `unit` DESC [ RunTime:0.004138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37974769 LIMIT 2 [ RunTime:0.001006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37974769 ORDER BY `minOrder` ASC [ RunTime:0.003802s ]
select * from pdf where partno='21020000' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.018547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21020000' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.004135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37974768 LIMIT 4 [ RunTime:0.011871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37974768 ORDER BY `minOrder` ASC [ RunTime:0.037205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37974768 ORDER BY `unit` DESC [ RunTime:0.001830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37974768 LIMIT 2 [ RunTime:0.003323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37974768 ORDER BY `minOrder` ASC [ RunTime:0.007879s ]
select * from pdf where partno='21050000' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.017272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21050000' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.002314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37974767 LIMIT 4 [ RunTime:0.007106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37974767 ORDER BY `minOrder` ASC [ RunTime:0.004411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37974767 ORDER BY `unit` DESC [ RunTime:0.012090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37974767 LIMIT 2 [ RunTime:0.010445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37974767 ORDER BY `minOrder` ASC [ RunTime:0.007477s ]
select * from pdf where partno='21030000' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.001637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21030000' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.005126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37974766 LIMIT 4 [ RunTime:0.002459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37974766 ORDER BY `minOrder` ASC [ RunTime:0.000820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37974766 ORDER BY `unit` DESC [ RunTime:0.003554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37974766 LIMIT 2 [ RunTime:0.005053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37974766 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
select * from pdf where partno='21040000' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.002134s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21040000' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37948214 LIMIT 4 [ RunTime:0.001618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37948214 ORDER BY `minOrder` ASC [ RunTime:0.002185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37948214 ORDER BY `unit` DESC [ RunTime:0.000842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37948214 LIMIT 2 [ RunTime:0.005706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37948214 ORDER BY `minOrder` ASC [ RunTime:0.003641s ]
select * from pdf where partno='21028' and brandshort='3M' limit 1 [ RunTime:0.013234s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21028' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.019096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37948128 LIMIT 4 [ RunTime:0.012532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37948128 ORDER BY `minOrder` ASC [ RunTime:0.008604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37948128 ORDER BY `unit` DESC [ RunTime:0.000895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37948128 LIMIT 2 [ RunTime:0.003413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37948128 ORDER BY `minOrder` ASC [ RunTime:0.003730s ]
select * from pdf where partno='21027' and brandshort='3M' limit 1 [ RunTime:0.001513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21027' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.005424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37947818 LIMIT 4 [ RunTime:0.004252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37947818 ORDER BY `minOrder` ASC [ RunTime:0.030575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37947818 ORDER BY `unit` DESC [ RunTime:0.004635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37947818 LIMIT 2 [ RunTime:0.002919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37947818 ORDER BY `minOrder` ASC [ RunTime:0.006356s ]
select * from pdf where partno='21035' and brandshort='3M' limit 1 [ RunTime:0.003377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.007156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37947738 LIMIT 4 [ RunTime:0.035767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37947738 ORDER BY `minOrder` ASC [ RunTime:0.014074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37947738 ORDER BY `unit` DESC [ RunTime:0.010460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37947738 LIMIT 2 [ RunTime:0.007967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37947738 ORDER BY `minOrder` ASC [ RunTime:0.001890s ]
select * from pdf where partno='21034' and brandshort='3M' limit 1 [ RunTime:0.014017s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21034' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.024111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37944090 LIMIT 4 [ RunTime:0.021356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37944090 ORDER BY `minOrder` ASC [ RunTime:0.044107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37944090 ORDER BY `unit` DESC [ RunTime:0.002619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37944090 LIMIT 2 [ RunTime:0.014879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37944090 ORDER BY `minOrder` ASC [ RunTime:0.010171s ]
select * from pdf where partno='21041' and brandshort='3M' limit 1 [ RunTime:0.022440s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21041' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.016701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37944089 LIMIT 4 [ RunTime:0.004161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37944089 ORDER BY `minOrder` ASC [ RunTime:0.018441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37944089 ORDER BY `unit` DESC [ RunTime:0.004004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37944089 LIMIT 2 [ RunTime:0.002119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37944089 ORDER BY `minOrder` ASC [ RunTime:0.000937s ]
select * from pdf where partno='21038' and brandshort='3M' limit 1 [ RunTime:0.001304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21038' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.008477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37944042 LIMIT 4 [ RunTime:0.029780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37944042 ORDER BY `minOrder` ASC [ RunTime:0.035219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37944042 ORDER BY `unit` DESC [ RunTime:0.004033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37944042 LIMIT 2 [ RunTime:0.010409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37944042 ORDER BY `minOrder` ASC [ RunTime:0.016390s ]
select * from pdf where partno='21037' and brandshort='3M' limit 1 [ RunTime:0.001596s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21037' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.007034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37944041 LIMIT 4 [ RunTime:0.005535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37944041 ORDER BY `minOrder` ASC [ RunTime:0.086447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37944041 ORDER BY `unit` DESC [ RunTime:0.036614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37944041 LIMIT 2 [ RunTime:0.027847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37944041 ORDER BY `minOrder` ASC [ RunTime:0.008905s ]
select * from pdf where partno='21040' and brandshort='3M' limit 1 [ RunTime:0.001547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21040' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.013610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37942674 LIMIT 4 [ RunTime:0.001052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37942674 ORDER BY `minOrder` ASC [ RunTime:0.013465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37942674 ORDER BY `unit` DESC [ RunTime:0.021892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37942674 LIMIT 2 [ RunTime:0.011576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37942674 ORDER BY `minOrder` ASC [ RunTime:0.011267s ]
select * from pdf where partno='21021' and brandshort='3M' limit 1 [ RunTime:0.008461s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21021' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.006028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37942576 LIMIT 4 [ RunTime:0.000908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37942576 ORDER BY `minOrder` ASC [ RunTime:0.000733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37942576 ORDER BY `unit` DESC [ RunTime:0.003223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37942576 LIMIT 2 [ RunTime:0.005079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37942576 ORDER BY `minOrder` ASC [ RunTime:0.007801s ]
select * from pdf where partno='21019' and brandshort='3M' limit 1 [ RunTime:0.005023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21019' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.003096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37942528 LIMIT 4 [ RunTime:0.000786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37942528 ORDER BY `minOrder` ASC [ RunTime:0.000849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37942528 ORDER BY `unit` DESC [ RunTime:0.003765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37942528 LIMIT 2 [ RunTime:0.011160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37942528 ORDER BY `minOrder` ASC [ RunTime:0.000560s ]
select * from pdf where partno='21018' and brandshort='3M' limit 1 [ RunTime:0.006586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21018' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.003338s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.000588s ]