SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002494s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.174' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.084816s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003323s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.048134s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002561s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.174' ) [ RunTime:0.047900s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001996s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.042720s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002058s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.050887s ]
UPDATE `stock_search` SET `count` = 2361 , `updatetime` = '2026-06-07 01:13:05' WHERE `partno` = '210' [ RunTime:0.043423s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.020957s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.032767s ]
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.019476s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002861s ]
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.118852s ]
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 2660,20 [ RunTime:0.072685s ]
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 ('33628082','33619012','33618416','33618113','33529455','33529453','33529450','33529292','33529285','33529282','33529273','33529271','33529270','33529222','33529203','33529202','33529186','33529184','33529170','33529169') ORDER BY FIELD(s.id, 33628082,33619012,33618416,33618113,33529455,33529453,33529450,33529292,33529285,33529282,33529273,33529271,33529270,33529222,33529203,33529202,33529186,33529184,33529170,33529169) [ RunTime:0.026892s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33628082 LIMIT 4 [ RunTime:0.029137s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33628082 ORDER BY `minOrder` ASC [ RunTime:0.018914s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33628082 ORDER BY `unit` DESC [ RunTime:0.027737s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33628082 LIMIT 2 [ RunTime:0.012029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33628082 ORDER BY `minOrder` ASC [ RunTime:0.028551s ]
select * from pdf where partno='210260000' and brandshort='Weidmüller' limit 1 [ RunTime:0.008325s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003927s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210260000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.012765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33619012 LIMIT 4 [ RunTime:0.018981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33619012 ORDER BY `minOrder` ASC [ RunTime:0.005236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33619012 ORDER BY `unit` DESC [ RunTime:0.059192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33619012 LIMIT 2 [ RunTime:0.048363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33619012 ORDER BY `minOrder` ASC [ RunTime:0.011740s ]
select * from pdf where partno='2104-1307' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.023780s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-1307' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.006597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33618416 LIMIT 4 [ RunTime:0.012885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618416 ORDER BY `minOrder` ASC [ RunTime:0.028859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33618416 ORDER BY `unit` DESC [ RunTime:0.014823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33618416 LIMIT 2 [ RunTime:0.026507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618416 ORDER BY `minOrder` ASC [ RunTime:0.016245s ]
select * from pdf where partno='2102-1304' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.030460s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102-1304' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.043983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33618113 LIMIT 4 [ RunTime:0.014633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618113 ORDER BY `minOrder` ASC [ RunTime:0.065165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33618113 ORDER BY `unit` DESC [ RunTime:0.043532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33618113 LIMIT 2 [ RunTime:0.067642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618113 ORDER BY `minOrder` ASC [ RunTime:0.094886s ]
select * from pdf where partno='2102-5207' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.017144s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102-5207' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.011852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529455 LIMIT 4 [ RunTime:0.000461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529455 ORDER BY `minOrder` ASC [ RunTime:0.045270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529455 ORDER BY `unit` DESC [ RunTime:0.026775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529455 LIMIT 2 [ RunTime:0.041287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529455 ORDER BY `minOrder` ASC [ RunTime:0.032232s ]
select * from pdf where partno='2100G' and brandshort='American Electrical Inc.' limit 1 [ RunTime:0.015381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100G' OR `brand` LIKE 'American Electrical Inc.%' ) ) LIMIT 1 [ RunTime:0.006397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529453 LIMIT 4 [ RunTime:0.000700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529453 ORDER BY `minOrder` ASC [ RunTime:0.017214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529453 ORDER BY `unit` DESC [ RunTime:0.003730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529453 LIMIT 2 [ RunTime:0.000504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529453 ORDER BY `minOrder` ASC [ RunTime:0.005740s ]
select * from pdf where partno='2100025' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.010642s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100025' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529450 LIMIT 4 [ RunTime:0.001981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529450 ORDER BY `minOrder` ASC [ RunTime:0.002762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529450 ORDER BY `unit` DESC [ RunTime:0.005787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529450 LIMIT 2 [ RunTime:0.012157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529450 ORDER BY `minOrder` ASC [ RunTime:0.000583s ]
select * from pdf where partno='2100024' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100024' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529292 LIMIT 4 [ RunTime:0.018900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529292 ORDER BY `minOrder` ASC [ RunTime:0.003220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529292 ORDER BY `unit` DESC [ RunTime:0.037122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529292 LIMIT 2 [ RunTime:0.003660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529292 ORDER BY `minOrder` ASC [ RunTime:0.091545s ]
select * from pdf where partno='2100023' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.075904s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100023' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529285 LIMIT 4 [ RunTime:0.005440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529285 ORDER BY `minOrder` ASC [ RunTime:0.004985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529285 ORDER BY `unit` DESC [ RunTime:0.006455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529285 LIMIT 2 [ RunTime:0.013286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529285 ORDER BY `minOrder` ASC [ RunTime:0.004583s ]
select * from pdf where partno='2100027' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.016255s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100027' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.033117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529282 LIMIT 4 [ RunTime:0.084883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529282 ORDER BY `minOrder` ASC [ RunTime:0.019500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529282 ORDER BY `unit` DESC [ RunTime:0.059976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529282 LIMIT 2 [ RunTime:0.110171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529282 ORDER BY `minOrder` ASC [ RunTime:0.114743s ]
select * from pdf where partno='2100028' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.063503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100028' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.062011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529273 LIMIT 4 [ RunTime:0.155347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529273 ORDER BY `minOrder` ASC [ RunTime:0.033576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529273 ORDER BY `unit` DESC [ RunTime:0.021089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529273 LIMIT 2 [ RunTime:0.078708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529273 ORDER BY `minOrder` ASC [ RunTime:0.057650s ]
select * from pdf where partno='2100031' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.042602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100031' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.025584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529271 LIMIT 4 [ RunTime:0.008546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529271 ORDER BY `minOrder` ASC [ RunTime:0.026810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529271 ORDER BY `unit` DESC [ RunTime:0.026905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529271 LIMIT 2 [ RunTime:0.017791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529271 ORDER BY `minOrder` ASC [ RunTime:0.099831s ]
select * from pdf where partno='2100030' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.015698s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100030' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.019890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529270 LIMIT 4 [ RunTime:0.000337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529270 ORDER BY `minOrder` ASC [ RunTime:0.014241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529270 ORDER BY `unit` DESC [ RunTime:0.007036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529270 LIMIT 2 [ RunTime:0.007297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529270 ORDER BY `minOrder` ASC [ RunTime:0.016363s ]
select * from pdf where partno='2100032' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.086227s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100032' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529222 LIMIT 4 [ RunTime:0.029778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529222 ORDER BY `minOrder` ASC [ RunTime:0.001172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529222 ORDER BY `unit` DESC [ RunTime:0.026396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529222 LIMIT 2 [ RunTime:0.007231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529222 ORDER BY `minOrder` ASC [ RunTime:0.034552s ]
select * from pdf where partno='2100035' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.014427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100035' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.021397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529203 LIMIT 4 [ RunTime:0.029966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529203 ORDER BY `minOrder` ASC [ RunTime:0.005677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529203 ORDER BY `unit` DESC [ RunTime:0.035306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529203 LIMIT 2 [ RunTime:0.031375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529203 ORDER BY `minOrder` ASC [ RunTime:0.029634s ]
select * from pdf where partno='2100037' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.029003s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100037' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529202 LIMIT 4 [ RunTime:0.021692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529202 ORDER BY `minOrder` ASC [ RunTime:0.093310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529202 ORDER BY `unit` DESC [ RunTime:0.024835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529202 LIMIT 2 [ RunTime:0.018847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529202 ORDER BY `minOrder` ASC [ RunTime:0.025570s ]
select * from pdf where partno='2100038' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.012614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100038' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.032114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529186 LIMIT 4 [ RunTime:0.017344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529186 ORDER BY `minOrder` ASC [ RunTime:0.067511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529186 ORDER BY `unit` DESC [ RunTime:0.027800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529186 LIMIT 2 [ RunTime:0.018247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529186 ORDER BY `minOrder` ASC [ RunTime:0.015889s ]
select * from pdf where partno='2100036' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.063443s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100036' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.054126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529184 LIMIT 4 [ RunTime:0.065935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529184 ORDER BY `minOrder` ASC [ RunTime:0.016462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529184 ORDER BY `unit` DESC [ RunTime:0.042070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529184 LIMIT 2 [ RunTime:0.016473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529184 ORDER BY `minOrder` ASC [ RunTime:0.026024s ]
select * from pdf where partno='2100249' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.020304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100249' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.041039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529170 LIMIT 4 [ RunTime:0.061514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529170 ORDER BY `minOrder` ASC [ RunTime:0.031843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529170 ORDER BY `unit` DESC [ RunTime:0.010784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529170 LIMIT 2 [ RunTime:0.034504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529170 ORDER BY `minOrder` ASC [ RunTime:0.007960s ]
select * from pdf where partno='2100048' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.043165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100048' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.023587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529169 LIMIT 4 [ RunTime:0.009888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529169 ORDER BY `minOrder` ASC [ RunTime:0.017170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529169 ORDER BY `unit` DESC [ RunTime:0.010168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529169 LIMIT 2 [ RunTime:0.017460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529169 ORDER BY `minOrder` ASC [ RunTime:0.002418s ]
select * from pdf where partno='2100043' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.007720s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100043' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.031371s ]
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.086917s ]