SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002927s ]
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.001711s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002227s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000615s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001868s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.001360s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001357s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000293s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003401s ]
SELECT * FROM `stock_search` WHERE `partno` = '980' LIMIT 1 [ RunTime:0.009784s ]
UPDATE `stock_search` SET `count` = 425 , `updatetime` = '2026-06-05 13:01:11' WHERE `partno` = '980' [ RunTime:0.008838s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001900s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.004953s ]
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.006545s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001487s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '980%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.003495s ]
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 '980%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 360,20 [ RunTime:0.017021s ]
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 ('32315698','32315428','32315193','32315010','32314936','32314925','32314924','32314751','32314477','32314476','32314439','32314287','32314265','32314264','32314236','32314235','32312270','20093928','19597128','19596936') ORDER BY FIELD(s.id, 32315698,32315428,32315193,32315010,32314936,32314925,32314924,32314751,32314477,32314476,32314439,32314287,32314265,32314264,32314236,32314235,32312270,20093928,19597128,19596936) [ RunTime:0.008392s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32315698 LIMIT 4 [ RunTime:0.008093s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32315698 ORDER BY `minOrder` ASC [ RunTime:0.030654s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32315698 ORDER BY `unit` DESC [ RunTime:0.004982s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32315698 LIMIT 2 [ RunTime:0.019106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32315698 ORDER BY `minOrder` ASC [ RunTime:0.023791s ]
select * from pdf where partno='980-8666-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.026630s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8666-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.044489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32315428 LIMIT 4 [ RunTime:0.008199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32315428 ORDER BY `minOrder` ASC [ RunTime:0.021211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32315428 ORDER BY `unit` DESC [ RunTime:0.024151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32315428 LIMIT 2 [ RunTime:0.026481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32315428 ORDER BY `minOrder` ASC [ RunTime:0.013120s ]
select * from pdf where partno='9808563001' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.036927s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9808563001' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.008086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32315193 LIMIT 4 [ RunTime:0.046598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32315193 ORDER BY `minOrder` ASC [ RunTime:0.028910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32315193 ORDER BY `unit` DESC [ RunTime:0.025441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32315193 LIMIT 2 [ RunTime:0.056062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32315193 ORDER BY `minOrder` ASC [ RunTime:0.001952s ]
select * from pdf where partno='980-8551-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.135523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8551-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.080663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32315010 LIMIT 4 [ RunTime:0.102757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32315010 ORDER BY `minOrder` ASC [ RunTime:0.037982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32315010 ORDER BY `unit` DESC [ RunTime:0.016405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32315010 LIMIT 2 [ RunTime:0.023900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32315010 ORDER BY `minOrder` ASC [ RunTime:0.001292s ]
select * from pdf where partno='980-8557-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.046647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8557-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.065419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314936 LIMIT 4 [ RunTime:0.000824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314936 ORDER BY `minOrder` ASC [ RunTime:0.014425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314936 ORDER BY `unit` DESC [ RunTime:0.028048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314936 LIMIT 2 [ RunTime:0.016937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314936 ORDER BY `minOrder` ASC [ RunTime:0.017386s ]
select * from pdf where partno='980-8556-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.034708s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8556-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.019771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314925 LIMIT 4 [ RunTime:0.087929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314925 ORDER BY `minOrder` ASC [ RunTime:0.067907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314925 ORDER BY `unit` DESC [ RunTime:0.017009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314925 LIMIT 2 [ RunTime:0.028024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314925 ORDER BY `minOrder` ASC [ RunTime:0.015410s ]
select * from pdf where partno='980-8666-004' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.020772s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8666-004' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.049133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314924 LIMIT 4 [ RunTime:0.041082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314924 ORDER BY `minOrder` ASC [ RunTime:0.032139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314924 ORDER BY `unit` DESC [ RunTime:0.034956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314924 LIMIT 2 [ RunTime:0.032448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314924 ORDER BY `minOrder` ASC [ RunTime:0.015149s ]
select * from pdf where partno='980-8558-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.014777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8558-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.009792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314751 LIMIT 4 [ RunTime:0.006461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314751 ORDER BY `minOrder` ASC [ RunTime:0.033591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314751 ORDER BY `unit` DESC [ RunTime:0.004100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314751 LIMIT 2 [ RunTime:0.012848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314751 ORDER BY `minOrder` ASC [ RunTime:0.008514s ]
select * from pdf where partno='980-8666-005' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.016850s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8666-005' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.015460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314477 LIMIT 4 [ RunTime:0.011745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314477 ORDER BY `minOrder` ASC [ RunTime:0.013346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314477 ORDER BY `unit` DESC [ RunTime:0.012753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314477 LIMIT 2 [ RunTime:0.007601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314477 ORDER BY `minOrder` ASC [ RunTime:0.008995s ]
select * from pdf where partno='980-8553-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.017824s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8553-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.004951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314476 LIMIT 4 [ RunTime:0.017524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314476 ORDER BY `minOrder` ASC [ RunTime:0.008316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314476 ORDER BY `unit` DESC [ RunTime:0.013330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314476 LIMIT 2 [ RunTime:0.010690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314476 ORDER BY `minOrder` ASC [ RunTime:0.005122s ]
select * from pdf where partno='980-8554-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.007038s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8554-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.019089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314439 LIMIT 4 [ RunTime:0.008850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314439 ORDER BY `minOrder` ASC [ RunTime:0.009202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314439 ORDER BY `unit` DESC [ RunTime:0.018530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314439 LIMIT 2 [ RunTime:0.016672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314439 ORDER BY `minOrder` ASC [ RunTime:0.007009s ]
select * from pdf where partno='980-8555-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.008631s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8555-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.014792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314287 LIMIT 4 [ RunTime:0.017147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314287 ORDER BY `minOrder` ASC [ RunTime:0.008052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314287 ORDER BY `unit` DESC [ RunTime:0.006028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314287 LIMIT 2 [ RunTime:0.011347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314287 ORDER BY `minOrder` ASC [ RunTime:0.018722s ]
select * from pdf where partno='980-8550-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.024962s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8550-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.015016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314265 LIMIT 4 [ RunTime:0.004244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314265 ORDER BY `minOrder` ASC [ RunTime:0.015903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314265 ORDER BY `unit` DESC [ RunTime:0.003576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314265 LIMIT 2 [ RunTime:0.008658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314265 ORDER BY `minOrder` ASC [ RunTime:0.004544s ]
select * from pdf where partno='9808667071' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.017593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9808667071' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.016320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314264 LIMIT 4 [ RunTime:0.005666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314264 ORDER BY `minOrder` ASC [ RunTime:0.015254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314264 ORDER BY `unit` DESC [ RunTime:0.027146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314264 LIMIT 2 [ RunTime:0.021220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314264 ORDER BY `minOrder` ASC [ RunTime:0.015014s ]
select * from pdf where partno='980-8666-002' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.025839s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8666-002' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.028156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314236 LIMIT 4 [ RunTime:0.029947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314236 ORDER BY `minOrder` ASC [ RunTime:0.011987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314236 ORDER BY `unit` DESC [ RunTime:0.011254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314236 LIMIT 2 [ RunTime:0.016122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314236 ORDER BY `minOrder` ASC [ RunTime:0.001035s ]
select * from pdf where partno='9808667072' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.001345s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9808667072' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.003947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314235 LIMIT 4 [ RunTime:0.000577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314235 ORDER BY `minOrder` ASC [ RunTime:0.000561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314235 ORDER BY `unit` DESC [ RunTime:0.005304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314235 LIMIT 2 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314235 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='980-8552-000' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.009109s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '980-8552-000' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.005347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32312270 LIMIT 4 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32312270 ORDER BY `minOrder` ASC [ RunTime:0.003361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32312270 ORDER BY `unit` DESC [ RunTime:0.001993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32312270 LIMIT 2 [ RunTime:0.002291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32312270 ORDER BY `minOrder` ASC [ RunTime:0.002508s ]
select * from pdf where partno='9808637003' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.008578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9808637003' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.001894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20093928 LIMIT 4 [ RunTime:0.006582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20093928 ORDER BY `minOrder` ASC [ RunTime:0.007917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20093928 ORDER BY `unit` DESC [ RunTime:0.006434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20093928 LIMIT 2 [ RunTime:0.008111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20093928 ORDER BY `minOrder` ASC [ RunTime:0.002009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19597128 LIMIT 4 [ RunTime:0.003124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19597128 ORDER BY `minOrder` ASC [ RunTime:0.005898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19597128 ORDER BY `unit` DESC [ RunTime:0.008676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19597128 LIMIT 2 [ RunTime:0.001831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19597128 ORDER BY `minOrder` ASC [ RunTime:0.000480s ]
select * from pdf where partno='9801-0-15-21-23-14-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.002523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596936 LIMIT 4 [ RunTime:0.003204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596936 ORDER BY `minOrder` ASC [ RunTime:0.001511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19596936 ORDER BY `unit` DESC [ RunTime:0.009730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19596936 LIMIT 2 [ RunTime:0.003208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596936 ORDER BY `minOrder` ASC [ RunTime:0.001527s ]
select * from pdf where partno='9801-0-15-15-23-14-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.006038s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '980%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.001244s ]