SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002403s ]
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.002848s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001999s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000469s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002527s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000244s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001332s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000274s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001426s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.004544s ]
UPDATE `stock_search` SET `count` = 1968 , `updatetime` = '2026-06-06 21:06:06' WHERE `partno` = '210' [ RunTime:0.003990s ]
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.000234s ]
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.000403s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001917s ]
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.076734s ]
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.068735s ]
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.003241s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529282 LIMIT 4 [ RunTime:0.000398s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529282 ORDER BY `minOrder` ASC [ RunTime:0.000718s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529282 ORDER BY `unit` DESC [ RunTime:0.004694s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529282 LIMIT 2 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529282 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
select * from pdf where partno='2100028' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002710s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002328s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100028' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529273 LIMIT 4 [ RunTime:0.000751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529273 ORDER BY `minOrder` ASC [ RunTime:0.003475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529273 ORDER BY `unit` DESC [ RunTime:0.002862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529273 LIMIT 2 [ RunTime:0.001789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529273 ORDER BY `minOrder` ASC [ RunTime:0.004623s ]
select * from pdf where partno='2100031' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003166s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100031' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529271 LIMIT 4 [ RunTime:0.004655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529271 ORDER BY `minOrder` ASC [ RunTime:0.018739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529271 ORDER BY `unit` DESC [ RunTime:0.001063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529271 LIMIT 2 [ RunTime:0.000454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529271 ORDER BY `minOrder` ASC [ RunTime:0.000751s ]
select * from pdf where partno='2100030' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004567s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100030' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529270 LIMIT 4 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529270 ORDER BY `minOrder` ASC [ RunTime:0.001744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529270 ORDER BY `unit` DESC [ RunTime:0.003216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529270 LIMIT 2 [ RunTime:0.003821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529270 ORDER BY `minOrder` ASC [ RunTime:0.004537s ]
select * from pdf where partno='2100032' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.007558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100032' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529222 LIMIT 4 [ RunTime:0.003649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529222 ORDER BY `minOrder` ASC [ RunTime:0.008001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529222 ORDER BY `unit` DESC [ RunTime:0.005245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529222 LIMIT 2 [ RunTime:0.001733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529222 ORDER BY `minOrder` ASC [ RunTime:0.003483s ]
select * from pdf where partno='2100035' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.006680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100035' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529203 LIMIT 4 [ RunTime:0.006622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529203 ORDER BY `minOrder` ASC [ RunTime:0.004470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529203 ORDER BY `unit` DESC [ RunTime:0.003450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529203 LIMIT 2 [ RunTime:0.005517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529203 ORDER BY `minOrder` ASC [ RunTime:0.002378s ]
select * from pdf where partno='2100037' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.011418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100037' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529202 LIMIT 4 [ RunTime:0.002478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529202 ORDER BY `minOrder` ASC [ RunTime:0.001348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529202 ORDER BY `unit` DESC [ RunTime:0.002838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529202 LIMIT 2 [ RunTime:0.001323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529202 ORDER BY `minOrder` ASC [ RunTime:0.001919s ]
select * from pdf where partno='2100038' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100038' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529186 LIMIT 4 [ RunTime:0.003724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529186 ORDER BY `minOrder` ASC [ RunTime:0.001329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529186 ORDER BY `unit` DESC [ RunTime:0.001883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529186 LIMIT 2 [ RunTime:0.002641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529186 ORDER BY `minOrder` ASC [ RunTime:0.002710s ]
select * from pdf where partno='2100036' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003164s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100036' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529184 LIMIT 4 [ RunTime:0.008081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529184 ORDER BY `minOrder` ASC [ RunTime:0.001204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529184 ORDER BY `unit` DESC [ RunTime:0.001359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529184 LIMIT 2 [ RunTime:0.000283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529184 ORDER BY `minOrder` ASC [ RunTime:0.000942s ]
select * from pdf where partno='2100249' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.006603s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100249' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529170 LIMIT 4 [ RunTime:0.003925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529170 ORDER BY `minOrder` ASC [ RunTime:0.000854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529170 ORDER BY `unit` DESC [ RunTime:0.002636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529170 LIMIT 2 [ RunTime:0.000357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529170 ORDER BY `minOrder` ASC [ RunTime:0.001090s ]
select * from pdf where partno='2100048' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001186s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100048' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529169 LIMIT 4 [ RunTime:0.000357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529169 ORDER BY `minOrder` ASC [ RunTime:0.002312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529169 ORDER BY `unit` DESC [ RunTime:0.002344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529169 LIMIT 2 [ RunTime:0.006967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529169 ORDER BY `minOrder` ASC [ RunTime:0.006462s ]
select * from pdf where partno='2100043' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100043' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529158 LIMIT 4 [ RunTime:0.005344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529158 ORDER BY `minOrder` ASC [ RunTime:0.001737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529158 ORDER BY `unit` DESC [ RunTime:0.000986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529158 LIMIT 2 [ RunTime:0.002522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529158 ORDER BY `minOrder` ASC [ RunTime:0.002411s ]
select * from pdf where partno='2100247' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.008136s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100247' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529152 LIMIT 4 [ RunTime:0.002157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529152 ORDER BY `minOrder` ASC [ RunTime:0.008814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529152 ORDER BY `unit` DESC [ RunTime:0.004610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529152 LIMIT 2 [ RunTime:0.004471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529152 ORDER BY `minOrder` ASC [ RunTime:0.004385s ]
select * from pdf where partno='2100041' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100041' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529142 LIMIT 4 [ RunTime:0.000360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529142 ORDER BY `minOrder` ASC [ RunTime:0.004146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529142 ORDER BY `unit` DESC [ RunTime:0.000864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529142 LIMIT 2 [ RunTime:0.003180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529142 ORDER BY `minOrder` ASC [ RunTime:0.003972s ]
select * from pdf where partno='2100245' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100245' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529141 LIMIT 4 [ RunTime:0.006579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529141 ORDER BY `minOrder` ASC [ RunTime:0.001224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529141 ORDER BY `unit` DESC [ RunTime:0.002338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529141 LIMIT 2 [ RunTime:0.001821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529141 ORDER BY `minOrder` ASC [ RunTime:0.000592s ]
select * from pdf where partno='2100044' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100044' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529131 LIMIT 4 [ RunTime:0.002356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529131 ORDER BY `minOrder` ASC [ RunTime:0.005464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529131 ORDER BY `unit` DESC [ RunTime:0.001537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529131 LIMIT 2 [ RunTime:0.002025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529131 ORDER BY `minOrder` ASC [ RunTime:0.004838s ]
select * from pdf where partno='2100076' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000712s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100076' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529130 LIMIT 4 [ RunTime:0.004538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529130 ORDER BY `minOrder` ASC [ RunTime:0.001583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529130 ORDER BY `unit` DESC [ RunTime:0.002789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529130 LIMIT 2 [ RunTime:0.000957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529130 ORDER BY `minOrder` ASC [ RunTime:0.001219s ]
select * from pdf where partno='2100090' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100090' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529129 LIMIT 4 [ RunTime:0.005052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529129 ORDER BY `minOrder` ASC [ RunTime:0.004849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529129 ORDER BY `unit` DESC [ RunTime:0.003479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529129 LIMIT 2 [ RunTime:0.000789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529129 ORDER BY `minOrder` ASC [ RunTime:0.003350s ]
select * from pdf where partno='2100087' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100087' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529128 LIMIT 4 [ RunTime:0.001706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529128 ORDER BY `minOrder` ASC [ RunTime:0.004138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529128 ORDER BY `unit` DESC [ RunTime:0.002198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529128 LIMIT 2 [ RunTime:0.001553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529128 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
select * from pdf where partno='2100079' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100079' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529127 LIMIT 4 [ RunTime:0.004570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529127 ORDER BY `minOrder` ASC [ RunTime:0.007989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529127 ORDER BY `unit` DESC [ RunTime:0.008298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529127 LIMIT 2 [ RunTime:0.021933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529127 ORDER BY `minOrder` ASC [ RunTime:0.014558s ]
select * from pdf where partno='2100088' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.010251s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100088' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007005s ]
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.020836s ]