SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003720s ]
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.008392s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002228s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000690s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002454s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000413s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001912s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000343s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002045s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000768s ]
UPDATE `stock_search` SET `count` = 1961 , `updatetime` = '2026-06-06 21:05:41' WHERE `partno` = '210' [ RunTime:0.001919s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000310s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000278s ]
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.000466s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002550s ]
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.000494s ]
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.067212s ]
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.010555s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529126 LIMIT 4 [ RunTime:0.000975s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529126 ORDER BY `minOrder` ASC [ RunTime:0.005671s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529126 ORDER BY `unit` DESC [ RunTime:0.006434s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529126 LIMIT 2 [ RunTime:0.000818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529126 ORDER BY `minOrder` ASC [ RunTime:0.001046s ]
select * from pdf where partno='2100092' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005169s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003708s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100092' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529122 LIMIT 4 [ RunTime:0.002065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529122 ORDER BY `minOrder` ASC [ RunTime:0.007189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529122 ORDER BY `unit` DESC [ RunTime:0.003668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529122 LIMIT 2 [ RunTime:0.005956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529122 ORDER BY `minOrder` ASC [ RunTime:0.035399s ]
select * from pdf where partno='2100112' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.042601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100112' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.016372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529121 LIMIT 4 [ RunTime:0.026919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529121 ORDER BY `minOrder` ASC [ RunTime:0.010284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529121 ORDER BY `unit` DESC [ RunTime:0.015562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529121 LIMIT 2 [ RunTime:0.061899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529121 ORDER BY `minOrder` ASC [ RunTime:0.035721s ]
select * from pdf where partno='2100108' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.065762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100108' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.034929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529120 LIMIT 4 [ RunTime:0.031854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529120 ORDER BY `minOrder` ASC [ RunTime:0.009145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529120 ORDER BY `unit` DESC [ RunTime:0.028365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529120 LIMIT 2 [ RunTime:0.026165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529120 ORDER BY `minOrder` ASC [ RunTime:0.019706s ]
select * from pdf where partno='2100104' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.023679s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100104' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.024643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529116 LIMIT 4 [ RunTime:0.023042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529116 ORDER BY `minOrder` ASC [ RunTime:0.034721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529116 ORDER BY `unit` DESC [ RunTime:0.017992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529116 LIMIT 2 [ RunTime:0.069213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529116 ORDER BY `minOrder` ASC [ RunTime:0.014039s ]
select * from pdf where partno='2100071' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.037102s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100071' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.048431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529115 LIMIT 4 [ RunTime:0.023475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529115 ORDER BY `minOrder` ASC [ RunTime:0.015996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529115 ORDER BY `unit` DESC [ RunTime:0.050793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529115 LIMIT 2 [ RunTime:0.030534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529115 ORDER BY `minOrder` ASC [ RunTime:0.006239s ]
select * from pdf where partno='2100005' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.043001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100005' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.032958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529108 LIMIT 4 [ RunTime:0.020864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529108 ORDER BY `minOrder` ASC [ RunTime:0.034388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529108 ORDER BY `unit` DESC [ RunTime:0.022363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529108 LIMIT 2 [ RunTime:0.048872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529108 ORDER BY `minOrder` ASC [ RunTime:0.011640s ]
select * from pdf where partno='2100007' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.014432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100007' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.014930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529107 LIMIT 4 [ RunTime:0.012390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529107 ORDER BY `minOrder` ASC [ RunTime:0.050875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529107 ORDER BY `unit` DESC [ RunTime:0.024575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529107 LIMIT 2 [ RunTime:0.014085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529107 ORDER BY `minOrder` ASC [ RunTime:0.007448s ]
select * from pdf where partno='2100050' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100050' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.023160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529106 LIMIT 4 [ RunTime:0.018495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529106 ORDER BY `minOrder` ASC [ RunTime:0.025605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529106 ORDER BY `unit` DESC [ RunTime:0.053964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529106 LIMIT 2 [ RunTime:0.003752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529106 ORDER BY `minOrder` ASC [ RunTime:0.005564s ]
select * from pdf where partno='2100047' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.018908s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100047' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.064977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529105 LIMIT 4 [ RunTime:0.023156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529105 ORDER BY `minOrder` ASC [ RunTime:0.057942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529105 ORDER BY `unit` DESC [ RunTime:0.018808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529105 LIMIT 2 [ RunTime:0.017319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529105 ORDER BY `minOrder` ASC [ RunTime:0.005863s ]
select * from pdf where partno='2100039' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.025852s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100039' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.037657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529102 LIMIT 4 [ RunTime:0.018170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529102 ORDER BY `minOrder` ASC [ RunTime:0.012405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529102 ORDER BY `unit` DESC [ RunTime:0.027481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529102 LIMIT 2 [ RunTime:0.025367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529102 ORDER BY `minOrder` ASC [ RunTime:0.005698s ]
select * from pdf where partno='2100110' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.017585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100110' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.043553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529101 LIMIT 4 [ RunTime:0.023310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529101 ORDER BY `minOrder` ASC [ RunTime:0.031901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529101 ORDER BY `unit` DESC [ RunTime:0.009774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529101 LIMIT 2 [ RunTime:0.013427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529101 ORDER BY `minOrder` ASC [ RunTime:0.012426s ]
select * from pdf where partno='2100105' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.019112s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100105' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.028794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529100 LIMIT 4 [ RunTime:0.029800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529100 ORDER BY `minOrder` ASC [ RunTime:0.025456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529100 ORDER BY `unit` DESC [ RunTime:0.017820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529100 LIMIT 2 [ RunTime:0.016509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529100 ORDER BY `minOrder` ASC [ RunTime:0.014358s ]
select * from pdf where partno='2100010' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.014434s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100010' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.020279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529099 LIMIT 4 [ RunTime:0.006895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529099 ORDER BY `minOrder` ASC [ RunTime:0.021988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529099 ORDER BY `unit` DESC [ RunTime:0.027509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529099 LIMIT 2 [ RunTime:0.009572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529099 ORDER BY `minOrder` ASC [ RunTime:0.004448s ]
select * from pdf where partno='2100009' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.015201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100009' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.032580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529095 LIMIT 4 [ RunTime:0.012740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529095 ORDER BY `minOrder` ASC [ RunTime:0.057239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529095 ORDER BY `unit` DESC [ RunTime:0.028365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529095 LIMIT 2 [ RunTime:0.034323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529095 ORDER BY `minOrder` ASC [ RunTime:0.012271s ]
select * from pdf where partno='2100149' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.010531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100149' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.030504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529094 LIMIT 4 [ RunTime:0.010635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529094 ORDER BY `minOrder` ASC [ RunTime:0.012474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529094 ORDER BY `unit` DESC [ RunTime:0.019733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529094 LIMIT 2 [ RunTime:0.024203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529094 ORDER BY `minOrder` ASC [ RunTime:0.011472s ]
select * from pdf where partno='2100242' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.014728s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100242' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529093 LIMIT 4 [ RunTime:0.004573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529093 ORDER BY `minOrder` ASC [ RunTime:0.001930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529093 ORDER BY `unit` DESC [ RunTime:0.007206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529093 LIMIT 2 [ RunTime:0.011373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529093 ORDER BY `minOrder` ASC [ RunTime:0.000555s ]
select * from pdf where partno='2100241' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100241' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.013149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529092 LIMIT 4 [ RunTime:0.007110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529092 ORDER BY `minOrder` ASC [ RunTime:0.011783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529092 ORDER BY `unit` DESC [ RunTime:0.001452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529092 LIMIT 2 [ RunTime:0.008991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529092 ORDER BY `minOrder` ASC [ RunTime:0.000636s ]
select * from pdf where partno='2100139' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100139' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.009713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529091 LIMIT 4 [ RunTime:0.012426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529091 ORDER BY `minOrder` ASC [ RunTime:0.014838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529091 ORDER BY `unit` DESC [ RunTime:0.009883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529091 LIMIT 2 [ RunTime:0.003557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529091 ORDER BY `minOrder` ASC [ RunTime:0.006821s ]
select * from pdf where partno='2100053' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100053' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529090 LIMIT 4 [ RunTime:0.005284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529090 ORDER BY `minOrder` ASC [ RunTime:0.014125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529090 ORDER BY `unit` DESC [ RunTime:0.000719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529090 LIMIT 2 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529090 ORDER BY `minOrder` ASC [ RunTime:0.001480s ]
select * from pdf where partno='2100147' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002732s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100147' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.009878s ]
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.006789s ]