SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002303s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `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=MMF204DRE3K&search=1' [ RunTime:0.007196s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001575s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000549s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001446s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.006872s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001359s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010931s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002102s ]
SELECT * FROM `stock_search` WHERE `partno` = 'MMF204DRE3K' LIMIT 1 [ RunTime:0.017652s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-05 12:27:14' WHERE `partno` = 'MMF204DRE3K' [ RunTime:0.007502s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002046s ]
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 'MMF204DRE3K%' OR `brand` LIKE 'MMF204DRE3K%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048910s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18112935 LIMIT 5 [ RunTime:0.030566s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.020325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18112935 ORDER BY `minOrder` ASC [ RunTime:0.033858s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.014299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18112935 ORDER BY `unit` DESC [ RunTime:0.015597s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18112935 LIMIT 2 [ RunTime:0.011964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18112935 ORDER BY `minOrder` ASC [ RunTime:0.024987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18112934 LIMIT 5 [ RunTime:0.026600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18112934 ORDER BY `minOrder` ASC [ RunTime:0.034873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18112934 ORDER BY `unit` DESC [ RunTime:0.006356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18112934 LIMIT 2 [ RunTime:0.019020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18112934 ORDER BY `minOrder` ASC [ RunTime:0.017697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18112933 LIMIT 5 [ RunTime:0.034041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18112933 ORDER BY `minOrder` ASC [ RunTime:0.083968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18112933 ORDER BY `unit` DESC [ RunTime:0.051730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18112933 LIMIT 2 [ RunTime:0.023030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18112933 ORDER BY `minOrder` ASC [ RunTime:0.011656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18112932 LIMIT 5 [ RunTime:0.018672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18112932 ORDER BY `minOrder` ASC [ RunTime:0.054538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18112932 ORDER BY `unit` DESC [ RunTime:0.025158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18112932 LIMIT 2 [ RunTime:0.038674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18112932 ORDER BY `minOrder` ASC [ RunTime:0.037678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18112931 LIMIT 5 [ RunTime:0.002598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18112931 ORDER BY `minOrder` ASC [ RunTime:0.009140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18112931 ORDER BY `unit` DESC [ RunTime:0.008244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18112931 LIMIT 2 [ RunTime:0.020911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18112931 ORDER BY `minOrder` ASC [ RunTime:0.024600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18112930 LIMIT 5 [ RunTime:0.024816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18112930 ORDER BY `minOrder` ASC [ RunTime:0.016348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18112930 ORDER BY `unit` DESC [ RunTime:0.039434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18112930 LIMIT 2 [ RunTime:0.026642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18112930 ORDER BY `minOrder` ASC [ RunTime:0.041505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18112929 LIMIT 5 [ RunTime:0.026359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18112929 ORDER BY `minOrder` ASC [ RunTime:0.032873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18112929 ORDER BY `unit` DESC [ RunTime:0.007287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18112929 LIMIT 2 [ RunTime:0.006481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18112929 ORDER BY `minOrder` ASC [ RunTime:0.006377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18112928 LIMIT 5 [ RunTime:0.003524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18112928 ORDER BY `minOrder` ASC [ RunTime:0.017235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18112928 ORDER BY `unit` DESC [ RunTime:0.034000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18112928 LIMIT 2 [ RunTime:0.086145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18112928 ORDER BY `minOrder` ASC [ RunTime:0.008279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18112927 LIMIT 5 [ RunTime:0.011667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18112927 ORDER BY `minOrder` ASC [ RunTime:0.024266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18112927 ORDER BY `unit` DESC [ RunTime:0.042676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18112927 LIMIT 2 [ RunTime:0.009053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18112927 ORDER BY `minOrder` ASC [ RunTime:0.013506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16844471 LIMIT 5 [ RunTime:0.029061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16844471 ORDER BY `minOrder` ASC [ RunTime:0.019977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16844471 ORDER BY `unit` DESC [ RunTime:0.052194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16844471 LIMIT 2 [ RunTime:0.010883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16844471 ORDER BY `minOrder` ASC [ RunTime:0.006620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16844470 LIMIT 5 [ RunTime:0.045923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16844470 ORDER BY `minOrder` ASC [ RunTime:0.078100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16844470 ORDER BY `unit` DESC [ RunTime:0.058027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16844470 LIMIT 2 [ RunTime:0.028944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16844470 ORDER BY `minOrder` ASC [ RunTime:0.009704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15051103 LIMIT 5 [ RunTime:0.015037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15051103 ORDER BY `minOrder` ASC [ RunTime:0.072008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15051103 ORDER BY `unit` DESC [ RunTime:0.038833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15051103 LIMIT 2 [ RunTime:0.034560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15051103 ORDER BY `minOrder` ASC [ RunTime:0.013652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15051102 LIMIT 5 [ RunTime:0.024825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15051102 ORDER BY `minOrder` ASC [ RunTime:0.035459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15051102 ORDER BY `unit` DESC [ RunTime:0.047312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15051102 LIMIT 2 [ RunTime:0.031286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15051102 ORDER BY `minOrder` ASC [ RunTime:0.007105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15051101 LIMIT 5 [ RunTime:0.013891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15051101 ORDER BY `minOrder` ASC [ RunTime:0.038329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15051101 ORDER BY `unit` DESC [ RunTime:0.072343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15051101 LIMIT 2 [ RunTime:0.020590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15051101 ORDER BY `minOrder` ASC [ RunTime:0.005933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14109097 LIMIT 5 [ RunTime:0.031379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14109097 ORDER BY `minOrder` ASC [ RunTime:0.023673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14109097 ORDER BY `unit` DESC [ RunTime:0.028794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14109097 LIMIT 2 [ RunTime:0.004304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14109097 ORDER BY `minOrder` ASC [ RunTime:0.043407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14109096 LIMIT 5 [ RunTime:0.032467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14109096 ORDER BY `minOrder` ASC [ RunTime:0.025315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14109096 ORDER BY `unit` DESC [ RunTime:0.016494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14109096 LIMIT 2 [ RunTime:0.037660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14109096 ORDER BY `minOrder` ASC [ RunTime:0.006126s ]
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 'MMF204DRE3K%' OR `brand` LIKE 'MMF204DRE3K%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028504s ]
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 'MMF204DRE3K%' OR `brand` LIKE 'MMF204DRE3K%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37877396 LIMIT 5 [ RunTime:0.039442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877396 ORDER BY `minOrder` ASC [ RunTime:0.029442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37877396 ORDER BY `unit` DESC [ RunTime:0.039635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37877396 LIMIT 2 [ RunTime:0.044304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877396 ORDER BY `minOrder` ASC [ RunTime:0.033843s ]
select * from pdf where partno='MMF204DRE3K92' and brandshort='YAGEO' limit 1 [ RunTime:0.043607s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001433s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF204DRE3K92' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.041823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37877395 LIMIT 5 [ RunTime:0.023810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877395 ORDER BY `minOrder` ASC [ RunTime:0.021670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37877395 ORDER BY `unit` DESC [ RunTime:0.036847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37877395 LIMIT 2 [ RunTime:0.001275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877395 ORDER BY `minOrder` ASC [ RunTime:0.013289s ]
select * from pdf where partno='MMF204DRE3K9' and brandshort='YAGEO' limit 1 [ RunTime:0.025471s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF204DRE3K9' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.013890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37877394 LIMIT 5 [ RunTime:0.045369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877394 ORDER BY `minOrder` ASC [ RunTime:0.054686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37877394 ORDER BY `unit` DESC [ RunTime:0.023321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37877394 LIMIT 2 [ RunTime:0.035953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877394 ORDER BY `minOrder` ASC [ RunTime:0.000568s ]
select * from pdf where partno='MMF204DRE3K83' and brandshort='YAGEO' limit 1 [ RunTime:0.020513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF204DRE3K83' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.020622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37877393 LIMIT 5 [ RunTime:0.036712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877393 ORDER BY `minOrder` ASC [ RunTime:0.019453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37877393 ORDER BY `unit` DESC [ RunTime:0.032130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37877393 LIMIT 2 [ RunTime:0.020437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877393 ORDER BY `minOrder` ASC [ RunTime:0.000752s ]
select * from pdf where partno='MMF204DRE3K74' and brandshort='YAGEO' limit 1 [ RunTime:0.007255s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF204DRE3K74' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.023634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37877392 LIMIT 5 [ RunTime:0.013039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877392 ORDER BY `minOrder` ASC [ RunTime:0.023548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37877392 ORDER BY `unit` DESC [ RunTime:0.015209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37877392 LIMIT 2 [ RunTime:0.017185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877392 ORDER BY `minOrder` ASC [ RunTime:0.007966s ]
select * from pdf where partno='MMF204DRE3K65' and brandshort='YAGEO' limit 1 [ RunTime:0.005558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF204DRE3K65' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.026775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37877391 LIMIT 5 [ RunTime:0.020818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877391 ORDER BY `minOrder` ASC [ RunTime:0.044305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37877391 ORDER BY `unit` DESC [ RunTime:0.020003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37877391 LIMIT 2 [ RunTime:0.020579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877391 ORDER BY `minOrder` ASC [ RunTime:0.020411s ]
select * from pdf where partno='MMF204DRE3K6' and brandshort='YAGEO' limit 1 [ RunTime:0.025606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF204DRE3K6' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.029499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37877390 LIMIT 5 [ RunTime:0.046001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877390 ORDER BY `minOrder` ASC [ RunTime:0.039945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37877390 ORDER BY `unit` DESC [ RunTime:0.013787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37877390 LIMIT 2 [ RunTime:0.009973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877390 ORDER BY `minOrder` ASC [ RunTime:0.011791s ]
select * from pdf where partno='MMF204DRE3K57' and brandshort='YAGEO' limit 1 [ RunTime:0.012033s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF204DRE3K57' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.058168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37877389 LIMIT 5 [ RunTime:0.048272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877389 ORDER BY `minOrder` ASC [ RunTime:0.052446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37877389 ORDER BY `unit` DESC [ RunTime:0.010195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37877389 LIMIT 2 [ RunTime:0.026072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877389 ORDER BY `minOrder` ASC [ RunTime:0.031408s ]
select * from pdf where partno='MMF204DRE3K48' and brandshort='YAGEO' limit 1 [ RunTime:0.027205s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF204DRE3K48' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.039756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37877388 LIMIT 5 [ RunTime:0.039498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877388 ORDER BY `minOrder` ASC [ RunTime:0.021915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37877388 ORDER BY `unit` DESC [ RunTime:0.032000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37877388 LIMIT 2 [ RunTime:0.033920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877388 ORDER BY `minOrder` ASC [ RunTime:0.003984s ]
select * from pdf where partno='MMF204DRE3K4' and brandshort='YAGEO' limit 1 [ RunTime:0.018806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF204DRE3K4' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.060268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37877387 LIMIT 5 [ RunTime:0.034382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877387 ORDER BY `minOrder` ASC [ RunTime:0.091536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37877387 ORDER BY `unit` DESC [ RunTime:0.015214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37877387 LIMIT 2 [ RunTime:0.004841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877387 ORDER BY `minOrder` ASC [ RunTime:0.032128s ]
select * from pdf where partno='MMF204DRE3K32' and brandshort='YAGEO' limit 1 [ RunTime:0.048622s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF204DRE3K32' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.034990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37877386 LIMIT 5 [ RunTime:0.049042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877386 ORDER BY `minOrder` ASC [ RunTime:0.122258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37877386 ORDER BY `unit` DESC [ RunTime:0.055318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37877386 LIMIT 2 [ RunTime:0.036099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877386 ORDER BY `minOrder` ASC [ RunTime:0.026570s ]
select * from pdf where partno='MMF204DRE3K3' and brandshort='YAGEO' limit 1 [ RunTime:0.009433s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF204DRE3K3' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.050986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37877385 LIMIT 5 [ RunTime:0.027985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877385 ORDER BY `minOrder` ASC [ RunTime:0.043385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37877385 ORDER BY `unit` DESC [ RunTime:0.017630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37877385 LIMIT 2 [ RunTime:0.037537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877385 ORDER BY `minOrder` ASC [ RunTime:0.003944s ]
select * from pdf where partno='MMF204DRE3K24' and brandshort='YAGEO' limit 1 [ RunTime:0.019702s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF204DRE3K24' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.032631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37877384 LIMIT 5 [ RunTime:0.029892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877384 ORDER BY `minOrder` ASC [ RunTime:0.030012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37877384 ORDER BY `unit` DESC [ RunTime:0.020232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37877384 LIMIT 2 [ RunTime:0.045161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877384 ORDER BY `minOrder` ASC [ RunTime:0.001076s ]
select * from pdf where partno='MMF204DRE3K16' and brandshort='YAGEO' limit 1 [ RunTime:0.010507s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF204DRE3K16' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.006749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37877383 LIMIT 5 [ RunTime:0.013616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877383 ORDER BY `minOrder` ASC [ RunTime:0.010716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37877383 ORDER BY `unit` DESC [ RunTime:0.033924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37877383 LIMIT 2 [ RunTime:0.026965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877383 ORDER BY `minOrder` ASC [ RunTime:0.009037s ]
select * from pdf where partno='MMF204DRE3K09' and brandshort='YAGEO' limit 1 [ RunTime:0.016220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF204DRE3K09' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.020956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37877382 LIMIT 5 [ RunTime:0.009264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877382 ORDER BY `minOrder` ASC [ RunTime:0.011596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37877382 ORDER BY `unit` DESC [ RunTime:0.042222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37877382 LIMIT 2 [ RunTime:0.018889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877382 ORDER BY `minOrder` ASC [ RunTime:0.007399s ]
select * from pdf where partno='MMF204DRE3K01' and brandshort='YAGEO' limit 1 [ RunTime:0.012804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF204DRE3K01' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.029001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37877381 LIMIT 5 [ RunTime:0.037201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877381 ORDER BY `minOrder` ASC [ RunTime:0.028191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37877381 ORDER BY `unit` DESC [ RunTime:0.015946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37877381 LIMIT 2 [ RunTime:0.024025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37877381 ORDER BY `minOrder` ASC [ RunTime:0.005273s ]
select * from pdf where partno='MMF204DRE3K' and brandshort='YAGEO' limit 1 [ RunTime:0.026412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF204DRE3K' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.014109s ]
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 'MMF204DRE3K%' OR `brand` LIKE 'MMF204DRE3K%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033453s ]
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 'MMF204DRE3K%' OR `brand` LIKE 'MMF204DRE3K%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.091627s ]
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 'MMF204DRE3K%' OR `brand` LIKE 'MMF204DRE3K%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034901s ]
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 'MMF204DRE3K%' OR `brand` LIKE 'MMF204DRE3K%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053059s ]
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 'MMF204DRE3K%' OR `brand` LIKE 'MMF204DRE3K%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037476s ]
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 'MMF204DRE3K%' OR `brand` LIKE 'MMF204DRE3K%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011189s ]
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 'MMF204DRE3K%' OR `brand` LIKE 'MMF204DRE3K%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041637s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MMF204DRE3K%' OR `brand` LIKE 'MMF204DRE3K%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.024648s ]