SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002203s ]
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=213&srecordnum=7529' [ RunTime:0.005473s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001821s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000860s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002768s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.004226s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001982s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003535s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002180s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.004083s ]
UPDATE `stock_search` SET `count` = 5626 , `updatetime` = '2026-06-08 22:55:39' WHERE `partno` = '210' [ RunTime:0.001513s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.005063s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000964s ]
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.008098s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002105s ]
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.000997s ]
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 4240,20 [ RunTime:0.099663s ]
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 ('34521040','34520685','34519604','34511664','34511444','34510449','34510097','34509919','34509326','34508039','34508038','34507537','34507039','34507038','34506559','34506509','34506232','34505741','34505540','34505253') ORDER BY FIELD(s.id, 34521040,34520685,34519604,34511664,34511444,34510449,34510097,34509919,34509326,34508039,34508038,34507537,34507039,34507038,34506559,34506509,34506232,34505741,34505540,34505253) [ RunTime:0.007185s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34521040 LIMIT 4 [ RunTime:0.000772s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34521040 ORDER BY `minOrder` ASC [ RunTime:0.026339s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34521040 ORDER BY `unit` DESC [ RunTime:0.010477s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34521040 LIMIT 2 [ RunTime:0.029189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34521040 ORDER BY `minOrder` ASC [ RunTime:0.011149s ]
select * from pdf where partno='21033411505' and brandshort='HARTING' limit 1 [ RunTime:0.020419s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033411505' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.010868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34520685 LIMIT 4 [ RunTime:0.016766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34520685 ORDER BY `minOrder` ASC [ RunTime:0.011589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34520685 ORDER BY `unit` DESC [ RunTime:0.018107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34520685 LIMIT 2 [ RunTime:0.026400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34520685 ORDER BY `minOrder` ASC [ RunTime:0.017704s ]
select * from pdf where partno='21033962530' and brandshort='HARTING' limit 1 [ RunTime:0.008738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033962530' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.011283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34519604 LIMIT 4 [ RunTime:0.016201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34519604 ORDER BY `minOrder` ASC [ RunTime:0.032486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34519604 ORDER BY `unit` DESC [ RunTime:0.027124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34519604 LIMIT 2 [ RunTime:0.013325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34519604 ORDER BY `minOrder` ASC [ RunTime:0.000772s ]
select * from pdf where partno='21037991405' and brandshort='HARTING' limit 1 [ RunTime:0.012168s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21037991405' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.023510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34511664 LIMIT 4 [ RunTime:0.022650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34511664 ORDER BY `minOrder` ASC [ RunTime:0.018849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34511664 ORDER BY `unit` DESC [ RunTime:0.021687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34511664 LIMIT 2 [ RunTime:0.020818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34511664 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
select * from pdf where partno='21033411531' and brandshort='HARTING' limit 1 [ RunTime:0.008282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033411531' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.038054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34511444 LIMIT 4 [ RunTime:0.016467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34511444 ORDER BY `minOrder` ASC [ RunTime:0.023154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34511444 ORDER BY `unit` DESC [ RunTime:0.016538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34511444 LIMIT 2 [ RunTime:0.025520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34511444 ORDER BY `minOrder` ASC [ RunTime:0.014948s ]
select * from pdf where partno='21033212430' and brandshort='HARTING' limit 1 [ RunTime:0.012365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033212430' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.038588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34510449 LIMIT 4 [ RunTime:0.007885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34510449 ORDER BY `minOrder` ASC [ RunTime:0.010972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34510449 ORDER BY `unit` DESC [ RunTime:0.033931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34510449 LIMIT 2 [ RunTime:0.052545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34510449 ORDER BY `minOrder` ASC [ RunTime:0.004707s ]
select * from pdf where partno='21032721506' and brandshort='HARTING' limit 1 [ RunTime:0.036625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21032721506' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.022647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34510097 LIMIT 4 [ RunTime:0.023937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34510097 ORDER BY `minOrder` ASC [ RunTime:0.021690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34510097 ORDER BY `unit` DESC [ RunTime:0.024395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34510097 LIMIT 2 [ RunTime:0.027676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34510097 ORDER BY `minOrder` ASC [ RunTime:0.012766s ]
select * from pdf where partno='21033814437' and brandshort='HARTING' limit 1 [ RunTime:0.030423s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033814437' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.050535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34509919 LIMIT 4 [ RunTime:0.035971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34509919 ORDER BY `minOrder` ASC [ RunTime:0.029847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34509919 ORDER BY `unit` DESC [ RunTime:0.021419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34509919 LIMIT 2 [ RunTime:0.031972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34509919 ORDER BY `minOrder` ASC [ RunTime:0.042797s ]
select * from pdf where partno='21033211420' and brandshort='HARTING' limit 1 [ RunTime:0.000612s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033211420' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.032163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34509326 LIMIT 4 [ RunTime:0.069480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34509326 ORDER BY `minOrder` ASC [ RunTime:0.060308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34509326 ORDER BY `unit` DESC [ RunTime:0.034917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34509326 LIMIT 2 [ RunTime:0.036330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34509326 ORDER BY `minOrder` ASC [ RunTime:0.005395s ]
select * from pdf where partno='21033211430' and brandshort='HARTING' limit 1 [ RunTime:0.003625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033211430' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.010599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34508039 LIMIT 4 [ RunTime:0.018329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34508039 ORDER BY `minOrder` ASC [ RunTime:0.011273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34508039 ORDER BY `unit` DESC [ RunTime:0.041738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34508039 LIMIT 2 [ RunTime:0.015220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34508039 ORDER BY `minOrder` ASC [ RunTime:0.023096s ]
select * from pdf where partno='21033096501' and brandshort='HARTING' limit 1 [ RunTime:0.003890s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033096501' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.015791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34508038 LIMIT 4 [ RunTime:0.008240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34508038 ORDER BY `minOrder` ASC [ RunTime:0.013031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34508038 ORDER BY `unit` DESC [ RunTime:0.016753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34508038 LIMIT 2 [ RunTime:0.002047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34508038 ORDER BY `minOrder` ASC [ RunTime:0.013129s ]
select * from pdf where partno='21033096502' and brandshort='HARTING' limit 1 [ RunTime:0.030391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033096502' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.015286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34507537 LIMIT 4 [ RunTime:0.050514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34507537 ORDER BY `minOrder` ASC [ RunTime:0.024488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34507537 ORDER BY `unit` DESC [ RunTime:0.014866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34507537 LIMIT 2 [ RunTime:0.030977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34507537 ORDER BY `minOrder` ASC [ RunTime:0.006722s ]
select * from pdf where partno='21033992402' and brandshort='HARTING' limit 1 [ RunTime:0.015382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033992402' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.032416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34507039 LIMIT 4 [ RunTime:0.008910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34507039 ORDER BY `minOrder` ASC [ RunTime:0.021395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34507039 ORDER BY `unit` DESC [ RunTime:0.014115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34507039 LIMIT 2 [ RunTime:0.043734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34507039 ORDER BY `minOrder` ASC [ RunTime:0.023598s ]
select * from pdf where partno='21033096503' and brandshort='HARTING' limit 1 [ RunTime:0.007866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033096503' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.014516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34507038 LIMIT 4 [ RunTime:0.036638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34507038 ORDER BY `minOrder` ASC [ RunTime:0.034093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34507038 ORDER BY `unit` DESC [ RunTime:0.035083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34507038 LIMIT 2 [ RunTime:0.011235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34507038 ORDER BY `minOrder` ASC [ RunTime:0.022885s ]
select * from pdf where partno='21033096504' and brandshort='HARTING' limit 1 [ RunTime:0.001523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033096504' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.022778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34506559 LIMIT 4 [ RunTime:0.016527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34506559 ORDER BY `minOrder` ASC [ RunTime:0.029508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34506559 ORDER BY `unit` DESC [ RunTime:0.024734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34506559 LIMIT 2 [ RunTime:0.009645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34506559 ORDER BY `minOrder` ASC [ RunTime:0.002407s ]
select * from pdf where partno='21037992405' and brandshort='HARTING' limit 1 [ RunTime:0.021745s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21037992405' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.041686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34506509 LIMIT 4 [ RunTime:0.038980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34506509 ORDER BY `minOrder` ASC [ RunTime:0.014629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34506509 ORDER BY `unit` DESC [ RunTime:0.022786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34506509 LIMIT 2 [ RunTime:0.055097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34506509 ORDER BY `minOrder` ASC [ RunTime:0.025459s ]
select * from pdf where partno='21033962402' and brandshort='HARTING' limit 1 [ RunTime:0.006772s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033962402' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.024719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34506232 LIMIT 4 [ RunTime:0.012598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34506232 ORDER BY `minOrder` ASC [ RunTime:0.011928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34506232 ORDER BY `unit` DESC [ RunTime:0.006669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34506232 LIMIT 2 [ RunTime:0.028548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34506232 ORDER BY `minOrder` ASC [ RunTime:0.008872s ]
select * from pdf where partno='21033814417' and brandshort='HARTING' limit 1 [ RunTime:0.005251s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033814417' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.029671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34505741 LIMIT 4 [ RunTime:0.008302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34505741 ORDER BY `minOrder` ASC [ RunTime:0.036967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34505741 ORDER BY `unit` DESC [ RunTime:0.025979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34505741 LIMIT 2 [ RunTime:0.012187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34505741 ORDER BY `minOrder` ASC [ RunTime:0.018017s ]
select * from pdf where partno='21038212526' and brandshort='HARTING' limit 1 [ RunTime:0.017997s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21038212526' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.026754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34505540 LIMIT 4 [ RunTime:0.045559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34505540 ORDER BY `minOrder` ASC [ RunTime:0.045116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34505540 ORDER BY `unit` DESC [ RunTime:0.037612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34505540 LIMIT 2 [ RunTime:0.078335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34505540 ORDER BY `minOrder` ASC [ RunTime:0.044236s ]
select * from pdf where partno='21033095501' and brandshort='HARTING' limit 1 [ RunTime:0.010516s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033095501' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.035187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34505253 LIMIT 4 [ RunTime:0.041679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34505253 ORDER BY `minOrder` ASC [ RunTime:0.057771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34505253 ORDER BY `unit` DESC [ RunTime:0.022124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34505253 LIMIT 2 [ RunTime:0.070530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34505253 ORDER BY `minOrder` ASC [ RunTime:0.034371s ]
select * from pdf where partno='21033814416' and brandshort='HARTING' limit 1 [ RunTime:0.023271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033814416' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.045866s ]
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.003417s ]