SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002569s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.220' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.001871s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001259s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000437s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002439s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000352s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003293s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000351s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002109s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.002664s ]
UPDATE `stock_search` SET `count` = 1969 , `updatetime` = '2026-06-06 21:06:06' WHERE `partno` = '210' [ RunTime:0.001891s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000308s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000280s ]
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.004298s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002394s ]
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.102771s ]
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.043893s ]
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 ('33529282','33529273','33529271','33529270','33529222','33529203','33529202','33529186','33529184','33529170','33529169','33529158','33529152','33529142','33529141','33529131','33529130','33529129','33529128','33529127') ORDER BY FIELD(s.id, 33529282,33529273,33529271,33529270,33529222,33529203,33529202,33529186,33529184,33529170,33529169,33529158,33529152,33529142,33529141,33529131,33529130,33529129,33529128,33529127) [ RunTime:0.000815s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529282 LIMIT 4 [ RunTime:0.003060s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529282 ORDER BY `minOrder` ASC [ RunTime:0.000525s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529282 ORDER BY `unit` DESC [ RunTime:0.002078s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529282 LIMIT 2 [ RunTime:0.001594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529282 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
select * from pdf where partno='2100028' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003572s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002363s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100028' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529273 LIMIT 4 [ RunTime:0.013412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529273 ORDER BY `minOrder` ASC [ RunTime:0.002169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529273 ORDER BY `unit` DESC [ RunTime:0.000324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529273 LIMIT 2 [ RunTime:0.000883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529273 ORDER BY `minOrder` ASC [ RunTime:0.000251s ]
select * from pdf where partno='2100031' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100031' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529271 LIMIT 4 [ RunTime:0.004486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529271 ORDER BY `minOrder` ASC [ RunTime:0.000559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529271 ORDER BY `unit` DESC [ RunTime:0.000212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529271 LIMIT 2 [ RunTime:0.000202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529271 ORDER BY `minOrder` ASC [ RunTime:0.000907s ]
select * from pdf where partno='2100030' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100030' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529270 LIMIT 4 [ RunTime:0.004712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529270 ORDER BY `minOrder` ASC [ RunTime:0.007966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529270 ORDER BY `unit` DESC [ RunTime:0.000282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529270 LIMIT 2 [ RunTime:0.000931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529270 ORDER BY `minOrder` ASC [ RunTime:0.007956s ]
select * from pdf where partno='2100032' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000362s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100032' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529222 LIMIT 4 [ RunTime:0.000357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529222 ORDER BY `minOrder` ASC [ RunTime:0.003942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529222 ORDER BY `unit` DESC [ RunTime:0.001675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529222 LIMIT 2 [ RunTime:0.003377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529222 ORDER BY `minOrder` ASC [ RunTime:0.002015s ]
select * from pdf where partno='2100035' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100035' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529203 LIMIT 4 [ RunTime:0.006410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529203 ORDER BY `minOrder` ASC [ RunTime:0.003828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529203 ORDER BY `unit` DESC [ RunTime:0.003453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529203 LIMIT 2 [ RunTime:0.006688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529203 ORDER BY `minOrder` ASC [ RunTime:0.000223s ]
select * from pdf where partno='2100037' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004130s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100037' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529202 LIMIT 4 [ RunTime:0.003708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529202 ORDER BY `minOrder` ASC [ RunTime:0.008784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529202 ORDER BY `unit` DESC [ RunTime:0.002811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529202 LIMIT 2 [ RunTime:0.006223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529202 ORDER BY `minOrder` ASC [ RunTime:0.004667s ]
select * from pdf where partno='2100038' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003079s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100038' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529186 LIMIT 4 [ RunTime:0.003527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529186 ORDER BY `minOrder` ASC [ RunTime:0.003488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529186 ORDER BY `unit` DESC [ RunTime:0.002806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529186 LIMIT 2 [ RunTime:0.002315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529186 ORDER BY `minOrder` ASC [ RunTime:0.003792s ]
select * from pdf where partno='2100036' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001543s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100036' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529184 LIMIT 4 [ RunTime:0.002532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529184 ORDER BY `minOrder` ASC [ RunTime:0.002858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529184 ORDER BY `unit` DESC [ RunTime:0.002912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529184 LIMIT 2 [ RunTime:0.005162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529184 ORDER BY `minOrder` ASC [ RunTime:0.004641s ]
select * from pdf where partno='2100249' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003292s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100249' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529170 LIMIT 4 [ RunTime:0.001348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529170 ORDER BY `minOrder` ASC [ RunTime:0.003896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529170 ORDER BY `unit` DESC [ RunTime:0.003112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529170 LIMIT 2 [ RunTime:0.003541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529170 ORDER BY `minOrder` ASC [ RunTime:0.003674s ]
select * from pdf where partno='2100048' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100048' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529169 LIMIT 4 [ RunTime:0.002732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529169 ORDER BY `minOrder` ASC [ RunTime:0.002724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529169 ORDER BY `unit` DESC [ RunTime:0.001054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529169 LIMIT 2 [ RunTime:0.002402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529169 ORDER BY `minOrder` ASC [ RunTime:0.002681s ]
select * from pdf where partno='2100043' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.006266s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100043' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529158 LIMIT 4 [ RunTime:0.000994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529158 ORDER BY `minOrder` ASC [ RunTime:0.004892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529158 ORDER BY `unit` DESC [ RunTime:0.005879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529158 LIMIT 2 [ RunTime:0.002567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529158 ORDER BY `minOrder` ASC [ RunTime:0.002003s ]
select * from pdf where partno='2100247' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009222s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100247' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529152 LIMIT 4 [ RunTime:0.006441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529152 ORDER BY `minOrder` ASC [ RunTime:0.003555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529152 ORDER BY `unit` DESC [ RunTime:0.002189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529152 LIMIT 2 [ RunTime:0.004218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529152 ORDER BY `minOrder` ASC [ RunTime:0.002702s ]
select * from pdf where partno='2100041' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100041' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529142 LIMIT 4 [ RunTime:0.005112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529142 ORDER BY `minOrder` ASC [ RunTime:0.005803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529142 ORDER BY `unit` DESC [ RunTime:0.006614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529142 LIMIT 2 [ RunTime:0.002441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529142 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
select * from pdf where partno='2100245' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.006272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100245' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529141 LIMIT 4 [ RunTime:0.002379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529141 ORDER BY `minOrder` ASC [ RunTime:0.001948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529141 ORDER BY `unit` DESC [ RunTime:0.001058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529141 LIMIT 2 [ RunTime:0.000508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529141 ORDER BY `minOrder` ASC [ RunTime:0.003829s ]
select * from pdf where partno='2100044' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002544s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100044' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529131 LIMIT 4 [ RunTime:0.004385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529131 ORDER BY `minOrder` ASC [ RunTime:0.000869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529131 ORDER BY `unit` DESC [ RunTime:0.000978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529131 LIMIT 2 [ RunTime:0.001849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529131 ORDER BY `minOrder` ASC [ RunTime:0.000524s ]
select * from pdf where partno='2100076' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004059s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100076' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529130 LIMIT 4 [ RunTime:0.001449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529130 ORDER BY `minOrder` ASC [ RunTime:0.000878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529130 ORDER BY `unit` DESC [ RunTime:0.004324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529130 LIMIT 2 [ RunTime:0.001539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529130 ORDER BY `minOrder` ASC [ RunTime:0.003327s ]
select * from pdf where partno='2100090' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100090' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529129 LIMIT 4 [ RunTime:0.000427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529129 ORDER BY `minOrder` ASC [ RunTime:0.002687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529129 ORDER BY `unit` DESC [ RunTime:0.007756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529129 LIMIT 2 [ RunTime:0.001549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529129 ORDER BY `minOrder` ASC [ RunTime:0.003689s ]
select * from pdf where partno='2100087' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001003s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100087' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529128 LIMIT 4 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529128 ORDER BY `minOrder` ASC [ RunTime:0.000890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529128 ORDER BY `unit` DESC [ RunTime:0.000917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529128 LIMIT 2 [ RunTime:0.004605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529128 ORDER BY `minOrder` ASC [ RunTime:0.002469s ]
select * from pdf where partno='2100079' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100079' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529127 LIMIT 4 [ RunTime:0.001260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529127 ORDER BY `minOrder` ASC [ RunTime:0.000720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529127 ORDER BY `unit` DESC [ RunTime:0.002571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529127 LIMIT 2 [ RunTime:0.001366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529127 ORDER BY `minOrder` ASC [ RunTime:0.004470s ]
select * from pdf where partno='2100088' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.007995s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100088' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004511s ]
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.090689s ]