SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001261s ]
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.001619s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001519s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.006742s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003402s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.000356s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002637s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000450s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002386s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.001400s ]
UPDATE `stock_search` SET `count` = 2770 , `updatetime` = '2026-06-08 08:13:49' WHERE `partno` = '210' [ RunTime:0.001822s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000941s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000276s ]
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.000431s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002934s ]
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.185972s ]
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 2880,20 [ RunTime:0.112916s ]
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 ('36762190','36762189','36762187','36762186','36762184','36762183','36762180','36762179','36762178','36762177','36762173','36762172','36762171','36762170','36762168','36762167','36762166','36762165','36762164','36762163') ORDER BY FIELD(s.id, 36762190,36762189,36762187,36762186,36762184,36762183,36762180,36762179,36762178,36762177,36762173,36762172,36762171,36762170,36762168,36762167,36762166,36762165,36762164,36762163) [ RunTime:0.044193s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762190 LIMIT 4 [ RunTime:0.014116s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762190 ORDER BY `minOrder` ASC [ RunTime:0.014942s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.014946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762190 ORDER BY `unit` DESC [ RunTime:0.015264s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762190 LIMIT 2 [ RunTime:0.017537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762190 ORDER BY `minOrder` ASC [ RunTime:0.014306s ]
select * from pdf where partno='210-196' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.009514s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-196' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.007016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762189 LIMIT 4 [ RunTime:0.039959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762189 ORDER BY `minOrder` ASC [ RunTime:0.019237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762189 ORDER BY `unit` DESC [ RunTime:0.024702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762189 LIMIT 2 [ RunTime:0.001521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762189 ORDER BY `minOrder` ASC [ RunTime:0.015793s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.010347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.006825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762187 LIMIT 4 [ RunTime:0.038361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762187 ORDER BY `minOrder` ASC [ RunTime:0.061869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762187 ORDER BY `unit` DESC [ RunTime:0.011844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762187 LIMIT 2 [ RunTime:0.050380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762187 ORDER BY `minOrder` ASC [ RunTime:0.041271s ]
select * from pdf where partno='210-508' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.079818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-508' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.039628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762186 LIMIT 4 [ RunTime:0.050551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762186 ORDER BY `minOrder` ASC [ RunTime:0.025057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762186 ORDER BY `unit` DESC [ RunTime:0.111347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762186 LIMIT 2 [ RunTime:0.061674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762186 ORDER BY `minOrder` ASC [ RunTime:0.036533s ]
select * from pdf where partno='210-506' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.016106s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-506' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.023610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762184 LIMIT 4 [ RunTime:0.076722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762184 ORDER BY `minOrder` ASC [ RunTime:0.097673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762184 ORDER BY `unit` DESC [ RunTime:0.054976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762184 LIMIT 2 [ RunTime:0.069910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762184 ORDER BY `minOrder` ASC [ RunTime:0.040432s ]
select * from pdf where partno='210-196' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.035671s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-196' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762183 LIMIT 4 [ RunTime:0.018026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762183 ORDER BY `minOrder` ASC [ RunTime:0.050327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762183 ORDER BY `unit` DESC [ RunTime:0.016800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762183 LIMIT 2 [ RunTime:0.021089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762183 ORDER BY `minOrder` ASC [ RunTime:0.075212s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.042807s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.025848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762180 LIMIT 4 [ RunTime:0.048891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762180 ORDER BY `minOrder` ASC [ RunTime:0.021963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762180 ORDER BY `unit` DESC [ RunTime:0.173218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762180 LIMIT 2 [ RunTime:0.077987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762180 ORDER BY `minOrder` ASC [ RunTime:0.023053s ]
select * from pdf where partno='210-506' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.047436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-506' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.049404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762179 LIMIT 4 [ RunTime:0.070646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762179 ORDER BY `minOrder` ASC [ RunTime:0.095598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762179 ORDER BY `unit` DESC [ RunTime:0.138090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762179 LIMIT 2 [ RunTime:0.046319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762179 ORDER BY `minOrder` ASC [ RunTime:0.022910s ]
select * from pdf where partno='210-508' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.057412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-508' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.018462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762178 LIMIT 4 [ RunTime:0.076473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762178 ORDER BY `minOrder` ASC [ RunTime:0.053585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762178 ORDER BY `unit` DESC [ RunTime:0.097816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762178 LIMIT 2 [ RunTime:0.041259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762178 ORDER BY `minOrder` ASC [ RunTime:0.020766s ]
select * from pdf where partno='210-196' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.012580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-196' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.007047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762177 LIMIT 4 [ RunTime:0.035511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762177 ORDER BY `minOrder` ASC [ RunTime:0.087102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762177 ORDER BY `unit` DESC [ RunTime:0.026694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762177 LIMIT 2 [ RunTime:0.059442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762177 ORDER BY `minOrder` ASC [ RunTime:0.032594s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.071515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.013412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762173 LIMIT 4 [ RunTime:0.018621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762173 ORDER BY `minOrder` ASC [ RunTime:0.037008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762173 ORDER BY `unit` DESC [ RunTime:0.051036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762173 LIMIT 2 [ RunTime:0.037986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762173 ORDER BY `minOrder` ASC [ RunTime:0.045142s ]
select * from pdf where partno='210-506' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.012902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-506' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.040977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762172 LIMIT 4 [ RunTime:0.036005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762172 ORDER BY `minOrder` ASC [ RunTime:0.050690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762172 ORDER BY `unit` DESC [ RunTime:0.037107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762172 LIMIT 2 [ RunTime:0.028488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762172 ORDER BY `minOrder` ASC [ RunTime:0.030423s ]
select * from pdf where partno='210-508' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.005810s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-508' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.023761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762171 LIMIT 4 [ RunTime:0.059400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762171 ORDER BY `minOrder` ASC [ RunTime:0.028102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762171 ORDER BY `unit` DESC [ RunTime:0.033926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762171 LIMIT 2 [ RunTime:0.129583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762171 ORDER BY `minOrder` ASC [ RunTime:0.003133s ]
select * from pdf where partno='210-196' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.050082s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-196' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.012069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762170 LIMIT 4 [ RunTime:0.033008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762170 ORDER BY `minOrder` ASC [ RunTime:0.095426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762170 ORDER BY `unit` DESC [ RunTime:0.068692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762170 LIMIT 2 [ RunTime:0.062737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762170 ORDER BY `minOrder` ASC [ RunTime:0.018429s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.024325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.016462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762168 LIMIT 4 [ RunTime:0.028563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762168 ORDER BY `minOrder` ASC [ RunTime:0.087605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762168 ORDER BY `unit` DESC [ RunTime:0.050659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762168 LIMIT 2 [ RunTime:0.048820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762168 ORDER BY `minOrder` ASC [ RunTime:0.008633s ]
select * from pdf where partno='210-506' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.008932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-506' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.009473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762167 LIMIT 4 [ RunTime:0.069196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762167 ORDER BY `minOrder` ASC [ RunTime:0.107803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762167 ORDER BY `unit` DESC [ RunTime:0.008913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762167 LIMIT 2 [ RunTime:0.043652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762167 ORDER BY `minOrder` ASC [ RunTime:0.025449s ]
select * from pdf where partno='210-508' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.016575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-508' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.016665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762166 LIMIT 4 [ RunTime:0.021762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762166 ORDER BY `minOrder` ASC [ RunTime:0.072806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762166 ORDER BY `unit` DESC [ RunTime:0.052669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762166 LIMIT 2 [ RunTime:0.049293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762166 ORDER BY `minOrder` ASC [ RunTime:0.087195s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.035333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762165 LIMIT 4 [ RunTime:0.049995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762165 ORDER BY `minOrder` ASC [ RunTime:0.086269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762165 ORDER BY `unit` DESC [ RunTime:0.047568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762165 LIMIT 2 [ RunTime:0.031043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762165 ORDER BY `minOrder` ASC [ RunTime:0.008115s ]
select * from pdf where partno='210-196' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.010123s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-196' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.023134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762164 LIMIT 4 [ RunTime:0.054934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762164 ORDER BY `minOrder` ASC [ RunTime:0.081795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762164 ORDER BY `unit` DESC [ RunTime:0.033677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762164 LIMIT 2 [ RunTime:0.028607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762164 ORDER BY `minOrder` ASC [ RunTime:0.098138s ]
select * from pdf where partno='210-506' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.006951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-506' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.010303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36762163 LIMIT 4 [ RunTime:0.064842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762163 ORDER BY `minOrder` ASC [ RunTime:0.032609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36762163 ORDER BY `unit` DESC [ RunTime:0.047651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36762163 LIMIT 2 [ RunTime:0.037218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36762163 ORDER BY `minOrder` ASC [ RunTime:0.040270s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.006811s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.009523s ]
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.027398s ]