SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001499s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.60' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.009939s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001419s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.007689s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001972s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.60' ) [ RunTime:0.015360s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001193s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000586s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002094s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.012519s ]
UPDATE `stock_search` SET `count` = 2496 , `updatetime` = '2026-06-08 05:08:58' WHERE `partno` = '210' [ RunTime:0.011476s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002699s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.004341s ]
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.008553s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001219s ]
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.004022s ]
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 3520,20 [ RunTime:0.116305s ]
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 ('36761058','36761052','36761051','36761049','36761045','36761043','36761042','36761041','36761039','36761032','36761026','36761023','36761015','36761013','36761011','36761008','36761007','36761003','36761000','36760999') ORDER BY FIELD(s.id, 36761058,36761052,36761051,36761049,36761045,36761043,36761042,36761041,36761039,36761032,36761026,36761023,36761015,36761013,36761011,36761008,36761007,36761003,36761000,36760999) [ RunTime:0.025504s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761058 LIMIT 4 [ RunTime:0.040689s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761058 ORDER BY `minOrder` ASC [ RunTime:0.039201s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761058 ORDER BY `unit` DESC [ RunTime:0.057789s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.037896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761058 LIMIT 2 [ RunTime:0.015757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761058 ORDER BY `minOrder` ASC [ RunTime:0.011185s ]
select * from pdf where partno='210-112' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.011649s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-112' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.024456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761052 LIMIT 4 [ RunTime:0.046872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761052 ORDER BY `minOrder` ASC [ RunTime:0.009658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761052 ORDER BY `unit` DESC [ RunTime:0.052979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761052 LIMIT 2 [ RunTime:0.008540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761052 ORDER BY `minOrder` ASC [ RunTime:0.021547s ]
select * from pdf where partno='210-197' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-197' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.011400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761051 LIMIT 4 [ RunTime:0.032373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761051 ORDER BY `minOrder` ASC [ RunTime:0.006518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761051 ORDER BY `unit` DESC [ RunTime:0.025255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761051 LIMIT 2 [ RunTime:0.009620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761051 ORDER BY `minOrder` ASC [ RunTime:0.017314s ]
select * from pdf where partno='210-504' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.005362s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-504' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.005578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761049 LIMIT 4 [ RunTime:0.014464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761049 ORDER BY `minOrder` ASC [ RunTime:0.026634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761049 ORDER BY `unit` DESC [ RunTime:0.039428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761049 LIMIT 2 [ RunTime:0.052159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761049 ORDER BY `minOrder` ASC [ RunTime:0.010164s ]
select * from pdf where partno='210-506' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000599s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-506' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.015692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761045 LIMIT 4 [ RunTime:0.026412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761045 ORDER BY `minOrder` ASC [ RunTime:0.036645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761045 ORDER BY `unit` DESC [ RunTime:0.030709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761045 LIMIT 2 [ RunTime:0.034230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761045 ORDER BY `minOrder` ASC [ RunTime:0.013126s ]
select * from pdf where partno='210-111' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.006647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-111' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.016319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761043 LIMIT 4 [ RunTime:0.044198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761043 ORDER BY `minOrder` ASC [ RunTime:0.036425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761043 ORDER BY `unit` DESC [ RunTime:0.074603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761043 LIMIT 2 [ RunTime:0.018609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761043 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
select * from pdf where partno='210-112' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001219s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-112' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.001873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761042 LIMIT 4 [ RunTime:0.013676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761042 ORDER BY `minOrder` ASC [ RunTime:0.022276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761042 ORDER BY `unit` DESC [ RunTime:0.007245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761042 LIMIT 2 [ RunTime:0.015851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761042 ORDER BY `minOrder` ASC [ RunTime:0.004207s ]
select * from pdf where partno='210-113' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.020162s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-113' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.013256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761041 LIMIT 4 [ RunTime:0.014516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761041 ORDER BY `minOrder` ASC [ RunTime:0.043065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761041 ORDER BY `unit` DESC [ RunTime:0.032680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761041 LIMIT 2 [ RunTime:0.004922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761041 ORDER BY `minOrder` ASC [ RunTime:0.029000s ]
select * from pdf where partno='210-295' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.011581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-295' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.050923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761039 LIMIT 4 [ RunTime:0.018953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761039 ORDER BY `minOrder` ASC [ RunTime:0.061337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761039 ORDER BY `unit` DESC [ RunTime:0.008785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761039 LIMIT 2 [ RunTime:0.024687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761039 ORDER BY `minOrder` ASC [ RunTime:0.012535s ]
select * from pdf where partno='210-115' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.011286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-115' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.019412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761032 LIMIT 4 [ RunTime:0.043393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761032 ORDER BY `minOrder` ASC [ RunTime:0.021810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761032 ORDER BY `unit` DESC [ RunTime:0.008715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761032 LIMIT 2 [ RunTime:0.014711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761032 ORDER BY `minOrder` ASC [ RunTime:0.017800s ]
select * from pdf where partno='210-112' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.007850s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-112' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.004292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761026 LIMIT 4 [ RunTime:0.022041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761026 ORDER BY `minOrder` ASC [ RunTime:0.024698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761026 ORDER BY `unit` DESC [ RunTime:0.019667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761026 LIMIT 2 [ RunTime:0.008936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761026 ORDER BY `minOrder` ASC [ RunTime:0.033738s ]
select * from pdf where partno='210-505' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.012302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-505' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.004321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761023 LIMIT 4 [ RunTime:0.008810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761023 ORDER BY `minOrder` ASC [ RunTime:0.015008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761023 ORDER BY `unit` DESC [ RunTime:0.005949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761023 LIMIT 2 [ RunTime:0.049223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761023 ORDER BY `minOrder` ASC [ RunTime:0.009669s ]
select * from pdf where partno='210-111' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.003269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-111' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.004754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761015 LIMIT 4 [ RunTime:0.005297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761015 ORDER BY `minOrder` ASC [ RunTime:0.030368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761015 ORDER BY `unit` DESC [ RunTime:0.010667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761015 LIMIT 2 [ RunTime:0.051313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761015 ORDER BY `minOrder` ASC [ RunTime:0.009586s ]
select * from pdf where partno='210-112' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.006598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-112' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.005977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761013 LIMIT 4 [ RunTime:0.005459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761013 ORDER BY `minOrder` ASC [ RunTime:0.025706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761013 ORDER BY `unit` DESC [ RunTime:0.026928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761013 LIMIT 2 [ RunTime:0.028464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761013 ORDER BY `minOrder` ASC [ RunTime:0.017552s ]
select * from pdf where partno='210-504' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.022752s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-504' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.017898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761011 LIMIT 4 [ RunTime:0.018935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761011 ORDER BY `minOrder` ASC [ RunTime:0.107926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761011 ORDER BY `unit` DESC [ RunTime:0.074070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761011 LIMIT 2 [ RunTime:0.072071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761011 ORDER BY `minOrder` ASC [ RunTime:0.010408s ]
select * from pdf where partno='210-113' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000612s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-113' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.008621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761008 LIMIT 4 [ RunTime:0.021624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761008 ORDER BY `minOrder` ASC [ RunTime:0.072739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761008 ORDER BY `unit` DESC [ RunTime:0.031617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761008 LIMIT 2 [ RunTime:0.037825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761008 ORDER BY `minOrder` ASC [ RunTime:0.040534s ]
select * from pdf where partno='210-295' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.002146s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-295' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.010661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761007 LIMIT 4 [ RunTime:0.054393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761007 ORDER BY `minOrder` ASC [ RunTime:0.030412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761007 ORDER BY `unit` DESC [ RunTime:0.018301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761007 LIMIT 2 [ RunTime:0.035714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761007 ORDER BY `minOrder` ASC [ RunTime:0.024851s ]
select * from pdf where partno='210-115' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.010498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-115' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.003251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761003 LIMIT 4 [ RunTime:0.012196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761003 ORDER BY `minOrder` ASC [ RunTime:0.009119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761003 ORDER BY `unit` DESC [ RunTime:0.023144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761003 LIMIT 2 [ RunTime:0.020534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761003 ORDER BY `minOrder` ASC [ RunTime:0.000543s ]
select * from pdf where partno='210-112' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.005840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-112' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.012892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761000 LIMIT 4 [ RunTime:0.011655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761000 ORDER BY `minOrder` ASC [ RunTime:0.009743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761000 ORDER BY `unit` DESC [ RunTime:0.017186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761000 LIMIT 2 [ RunTime:0.011672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761000 ORDER BY `minOrder` ASC [ RunTime:0.003367s ]
select * from pdf where partno='210-111' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.004881s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-111' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.003556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36760999 LIMIT 4 [ RunTime:0.004555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760999 ORDER BY `minOrder` ASC [ RunTime:0.011642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36760999 ORDER BY `unit` DESC [ RunTime:0.000794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36760999 LIMIT 2 [ RunTime:0.006740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760999 ORDER BY `minOrder` ASC [ RunTime:0.003435s ]
select * from pdf where partno='210-197' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.002018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-197' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.003201s ]
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.002172s ]