SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002562s ]
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.004215s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.000999s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000472s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001200s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.000295s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000927s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000237s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001275s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000627s ]
UPDATE `stock_search` SET `count` = 4139 , `updatetime` = '2026-06-08 16:48:38' WHERE `partno` = '210' [ RunTime:0.009502s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001950s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000179s ]
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.005549s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002171s ]
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.000355s ]
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 3540,20 [ RunTime:0.039539s ]
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 ('36761436','36761435','36761431','36761429','36761427','36761426','36761425','36761422','36761421','36761418','36761417','36761416','36761407','36761406','36761405','36761403','36761402','36761399','36761396','36761395') ORDER BY FIELD(s.id, 36761436,36761435,36761431,36761429,36761427,36761426,36761425,36761422,36761421,36761418,36761417,36761416,36761407,36761406,36761405,36761403,36761402,36761399,36761396,36761395) [ RunTime:0.002321s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761436 LIMIT 4 [ RunTime:0.004046s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761436 ORDER BY `minOrder` ASC [ RunTime:0.006358s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761436 ORDER BY `unit` DESC [ RunTime:0.000352s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761436 LIMIT 2 [ RunTime:0.000332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761436 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
select * from pdf where partno='210-115' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.002541s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001155s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-115' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761435 LIMIT 4 [ RunTime:0.000205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761435 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761435 ORDER BY `unit` DESC [ RunTime:0.000230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761435 LIMIT 2 [ RunTime:0.000190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761435 ORDER BY `minOrder` ASC [ RunTime:0.000198s ]
select * from pdf where partno='210-506' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000308s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-506' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761431 LIMIT 4 [ RunTime:0.000286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761431 ORDER BY `minOrder` ASC [ RunTime:0.003668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761431 ORDER BY `unit` DESC [ RunTime:0.000256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761431 LIMIT 2 [ RunTime:0.000190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761431 ORDER BY `minOrder` ASC [ RunTime:0.000200s ]
select * from pdf where partno='210-508' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000300s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-508' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761429 LIMIT 4 [ RunTime:0.000195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761429 ORDER BY `minOrder` ASC [ RunTime:0.001296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761429 ORDER BY `unit` DESC [ RunTime:0.000214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761429 LIMIT 2 [ RunTime:0.000191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761429 ORDER BY `minOrder` ASC [ RunTime:0.000196s ]
select * from pdf where partno='210-112' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000279s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-112' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761427 LIMIT 4 [ RunTime:0.000186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761427 ORDER BY `minOrder` ASC [ RunTime:0.001114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761427 ORDER BY `unit` DESC [ RunTime:0.000223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761427 LIMIT 2 [ RunTime:0.000187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761427 ORDER BY `minOrder` ASC [ RunTime:0.000196s ]
select * from pdf where partno='210-504' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000277s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-504' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761426 LIMIT 4 [ RunTime:0.000198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761426 ORDER BY `minOrder` ASC [ RunTime:0.000629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761426 ORDER BY `unit` DESC [ RunTime:0.012110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761426 LIMIT 2 [ RunTime:0.000268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761426 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
select * from pdf where partno='210-113' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000305s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-113' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761425 LIMIT 4 [ RunTime:0.000199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761425 ORDER BY `minOrder` ASC [ RunTime:0.004642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761425 ORDER BY `unit` DESC [ RunTime:0.009607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761425 LIMIT 2 [ RunTime:0.015635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761425 ORDER BY `minOrder` ASC [ RunTime:0.000801s ]
select * from pdf where partno='210-111' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.015241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-111' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.013598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761422 LIMIT 4 [ RunTime:0.015680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761422 ORDER BY `minOrder` ASC [ RunTime:0.011611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761422 ORDER BY `unit` DESC [ RunTime:0.006180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761422 LIMIT 2 [ RunTime:0.008926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761422 ORDER BY `minOrder` ASC [ RunTime:0.022249s ]
select * from pdf where partno='210-197' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.015449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-197' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.006724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761421 LIMIT 4 [ RunTime:0.009968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761421 ORDER BY `minOrder` ASC [ RunTime:0.040602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761421 ORDER BY `unit` DESC [ RunTime:0.002944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761421 LIMIT 2 [ RunTime:0.003026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761421 ORDER BY `minOrder` ASC [ RunTime:0.007952s ]
select * from pdf where partno='210-112' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.006695s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-112' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.028383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761418 LIMIT 4 [ RunTime:0.013080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761418 ORDER BY `minOrder` ASC [ RunTime:0.059887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761418 ORDER BY `unit` DESC [ RunTime:0.051378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761418 LIMIT 2 [ RunTime:0.008213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761418 ORDER BY `minOrder` ASC [ RunTime:0.008330s ]
select * from pdf where partno='210-295' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.014909s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-295' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.014859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761417 LIMIT 4 [ RunTime:0.006170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761417 ORDER BY `minOrder` ASC [ RunTime:0.033721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761417 ORDER BY `unit` DESC [ RunTime:0.010965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761417 LIMIT 2 [ RunTime:0.028813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761417 ORDER BY `minOrder` ASC [ RunTime:0.003969s ]
select * from pdf where partno='210-505' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.028859s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-505' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.014250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761416 LIMIT 4 [ RunTime:0.008743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761416 ORDER BY `minOrder` ASC [ RunTime:0.022240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761416 ORDER BY `unit` DESC [ RunTime:0.005965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761416 LIMIT 2 [ RunTime:0.003448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761416 ORDER BY `minOrder` ASC [ RunTime:0.004958s ]
select * from pdf where partno='210-115' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.007944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-115' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.011820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761407 LIMIT 4 [ RunTime:0.016277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761407 ORDER BY `minOrder` ASC [ RunTime:0.023954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761407 ORDER BY `unit` DESC [ RunTime:0.002384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761407 LIMIT 2 [ RunTime:0.009972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761407 ORDER BY `minOrder` ASC [ RunTime:0.001741s ]
select * from pdf where partno='210-112' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.013253s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-112' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.044135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761406 LIMIT 4 [ RunTime:0.050117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761406 ORDER BY `minOrder` ASC [ RunTime:0.027239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761406 ORDER BY `unit` DESC [ RunTime:0.077634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761406 LIMIT 2 [ RunTime:0.029264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761406 ORDER BY `minOrder` ASC [ RunTime:0.015883s ]
select * from pdf where partno='210-111' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.025289s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-111' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.017136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761405 LIMIT 4 [ RunTime:0.026348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761405 ORDER BY `minOrder` ASC [ RunTime:0.071810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761405 ORDER BY `unit` DESC [ RunTime:0.061363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761405 LIMIT 2 [ RunTime:0.026366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761405 ORDER BY `minOrder` ASC [ RunTime:0.098022s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.082101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.026670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761403 LIMIT 4 [ RunTime:0.030881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761403 ORDER BY `minOrder` ASC [ RunTime:0.039637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761403 ORDER BY `unit` DESC [ RunTime:0.038137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761403 LIMIT 2 [ RunTime:0.014639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761403 ORDER BY `minOrder` ASC [ RunTime:0.029511s ]
select * from pdf where partno='210-113' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.005264s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-113' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761402 LIMIT 4 [ RunTime:0.001448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761402 ORDER BY `minOrder` ASC [ RunTime:0.070998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761402 ORDER BY `unit` DESC [ RunTime:0.008602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761402 LIMIT 2 [ RunTime:0.002458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761402 ORDER BY `minOrder` ASC [ RunTime:0.002764s ]
select * from pdf where partno='210-197' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.016287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-197' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.023095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761399 LIMIT 4 [ RunTime:0.004015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761399 ORDER BY `minOrder` ASC [ RunTime:0.035046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761399 ORDER BY `unit` DESC [ RunTime:0.026585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761399 LIMIT 2 [ RunTime:0.007247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761399 ORDER BY `minOrder` ASC [ RunTime:0.020234s ]
select * from pdf where partno='210-112' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.031162s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-112' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.004451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761396 LIMIT 4 [ RunTime:0.004252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761396 ORDER BY `minOrder` ASC [ RunTime:0.056937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761396 ORDER BY `unit` DESC [ RunTime:0.011061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761396 LIMIT 2 [ RunTime:0.114655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761396 ORDER BY `minOrder` ASC [ RunTime:0.000598s ]
select * from pdf where partno='210-504' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.034674s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-504' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.085975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761395 LIMIT 4 [ RunTime:0.024334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761395 ORDER BY `minOrder` ASC [ RunTime:0.031215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761395 ORDER BY `unit` DESC [ RunTime:0.015781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761395 LIMIT 2 [ RunTime:0.005747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761395 ORDER BY `minOrder` ASC [ RunTime:0.044437s ]
select * from pdf where partno='210-196' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.020435s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-196' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.013499s ]
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.022646s ]