SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001098s ]
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 '121KH10%' OR `brand` LIKE '121KH10%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029469s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14846250 LIMIT 5 [ RunTime:0.001935s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14846250 ORDER BY `minOrder` ASC [ RunTime:0.010531s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14846250 ORDER BY `unit` DESC [ RunTime:0.001455s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14846250 LIMIT 2 [ RunTime:0.001772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14846250 ORDER BY `minOrder` ASC [ RunTime:0.005059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14846167 LIMIT 5 [ RunTime:0.005315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14846167 ORDER BY `minOrder` ASC [ RunTime:0.026718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14846167 ORDER BY `unit` DESC [ RunTime:0.022271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14846167 LIMIT 2 [ RunTime:0.010112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14846167 ORDER BY `minOrder` ASC [ RunTime:0.010938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14846166 LIMIT 5 [ RunTime:0.012723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14846166 ORDER BY `minOrder` ASC [ RunTime:0.006102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14846166 ORDER BY `unit` DESC [ RunTime:0.016455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14846166 LIMIT 2 [ RunTime:0.028737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14846166 ORDER BY `minOrder` ASC [ RunTime:0.018046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14845616 LIMIT 5 [ RunTime:0.015552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14845616 ORDER BY `minOrder` ASC [ RunTime:0.025314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14845616 ORDER BY `unit` DESC [ RunTime:0.001310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14845616 LIMIT 2 [ RunTime:0.004477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14845616 ORDER BY `minOrder` ASC [ RunTime:0.005643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14845615 LIMIT 5 [ RunTime:0.008465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14845615 ORDER BY `minOrder` ASC [ RunTime:0.021448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14845615 ORDER BY `unit` DESC [ RunTime:0.063931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14845615 LIMIT 2 [ RunTime:0.023885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14845615 ORDER BY `minOrder` ASC [ RunTime:0.014076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14845597 LIMIT 5 [ RunTime:0.013583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14845597 ORDER BY `minOrder` ASC [ RunTime:0.012914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14845597 ORDER BY `unit` DESC [ RunTime:0.050699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14845597 LIMIT 2 [ RunTime:0.022545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14845597 ORDER BY `minOrder` ASC [ RunTime:0.035475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14845439 LIMIT 5 [ RunTime:0.023215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14845439 ORDER BY `minOrder` ASC [ RunTime:0.051004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14845439 ORDER BY `unit` DESC [ RunTime:0.037673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14845439 LIMIT 2 [ RunTime:0.020534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14845439 ORDER BY `minOrder` ASC [ RunTime:0.039800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14845438 LIMIT 5 [ RunTime:0.118308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14845438 ORDER BY `minOrder` ASC [ RunTime:0.022717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14845438 ORDER BY `unit` DESC [ RunTime:0.016329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14845438 LIMIT 2 [ RunTime:0.039245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14845438 ORDER BY `minOrder` ASC [ RunTime:0.011953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14845433 LIMIT 5 [ RunTime:0.051307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14845433 ORDER BY `minOrder` ASC [ RunTime:0.064167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14845433 ORDER BY `unit` DESC [ RunTime:0.027167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14845433 LIMIT 2 [ RunTime:0.026948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14845433 ORDER BY `minOrder` ASC [ RunTime:0.010141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14834160 LIMIT 5 [ RunTime:0.037751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14834160 ORDER BY `minOrder` ASC [ RunTime:0.013870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14834160 ORDER BY `unit` DESC [ RunTime:0.046807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14834160 LIMIT 2 [ RunTime:0.029771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14834160 ORDER BY `minOrder` ASC [ RunTime:0.003032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13944316 LIMIT 5 [ RunTime:0.009152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13944316 ORDER BY `minOrder` ASC [ RunTime:0.011718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13944316 ORDER BY `unit` DESC [ RunTime:0.029551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13944316 LIMIT 2 [ RunTime:0.026630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13944316 ORDER BY `minOrder` ASC [ RunTime:0.012058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13944315 LIMIT 5 [ RunTime:0.014652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13944315 ORDER BY `minOrder` ASC [ RunTime:0.021634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13944315 ORDER BY `unit` DESC [ RunTime:0.023067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13944315 LIMIT 2 [ RunTime:0.031147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13944315 ORDER BY `minOrder` ASC [ RunTime:0.022731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13944236 LIMIT 5 [ RunTime:0.063220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13944236 ORDER BY `minOrder` ASC [ RunTime:0.066136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13944236 ORDER BY `unit` DESC [ RunTime:0.041683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13944236 LIMIT 2 [ RunTime:0.016513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13944236 ORDER BY `minOrder` ASC [ RunTime:0.021435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13943780 LIMIT 5 [ RunTime:0.024379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13943780 ORDER BY `minOrder` ASC [ RunTime:0.045394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13943780 ORDER BY `unit` DESC [ RunTime:0.018975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13943780 LIMIT 2 [ RunTime:0.059537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13943780 ORDER BY `minOrder` ASC [ RunTime:0.049221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13943761 LIMIT 5 [ RunTime:0.053925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13943761 ORDER BY `minOrder` ASC [ RunTime:0.105678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13943761 ORDER BY `unit` DESC [ RunTime:0.022654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13943761 LIMIT 2 [ RunTime:0.019855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13943761 ORDER BY `minOrder` ASC [ RunTime:0.018672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13943760 LIMIT 5 [ RunTime:0.033313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13943760 ORDER BY `minOrder` ASC [ RunTime:0.081513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13943760 ORDER BY `unit` DESC [ RunTime:0.112601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13943760 LIMIT 2 [ RunTime:0.134303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13943760 ORDER BY `minOrder` ASC [ RunTime:0.046437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13933193 LIMIT 5 [ RunTime:0.081904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13933193 ORDER BY `minOrder` ASC [ RunTime:0.036883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13933193 ORDER BY `unit` DESC [ RunTime:0.077294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13933193 LIMIT 2 [ RunTime:0.063430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13933193 ORDER BY `minOrder` ASC [ RunTime:0.008547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13933192 LIMIT 5 [ RunTime:0.101081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13933192 ORDER BY `minOrder` ASC [ RunTime:0.090693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13933192 ORDER BY `unit` DESC [ RunTime:0.041160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13933192 LIMIT 2 [ RunTime:0.032703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13933192 ORDER BY `minOrder` ASC [ RunTime:0.060457s ]
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 '121KH10%' OR `brand` LIKE '121KH10%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.074605s ]
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 '121KH10%' OR `brand` LIKE '121KH10%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.106605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41821959 LIMIT 5 [ RunTime:0.043182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41821959 ORDER BY `minOrder` ASC [ RunTime:0.051196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41821959 ORDER BY `unit` DESC [ RunTime:0.033656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41821959 LIMIT 2 [ RunTime:0.025049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41821959 ORDER BY `minOrder` ASC [ RunTime:0.032005s ]
select * from pdf where partno='121KH10J-FTB' and brandshort='YAGEO' limit 1 [ RunTime:0.009747s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002495s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121KH10J-FTB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.015110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41821958 LIMIT 5 [ RunTime:0.021675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41821958 ORDER BY `minOrder` ASC [ RunTime:0.001788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41821958 ORDER BY `unit` DESC [ RunTime:0.005858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41821958 LIMIT 2 [ RunTime:0.000661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41821958 ORDER BY `minOrder` ASC [ RunTime:0.012991s ]
select * from pdf where partno='121KH10J-FTR' and brandshort='YAGEO' limit 1 [ RunTime:0.005530s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121KH10J-FTR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.025189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41821957 LIMIT 5 [ RunTime:0.015914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41821957 ORDER BY `minOrder` ASC [ RunTime:0.009176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41821957 ORDER BY `unit` DESC [ RunTime:0.008833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41821957 LIMIT 2 [ RunTime:0.007540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41821957 ORDER BY `minOrder` ASC [ RunTime:0.023405s ]
select * from pdf where partno='121KH10J-OTR' and brandshort='YAGEO' limit 1 [ RunTime:0.007241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121KH10J-OTR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.010645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41821956 LIMIT 5 [ RunTime:0.006691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41821956 ORDER BY `minOrder` ASC [ RunTime:0.001578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41821956 ORDER BY `unit` DESC [ RunTime:0.003178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41821956 LIMIT 2 [ RunTime:0.018416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41821956 ORDER BY `minOrder` ASC [ RunTime:0.009339s ]
select * from pdf where partno='121KH10J-OTB' and brandshort='YAGEO' limit 1 [ RunTime:0.013152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121KH10J-OTB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.007657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41821557 LIMIT 5 [ RunTime:0.003001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41821557 ORDER BY `minOrder` ASC [ RunTime:0.010777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41821557 ORDER BY `unit` DESC [ RunTime:0.010951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41821557 LIMIT 2 [ RunTime:0.006750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41821557 ORDER BY `minOrder` ASC [ RunTime:0.001968s ]
select * from pdf where partno='121KH10-FTR' and brandshort='YAGEO' limit 1 [ RunTime:0.002150s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121KH10-FTR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.015898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41821556 LIMIT 5 [ RunTime:0.005397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41821556 ORDER BY `minOrder` ASC [ RunTime:0.002707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41821556 ORDER BY `unit` DESC [ RunTime:0.002351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41821556 LIMIT 2 [ RunTime:0.000891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41821556 ORDER BY `minOrder` ASC [ RunTime:0.002961s ]
select * from pdf where partno='121KH10-OTR' and brandshort='YAGEO' limit 1 [ RunTime:0.022050s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121KH10-OTR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.007240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41821555 LIMIT 5 [ RunTime:0.014802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41821555 ORDER BY `minOrder` ASC [ RunTime:0.000517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41821555 ORDER BY `unit` DESC [ RunTime:0.000469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41821555 LIMIT 2 [ RunTime:0.000782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41821555 ORDER BY `minOrder` ASC [ RunTime:0.001228s ]
select * from pdf where partno='121KH10-FTB' and brandshort='YAGEO' limit 1 [ RunTime:0.002192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121KH10-FTB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.001473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41821554 LIMIT 5 [ RunTime:0.000651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41821554 ORDER BY `minOrder` ASC [ RunTime:0.002139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41821554 ORDER BY `unit` DESC [ RunTime:0.006385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41821554 LIMIT 2 [ RunTime:0.001395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41821554 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
select * from pdf where partno='121KH10-OTB' and brandshort='YAGEO' limit 1 [ RunTime:0.004774s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121KH10-OTB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.006877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41820737 LIMIT 5 [ RunTime:0.025132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41820737 ORDER BY `minOrder` ASC [ RunTime:0.012855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41820737 ORDER BY `unit` DESC [ RunTime:0.023359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41820737 LIMIT 2 [ RunTime:0.006327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41820737 ORDER BY `minOrder` ASC [ RunTime:0.018838s ]
select * from pdf where partno='121KH10J-TR' and brandshort='YAGEO' limit 1 [ RunTime:0.009967s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121KH10J-TR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.012778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41820736 LIMIT 5 [ RunTime:0.012674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41820736 ORDER BY `minOrder` ASC [ RunTime:0.003358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41820736 ORDER BY `unit` DESC [ RunTime:0.001710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41820736 LIMIT 2 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41820736 ORDER BY `minOrder` ASC [ RunTime:0.001328s ]
select * from pdf where partno='121KH10J-TB' and brandshort='YAGEO' limit 1 [ RunTime:0.010428s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121KH10J-TB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.016662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41820500 LIMIT 5 [ RunTime:0.011323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41820500 ORDER BY `minOrder` ASC [ RunTime:0.015585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41820500 ORDER BY `unit` DESC [ RunTime:0.002204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41820500 LIMIT 2 [ RunTime:0.009089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41820500 ORDER BY `minOrder` ASC [ RunTime:0.004138s ]
select * from pdf where partno='121KH10-TR' and brandshort='YAGEO' limit 1 [ RunTime:0.015471s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121KH10-TR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.015201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41820499 LIMIT 5 [ RunTime:0.003051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41820499 ORDER BY `minOrder` ASC [ RunTime:0.009156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41820499 ORDER BY `unit` DESC [ RunTime:0.002679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41820499 LIMIT 2 [ RunTime:0.002311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41820499 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
select * from pdf where partno='121KH10-TB' and brandshort='YAGEO' limit 1 [ RunTime:0.001071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121KH10-TB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.012042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41819240 LIMIT 5 [ RunTime:0.013834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41819240 ORDER BY `minOrder` ASC [ RunTime:0.006420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41819240 ORDER BY `unit` DESC [ RunTime:0.018609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41819240 LIMIT 2 [ RunTime:0.006703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41819240 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
select * from pdf where partno='121KH10J-O' and brandshort='YAGEO' limit 1 [ RunTime:0.009337s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121KH10J-O' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.029176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41819237 LIMIT 5 [ RunTime:0.016844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41819237 ORDER BY `minOrder` ASC [ RunTime:0.018617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41819237 ORDER BY `unit` DESC [ RunTime:0.051428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41819237 LIMIT 2 [ RunTime:0.033726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41819237 ORDER BY `minOrder` ASC [ RunTime:0.007417s ]
select * from pdf where partno='121KH10J-F' and brandshort='YAGEO' limit 1 [ RunTime:0.017244s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121KH10J-F' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.031362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41819186 LIMIT 5 [ RunTime:0.047783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41819186 ORDER BY `minOrder` ASC [ RunTime:0.060271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41819186 ORDER BY `unit` DESC [ RunTime:0.038716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41819186 LIMIT 2 [ RunTime:0.045636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41819186 ORDER BY `minOrder` ASC [ RunTime:0.016217s ]
select * from pdf where partno='121KH10-O' and brandshort='YAGEO' limit 1 [ RunTime:0.022438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121KH10-O' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.029105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41819185 LIMIT 5 [ RunTime:0.049951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41819185 ORDER BY `minOrder` ASC [ RunTime:0.039716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41819185 ORDER BY `unit` DESC [ RunTime:0.012770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41819185 LIMIT 2 [ RunTime:0.040449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41819185 ORDER BY `minOrder` ASC [ RunTime:0.020641s ]
select * from pdf where partno='121KH10-F' and brandshort='YAGEO' limit 1 [ RunTime:0.052921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121KH10-F' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.024810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41818929 LIMIT 5 [ RunTime:0.021094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41818929 ORDER BY `minOrder` ASC [ RunTime:0.011824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41818929 ORDER BY `unit` DESC [ RunTime:0.043195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41818929 LIMIT 2 [ RunTime:0.018995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41818929 ORDER BY `minOrder` ASC [ RunTime:0.001016s ]
select * from pdf where partno='121KH10J' and brandshort='YAGEO' limit 1 [ RunTime:0.011371s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121KH10J' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.013018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41818742 LIMIT 5 [ RunTime:0.010619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41818742 ORDER BY `minOrder` ASC [ RunTime:0.008380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41818742 ORDER BY `unit` DESC [ RunTime:0.013587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41818742 LIMIT 2 [ RunTime:0.030505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41818742 ORDER BY `minOrder` ASC [ RunTime:0.032397s ]
select * from pdf where partno='121KH10' and brandshort='YAGEO' limit 1 [ RunTime:0.013130s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121KH10' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.012381s ]
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 '121KH10%' OR `brand` LIKE '121KH10%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017401s ]
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 '121KH10%' OR `brand` LIKE '121KH10%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022600s ]
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 '121KH10%' OR `brand` LIKE '121KH10%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040154s ]
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 '121KH10%' OR `brand` LIKE '121KH10%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027507s ]
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 '121KH10%' OR `brand` LIKE '121KH10%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033441s ]
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 '121KH10%' OR `brand` LIKE '121KH10%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047118s ]
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 '121KH10%' OR `brand` LIKE '121KH10%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.068450s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '121KH10%' OR `brand` LIKE '121KH10%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.033606s ]