SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001544s ]
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.013445s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001489s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001218s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001447s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.000285s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001697s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.025186s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001711s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.005140s ]
UPDATE `stock_search` SET `count` = 4122 , `updatetime` = '2026-06-08 16:46:49' WHERE `partno` = '210' [ RunTime:0.031579s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.016803s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.031195s ]
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.013903s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002631s ]
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.006046s ]
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 1900,20 [ RunTime:0.219978s ]
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 ('10852796','10832093','37958801','36910782','36874533','36874532','36874531','35500481','35500480','35500427','35498347','35498158','35495700','35493622','35301943','34450632','34450411','34448625','34448575','34448573') ORDER BY FIELD(s.id, 10852796,10832093,37958801,36910782,36874533,36874532,36874531,35500481,35500480,35500427,35498347,35498158,35495700,35493622,35301943,34450632,34450411,34448625,34448575,34448573) [ RunTime:0.111945s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.009061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10852796 LIMIT 4 [ RunTime:0.002780s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10852796 ORDER BY `minOrder` ASC [ RunTime:0.052193s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10852796 ORDER BY `unit` DESC [ RunTime:0.045225s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10852796 LIMIT 2 [ RunTime:0.023080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10852796 ORDER BY `minOrder` ASC [ RunTime:0.010954s ]
select * from pdf where partno='21033812404' and brandshort='HARTING' limit 1 [ RunTime:0.018383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10832093 LIMIT 4 [ RunTime:0.034922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10832093 ORDER BY `minOrder` ASC [ RunTime:0.006377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10832093 ORDER BY `unit` DESC [ RunTime:0.013583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10832093 LIMIT 2 [ RunTime:0.021476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10832093 ORDER BY `minOrder` ASC [ RunTime:0.012960s ]
select * from pdf where partno='21021591305' and brandshort='HARTING' limit 1 [ RunTime:0.008937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37958801 LIMIT 4 [ RunTime:0.011921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37958801 ORDER BY `minOrder` ASC [ RunTime:0.021403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37958801 ORDER BY `unit` DESC [ RunTime:0.030914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37958801 LIMIT 2 [ RunTime:0.007338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37958801 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
select * from pdf where partno='2105108' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.016960s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105108' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36910782 LIMIT 4 [ RunTime:0.019470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36910782 ORDER BY `minOrder` ASC [ RunTime:0.056807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36910782 ORDER BY `unit` DESC [ RunTime:0.118804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36910782 LIMIT 2 [ RunTime:0.034628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36910782 ORDER BY `minOrder` ASC [ RunTime:0.016937s ]
select * from pdf where partno='2104-1001-KIT' and brandshort='DB Unlimited' limit 1 [ RunTime:0.024086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-1001-KIT' OR `brand` LIKE 'DB Unlimited%' ) ) LIMIT 1 [ RunTime:0.020574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36874533 LIMIT 4 [ RunTime:0.064351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36874533 ORDER BY `minOrder` ASC [ RunTime:0.048295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36874533 ORDER BY `unit` DESC [ RunTime:0.015265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36874533 LIMIT 2 [ RunTime:0.029759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36874533 ORDER BY `minOrder` ASC [ RunTime:0.042534s ]
select * from pdf where partno='210B-H' and brandshort='Excelta Corporation' limit 1 [ RunTime:0.018847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210B-H' OR `brand` LIKE 'Excelta Corporation%' ) ) LIMIT 1 [ RunTime:0.024235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36874532 LIMIT 4 [ RunTime:0.052806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36874532 ORDER BY `minOrder` ASC [ RunTime:0.030015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36874532 ORDER BY `unit` DESC [ RunTime:0.050164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36874532 LIMIT 2 [ RunTime:0.005503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36874532 ORDER BY `minOrder` ASC [ RunTime:0.025536s ]
select * from pdf where partno='210B-P' and brandshort='Excelta Corporation' limit 1 [ RunTime:0.004297s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210B-P' OR `brand` LIKE 'Excelta Corporation%' ) ) LIMIT 1 [ RunTime:0.021392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36874531 LIMIT 4 [ RunTime:0.000457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36874531 ORDER BY `minOrder` ASC [ RunTime:0.009187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36874531 ORDER BY `unit` DESC [ RunTime:0.036642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36874531 LIMIT 2 [ RunTime:0.000576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36874531 ORDER BY `minOrder` ASC [ RunTime:0.008152s ]
select * from pdf where partno='210S-P' and brandshort='Excelta Corporation' limit 1 [ RunTime:0.017088s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210S-P' OR `brand` LIKE 'Excelta Corporation%' ) ) LIMIT 1 [ RunTime:0.026807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35500481 LIMIT 4 [ RunTime:0.008485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35500481 ORDER BY `minOrder` ASC [ RunTime:0.090721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35500481 ORDER BY `unit` DESC [ RunTime:0.035896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35500481 LIMIT 2 [ RunTime:0.014290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35500481 ORDER BY `minOrder` ASC [ RunTime:0.014825s ]
select * from pdf where partno='2107506' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.028458s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107506' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.035782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35500480 LIMIT 4 [ RunTime:0.030301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35500480 ORDER BY `minOrder` ASC [ RunTime:0.044381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35500480 ORDER BY `unit` DESC [ RunTime:0.014645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35500480 LIMIT 2 [ RunTime:0.011233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35500480 ORDER BY `minOrder` ASC [ RunTime:0.040382s ]
select * from pdf where partno='2107780' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.018371s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107780' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.028657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35500427 LIMIT 4 [ RunTime:0.004164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35500427 ORDER BY `minOrder` ASC [ RunTime:0.036094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35500427 ORDER BY `unit` DESC [ RunTime:0.019531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35500427 LIMIT 2 [ RunTime:0.033553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35500427 ORDER BY `minOrder` ASC [ RunTime:0.045171s ]
select * from pdf where partno='2107778' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.022183s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107778' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35498347 LIMIT 4 [ RunTime:0.018952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35498347 ORDER BY `minOrder` ASC [ RunTime:0.069401s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35498347 ORDER BY `unit` DESC [ RunTime:0.047686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35498347 LIMIT 2 [ RunTime:0.000482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35498347 ORDER BY `minOrder` ASC [ RunTime:0.022246s ]
select * from pdf where partno='21033711403' and brandshort='HARTING' limit 1 [ RunTime:0.097575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033711403' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.000583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35498158 LIMIT 4 [ RunTime:0.064434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35498158 ORDER BY `minOrder` ASC [ RunTime:0.110108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35498158 ORDER BY `unit` DESC [ RunTime:0.071795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35498158 LIMIT 2 [ RunTime:0.033695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35498158 ORDER BY `minOrder` ASC [ RunTime:0.032739s ]
select * from pdf where partno='2109405' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.034633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109405' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.051219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35495700 LIMIT 4 [ RunTime:0.014121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35495700 ORDER BY `minOrder` ASC [ RunTime:0.068477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35495700 ORDER BY `unit` DESC [ RunTime:0.057466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35495700 LIMIT 2 [ RunTime:0.012372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35495700 ORDER BY `minOrder` ASC [ RunTime:0.016019s ]
select * from pdf where partno='2107717' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007486s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107717' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35493622 LIMIT 4 [ RunTime:0.000452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35493622 ORDER BY `minOrder` ASC [ RunTime:0.062063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35493622 ORDER BY `unit` DESC [ RunTime:0.024199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35493622 LIMIT 2 [ RunTime:0.009410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35493622 ORDER BY `minOrder` ASC [ RunTime:0.018478s ]
select * from pdf where partno='2108123' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003307s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108123' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35301943 LIMIT 4 [ RunTime:0.008788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35301943 ORDER BY `minOrder` ASC [ RunTime:0.020168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35301943 ORDER BY `unit` DESC [ RunTime:0.031644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35301943 LIMIT 2 [ RunTime:0.018537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35301943 ORDER BY `minOrder` ASC [ RunTime:0.021647s ]
select * from pdf where partno='210112043' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.012301s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210112043' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.028463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34450632 LIMIT 4 [ RunTime:0.012268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34450632 ORDER BY `minOrder` ASC [ RunTime:0.022984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34450632 ORDER BY `unit` DESC [ RunTime:0.038323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34450632 LIMIT 2 [ RunTime:0.007327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34450632 ORDER BY `minOrder` ASC [ RunTime:0.050976s ]
select * from pdf where partno='2109286' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.051078s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109286' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.051658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34450411 LIMIT 4 [ RunTime:0.050875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34450411 ORDER BY `minOrder` ASC [ RunTime:0.051687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34450411 ORDER BY `unit` DESC [ RunTime:0.031411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34450411 LIMIT 2 [ RunTime:0.021604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34450411 ORDER BY `minOrder` ASC [ RunTime:0.060468s ]
select * from pdf where partno='21033092431' and brandshort='HARTING' limit 1 [ RunTime:0.083021s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033092431' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.020042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34448625 LIMIT 4 [ RunTime:0.094991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34448625 ORDER BY `minOrder` ASC [ RunTime:0.053141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34448625 ORDER BY `unit` DESC [ RunTime:0.069833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34448625 LIMIT 2 [ RunTime:0.000522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34448625 ORDER BY `minOrder` ASC [ RunTime:0.046773s ]
select * from pdf where partno='21033211431' and brandshort='HARTING' limit 1 [ RunTime:0.113287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033211431' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.079588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34448575 LIMIT 4 [ RunTime:0.016792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34448575 ORDER BY `minOrder` ASC [ RunTime:0.101112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34448575 ORDER BY `unit` DESC [ RunTime:0.054702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34448575 LIMIT 2 [ RunTime:0.075948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34448575 ORDER BY `minOrder` ASC [ RunTime:0.043004s ]
select * from pdf where partno='21033095503' and brandshort='HARTING' limit 1 [ RunTime:0.080509s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033095503' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.000546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34448573 LIMIT 4 [ RunTime:0.041098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34448573 ORDER BY `minOrder` ASC [ RunTime:0.094805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34448573 ORDER BY `unit` DESC [ RunTime:0.046836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34448573 LIMIT 2 [ RunTime:0.024098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34448573 ORDER BY `minOrder` ASC [ RunTime:0.018693s ]
select * from pdf where partno='21033961402' and brandshort='HARTING' limit 1 [ RunTime:0.018938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033961402' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.032190s ]
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.020638s ]