SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002802s ]
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.004326s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002267s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000676s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002908s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.003560s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001900s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000861s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001765s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.001435s ]
UPDATE `stock_search` SET `count` = 4159 , `updatetime` = '2026-06-08 16:50:18' WHERE `partno` = '210' [ RunTime:0.002005s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003767s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.005965s ]
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.000453s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001608s ]
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.148347s ]
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.098458s ]
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 ('36761480','36761478','36761475','36761472','36761471','36761470','36761469','36761463','36761461','36761460','36761457','36761454','36761452','36761449','36761446','36761444','36761443','36761442','36761441','36761437') ORDER BY FIELD(s.id, 36761480,36761478,36761475,36761472,36761471,36761470,36761469,36761463,36761461,36761460,36761457,36761454,36761452,36761449,36761446,36761444,36761443,36761442,36761441,36761437) [ RunTime:0.028023s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761480 LIMIT 4 [ RunTime:0.056102s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761480 ORDER BY `minOrder` ASC [ RunTime:0.031432s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761480 ORDER BY `unit` DESC [ RunTime:0.029745s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.018036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761480 LIMIT 2 [ RunTime:0.016949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761480 ORDER BY `minOrder` ASC [ RunTime:0.019559s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.024863s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.029800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761478 LIMIT 4 [ RunTime:0.067496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761478 ORDER BY `minOrder` ASC [ RunTime:0.100699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761478 ORDER BY `unit` DESC [ RunTime:0.082555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761478 LIMIT 2 [ RunTime:0.088531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761478 ORDER BY `minOrder` ASC [ RunTime:0.032122s ]
select * from pdf where partno='210-196' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.039647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-196' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.021554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761475 LIMIT 4 [ RunTime:0.078177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761475 ORDER BY `minOrder` ASC [ RunTime:0.193901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761475 ORDER BY `unit` DESC [ RunTime:0.091051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761475 LIMIT 2 [ RunTime:0.098538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761475 ORDER BY `minOrder` ASC [ RunTime:0.065904s ]
select * from pdf where partno='210-111' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.041032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-111' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.041459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761472 LIMIT 4 [ RunTime:0.047322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761472 ORDER BY `minOrder` ASC [ RunTime:0.066204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761472 ORDER BY `unit` DESC [ RunTime:0.068462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761472 LIMIT 2 [ RunTime:0.031665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761472 ORDER BY `minOrder` ASC [ RunTime:0.016259s ]
select * from pdf where partno='210-112' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.011649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-112' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.006328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761471 LIMIT 4 [ RunTime:0.027430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761471 ORDER BY `minOrder` ASC [ RunTime:0.044259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761471 ORDER BY `unit` DESC [ RunTime:0.044595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761471 LIMIT 2 [ RunTime:0.059602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761471 ORDER BY `minOrder` ASC [ RunTime:0.016825s ]
select * from pdf where partno='210-113' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.050943s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-113' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.012629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761470 LIMIT 4 [ RunTime:0.091156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761470 ORDER BY `minOrder` ASC [ RunTime:0.092419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761470 ORDER BY `unit` DESC [ RunTime:0.057305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761470 LIMIT 2 [ RunTime:0.098975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761470 ORDER BY `minOrder` ASC [ RunTime:0.060302s ]
select * from pdf where partno='210-505' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000672s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-505' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.013134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761469 LIMIT 4 [ RunTime:0.041130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761469 ORDER BY `minOrder` ASC [ RunTime:0.088754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761469 ORDER BY `unit` DESC [ RunTime:0.179317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761469 LIMIT 2 [ RunTime:0.065558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761469 ORDER BY `minOrder` ASC [ RunTime:0.091124s ]
select * from pdf where partno='210-295' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.021227s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-295' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.030046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761463 LIMIT 4 [ RunTime:0.045335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761463 ORDER BY `minOrder` ASC [ RunTime:0.092635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761463 ORDER BY `unit` DESC [ RunTime:0.130978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761463 LIMIT 2 [ RunTime:0.094488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761463 ORDER BY `minOrder` ASC [ RunTime:0.005563s ]
select * from pdf where partno='210-115' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.025003s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-115' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761461 LIMIT 4 [ RunTime:0.160913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761461 ORDER BY `minOrder` ASC [ RunTime:0.114182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761461 ORDER BY `unit` DESC [ RunTime:0.043422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761461 LIMIT 2 [ RunTime:0.022783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761461 ORDER BY `minOrder` ASC [ RunTime:0.078045s ]
select * from pdf where partno='210-197' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.040426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-197' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.059020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761460 LIMIT 4 [ RunTime:0.059112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761460 ORDER BY `minOrder` ASC [ RunTime:0.021811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761460 ORDER BY `unit` DESC [ RunTime:0.078028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761460 LIMIT 2 [ RunTime:0.052498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761460 ORDER BY `minOrder` ASC [ RunTime:0.070269s ]
select * from pdf where partno='210-112' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.051193s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-112' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.008606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761457 LIMIT 4 [ RunTime:0.056557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761457 ORDER BY `minOrder` ASC [ RunTime:0.057513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761457 ORDER BY `unit` DESC [ RunTime:0.084675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761457 LIMIT 2 [ RunTime:0.123021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761457 ORDER BY `minOrder` ASC [ RunTime:0.047985s ]
select * from pdf where partno='210-111' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.044722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-111' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.041942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761454 LIMIT 4 [ RunTime:0.075372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761454 ORDER BY `minOrder` ASC [ RunTime:0.122459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761454 ORDER BY `unit` DESC [ RunTime:0.157691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761454 LIMIT 2 [ RunTime:0.101131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761454 ORDER BY `minOrder` ASC [ RunTime:0.092895s ]
select * from pdf where partno='210-504' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.011550s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-504' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.008109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761452 LIMIT 4 [ RunTime:0.040867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761452 ORDER BY `minOrder` ASC [ RunTime:0.045387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761452 ORDER BY `unit` DESC [ RunTime:0.019904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761452 LIMIT 2 [ RunTime:0.071845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761452 ORDER BY `minOrder` ASC [ RunTime:0.045777s ]
select * from pdf where partno='210-112' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.036647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-112' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.013525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761449 LIMIT 4 [ RunTime:0.050980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761449 ORDER BY `minOrder` ASC [ RunTime:0.022696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761449 ORDER BY `unit` DESC [ RunTime:0.103651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761449 LIMIT 2 [ RunTime:0.088769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761449 ORDER BY `minOrder` ASC [ RunTime:0.023590s ]
select * from pdf where partno='210-113' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.013793s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-113' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761446 LIMIT 4 [ RunTime:0.106282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761446 ORDER BY `minOrder` ASC [ RunTime:0.029106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761446 ORDER BY `unit` DESC [ RunTime:0.056252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761446 LIMIT 2 [ RunTime:0.065176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761446 ORDER BY `minOrder` ASC [ RunTime:0.008206s ]
select * from pdf where partno='210-295' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.024840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-295' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.010256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761444 LIMIT 4 [ RunTime:0.044514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761444 ORDER BY `minOrder` ASC [ RunTime:0.048177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761444 ORDER BY `unit` DESC [ RunTime:0.050123s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761444 LIMIT 2 [ RunTime:0.069477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761444 ORDER BY `minOrder` ASC [ RunTime:0.035125s ]
select * from pdf where partno='210-505' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.007241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-505' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.010704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761443 LIMIT 4 [ RunTime:0.054573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761443 ORDER BY `minOrder` ASC [ RunTime:0.114226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761443 ORDER BY `unit` DESC [ RunTime:0.012611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761443 LIMIT 2 [ RunTime:0.016760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761443 ORDER BY `minOrder` ASC [ RunTime:0.034307s ]
select * from pdf where partno='210-112' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.018568s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-112' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.022977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761442 LIMIT 4 [ RunTime:0.045712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761442 ORDER BY `minOrder` ASC [ RunTime:0.069176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761442 ORDER BY `unit` DESC [ RunTime:0.023179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761442 LIMIT 2 [ RunTime:0.105731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761442 ORDER BY `minOrder` ASC [ RunTime:0.022807s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.044113s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.043281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761441 LIMIT 4 [ RunTime:0.094698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761441 ORDER BY `minOrder` ASC [ RunTime:0.089266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761441 ORDER BY `unit` DESC [ RunTime:0.159838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761441 LIMIT 2 [ RunTime:0.054667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761441 ORDER BY `minOrder` ASC [ RunTime:0.070607s ]
select * from pdf where partno='210-197' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.051214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-197' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.034248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761437 LIMIT 4 [ RunTime:0.111573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761437 ORDER BY `minOrder` ASC [ RunTime:0.049949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761437 ORDER BY `unit` DESC [ RunTime:0.222844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761437 LIMIT 2 [ RunTime:0.073123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761437 ORDER BY `minOrder` ASC [ RunTime:0.069427s ]
select * from pdf where partno='210-111' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.051163s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-111' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.052014s ]
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.019331s ]