SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001241s ]
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.001576s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.000917s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000371s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001688s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000561s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001531s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001006s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001067s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.010100s ]
UPDATE `stock_search` SET `count` = 1933 , `updatetime` = '2026-06-06 21:02:23' WHERE `partno` = '210' [ RunTime:0.014547s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.007643s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000308s ]
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.007713s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002162s ]
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.001066s ]
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.065904s ]
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.014035s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529282 LIMIT 4 [ RunTime:0.020285s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529282 ORDER BY `minOrder` ASC [ RunTime:0.006625s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529282 ORDER BY `unit` DESC [ RunTime:0.003947s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529282 LIMIT 2 [ RunTime:0.015089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529282 ORDER BY `minOrder` ASC [ RunTime:0.008230s ]
select * from pdf where partno='2100028' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.015241s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100028' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.022705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529273 LIMIT 4 [ RunTime:0.024794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529273 ORDER BY `minOrder` ASC [ RunTime:0.014101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529273 ORDER BY `unit` DESC [ RunTime:0.025050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529273 LIMIT 2 [ RunTime:0.001402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529273 ORDER BY `minOrder` ASC [ RunTime:0.000958s ]
select * from pdf where partno='2100031' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.026830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100031' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.023495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529271 LIMIT 4 [ RunTime:0.021750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529271 ORDER BY `minOrder` ASC [ RunTime:0.029349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529271 ORDER BY `unit` DESC [ RunTime:0.024784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529271 LIMIT 2 [ RunTime:0.034752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529271 ORDER BY `minOrder` ASC [ RunTime:0.004891s ]
select * from pdf where partno='2100030' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.038915s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100030' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.042118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529270 LIMIT 4 [ RunTime:0.016616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529270 ORDER BY `minOrder` ASC [ RunTime:0.008816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529270 ORDER BY `unit` DESC [ RunTime:0.049945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529270 LIMIT 2 [ RunTime:0.014930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529270 ORDER BY `minOrder` ASC [ RunTime:0.001450s ]
select * from pdf where partno='2100032' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.019809s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100032' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.021631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529222 LIMIT 4 [ RunTime:0.010758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529222 ORDER BY `minOrder` ASC [ RunTime:0.018284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529222 ORDER BY `unit` DESC [ RunTime:0.013577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529222 LIMIT 2 [ RunTime:0.005946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529222 ORDER BY `minOrder` ASC [ RunTime:0.003372s ]
select * from pdf where partno='2100035' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.015036s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100035' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.019995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529203 LIMIT 4 [ RunTime:0.031554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529203 ORDER BY `minOrder` ASC [ RunTime:0.025940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529203 ORDER BY `unit` DESC [ RunTime:0.006809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529203 LIMIT 2 [ RunTime:0.031564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529203 ORDER BY `minOrder` ASC [ RunTime:0.008498s ]
select * from pdf where partno='2100037' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.011544s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100037' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.014031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529202 LIMIT 4 [ RunTime:0.016499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529202 ORDER BY `minOrder` ASC [ RunTime:0.018400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529202 ORDER BY `unit` DESC [ RunTime:0.022899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529202 LIMIT 2 [ RunTime:0.019014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529202 ORDER BY `minOrder` ASC [ RunTime:0.006269s ]
select * from pdf where partno='2100038' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.034153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100038' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.013666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529186 LIMIT 4 [ RunTime:0.005573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529186 ORDER BY `minOrder` ASC [ RunTime:0.002498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529186 ORDER BY `unit` DESC [ RunTime:0.014954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529186 LIMIT 2 [ RunTime:0.011982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529186 ORDER BY `minOrder` ASC [ RunTime:0.005828s ]
select * from pdf where partno='2100036' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.008546s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100036' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.041323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529184 LIMIT 4 [ RunTime:0.021109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529184 ORDER BY `minOrder` ASC [ RunTime:0.012948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529184 ORDER BY `unit` DESC [ RunTime:0.013091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529184 LIMIT 2 [ RunTime:0.028918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529184 ORDER BY `minOrder` ASC [ RunTime:0.023761s ]
select * from pdf where partno='2100249' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.015733s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100249' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.030282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529170 LIMIT 4 [ RunTime:0.008157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529170 ORDER BY `minOrder` ASC [ RunTime:0.018002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529170 ORDER BY `unit` DESC [ RunTime:0.006870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529170 LIMIT 2 [ RunTime:0.028901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529170 ORDER BY `minOrder` ASC [ RunTime:0.009707s ]
select * from pdf where partno='2100048' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.006094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100048' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.029496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529169 LIMIT 4 [ RunTime:0.037938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529169 ORDER BY `minOrder` ASC [ RunTime:0.015994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529169 ORDER BY `unit` DESC [ RunTime:0.028244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529169 LIMIT 2 [ RunTime:0.009130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529169 ORDER BY `minOrder` ASC [ RunTime:0.000231s ]
select * from pdf where partno='2100043' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.010107s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100043' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.011938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529158 LIMIT 4 [ RunTime:0.013387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529158 ORDER BY `minOrder` ASC [ RunTime:0.012244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529158 ORDER BY `unit` DESC [ RunTime:0.003495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529158 LIMIT 2 [ RunTime:0.002837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529158 ORDER BY `minOrder` ASC [ RunTime:0.005880s ]
select * from pdf where partno='2100247' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.008987s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100247' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.022801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529152 LIMIT 4 [ RunTime:0.035586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529152 ORDER BY `minOrder` ASC [ RunTime:0.017646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529152 ORDER BY `unit` DESC [ RunTime:0.013137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529152 LIMIT 2 [ RunTime:0.006406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529152 ORDER BY `minOrder` ASC [ RunTime:0.004263s ]
select * from pdf where partno='2100041' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.017151s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100041' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.021779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529142 LIMIT 4 [ RunTime:0.015301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529142 ORDER BY `minOrder` ASC [ RunTime:0.007378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529142 ORDER BY `unit` DESC [ RunTime:0.018860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529142 LIMIT 2 [ RunTime:0.009961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529142 ORDER BY `minOrder` ASC [ RunTime:0.004681s ]
select * from pdf where partno='2100245' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.008940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100245' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529141 LIMIT 4 [ RunTime:0.008569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529141 ORDER BY `minOrder` ASC [ RunTime:0.016456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529141 ORDER BY `unit` DESC [ RunTime:0.006951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529141 LIMIT 2 [ RunTime:0.004876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529141 ORDER BY `minOrder` ASC [ RunTime:0.001834s ]
select * from pdf where partno='2100044' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.010538s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100044' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.023327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529131 LIMIT 4 [ RunTime:0.001572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529131 ORDER BY `minOrder` ASC [ RunTime:0.012392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529131 ORDER BY `unit` DESC [ RunTime:0.003362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529131 LIMIT 2 [ RunTime:0.009036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529131 ORDER BY `minOrder` ASC [ RunTime:0.005435s ]
select * from pdf where partno='2100076' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100076' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.025287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529130 LIMIT 4 [ RunTime:0.013184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529130 ORDER BY `minOrder` ASC [ RunTime:0.019364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529130 ORDER BY `unit` DESC [ RunTime:0.016295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529130 LIMIT 2 [ RunTime:0.009792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529130 ORDER BY `minOrder` ASC [ RunTime:0.008838s ]
select * from pdf where partno='2100090' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003374s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100090' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.023391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529129 LIMIT 4 [ RunTime:0.011280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529129 ORDER BY `minOrder` ASC [ RunTime:0.017601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529129 ORDER BY `unit` DESC [ RunTime:0.014627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529129 LIMIT 2 [ RunTime:0.002264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529129 ORDER BY `minOrder` ASC [ RunTime:0.013283s ]
select * from pdf where partno='2100087' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.007214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100087' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.018951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529128 LIMIT 4 [ RunTime:0.021943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529128 ORDER BY `minOrder` ASC [ RunTime:0.015281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529128 ORDER BY `unit` DESC [ RunTime:0.003245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529128 LIMIT 2 [ RunTime:0.000707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529128 ORDER BY `minOrder` ASC [ RunTime:0.000642s ]
select * from pdf where partno='2100079' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100079' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.011913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529127 LIMIT 4 [ RunTime:0.003737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529127 ORDER BY `minOrder` ASC [ RunTime:0.007777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529127 ORDER BY `unit` DESC [ RunTime:0.000896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529127 LIMIT 2 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529127 ORDER BY `minOrder` ASC [ RunTime:0.003086s ]
select * from pdf where partno='2100088' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000912s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100088' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005472s ]
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.000500s ]