SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001650s ]
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.010109s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001423s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000526s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002346s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.000280s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001691s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000254s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001761s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.003763s ]
UPDATE `stock_search` SET `count` = 4137 , `updatetime` = '2026-06-08 16:48:30' WHERE `partno` = '210' [ RunTime:0.005262s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000533s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.009806s ]
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.000808s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003153s ]
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.000543s ]
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 2800,20 [ RunTime:0.106732s ]
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 ('37558879','37558878','37558877','37558876','37558851','37558844','37558833','37558832','37558777','37558776','37558702','37558656','37558655','37558654','37558624','37558623','37558622','37558621','37558583','37558582') ORDER BY FIELD(s.id, 37558879,37558878,37558877,37558876,37558851,37558844,37558833,37558832,37558777,37558776,37558702,37558656,37558655,37558654,37558624,37558623,37558622,37558621,37558583,37558582) [ RunTime:0.016082s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558879 LIMIT 4 [ RunTime:0.040763s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.020132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558879 ORDER BY `minOrder` ASC [ RunTime:0.014487s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558879 ORDER BY `unit` DESC [ RunTime:0.040507s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.012126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558879 LIMIT 2 [ RunTime:0.015096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558879 ORDER BY `minOrder` ASC [ RunTime:0.022626s ]
select * from pdf where partno='210002814' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.024519s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001267s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002814' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.034329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558878 LIMIT 4 [ RunTime:0.066228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558878 ORDER BY `minOrder` ASC [ RunTime:0.035727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558878 ORDER BY `unit` DESC [ RunTime:0.047043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558878 LIMIT 2 [ RunTime:0.028184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558878 ORDER BY `minOrder` ASC [ RunTime:0.026726s ]
select * from pdf where partno='210002813' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.045650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002813' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.025395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558877 LIMIT 4 [ RunTime:0.017060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558877 ORDER BY `minOrder` ASC [ RunTime:0.045853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558877 ORDER BY `unit` DESC [ RunTime:0.005297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558877 LIMIT 2 [ RunTime:0.012029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558877 ORDER BY `minOrder` ASC [ RunTime:0.008258s ]
select * from pdf where partno='210002815' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.019222s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002815' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.024088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558876 LIMIT 4 [ RunTime:0.030952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558876 ORDER BY `minOrder` ASC [ RunTime:0.040101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558876 ORDER BY `unit` DESC [ RunTime:0.019738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558876 LIMIT 2 [ RunTime:0.017289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558876 ORDER BY `minOrder` ASC [ RunTime:0.024131s ]
select * from pdf where partno='210002816' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.031037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002816' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.028837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558851 LIMIT 4 [ RunTime:0.022955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558851 ORDER BY `minOrder` ASC [ RunTime:0.013341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558851 ORDER BY `unit` DESC [ RunTime:0.032957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558851 LIMIT 2 [ RunTime:0.033547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558851 ORDER BY `minOrder` ASC [ RunTime:0.017150s ]
select * from pdf where partno='210002947' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.035664s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002947' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.036301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558844 LIMIT 4 [ RunTime:0.047878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558844 ORDER BY `minOrder` ASC [ RunTime:0.025315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558844 ORDER BY `unit` DESC [ RunTime:0.006092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558844 LIMIT 2 [ RunTime:0.012785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558844 ORDER BY `minOrder` ASC [ RunTime:0.009394s ]
select * from pdf where partno='210002898' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.026411s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002898' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.005073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558833 LIMIT 4 [ RunTime:0.019647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558833 ORDER BY `minOrder` ASC [ RunTime:0.029661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558833 ORDER BY `unit` DESC [ RunTime:0.005088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558833 LIMIT 2 [ RunTime:0.011263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558833 ORDER BY `minOrder` ASC [ RunTime:0.002918s ]
select * from pdf where partno='210002841' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.010803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002841' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.035691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558832 LIMIT 4 [ RunTime:0.018408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558832 ORDER BY `minOrder` ASC [ RunTime:0.012700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558832 ORDER BY `unit` DESC [ RunTime:0.011374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558832 LIMIT 2 [ RunTime:0.022506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558832 ORDER BY `minOrder` ASC [ RunTime:0.002145s ]
select * from pdf where partno='210002906' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.101177s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002906' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.025475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558777 LIMIT 4 [ RunTime:0.018131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558777 ORDER BY `minOrder` ASC [ RunTime:0.004695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558777 ORDER BY `unit` DESC [ RunTime:0.024507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558777 LIMIT 2 [ RunTime:0.034649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558777 ORDER BY `minOrder` ASC [ RunTime:0.025422s ]
select * from pdf where partno='210002812' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.043035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002812' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.024236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558776 LIMIT 4 [ RunTime:0.035857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558776 ORDER BY `minOrder` ASC [ RunTime:0.060857s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558776 ORDER BY `unit` DESC [ RunTime:0.025632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558776 LIMIT 2 [ RunTime:0.034656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558776 ORDER BY `minOrder` ASC [ RunTime:0.035193s ]
select * from pdf where partno='210002817' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.025396s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002817' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.011519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558702 LIMIT 4 [ RunTime:0.020501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558702 ORDER BY `minOrder` ASC [ RunTime:0.016223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558702 ORDER BY `unit` DESC [ RunTime:0.026548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558702 LIMIT 2 [ RunTime:0.009757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558702 ORDER BY `minOrder` ASC [ RunTime:0.009310s ]
select * from pdf where partno='210002823' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.055522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002823' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.008487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558656 LIMIT 4 [ RunTime:0.023468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558656 ORDER BY `minOrder` ASC [ RunTime:0.021525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558656 ORDER BY `unit` DESC [ RunTime:0.038829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558656 LIMIT 2 [ RunTime:0.066860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558656 ORDER BY `minOrder` ASC [ RunTime:0.018007s ]
select * from pdf where partno='210002811' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.024554s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002811' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.035991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558655 LIMIT 4 [ RunTime:0.059801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558655 ORDER BY `minOrder` ASC [ RunTime:0.004466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558655 ORDER BY `unit` DESC [ RunTime:0.027142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558655 LIMIT 2 [ RunTime:0.023113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558655 ORDER BY `minOrder` ASC [ RunTime:0.011024s ]
select * from pdf where partno='210002807' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.002149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002807' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.016391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558654 LIMIT 4 [ RunTime:0.031015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558654 ORDER BY `minOrder` ASC [ RunTime:0.016875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558654 ORDER BY `unit` DESC [ RunTime:0.030616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558654 LIMIT 2 [ RunTime:0.003374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558654 ORDER BY `minOrder` ASC [ RunTime:0.006259s ]
select * from pdf where partno='210002810' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.023943s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002810' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.014093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558624 LIMIT 4 [ RunTime:0.025663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558624 ORDER BY `minOrder` ASC [ RunTime:0.018837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558624 ORDER BY `unit` DESC [ RunTime:0.002911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558624 LIMIT 2 [ RunTime:0.001637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558624 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
select * from pdf where partno='210003022' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.004844s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210003022' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.011836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558623 LIMIT 4 [ RunTime:0.002162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558623 ORDER BY `minOrder` ASC [ RunTime:0.024187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558623 ORDER BY `unit` DESC [ RunTime:0.007982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558623 LIMIT 2 [ RunTime:0.012439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558623 ORDER BY `minOrder` ASC [ RunTime:0.000535s ]
select * from pdf where partno='210002806' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.004011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002806' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.009933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558622 LIMIT 4 [ RunTime:0.003746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558622 ORDER BY `minOrder` ASC [ RunTime:0.006319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558622 ORDER BY `unit` DESC [ RunTime:0.003579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558622 LIMIT 2 [ RunTime:0.001557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558622 ORDER BY `minOrder` ASC [ RunTime:0.003158s ]
select * from pdf where partno='210002808' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.024004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002808' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.002719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558621 LIMIT 4 [ RunTime:0.002238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558621 ORDER BY `minOrder` ASC [ RunTime:0.008424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558621 ORDER BY `unit` DESC [ RunTime:0.003424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558621 LIMIT 2 [ RunTime:0.002378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558621 ORDER BY `minOrder` ASC [ RunTime:0.001170s ]
select * from pdf where partno='210002809' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.002049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002809' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.024082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558583 LIMIT 4 [ RunTime:0.000902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558583 ORDER BY `minOrder` ASC [ RunTime:0.007454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558583 ORDER BY `unit` DESC [ RunTime:0.000763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558583 LIMIT 2 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558583 ORDER BY `minOrder` ASC [ RunTime:0.003307s ]
select * from pdf where partno='210002802' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.006459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002802' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.008058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37558582 LIMIT 4 [ RunTime:0.000853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558582 ORDER BY `minOrder` ASC [ RunTime:0.000656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37558582 ORDER BY `unit` DESC [ RunTime:0.010437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37558582 LIMIT 2 [ RunTime:0.038370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37558582 ORDER BY `minOrder` ASC [ RunTime:0.003652s ]
select * from pdf where partno='210002801' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.013068s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002801' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.003740s ]
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.002362s ]