SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002169s ]
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.009231s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001335s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.016039s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002388s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.004445s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002490s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.027991s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002002s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.019793s ]
UPDATE `stock_search` SET `count` = 4122 , `updatetime` = '2026-06-08 16:46:49' WHERE `partno` = '210' [ RunTime:0.031700s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.012758s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.008906s ]
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.067461s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002847s ]
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.043039s ]
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 4720,20 [ RunTime:0.165331s ]
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 ('33619012','33618416','33618113','33529455','33529453','33529450','33529292','33529285','33529282','33529273','33529271','33529270','33529222','33529203','33529202','33529186','33529184','33529170','33529169','33529158') ORDER BY FIELD(s.id, 33619012,33618416,33618113,33529455,33529453,33529450,33529292,33529285,33529282,33529273,33529271,33529270,33529222,33529203,33529202,33529186,33529184,33529170,33529169,33529158) [ RunTime:0.069772s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33619012 LIMIT 4 [ RunTime:0.040788s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33619012 ORDER BY `minOrder` ASC [ RunTime:0.048069s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.077318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33619012 ORDER BY `unit` DESC [ RunTime:0.049996s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.019479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33619012 LIMIT 2 [ RunTime:0.024681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33619012 ORDER BY `minOrder` ASC [ RunTime:0.031618s ]
select * from pdf where partno='2104-1307' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.025363s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104-1307' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.023517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33618416 LIMIT 4 [ RunTime:0.063349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618416 ORDER BY `minOrder` ASC [ RunTime:0.040355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33618416 ORDER BY `unit` DESC [ RunTime:0.096818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33618416 LIMIT 2 [ RunTime:0.108905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618416 ORDER BY `minOrder` ASC [ RunTime:0.054813s ]
select * from pdf where partno='2102-1304' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.007547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102-1304' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.041238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33618113 LIMIT 4 [ RunTime:0.057353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618113 ORDER BY `minOrder` ASC [ RunTime:0.073824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33618113 ORDER BY `unit` DESC [ RunTime:0.061850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33618113 LIMIT 2 [ RunTime:0.059281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33618113 ORDER BY `minOrder` ASC [ RunTime:0.014016s ]
select * from pdf where partno='2102-5207' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.035602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102-5207' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.046820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529455 LIMIT 4 [ RunTime:0.012029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529455 ORDER BY `minOrder` ASC [ RunTime:0.023993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529455 ORDER BY `unit` DESC [ RunTime:0.021732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529455 LIMIT 2 [ RunTime:0.022542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529455 ORDER BY `minOrder` ASC [ RunTime:0.004267s ]
select * from pdf where partno='2100G' and brandshort='American Electrical Inc.' limit 1 [ RunTime:0.036874s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100G' OR `brand` LIKE 'American Electrical Inc.%' ) ) LIMIT 1 [ RunTime:0.064593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529453 LIMIT 4 [ RunTime:0.047883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529453 ORDER BY `minOrder` ASC [ RunTime:0.054999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529453 ORDER BY `unit` DESC [ RunTime:0.027440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529453 LIMIT 2 [ RunTime:0.086756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529453 ORDER BY `minOrder` ASC [ RunTime:0.016328s ]
select * from pdf where partno='2100025' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.045028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100025' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.039350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529450 LIMIT 4 [ RunTime:0.077479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529450 ORDER BY `minOrder` ASC [ RunTime:0.039974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529450 ORDER BY `unit` DESC [ RunTime:0.115597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529450 LIMIT 2 [ RunTime:0.111385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529450 ORDER BY `minOrder` ASC [ RunTime:0.028529s ]
select * from pdf where partno='2100024' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.022490s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100024' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.089580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529292 LIMIT 4 [ RunTime:0.020886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529292 ORDER BY `minOrder` ASC [ RunTime:0.050539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529292 ORDER BY `unit` DESC [ RunTime:0.055868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529292 LIMIT 2 [ RunTime:0.101624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529292 ORDER BY `minOrder` ASC [ RunTime:0.099502s ]
select * from pdf where partno='2100023' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.025797s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100023' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.055045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529285 LIMIT 4 [ RunTime:0.051895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529285 ORDER BY `minOrder` ASC [ RunTime:0.018324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529285 ORDER BY `unit` DESC [ RunTime:0.033328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529285 LIMIT 2 [ RunTime:0.046441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529285 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
select * from pdf where partno='2100027' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.007455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100027' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.036274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529282 LIMIT 4 [ RunTime:0.025233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529282 ORDER BY `minOrder` ASC [ RunTime:0.024748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529282 ORDER BY `unit` DESC [ RunTime:0.043641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529282 LIMIT 2 [ RunTime:0.010922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529282 ORDER BY `minOrder` ASC [ RunTime:0.014573s ]
select * from pdf where partno='2100028' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.024602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100028' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.045212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529273 LIMIT 4 [ RunTime:0.096448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529273 ORDER BY `minOrder` ASC [ RunTime:0.038451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529273 ORDER BY `unit` DESC [ RunTime:0.343396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529273 LIMIT 2 [ RunTime:0.276721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529273 ORDER BY `minOrder` ASC [ RunTime:0.071150s ]
select * from pdf where partno='2100031' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.052313s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100031' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.183438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529271 LIMIT 4 [ RunTime:0.110728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529271 ORDER BY `minOrder` ASC [ RunTime:0.187494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529271 ORDER BY `unit` DESC [ RunTime:0.165746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529271 LIMIT 2 [ RunTime:0.098431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529271 ORDER BY `minOrder` ASC [ RunTime:0.038099s ]
select * from pdf where partno='2100030' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.093848s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100030' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.037933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529270 LIMIT 4 [ RunTime:0.048159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529270 ORDER BY `minOrder` ASC [ RunTime:0.036610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529270 ORDER BY `unit` DESC [ RunTime:0.007148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529270 LIMIT 2 [ RunTime:0.036698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529270 ORDER BY `minOrder` ASC [ RunTime:0.024099s ]
select * from pdf where partno='2100032' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.019545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100032' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.014940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529222 LIMIT 4 [ RunTime:0.008959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529222 ORDER BY `minOrder` ASC [ RunTime:0.011011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529222 ORDER BY `unit` DESC [ RunTime:0.005336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529222 LIMIT 2 [ RunTime:0.006385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529222 ORDER BY `minOrder` ASC [ RunTime:0.002487s ]
select * from pdf where partno='2100035' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001963s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100035' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529203 LIMIT 4 [ RunTime:0.002459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529203 ORDER BY `minOrder` ASC [ RunTime:0.003719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529203 ORDER BY `unit` DESC [ RunTime:0.011876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529203 LIMIT 2 [ RunTime:0.006453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529203 ORDER BY `minOrder` ASC [ RunTime:0.003574s ]
select * from pdf where partno='2100037' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100037' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529202 LIMIT 4 [ RunTime:0.002507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529202 ORDER BY `minOrder` ASC [ RunTime:0.003356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529202 ORDER BY `unit` DESC [ RunTime:0.001496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529202 LIMIT 2 [ RunTime:0.001499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529202 ORDER BY `minOrder` ASC [ RunTime:0.000602s ]
select * from pdf where partno='2100038' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100038' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529186 LIMIT 4 [ RunTime:0.008013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529186 ORDER BY `minOrder` ASC [ RunTime:0.002219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529186 ORDER BY `unit` DESC [ RunTime:0.001647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529186 LIMIT 2 [ RunTime:0.002049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529186 ORDER BY `minOrder` ASC [ RunTime:0.000697s ]
select * from pdf where partno='2100036' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100036' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529184 LIMIT 4 [ RunTime:0.001509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529184 ORDER BY `minOrder` ASC [ RunTime:0.001123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529184 ORDER BY `unit` DESC [ RunTime:0.002548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529184 LIMIT 2 [ RunTime:0.001877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529184 ORDER BY `minOrder` ASC [ RunTime:0.009070s ]
select * from pdf where partno='2100249' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100249' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529170 LIMIT 4 [ RunTime:0.002712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529170 ORDER BY `minOrder` ASC [ RunTime:0.001203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529170 ORDER BY `unit` DESC [ RunTime:0.004659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529170 LIMIT 2 [ RunTime:0.002899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529170 ORDER BY `minOrder` ASC [ RunTime:0.004185s ]
select * from pdf where partno='2100048' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001098s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100048' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529169 LIMIT 4 [ RunTime:0.006219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529169 ORDER BY `minOrder` ASC [ RunTime:0.007678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529169 ORDER BY `unit` DESC [ RunTime:0.005180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529169 LIMIT 2 [ RunTime:0.002179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529169 ORDER BY `minOrder` ASC [ RunTime:0.000555s ]
select * from pdf where partno='2100043' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003242s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100043' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529158 LIMIT 4 [ RunTime:0.000661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529158 ORDER BY `minOrder` ASC [ RunTime:0.001479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529158 ORDER BY `unit` DESC [ RunTime:0.001854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529158 LIMIT 2 [ RunTime:0.000671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529158 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
select * from pdf where partno='2100247' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100247' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003433s ]
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.001130s ]