SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002446s ]
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.002888s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002103s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000578s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003446s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.004316s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002100s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004327s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002074s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.001963s ]
UPDATE `stock_search` SET `count` = 3967 , `updatetime` = '2026-06-08 15:56:56' WHERE `partno` = '210' [ RunTime:0.001514s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000313s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000278s ]
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.000460s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002430s ]
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.000544s ]
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 2620,20 [ RunTime:0.084865s ]
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 ('37560851','37560850','37560849','37560848','37560847','37560846','37560845','37560844','37560843','37560842','37560841','37560839','37560838','37560835','37560834','37560833','37560832','37560830','37560829','37560828') ORDER BY FIELD(s.id, 37560851,37560850,37560849,37560848,37560847,37560846,37560845,37560844,37560843,37560842,37560841,37560839,37560838,37560835,37560834,37560833,37560832,37560830,37560829,37560828) [ RunTime:0.029979s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560851 LIMIT 4 [ RunTime:0.011690s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560851 ORDER BY `minOrder` ASC [ RunTime:0.011646s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560851 ORDER BY `unit` DESC [ RunTime:0.000282s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560851 LIMIT 2 [ RunTime:0.000278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560851 ORDER BY `minOrder` ASC [ RunTime:0.003756s ]
select * from pdf where partno='210000419' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.001545s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000419' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.011999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560850 LIMIT 4 [ RunTime:0.029504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560850 ORDER BY `minOrder` ASC [ RunTime:0.021396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560850 ORDER BY `unit` DESC [ RunTime:0.027627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560850 LIMIT 2 [ RunTime:0.014391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560850 ORDER BY `minOrder` ASC [ RunTime:0.023780s ]
select * from pdf where partno='210001013' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.023289s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001013' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.016594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560849 LIMIT 4 [ RunTime:0.032328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560849 ORDER BY `minOrder` ASC [ RunTime:0.031085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560849 ORDER BY `unit` DESC [ RunTime:0.011983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560849 LIMIT 2 [ RunTime:0.039509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560849 ORDER BY `minOrder` ASC [ RunTime:0.012665s ]
select * from pdf where partno='210002318' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.016476s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002318' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.026791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560848 LIMIT 4 [ RunTime:0.054631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560848 ORDER BY `minOrder` ASC [ RunTime:0.015868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560848 ORDER BY `unit` DESC [ RunTime:0.041098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560848 LIMIT 2 [ RunTime:0.124710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560848 ORDER BY `minOrder` ASC [ RunTime:0.055738s ]
select * from pdf where partno='210000379' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.051206s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000379' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.062095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560847 LIMIT 4 [ RunTime:0.061587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560847 ORDER BY `minOrder` ASC [ RunTime:0.068675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560847 ORDER BY `unit` DESC [ RunTime:0.158120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560847 LIMIT 2 [ RunTime:0.025599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560847 ORDER BY `minOrder` ASC [ RunTime:0.026673s ]
select * from pdf where partno='210000212' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.033369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000212' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.050424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560846 LIMIT 4 [ RunTime:0.128382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560846 ORDER BY `minOrder` ASC [ RunTime:0.064106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560846 ORDER BY `unit` DESC [ RunTime:0.025803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560846 LIMIT 2 [ RunTime:0.022723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560846 ORDER BY `minOrder` ASC [ RunTime:0.008198s ]
select * from pdf where partno='210000299' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.030797s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000299' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.043351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560845 LIMIT 4 [ RunTime:0.133042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560845 ORDER BY `minOrder` ASC [ RunTime:0.057319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560845 ORDER BY `unit` DESC [ RunTime:0.065578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560845 LIMIT 2 [ RunTime:0.005089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560845 ORDER BY `minOrder` ASC [ RunTime:0.019443s ]
select * from pdf where partno='210000297' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.009238s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000297' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.030419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560844 LIMIT 4 [ RunTime:0.012867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560844 ORDER BY `minOrder` ASC [ RunTime:0.078321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560844 ORDER BY `unit` DESC [ RunTime:0.080317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560844 LIMIT 2 [ RunTime:0.064914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560844 ORDER BY `minOrder` ASC [ RunTime:0.019108s ]
select * from pdf where partno='210002541' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.055028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002541' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.018641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560843 LIMIT 4 [ RunTime:0.016047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560843 ORDER BY `minOrder` ASC [ RunTime:0.037863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560843 ORDER BY `unit` DESC [ RunTime:0.007948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560843 LIMIT 2 [ RunTime:0.007161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560843 ORDER BY `minOrder` ASC [ RunTime:0.014814s ]
select * from pdf where partno='210002362' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.013656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002362' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.002377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560842 LIMIT 4 [ RunTime:0.002304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560842 ORDER BY `minOrder` ASC [ RunTime:0.008161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560842 ORDER BY `unit` DESC [ RunTime:0.008934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560842 LIMIT 2 [ RunTime:0.019179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560842 ORDER BY `minOrder` ASC [ RunTime:0.005469s ]
select * from pdf where partno='210002361' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.007780s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002361' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.015296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560841 LIMIT 4 [ RunTime:0.035655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560841 ORDER BY `minOrder` ASC [ RunTime:0.049785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560841 ORDER BY `unit` DESC [ RunTime:0.005652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560841 LIMIT 2 [ RunTime:0.046663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560841 ORDER BY `minOrder` ASC [ RunTime:0.006631s ]
select * from pdf where partno='210002855' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.004171s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002855' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.005334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560839 LIMIT 4 [ RunTime:0.008125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560839 ORDER BY `minOrder` ASC [ RunTime:0.011807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560839 ORDER BY `unit` DESC [ RunTime:0.027464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560839 LIMIT 2 [ RunTime:0.018298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560839 ORDER BY `minOrder` ASC [ RunTime:0.006457s ]
select * from pdf where partno='210001547' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.019294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210001547' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.020458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560838 LIMIT 4 [ RunTime:0.028982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560838 ORDER BY `minOrder` ASC [ RunTime:0.007528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560838 ORDER BY `unit` DESC [ RunTime:0.006327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560838 LIMIT 2 [ RunTime:0.020417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560838 ORDER BY `minOrder` ASC [ RunTime:0.005705s ]
select * from pdf where partno='210000303' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.010072s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000303' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.009226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560835 LIMIT 4 [ RunTime:0.009181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560835 ORDER BY `minOrder` ASC [ RunTime:0.006773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560835 ORDER BY `unit` DESC [ RunTime:0.023134s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560835 LIMIT 2 [ RunTime:0.006342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560835 ORDER BY `minOrder` ASC [ RunTime:0.013950s ]
select * from pdf where partno='210003021' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.004290s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210003021' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.003006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560834 LIMIT 4 [ RunTime:0.067511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560834 ORDER BY `minOrder` ASC [ RunTime:0.019495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560834 ORDER BY `unit` DESC [ RunTime:0.032413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560834 LIMIT 2 [ RunTime:0.017452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560834 ORDER BY `minOrder` ASC [ RunTime:0.001718s ]
select * from pdf where partno='210002854' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.003339s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002854' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.017347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560833 LIMIT 4 [ RunTime:0.065031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560833 ORDER BY `minOrder` ASC [ RunTime:0.042814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560833 ORDER BY `unit` DESC [ RunTime:0.009104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560833 LIMIT 2 [ RunTime:0.013747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560833 ORDER BY `minOrder` ASC [ RunTime:0.008014s ]
select * from pdf where partno='210002360' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.027836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002360' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.043847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560832 LIMIT 4 [ RunTime:0.005622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560832 ORDER BY `minOrder` ASC [ RunTime:0.007357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560832 ORDER BY `unit` DESC [ RunTime:0.002837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560832 LIMIT 2 [ RunTime:0.054548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560832 ORDER BY `minOrder` ASC [ RunTime:0.005300s ]
select * from pdf where partno='210002359' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.007474s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002359' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.012484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560830 LIMIT 4 [ RunTime:0.024527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560830 ORDER BY `minOrder` ASC [ RunTime:0.012923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560830 ORDER BY `unit` DESC [ RunTime:0.007518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560830 LIMIT 2 [ RunTime:0.028329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560830 ORDER BY `minOrder` ASC [ RunTime:0.002159s ]
select * from pdf where partno='210000168' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.004911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000168' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.014285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560829 LIMIT 4 [ RunTime:0.015861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560829 ORDER BY `minOrder` ASC [ RunTime:0.006489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560829 ORDER BY `unit` DESC [ RunTime:0.018365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560829 LIMIT 2 [ RunTime:0.022621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560829 ORDER BY `minOrder` ASC [ RunTime:0.006069s ]
select * from pdf where partno='210000171' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.014043s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210000171' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.006641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37560828 LIMIT 4 [ RunTime:0.023406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560828 ORDER BY `minOrder` ASC [ RunTime:0.046912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37560828 ORDER BY `unit` DESC [ RunTime:0.032154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37560828 LIMIT 2 [ RunTime:0.050767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37560828 ORDER BY `minOrder` ASC [ RunTime:0.014607s ]
select * from pdf where partno='210002356' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.043606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210002356' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.059451s ]
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.051314s ]