SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001233s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.220' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.002674s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001180s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003010s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001814s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000402s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001030s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000244s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001119s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000558s ]
UPDATE `stock_search` SET `count` = 1982 , `updatetime` = '2026-06-06 21:07:38' WHERE `partno` = '210' [ RunTime:0.007224s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000247s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000200s ]
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.000363s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001597s ]
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.000463s ]
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 2940,20 [ RunTime:0.055383s ]
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 ('33170962','33170829','33170797','33170777','33170775','33170708','33170685','33170666','33170639','33170615','33170565','33170557','33170497','33170363','33170356','33170332','33170292','33170235','33170201','33170171') ORDER BY FIELD(s.id, 33170962,33170829,33170797,33170777,33170775,33170708,33170685,33170666,33170639,33170615,33170565,33170557,33170497,33170363,33170356,33170332,33170292,33170235,33170201,33170171) [ RunTime:0.003593s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170962 LIMIT 4 [ RunTime:0.005870s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170962 ORDER BY `minOrder` ASC [ RunTime:0.001062s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170962 ORDER BY `unit` DESC [ RunTime:0.002407s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170962 LIMIT 2 [ RunTime:0.005077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170962 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='21024' and brandshort='Wiha' limit 1 [ RunTime:0.004343s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002175s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21024' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.009526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170829 LIMIT 4 [ RunTime:0.002436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170829 ORDER BY `minOrder` ASC [ RunTime:0.007191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170829 ORDER BY `unit` DESC [ RunTime:0.000811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170829 LIMIT 2 [ RunTime:0.000650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170829 ORDER BY `minOrder` ASC [ RunTime:0.001122s ]
select * from pdf where partno='21022' and brandshort='Wiha' limit 1 [ RunTime:0.003926s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21022' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.004376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170797 LIMIT 4 [ RunTime:0.004908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170797 ORDER BY `minOrder` ASC [ RunTime:0.003410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170797 ORDER BY `unit` DESC [ RunTime:0.008160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170797 LIMIT 2 [ RunTime:0.001880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170797 ORDER BY `minOrder` ASC [ RunTime:0.002441s ]
select * from pdf where partno='21068' and brandshort='Wiha' limit 1 [ RunTime:0.004853s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21068' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.003362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170777 LIMIT 4 [ RunTime:0.000730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170777 ORDER BY `minOrder` ASC [ RunTime:0.007138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170777 ORDER BY `unit` DESC [ RunTime:0.000550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170777 LIMIT 2 [ RunTime:0.002596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170777 ORDER BY `minOrder` ASC [ RunTime:0.006346s ]
select * from pdf where partno='21066' and brandshort='Wiha' limit 1 [ RunTime:0.004346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21066' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.010288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170775 LIMIT 4 [ RunTime:0.002396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170775 ORDER BY `minOrder` ASC [ RunTime:0.021519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170775 ORDER BY `unit` DESC [ RunTime:0.004787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170775 LIMIT 2 [ RunTime:0.004437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170775 ORDER BY `minOrder` ASC [ RunTime:0.013130s ]
select * from pdf where partno='21020' and brandshort='Wiha' limit 1 [ RunTime:0.003467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21020' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.016429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170708 LIMIT 4 [ RunTime:0.001925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170708 ORDER BY `minOrder` ASC [ RunTime:0.004001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170708 ORDER BY `unit` DESC [ RunTime:0.011635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170708 LIMIT 2 [ RunTime:0.004399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170708 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='21019' and brandshort='Wiha' limit 1 [ RunTime:0.002672s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21019' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.009533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170685 LIMIT 4 [ RunTime:0.009184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170685 ORDER BY `minOrder` ASC [ RunTime:0.013318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170685 ORDER BY `unit` DESC [ RunTime:0.004448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170685 LIMIT 2 [ RunTime:0.013255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170685 ORDER BY `minOrder` ASC [ RunTime:0.020258s ]
select * from pdf where partno='21064' and brandshort='Wiha' limit 1 [ RunTime:0.001076s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21064' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.006447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170666 LIMIT 4 [ RunTime:0.018231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170666 ORDER BY `minOrder` ASC [ RunTime:0.022916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170666 ORDER BY `unit` DESC [ RunTime:0.017216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170666 LIMIT 2 [ RunTime:0.014269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170666 ORDER BY `minOrder` ASC [ RunTime:0.015804s ]
select * from pdf where partno='21017' and brandshort='Wiha' limit 1 [ RunTime:0.034351s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21017' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.024742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170639 LIMIT 4 [ RunTime:0.008778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170639 ORDER BY `minOrder` ASC [ RunTime:0.003213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170639 ORDER BY `unit` DESC [ RunTime:0.024387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170639 LIMIT 2 [ RunTime:0.040102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170639 ORDER BY `minOrder` ASC [ RunTime:0.038062s ]
select * from pdf where partno='21062' and brandshort='Wiha' limit 1 [ RunTime:0.020622s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21062' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.030430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170615 LIMIT 4 [ RunTime:0.029995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170615 ORDER BY `minOrder` ASC [ RunTime:0.043201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170615 ORDER BY `unit` DESC [ RunTime:0.014002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170615 LIMIT 2 [ RunTime:0.017814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170615 ORDER BY `minOrder` ASC [ RunTime:0.007480s ]
select * from pdf where partno='21060' and brandshort='Wiha' limit 1 [ RunTime:0.018056s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21060' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.013612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170565 LIMIT 4 [ RunTime:0.023899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170565 ORDER BY `minOrder` ASC [ RunTime:0.011560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170565 ORDER BY `unit` DESC [ RunTime:0.002703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170565 LIMIT 2 [ RunTime:0.000459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170565 ORDER BY `minOrder` ASC [ RunTime:0.002492s ]
select * from pdf where partno='21058' and brandshort='Wiha' limit 1 [ RunTime:0.013906s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21058' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.021631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170557 LIMIT 4 [ RunTime:0.020535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170557 ORDER BY `minOrder` ASC [ RunTime:0.019024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170557 ORDER BY `unit` DESC [ RunTime:0.012211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170557 LIMIT 2 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170557 ORDER BY `minOrder` ASC [ RunTime:0.002249s ]
select * from pdf where partno='21015' and brandshort='Wiha' limit 1 [ RunTime:0.011953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21015' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.015893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170497 LIMIT 4 [ RunTime:0.002964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170497 ORDER BY `minOrder` ASC [ RunTime:0.011306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170497 ORDER BY `unit` DESC [ RunTime:0.009731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170497 LIMIT 2 [ RunTime:0.005554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170497 ORDER BY `minOrder` ASC [ RunTime:0.009875s ]
select * from pdf where partno='21014' and brandshort='Wiha' limit 1 [ RunTime:0.004438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21014' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.000754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170363 LIMIT 4 [ RunTime:0.007078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170363 ORDER BY `minOrder` ASC [ RunTime:0.003749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170363 ORDER BY `unit` DESC [ RunTime:0.000707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170363 LIMIT 2 [ RunTime:0.003456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170363 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
select * from pdf where partno='21056' and brandshort='Wiha' limit 1 [ RunTime:0.012208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21056' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.012288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170356 LIMIT 4 [ RunTime:0.007533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170356 ORDER BY `minOrder` ASC [ RunTime:0.014410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170356 ORDER BY `unit` DESC [ RunTime:0.002366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170356 LIMIT 2 [ RunTime:0.004473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170356 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
select * from pdf where partno='21057' and brandshort='Wiha' limit 1 [ RunTime:0.011460s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21057' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.015386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170332 LIMIT 4 [ RunTime:0.002164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170332 ORDER BY `minOrder` ASC [ RunTime:0.000732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170332 ORDER BY `unit` DESC [ RunTime:0.001445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170332 LIMIT 2 [ RunTime:0.010876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170332 ORDER BY `minOrder` ASC [ RunTime:0.003715s ]
select * from pdf where partno='21054' and brandshort='Wiha' limit 1 [ RunTime:0.003234s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21054' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.003351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170292 LIMIT 4 [ RunTime:0.005417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170292 ORDER BY `minOrder` ASC [ RunTime:0.005584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170292 ORDER BY `unit` DESC [ RunTime:0.001794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170292 LIMIT 2 [ RunTime:0.000786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170292 ORDER BY `minOrder` ASC [ RunTime:0.001443s ]
select * from pdf where partno='21052' and brandshort='Wiha' limit 1 [ RunTime:0.006028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21052' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.018043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170235 LIMIT 4 [ RunTime:0.004494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170235 ORDER BY `minOrder` ASC [ RunTime:0.003105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170235 ORDER BY `unit` DESC [ RunTime:0.011018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170235 LIMIT 2 [ RunTime:0.013493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170235 ORDER BY `minOrder` ASC [ RunTime:0.001256s ]
select * from pdf where partno='21050' and brandshort='Wiha' limit 1 [ RunTime:0.007702s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21050' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.022574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170201 LIMIT 4 [ RunTime:0.016375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170201 ORDER BY `minOrder` ASC [ RunTime:0.015423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170201 ORDER BY `unit` DESC [ RunTime:0.006469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170201 LIMIT 2 [ RunTime:0.029557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170201 ORDER BY `minOrder` ASC [ RunTime:0.004521s ]
select * from pdf where partno='21012' and brandshort='Wiha' limit 1 [ RunTime:0.009655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21012' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.013573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170171 LIMIT 4 [ RunTime:0.008083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170171 ORDER BY `minOrder` ASC [ RunTime:0.002449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170171 ORDER BY `unit` DESC [ RunTime:0.003600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170171 LIMIT 2 [ RunTime:0.002893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170171 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
select * from pdf where partno='21011' and brandshort='Wiha' limit 1 [ RunTime:0.006846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21011' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.001050s ]
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.001739s ]