SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001315s ]
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=167&srecordnum=7529' [ RunTime:0.007797s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001343s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.020839s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002320s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.002227s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001237s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003073s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002460s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.047150s ]
UPDATE `stock_search` SET `count` = 4481 , `updatetime` = '2026-06-08 18:30:17' WHERE `partno` = '210' [ RunTime:0.013007s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002609s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.009595s ]
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.009947s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.004190s ]
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:1.054854s ]
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 3320,20 [ RunTime:0.099041s ]
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 ('36761812','36761811','36761810','36761807','36761805','36761803','36761802','36761801','36761800','36761799','36761797','36761795','36761794','36761792','36761791','36761790','36761788','36761787','36761786','36761785') ORDER BY FIELD(s.id, 36761812,36761811,36761810,36761807,36761805,36761803,36761802,36761801,36761800,36761799,36761797,36761795,36761794,36761792,36761791,36761790,36761788,36761787,36761786,36761785) [ RunTime:0.007571s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761812 LIMIT 4 [ RunTime:0.010115s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761812 ORDER BY `minOrder` ASC [ RunTime:0.023133s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761812 ORDER BY `unit` DESC [ RunTime:0.003190s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761812 LIMIT 2 [ RunTime:0.011588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761812 ORDER BY `minOrder` ASC [ RunTime:0.000743s ]
select * from pdf where partno='210-111' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.003253s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001249s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-111' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.009426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761811 LIMIT 4 [ RunTime:0.001741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761811 ORDER BY `minOrder` ASC [ RunTime:0.021078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761811 ORDER BY `unit` DESC [ RunTime:0.005081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761811 LIMIT 2 [ RunTime:0.004120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761811 ORDER BY `minOrder` ASC [ RunTime:0.008300s ]
select * from pdf where partno='210-113' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.013058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-113' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.020075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761810 LIMIT 4 [ RunTime:0.019586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761810 ORDER BY `minOrder` ASC [ RunTime:0.026288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761810 ORDER BY `unit` DESC [ RunTime:0.065667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761810 LIMIT 2 [ RunTime:0.003719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761810 ORDER BY `minOrder` ASC [ RunTime:0.025798s ]
select * from pdf where partno='210-196' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.037866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-196' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.014271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761807 LIMIT 4 [ RunTime:0.038748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761807 ORDER BY `minOrder` ASC [ RunTime:0.074920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761807 ORDER BY `unit` DESC [ RunTime:0.140371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761807 LIMIT 2 [ RunTime:0.011163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761807 ORDER BY `minOrder` ASC [ RunTime:0.034742s ]
select * from pdf where partno='210-115' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.026882s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-115' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.023722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761805 LIMIT 4 [ RunTime:0.078504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761805 ORDER BY `minOrder` ASC [ RunTime:0.004079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761805 ORDER BY `unit` DESC [ RunTime:0.010113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761805 LIMIT 2 [ RunTime:0.014545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761805 ORDER BY `minOrder` ASC [ RunTime:0.044262s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.022098s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.066366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761803 LIMIT 4 [ RunTime:0.145537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761803 ORDER BY `minOrder` ASC [ RunTime:0.032195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761803 ORDER BY `unit` DESC [ RunTime:0.029186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761803 LIMIT 2 [ RunTime:0.044301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761803 ORDER BY `minOrder` ASC [ RunTime:0.031583s ]
select * from pdf where partno='210-506' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.044053s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-506' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.033157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761802 LIMIT 4 [ RunTime:0.029879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761802 ORDER BY `minOrder` ASC [ RunTime:0.022713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761802 ORDER BY `unit` DESC [ RunTime:0.080641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761802 LIMIT 2 [ RunTime:0.003239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761802 ORDER BY `minOrder` ASC [ RunTime:0.013649s ]
select * from pdf where partno='210-504' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.019948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-504' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.011733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761801 LIMIT 4 [ RunTime:0.012481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761801 ORDER BY `minOrder` ASC [ RunTime:0.042054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761801 ORDER BY `unit` DESC [ RunTime:0.005047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761801 LIMIT 2 [ RunTime:0.011591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761801 ORDER BY `minOrder` ASC [ RunTime:0.018692s ]
select * from pdf where partno='210-197' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.007403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-197' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.018074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761800 LIMIT 4 [ RunTime:0.009599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761800 ORDER BY `minOrder` ASC [ RunTime:0.019071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761800 ORDER BY `unit` DESC [ RunTime:0.017551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761800 LIMIT 2 [ RunTime:0.007343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761800 ORDER BY `minOrder` ASC [ RunTime:0.002265s ]
select * from pdf where partno='210-295' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.004160s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-295' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.022764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761799 LIMIT 4 [ RunTime:0.027723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761799 ORDER BY `minOrder` ASC [ RunTime:0.046423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761799 ORDER BY `unit` DESC [ RunTime:0.015136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761799 LIMIT 2 [ RunTime:0.005636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761799 ORDER BY `minOrder` ASC [ RunTime:0.003727s ]
select * from pdf where partno='210-111' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.016501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-111' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.039633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761797 LIMIT 4 [ RunTime:0.010314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761797 ORDER BY `minOrder` ASC [ RunTime:0.028187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761797 ORDER BY `unit` DESC [ RunTime:0.025867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761797 LIMIT 2 [ RunTime:0.004450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761797 ORDER BY `minOrder` ASC [ RunTime:0.012770s ]
select * from pdf where partno='210-505' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.009036s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-505' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.016740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761795 LIMIT 4 [ RunTime:0.029636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761795 ORDER BY `minOrder` ASC [ RunTime:0.067072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761795 ORDER BY `unit` DESC [ RunTime:0.007484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761795 LIMIT 2 [ RunTime:0.024096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761795 ORDER BY `minOrder` ASC [ RunTime:0.015002s ]
select * from pdf where partno='210-113' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.012822s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-113' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.017439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761794 LIMIT 4 [ RunTime:0.011937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761794 ORDER BY `minOrder` ASC [ RunTime:0.055862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761794 ORDER BY `unit` DESC [ RunTime:0.079216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761794 LIMIT 2 [ RunTime:0.015143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761794 ORDER BY `minOrder` ASC [ RunTime:0.042664s ]
select * from pdf where partno='210-115' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.014641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-115' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.029781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761792 LIMIT 4 [ RunTime:0.011346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761792 ORDER BY `minOrder` ASC [ RunTime:0.047709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761792 ORDER BY `unit` DESC [ RunTime:0.006074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761792 LIMIT 2 [ RunTime:0.025005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761792 ORDER BY `minOrder` ASC [ RunTime:0.020737s ]
select * from pdf where partno='210-508' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.025167s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-508' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.014452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761791 LIMIT 4 [ RunTime:0.018364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761791 ORDER BY `minOrder` ASC [ RunTime:0.029516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761791 ORDER BY `unit` DESC [ RunTime:0.043413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761791 LIMIT 2 [ RunTime:0.018502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761791 ORDER BY `minOrder` ASC [ RunTime:0.014934s ]
select * from pdf where partno='210-197' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.016679s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-197' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.028029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761790 LIMIT 4 [ RunTime:0.084328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761790 ORDER BY `minOrder` ASC [ RunTime:0.025971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761790 ORDER BY `unit` DESC [ RunTime:0.076399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761790 LIMIT 2 [ RunTime:0.023993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761790 ORDER BY `minOrder` ASC [ RunTime:0.027860s ]
select * from pdf where partno='210-111' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.022842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-111' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.031284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761788 LIMIT 4 [ RunTime:0.028058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761788 ORDER BY `minOrder` ASC [ RunTime:0.087521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761788 ORDER BY `unit` DESC [ RunTime:0.073128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761788 LIMIT 2 [ RunTime:0.054655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761788 ORDER BY `minOrder` ASC [ RunTime:0.144894s ]
select * from pdf where partno='210-504' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.070087s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-504' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.028391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761787 LIMIT 4 [ RunTime:0.010202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761787 ORDER BY `minOrder` ASC [ RunTime:0.050941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761787 ORDER BY `unit` DESC [ RunTime:0.050052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761787 LIMIT 2 [ RunTime:0.012848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761787 ORDER BY `minOrder` ASC [ RunTime:0.051419s ]
select * from pdf where partno='210-295' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.051362s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-295' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.023528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761786 LIMIT 4 [ RunTime:0.019404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761786 ORDER BY `minOrder` ASC [ RunTime:0.030721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761786 ORDER BY `unit` DESC [ RunTime:0.023118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761786 LIMIT 2 [ RunTime:0.000539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761786 ORDER BY `minOrder` ASC [ RunTime:0.006793s ]
select * from pdf where partno='210-196' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.048259s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-196' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.029810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36761785 LIMIT 4 [ RunTime:0.024352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761785 ORDER BY `minOrder` ASC [ RunTime:0.060806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36761785 ORDER BY `unit` DESC [ RunTime:0.061675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36761785 LIMIT 2 [ RunTime:0.043912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36761785 ORDER BY `minOrder` ASC [ RunTime:0.014996s ]
select * from pdf where partno='210-114' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.019861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-114' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.039498s ]
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.135111s ]