SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001545s ]
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.001713s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001232s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000518s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001417s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000264s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000974s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000189s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.005228s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.005922s ]
UPDATE `stock_search` SET `count` = 1997 , `updatetime` = '2026-06-06 21:09:19' WHERE `partno` = '210' [ RunTime:0.004240s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.004999s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000275s ]
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.000433s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001884s ]
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.058990s ]
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 2680,20 [ RunTime:0.091146s ]
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 ('33529126','33529122','33529121','33529120','33529116','33529115','33529108','33529107','33529106','33529105','33529102','33529101','33529100','33529099','33529095','33529094','33529093','33529092','33529091','33529090') ORDER BY FIELD(s.id, 33529126,33529122,33529121,33529120,33529116,33529115,33529108,33529107,33529106,33529105,33529102,33529101,33529100,33529099,33529095,33529094,33529093,33529092,33529091,33529090) [ RunTime:0.018242s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529126 LIMIT 4 [ RunTime:0.008738s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529126 ORDER BY `minOrder` ASC [ RunTime:0.012480s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529126 ORDER BY `unit` DESC [ RunTime:0.002451s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529126 LIMIT 2 [ RunTime:0.003684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529126 ORDER BY `minOrder` ASC [ RunTime:0.005505s ]
select * from pdf where partno='2100092' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000824s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100092' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529122 LIMIT 4 [ RunTime:0.001892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529122 ORDER BY `minOrder` ASC [ RunTime:0.000674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529122 ORDER BY `unit` DESC [ RunTime:0.000263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529122 LIMIT 2 [ RunTime:0.002535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529122 ORDER BY `minOrder` ASC [ RunTime:0.000536s ]
select * from pdf where partno='2100112' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004913s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100112' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529121 LIMIT 4 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529121 ORDER BY `minOrder` ASC [ RunTime:0.003890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529121 ORDER BY `unit` DESC [ RunTime:0.002493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529121 LIMIT 2 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529121 ORDER BY `minOrder` ASC [ RunTime:0.000353s ]
select * from pdf where partno='2100108' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002887s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100108' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529120 LIMIT 4 [ RunTime:0.001446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529120 ORDER BY `minOrder` ASC [ RunTime:0.000690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529120 ORDER BY `unit` DESC [ RunTime:0.003175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529120 LIMIT 2 [ RunTime:0.000402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529120 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
select * from pdf where partno='2100104' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004362s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100104' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529116 LIMIT 4 [ RunTime:0.004373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529116 ORDER BY `minOrder` ASC [ RunTime:0.020974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529116 ORDER BY `unit` DESC [ RunTime:0.008585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529116 LIMIT 2 [ RunTime:0.006779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529116 ORDER BY `minOrder` ASC [ RunTime:0.001502s ]
select * from pdf where partno='2100071' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.008062s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100071' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529115 LIMIT 4 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529115 ORDER BY `minOrder` ASC [ RunTime:0.003142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529115 ORDER BY `unit` DESC [ RunTime:0.000532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529115 LIMIT 2 [ RunTime:0.000403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529115 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
select * from pdf where partno='2100005' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.008613s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100005' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529108 LIMIT 4 [ RunTime:0.000991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529108 ORDER BY `minOrder` ASC [ RunTime:0.005121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529108 ORDER BY `unit` DESC [ RunTime:0.006715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529108 LIMIT 2 [ RunTime:0.012579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529108 ORDER BY `minOrder` ASC [ RunTime:0.012859s ]
select * from pdf where partno='2100007' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005636s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100007' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529107 LIMIT 4 [ RunTime:0.005837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529107 ORDER BY `minOrder` ASC [ RunTime:0.005248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529107 ORDER BY `unit` DESC [ RunTime:0.023283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529107 LIMIT 2 [ RunTime:0.024420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529107 ORDER BY `minOrder` ASC [ RunTime:0.002725s ]
select * from pdf where partno='2100050' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004764s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100050' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529106 LIMIT 4 [ RunTime:0.000273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529106 ORDER BY `minOrder` ASC [ RunTime:0.001231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529106 ORDER BY `unit` DESC [ RunTime:0.000406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529106 LIMIT 2 [ RunTime:0.000284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529106 ORDER BY `minOrder` ASC [ RunTime:0.000404s ]
select * from pdf where partno='2100047' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100047' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529105 LIMIT 4 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529105 ORDER BY `minOrder` ASC [ RunTime:0.016520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529105 ORDER BY `unit` DESC [ RunTime:0.016043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529105 LIMIT 2 [ RunTime:0.011615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529105 ORDER BY `minOrder` ASC [ RunTime:0.009208s ]
select * from pdf where partno='2100039' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.025233s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100039' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529102 LIMIT 4 [ RunTime:0.004166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529102 ORDER BY `minOrder` ASC [ RunTime:0.044218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529102 ORDER BY `unit` DESC [ RunTime:0.036085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529102 LIMIT 2 [ RunTime:0.011681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529102 ORDER BY `minOrder` ASC [ RunTime:0.000650s ]
select * from pdf where partno='2100110' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100110' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.023030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529101 LIMIT 4 [ RunTime:0.030242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529101 ORDER BY `minOrder` ASC [ RunTime:0.024393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529101 ORDER BY `unit` DESC [ RunTime:0.028082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529101 LIMIT 2 [ RunTime:0.011359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529101 ORDER BY `minOrder` ASC [ RunTime:0.005449s ]
select * from pdf where partno='2100105' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.023392s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100105' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529100 LIMIT 4 [ RunTime:0.012531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529100 ORDER BY `minOrder` ASC [ RunTime:0.009908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529100 ORDER BY `unit` DESC [ RunTime:0.010034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529100 LIMIT 2 [ RunTime:0.005221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529100 ORDER BY `minOrder` ASC [ RunTime:0.011328s ]
select * from pdf where partno='2100010' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100010' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.024074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529099 LIMIT 4 [ RunTime:0.009247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529099 ORDER BY `minOrder` ASC [ RunTime:0.029739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529099 ORDER BY `unit` DESC [ RunTime:0.016576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529099 LIMIT 2 [ RunTime:0.003759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529099 ORDER BY `minOrder` ASC [ RunTime:0.010775s ]
select * from pdf where partno='2100009' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002983s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100009' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.001765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529095 LIMIT 4 [ RunTime:0.017624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529095 ORDER BY `minOrder` ASC [ RunTime:0.002499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529095 ORDER BY `unit` DESC [ RunTime:0.007546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529095 LIMIT 2 [ RunTime:0.006265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529095 ORDER BY `minOrder` ASC [ RunTime:0.007527s ]
select * from pdf where partno='2100149' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002345s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100149' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529094 LIMIT 4 [ RunTime:0.000405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529094 ORDER BY `minOrder` ASC [ RunTime:0.004412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529094 ORDER BY `unit` DESC [ RunTime:0.002744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529094 LIMIT 2 [ RunTime:0.010686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529094 ORDER BY `minOrder` ASC [ RunTime:0.001818s ]
select * from pdf where partno='2100242' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100242' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529093 LIMIT 4 [ RunTime:0.000731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529093 ORDER BY `minOrder` ASC [ RunTime:0.003468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529093 ORDER BY `unit` DESC [ RunTime:0.000509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529093 LIMIT 2 [ RunTime:0.002807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529093 ORDER BY `minOrder` ASC [ RunTime:0.005986s ]
select * from pdf where partno='2100241' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.006005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100241' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529092 LIMIT 4 [ RunTime:0.004034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529092 ORDER BY `minOrder` ASC [ RunTime:0.011218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529092 ORDER BY `unit` DESC [ RunTime:0.008240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529092 LIMIT 2 [ RunTime:0.009895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529092 ORDER BY `minOrder` ASC [ RunTime:0.001714s ]
select * from pdf where partno='2100139' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005658s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100139' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529091 LIMIT 4 [ RunTime:0.001670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529091 ORDER BY `minOrder` ASC [ RunTime:0.009987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529091 ORDER BY `unit` DESC [ RunTime:0.011763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529091 LIMIT 2 [ RunTime:0.002947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529091 ORDER BY `minOrder` ASC [ RunTime:0.023406s ]
select * from pdf where partno='2100053' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.016316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100053' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.013200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529090 LIMIT 4 [ RunTime:0.002119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529090 ORDER BY `minOrder` ASC [ RunTime:0.004757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529090 ORDER BY `unit` DESC [ RunTime:0.010144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529090 LIMIT 2 [ RunTime:0.000479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529090 ORDER BY `minOrder` ASC [ RunTime:0.000269s ]
select * from pdf where partno='2100147' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001186s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100147' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.000312s ]
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.000384s ]