SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002630s ]
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 'MMF-25FRE2K%' OR `brand` LIKE 'MMF-25FRE2K%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019105s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18066188 LIMIT 5 [ RunTime:0.000746s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066188 ORDER BY `minOrder` ASC [ RunTime:0.014348s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18066188 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18066188 LIMIT 2 [ RunTime:0.007948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066188 ORDER BY `minOrder` ASC [ RunTime:0.017087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18066187 LIMIT 5 [ RunTime:0.000474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066187 ORDER BY `minOrder` ASC [ RunTime:0.012161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18066187 ORDER BY `unit` DESC [ RunTime:0.004842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18066187 LIMIT 2 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066187 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18066186 LIMIT 5 [ RunTime:0.000618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066186 ORDER BY `minOrder` ASC [ RunTime:0.006734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18066186 ORDER BY `unit` DESC [ RunTime:0.004660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18066186 LIMIT 2 [ RunTime:0.003757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066186 ORDER BY `minOrder` ASC [ RunTime:0.003243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18066185 LIMIT 5 [ RunTime:0.000449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066185 ORDER BY `minOrder` ASC [ RunTime:0.004995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18066185 ORDER BY `unit` DESC [ RunTime:0.008523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18066185 LIMIT 2 [ RunTime:0.000669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066185 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18066184 LIMIT 5 [ RunTime:0.000642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066184 ORDER BY `minOrder` ASC [ RunTime:0.014472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18066184 ORDER BY `unit` DESC [ RunTime:0.007392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18066184 LIMIT 2 [ RunTime:0.000833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066184 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18066183 LIMIT 5 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066183 ORDER BY `minOrder` ASC [ RunTime:0.000655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18066183 ORDER BY `unit` DESC [ RunTime:0.006678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18066183 LIMIT 2 [ RunTime:0.000943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066183 ORDER BY `minOrder` ASC [ RunTime:0.000528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18066182 LIMIT 5 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066182 ORDER BY `minOrder` ASC [ RunTime:0.000546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18066182 ORDER BY `unit` DESC [ RunTime:0.005480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18066182 LIMIT 2 [ RunTime:0.000533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066182 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18066181 LIMIT 5 [ RunTime:0.000501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066181 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18066181 ORDER BY `unit` DESC [ RunTime:0.005277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18066181 LIMIT 2 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066181 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18066180 LIMIT 5 [ RunTime:0.000461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066180 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18066180 ORDER BY `unit` DESC [ RunTime:0.005481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18066180 LIMIT 2 [ RunTime:0.000714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066180 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18066179 LIMIT 5 [ RunTime:0.000431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066179 ORDER BY `minOrder` ASC [ RunTime:0.000493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18066179 ORDER BY `unit` DESC [ RunTime:0.005357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18066179 LIMIT 2 [ RunTime:0.000760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066179 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18066178 LIMIT 5 [ RunTime:0.000510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066178 ORDER BY `minOrder` ASC [ RunTime:0.000481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18066178 ORDER BY `unit` DESC [ RunTime:0.005649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18066178 LIMIT 2 [ RunTime:0.000755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18066178 ORDER BY `minOrder` ASC [ RunTime:0.000340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16834025 LIMIT 5 [ RunTime:0.000891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16834025 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16834025 ORDER BY `unit` DESC [ RunTime:0.007536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16834025 LIMIT 2 [ RunTime:0.000932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16834025 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16834024 LIMIT 5 [ RunTime:0.000462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16834024 ORDER BY `minOrder` ASC [ RunTime:0.001997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16834024 ORDER BY `unit` DESC [ RunTime:0.010366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16834024 LIMIT 2 [ RunTime:0.002717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16834024 ORDER BY `minOrder` ASC [ RunTime:0.000526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16834023 LIMIT 5 [ RunTime:0.002289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16834023 ORDER BY `minOrder` ASC [ RunTime:0.004133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16834023 ORDER BY `unit` DESC [ RunTime:0.007352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16834023 LIMIT 2 [ RunTime:0.001784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16834023 ORDER BY `minOrder` ASC [ RunTime:0.002385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15725563 LIMIT 5 [ RunTime:0.001115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15725563 ORDER BY `minOrder` ASC [ RunTime:0.000670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15725563 ORDER BY `unit` DESC [ RunTime:0.008410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15725563 LIMIT 2 [ RunTime:0.002308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15725563 ORDER BY `minOrder` ASC [ RunTime:0.000658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15725562 LIMIT 5 [ RunTime:0.000539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15725562 ORDER BY `minOrder` ASC [ RunTime:0.000616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15725562 ORDER BY `unit` DESC [ RunTime:0.000462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15725562 LIMIT 2 [ RunTime:0.001160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15725562 ORDER BY `minOrder` ASC [ RunTime:0.000967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15725561 LIMIT 5 [ RunTime:0.000425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15725561 ORDER BY `minOrder` ASC [ RunTime:0.000688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15725561 ORDER BY `unit` DESC [ RunTime:0.000490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15725561 LIMIT 2 [ RunTime:0.001138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15725561 ORDER BY `minOrder` ASC [ RunTime:0.001559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15725560 LIMIT 5 [ RunTime:0.000442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15725560 ORDER BY `minOrder` ASC [ RunTime:0.000866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15725560 ORDER BY `unit` DESC [ RunTime:0.000442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15725560 LIMIT 2 [ RunTime:0.001051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15725560 ORDER BY `minOrder` ASC [ RunTime:0.001236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15725559 LIMIT 5 [ RunTime:0.000435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15725559 ORDER BY `minOrder` ASC [ RunTime:0.000907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15725559 ORDER BY `unit` DESC [ RunTime:0.000413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15725559 LIMIT 2 [ RunTime:0.000960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15725559 ORDER BY `minOrder` ASC [ RunTime:0.001356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14099818 LIMIT 5 [ RunTime:0.000737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14099818 ORDER BY `minOrder` ASC [ RunTime:0.000827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14099818 ORDER BY `unit` DESC [ RunTime:0.002782s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14099818 LIMIT 2 [ RunTime:0.000913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14099818 ORDER BY `minOrder` ASC [ RunTime:0.001911s ]
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 'MMF-25FRE2K%' OR `brand` LIKE 'MMF-25FRE2K%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000805s ]
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 'MMF-25FRE2K%' OR `brand` LIKE 'MMF-25FRE2K%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34194397 LIMIT 5 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194397 ORDER BY `minOrder` ASC [ RunTime:0.003058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34194397 ORDER BY `unit` DESC [ RunTime:0.003093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34194397 LIMIT 2 [ RunTime:0.002165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194397 ORDER BY `minOrder` ASC [ RunTime:0.002848s ]
select * from pdf where partno='MMF-25FRE2K94' and brandshort='YAGEO' limit 1 [ RunTime:0.001622s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002490s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF-25FRE2K94' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.006353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34194396 LIMIT 5 [ RunTime:0.007935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194396 ORDER BY `minOrder` ASC [ RunTime:0.007209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34194396 ORDER BY `unit` DESC [ RunTime:0.000286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34194396 LIMIT 2 [ RunTime:0.001934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194396 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
select * from pdf where partno='MMF-25FRE2K87' and brandshort='YAGEO' limit 1 [ RunTime:0.000911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF-25FRE2K87' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.006530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34194395 LIMIT 5 [ RunTime:0.002998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194395 ORDER BY `minOrder` ASC [ RunTime:0.003471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34194395 ORDER BY `unit` DESC [ RunTime:0.000625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34194395 LIMIT 2 [ RunTime:0.001858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194395 ORDER BY `minOrder` ASC [ RunTime:0.003366s ]
select * from pdf where partno='MMF-25FRE2K8' and brandshort='YAGEO' limit 1 [ RunTime:0.000849s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF-25FRE2K8' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.011870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34194195 LIMIT 5 [ RunTime:0.008206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194195 ORDER BY `minOrder` ASC [ RunTime:0.007234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34194195 ORDER BY `unit` DESC [ RunTime:0.000772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34194195 LIMIT 2 [ RunTime:0.001581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194195 ORDER BY `minOrder` ASC [ RunTime:0.005371s ]
select * from pdf where partno='MMF-25FRE2K74' and brandshort='YAGEO' limit 1 [ RunTime:0.001317s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF-25FRE2K74' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.006432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34194194 LIMIT 5 [ RunTime:0.015899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194194 ORDER BY `minOrder` ASC [ RunTime:0.011626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34194194 ORDER BY `unit` DESC [ RunTime:0.005553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34194194 LIMIT 2 [ RunTime:0.001483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194194 ORDER BY `minOrder` ASC [ RunTime:0.002303s ]
select * from pdf where partno='MMF-25FRE2K7' and brandshort='YAGEO' limit 1 [ RunTime:0.006279s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF-25FRE2K7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.009746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34194193 LIMIT 5 [ RunTime:0.007406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194193 ORDER BY `minOrder` ASC [ RunTime:0.001053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34194193 ORDER BY `unit` DESC [ RunTime:0.002630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34194193 LIMIT 2 [ RunTime:0.002613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194193 ORDER BY `minOrder` ASC [ RunTime:0.001733s ]
select * from pdf where partno='MMF-25FRE2K67' and brandshort='YAGEO' limit 1 [ RunTime:0.000849s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF-25FRE2K67' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.011083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34194192 LIMIT 5 [ RunTime:0.003196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194192 ORDER BY `minOrder` ASC [ RunTime:0.007402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34194192 ORDER BY `unit` DESC [ RunTime:0.002659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34194192 LIMIT 2 [ RunTime:0.002609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194192 ORDER BY `minOrder` ASC [ RunTime:0.000323s ]
select * from pdf where partno='MMF-25FRE2K61' and brandshort='YAGEO' limit 1 [ RunTime:0.000870s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF-25FRE2K61' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.001951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34194191 LIMIT 5 [ RunTime:0.000365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194191 ORDER BY `minOrder` ASC [ RunTime:0.004787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34194191 ORDER BY `unit` DESC [ RunTime:0.001150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34194191 LIMIT 2 [ RunTime:0.000424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194191 ORDER BY `minOrder` ASC [ RunTime:0.002791s ]
select * from pdf where partno='MMF-25FRE2K55' and brandshort='YAGEO' limit 1 [ RunTime:0.000842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF-25FRE2K55' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.002217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34194190 LIMIT 5 [ RunTime:0.004859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194190 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34194190 ORDER BY `unit` DESC [ RunTime:0.002429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34194190 LIMIT 2 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194190 ORDER BY `minOrder` ASC [ RunTime:0.000272s ]
select * from pdf where partno='MMF-25FRE2K49' and brandshort='YAGEO' limit 1 [ RunTime:0.000884s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF-25FRE2K49' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.002464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34194189 LIMIT 5 [ RunTime:0.000375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194189 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34194189 ORDER BY `unit` DESC [ RunTime:0.001253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34194189 LIMIT 2 [ RunTime:0.003221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194189 ORDER BY `minOrder` ASC [ RunTime:0.000287s ]
select * from pdf where partno='MMF-25FRE2K43' and brandshort='YAGEO' limit 1 [ RunTime:0.000946s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF-25FRE2K43' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.002150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34194188 LIMIT 5 [ RunTime:0.000925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194188 ORDER BY `minOrder` ASC [ RunTime:0.001305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34194188 ORDER BY `unit` DESC [ RunTime:0.001843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34194188 LIMIT 2 [ RunTime:0.004995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194188 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
select * from pdf where partno='MMF-25FRE2K4' and brandshort='YAGEO' limit 1 [ RunTime:0.000818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF-25FRE2K4' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.006494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34194187 LIMIT 5 [ RunTime:0.000692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194187 ORDER BY `minOrder` ASC [ RunTime:0.001822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34194187 ORDER BY `unit` DESC [ RunTime:0.001421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34194187 LIMIT 2 [ RunTime:0.005397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194187 ORDER BY `minOrder` ASC [ RunTime:0.001066s ]
select * from pdf where partno='MMF-25FRE2K37' and brandshort='YAGEO' limit 1 [ RunTime:0.001038s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF-25FRE2K37' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.006459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34194186 LIMIT 5 [ RunTime:0.000557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194186 ORDER BY `minOrder` ASC [ RunTime:0.001975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34194186 ORDER BY `unit` DESC [ RunTime:0.001179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34194186 LIMIT 2 [ RunTime:0.005793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194186 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
select * from pdf where partno='MMF-25FRE2K32' and brandshort='YAGEO' limit 1 [ RunTime:0.001171s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF-25FRE2K32' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.004574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34194185 LIMIT 5 [ RunTime:0.002196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194185 ORDER BY `minOrder` ASC [ RunTime:0.000727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34194185 ORDER BY `unit` DESC [ RunTime:0.006112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34194185 LIMIT 2 [ RunTime:0.000605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194185 ORDER BY `minOrder` ASC [ RunTime:0.001997s ]
select * from pdf where partno='MMF-25FRE2K26' and brandshort='YAGEO' limit 1 [ RunTime:0.000888s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF-25FRE2K26' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.004274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34194184 LIMIT 5 [ RunTime:0.001813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194184 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34194184 ORDER BY `unit` DESC [ RunTime:0.004985s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34194184 LIMIT 2 [ RunTime:0.003157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194184 ORDER BY `minOrder` ASC [ RunTime:0.000636s ]
select * from pdf where partno='MMF-25FRE2K21' and brandshort='YAGEO' limit 1 [ RunTime:0.000867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF-25FRE2K21' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.003414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34194183 LIMIT 5 [ RunTime:0.000430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194183 ORDER BY `minOrder` ASC [ RunTime:0.001882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34194183 ORDER BY `unit` DESC [ RunTime:0.001266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34194183 LIMIT 2 [ RunTime:0.003603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194183 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
select * from pdf where partno='MMF-25FRE2K2' and brandshort='YAGEO' limit 1 [ RunTime:0.001419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF-25FRE2K2' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.002474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34194182 LIMIT 5 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194182 ORDER BY `minOrder` ASC [ RunTime:0.001466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34194182 ORDER BY `unit` DESC [ RunTime:0.001803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34194182 LIMIT 2 [ RunTime:0.000335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194182 ORDER BY `minOrder` ASC [ RunTime:0.002918s ]
select * from pdf where partno='MMF-25FRE2K15' and brandshort='YAGEO' limit 1 [ RunTime:0.001260s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF-25FRE2K15' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.002093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34194181 LIMIT 5 [ RunTime:0.000501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194181 ORDER BY `minOrder` ASC [ RunTime:0.006570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34194181 ORDER BY `unit` DESC [ RunTime:0.000358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34194181 LIMIT 2 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194181 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
select * from pdf where partno='MMF-25FRE2K1' and brandshort='YAGEO' limit 1 [ RunTime:0.006536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF-25FRE2K1' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.003374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34194180 LIMIT 5 [ RunTime:0.001453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194180 ORDER BY `minOrder` ASC [ RunTime:0.013633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34194180 ORDER BY `unit` DESC [ RunTime:0.005258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34194180 LIMIT 2 [ RunTime:0.001101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194180 ORDER BY `minOrder` ASC [ RunTime:0.000809s ]
select * from pdf where partno='MMF-25FRE2K05' and brandshort='YAGEO' limit 1 [ RunTime:0.000948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF-25FRE2K05' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.004501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34194179 LIMIT 5 [ RunTime:0.002755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194179 ORDER BY `minOrder` ASC [ RunTime:0.003165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34194179 ORDER BY `unit` DESC [ RunTime:0.000641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34194179 LIMIT 2 [ RunTime:0.000589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34194179 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
select * from pdf where partno='MMF-25FRE2K' and brandshort='YAGEO' limit 1 [ RunTime:0.001035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMF-25FRE2K' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.012019s ]
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 'MMF-25FRE2K%' OR `brand` LIKE 'MMF-25FRE2K%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005235s ]
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 'MMF-25FRE2K%' OR `brand` LIKE 'MMF-25FRE2K%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004381s ]
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 'MMF-25FRE2K%' OR `brand` LIKE 'MMF-25FRE2K%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001753s ]
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 'MMF-25FRE2K%' OR `brand` LIKE 'MMF-25FRE2K%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005620s ]
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 'MMF-25FRE2K%' OR `brand` LIKE 'MMF-25FRE2K%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004225s ]
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 'MMF-25FRE2K%' OR `brand` LIKE 'MMF-25FRE2K%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003985s ]
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 'MMF-25FRE2K%' OR `brand` LIKE 'MMF-25FRE2K%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016840s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MMF-25FRE2K%' OR `brand` LIKE 'MMF-25FRE2K%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.029408s ]