SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001544s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.220' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.128039s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001710s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001343s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001172s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.002622s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001857s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002733s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001526s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.019083s ]
UPDATE `stock_search` SET `count` = 1986 , `updatetime` = '2026-06-06 21:07:55' WHERE `partno` = '210' [ RunTime:0.021798s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.006091s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.006801s ]
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.013803s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.004218s ]
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.013551s ]
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 2480,20 [ RunTime:0.081298s ]
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 ('33854839','33854838','33854837','33854836','33854835','33854834','33854833','33854832','33854831','33854830','33854829','33854828','33854827','33854826','33854825','33854824','33854823','33854822','33854821','33854820') ORDER BY FIELD(s.id, 33854839,33854838,33854837,33854836,33854835,33854834,33854833,33854832,33854831,33854830,33854829,33854828,33854827,33854826,33854825,33854824,33854823,33854822,33854821,33854820) [ RunTime:0.105024s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854839 LIMIT 4 [ RunTime:0.035977s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854839 ORDER BY `minOrder` ASC [ RunTime:0.040577s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854839 ORDER BY `unit` DESC [ RunTime:0.053313s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854839 LIMIT 2 [ RunTime:0.057558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854839 ORDER BY `minOrder` ASC [ RunTime:0.032954s ]
select * from pdf where partno='210-333/1200-079' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.017231s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/1200-079' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.026976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854838 LIMIT 4 [ RunTime:0.055021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854838 ORDER BY `minOrder` ASC [ RunTime:0.013875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854838 ORDER BY `unit` DESC [ RunTime:0.026613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854838 LIMIT 2 [ RunTime:0.011919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854838 ORDER BY `minOrder` ASC [ RunTime:0.016657s ]
select * from pdf where partno='210-333/800-079' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.023649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/800-079' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.040171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854837 LIMIT 4 [ RunTime:0.006916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854837 ORDER BY `minOrder` ASC [ RunTime:0.005100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854837 ORDER BY `unit` DESC [ RunTime:0.006942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854837 LIMIT 2 [ RunTime:0.007646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854837 ORDER BY `minOrder` ASC [ RunTime:0.003747s ]
select * from pdf where partno='210-333/500-076' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000839s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/500-076' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.003381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854836 LIMIT 4 [ RunTime:0.011658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854836 ORDER BY `minOrder` ASC [ RunTime:0.026063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854836 ORDER BY `unit` DESC [ RunTime:0.028638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854836 LIMIT 2 [ RunTime:0.019764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854836 ORDER BY `minOrder` ASC [ RunTime:0.014291s ]
select * from pdf where partno='210-332/700-103' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.017624s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/700-103' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.013302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854835 LIMIT 4 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854835 ORDER BY `minOrder` ASC [ RunTime:0.006312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854835 ORDER BY `unit` DESC [ RunTime:0.004912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854835 LIMIT 2 [ RunTime:0.000727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854835 ORDER BY `minOrder` ASC [ RunTime:0.001078s ]
select * from pdf where partno='210-332/350-202' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.013306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/350-202' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.009665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854834 LIMIT 4 [ RunTime:0.002584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854834 ORDER BY `minOrder` ASC [ RunTime:0.000928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854834 ORDER BY `unit` DESC [ RunTime:0.024743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854834 LIMIT 2 [ RunTime:0.010566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854834 ORDER BY `minOrder` ASC [ RunTime:0.011332s ]
select * from pdf where partno='210-332/508-001' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.012247s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/508-001' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.007847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854833 LIMIT 4 [ RunTime:0.009560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854833 ORDER BY `minOrder` ASC [ RunTime:0.013294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854833 ORDER BY `unit` DESC [ RunTime:0.014049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854833 LIMIT 2 [ RunTime:0.003754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854833 ORDER BY `minOrder` ASC [ RunTime:0.001056s ]
select * from pdf where partno='210-332/400-202' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.019066s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/400-202' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.003887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854832 LIMIT 4 [ RunTime:0.014717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854832 ORDER BY `minOrder` ASC [ RunTime:0.006649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854832 ORDER BY `unit` DESC [ RunTime:0.005153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854832 LIMIT 2 [ RunTime:0.005152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854832 ORDER BY `minOrder` ASC [ RunTime:0.003670s ]
select * from pdf where partno='210-331/250-204' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.002971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-331/250-204' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.002505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854831 LIMIT 4 [ RunTime:0.010415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854831 ORDER BY `minOrder` ASC [ RunTime:0.031905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854831 ORDER BY `unit` DESC [ RunTime:0.008606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854831 LIMIT 2 [ RunTime:0.011235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854831 ORDER BY `minOrder` ASC [ RunTime:0.005919s ]
select * from pdf where partno='210-333/500-075' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.010435s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/500-075' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.012362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854830 LIMIT 4 [ RunTime:0.001042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854830 ORDER BY `minOrder` ASC [ RunTime:0.002837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854830 ORDER BY `unit` DESC [ RunTime:0.006390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854830 LIMIT 2 [ RunTime:0.003585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854830 ORDER BY `minOrder` ASC [ RunTime:0.014197s ]
select * from pdf where partno='210-333/500-005' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.006606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/500-005' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.008497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854829 LIMIT 4 [ RunTime:0.007169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854829 ORDER BY `minOrder` ASC [ RunTime:0.004104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854829 ORDER BY `unit` DESC [ RunTime:0.008249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854829 LIMIT 2 [ RunTime:0.013380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854829 ORDER BY `minOrder` ASC [ RunTime:0.000861s ]
select * from pdf where partno='210-332/700-102' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/700-102' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.002479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854828 LIMIT 4 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854828 ORDER BY `minOrder` ASC [ RunTime:0.004081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854828 ORDER BY `unit` DESC [ RunTime:0.011410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854828 LIMIT 2 [ RunTime:0.013665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854828 ORDER BY `minOrder` ASC [ RunTime:0.002548s ]
select * from pdf where partno='210-333/1000-208' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001393s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/1000-208' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.009364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854827 LIMIT 4 [ RunTime:0.008409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854827 ORDER BY `minOrder` ASC [ RunTime:0.002508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854827 ORDER BY `unit` DESC [ RunTime:0.000719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854827 LIMIT 2 [ RunTime:0.014831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854827 ORDER BY `minOrder` ASC [ RunTime:0.000471s ]
select * from pdf where partno='210-333/1000-079' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.003534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/1000-079' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.004967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854826 LIMIT 4 [ RunTime:0.001503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854826 ORDER BY `minOrder` ASC [ RunTime:0.006368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854826 ORDER BY `unit` DESC [ RunTime:0.003084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854826 LIMIT 2 [ RunTime:0.008221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854826 ORDER BY `minOrder` ASC [ RunTime:0.004792s ]
select * from pdf where partno='210-332/750-001' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/750-001' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.012293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854825 LIMIT 4 [ RunTime:0.012124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854825 ORDER BY `minOrder` ASC [ RunTime:0.001438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854825 ORDER BY `unit` DESC [ RunTime:0.006901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854825 LIMIT 2 [ RunTime:0.003723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854825 ORDER BY `minOrder` ASC [ RunTime:0.002026s ]
select * from pdf where partno='210-332/700-001' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.012707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/700-001' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.004500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854824 LIMIT 4 [ RunTime:0.009816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854824 ORDER BY `minOrder` ASC [ RunTime:0.013245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854824 ORDER BY `unit` DESC [ RunTime:0.013642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854824 LIMIT 2 [ RunTime:0.006939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854824 ORDER BY `minOrder` ASC [ RunTime:0.009252s ]
select * from pdf where partno='210-332/400-205' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.021295s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/400-205' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.005587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854823 LIMIT 4 [ RunTime:0.007838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854823 ORDER BY `minOrder` ASC [ RunTime:0.000695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854823 ORDER BY `unit` DESC [ RunTime:0.004813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854823 LIMIT 2 [ RunTime:0.001867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854823 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
select * from pdf where partno='210-331/254-207' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.002600s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-331/254-207' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.000812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854822 LIMIT 4 [ RunTime:0.000756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854822 ORDER BY `minOrder` ASC [ RunTime:0.006825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854822 ORDER BY `unit` DESC [ RunTime:0.002305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854822 LIMIT 2 [ RunTime:0.006940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854822 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='210-332/508-205' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/508-205' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.002820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854821 LIMIT 4 [ RunTime:0.001432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854821 ORDER BY `minOrder` ASC [ RunTime:0.004550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854821 ORDER BY `unit` DESC [ RunTime:0.002187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854821 LIMIT 2 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854821 ORDER BY `minOrder` ASC [ RunTime:0.000284s ]
select * from pdf where partno='210-332/500-206' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.000890s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/500-206' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.004646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854820 LIMIT 4 [ RunTime:0.000464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854820 ORDER BY `minOrder` ASC [ RunTime:0.002315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854820 ORDER BY `unit` DESC [ RunTime:0.005130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854820 LIMIT 2 [ RunTime:0.015277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854820 ORDER BY `minOrder` ASC [ RunTime:0.001988s ]
select * from pdf where partno='210-333/600-105' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.001776s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/600-105' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.001309s ]
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.000502s ]