SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001120s ]
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.027278s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001319s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.076187s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001353s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.047897s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002097s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.033069s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001567s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.032249s ]
UPDATE `stock_search` SET `count` = 3087 , `updatetime` = '2026-06-08 12:29:03' WHERE `partno` = '210' [ RunTime:0.031814s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.012135s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.007094s ]
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.028618s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001430s ]
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.140782s ]
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 3340,20 [ RunTime:0.104622s ]
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 ('36761740','36761739','36761738','36761737','36761736','36761735','36761734','36761733','36761732','36761731','36761727','36761726','36761725','36761723','36761722','36761721','36761719','36761718','36761717','36761716') ORDER BY FIELD(s.id, 36761740,36761739,36761738,36761737,36761736,36761735,36761734,36761733,36761732,36761731,36761727,36761726,36761725,36761723,36761722,36761721,36761719,36761718,36761717,36761716) [ RunTime:0.025303s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761740 LIMIT 4 [ RunTime:0.032091s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761740 ORDER BY `minOrder` ASC [ RunTime:0.033247s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761740 ORDER BY `unit` DESC [ RunTime:0.084829s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761740 LIMIT 2 [ RunTime:0.019004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761740 ORDER BY `minOrder` ASC [ RunTime:0.021793s ]
select * from pdf where partno='210-295' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.023053s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-295' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.024601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761739 LIMIT 4 [ RunTime:0.015461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761739 ORDER BY `minOrder` ASC [ RunTime:0.035508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761739 ORDER BY `unit` DESC [ RunTime:0.066422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761739 LIMIT 2 [ RunTime:0.054828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761739 ORDER BY `minOrder` ASC [ RunTime:0.033888s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.024646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761738 LIMIT 4 [ RunTime:0.019973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761738 ORDER BY `minOrder` ASC [ RunTime:0.032388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761738 ORDER BY `unit` DESC [ RunTime:0.017846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761738 LIMIT 2 [ RunTime:0.030613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761738 ORDER BY `minOrder` ASC [ RunTime:0.002301s ]
select * from pdf where partno='210-504' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.008377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-504' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.005280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761737 LIMIT 4 [ RunTime:0.025215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761737 ORDER BY `minOrder` ASC [ RunTime:0.018756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761737 ORDER BY `unit` DESC [ RunTime:0.025230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761737 LIMIT 2 [ RunTime:0.032287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761737 ORDER BY `minOrder` ASC [ RunTime:0.007657s ]
select * from pdf where partno='210-508' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.012424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-508' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.003789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761736 LIMIT 4 [ RunTime:0.036329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761736 ORDER BY `minOrder` ASC [ RunTime:0.012314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761736 ORDER BY `unit` DESC [ RunTime:0.015720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761736 LIMIT 2 [ RunTime:0.011484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761736 ORDER BY `minOrder` ASC [ RunTime:0.009099s ]
select * from pdf where partno='210-196' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.015189s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-196' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.002204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761735 LIMIT 4 [ RunTime:0.006633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761735 ORDER BY `minOrder` ASC [ RunTime:0.001745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761735 ORDER BY `unit` DESC [ RunTime:0.005701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761735 LIMIT 2 [ RunTime:0.012934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761735 ORDER BY `minOrder` ASC [ RunTime:0.002171s ]
select * from pdf where partno='210-111' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.003262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-111' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.036088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761734 LIMIT 4 [ RunTime:0.049860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761734 ORDER BY `minOrder` ASC [ RunTime:0.060460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761734 ORDER BY `unit` DESC [ RunTime:0.064002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761734 LIMIT 2 [ RunTime:0.130689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761734 ORDER BY `minOrder` ASC [ RunTime:0.003871s ]
select * from pdf where partno='210-115' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.002807s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-115' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761733 LIMIT 4 [ RunTime:0.014159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761733 ORDER BY `minOrder` ASC [ RunTime:0.010370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761733 ORDER BY `unit` DESC [ RunTime:0.022581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761733 LIMIT 2 [ RunTime:0.008308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761733 ORDER BY `minOrder` ASC [ RunTime:0.012886s ]
select * from pdf where partno='210-505' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.004765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-505' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.002597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761732 LIMIT 4 [ RunTime:0.016874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761732 ORDER BY `minOrder` ASC [ RunTime:0.009260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761732 ORDER BY `unit` DESC [ RunTime:0.011386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761732 LIMIT 2 [ RunTime:0.022029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761732 ORDER BY `minOrder` ASC [ RunTime:0.017999s ]
select * from pdf where partno='210-197' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.016318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-197' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.004788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761731 LIMIT 4 [ RunTime:0.047856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761731 ORDER BY `minOrder` ASC [ RunTime:0.011429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761731 ORDER BY `unit` DESC [ RunTime:0.026523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761731 LIMIT 2 [ RunTime:0.011089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761731 ORDER BY `minOrder` ASC [ RunTime:0.016011s ]
select * from pdf where partno='210-113' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.003223s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-113' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.019046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761727 LIMIT 4 [ RunTime:0.000796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761727 ORDER BY `minOrder` ASC [ RunTime:0.032169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761727 ORDER BY `unit` DESC [ RunTime:0.016183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761727 LIMIT 2 [ RunTime:0.029270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761727 ORDER BY `minOrder` ASC [ RunTime:0.022701s ]
select * from pdf where partno='210-506' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.009358s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-506' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.008192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761726 LIMIT 4 [ RunTime:0.016961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761726 ORDER BY `minOrder` ASC [ RunTime:0.033964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761726 ORDER BY `unit` DESC [ RunTime:0.022459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761726 LIMIT 2 [ RunTime:0.026896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761726 ORDER BY `minOrder` ASC [ RunTime:0.039750s ]
select * from pdf where partno='210-111' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.018143s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-111' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.007221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761725 LIMIT 4 [ RunTime:0.029583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761725 ORDER BY `minOrder` ASC [ RunTime:0.008689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761725 ORDER BY `unit` DESC [ RunTime:0.022948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761725 LIMIT 2 [ RunTime:0.022084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761725 ORDER BY `minOrder` ASC [ RunTime:0.014703s ]
select * from pdf where partno='210-295' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.043757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-295' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.009964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761723 LIMIT 4 [ RunTime:0.032887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761723 ORDER BY `minOrder` ASC [ RunTime:0.024675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761723 ORDER BY `unit` DESC [ RunTime:0.016078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761723 LIMIT 2 [ RunTime:0.025308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761723 ORDER BY `minOrder` ASC [ RunTime:0.016525s ]
select * from pdf where partno='210-115' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.020188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-115' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.010714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761722 LIMIT 4 [ RunTime:0.043790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761722 ORDER BY `minOrder` ASC [ RunTime:0.019494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761722 ORDER BY `unit` DESC [ RunTime:0.036324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761722 LIMIT 2 [ RunTime:0.024917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761722 ORDER BY `minOrder` ASC [ RunTime:0.042006s ]
select * from pdf where partno='210-504' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.025158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-504' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.013618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761721 LIMIT 4 [ RunTime:0.017671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761721 ORDER BY `minOrder` ASC [ RunTime:0.017749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761721 ORDER BY `unit` DESC [ RunTime:0.062639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761721 LIMIT 2 [ RunTime:0.074251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761721 ORDER BY `minOrder` ASC [ RunTime:0.040695s ]
select * from pdf where partno='210-505' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.004079s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-505' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.001243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761719 LIMIT 4 [ RunTime:0.000799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761719 ORDER BY `minOrder` ASC [ RunTime:0.000835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761719 ORDER BY `unit` DESC [ RunTime:0.002539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761719 LIMIT 2 [ RunTime:0.003248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761719 ORDER BY `minOrder` ASC [ RunTime:0.002522s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.002895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761718 LIMIT 4 [ RunTime:0.001605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761718 ORDER BY `minOrder` ASC [ RunTime:0.001711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761718 ORDER BY `unit` DESC [ RunTime:0.001325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761718 LIMIT 2 [ RunTime:0.003905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761718 ORDER BY `minOrder` ASC [ RunTime:0.001875s ]
select * from pdf where partno='210-197' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-197' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.003988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761717 LIMIT 4 [ RunTime:0.003012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761717 ORDER BY `minOrder` ASC [ RunTime:0.000790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761717 ORDER BY `unit` DESC [ RunTime:0.000905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761717 LIMIT 2 [ RunTime:0.001191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761717 ORDER BY `minOrder` ASC [ RunTime:0.000722s ]
select * from pdf where partno='210-113' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-113' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.001707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761716 LIMIT 4 [ RunTime:0.001668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761716 ORDER BY `minOrder` ASC [ RunTime:0.001934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761716 ORDER BY `unit` DESC [ RunTime:0.001600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761716 LIMIT 2 [ RunTime:0.005664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761716 ORDER BY `minOrder` ASC [ RunTime:0.003559s ]
select * from pdf where partno='210-111' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.002589s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-111' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000939s ]
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.089216s ]