SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002116s ]
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` = '' , `host` = 'https://ic118.com/stock&keyword=210&page=251&srecordnum=7529' [ RunTime:0.013640s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003152s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004056s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002511s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.006454s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002389s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010537s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.007354s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.025325s ]
UPDATE `stock_search` SET `count` = 4253 , `updatetime` = '2026-06-08 17:23:32' WHERE `partno` = '210' [ RunTime:0.023781s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.024157s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.017186s ]
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.016242s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.004224s ]
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.342646s ]
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 5000,20 [ RunTime:0.078376s ]
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 ('33304525','33304372','33174799','33172084','33171805','33171217','33171210','33171082','33170962','33170829','33170797','33170777','33170775','33170708','33170685','33170666','33170639','33170615','33170565','33170557') ORDER BY FIELD(s.id, 33304525,33304372,33174799,33172084,33171805,33171217,33171210,33171082,33170962,33170829,33170797,33170777,33170775,33170708,33170685,33170666,33170639,33170615,33170565,33170557) [ RunTime:0.191230s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33304525 LIMIT 4 [ RunTime:0.004585s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33304525 ORDER BY `minOrder` ASC [ RunTime:0.112687s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.108625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33304525 ORDER BY `unit` DESC [ RunTime:0.037040s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33304525 LIMIT 2 [ RunTime:0.030004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33304525 ORDER BY `minOrder` ASC [ RunTime:0.022344s ]
select * from pdf where partno='2101.2' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.052635s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003063s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101.2' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.041034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33304372 LIMIT 4 [ RunTime:0.003060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33304372 ORDER BY `minOrder` ASC [ RunTime:0.084752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33304372 ORDER BY `unit` DESC [ RunTime:0.031289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33304372 LIMIT 2 [ RunTime:0.036763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33304372 ORDER BY `minOrder` ASC [ RunTime:0.018381s ]
select * from pdf where partno='2102-1392' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.036023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102-1392' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.008117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33174799 LIMIT 4 [ RunTime:0.030287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33174799 ORDER BY `minOrder` ASC [ RunTime:0.047932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33174799 ORDER BY `unit` DESC [ RunTime:0.031192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33174799 LIMIT 2 [ RunTime:0.064023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33174799 ORDER BY `minOrder` ASC [ RunTime:0.019829s ]
select * from pdf where partno='2100-0065' and brandshort='Metcal' limit 1 [ RunTime:0.041130s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100-0065' OR `brand` LIKE 'Metcal%' ) ) LIMIT 1 [ RunTime:0.037941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33172084 LIMIT 4 [ RunTime:0.006512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33172084 ORDER BY `minOrder` ASC [ RunTime:0.055064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33172084 ORDER BY `unit` DESC [ RunTime:0.040547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33172084 LIMIT 2 [ RunTime:0.028730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33172084 ORDER BY `minOrder` ASC [ RunTime:0.060958s ]
select * from pdf where partno='21094' and brandshort='Wiha' limit 1 [ RunTime:0.031397s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21094' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.072359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33171805 LIMIT 4 [ RunTime:0.027797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33171805 ORDER BY `minOrder` ASC [ RunTime:0.076898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33171805 ORDER BY `unit` DESC [ RunTime:0.060643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33171805 LIMIT 2 [ RunTime:0.022091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33171805 ORDER BY `minOrder` ASC [ RunTime:0.019904s ]
select * from pdf where partno='21095' and brandshort='Wiha' limit 1 [ RunTime:0.058004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21095' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.046200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33171217 LIMIT 4 [ RunTime:0.024539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33171217 ORDER BY `minOrder` ASC [ RunTime:0.065437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33171217 ORDER BY `unit` DESC [ RunTime:0.110957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33171217 LIMIT 2 [ RunTime:0.033350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33171217 ORDER BY `minOrder` ASC [ RunTime:0.012631s ]
select * from pdf where partno='21032' and brandshort='Wiha' limit 1 [ RunTime:0.019058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21032' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.012981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33171210 LIMIT 4 [ RunTime:0.015768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33171210 ORDER BY `minOrder` ASC [ RunTime:0.152514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33171210 ORDER BY `unit` DESC [ RunTime:0.000969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33171210 LIMIT 2 [ RunTime:0.010707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33171210 ORDER BY `minOrder` ASC [ RunTime:0.004545s ]
select * from pdf where partno='21030' and brandshort='Wiha' limit 1 [ RunTime:0.011874s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21030' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.009510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33171082 LIMIT 4 [ RunTime:0.008221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33171082 ORDER BY `minOrder` ASC [ RunTime:0.064181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33171082 ORDER BY `unit` DESC [ RunTime:0.017212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33171082 LIMIT 2 [ RunTime:0.008838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33171082 ORDER BY `minOrder` ASC [ RunTime:0.005431s ]
select * from pdf where partno='21027' and brandshort='Wiha' limit 1 [ RunTime:0.002118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21027' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.018861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170962 LIMIT 4 [ RunTime:0.000458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170962 ORDER BY `minOrder` ASC [ RunTime:0.046717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170962 ORDER BY `unit` DESC [ RunTime:0.028518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170962 LIMIT 2 [ RunTime:0.059509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170962 ORDER BY `minOrder` ASC [ RunTime:0.009691s ]
select * from pdf where partno='21024' and brandshort='Wiha' limit 1 [ RunTime:0.019713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21024' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.034808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170829 LIMIT 4 [ RunTime:0.007182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170829 ORDER BY `minOrder` ASC [ RunTime:0.041817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170829 ORDER BY `unit` DESC [ RunTime:0.065261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170829 LIMIT 2 [ RunTime:0.011201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170829 ORDER BY `minOrder` ASC [ RunTime:0.004339s ]
select * from pdf where partno='21022' and brandshort='Wiha' limit 1 [ RunTime:0.009544s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21022' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.020658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170797 LIMIT 4 [ RunTime:0.009664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170797 ORDER BY `minOrder` ASC [ RunTime:0.014563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170797 ORDER BY `unit` DESC [ RunTime:0.016431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170797 LIMIT 2 [ RunTime:0.045810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170797 ORDER BY `minOrder` ASC [ RunTime:0.026257s ]
select * from pdf where partno='21068' and brandshort='Wiha' limit 1 [ RunTime:0.001277s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21068' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.008857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170777 LIMIT 4 [ RunTime:0.011844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170777 ORDER BY `minOrder` ASC [ RunTime:0.024317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170777 ORDER BY `unit` DESC [ RunTime:0.017989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170777 LIMIT 2 [ RunTime:0.009706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170777 ORDER BY `minOrder` ASC [ RunTime:0.014993s ]
select * from pdf where partno='21066' and brandshort='Wiha' limit 1 [ RunTime:0.031318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21066' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.006287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170775 LIMIT 4 [ RunTime:0.009717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170775 ORDER BY `minOrder` ASC [ RunTime:0.001411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170775 ORDER BY `unit` DESC [ RunTime:0.013723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170775 LIMIT 2 [ RunTime:0.012216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170775 ORDER BY `minOrder` ASC [ RunTime:0.006251s ]
select * from pdf where partno='21020' and brandshort='Wiha' limit 1 [ RunTime:0.020477s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21020' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.000952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170708 LIMIT 4 [ RunTime:0.001557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170708 ORDER BY `minOrder` ASC [ RunTime:0.037742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170708 ORDER BY `unit` DESC [ RunTime:0.042318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170708 LIMIT 2 [ RunTime:0.016432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170708 ORDER BY `minOrder` ASC [ RunTime:0.005895s ]
select * from pdf where partno='21019' and brandshort='Wiha' limit 1 [ RunTime:0.017775s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21019' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.018938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170685 LIMIT 4 [ RunTime:0.005545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170685 ORDER BY `minOrder` ASC [ RunTime:0.029421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170685 ORDER BY `unit` DESC [ RunTime:0.042668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170685 LIMIT 2 [ RunTime:0.027520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170685 ORDER BY `minOrder` ASC [ RunTime:0.002754s ]
select * from pdf where partno='21064' and brandshort='Wiha' limit 1 [ RunTime:0.004314s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21064' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.031603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170666 LIMIT 4 [ RunTime:0.004049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170666 ORDER BY `minOrder` ASC [ RunTime:0.023710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170666 ORDER BY `unit` DESC [ RunTime:0.007904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170666 LIMIT 2 [ RunTime:0.008124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170666 ORDER BY `minOrder` ASC [ RunTime:0.000884s ]
select * from pdf where partno='21017' and brandshort='Wiha' limit 1 [ RunTime:0.012568s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21017' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.025763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170639 LIMIT 4 [ RunTime:0.002491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170639 ORDER BY `minOrder` ASC [ RunTime:0.022787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170639 ORDER BY `unit` DESC [ RunTime:0.005917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170639 LIMIT 2 [ RunTime:0.003523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170639 ORDER BY `minOrder` ASC [ RunTime:0.006403s ]
select * from pdf where partno='21062' and brandshort='Wiha' limit 1 [ RunTime:0.003987s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21062' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.021363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170615 LIMIT 4 [ RunTime:0.019931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170615 ORDER BY `minOrder` ASC [ RunTime:0.028906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170615 ORDER BY `unit` DESC [ RunTime:0.006498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170615 LIMIT 2 [ RunTime:0.001791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170615 ORDER BY `minOrder` ASC [ RunTime:0.000830s ]
select * from pdf where partno='21060' and brandshort='Wiha' limit 1 [ RunTime:0.003113s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21060' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.020739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170565 LIMIT 4 [ RunTime:0.021647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170565 ORDER BY `minOrder` ASC [ RunTime:0.069099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170565 ORDER BY `unit` DESC [ RunTime:0.007032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170565 LIMIT 2 [ RunTime:0.004066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170565 ORDER BY `minOrder` ASC [ RunTime:0.011321s ]
select * from pdf where partno='21058' and brandshort='Wiha' limit 1 [ RunTime:0.009445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21058' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.011385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33170557 LIMIT 4 [ RunTime:0.005026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170557 ORDER BY `minOrder` ASC [ RunTime:0.013336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33170557 ORDER BY `unit` DESC [ RunTime:0.020775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33170557 LIMIT 2 [ RunTime:0.007856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33170557 ORDER BY `minOrder` ASC [ RunTime:0.003587s ]
select * from pdf where partno='21015' and brandshort='Wiha' limit 1 [ RunTime:0.005160s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21015' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.000634s ]
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.105771s ]