SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001439s ]
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=136&srecordnum=7472' [ RunTime:0.002818s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001494s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000496s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001741s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.007265s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001478s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004929s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001556s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000674s ]
UPDATE `stock_search` SET `count` = 5149 , `updatetime` = '2026-06-08 22:49:08' WHERE `partno` = '210' [ RunTime:0.012734s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000255s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000193s ]
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.000347s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001491s ]
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.129997s ]
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 2700,20 [ RunTime:0.099840s ]
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 ('37560639','37560638','37560637','37560636','37560635','37560626','37560610','37560591','37560590','37560589','37560588','37560587','37560580','37560560','37560559','37560558','37560546','37560544','37560543','37560542') ORDER BY FIELD(s.id, 37560639,37560638,37560637,37560636,37560635,37560626,37560610,37560591,37560590,37560589,37560588,37560587,37560580,37560560,37560559,37560558,37560546,37560544,37560543,37560542) [ RunTime:0.010761s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560639 LIMIT 4 [ RunTime:0.014588s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560639 ORDER BY `minOrder` ASC [ RunTime:0.017098s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560639 ORDER BY `unit` DESC [ RunTime:0.017595s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560639 LIMIT 2 [ RunTime:0.013164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560639 ORDER BY `minOrder` ASC [ RunTime:0.005112s ]
select * from pdf where partno='210001236' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.001120s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002658s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001236' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.004782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560638 LIMIT 4 [ RunTime:0.002990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560638 ORDER BY `minOrder` ASC [ RunTime:0.000952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560638 ORDER BY `unit` DESC [ RunTime:0.003235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560638 LIMIT 2 [ RunTime:0.006821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560638 ORDER BY `minOrder` ASC [ RunTime:0.000968s ]
select * from pdf where partno='210001386' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.005746s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001386' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.006613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560637 LIMIT 4 [ RunTime:0.000596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560637 ORDER BY `minOrder` ASC [ RunTime:0.002790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560637 ORDER BY `unit` DESC [ RunTime:0.003217s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560637 LIMIT 2 [ RunTime:0.003536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560637 ORDER BY `minOrder` ASC [ RunTime:0.012639s ]
select * from pdf where partno='210001238' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.000729s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001238' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.000503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560636 LIMIT 4 [ RunTime:0.000545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560636 ORDER BY `minOrder` ASC [ RunTime:0.006828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560636 ORDER BY `unit` DESC [ RunTime:0.003978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560636 LIMIT 2 [ RunTime:0.005852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560636 ORDER BY `minOrder` ASC [ RunTime:0.006586s ]
select * from pdf where partno='210001354' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.000675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001354' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.003021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560635 LIMIT 4 [ RunTime:0.000485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560635 ORDER BY `minOrder` ASC [ RunTime:0.008161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560635 ORDER BY `unit` DESC [ RunTime:0.009493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560635 LIMIT 2 [ RunTime:0.000568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560635 ORDER BY `minOrder` ASC [ RunTime:0.003661s ]
select * from pdf where partno='210001040' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.006823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001040' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.001079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560626 LIMIT 4 [ RunTime:0.001752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560626 ORDER BY `minOrder` ASC [ RunTime:0.018060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560626 ORDER BY `unit` DESC [ RunTime:0.004017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560626 LIMIT 2 [ RunTime:0.001660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560626 ORDER BY `minOrder` ASC [ RunTime:0.000499s ]
select * from pdf where partno='210003132' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.001359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210003132' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.004188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560610 LIMIT 4 [ RunTime:0.002401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560610 ORDER BY `minOrder` ASC [ RunTime:0.015237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560610 ORDER BY `unit` DESC [ RunTime:0.008485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560610 LIMIT 2 [ RunTime:0.001157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560610 ORDER BY `minOrder` ASC [ RunTime:0.004775s ]
select * from pdf where partno='210001724' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.002697s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001724' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.002594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560591 LIMIT 4 [ RunTime:0.005694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560591 ORDER BY `minOrder` ASC [ RunTime:0.007983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560591 ORDER BY `unit` DESC [ RunTime:0.005885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560591 LIMIT 2 [ RunTime:0.000506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560591 ORDER BY `minOrder` ASC [ RunTime:0.004692s ]
select * from pdf where partno='210000632' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.001500s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000632' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.002844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560590 LIMIT 4 [ RunTime:0.002460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560590 ORDER BY `minOrder` ASC [ RunTime:0.008082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560590 ORDER BY `unit` DESC [ RunTime:0.009573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560590 LIMIT 2 [ RunTime:0.011260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560590 ORDER BY `minOrder` ASC [ RunTime:0.002328s ]
select * from pdf where partno='210000568' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.000604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000568' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.000915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560589 LIMIT 4 [ RunTime:0.006299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560589 ORDER BY `minOrder` ASC [ RunTime:0.002238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560589 ORDER BY `unit` DESC [ RunTime:0.005313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560589 LIMIT 2 [ RunTime:0.003576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560589 ORDER BY `minOrder` ASC [ RunTime:0.001415s ]
select * from pdf where partno='210000672' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.004638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000672' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.005083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560588 LIMIT 4 [ RunTime:0.005663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560588 ORDER BY `minOrder` ASC [ RunTime:0.001971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560588 ORDER BY `unit` DESC [ RunTime:0.003737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560588 LIMIT 2 [ RunTime:0.001605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560588 ORDER BY `minOrder` ASC [ RunTime:0.001839s ]
select * from pdf where partno='210000784' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.005357s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000784' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.000658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560587 LIMIT 4 [ RunTime:0.004909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560587 ORDER BY `minOrder` ASC [ RunTime:0.004958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560587 ORDER BY `unit` DESC [ RunTime:0.003670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560587 LIMIT 2 [ RunTime:0.000331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560587 ORDER BY `minOrder` ASC [ RunTime:0.000551s ]
select * from pdf where partno='210000558' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.001920s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000558' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.004908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560580 LIMIT 4 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560580 ORDER BY `minOrder` ASC [ RunTime:0.009559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560580 ORDER BY `unit` DESC [ RunTime:0.004831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560580 LIMIT 2 [ RunTime:0.000438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560580 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
select * from pdf where partno='210003131' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.001837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210003131' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.005293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560560 LIMIT 4 [ RunTime:0.001178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560560 ORDER BY `minOrder` ASC [ RunTime:0.009517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560560 ORDER BY `unit` DESC [ RunTime:0.004081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560560 LIMIT 2 [ RunTime:0.000538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560560 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
select * from pdf where partno='210000783' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.001519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000783' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.004979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560559 LIMIT 4 [ RunTime:0.001958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560559 ORDER BY `minOrder` ASC [ RunTime:0.009574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560559 ORDER BY `unit` DESC [ RunTime:0.009579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560559 LIMIT 2 [ RunTime:0.001533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560559 ORDER BY `minOrder` ASC [ RunTime:0.002032s ]
select * from pdf where partno='210000627' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.001708s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000627' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.005774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560558 LIMIT 4 [ RunTime:0.002485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560558 ORDER BY `minOrder` ASC [ RunTime:0.007747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560558 ORDER BY `unit` DESC [ RunTime:0.015165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560558 LIMIT 2 [ RunTime:0.000847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560558 ORDER BY `minOrder` ASC [ RunTime:0.001107s ]
select * from pdf where partno='210000567' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.005502s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000567' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.001779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560546 LIMIT 4 [ RunTime:0.009660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560546 ORDER BY `minOrder` ASC [ RunTime:0.006171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560546 ORDER BY `unit` DESC [ RunTime:0.015480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560546 LIMIT 2 [ RunTime:0.008721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560546 ORDER BY `minOrder` ASC [ RunTime:0.007969s ]
select * from pdf where partno='210000470' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.003102s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000470' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.004243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560544 LIMIT 4 [ RunTime:0.008679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560544 ORDER BY `minOrder` ASC [ RunTime:0.006282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560544 ORDER BY `unit` DESC [ RunTime:0.009263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560544 LIMIT 2 [ RunTime:0.004677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560544 ORDER BY `minOrder` ASC [ RunTime:0.002148s ]
select * from pdf where partno='210000639' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.009507s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000639' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.012332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560543 LIMIT 4 [ RunTime:0.000486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560543 ORDER BY `minOrder` ASC [ RunTime:0.010275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560543 ORDER BY `unit` DESC [ RunTime:0.010801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560543 LIMIT 2 [ RunTime:0.004168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560543 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
select * from pdf where partno='210000611' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.003408s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000611' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.002935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560542 LIMIT 4 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560542 ORDER BY `minOrder` ASC [ RunTime:0.017280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560542 ORDER BY `unit` DESC [ RunTime:0.011605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560542 LIMIT 2 [ RunTime:0.003215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560542 ORDER BY `minOrder` ASC [ RunTime:0.003027s ]
select * from pdf where partno='210000693' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.003442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000693' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.000729s ]
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.090131s ]