SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001842s ]
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.008479s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001256s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.010848s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002547s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.006375s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002649s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.017882s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002401s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.046725s ]
UPDATE `stock_search` SET `count` = 2004 , `updatetime` = '2026-06-06 21:09:59' WHERE `partno` = '210' [ RunTime:0.010751s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.021299s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.009223s ]
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.018387s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002843s ]
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.021667s ]
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.060473s ]
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.013752s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170962 LIMIT 4 [ RunTime:0.038660s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170962 ORDER BY `minOrder` ASC [ RunTime:0.024099s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170962 ORDER BY `unit` DESC [ RunTime:0.096423s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170962 LIMIT 2 [ RunTime:0.065538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170962 ORDER BY `minOrder` ASC [ RunTime:0.000602s ]
select * from pdf where partno='21024' and brandshort='Wiha' limit 1 [ RunTime:0.027222s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21024' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.017493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170829 LIMIT 4 [ RunTime:0.030083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170829 ORDER BY `minOrder` ASC [ RunTime:0.033203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170829 ORDER BY `unit` DESC [ RunTime:0.011126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170829 LIMIT 2 [ RunTime:0.000299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170829 ORDER BY `minOrder` ASC [ RunTime:0.045283s ]
select * from pdf where partno='21022' and brandshort='Wiha' limit 1 [ RunTime:0.060806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21022' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.051244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170797 LIMIT 4 [ RunTime:0.051099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170797 ORDER BY `minOrder` ASC [ RunTime:0.000584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170797 ORDER BY `unit` DESC [ RunTime:0.038377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170797 LIMIT 2 [ RunTime:0.021678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170797 ORDER BY `minOrder` ASC [ RunTime:0.034448s ]
select * from pdf where partno='21068' and brandshort='Wiha' limit 1 [ RunTime:0.016077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21068' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.044498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170777 LIMIT 4 [ RunTime:0.031264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170777 ORDER BY `minOrder` ASC [ RunTime:0.076426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170777 ORDER BY `unit` DESC [ RunTime:0.077215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170777 LIMIT 2 [ RunTime:0.038116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170777 ORDER BY `minOrder` ASC [ RunTime:0.000598s ]
select * from pdf where partno='21066' and brandshort='Wiha' limit 1 [ RunTime:0.067503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21066' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.039083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170775 LIMIT 4 [ RunTime:0.032094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170775 ORDER BY `minOrder` ASC [ RunTime:0.024497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170775 ORDER BY `unit` DESC [ RunTime:0.073720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170775 LIMIT 2 [ RunTime:0.032333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170775 ORDER BY `minOrder` ASC [ RunTime:0.101184s ]
select * from pdf where partno='21020' and brandshort='Wiha' limit 1 [ RunTime:0.051867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21020' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.043707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170708 LIMIT 4 [ RunTime:0.026542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170708 ORDER BY `minOrder` ASC [ RunTime:0.038585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170708 ORDER BY `unit` DESC [ RunTime:0.020336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170708 LIMIT 2 [ RunTime:0.021265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170708 ORDER BY `minOrder` ASC [ RunTime:0.094252s ]
select * from pdf where partno='21019' and brandshort='Wiha' limit 1 [ RunTime:0.057246s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21019' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.029432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170685 LIMIT 4 [ RunTime:0.045479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170685 ORDER BY `minOrder` ASC [ RunTime:0.056270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170685 ORDER BY `unit` DESC [ RunTime:0.021113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170685 LIMIT 2 [ RunTime:0.010099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170685 ORDER BY `minOrder` ASC [ RunTime:0.050368s ]
select * from pdf where partno='21064' and brandshort='Wiha' limit 1 [ RunTime:0.017238s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21064' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.019205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170666 LIMIT 4 [ RunTime:0.024319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170666 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170666 ORDER BY `unit` DESC [ RunTime:0.034635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170666 LIMIT 2 [ RunTime:0.035498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170666 ORDER BY `minOrder` ASC [ RunTime:0.058626s ]
select * from pdf where partno='21017' and brandshort='Wiha' limit 1 [ RunTime:0.017159s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21017' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.029161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170639 LIMIT 4 [ RunTime:0.032274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170639 ORDER BY `minOrder` ASC [ RunTime:0.021488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170639 ORDER BY `unit` DESC [ RunTime:0.018502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170639 LIMIT 2 [ RunTime:0.066196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170639 ORDER BY `minOrder` ASC [ RunTime:0.022262s ]
select * from pdf where partno='21062' and brandshort='Wiha' limit 1 [ RunTime:0.054798s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21062' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.089997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170615 LIMIT 4 [ RunTime:0.016819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170615 ORDER BY `minOrder` ASC [ RunTime:0.024997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170615 ORDER BY `unit` DESC [ RunTime:0.026584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170615 LIMIT 2 [ RunTime:0.030412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170615 ORDER BY `minOrder` ASC [ RunTime:0.032338s ]
select * from pdf where partno='21060' and brandshort='Wiha' limit 1 [ RunTime:0.051172s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21060' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.012085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170565 LIMIT 4 [ RunTime:0.018548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170565 ORDER BY `minOrder` ASC [ RunTime:0.032548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170565 ORDER BY `unit` DESC [ RunTime:0.027442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170565 LIMIT 2 [ RunTime:0.013964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170565 ORDER BY `minOrder` ASC [ RunTime:0.045294s ]
select * from pdf where partno='21058' and brandshort='Wiha' limit 1 [ RunTime:0.028115s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21058' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.027295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170557 LIMIT 4 [ RunTime:0.019468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170557 ORDER BY `minOrder` ASC [ RunTime:0.030811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170557 ORDER BY `unit` DESC [ RunTime:0.009805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170557 LIMIT 2 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170557 ORDER BY `minOrder` ASC [ RunTime:0.015819s ]
select * from pdf where partno='21015' and brandshort='Wiha' limit 1 [ RunTime:0.016069s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21015' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.091681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170497 LIMIT 4 [ RunTime:0.011670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170497 ORDER BY `minOrder` ASC [ RunTime:0.025485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170497 ORDER BY `unit` DESC [ RunTime:0.019349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170497 LIMIT 2 [ RunTime:0.009746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170497 ORDER BY `minOrder` ASC [ RunTime:0.008499s ]
select * from pdf where partno='21014' and brandshort='Wiha' limit 1 [ RunTime:0.006852s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21014' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.038812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170363 LIMIT 4 [ RunTime:0.041435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170363 ORDER BY `minOrder` ASC [ RunTime:0.051192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170363 ORDER BY `unit` DESC [ RunTime:0.050932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170363 LIMIT 2 [ RunTime:0.051001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170363 ORDER BY `minOrder` ASC [ RunTime:0.051290s ]
select * from pdf where partno='21056' and brandshort='Wiha' limit 1 [ RunTime:0.051106s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21056' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.051073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170356 LIMIT 4 [ RunTime:0.012280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170356 ORDER BY `minOrder` ASC [ RunTime:0.051096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170356 ORDER BY `unit` DESC [ RunTime:0.054394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170356 LIMIT 2 [ RunTime:0.002475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170356 ORDER BY `minOrder` ASC [ RunTime:0.037570s ]
select * from pdf where partno='21057' and brandshort='Wiha' limit 1 [ RunTime:0.034367s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21057' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.047693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170332 LIMIT 4 [ RunTime:0.051579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170332 ORDER BY `minOrder` ASC [ RunTime:0.065543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170332 ORDER BY `unit` DESC [ RunTime:0.050927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170332 LIMIT 2 [ RunTime:0.031116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170332 ORDER BY `minOrder` ASC [ RunTime:0.031981s ]
select * from pdf where partno='21054' and brandshort='Wiha' limit 1 [ RunTime:0.106117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21054' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.040380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170292 LIMIT 4 [ RunTime:0.086252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170292 ORDER BY `minOrder` ASC [ RunTime:0.034218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170292 ORDER BY `unit` DESC [ RunTime:0.037581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170292 LIMIT 2 [ RunTime:0.069239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170292 ORDER BY `minOrder` ASC [ RunTime:0.072124s ]
select * from pdf where partno='21052' and brandshort='Wiha' limit 1 [ RunTime:0.070910s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21052' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.026685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170235 LIMIT 4 [ RunTime:0.091424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170235 ORDER BY `minOrder` ASC [ RunTime:0.069266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170235 ORDER BY `unit` DESC [ RunTime:0.080836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170235 LIMIT 2 [ RunTime:0.049126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170235 ORDER BY `minOrder` ASC [ RunTime:0.031346s ]
select * from pdf where partno='21050' and brandshort='Wiha' limit 1 [ RunTime:0.068269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21050' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.023886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170201 LIMIT 4 [ RunTime:0.014890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170201 ORDER BY `minOrder` ASC [ RunTime:0.049975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170201 ORDER BY `unit` DESC [ RunTime:0.018865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170201 LIMIT 2 [ RunTime:0.032561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170201 ORDER BY `minOrder` ASC [ RunTime:0.004390s ]
select * from pdf where partno='21012' and brandshort='Wiha' limit 1 [ RunTime:0.027262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21012' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.060147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170171 LIMIT 4 [ RunTime:0.051181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170171 ORDER BY `minOrder` ASC [ RunTime:0.051250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170171 ORDER BY `unit` DESC [ RunTime:0.109934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170171 LIMIT 2 [ RunTime:0.072549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170171 ORDER BY `minOrder` ASC [ RunTime:0.032466s ]
select * from pdf where partno='21011' and brandshort='Wiha' limit 1 [ RunTime:0.024990s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21011' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.044917s ]
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.095801s ]