SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001576s ]
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.006918s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.005155s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002300s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001695s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.005711s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002954s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004377s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001853s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.001716s ]
UPDATE `stock_search` SET `count` = 3026 , `updatetime` = '2026-06-08 12:09:28' WHERE `partno` = '210' [ RunTime:0.007265s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.011734s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.014248s ]
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.002797s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001564s ]
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.232045s ]
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 2940,20 [ RunTime:0.138465s ]
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 ('36762228','36762227','36762226','36762225','36762224','36762223','36762221','36762219','36762218','36762217','36762215','36762214','36762213','36762212','36762211','36762208','36762207','36762206','36762204','36762202') ORDER BY FIELD(s.id, 36762228,36762227,36762226,36762225,36762224,36762223,36762221,36762219,36762218,36762217,36762215,36762214,36762213,36762212,36762211,36762208,36762207,36762206,36762204,36762202) [ RunTime:0.126104s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.031450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762228 LIMIT 4 [ RunTime:0.008902s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762228 ORDER BY `minOrder` ASC [ RunTime:0.040853s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762228 ORDER BY `unit` DESC [ RunTime:0.038818s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762228 LIMIT 2 [ RunTime:0.002601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762228 ORDER BY `minOrder` ASC [ RunTime:0.045847s ]
select * from pdf where partno='210-196' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.014948s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003786s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-196' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.015676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762227 LIMIT 4 [ RunTime:0.027678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762227 ORDER BY `minOrder` ASC [ RunTime:0.031580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762227 ORDER BY `unit` DESC [ RunTime:0.042297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762227 LIMIT 2 [ RunTime:0.003229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762227 ORDER BY `minOrder` ASC [ RunTime:0.009854s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.008355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.022364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762226 LIMIT 4 [ RunTime:0.026096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762226 ORDER BY `minOrder` ASC [ RunTime:0.041915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762226 ORDER BY `unit` DESC [ RunTime:0.014423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762226 LIMIT 2 [ RunTime:0.008549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762226 ORDER BY `minOrder` ASC [ RunTime:0.011940s ]
select * from pdf where partno='210-506' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-506' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.010624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762225 LIMIT 4 [ RunTime:0.014949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762225 ORDER BY `minOrder` ASC [ RunTime:0.016575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762225 ORDER BY `unit` DESC [ RunTime:0.021820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762225 LIMIT 2 [ RunTime:0.004075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762225 ORDER BY `minOrder` ASC [ RunTime:0.002560s ]
select * from pdf where partno='210-508' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.018425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-508' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.011057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762224 LIMIT 4 [ RunTime:0.015888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762224 ORDER BY `minOrder` ASC [ RunTime:0.042697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762224 ORDER BY `unit` DESC [ RunTime:0.077551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762224 LIMIT 2 [ RunTime:0.013261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762224 ORDER BY `minOrder` ASC [ RunTime:0.011244s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.041999s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.010044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762223 LIMIT 4 [ RunTime:0.045343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762223 ORDER BY `minOrder` ASC [ RunTime:0.040284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762223 ORDER BY `unit` DESC [ RunTime:0.040388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762223 LIMIT 2 [ RunTime:0.045157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762223 ORDER BY `minOrder` ASC [ RunTime:0.037184s ]
select * from pdf where partno='210-196' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.026703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-196' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.011112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762221 LIMIT 4 [ RunTime:0.024166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762221 ORDER BY `minOrder` ASC [ RunTime:0.054391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762221 ORDER BY `unit` DESC [ RunTime:0.008559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762221 LIMIT 2 [ RunTime:0.030992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762221 ORDER BY `minOrder` ASC [ RunTime:0.015218s ]
select * from pdf where partno='210-506' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-506' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.017403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762219 LIMIT 4 [ RunTime:0.014467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762219 ORDER BY `minOrder` ASC [ RunTime:0.042474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762219 ORDER BY `unit` DESC [ RunTime:0.143152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762219 LIMIT 2 [ RunTime:0.012165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762219 ORDER BY `minOrder` ASC [ RunTime:0.021181s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.034736s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762218 LIMIT 4 [ RunTime:0.019450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762218 ORDER BY `minOrder` ASC [ RunTime:0.043076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762218 ORDER BY `unit` DESC [ RunTime:0.022609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762218 LIMIT 2 [ RunTime:0.041671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762218 ORDER BY `minOrder` ASC [ RunTime:0.026817s ]
select * from pdf where partno='210-508' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.017946s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-508' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.013702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762217 LIMIT 4 [ RunTime:0.025337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762217 ORDER BY `minOrder` ASC [ RunTime:0.073893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762217 ORDER BY `unit` DESC [ RunTime:0.028470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762217 LIMIT 2 [ RunTime:0.016327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762217 ORDER BY `minOrder` ASC [ RunTime:0.085425s ]
select * from pdf where partno='210-196' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.011194s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-196' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.037959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762215 LIMIT 4 [ RunTime:0.048356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762215 ORDER BY `minOrder` ASC [ RunTime:0.046245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762215 ORDER BY `unit` DESC [ RunTime:0.027794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762215 LIMIT 2 [ RunTime:0.025274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762215 ORDER BY `minOrder` ASC [ RunTime:0.016890s ]
select * from pdf where partno='210-506' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.051915s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-506' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.051330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762214 LIMIT 4 [ RunTime:0.050463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762214 ORDER BY `minOrder` ASC [ RunTime:0.066053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762214 ORDER BY `unit` DESC [ RunTime:0.028163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762214 LIMIT 2 [ RunTime:0.059567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762214 ORDER BY `minOrder` ASC [ RunTime:0.060336s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.043922s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.050967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762213 LIMIT 4 [ RunTime:0.021844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762213 ORDER BY `minOrder` ASC [ RunTime:0.084215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762213 ORDER BY `unit` DESC [ RunTime:0.050745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762213 LIMIT 2 [ RunTime:0.027880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762213 ORDER BY `minOrder` ASC [ RunTime:0.048308s ]
select * from pdf where partno='210-196' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.079722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-196' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.050197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762212 LIMIT 4 [ RunTime:0.004567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762212 ORDER BY `minOrder` ASC [ RunTime:0.098902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762212 ORDER BY `unit` DESC [ RunTime:0.025611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762212 LIMIT 2 [ RunTime:0.059465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762212 ORDER BY `minOrder` ASC [ RunTime:0.050712s ]
select * from pdf where partno='210-508' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.031925s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-508' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.009311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762211 LIMIT 4 [ RunTime:0.000391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762211 ORDER BY `minOrder` ASC [ RunTime:0.136833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762211 ORDER BY `unit` DESC [ RunTime:0.035559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762211 LIMIT 2 [ RunTime:0.025296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762211 ORDER BY `minOrder` ASC [ RunTime:0.045189s ]
select * from pdf where partno='210-506' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.003074s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-506' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.044893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762208 LIMIT 4 [ RunTime:0.032056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762208 ORDER BY `minOrder` ASC [ RunTime:0.067651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762208 ORDER BY `unit` DESC [ RunTime:0.021836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762208 LIMIT 2 [ RunTime:0.079335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762208 ORDER BY `minOrder` ASC [ RunTime:0.127449s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.019645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.018114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762207 LIMIT 4 [ RunTime:0.050594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762207 ORDER BY `minOrder` ASC [ RunTime:0.084533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762207 ORDER BY `unit` DESC [ RunTime:0.038241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762207 LIMIT 2 [ RunTime:0.050569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762207 ORDER BY `minOrder` ASC [ RunTime:0.045794s ]
select * from pdf where partno='210-196' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.022678s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-196' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.050588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762206 LIMIT 4 [ RunTime:0.000301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762206 ORDER BY `minOrder` ASC [ RunTime:0.083849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762206 ORDER BY `unit` DESC [ RunTime:0.096854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762206 LIMIT 2 [ RunTime:0.050631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762206 ORDER BY `minOrder` ASC [ RunTime:0.018590s ]
select * from pdf where partno='210-508' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.030748s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-508' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.050120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762204 LIMIT 4 [ RunTime:0.056902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762204 ORDER BY `minOrder` ASC [ RunTime:0.097066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762204 ORDER BY `unit` DESC [ RunTime:0.067097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762204 LIMIT 2 [ RunTime:0.050756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762204 ORDER BY `minOrder` ASC [ RunTime:0.022477s ]
select * from pdf where partno='210-506' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.035152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-506' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.030756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762202 LIMIT 4 [ RunTime:0.012532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762202 ORDER BY `minOrder` ASC [ RunTime:0.044967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762202 ORDER BY `unit` DESC [ RunTime:0.050792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762202 LIMIT 2 [ RunTime:0.034199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762202 ORDER BY `minOrder` ASC [ RunTime:0.019467s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.044916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000603s ]
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.240427s ]