SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002569s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.101' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=612N&search=1' [ RunTime:0.007278s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001369s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000452s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003063s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.101' ) [ RunTime:0.006985s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002539s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000380s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002046s ]
SELECT * FROM `stock_search` WHERE `partno` = '612N' LIMIT 1 [ RunTime:0.005647s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-22 23:03:46' WHERE `partno` = '612N' [ RunTime:0.012327s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003226s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '612N%' OR `brand` LIKE '612N%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030317s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15180460 LIMIT 5 [ RunTime:0.015556s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15180460 ORDER BY `minOrder` ASC [ RunTime:0.002680s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15180460 ORDER BY `unit` DESC [ RunTime:0.006296s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15180460 LIMIT 2 [ RunTime:0.009499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15180460 ORDER BY `minOrder` ASC [ RunTime:0.007092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16969611 LIMIT 5 [ RunTime:0.007816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16969611 ORDER BY `minOrder` ASC [ RunTime:0.001118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16969611 ORDER BY `unit` DESC [ RunTime:0.006887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16969611 LIMIT 2 [ RunTime:0.000970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16969611 ORDER BY `minOrder` ASC [ RunTime:0.001415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16969615 LIMIT 5 [ RunTime:0.009432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16969615 ORDER BY `minOrder` ASC [ RunTime:0.010430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16969615 ORDER BY `unit` DESC [ RunTime:0.003122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16969615 LIMIT 2 [ RunTime:0.009153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16969615 ORDER BY `minOrder` ASC [ RunTime:0.001914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16008496 LIMIT 5 [ RunTime:0.006152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16008496 ORDER BY `minOrder` ASC [ RunTime:0.004953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16008496 ORDER BY `unit` DESC [ RunTime:0.007946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16008496 LIMIT 2 [ RunTime:0.011375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16008496 ORDER BY `minOrder` ASC [ RunTime:0.002620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18597323 LIMIT 5 [ RunTime:0.006615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18597323 ORDER BY `minOrder` ASC [ RunTime:0.000731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18597323 ORDER BY `unit` DESC [ RunTime:0.003304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18597323 LIMIT 2 [ RunTime:0.004087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18597323 ORDER BY `minOrder` ASC [ RunTime:0.003784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14168766 LIMIT 5 [ RunTime:0.006353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14168766 ORDER BY `minOrder` ASC [ RunTime:0.008237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14168766 ORDER BY `unit` DESC [ RunTime:0.013006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14168766 LIMIT 2 [ RunTime:0.011055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14168766 ORDER BY `minOrder` ASC [ RunTime:0.000575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18591995 LIMIT 5 [ RunTime:0.004552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18591995 ORDER BY `minOrder` ASC [ RunTime:0.009073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18591995 ORDER BY `unit` DESC [ RunTime:0.014054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18591995 LIMIT 2 [ RunTime:0.004418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18591995 ORDER BY `minOrder` ASC [ RunTime:0.000668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14532 LIMIT 5 [ RunTime:0.000754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14532 ORDER BY `minOrder` ASC [ RunTime:0.005004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14532 ORDER BY `unit` DESC [ RunTime:0.009517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14532 LIMIT 2 [ RunTime:0.005013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14532 ORDER BY `minOrder` ASC [ RunTime:0.007297s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002465s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612NGN' OR `brand` LIKE 'EBM-PAPST%' ) ) LIMIT 1 [ RunTime:0.034767s ]
SELECT `id` FROM `stock` WHERE `id` <> 14532 AND `partno` = '612NGN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst%' ) [ RunTime:0.035476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18597414 [ RunTime:0.077521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16009571 LIMIT 5 [ RunTime:0.037466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16009571 ORDER BY `minOrder` ASC [ RunTime:0.078536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16009571 ORDER BY `unit` DESC [ RunTime:0.067269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16009571 LIMIT 2 [ RunTime:0.018883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16009571 ORDER BY `minOrder` ASC [ RunTime:0.129700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16967611 LIMIT 5 [ RunTime:0.051956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16967611 ORDER BY `minOrder` ASC [ RunTime:0.021222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16967611 ORDER BY `unit` DESC [ RunTime:0.007131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16967611 LIMIT 2 [ RunTime:0.026655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16967611 ORDER BY `minOrder` ASC [ RunTime:0.016705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15181879 LIMIT 5 [ RunTime:0.013020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15181879 ORDER BY `minOrder` ASC [ RunTime:0.015373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15181879 ORDER BY `unit` DESC [ RunTime:0.006156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15181879 LIMIT 2 [ RunTime:0.005507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15181879 ORDER BY `minOrder` ASC [ RunTime:0.007293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18595916 LIMIT 5 [ RunTime:0.008763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18595916 ORDER BY `minOrder` ASC [ RunTime:0.029381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18595916 ORDER BY `unit` DESC [ RunTime:0.017026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18595916 LIMIT 2 [ RunTime:0.000728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18595916 ORDER BY `minOrder` ASC [ RunTime:0.000565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18597414 LIMIT 5 [ RunTime:0.009313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18597414 ORDER BY `minOrder` ASC [ RunTime:0.007091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18597414 ORDER BY `unit` DESC [ RunTime:0.007297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18597414 LIMIT 2 [ RunTime:0.000837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18597414 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15182147 LIMIT 5 [ RunTime:0.007528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15182147 ORDER BY `minOrder` ASC [ RunTime:0.003282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15182147 ORDER BY `unit` DESC [ RunTime:0.008823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15182147 LIMIT 2 [ RunTime:0.004557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15182147 ORDER BY `minOrder` ASC [ RunTime:0.000672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18596930 LIMIT 5 [ RunTime:0.001477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18596930 ORDER BY `minOrder` ASC [ RunTime:0.008331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18596930 ORDER BY `unit` DESC [ RunTime:0.008144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18596930 LIMIT 2 [ RunTime:0.005667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18596930 ORDER BY `minOrder` ASC [ RunTime:0.001528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15182228 LIMIT 5 [ RunTime:0.005500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15182228 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15182228 ORDER BY `unit` DESC [ RunTime:0.011979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15182228 LIMIT 2 [ RunTime:0.002421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15182228 ORDER BY `minOrder` ASC [ RunTime:0.000406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18705849 LIMIT 5 [ RunTime:0.003326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18705849 ORDER BY `minOrder` ASC [ RunTime:0.001826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18705849 ORDER BY `unit` DESC [ RunTime:0.011760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18705849 LIMIT 2 [ RunTime:0.004141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18705849 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18596929 LIMIT 5 [ RunTime:0.002668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18596929 ORDER BY `minOrder` ASC [ RunTime:0.006675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18596929 ORDER BY `unit` DESC [ RunTime:0.016537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18596929 LIMIT 2 [ RunTime:0.003164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18596929 ORDER BY `minOrder` ASC [ RunTime:0.003080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16009449 LIMIT 5 [ RunTime:0.004078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16009449 ORDER BY `minOrder` ASC [ RunTime:0.009451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16009449 ORDER BY `unit` DESC [ RunTime:0.016182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16009449 LIMIT 2 [ RunTime:0.005995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16009449 ORDER BY `minOrder` ASC [ RunTime:0.003555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18597545 LIMIT 5 [ RunTime:0.003850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18597545 ORDER BY `minOrder` ASC [ RunTime:0.003213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18597545 ORDER BY `unit` DESC [ RunTime:0.009343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18597545 LIMIT 2 [ RunTime:0.001199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18597545 ORDER BY `minOrder` ASC [ RunTime:0.000516s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '612N%' OR `brand` LIKE '612N%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51084879 LIMIT 5 [ RunTime:0.001298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51084879 ORDER BY `minOrder` ASC [ RunTime:0.004765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51084879 ORDER BY `unit` DESC [ RunTime:0.007894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51084879 LIMIT 2 [ RunTime:0.008513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51084879 ORDER BY `minOrder` ASC [ RunTime:0.002093s ]
select * from pdf where partno='612nn' and brandshort='ebm-papst' limit 1 [ RunTime:0.006087s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612nn' OR `brand` LIKE 'ebm-papst%' ) ) LIMIT 1 [ RunTime:0.002115s ]
SELECT `id` FROM `stock` WHERE `id` <> 51084879 AND `partno` = '612nn' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst%' ) [ RunTime:0.004576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16009571 [ RunTime:0.000382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51084840 LIMIT 5 [ RunTime:0.000338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51084840 ORDER BY `minOrder` ASC [ RunTime:0.002418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51084840 ORDER BY `unit` DESC [ RunTime:0.001313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51084840 LIMIT 2 [ RunTime:0.001246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51084840 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
select * from pdf where partno='612ngmi' and brandshort='ebm-papst' limit 1 [ RunTime:0.003038s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612ngmi' OR `brand` LIKE 'ebm-papst%' ) ) LIMIT 1 [ RunTime:0.003158s ]
SELECT `id` FROM `stock` WHERE `id` <> 51084840 AND `partno` = '612ngmi' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst%' ) [ RunTime:0.005695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15182228 [ RunTime:0.002299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51084805 LIMIT 5 [ RunTime:0.006704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51084805 ORDER BY `minOrder` ASC [ RunTime:0.001826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51084805 ORDER BY `unit` DESC [ RunTime:0.008812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51084805 LIMIT 2 [ RunTime:0.004430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51084805 ORDER BY `minOrder` ASC [ RunTime:0.000820s ]
select * from pdf where partno='612nhu-181' and brandshort='ebm-papst' limit 1 [ RunTime:0.001989s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612nhu-181' OR `brand` LIKE 'ebm-papst%' ) ) LIMIT 1 [ RunTime:0.005769s ]
SELECT `id` FROM `stock` WHERE `id` <> 51084805 AND `partno` = '612nhu-181' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst%' ) [ RunTime:0.001838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18595916 [ RunTime:0.011160s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '612N%' OR `brand` LIKE '612N%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51602374 LIMIT 5 [ RunTime:0.000986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51602374 ORDER BY `minOrder` ASC [ RunTime:0.002274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51602374 ORDER BY `unit` DESC [ RunTime:0.009356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51602374 LIMIT 2 [ RunTime:0.004415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51602374 ORDER BY `minOrder` ASC [ RunTime:0.000516s ]
select * from pdf where partno='612NHH-118' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.002357s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612NHH-118' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.002306s ]
SELECT `id` FROM `stock` WHERE `id` <> 51602374 AND `partno` = '612NHH-118' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.004656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16969611 [ RunTime:0.002343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51603124 LIMIT 5 [ RunTime:0.006116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51603124 ORDER BY `minOrder` ASC [ RunTime:0.004598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51603124 ORDER BY `unit` DESC [ RunTime:0.003655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51603124 LIMIT 2 [ RunTime:0.005348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51603124 ORDER BY `minOrder` ASC [ RunTime:0.001647s ]
select * from pdf where partno='612NGLE' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.001702s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612NGLE' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.008972s ]
SELECT `id` FROM `stock` WHERE `id` <> 51603124 AND `partno` = '612NGLE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.003748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16008496 [ RunTime:0.001552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51601399 LIMIT 5 [ RunTime:0.002927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51601399 ORDER BY `minOrder` ASC [ RunTime:0.002492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51601399 ORDER BY `unit` DESC [ RunTime:0.003644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51601399 LIMIT 2 [ RunTime:0.003314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51601399 ORDER BY `minOrder` ASC [ RunTime:0.009006s ]
select * from pdf where partno='612NHH' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.003200s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612NHH' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.001361s ]
SELECT `id` FROM `stock` WHERE `id` <> 51601399 AND `partno` = '612NHH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.002952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15180460 [ RunTime:0.003020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51603149 LIMIT 5 [ RunTime:0.001700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51603149 ORDER BY `minOrder` ASC [ RunTime:0.006914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51603149 ORDER BY `unit` DESC [ RunTime:0.002395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51603149 LIMIT 2 [ RunTime:0.002744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51603149 ORDER BY `minOrder` ASC [ RunTime:0.001359s ]
select * from pdf where partno='612NGHH' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.004189s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612NGHH' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.004829s ]
SELECT `id` FROM `stock` WHERE `id` <> 51603149 AND `partno` = '612NGHH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.000865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14168766 [ RunTime:0.001010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33044943 LIMIT 5 [ RunTime:0.004625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33044943 ORDER BY `minOrder` ASC [ RunTime:0.002117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33044943 ORDER BY `unit` DESC [ RunTime:0.005364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33044943 LIMIT 2 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33044943 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
select * from pdf where partno='612NGME' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.003135s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612NGME' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.000797s ]
SELECT `id` FROM `stock` WHERE `id` <> 33044943 AND `partno` = '612NGME' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.001543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18591995 [ RunTime:0.004043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44576433 LIMIT 5 [ RunTime:0.000410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44576433 ORDER BY `minOrder` ASC [ RunTime:0.012945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44576433 ORDER BY `unit` DESC [ RunTime:0.006689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44576433 LIMIT 2 [ RunTime:0.001431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44576433 ORDER BY `minOrder` ASC [ RunTime:0.000751s ]
select * from pdf where partno='612NGME' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.006464s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612NGME' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.000455s ]
SELECT `id` FROM `stock` WHERE `id` <> 44576433 AND `partno` = '612NGME' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.007346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18591995 [ RunTime:0.004182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51602323 LIMIT 5 [ RunTime:0.004523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51602323 ORDER BY `minOrder` ASC [ RunTime:0.002623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51602323 ORDER BY `unit` DESC [ RunTime:0.019283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51602323 LIMIT 2 [ RunTime:0.002444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51602323 ORDER BY `minOrder` ASC [ RunTime:0.003532s ]
select * from pdf where partno='612NN' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.004686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612NN' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.006287s ]
SELECT `id` FROM `stock` WHERE `id` <> 51602323 AND `partno` = '612NN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.007744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16009571 [ RunTime:0.010811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51604515 LIMIT 5 [ RunTime:0.003031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51604515 ORDER BY `minOrder` ASC [ RunTime:0.008404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51604515 ORDER BY `unit` DESC [ RunTime:0.003821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51604515 LIMIT 2 [ RunTime:0.015446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51604515 ORDER BY `minOrder` ASC [ RunTime:0.012203s ]
select * from pdf where partno='612NME' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.048918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612NME' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.008632s ]
SELECT `id` FROM `stock` WHERE `id` <> 51604515 AND `partno` = '612NME' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.024343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16967611 [ RunTime:0.010532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51603701 LIMIT 5 [ RunTime:0.011054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51603701 ORDER BY `minOrder` ASC [ RunTime:0.014552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51603701 ORDER BY `unit` DESC [ RunTime:0.019061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51603701 LIMIT 2 [ RunTime:0.039439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51603701 ORDER BY `minOrder` ASC [ RunTime:0.011548s ]
select * from pdf where partno='612NHU-181' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.073246s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612NHU-181' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.055665s ]
SELECT `id` FROM `stock` WHERE `id` <> 51603701 AND `partno` = '612NHU-181' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.022094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18595916 [ RunTime:0.033828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51604206 LIMIT 5 [ RunTime:0.041646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51604206 ORDER BY `minOrder` ASC [ RunTime:0.031739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51604206 ORDER BY `unit` DESC [ RunTime:0.042325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51604206 LIMIT 2 [ RunTime:0.062040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51604206 ORDER BY `minOrder` ASC [ RunTime:0.020332s ]
select * from pdf where partno='612NLE' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.034443s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612NLE' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.132049s ]
SELECT `id` FROM `stock` WHERE `id` <> 51604206 AND `partno` = '612NLE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.054425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18597323 [ RunTime:0.140820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51603171 LIMIT 5 [ RunTime:0.051059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51603171 ORDER BY `minOrder` ASC [ RunTime:0.003226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51603171 ORDER BY `unit` DESC [ RunTime:0.016658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51603171 LIMIT 2 [ RunTime:0.018923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51603171 ORDER BY `minOrder` ASC [ RunTime:0.021848s ]
select * from pdf where partno='612N/2H' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.035986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612N/2H' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.050932s ]
SELECT `id` FROM `stock` WHERE `id` <> 51603171 AND `partno` = '612N/2H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.017290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14169048 [ RunTime:0.039458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51604989 LIMIT 5 [ RunTime:0.007568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51604989 ORDER BY `minOrder` ASC [ RunTime:0.018506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51604989 ORDER BY `unit` DESC [ RunTime:0.010946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51604989 LIMIT 2 [ RunTime:0.032235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51604989 ORDER BY `minOrder` ASC [ RunTime:0.031201s ]
select * from pdf where partno='612NGH' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.012287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612NGH' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.023529s ]
SELECT `id` FROM `stock` WHERE `id` <> 51604989 AND `partno` = '612NGH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.067034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15182147 [ RunTime:0.009380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33048666 LIMIT 5 [ RunTime:0.041196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33048666 ORDER BY `minOrder` ASC [ RunTime:0.023988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33048666 ORDER BY `unit` DESC [ RunTime:0.058178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33048666 LIMIT 2 [ RunTime:0.032046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33048666 ORDER BY `minOrder` ASC [ RunTime:0.007979s ]
select * from pdf where partno='612NGN' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.018173s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612NGN' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.023079s ]
SELECT `id` FROM `stock` WHERE `id` <> 33048666 AND `partno` = '612NGN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.020974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18597414 [ RunTime:0.031614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44579231 LIMIT 5 [ RunTime:0.023720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44579231 ORDER BY `minOrder` ASC [ RunTime:0.021550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44579231 ORDER BY `unit` DESC [ RunTime:0.020052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44579231 LIMIT 2 [ RunTime:0.029934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44579231 ORDER BY `minOrder` ASC [ RunTime:0.030517s ]
select * from pdf where partno='612N/2ME' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.042319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612N/2ME' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.025109s ]
SELECT `id` FROM `stock` WHERE `id` <> 44579231 AND `partno` = '612N/2ME' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.027239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18596929 [ RunTime:0.010604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33049535 LIMIT 5 [ RunTime:0.042099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33049535 ORDER BY `minOrder` ASC [ RunTime:0.032234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33049535 ORDER BY `unit` DESC [ RunTime:0.017154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33049535 LIMIT 2 [ RunTime:0.022724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33049535 ORDER BY `minOrder` ASC [ RunTime:0.005461s ]
select * from pdf where partno='612N/2ME' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.003142s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612N/2ME' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.004791s ]
SELECT `id` FROM `stock` WHERE `id` <> 33049535 AND `partno` = '612N/2ME' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.050964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18596929 [ RunTime:0.014666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44579767 LIMIT 5 [ RunTime:0.025234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44579767 ORDER BY `minOrder` ASC [ RunTime:0.026306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44579767 ORDER BY `unit` DESC [ RunTime:0.007554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44579767 LIMIT 2 [ RunTime:0.021595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44579767 ORDER BY `minOrder` ASC [ RunTime:0.018215s ]
select * from pdf where partno='612NGMI' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.018269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612NGMI' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.018666s ]
SELECT `id` FROM `stock` WHERE `id` <> 44579767 AND `partno` = '612NGMI' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.019759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15182228 [ RunTime:0.000906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33050378 LIMIT 5 [ RunTime:0.035110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33050378 ORDER BY `minOrder` ASC [ RunTime:0.051686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33050378 ORDER BY `unit` DESC [ RunTime:0.036917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33050378 LIMIT 2 [ RunTime:0.046950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33050378 ORDER BY `minOrder` ASC [ RunTime:0.011932s ]
select * from pdf where partno='612NGMI' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.015720s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612NGMI' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.017011s ]
SELECT `id` FROM `stock` WHERE `id` <> 33050378 AND `partno` = '612NGMI' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.015175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15182228 [ RunTime:0.022076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51693526 LIMIT 5 [ RunTime:0.037250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51693526 ORDER BY `minOrder` ASC [ RunTime:0.057030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51693526 ORDER BY `unit` DESC [ RunTime:0.013155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51693526 LIMIT 2 [ RunTime:0.014802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51693526 ORDER BY `minOrder` ASC [ RunTime:0.009950s ]
select * from pdf where partno='612N' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.008105s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612N' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.033312s ]
SELECT `id` FROM `stock` WHERE `id` <> 51693526 AND `partno` = '612N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.025510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18705849 [ RunTime:0.012430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51609012 LIMIT 5 [ RunTime:0.013565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51609012 ORDER BY `minOrder` ASC [ RunTime:0.024311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51609012 ORDER BY `unit` DESC [ RunTime:0.027657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51609012 LIMIT 2 [ RunTime:0.030404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51609012 ORDER BY `minOrder` ASC [ RunTime:0.010745s ]
select * from pdf where partno='612N/2GN' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.014441s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612N/2GN' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.014402s ]
SELECT `id` FROM `stock` WHERE `id` <> 51609012 AND `partno` = '612N/2GN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.061433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16009449 [ RunTime:0.039027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51694569 LIMIT 5 [ RunTime:0.037946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51694569 ORDER BY `minOrder` ASC [ RunTime:0.014036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51694569 ORDER BY `unit` DESC [ RunTime:0.013826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51694569 LIMIT 2 [ RunTime:0.005658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51694569 ORDER BY `minOrder` ASC [ RunTime:0.000697s ]
select * from pdf where partno='612NW' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.002321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '612NW' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.015904s ]
SELECT `id` FROM `stock` WHERE `id` <> 51694569 AND `partno` = '612NW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.008314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16995195 [ RunTime:0.010941s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '612N%' OR `brand` LIKE '612N%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011471s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '612N%' OR `brand` LIKE '612N%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013117s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '612N%' OR `brand` LIKE '612N%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009853s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '612N%' OR `brand` LIKE '612N%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012823s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '612N%' OR `brand` LIKE '612N%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003316s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '612N%' OR `brand` LIKE '612N%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006884s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '612N%' OR `brand` LIKE '612N%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002884s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '612N%' OR `brand` LIKE '612N%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003572s ]