SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001572s ]
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` = '' , `host` = 'https://ic118.com/stock&keyword=210&page=164&srecordnum=7402' [ RunTime:0.010470s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001516s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004750s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002535s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.007790s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002459s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.016137s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001929s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.043269s ]
UPDATE `stock_search` SET `count` = 4406 , `updatetime` = '2026-06-08 18:25:20' WHERE `partno` = '210' [ RunTime:0.031075s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003174s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.001313s ]
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.006211s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.013346s ]
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.498450s ]
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 3260,20 [ RunTime:0.106382s ]
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 ('36761896','36761895','36761894','36761893','36761891','36761890','36761889','36761888','36761887','36761886','36761885','36761884','36761883','36761882','36761879','36761878','36761877','36761876','36761875','36761874') ORDER BY FIELD(s.id, 36761896,36761895,36761894,36761893,36761891,36761890,36761889,36761888,36761887,36761886,36761885,36761884,36761883,36761882,36761879,36761878,36761877,36761876,36761875,36761874) [ RunTime:0.003986s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761896 LIMIT 4 [ RunTime:0.010009s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761896 ORDER BY `minOrder` ASC [ RunTime:0.011128s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761896 ORDER BY `unit` DESC [ RunTime:0.012334s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761896 LIMIT 2 [ RunTime:0.008763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761896 ORDER BY `minOrder` ASC [ RunTime:0.027662s ]
select * from pdf where partno='210-506' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001757s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-506' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.004003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761895 LIMIT 4 [ RunTime:0.005844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761895 ORDER BY `minOrder` ASC [ RunTime:0.003089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761895 ORDER BY `unit` DESC [ RunTime:0.031138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761895 LIMIT 2 [ RunTime:0.018732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761895 ORDER BY `minOrder` ASC [ RunTime:0.002178s ]
select * from pdf where partno='210-115' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001636s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-115' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.002979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761894 LIMIT 4 [ RunTime:0.011180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761894 ORDER BY `minOrder` ASC [ RunTime:0.023850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761894 ORDER BY `unit` DESC [ RunTime:0.005962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761894 LIMIT 2 [ RunTime:0.009809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761894 ORDER BY `minOrder` ASC [ RunTime:0.010635s ]
select * from pdf where partno='210-113' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.014690s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-113' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.001383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761893 LIMIT 4 [ RunTime:0.020552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761893 ORDER BY `minOrder` ASC [ RunTime:0.027789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761893 ORDER BY `unit` DESC [ RunTime:0.007372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761893 LIMIT 2 [ RunTime:0.021518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761893 ORDER BY `minOrder` ASC [ RunTime:0.025417s ]
select * from pdf where partno='210-504' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.029116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-504' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.008185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761891 LIMIT 4 [ RunTime:0.013858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761891 ORDER BY `minOrder` ASC [ RunTime:0.016578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761891 ORDER BY `unit` DESC [ RunTime:0.046016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761891 LIMIT 2 [ RunTime:0.036925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761891 ORDER BY `minOrder` ASC [ RunTime:0.021681s ]
select * from pdf where partno='210-508' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.006650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-508' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.043560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761890 LIMIT 4 [ RunTime:0.035302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761890 ORDER BY `minOrder` ASC [ RunTime:0.018006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761890 ORDER BY `unit` DESC [ RunTime:0.020083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761890 LIMIT 2 [ RunTime:0.032910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761890 ORDER BY `minOrder` ASC [ RunTime:0.020941s ]
select * from pdf where partno='210-197' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.010074s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-197' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.001551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761889 LIMIT 4 [ RunTime:0.002864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761889 ORDER BY `minOrder` ASC [ RunTime:0.012951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761889 ORDER BY `unit` DESC [ RunTime:0.011267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761889 LIMIT 2 [ RunTime:0.015912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761889 ORDER BY `minOrder` ASC [ RunTime:0.000723s ]
select * from pdf where partno='210-295' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.009088s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-295' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761888 LIMIT 4 [ RunTime:0.007252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761888 ORDER BY `minOrder` ASC [ RunTime:0.017910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761888 ORDER BY `unit` DESC [ RunTime:0.008062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761888 LIMIT 2 [ RunTime:0.017060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761888 ORDER BY `minOrder` ASC [ RunTime:0.019948s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.007058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.008900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761887 LIMIT 4 [ RunTime:0.045590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761887 ORDER BY `minOrder` ASC [ RunTime:0.023929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761887 ORDER BY `unit` DESC [ RunTime:0.004200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761887 LIMIT 2 [ RunTime:0.025692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761887 ORDER BY `minOrder` ASC [ RunTime:0.018952s ]
select * from pdf where partno='210-115' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.009971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-115' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.018198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761886 LIMIT 4 [ RunTime:0.024197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761886 ORDER BY `minOrder` ASC [ RunTime:0.008314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761886 ORDER BY `unit` DESC [ RunTime:0.048218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761886 LIMIT 2 [ RunTime:0.013447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761886 ORDER BY `minOrder` ASC [ RunTime:0.009886s ]
select * from pdf where partno='210-505' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.005274s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-505' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.009867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761885 LIMIT 4 [ RunTime:0.025269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761885 ORDER BY `minOrder` ASC [ RunTime:0.018097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761885 ORDER BY `unit` DESC [ RunTime:0.014577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761885 LIMIT 2 [ RunTime:0.067243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761885 ORDER BY `minOrder` ASC [ RunTime:0.016294s ]
select * from pdf where partno='210-113' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.035319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-113' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.009135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761884 LIMIT 4 [ RunTime:0.050341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761884 ORDER BY `minOrder` ASC [ RunTime:0.102761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761884 ORDER BY `unit` DESC [ RunTime:0.055339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761884 LIMIT 2 [ RunTime:0.030130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761884 ORDER BY `minOrder` ASC [ RunTime:0.006695s ]
select * from pdf where partno='210-197' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.023305s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-197' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.046110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761883 LIMIT 4 [ RunTime:0.051286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761883 ORDER BY `minOrder` ASC [ RunTime:0.028551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761883 ORDER BY `unit` DESC [ RunTime:0.125558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761883 LIMIT 2 [ RunTime:0.093962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761883 ORDER BY `minOrder` ASC [ RunTime:0.025485s ]
select * from pdf where partno='210-504' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000892s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-504' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.027255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761882 LIMIT 4 [ RunTime:0.028602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761882 ORDER BY `minOrder` ASC [ RunTime:0.119249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761882 ORDER BY `unit` DESC [ RunTime:0.027947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761882 LIMIT 2 [ RunTime:0.150246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761882 ORDER BY `minOrder` ASC [ RunTime:0.043107s ]
select * from pdf where partno='210-196' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.014302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-196' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.021891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761879 LIMIT 4 [ RunTime:0.051000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761879 ORDER BY `minOrder` ASC [ RunTime:0.044200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761879 ORDER BY `unit` DESC [ RunTime:0.057936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761879 LIMIT 2 [ RunTime:0.009447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761879 ORDER BY `minOrder` ASC [ RunTime:0.015561s ]
select * from pdf where partno='210-506' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.008529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-506' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.015196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761878 LIMIT 4 [ RunTime:0.043212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761878 ORDER BY `minOrder` ASC [ RunTime:0.125863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761878 ORDER BY `unit` DESC [ RunTime:0.152418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761878 LIMIT 2 [ RunTime:0.075221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761878 ORDER BY `minOrder` ASC [ RunTime:0.016450s ]
select * from pdf where partno='210-295' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-295' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.034057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761877 LIMIT 4 [ RunTime:0.064407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761877 ORDER BY `minOrder` ASC [ RunTime:0.072954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761877 ORDER BY `unit` DESC [ RunTime:0.028325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761877 LIMIT 2 [ RunTime:0.051400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761877 ORDER BY `minOrder` ASC [ RunTime:0.030951s ]
select * from pdf where partno='210-115' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.041112s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-115' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.020726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761876 LIMIT 4 [ RunTime:0.049104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761876 ORDER BY `minOrder` ASC [ RunTime:0.061340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761876 ORDER BY `unit` DESC [ RunTime:0.016953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761876 LIMIT 2 [ RunTime:0.098877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761876 ORDER BY `minOrder` ASC [ RunTime:0.072705s ]
select * from pdf where partno='210-113' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001998s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-113' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.031281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761875 LIMIT 4 [ RunTime:0.021922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761875 ORDER BY `minOrder` ASC [ RunTime:0.104719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761875 ORDER BY `unit` DESC [ RunTime:0.072101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761875 LIMIT 2 [ RunTime:0.152535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761875 ORDER BY `minOrder` ASC [ RunTime:0.091812s ]
select * from pdf where partno='210-197' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.044043s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-197' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.022835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761874 LIMIT 4 [ RunTime:0.090088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761874 ORDER BY `minOrder` ASC [ RunTime:0.065547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761874 ORDER BY `unit` DESC [ RunTime:0.068991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761874 LIMIT 2 [ RunTime:0.063636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761874 ORDER BY `minOrder` ASC [ RunTime:0.031093s ]
select * from pdf where partno='210-505' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.021497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-505' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.019109s ]
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.020080s ]