SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001316s ]
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.001732s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.000877s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001730s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001530s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000271s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001190s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001471s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001083s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.004456s ]
UPDATE `stock_search` SET `count` = 1402 , `updatetime` = '2026-06-06 18:33:45' WHERE `partno` = '210' [ RunTime:0.008984s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000903s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.001586s ]
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.002678s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002954s ]
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.005002s ]
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.070501s ]
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 ('33529101','33529100','33529099','33529095','33529094','33529093','33529092','33529091','33529090','33529086','33529085','33529084','33529083','33529082','33529081','33529080','33529079','33529078','33529077','33529062') ORDER BY FIELD(s.id, 33529101,33529100,33529099,33529095,33529094,33529093,33529092,33529091,33529090,33529086,33529085,33529084,33529083,33529082,33529081,33529080,33529079,33529078,33529077,33529062) [ RunTime:0.010856s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529101 LIMIT 4 [ RunTime:0.004819s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529101 ORDER BY `minOrder` ASC [ RunTime:0.003219s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529101 ORDER BY `unit` DESC [ RunTime:0.006774s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529101 LIMIT 2 [ RunTime:0.004830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529101 ORDER BY `minOrder` ASC [ RunTime:0.003012s ]
select * from pdf where partno='2100105' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009666s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002069s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100105' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529100 LIMIT 4 [ RunTime:0.012194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529100 ORDER BY `minOrder` ASC [ RunTime:0.000691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529100 ORDER BY `unit` DESC [ RunTime:0.007277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529100 LIMIT 2 [ RunTime:0.013534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529100 ORDER BY `minOrder` ASC [ RunTime:0.007243s ]
select * from pdf where partno='2100010' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.006785s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100010' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529099 LIMIT 4 [ RunTime:0.005189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529099 ORDER BY `minOrder` ASC [ RunTime:0.005118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529099 ORDER BY `unit` DESC [ RunTime:0.002242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529099 LIMIT 2 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529099 ORDER BY `minOrder` ASC [ RunTime:0.007872s ]
select * from pdf where partno='2100009' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.013167s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100009' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.011262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529095 LIMIT 4 [ RunTime:0.000780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529095 ORDER BY `minOrder` ASC [ RunTime:0.007154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529095 ORDER BY `unit` DESC [ RunTime:0.005593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529095 LIMIT 2 [ RunTime:0.003353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529095 ORDER BY `minOrder` ASC [ RunTime:0.011273s ]
select * from pdf where partno='2100149' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100149' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.022463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529094 LIMIT 4 [ RunTime:0.000742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529094 ORDER BY `minOrder` ASC [ RunTime:0.001082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529094 ORDER BY `unit` DESC [ RunTime:0.014214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529094 LIMIT 2 [ RunTime:0.007062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529094 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
select * from pdf where partno='2100242' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.013400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100242' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.026323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529093 LIMIT 4 [ RunTime:0.006423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529093 ORDER BY `minOrder` ASC [ RunTime:0.000881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529093 ORDER BY `unit` DESC [ RunTime:0.008654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529093 LIMIT 2 [ RunTime:0.048803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529093 ORDER BY `minOrder` ASC [ RunTime:0.014090s ]
select * from pdf where partno='2100241' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.008746s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100241' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529092 LIMIT 4 [ RunTime:0.003545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529092 ORDER BY `minOrder` ASC [ RunTime:0.014140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529092 ORDER BY `unit` DESC [ RunTime:0.010408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529092 LIMIT 2 [ RunTime:0.005324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529092 ORDER BY `minOrder` ASC [ RunTime:0.003509s ]
select * from pdf where partno='2100139' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001378s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100139' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529091 LIMIT 4 [ RunTime:0.015511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529091 ORDER BY `minOrder` ASC [ RunTime:0.005197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529091 ORDER BY `unit` DESC [ RunTime:0.000648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529091 LIMIT 2 [ RunTime:0.003137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529091 ORDER BY `minOrder` ASC [ RunTime:0.004556s ]
select * from pdf where partno='2100053' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100053' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529090 LIMIT 4 [ RunTime:0.009900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529090 ORDER BY `minOrder` ASC [ RunTime:0.002634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529090 ORDER BY `unit` DESC [ RunTime:0.005665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529090 LIMIT 2 [ RunTime:0.007548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529090 ORDER BY `minOrder` ASC [ RunTime:0.001093s ]
select * from pdf where partno='2100147' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009260s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100147' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529086 LIMIT 4 [ RunTime:0.002702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529086 ORDER BY `minOrder` ASC [ RunTime:0.006331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529086 ORDER BY `unit` DESC [ RunTime:0.005471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529086 LIMIT 2 [ RunTime:0.007897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529086 ORDER BY `minOrder` ASC [ RunTime:0.002173s ]
select * from pdf where partno='2100114' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.010962s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100114' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529085 LIMIT 4 [ RunTime:0.005451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529085 ORDER BY `minOrder` ASC [ RunTime:0.004334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529085 ORDER BY `unit` DESC [ RunTime:0.010621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529085 LIMIT 2 [ RunTime:0.010215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529085 ORDER BY `minOrder` ASC [ RunTime:0.002067s ]
select * from pdf where partno='2100113' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000879s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100113' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529084 LIMIT 4 [ RunTime:0.004712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529084 ORDER BY `minOrder` ASC [ RunTime:0.007282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529084 ORDER BY `unit` DESC [ RunTime:0.000371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529084 LIMIT 2 [ RunTime:0.002453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529084 ORDER BY `minOrder` ASC [ RunTime:0.001687s ]
select * from pdf where partno='2100130' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100130' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529083 LIMIT 4 [ RunTime:0.030686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529083 ORDER BY `minOrder` ASC [ RunTime:0.003028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529083 ORDER BY `unit` DESC [ RunTime:0.010545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529083 LIMIT 2 [ RunTime:0.000998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529083 ORDER BY `minOrder` ASC [ RunTime:0.006781s ]
select * from pdf where partno='2100074' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.008826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100074' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.021156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529082 LIMIT 4 [ RunTime:0.015742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529082 ORDER BY `minOrder` ASC [ RunTime:0.011855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529082 ORDER BY `unit` DESC [ RunTime:0.019900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529082 LIMIT 2 [ RunTime:0.007285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529082 ORDER BY `minOrder` ASC [ RunTime:0.007405s ]
select * from pdf where partno='2100069' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.020188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100069' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.011319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529081 LIMIT 4 [ RunTime:0.001534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529081 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529081 ORDER BY `unit` DESC [ RunTime:0.000427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529081 LIMIT 2 [ RunTime:0.001167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529081 ORDER BY `minOrder` ASC [ RunTime:0.005271s ]
select * from pdf where partno='2100117' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.035763s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100117' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.014731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529080 LIMIT 4 [ RunTime:0.001014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529080 ORDER BY `minOrder` ASC [ RunTime:0.000700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529080 ORDER BY `unit` DESC [ RunTime:0.008362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529080 LIMIT 2 [ RunTime:0.008416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529080 ORDER BY `minOrder` ASC [ RunTime:0.004948s ]
select * from pdf where partno='2100107' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001875s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100107' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.014739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529079 LIMIT 4 [ RunTime:0.002332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529079 ORDER BY `minOrder` ASC [ RunTime:0.000699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529079 ORDER BY `unit` DESC [ RunTime:0.003300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529079 LIMIT 2 [ RunTime:0.006454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529079 ORDER BY `minOrder` ASC [ RunTime:0.006926s ]
select * from pdf where partno='2100119' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.007739s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100119' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529078 LIMIT 4 [ RunTime:0.005108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529078 ORDER BY `minOrder` ASC [ RunTime:0.002101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529078 ORDER BY `unit` DESC [ RunTime:0.000761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529078 LIMIT 2 [ RunTime:0.006814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529078 ORDER BY `minOrder` ASC [ RunTime:0.001166s ]
select * from pdf where partno='2100132' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100132' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529077 LIMIT 4 [ RunTime:0.008395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529077 ORDER BY `minOrder` ASC [ RunTime:0.001852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529077 ORDER BY `unit` DESC [ RunTime:0.001057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529077 LIMIT 2 [ RunTime:0.000580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529077 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
select * from pdf where partno='2100135' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100135' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33529062 LIMIT 4 [ RunTime:0.009277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529062 ORDER BY `minOrder` ASC [ RunTime:0.012427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33529062 ORDER BY `unit` DESC [ RunTime:0.010558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33529062 LIMIT 2 [ RunTime:0.001734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33529062 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
select * from pdf where partno='2100008' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001136s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100008' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007993s ]
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.006615s ]