SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001912s ]
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.002862s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001278s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002718s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003708s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.006267s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001276s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010233s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002232s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.009677s ]
UPDATE `stock_search` SET `count` = 4125 , `updatetime` = '2026-06-08 16:47:22' WHERE `partno` = '210' [ RunTime:0.012017s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.006430s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000285s ]
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.005039s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001650s ]
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.008042s ]
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 4600,20 [ RunTime:0.057906s ]
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 ('33854787','33854786','33854785','33854784','33854783','33854782','33854781','33854780','33854779','33854778','33854777','33854776','33854775','33854774','33854773','33854772','33854771','33854770','33854769','33854768') ORDER BY FIELD(s.id, 33854787,33854786,33854785,33854784,33854783,33854782,33854781,33854780,33854779,33854778,33854777,33854776,33854775,33854774,33854773,33854772,33854771,33854770,33854769,33854768) [ RunTime:0.036643s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.016144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854787 LIMIT 4 [ RunTime:0.054008s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.016168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854787 ORDER BY `minOrder` ASC [ RunTime:0.027958s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854787 ORDER BY `unit` DESC [ RunTime:0.042319s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.020297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854787 LIMIT 2 [ RunTime:0.058978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854787 ORDER BY `minOrder` ASC [ RunTime:0.061593s ]
select * from pdf where partno='210-332/396-202' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.088773s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002504s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/396-202' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.103313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854786 LIMIT 4 [ RunTime:0.042952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854786 ORDER BY `minOrder` ASC [ RunTime:0.040732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854786 ORDER BY `unit` DESC [ RunTime:0.042213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854786 LIMIT 2 [ RunTime:0.047255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854786 ORDER BY `minOrder` ASC [ RunTime:0.038960s ]
select * from pdf where partno='210-332/635-199' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.083645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/635-199' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.096252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854785 LIMIT 4 [ RunTime:0.079559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854785 ORDER BY `minOrder` ASC [ RunTime:0.066835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854785 ORDER BY `unit` DESC [ RunTime:0.055836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854785 LIMIT 2 [ RunTime:0.039647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854785 ORDER BY `minOrder` ASC [ RunTime:0.058713s ]
select * from pdf where partno='210-332/635-084' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.037101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/635-084' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.011606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854784 LIMIT 4 [ RunTime:0.036347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854784 ORDER BY `minOrder` ASC [ RunTime:0.030734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854784 ORDER BY `unit` DESC [ RunTime:0.047597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854784 LIMIT 2 [ RunTime:0.046352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854784 ORDER BY `minOrder` ASC [ RunTime:0.028647s ]
select * from pdf where partno='210-333/700-078' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.091459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/700-078' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.061359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854783 LIMIT 4 [ RunTime:0.040684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854783 ORDER BY `minOrder` ASC [ RunTime:0.102507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854783 ORDER BY `unit` DESC [ RunTime:0.073442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854783 LIMIT 2 [ RunTime:0.092992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854783 ORDER BY `minOrder` ASC [ RunTime:0.082115s ]
select * from pdf where partno='210-333/600-009' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.073455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/600-009' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.055593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854782 LIMIT 4 [ RunTime:0.066700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854782 ORDER BY `minOrder` ASC [ RunTime:0.150464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854782 ORDER BY `unit` DESC [ RunTime:0.099446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854782 LIMIT 2 [ RunTime:0.022018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854782 ORDER BY `minOrder` ASC [ RunTime:0.043440s ]
select * from pdf where partno='210-333/500-001' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.041271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/500-001' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.075549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854781 LIMIT 4 [ RunTime:0.069835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854781 ORDER BY `minOrder` ASC [ RunTime:0.043239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854781 ORDER BY `unit` DESC [ RunTime:0.078299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854781 LIMIT 2 [ RunTime:0.093729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854781 ORDER BY `minOrder` ASC [ RunTime:0.049631s ]
select * from pdf where partno='210-333/800-010' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.041687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/800-010' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.062458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854780 LIMIT 4 [ RunTime:0.064291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854780 ORDER BY `minOrder` ASC [ RunTime:0.147713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854780 ORDER BY `unit` DESC [ RunTime:0.087371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854780 LIMIT 2 [ RunTime:0.079571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854780 ORDER BY `minOrder` ASC [ RunTime:0.051676s ]
select * from pdf where partno='210-333/800-005' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.064514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/800-005' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.157554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854779 LIMIT 4 [ RunTime:0.053766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854779 ORDER BY `minOrder` ASC [ RunTime:0.113116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854779 ORDER BY `unit` DESC [ RunTime:0.047310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854779 LIMIT 2 [ RunTime:0.050807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854779 ORDER BY `minOrder` ASC [ RunTime:0.061828s ]
select * from pdf where partno='210-332/1000-103' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.088442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/1000-103' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.022839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854778 LIMIT 4 [ RunTime:0.072697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854778 ORDER BY `minOrder` ASC [ RunTime:0.105967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854778 ORDER BY `unit` DESC [ RunTime:0.053936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854778 LIMIT 2 [ RunTime:0.022897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854778 ORDER BY `minOrder` ASC [ RunTime:0.048575s ]
select * from pdf where partno='210-332/635-083' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.071472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/635-083' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.075099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854777 LIMIT 4 [ RunTime:0.055111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854777 ORDER BY `minOrder` ASC [ RunTime:0.022564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854777 ORDER BY `unit` DESC [ RunTime:0.048531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854777 LIMIT 2 [ RunTime:0.048845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854777 ORDER BY `minOrder` ASC [ RunTime:0.034153s ]
select * from pdf where partno='210-332/350-206' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.039305s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/350-206' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.051900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854776 LIMIT 4 [ RunTime:0.063940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854776 ORDER BY `minOrder` ASC [ RunTime:0.071875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854776 ORDER BY `unit` DESC [ RunTime:0.085444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854776 LIMIT 2 [ RunTime:0.054080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854776 ORDER BY `minOrder` ASC [ RunTime:0.004917s ]
select * from pdf where partno='210-333/1000-202' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.058953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/1000-202' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.031917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854775 LIMIT 4 [ RunTime:0.025385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854775 ORDER BY `minOrder` ASC [ RunTime:0.008588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854775 ORDER BY `unit` DESC [ RunTime:0.071511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854775 LIMIT 2 [ RunTime:0.043221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854775 ORDER BY `minOrder` ASC [ RunTime:0.033988s ]
select * from pdf where partno='210-332/1016-204' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.029955s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/1016-204' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.035326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854774 LIMIT 4 [ RunTime:0.017239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854774 ORDER BY `minOrder` ASC [ RunTime:0.019225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854774 ORDER BY `unit` DESC [ RunTime:0.019381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854774 LIMIT 2 [ RunTime:0.011386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854774 ORDER BY `minOrder` ASC [ RunTime:0.021610s ]
select * from pdf where partno='210-332/381-202' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.003249s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/381-202' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.024910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854773 LIMIT 4 [ RunTime:0.164151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854773 ORDER BY `minOrder` ASC [ RunTime:0.098610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854773 ORDER BY `unit` DESC [ RunTime:0.043294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854773 LIMIT 2 [ RunTime:0.068741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854773 ORDER BY `minOrder` ASC [ RunTime:0.029293s ]
select * from pdf where partno='210-333/1200-076' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.025531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/1200-076' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.153798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854772 LIMIT 4 [ RunTime:0.114554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854772 ORDER BY `minOrder` ASC [ RunTime:0.044730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854772 ORDER BY `unit` DESC [ RunTime:0.119869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854772 LIMIT 2 [ RunTime:0.139785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854772 ORDER BY `minOrder` ASC [ RunTime:0.060089s ]
select * from pdf where partno='210-333/800-004' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.063506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/800-004' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.033433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854771 LIMIT 4 [ RunTime:0.036057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854771 ORDER BY `minOrder` ASC [ RunTime:0.075636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854771 ORDER BY `unit` DESC [ RunTime:0.007637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854771 LIMIT 2 [ RunTime:0.098493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854771 ORDER BY `minOrder` ASC [ RunTime:0.061812s ]
select * from pdf where partno='210-332/500-204' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.013445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-332/500-204' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.030592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854770 LIMIT 4 [ RunTime:0.048323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854770 ORDER BY `minOrder` ASC [ RunTime:0.089222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854770 ORDER BY `unit` DESC [ RunTime:0.120146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854770 LIMIT 2 [ RunTime:0.074638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854770 ORDER BY `minOrder` ASC [ RunTime:0.023290s ]
select * from pdf where partno='210-333/1200-107' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.010580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/1200-107' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.032065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854769 LIMIT 4 [ RunTime:0.019695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854769 ORDER BY `minOrder` ASC [ RunTime:0.026403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854769 ORDER BY `unit` DESC [ RunTime:0.009777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854769 LIMIT 2 [ RunTime:0.054774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854769 ORDER BY `minOrder` ASC [ RunTime:0.010756s ]
select * from pdf where partno='210-333/1000-113' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.047023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/1000-113' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.014201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33854768 LIMIT 4 [ RunTime:0.081390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854768 ORDER BY `minOrder` ASC [ RunTime:0.036196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33854768 ORDER BY `unit` DESC [ RunTime:0.015253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33854768 LIMIT 2 [ RunTime:0.022945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33854768 ORDER BY `minOrder` ASC [ RunTime:0.022111s ]
select * from pdf where partno='210-333/800-007' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.030078s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-333/800-007' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.034590s ]
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.071041s ]