SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001429s ]
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=206&srecordnum=7529' [ RunTime:0.008373s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001454s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000664s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002563s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.000270s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001137s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000200s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.000942s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000691s ]
UPDATE `stock_search` SET `count` = 4510 , `updatetime` = '2026-06-08 18:30:48' WHERE `partno` = '210' [ RunTime:0.008578s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001447s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000170s ]
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.000285s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001248s ]
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.000566s ]
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 4100,20 [ RunTime:0.048580s ]
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 ('35533190','35533021','35532403','35532402','35532012','35531736','35531077','35530953','35530837','35530043','35529743','35529714','35529319','35529207','35528363','35528362','35528361','35528359','35528357','35526969') ORDER BY FIELD(s.id, 35533190,35533021,35532403,35532402,35532012,35531736,35531077,35530953,35530837,35530043,35529743,35529714,35529319,35529207,35528363,35528362,35528361,35528359,35528357,35526969) [ RunTime:0.006095s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35533190 LIMIT 4 [ RunTime:0.020812s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.010397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35533190 ORDER BY `minOrder` ASC [ RunTime:0.004709s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35533190 ORDER BY `unit` DESC [ RunTime:0.002878s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35533190 LIMIT 2 [ RunTime:0.005975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35533190 ORDER BY `minOrder` ASC [ RunTime:0.013700s ]
select * from pdf where partno='2108540' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002266s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001329s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108540' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35533021 LIMIT 4 [ RunTime:0.002902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35533021 ORDER BY `minOrder` ASC [ RunTime:0.000598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35533021 ORDER BY `unit` DESC [ RunTime:0.020430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35533021 LIMIT 2 [ RunTime:0.001277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35533021 ORDER BY `minOrder` ASC [ RunTime:0.000305s ]
select * from pdf where partno='21043162400' and brandshort='HARTING' limit 1 [ RunTime:0.002049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21043162400' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.004279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35532403 LIMIT 4 [ RunTime:0.003027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35532403 ORDER BY `minOrder` ASC [ RunTime:0.003600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35532403 ORDER BY `unit` DESC [ RunTime:0.006496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35532403 LIMIT 2 [ RunTime:0.000401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35532403 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
select * from pdf where partno='2107813' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107813' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35532402 LIMIT 4 [ RunTime:0.022579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35532402 ORDER BY `minOrder` ASC [ RunTime:0.010815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35532402 ORDER BY `unit` DESC [ RunTime:0.006201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35532402 LIMIT 2 [ RunTime:0.005950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35532402 ORDER BY `minOrder` ASC [ RunTime:0.007065s ]
select * from pdf where partno='2107812' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008479s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107812' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35532012 LIMIT 4 [ RunTime:0.013771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35532012 ORDER BY `minOrder` ASC [ RunTime:0.017848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35532012 ORDER BY `unit` DESC [ RunTime:0.017961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35532012 LIMIT 2 [ RunTime:0.010543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35532012 ORDER BY `minOrder` ASC [ RunTime:0.012249s ]
select * from pdf where partno='2104383' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104383' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35531736 LIMIT 4 [ RunTime:0.008085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35531736 ORDER BY `minOrder` ASC [ RunTime:0.021112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35531736 ORDER BY `unit` DESC [ RunTime:0.007604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35531736 LIMIT 2 [ RunTime:0.013772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35531736 ORDER BY `minOrder` ASC [ RunTime:0.008321s ]
select * from pdf where partno='21024547305' and brandshort='HARTING' limit 1 [ RunTime:0.001328s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21024547305' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.004462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35531077 LIMIT 4 [ RunTime:0.003933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35531077 ORDER BY `minOrder` ASC [ RunTime:0.008151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35531077 ORDER BY `unit` DESC [ RunTime:0.004981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35531077 LIMIT 2 [ RunTime:0.005612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35531077 ORDER BY `minOrder` ASC [ RunTime:0.014620s ]
select * from pdf where partno='2104886' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011082s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104886' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35530953 LIMIT 4 [ RunTime:0.000938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35530953 ORDER BY `minOrder` ASC [ RunTime:0.006285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35530953 ORDER BY `unit` DESC [ RunTime:0.000968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35530953 LIMIT 2 [ RunTime:0.016338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35530953 ORDER BY `minOrder` ASC [ RunTime:0.005933s ]
select * from pdf where partno='21033176410' and brandshort='HARTING' limit 1 [ RunTime:0.001653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033176410' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.010644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35530837 LIMIT 4 [ RunTime:0.029723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35530837 ORDER BY `minOrder` ASC [ RunTime:0.012882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35530837 ORDER BY `unit` DESC [ RunTime:0.029511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35530837 LIMIT 2 [ RunTime:0.006116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35530837 ORDER BY `minOrder` ASC [ RunTime:0.006752s ]
select * from pdf where partno='21024547304' and brandshort='HARTING' limit 1 [ RunTime:0.012902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21024547304' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.023420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35530043 LIMIT 4 [ RunTime:0.010260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35530043 ORDER BY `minOrder` ASC [ RunTime:0.005492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35530043 ORDER BY `unit` DESC [ RunTime:0.000498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35530043 LIMIT 2 [ RunTime:0.000485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35530043 ORDER BY `minOrder` ASC [ RunTime:0.012051s ]
select * from pdf where partno='21024547303' and brandshort='HARTING' limit 1 [ RunTime:0.008130s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21024547303' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.016530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35529743 LIMIT 4 [ RunTime:0.008202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35529743 ORDER BY `minOrder` ASC [ RunTime:0.011758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35529743 ORDER BY `unit` DESC [ RunTime:0.000716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35529743 LIMIT 2 [ RunTime:0.009763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35529743 ORDER BY `minOrder` ASC [ RunTime:0.010416s ]
select * from pdf where partno='2107779' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.013761s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2107779' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35529714 LIMIT 4 [ RunTime:0.001148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35529714 ORDER BY `minOrder` ASC [ RunTime:0.000769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35529714 ORDER BY `unit` DESC [ RunTime:0.007926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35529714 LIMIT 2 [ RunTime:0.000879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35529714 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
select * from pdf where partno='2104883' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104883' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35529319 LIMIT 4 [ RunTime:0.006215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35529319 ORDER BY `minOrder` ASC [ RunTime:0.003959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35529319 ORDER BY `unit` DESC [ RunTime:0.003987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35529319 LIMIT 2 [ RunTime:0.016196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35529319 ORDER BY `minOrder` ASC [ RunTime:0.006803s ]
select * from pdf where partno='21025547304' and brandshort='HARTING' limit 1 [ RunTime:0.005635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21025547304' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.015606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35529207 LIMIT 4 [ RunTime:0.010072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35529207 ORDER BY `minOrder` ASC [ RunTime:0.030479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35529207 ORDER BY `unit` DESC [ RunTime:0.012332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35529207 LIMIT 2 [ RunTime:0.007220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35529207 ORDER BY `minOrder` ASC [ RunTime:0.000899s ]
select * from pdf where partno='21024547302' and brandshort='HARTING' limit 1 [ RunTime:0.014231s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21024547302' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.009446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35528363 LIMIT 4 [ RunTime:0.009121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35528363 ORDER BY `minOrder` ASC [ RunTime:0.020462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35528363 ORDER BY `unit` DESC [ RunTime:0.026151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35528363 LIMIT 2 [ RunTime:0.020588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35528363 ORDER BY `minOrder` ASC [ RunTime:0.005686s ]
select * from pdf where partno='2108497' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010696s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108497' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35528362 LIMIT 4 [ RunTime:0.027252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35528362 ORDER BY `minOrder` ASC [ RunTime:0.014188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35528362 ORDER BY `unit` DESC [ RunTime:0.001234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35528362 LIMIT 2 [ RunTime:0.000829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35528362 ORDER BY `minOrder` ASC [ RunTime:0.000555s ]
select * from pdf where partno='2109896' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109896' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35528361 LIMIT 4 [ RunTime:0.018070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35528361 ORDER BY `minOrder` ASC [ RunTime:0.004877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35528361 ORDER BY `unit` DESC [ RunTime:0.011384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35528361 LIMIT 2 [ RunTime:0.005991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35528361 ORDER BY `minOrder` ASC [ RunTime:0.006344s ]
select * from pdf where partno='2104382' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006175s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104382' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35528359 LIMIT 4 [ RunTime:0.008079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35528359 ORDER BY `minOrder` ASC [ RunTime:0.025022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35528359 ORDER BY `unit` DESC [ RunTime:0.013339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35528359 LIMIT 2 [ RunTime:0.022121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35528359 ORDER BY `minOrder` ASC [ RunTime:0.002517s ]
select * from pdf where partno='2109895' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003279s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109895' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35528357 LIMIT 4 [ RunTime:0.000852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35528357 ORDER BY `minOrder` ASC [ RunTime:0.000855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35528357 ORDER BY `unit` DESC [ RunTime:0.008484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35528357 LIMIT 2 [ RunTime:0.006701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35528357 ORDER BY `minOrder` ASC [ RunTime:0.001495s ]
select * from pdf where partno='2106411' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.018902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106411' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35526969 LIMIT 4 [ RunTime:0.003570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35526969 ORDER BY `minOrder` ASC [ RunTime:0.010169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35526969 ORDER BY `unit` DESC [ RunTime:0.015071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35526969 LIMIT 2 [ RunTime:0.010821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35526969 ORDER BY `minOrder` ASC [ RunTime:0.005515s ]
select * from pdf where partno='2104381' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003202s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104381' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018484s ]
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.009385s ]