SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002567s ]
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 '151KD05%' OR `brand` LIKE '151KD05%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034266s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14844961 LIMIT 5 [ RunTime:0.030504s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14844961 ORDER BY `minOrder` ASC [ RunTime:0.027135s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.012092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14844961 ORDER BY `unit` DESC [ RunTime:0.007788s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14844961 LIMIT 2 [ RunTime:0.008207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14844961 ORDER BY `minOrder` ASC [ RunTime:0.016153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14844929 LIMIT 5 [ RunTime:0.032531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14844929 ORDER BY `minOrder` ASC [ RunTime:0.016067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14844929 ORDER BY `unit` DESC [ RunTime:0.028250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14844929 LIMIT 2 [ RunTime:0.052518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14844929 ORDER BY `minOrder` ASC [ RunTime:0.014793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14844602 LIMIT 5 [ RunTime:0.012332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14844602 ORDER BY `minOrder` ASC [ RunTime:0.032787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14844602 ORDER BY `unit` DESC [ RunTime:0.021788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14844602 LIMIT 2 [ RunTime:0.010569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14844602 ORDER BY `minOrder` ASC [ RunTime:0.011310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14844550 LIMIT 5 [ RunTime:0.017722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14844550 ORDER BY `minOrder` ASC [ RunTime:0.018175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14844550 ORDER BY `unit` DESC [ RunTime:0.013929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14844550 LIMIT 2 [ RunTime:0.014876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14844550 ORDER BY `minOrder` ASC [ RunTime:0.004037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14844374 LIMIT 5 [ RunTime:0.006902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14844374 ORDER BY `minOrder` ASC [ RunTime:0.007035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14844374 ORDER BY `unit` DESC [ RunTime:0.013977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14844374 LIMIT 2 [ RunTime:0.007724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14844374 ORDER BY `minOrder` ASC [ RunTime:0.001345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14844348 LIMIT 5 [ RunTime:0.001691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14844348 ORDER BY `minOrder` ASC [ RunTime:0.002294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14844348 ORDER BY `unit` DESC [ RunTime:0.006344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14844348 LIMIT 2 [ RunTime:0.004581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14844348 ORDER BY `minOrder` ASC [ RunTime:0.012464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14843674 LIMIT 5 [ RunTime:0.009334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14843674 ORDER BY `minOrder` ASC [ RunTime:0.014207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14843674 ORDER BY `unit` DESC [ RunTime:0.005898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14843674 LIMIT 2 [ RunTime:0.007615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14843674 ORDER BY `minOrder` ASC [ RunTime:0.014412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14843665 LIMIT 5 [ RunTime:0.008282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14843665 ORDER BY `minOrder` ASC [ RunTime:0.005319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14843665 ORDER BY `unit` DESC [ RunTime:0.002795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14843665 LIMIT 2 [ RunTime:0.003213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14843665 ORDER BY `minOrder` ASC [ RunTime:0.003453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14843542 LIMIT 5 [ RunTime:0.001103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14843542 ORDER BY `minOrder` ASC [ RunTime:0.003043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14843542 ORDER BY `unit` DESC [ RunTime:0.002324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14843542 LIMIT 2 [ RunTime:0.019274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14843542 ORDER BY `minOrder` ASC [ RunTime:0.014350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14843535 LIMIT 5 [ RunTime:0.016143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14843535 ORDER BY `minOrder` ASC [ RunTime:0.004615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14843535 ORDER BY `unit` DESC [ RunTime:0.015692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14843535 LIMIT 2 [ RunTime:0.006402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14843535 ORDER BY `minOrder` ASC [ RunTime:0.004295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14843532 LIMIT 5 [ RunTime:0.007120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14843532 ORDER BY `minOrder` ASC [ RunTime:0.004318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14843532 ORDER BY `unit` DESC [ RunTime:0.010835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14843532 LIMIT 2 [ RunTime:0.023085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14843532 ORDER BY `minOrder` ASC [ RunTime:0.015203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14843440 LIMIT 5 [ RunTime:0.001011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14843440 ORDER BY `minOrder` ASC [ RunTime:0.010497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14843440 ORDER BY `unit` DESC [ RunTime:0.006226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14843440 LIMIT 2 [ RunTime:0.001443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14843440 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14843439 LIMIT 5 [ RunTime:0.004083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14843439 ORDER BY `minOrder` ASC [ RunTime:0.016423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14843439 ORDER BY `unit` DESC [ RunTime:0.005621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14843439 LIMIT 2 [ RunTime:0.002808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14843439 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14843435 LIMIT 5 [ RunTime:0.000839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14843435 ORDER BY `minOrder` ASC [ RunTime:0.007562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14843435 ORDER BY `unit` DESC [ RunTime:0.007135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14843435 LIMIT 2 [ RunTime:0.001510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14843435 ORDER BY `minOrder` ASC [ RunTime:0.006859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13943203 LIMIT 5 [ RunTime:0.002548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13943203 ORDER BY `minOrder` ASC [ RunTime:0.005643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13943203 ORDER BY `unit` DESC [ RunTime:0.009311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13943203 LIMIT 2 [ RunTime:0.001235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13943203 ORDER BY `minOrder` ASC [ RunTime:0.001114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13942830 LIMIT 5 [ RunTime:0.001494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13942830 ORDER BY `minOrder` ASC [ RunTime:0.001009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13942830 ORDER BY `unit` DESC [ RunTime:0.006197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13942830 LIMIT 2 [ RunTime:0.005110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13942830 ORDER BY `minOrder` ASC [ RunTime:0.000576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13942682 LIMIT 5 [ RunTime:0.002420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13942682 ORDER BY `minOrder` ASC [ RunTime:0.002384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13942682 ORDER BY `unit` DESC [ RunTime:0.008103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13942682 LIMIT 2 [ RunTime:0.002747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13942682 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13942093 LIMIT 5 [ RunTime:0.003085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13942093 ORDER BY `minOrder` ASC [ RunTime:0.000840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13942093 ORDER BY `unit` DESC [ RunTime:0.008246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13942093 LIMIT 2 [ RunTime:0.003445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13942093 ORDER BY `minOrder` ASC [ RunTime:0.000536s ]
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 '151KD05%' OR `brand` LIKE '151KD05%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006755s ]
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 '151KD05%' OR `brand` LIKE '151KD05%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41813081 LIMIT 5 [ RunTime:0.001902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41813081 ORDER BY `minOrder` ASC [ RunTime:0.003589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41813081 ORDER BY `unit` DESC [ RunTime:0.010835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41813081 LIMIT 2 [ RunTime:0.003304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41813081 ORDER BY `minOrder` ASC [ RunTime:0.003122s ]
select * from pdf where partno='151KD05J-OTR' and brandshort='YAGEO' limit 1 [ RunTime:0.002017s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002021s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151KD05J-OTR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.003915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41813079 LIMIT 5 [ RunTime:0.000781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41813079 ORDER BY `minOrder` ASC [ RunTime:0.000610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41813079 ORDER BY `unit` DESC [ RunTime:0.005899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41813079 LIMIT 2 [ RunTime:0.004421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41813079 ORDER BY `minOrder` ASC [ RunTime:0.001230s ]
select * from pdf where partno='151KD05J-FTR' and brandshort='YAGEO' limit 1 [ RunTime:0.003226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151KD05J-FTR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.002741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41813075 LIMIT 5 [ RunTime:0.001773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41813075 ORDER BY `minOrder` ASC [ RunTime:0.000702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41813075 ORDER BY `unit` DESC [ RunTime:0.008760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41813075 LIMIT 2 [ RunTime:0.005172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41813075 ORDER BY `minOrder` ASC [ RunTime:0.001689s ]
select * from pdf where partno='151KD05J-OTB' and brandshort='YAGEO' limit 1 [ RunTime:0.000739s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151KD05J-OTB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.003069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41813074 LIMIT 5 [ RunTime:0.005394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41813074 ORDER BY `minOrder` ASC [ RunTime:0.003446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41813074 ORDER BY `unit` DESC [ RunTime:0.008095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41813074 LIMIT 2 [ RunTime:0.003565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41813074 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
select * from pdf where partno='151KD05J-FTB' and brandshort='YAGEO' limit 1 [ RunTime:0.000695s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151KD05J-FTB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.005477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41812661 LIMIT 5 [ RunTime:0.002970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41812661 ORDER BY `minOrder` ASC [ RunTime:0.000697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41812661 ORDER BY `unit` DESC [ RunTime:0.008057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41812661 LIMIT 2 [ RunTime:0.000893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41812661 ORDER BY `minOrder` ASC [ RunTime:0.003680s ]
select * from pdf where partno='151KD05J-TR' and brandshort='YAGEO' limit 1 [ RunTime:0.001422s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151KD05J-TR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.009719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41812647 LIMIT 5 [ RunTime:0.002775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41812647 ORDER BY `minOrder` ASC [ RunTime:0.002721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41812647 ORDER BY `unit` DESC [ RunTime:0.005490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41812647 LIMIT 2 [ RunTime:0.002077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41812647 ORDER BY `minOrder` ASC [ RunTime:0.002121s ]
select * from pdf where partno='151KD05J-TB' and brandshort='YAGEO' limit 1 [ RunTime:0.003151s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151KD05J-TB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.003568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41812646 LIMIT 5 [ RunTime:0.010169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41812646 ORDER BY `minOrder` ASC [ RunTime:0.006517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41812646 ORDER BY `unit` DESC [ RunTime:0.002791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41812646 LIMIT 2 [ RunTime:0.006080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41812646 ORDER BY `minOrder` ASC [ RunTime:0.002830s ]
select * from pdf where partno='151KD05J-O' and brandshort='YAGEO' limit 1 [ RunTime:0.002805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151KD05J-O' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.003795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41812543 LIMIT 5 [ RunTime:0.008847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41812543 ORDER BY `minOrder` ASC [ RunTime:0.020408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41812543 ORDER BY `unit` DESC [ RunTime:0.008329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41812543 LIMIT 2 [ RunTime:0.014814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41812543 ORDER BY `minOrder` ASC [ RunTime:0.005960s ]
select * from pdf where partno='151KD05J-F' and brandshort='YAGEO' limit 1 [ RunTime:0.008414s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151KD05J-F' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.013653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41812529 LIMIT 5 [ RunTime:0.008453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41812529 ORDER BY `minOrder` ASC [ RunTime:0.006765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41812529 ORDER BY `unit` DESC [ RunTime:0.008870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41812529 LIMIT 2 [ RunTime:0.010471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41812529 ORDER BY `minOrder` ASC [ RunTime:0.001860s ]
select * from pdf where partno='151KD05J' and brandshort='YAGEO' limit 1 [ RunTime:0.006447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151KD05J' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.008452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41810198 LIMIT 5 [ RunTime:0.011846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41810198 ORDER BY `minOrder` ASC [ RunTime:0.003642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41810198 ORDER BY `unit` DESC [ RunTime:0.001172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41810198 LIMIT 2 [ RunTime:0.006018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41810198 ORDER BY `minOrder` ASC [ RunTime:0.002462s ]
select * from pdf where partno='151KD05-OTB' and brandshort='YAGEO' limit 1 [ RunTime:0.005065s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151KD05-OTB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.008185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41810191 LIMIT 5 [ RunTime:0.006258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41810191 ORDER BY `minOrder` ASC [ RunTime:0.003410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41810191 ORDER BY `unit` DESC [ RunTime:0.004098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41810191 LIMIT 2 [ RunTime:0.008951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41810191 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='151KD05-FTR' and brandshort='YAGEO' limit 1 [ RunTime:0.015219s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151KD05-FTR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.012506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41810182 LIMIT 5 [ RunTime:0.004457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41810182 ORDER BY `minOrder` ASC [ RunTime:0.002316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41810182 ORDER BY `unit` DESC [ RunTime:0.001335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41810182 LIMIT 2 [ RunTime:0.000738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41810182 ORDER BY `minOrder` ASC [ RunTime:0.000844s ]
select * from pdf where partno='151KD05-FTB' and brandshort='YAGEO' limit 1 [ RunTime:0.001023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151KD05-FTB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.004420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41810181 LIMIT 5 [ RunTime:0.000652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41810181 ORDER BY `minOrder` ASC [ RunTime:0.000656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41810181 ORDER BY `unit` DESC [ RunTime:0.002355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41810181 LIMIT 2 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41810181 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
select * from pdf where partno='151KD05-OTR' and brandshort='YAGEO' limit 1 [ RunTime:0.000930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151KD05-OTR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.004500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41810032 LIMIT 5 [ RunTime:0.000837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41810032 ORDER BY `minOrder` ASC [ RunTime:0.000887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41810032 ORDER BY `unit` DESC [ RunTime:0.002756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41810032 LIMIT 2 [ RunTime:0.007453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41810032 ORDER BY `minOrder` ASC [ RunTime:0.004703s ]
select * from pdf where partno='151KD05-TB' and brandshort='YAGEO' limit 1 [ RunTime:0.001042s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151KD05-TB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.009691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41810030 LIMIT 5 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41810030 ORDER BY `minOrder` ASC [ RunTime:0.002557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41810030 ORDER BY `unit` DESC [ RunTime:0.000611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41810030 LIMIT 2 [ RunTime:0.012769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41810030 ORDER BY `minOrder` ASC [ RunTime:0.005956s ]
select * from pdf where partno='151KD05-TR' and brandshort='YAGEO' limit 1 [ RunTime:0.004822s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151KD05-TR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.006588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41809999 LIMIT 5 [ RunTime:0.003815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41809999 ORDER BY `minOrder` ASC [ RunTime:0.001599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41809999 ORDER BY `unit` DESC [ RunTime:0.008875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41809999 LIMIT 2 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41809999 ORDER BY `minOrder` ASC [ RunTime:0.001561s ]
select * from pdf where partno='151KD05-F' and brandshort='YAGEO' limit 1 [ RunTime:0.001239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151KD05-F' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.004546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41809994 LIMIT 5 [ RunTime:0.000650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41809994 ORDER BY `minOrder` ASC [ RunTime:0.003428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41809994 ORDER BY `unit` DESC [ RunTime:0.001602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41809994 LIMIT 2 [ RunTime:0.001153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41809994 ORDER BY `minOrder` ASC [ RunTime:0.003693s ]
select * from pdf where partno='151KD05-O' and brandshort='YAGEO' limit 1 [ RunTime:0.009887s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151KD05-O' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.004682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41809973 LIMIT 5 [ RunTime:0.000668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41809973 ORDER BY `minOrder` ASC [ RunTime:0.007834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41809973 ORDER BY `unit` DESC [ RunTime:0.001011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41809973 LIMIT 2 [ RunTime:0.000670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41809973 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
select * from pdf where partno='151KD05' and brandshort='YAGEO' limit 1 [ RunTime:0.000940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '151KD05' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.004392s ]
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 '151KD05%' OR `brand` LIKE '151KD05%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010876s ]
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 '151KD05%' OR `brand` LIKE '151KD05%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001569s ]
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 '151KD05%' OR `brand` LIKE '151KD05%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005445s ]
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 '151KD05%' OR `brand` LIKE '151KD05%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014883s ]
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 '151KD05%' OR `brand` LIKE '151KD05%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003236s ]
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 '151KD05%' OR `brand` LIKE '151KD05%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007051s ]
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 '151KD05%' OR `brand` LIKE '151KD05%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004887s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '151KD05%' OR `brand` LIKE '151KD05%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007119s ]