SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001531s ]
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.024698s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002120s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.011380s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001789s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.022637s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001526s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.012996s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001398s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.016032s ]
UPDATE `stock_search` SET `count` = 4128 , `updatetime` = '2026-06-08 16:47:37' WHERE `partno` = '210' [ RunTime:0.004273s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.017171s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.023829s ]
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.005259s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002189s ]
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.007139s ]
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 4080,20 [ RunTime:0.098540s ]
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 ('35538260','35538259','35538106','35538056','35537305','35536241','35536043','35536001','35535338','35535166','35535053','35534987','35534809','35534808','35534294','35534069','35533825','35533815','35533776','35533191') ORDER BY FIELD(s.id, 35538260,35538259,35538106,35538056,35537305,35536241,35536043,35536001,35535338,35535166,35535053,35534987,35534809,35534808,35534294,35534069,35533825,35533815,35533776,35533191) [ RunTime:0.122986s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.035106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35538260 LIMIT 4 [ RunTime:0.022727s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35538260 ORDER BY `minOrder` ASC [ RunTime:0.029384s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35538260 ORDER BY `unit` DESC [ RunTime:0.010503s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35538260 LIMIT 2 [ RunTime:0.002004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35538260 ORDER BY `minOrder` ASC [ RunTime:0.006325s ]
select * from pdf where partno='2107786' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.016922s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002243s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107786' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.043440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35538259 LIMIT 4 [ RunTime:0.013033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35538259 ORDER BY `minOrder` ASC [ RunTime:0.047176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35538259 ORDER BY `unit` DESC [ RunTime:0.013716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35538259 LIMIT 2 [ RunTime:0.023379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35538259 ORDER BY `minOrder` ASC [ RunTime:0.017758s ]
select * from pdf where partno='2107519' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107519' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35538106 LIMIT 4 [ RunTime:0.003627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35538106 ORDER BY `minOrder` ASC [ RunTime:0.004366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35538106 ORDER BY `unit` DESC [ RunTime:0.016052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35538106 LIMIT 2 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35538106 ORDER BY `minOrder` ASC [ RunTime:0.010965s ]
select * from pdf where partno='21035853451' and brandshort='HARTING' limit 1 [ RunTime:0.005907s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035853451' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.003295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35538056 LIMIT 4 [ RunTime:0.009900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35538056 ORDER BY `minOrder` ASC [ RunTime:0.011386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35538056 ORDER BY `unit` DESC [ RunTime:0.025445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35538056 LIMIT 2 [ RunTime:0.003617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35538056 ORDER BY `minOrder` ASC [ RunTime:0.015858s ]
select * from pdf where partno='2106283' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017922s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106283' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35537305 LIMIT 4 [ RunTime:0.004602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35537305 ORDER BY `minOrder` ASC [ RunTime:0.025916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35537305 ORDER BY `unit` DESC [ RunTime:0.018249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35537305 LIMIT 2 [ RunTime:0.002622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35537305 ORDER BY `minOrder` ASC [ RunTime:0.000570s ]
select * from pdf where partno='2107807' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107807' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35536241 LIMIT 4 [ RunTime:0.012148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35536241 ORDER BY `minOrder` ASC [ RunTime:0.053057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35536241 ORDER BY `unit` DESC [ RunTime:0.021250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35536241 LIMIT 2 [ RunTime:0.025404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35536241 ORDER BY `minOrder` ASC [ RunTime:0.012866s ]
select * from pdf where partno='2107806' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107806' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35536043 LIMIT 4 [ RunTime:0.002896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35536043 ORDER BY `minOrder` ASC [ RunTime:0.001773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35536043 ORDER BY `unit` DESC [ RunTime:0.011027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35536043 LIMIT 2 [ RunTime:0.006677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35536043 ORDER BY `minOrder` ASC [ RunTime:0.008949s ]
select * from pdf where partno='21035992535' and brandshort='HARTING' limit 1 [ RunTime:0.032458s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035992535' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.010190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35536001 LIMIT 4 [ RunTime:0.053838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35536001 ORDER BY `minOrder` ASC [ RunTime:0.057725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35536001 ORDER BY `unit` DESC [ RunTime:0.010448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35536001 LIMIT 2 [ RunTime:0.006978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35536001 ORDER BY `minOrder` ASC [ RunTime:0.012923s ]
select * from pdf where partno='21035851451' and brandshort='HARTING' limit 1 [ RunTime:0.033635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035851451' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.017799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35535338 LIMIT 4 [ RunTime:0.018859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35535338 ORDER BY `minOrder` ASC [ RunTime:0.046803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35535338 ORDER BY `unit` DESC [ RunTime:0.015786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35535338 LIMIT 2 [ RunTime:0.044750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35535338 ORDER BY `minOrder` ASC [ RunTime:0.030096s ]
select * from pdf where partno='21035853401' and brandshort='HARTING' limit 1 [ RunTime:0.040690s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035853401' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.035395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35535166 LIMIT 4 [ RunTime:0.027231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35535166 ORDER BY `minOrder` ASC [ RunTime:0.057700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35535166 ORDER BY `unit` DESC [ RunTime:0.029263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35535166 LIMIT 2 [ RunTime:0.026745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35535166 ORDER BY `minOrder` ASC [ RunTime:0.002877s ]
select * from pdf where partno='21035991535' and brandshort='HARTING' limit 1 [ RunTime:0.012501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035991535' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.006238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35535053 LIMIT 4 [ RunTime:0.015217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35535053 ORDER BY `minOrder` ASC [ RunTime:0.076338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35535053 ORDER BY `unit` DESC [ RunTime:0.021856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35535053 LIMIT 2 [ RunTime:0.032796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35535053 ORDER BY `minOrder` ASC [ RunTime:0.029756s ]
select * from pdf where partno='2101503' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.046469s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101503' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.023165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35534987 LIMIT 4 [ RunTime:0.020666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35534987 ORDER BY `minOrder` ASC [ RunTime:0.132310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35534987 ORDER BY `unit` DESC [ RunTime:0.041315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35534987 LIMIT 2 [ RunTime:0.020574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35534987 ORDER BY `minOrder` ASC [ RunTime:0.010276s ]
select * from pdf where partno='21035962535' and brandshort='HARTING' limit 1 [ RunTime:0.007206s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035962535' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.005192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35534809 LIMIT 4 [ RunTime:0.024589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35534809 ORDER BY `minOrder` ASC [ RunTime:0.029291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35534809 ORDER BY `unit` DESC [ RunTime:0.065895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35534809 LIMIT 2 [ RunTime:0.080815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35534809 ORDER BY `minOrder` ASC [ RunTime:0.028485s ]
select * from pdf where partno='21035961535' and brandshort='HARTING' limit 1 [ RunTime:0.000455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035961535' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.015091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35534808 LIMIT 4 [ RunTime:0.056125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35534808 ORDER BY `minOrder` ASC [ RunTime:0.083615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35534808 ORDER BY `unit` DESC [ RunTime:0.003018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35534808 LIMIT 2 [ RunTime:0.017435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35534808 ORDER BY `minOrder` ASC [ RunTime:0.000525s ]
select * from pdf where partno='21035961516' and brandshort='HARTING' limit 1 [ RunTime:0.003263s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035961516' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.049466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35534294 LIMIT 4 [ RunTime:0.000643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35534294 ORDER BY `minOrder` ASC [ RunTime:0.093178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35534294 ORDER BY `unit` DESC [ RunTime:0.054002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35534294 LIMIT 2 [ RunTime:0.027196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35534294 ORDER BY `minOrder` ASC [ RunTime:0.028057s ]
select * from pdf where partno='2107781' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.029646s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107781' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35534069 LIMIT 4 [ RunTime:0.050782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35534069 ORDER BY `minOrder` ASC [ RunTime:0.048506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35534069 ORDER BY `unit` DESC [ RunTime:0.028062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35534069 LIMIT 2 [ RunTime:0.039891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35534069 ORDER BY `minOrder` ASC [ RunTime:0.018303s ]
select * from pdf where partno='21033176810' and brandshort='HARTING' limit 1 [ RunTime:0.017732s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033176810' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.021389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35533825 LIMIT 4 [ RunTime:0.014562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35533825 ORDER BY `minOrder` ASC [ RunTime:0.056783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35533825 ORDER BY `unit` DESC [ RunTime:0.078744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35533825 LIMIT 2 [ RunTime:0.038499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35533825 ORDER BY `minOrder` ASC [ RunTime:0.025660s ]
select * from pdf where partno='2101346' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.026540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101346' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.029547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35533815 LIMIT 4 [ RunTime:0.018090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35533815 ORDER BY `minOrder` ASC [ RunTime:0.091679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35533815 ORDER BY `unit` DESC [ RunTime:0.046542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35533815 LIMIT 2 [ RunTime:0.028637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35533815 ORDER BY `minOrder` ASC [ RunTime:0.030225s ]
select * from pdf where partno='2107811' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.038647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107811' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.030545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35533776 LIMIT 4 [ RunTime:0.043954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35533776 ORDER BY `minOrder` ASC [ RunTime:0.024380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35533776 ORDER BY `unit` DESC [ RunTime:0.016546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35533776 LIMIT 2 [ RunTime:0.040665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35533776 ORDER BY `minOrder` ASC [ RunTime:0.015812s ]
select * from pdf where partno='21035851401' and brandshort='HARTING' limit 1 [ RunTime:0.014522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035851401' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.016124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35533191 LIMIT 4 [ RunTime:0.080726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35533191 ORDER BY `minOrder` ASC [ RunTime:0.103995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35533191 ORDER BY `unit` DESC [ RunTime:0.049510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35533191 LIMIT 2 [ RunTime:0.024229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35533191 ORDER BY `minOrder` ASC [ RunTime:0.034660s ]
select * from pdf where partno='2107785' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.072699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107785' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.025324s ]
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.015728s ]