SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001477s ]
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=201&srecordnum=7530' [ RunTime:0.003697s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001570s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004011s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001628s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.009455s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001485s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000283s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001968s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.001097s ]
UPDATE `stock_search` SET `count` = 4569 , `updatetime` = '2026-06-08 19:01:10' WHERE `partno` = '210' [ RunTime:0.015792s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.012951s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000395s ]
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.008615s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001473s ]
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.573034s ]
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 4000,20 [ RunTime:0.134062s ]
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 ('35563452','35562975','35562957','35562742','35562689','35562369','35562040','35561986','35561752','35561643','35561642','35561499','35561498','35561066','35560472','35559699','35558832','35558630','35558407','35557964') ORDER BY FIELD(s.id, 35563452,35562975,35562957,35562742,35562689,35562369,35562040,35561986,35561752,35561643,35561642,35561499,35561498,35561066,35560472,35559699,35558832,35558630,35558407,35557964) [ RunTime:0.074343s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35563452 LIMIT 4 [ RunTime:0.028800s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35563452 ORDER BY `minOrder` ASC [ RunTime:0.017614s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35563452 ORDER BY `unit` DESC [ RunTime:0.003938s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.011908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35563452 LIMIT 2 [ RunTime:0.021049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35563452 ORDER BY `minOrder` ASC [ RunTime:0.012017s ]
select * from pdf where partno='2109201' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.025534s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109201' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35562975 LIMIT 4 [ RunTime:0.004327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562975 ORDER BY `minOrder` ASC [ RunTime:0.005290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35562975 ORDER BY `unit` DESC [ RunTime:0.006542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35562975 LIMIT 2 [ RunTime:0.039268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562975 ORDER BY `minOrder` ASC [ RunTime:0.008729s ]
select * from pdf where partno='2106282' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.023360s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106282' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35562957 LIMIT 4 [ RunTime:0.030298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562957 ORDER BY `minOrder` ASC [ RunTime:0.009466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35562957 ORDER BY `unit` DESC [ RunTime:0.027335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35562957 LIMIT 2 [ RunTime:0.027492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562957 ORDER BY `minOrder` ASC [ RunTime:0.023647s ]
select * from pdf where partno='2109197' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109197' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35562742 LIMIT 4 [ RunTime:0.012372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562742 ORDER BY `minOrder` ASC [ RunTime:0.026005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35562742 ORDER BY `unit` DESC [ RunTime:0.034800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35562742 LIMIT 2 [ RunTime:0.054547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562742 ORDER BY `minOrder` ASC [ RunTime:0.014116s ]
select * from pdf where partno='2106176' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.016680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106176' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35562689 LIMIT 4 [ RunTime:0.030262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562689 ORDER BY `minOrder` ASC [ RunTime:0.004013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35562689 ORDER BY `unit` DESC [ RunTime:0.013486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35562689 LIMIT 2 [ RunTime:0.022620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562689 ORDER BY `minOrder` ASC [ RunTime:0.003811s ]
select * from pdf where partno='21035853420' and brandshort='HARTING' limit 1 [ RunTime:0.026206s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035853420' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.015845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35562369 LIMIT 4 [ RunTime:0.018498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562369 ORDER BY `minOrder` ASC [ RunTime:0.039823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35562369 ORDER BY `unit` DESC [ RunTime:0.013299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35562369 LIMIT 2 [ RunTime:0.029493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562369 ORDER BY `minOrder` ASC [ RunTime:0.005353s ]
select * from pdf where partno='2106574' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.018430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106574' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35562040 LIMIT 4 [ RunTime:0.018070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562040 ORDER BY `minOrder` ASC [ RunTime:0.036063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35562040 ORDER BY `unit` DESC [ RunTime:0.029326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35562040 LIMIT 2 [ RunTime:0.002459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35562040 ORDER BY `minOrder` ASC [ RunTime:0.012136s ]
select * from pdf where partno='21034853410' and brandshort='HARTING' limit 1 [ RunTime:0.037606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21034853410' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.038616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35561986 LIMIT 4 [ RunTime:0.021674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561986 ORDER BY `minOrder` ASC [ RunTime:0.029780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35561986 ORDER BY `unit` DESC [ RunTime:0.015754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35561986 LIMIT 2 [ RunTime:0.019618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561986 ORDER BY `minOrder` ASC [ RunTime:0.007525s ]
select * from pdf where partno='2106278' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.021477s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106278' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35561752 LIMIT 4 [ RunTime:0.006868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561752 ORDER BY `minOrder` ASC [ RunTime:0.038681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35561752 ORDER BY `unit` DESC [ RunTime:0.065453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35561752 LIMIT 2 [ RunTime:0.041900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561752 ORDER BY `minOrder` ASC [ RunTime:0.000550s ]
select * from pdf where partno='2106275' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.018000s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106275' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.046936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35561643 LIMIT 4 [ RunTime:0.066704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561643 ORDER BY `minOrder` ASC [ RunTime:0.077004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35561643 ORDER BY `unit` DESC [ RunTime:0.038040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35561643 LIMIT 2 [ RunTime:0.030086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561643 ORDER BY `minOrder` ASC [ RunTime:0.064721s ]
select * from pdf where partno='2106271' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.092285s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106271' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.075057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35561642 LIMIT 4 [ RunTime:0.096129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561642 ORDER BY `minOrder` ASC [ RunTime:0.032505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35561642 ORDER BY `unit` DESC [ RunTime:0.038020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35561642 LIMIT 2 [ RunTime:0.043928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561642 ORDER BY `minOrder` ASC [ RunTime:0.012425s ]
select * from pdf where partno='2106166' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.028837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106166' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.079807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35561499 LIMIT 4 [ RunTime:0.110762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561499 ORDER BY `minOrder` ASC [ RunTime:0.008119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35561499 ORDER BY `unit` DESC [ RunTime:0.037020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35561499 LIMIT 2 [ RunTime:0.057053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561499 ORDER BY `minOrder` ASC [ RunTime:0.036273s ]
select * from pdf where partno='2106269' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.090444s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106269' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.089119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35561498 LIMIT 4 [ RunTime:0.077780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561498 ORDER BY `minOrder` ASC [ RunTime:0.096643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35561498 ORDER BY `unit` DESC [ RunTime:0.056096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35561498 LIMIT 2 [ RunTime:0.018907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561498 ORDER BY `minOrder` ASC [ RunTime:0.019214s ]
select * from pdf where partno='21034851410' and brandshort='HARTING' limit 1 [ RunTime:0.013196s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21034851410' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.048199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35561066 LIMIT 4 [ RunTime:0.048611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561066 ORDER BY `minOrder` ASC [ RunTime:0.048789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35561066 ORDER BY `unit` DESC [ RunTime:0.044526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35561066 LIMIT 2 [ RunTime:0.066372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35561066 ORDER BY `minOrder` ASC [ RunTime:0.018562s ]
select * from pdf where partno='21034831810' and brandshort='HARTING' limit 1 [ RunTime:0.014278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21034831810' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.051268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35560472 LIMIT 4 [ RunTime:0.070423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35560472 ORDER BY `minOrder` ASC [ RunTime:0.016753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35560472 ORDER BY `unit` DESC [ RunTime:0.046093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35560472 LIMIT 2 [ RunTime:0.017307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35560472 ORDER BY `minOrder` ASC [ RunTime:0.028644s ]
select * from pdf where partno='2106286' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.045445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106286' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.070513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35559699 LIMIT 4 [ RunTime:0.076285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35559699 ORDER BY `minOrder` ASC [ RunTime:0.033436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35559699 ORDER BY `unit` DESC [ RunTime:0.023485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35559699 LIMIT 2 [ RunTime:0.041958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35559699 ORDER BY `minOrder` ASC [ RunTime:0.025920s ]
select * from pdf where partno='21034831405' and brandshort='HARTING' limit 1 [ RunTime:0.022125s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21034831405' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.064377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35558832 LIMIT 4 [ RunTime:0.053354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35558832 ORDER BY `minOrder` ASC [ RunTime:0.039942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35558832 ORDER BY `unit` DESC [ RunTime:0.031982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35558832 LIMIT 2 [ RunTime:0.054284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35558832 ORDER BY `minOrder` ASC [ RunTime:0.003273s ]
select * from pdf where partno='21035853410' and brandshort='HARTING' limit 1 [ RunTime:0.023608s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035853410' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.034751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35558630 LIMIT 4 [ RunTime:0.010256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35558630 ORDER BY `minOrder` ASC [ RunTime:0.045097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35558630 ORDER BY `unit` DESC [ RunTime:0.045231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35558630 LIMIT 2 [ RunTime:0.023038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35558630 ORDER BY `minOrder` ASC [ RunTime:0.057162s ]
select * from pdf where partno='2105244' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.060888s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105244' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.028259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35558407 LIMIT 4 [ RunTime:0.048923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35558407 ORDER BY `minOrder` ASC [ RunTime:0.090206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35558407 ORDER BY `unit` DESC [ RunTime:0.076687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35558407 LIMIT 2 [ RunTime:0.089506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35558407 ORDER BY `minOrder` ASC [ RunTime:0.018337s ]
select * from pdf where partno='2106168' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.027723s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106168' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.030601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35557964 LIMIT 4 [ RunTime:0.038981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35557964 ORDER BY `minOrder` ASC [ RunTime:0.027375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35557964 ORDER BY `unit` DESC [ RunTime:0.021180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35557964 LIMIT 2 [ RunTime:0.023049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35557964 ORDER BY `minOrder` ASC [ RunTime:0.009065s ]
select * from pdf where partno='2106165' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.029971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106165' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.030764s ]
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.026634s ]