SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001252s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=4412F&search=1' [ RunTime:0.002359s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001210s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000589s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002218s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.002443s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001967s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000266s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001808s ]
SELECT * FROM `stock_search` WHERE `partno` = '4412F' LIMIT 1 [ RunTime:0.003813s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-25 05:02:59' WHERE `partno` = '4412F' [ RunTime:0.009942s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002812s ]
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 '4412F%' OR `brand` LIKE '4412F%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032129s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15180626 LIMIT 5 [ RunTime:0.011664s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15180626 ORDER BY `minOrder` ASC [ RunTime:0.016837s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15180626 ORDER BY `unit` DESC [ RunTime:0.010721s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15180626 LIMIT 2 [ RunTime:0.023297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15180626 ORDER BY `minOrder` ASC [ RunTime:0.010073s ]
select * from pdf where partno='4412FGL' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.050464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16008512 LIMIT 5 [ RunTime:0.019882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16008512 ORDER BY `minOrder` ASC [ RunTime:0.035177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16008512 ORDER BY `unit` DESC [ RunTime:0.076761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16008512 LIMIT 2 [ RunTime:0.033605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16008512 ORDER BY `minOrder` ASC [ RunTime:0.046339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18592501 LIMIT 5 [ RunTime:0.060696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18592501 ORDER BY `minOrder` ASC [ RunTime:0.101350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18592501 ORDER BY `unit` DESC [ RunTime:0.065746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18592501 LIMIT 2 [ RunTime:0.055800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18592501 ORDER BY `minOrder` ASC [ RunTime:0.030145s ]
select * from pdf where partno='4412FM' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.060819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16968784 LIMIT 5 [ RunTime:0.055670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16968784 ORDER BY `minOrder` ASC [ RunTime:0.040017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16968784 ORDER BY `unit` DESC [ RunTime:0.061606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16968784 LIMIT 2 [ RunTime:0.052678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16968784 ORDER BY `minOrder` ASC [ RunTime:0.036752s ]
select * from pdf where partno='4412FNH' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.053325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16009588 LIMIT 5 [ RunTime:0.059854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16009588 ORDER BY `minOrder` ASC [ RunTime:0.047678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16009588 ORDER BY `unit` DESC [ RunTime:0.042401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16009588 LIMIT 2 [ RunTime:0.106369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16009588 ORDER BY `minOrder` ASC [ RunTime:0.014229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16009018 LIMIT 5 [ RunTime:0.034916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16009018 ORDER BY `minOrder` ASC [ RunTime:0.055226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16009018 ORDER BY `unit` DESC [ RunTime:0.067188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16009018 LIMIT 2 [ RunTime:0.024497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16009018 ORDER BY `minOrder` ASC [ RunTime:0.007550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16969423 LIMIT 5 [ RunTime:0.024658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16969423 ORDER BY `minOrder` ASC [ RunTime:0.044637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16969423 ORDER BY `unit` DESC [ RunTime:0.031206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16969423 LIMIT 2 [ RunTime:0.010237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16969423 ORDER BY `minOrder` ASC [ RunTime:0.043080s ]
select * from pdf where partno='4412FN/2H' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.023392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15182158 LIMIT 5 [ RunTime:0.014389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15182158 ORDER BY `minOrder` ASC [ RunTime:0.034979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15182158 ORDER BY `unit` DESC [ RunTime:0.030660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15182158 LIMIT 2 [ RunTime:0.013158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15182158 ORDER BY `minOrder` ASC [ RunTime:0.006007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16968867 LIMIT 5 [ RunTime:0.016579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16968867 ORDER BY `minOrder` ASC [ RunTime:0.010190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16968867 ORDER BY `unit` DESC [ RunTime:0.022337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16968867 LIMIT 2 [ RunTime:0.000932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16968867 ORDER BY `minOrder` ASC [ RunTime:0.012160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16009458 LIMIT 5 [ RunTime:0.019888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16009458 ORDER BY `minOrder` ASC [ RunTime:0.015640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16009458 ORDER BY `unit` DESC [ RunTime:0.032886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16009458 LIMIT 2 [ RunTime:0.004880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16009458 ORDER BY `minOrder` ASC [ RunTime:0.002641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18597432 LIMIT 5 [ RunTime:0.019865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18597432 ORDER BY `minOrder` ASC [ RunTime:0.040291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18597432 ORDER BY `unit` DESC [ RunTime:0.067201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18597432 LIMIT 2 [ RunTime:0.014193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18597432 ORDER BY `minOrder` ASC [ RunTime:0.013235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18595367 LIMIT 5 [ RunTime:0.046892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18595367 ORDER BY `minOrder` ASC [ RunTime:0.041508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18595367 ORDER BY `unit` DESC [ RunTime:0.047053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18595367 LIMIT 2 [ RunTime:0.002902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18595367 ORDER BY `minOrder` ASC [ RunTime:0.000505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18593371 LIMIT 5 [ RunTime:0.010010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18593371 ORDER BY `minOrder` ASC [ RunTime:0.024389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18593371 ORDER BY `unit` DESC [ RunTime:0.027244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18593371 LIMIT 2 [ RunTime:0.019902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18593371 ORDER BY `minOrder` ASC [ RunTime:0.020484s ]
select * from pdf where partno='4412F/2D' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.054732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18593188 LIMIT 5 [ RunTime:0.038439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18593188 ORDER BY `minOrder` ASC [ RunTime:0.028009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18593188 ORDER BY `unit` DESC [ RunTime:0.043099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18593188 LIMIT 2 [ RunTime:0.020934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18593188 ORDER BY `minOrder` ASC [ RunTime:0.006722s ]
select * from pdf where partno='4412FM/2' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.037940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15181638 LIMIT 5 [ RunTime:0.025976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15181638 ORDER BY `minOrder` ASC [ RunTime:0.018329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15181638 ORDER BY `unit` DESC [ RunTime:0.068194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15181638 LIMIT 2 [ RunTime:0.032647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15181638 ORDER BY `minOrder` ASC [ RunTime:0.023833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15180834 LIMIT 5 [ RunTime:0.025848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15180834 ORDER BY `minOrder` ASC [ RunTime:0.030529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15180834 ORDER BY `unit` DESC [ RunTime:0.027130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15180834 LIMIT 2 [ RunTime:0.031760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15180834 ORDER BY `minOrder` ASC [ RunTime:0.014811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14169148 LIMIT 5 [ RunTime:0.021686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14169148 ORDER BY `minOrder` ASC [ RunTime:0.035141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14169148 ORDER BY `unit` DESC [ RunTime:0.029595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14169148 LIMIT 2 [ RunTime:0.012428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14169148 ORDER BY `minOrder` ASC [ RunTime:0.034304s ]
select * from pdf where partno='4412FGML' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.046196s ]
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 '4412F%' OR `brand` LIKE '4412F%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.059336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51084948 LIMIT 5 [ RunTime:0.029285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51084948 ORDER BY `minOrder` ASC [ RunTime:0.046012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51084948 ORDER BY `unit` DESC [ RunTime:0.060980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51084948 LIMIT 2 [ RunTime:0.048428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51084948 ORDER BY `minOrder` ASC [ RunTime:0.007259s ]
select * from pdf where partno='4412f/2gp-535' and brandshort='ebm-papst' limit 1 [ RunTime:0.019880s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4412f/2gp-535' OR `brand` LIKE 'ebm-papst%' ) ) LIMIT 1 [ RunTime:0.029879s ]
SELECT `id` FROM `stock` WHERE `id` <> 51084948 AND `partno` = '4412f/2gp-535' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst%' ) [ RunTime:0.062459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18597432 [ RunTime:0.052041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51085304 LIMIT 5 [ RunTime:0.019145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085304 ORDER BY `minOrder` ASC [ RunTime:0.033010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51085304 ORDER BY `unit` DESC [ RunTime:0.030478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51085304 LIMIT 2 [ RunTime:0.065351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085304 ORDER BY `minOrder` ASC [ RunTime:0.006016s ]
select * from pdf where partno='4412fml' and brandshort='ebm-papst' limit 1 [ RunTime:0.025081s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4412fml' OR `brand` LIKE 'ebm-papst%' ) ) LIMIT 1 [ RunTime:0.042006s ]
SELECT `id` FROM `stock` WHERE `id` <> 51085304 AND `partno` = '4412fml' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst%' ) [ RunTime:0.039254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16968867 [ RunTime:0.025666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51085255 LIMIT 5 [ RunTime:0.067624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085255 ORDER BY `minOrder` ASC [ RunTime:0.042041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51085255 ORDER BY `unit` DESC [ RunTime:0.019346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51085255 LIMIT 2 [ RunTime:0.016636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51085255 ORDER BY `minOrder` ASC [ RunTime:0.004022s ]
select * from pdf where partno='4412fnh' and brandshort='ebm-papst' limit 1 [ RunTime:0.015815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4412fnh' OR `brand` LIKE 'ebm-papst%' ) ) LIMIT 1 [ RunTime:0.021157s ]
SELECT `id` FROM `stock` WHERE `id` <> 51085255 AND `partno` = '4412fnh' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst%' ) [ RunTime:0.027248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16968784 [ RunTime:0.031364s ]
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 '4412F%' OR `brand` LIKE '4412F%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58476316 LIMIT 5 [ RunTime:0.000713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58476316 ORDER BY `minOrder` ASC [ RunTime:0.015788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58476316 ORDER BY `unit` DESC [ RunTime:0.012993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58476316 LIMIT 2 [ RunTime:0.009023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58476316 ORDER BY `minOrder` ASC [ RunTime:0.008723s ]
select * from pdf where partno='4412F/2' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.013164s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4412F/2' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.013094s ]
SELECT `id` FROM `stock` WHERE `id` <> 58476316 AND `partno` = '4412F/2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.014788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16008512 [ RunTime:0.005181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58475382 LIMIT 5 [ RunTime:0.004721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58475382 ORDER BY `minOrder` ASC [ RunTime:0.025586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58475382 ORDER BY `unit` DESC [ RunTime:0.002001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58475382 LIMIT 2 [ RunTime:0.011414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58475382 ORDER BY `minOrder` ASC [ RunTime:0.014687s ]
select * from pdf where partno='4412FM' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.003272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4412FM' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.013944s ]
SELECT `id` FROM `stock` WHERE `id` <> 58475382 AND `partno` = '4412FM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.035555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18592501 [ RunTime:0.011893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58476395 LIMIT 5 [ RunTime:0.020201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58476395 ORDER BY `minOrder` ASC [ RunTime:0.050000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58476395 ORDER BY `unit` DESC [ RunTime:0.010419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58476395 LIMIT 2 [ RunTime:0.012632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58476395 ORDER BY `minOrder` ASC [ RunTime:0.002169s ]
select * from pdf where partno='4412FNH' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.009397s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4412FNH' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.015582s ]
SELECT `id` FROM `stock` WHERE `id` <> 58476395 AND `partno` = '4412FNH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.005446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16968784 [ RunTime:0.003625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58476317 LIMIT 5 [ RunTime:0.013634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58476317 ORDER BY `minOrder` ASC [ RunTime:0.024314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58476317 ORDER BY `unit` DESC [ RunTime:0.006719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58476317 LIMIT 2 [ RunTime:0.015752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58476317 ORDER BY `minOrder` ASC [ RunTime:0.005934s ]
select * from pdf where partno='4412F/2M' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.021639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4412F/2M' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.018157s ]
SELECT `id` FROM `stock` WHERE `id` <> 58476317 AND `partno` = '4412F/2M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.010843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16009588 [ RunTime:0.004583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58479988 LIMIT 5 [ RunTime:0.026240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58479988 ORDER BY `minOrder` ASC [ RunTime:0.005961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58479988 ORDER BY `unit` DESC [ RunTime:0.035173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58479988 LIMIT 2 [ RunTime:0.008368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58479988 ORDER BY `minOrder` ASC [ RunTime:0.000253s ]
select * from pdf where partno='4412FN/2H' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.003521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4412FN/2H' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.016952s ]
SELECT `id` FROM `stock` WHERE `id` <> 58479988 AND `partno` = '4412FN/2H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.024389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16969423 [ RunTime:0.027391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58479549 LIMIT 5 [ RunTime:0.024361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58479549 ORDER BY `minOrder` ASC [ RunTime:0.033003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58479549 ORDER BY `unit` DESC [ RunTime:0.006124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58479549 LIMIT 2 [ RunTime:0.029233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58479549 ORDER BY `minOrder` ASC [ RunTime:0.004815s ]
select * from pdf where partno='4412F' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.037081s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4412F' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.008903s ]
SELECT `id` FROM `stock` WHERE `id` <> 58479549 AND `partno` = '4412F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.009215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16009018 [ RunTime:0.012840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58477599 LIMIT 5 [ RunTime:0.011393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58477599 ORDER BY `minOrder` ASC [ RunTime:0.005025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58477599 ORDER BY `unit` DESC [ RunTime:0.021385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58477599 LIMIT 2 [ RunTime:0.030894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58477599 ORDER BY `minOrder` ASC [ RunTime:0.002987s ]
select * from pdf where partno='4412FML' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.027965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4412FML' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.016045s ]
SELECT `id` FROM `stock` WHERE `id` <> 58477599 AND `partno` = '4412FML' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.020549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16968867 [ RunTime:0.000644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58480682 LIMIT 5 [ RunTime:0.070980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58480682 ORDER BY `minOrder` ASC [ RunTime:0.020731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58480682 ORDER BY `unit` DESC [ RunTime:0.016092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58480682 LIMIT 2 [ RunTime:0.017260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58480682 ORDER BY `minOrder` ASC [ RunTime:0.017883s ]
select * from pdf where partno='4412FGM' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.018373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4412FGM' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.014959s ]
SELECT `id` FROM `stock` WHERE `id` <> 58480682 AND `partno` = '4412FGM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.039932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15182158 [ RunTime:0.001984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58492731 LIMIT 5 [ RunTime:0.002770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58492731 ORDER BY `minOrder` ASC [ RunTime:0.006841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58492731 ORDER BY `unit` DESC [ RunTime:0.003953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58492731 LIMIT 2 [ RunTime:0.019334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58492731 ORDER BY `minOrder` ASC [ RunTime:0.002224s ]
select * from pdf where partno='4412F/2D' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.005971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4412F/2D' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.016211s ]
SELECT `id` FROM `stock` WHERE `id` <> 58492731 AND `partno` = '4412F/2D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.008995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18593371 [ RunTime:0.031121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58492235 LIMIT 5 [ RunTime:0.063731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58492235 ORDER BY `minOrder` ASC [ RunTime:0.019496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58492235 ORDER BY `unit` DESC [ RunTime:0.011021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58492235 LIMIT 2 [ RunTime:0.029043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58492235 ORDER BY `minOrder` ASC [ RunTime:0.042170s ]
select * from pdf where partno='4412FM/2' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.020783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4412FM/2' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.019310s ]
SELECT `id` FROM `stock` WHERE `id` <> 58492235 AND `partno` = '4412FM/2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.043330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18593188 [ RunTime:0.062474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58492230 LIMIT 5 [ RunTime:0.005888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58492230 ORDER BY `minOrder` ASC [ RunTime:0.058637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58492230 ORDER BY `unit` DESC [ RunTime:0.057078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58492230 LIMIT 2 [ RunTime:0.017559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58492230 ORDER BY `minOrder` ASC [ RunTime:0.015865s ]
select * from pdf where partno='4412FMD' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.020722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4412FMD' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.068089s ]
SELECT `id` FROM `stock` WHERE `id` <> 58492230 AND `partno` = '4412FMD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.036205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15180834 [ RunTime:0.037051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58481097 LIMIT 5 [ RunTime:0.057747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58481097 ORDER BY `minOrder` ASC [ RunTime:0.031151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58481097 ORDER BY `unit` DESC [ RunTime:0.013975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58481097 LIMIT 2 [ RunTime:0.015995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58481097 ORDER BY `minOrder` ASC [ RunTime:0.004377s ]
select * from pdf where partno='4412F/2GP-535' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.005894s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4412F/2GP-535' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.009184s ]
SELECT `id` FROM `stock` WHERE `id` <> 58481097 AND `partno` = '4412F/2GP-535' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.023546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18597432 [ RunTime:0.003847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58480259 LIMIT 5 [ RunTime:0.013545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58480259 ORDER BY `minOrder` ASC [ RunTime:0.058501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58480259 ORDER BY `unit` DESC [ RunTime:0.013754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58480259 LIMIT 2 [ RunTime:0.027043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58480259 ORDER BY `minOrder` ASC [ RunTime:0.002577s ]
select * from pdf where partno='4412FGL' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.008745s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4412FGL' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.049373s ]
SELECT `id` FROM `stock` WHERE `id` <> 58480259 AND `partno` = '4412FGL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.031681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15180626 [ RunTime:0.021336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58479913 LIMIT 5 [ RunTime:0.050646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58479913 ORDER BY `minOrder` ASC [ RunTime:0.044182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58479913 ORDER BY `unit` DESC [ RunTime:0.042758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58479913 LIMIT 2 [ RunTime:0.030948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58479913 ORDER BY `minOrder` ASC [ RunTime:0.028766s ]
select * from pdf where partno='4412FGML' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.006101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4412FGML' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.037520s ]
SELECT `id` FROM `stock` WHERE `id` <> 58479913 AND `partno` = '4412FGML' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.034716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14169148 [ RunTime:0.047622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58479544 LIMIT 5 [ RunTime:0.053903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58479544 ORDER BY `minOrder` ASC [ RunTime:0.011509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58479544 ORDER BY `unit` DESC [ RunTime:0.032501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58479544 LIMIT 2 [ RunTime:0.064418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58479544 ORDER BY `minOrder` ASC [ RunTime:0.006710s ]
select * from pdf where partno='4412FG' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.054340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4412FG' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.023539s ]
SELECT `id` FROM `stock` WHERE `id` <> 58479544 AND `partno` = '4412FG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.019405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16009458 [ RunTime:0.018233s ]
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 '4412F%' OR `brand` LIKE '4412F%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042169s ]
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 '4412F%' OR `brand` LIKE '4412F%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025363s ]
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 '4412F%' OR `brand` LIKE '4412F%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025082s ]
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 '4412F%' OR `brand` LIKE '4412F%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034719s ]
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 '4412F%' OR `brand` LIKE '4412F%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030096s ]
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 '4412F%' OR `brand` LIKE '4412F%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039894s ]
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 '4412F%' OR `brand` LIKE '4412F%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027492s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4412F%' OR `brand` LIKE '4412F%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.037383s ]