SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001333s ]
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 'MD212S-03%' OR `brand` LIKE 'MD212S-03%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045453s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14766427 LIMIT 5 [ RunTime:0.016739s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14766427 ORDER BY `minOrder` ASC [ RunTime:0.008990s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14766427 ORDER BY `unit` DESC [ RunTime:0.021907s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14766427 LIMIT 2 [ RunTime:0.006678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14766427 ORDER BY `minOrder` ASC [ RunTime:0.020511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13874015 LIMIT 5 [ RunTime:0.009829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13874015 ORDER BY `minOrder` ASC [ RunTime:0.018696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13874015 ORDER BY `unit` DESC [ RunTime:0.048577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13874015 LIMIT 2 [ RunTime:0.026227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13874015 ORDER BY `minOrder` ASC [ RunTime:0.003991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14770797 LIMIT 5 [ RunTime:0.025513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14770797 ORDER BY `minOrder` ASC [ RunTime:0.016693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14770797 ORDER BY `unit` DESC [ RunTime:0.057046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14770797 LIMIT 2 [ RunTime:0.050844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14770797 ORDER BY `minOrder` ASC [ RunTime:0.015248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14768598 LIMIT 5 [ RunTime:0.037223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14768598 ORDER BY `minOrder` ASC [ RunTime:0.018343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14768598 ORDER BY `unit` DESC [ RunTime:0.027888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14768598 LIMIT 2 [ RunTime:0.015933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14768598 ORDER BY `minOrder` ASC [ RunTime:0.011218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14766808 LIMIT 5 [ RunTime:0.020288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14766808 ORDER BY `minOrder` ASC [ RunTime:0.003429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14766808 ORDER BY `unit` DESC [ RunTime:0.011880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14766808 LIMIT 2 [ RunTime:0.011668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14766808 ORDER BY `minOrder` ASC [ RunTime:0.019096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13880192 LIMIT 5 [ RunTime:0.027855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13880192 ORDER BY `minOrder` ASC [ RunTime:0.014447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13880192 ORDER BY `unit` DESC [ RunTime:0.020534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13880192 LIMIT 2 [ RunTime:0.017332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13880192 ORDER BY `minOrder` ASC [ RunTime:0.021971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13875916 LIMIT 5 [ RunTime:0.029540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13875916 ORDER BY `minOrder` ASC [ RunTime:0.005979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13875916 ORDER BY `unit` DESC [ RunTime:0.006656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13875916 LIMIT 2 [ RunTime:0.021643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13875916 ORDER BY `minOrder` ASC [ RunTime:0.006188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13875910 LIMIT 5 [ RunTime:0.011972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13875910 ORDER BY `minOrder` ASC [ RunTime:0.022089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13875910 ORDER BY `unit` DESC [ RunTime:0.023869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13875910 LIMIT 2 [ RunTime:0.006786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13875910 ORDER BY `minOrder` ASC [ RunTime:0.002082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13874178 LIMIT 5 [ RunTime:0.017507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13874178 ORDER BY `minOrder` ASC [ RunTime:0.015401s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13874178 ORDER BY `unit` DESC [ RunTime:0.001607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13874178 LIMIT 2 [ RunTime:0.004073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13874178 ORDER BY `minOrder` ASC [ RunTime:0.001767s ]
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 'MD212S-03%' OR `brand` LIKE 'MD212S-03%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011090s ]
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 'MD212S-03%' OR `brand` LIKE 'MD212S-03%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64325882 LIMIT 5 [ RunTime:0.022940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64325882 ORDER BY `minOrder` ASC [ RunTime:0.009723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64325882 ORDER BY `unit` DESC [ RunTime:0.020966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64325882 LIMIT 2 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64325882 ORDER BY `minOrder` ASC [ RunTime:0.018802s ]
select * from pdf where partno='MD212S-03BI' and brandshort='MicroPower Direct' limit 1 [ RunTime:0.013501s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001481s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MD212S-03BI' OR `brand` LIKE 'MicroPower Direct%' ) ) LIMIT 1 [ RunTime:0.012450s ]
SELECT `id` FROM `stock` WHERE `id` <> 64325882 AND `partno` = 'MD212S-03BI' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%micropower direct%' ) [ RunTime:0.017226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13874015 [ RunTime:0.015366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64325113 LIMIT 5 [ RunTime:0.000751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64325113 ORDER BY `minOrder` ASC [ RunTime:0.002247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64325113 ORDER BY `unit` DESC [ RunTime:0.005166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64325113 LIMIT 2 [ RunTime:0.021708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64325113 ORDER BY `minOrder` ASC [ RunTime:0.005593s ]
select * from pdf where partno='MD212S-03B' and brandshort='MicroPower Direct' limit 1 [ RunTime:0.004993s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MD212S-03B' OR `brand` LIKE 'MicroPower Direct%' ) ) LIMIT 1 [ RunTime:0.003855s ]
SELECT `id` FROM `stock` WHERE `id` <> 64325113 AND `partno` = 'MD212S-03B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%micropower direct%' ) [ RunTime:0.006825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14766427 [ RunTime:0.031521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64341708 LIMIT 5 [ RunTime:0.016052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64341708 ORDER BY `minOrder` ASC [ RunTime:0.010035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64341708 ORDER BY `unit` DESC [ RunTime:0.006316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64341708 LIMIT 2 [ RunTime:0.007863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64341708 ORDER BY `minOrder` ASC [ RunTime:0.008899s ]
select * from pdf where partno='MD212S-03RU' and brandshort='MicroPower Direct' limit 1 [ RunTime:0.004712s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MD212S-03RU' OR `brand` LIKE 'MicroPower Direct%' ) ) LIMIT 1 [ RunTime:0.009560s ]
SELECT `id` FROM `stock` WHERE `id` <> 64341708 AND `partno` = 'MD212S-03RU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%micropower direct%' ) [ RunTime:0.001895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13880192 [ RunTime:0.000777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64335483 LIMIT 5 [ RunTime:0.024283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64335483 ORDER BY `minOrder` ASC [ RunTime:0.009369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64335483 ORDER BY `unit` DESC [ RunTime:0.000412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64335483 LIMIT 2 [ RunTime:0.002634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64335483 ORDER BY `minOrder` ASC [ RunTime:0.000242s ]
select * from pdf where partno='MD212S-03RWI' and brandshort='MicroPower Direct' limit 1 [ RunTime:0.001080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MD212S-03RWI' OR `brand` LIKE 'MicroPower Direct%' ) ) LIMIT 1 [ RunTime:0.004423s ]
SELECT `id` FROM `stock` WHERE `id` <> 64335483 AND `partno` = 'MD212S-03RWI' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%micropower direct%' ) [ RunTime:0.002630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14770797 [ RunTime:0.000490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64330167 LIMIT 5 [ RunTime:0.004931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64330167 ORDER BY `minOrder` ASC [ RunTime:0.003831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64330167 ORDER BY `unit` DESC [ RunTime:0.000678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64330167 LIMIT 2 [ RunTime:0.000490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64330167 ORDER BY `minOrder` ASC [ RunTime:0.002450s ]
select * from pdf where partno='MD212S-03I6' and brandshort='MicroPower Direct' limit 1 [ RunTime:0.001029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MD212S-03I6' OR `brand` LIKE 'MicroPower Direct%' ) ) LIMIT 1 [ RunTime:0.001241s ]
SELECT `id` FROM `stock` WHERE `id` <> 64330167 AND `partno` = 'MD212S-03I6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%micropower direct%' ) [ RunTime:0.003791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14768598 [ RunTime:0.010219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64330112 LIMIT 5 [ RunTime:0.006556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64330112 ORDER BY `minOrder` ASC [ RunTime:0.008661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64330112 ORDER BY `unit` DESC [ RunTime:0.002696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64330112 LIMIT 2 [ RunTime:0.000354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64330112 ORDER BY `minOrder` ASC [ RunTime:0.000241s ]
select * from pdf where partno='MD212S-03I4' and brandshort='MicroPower Direct' limit 1 [ RunTime:0.000859s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MD212S-03I4' OR `brand` LIKE 'MicroPower Direct%' ) ) LIMIT 1 [ RunTime:0.003822s ]
SELECT `id` FROM `stock` WHERE `id` <> 64330112 AND `partno` = 'MD212S-03I4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%micropower direct%' ) [ RunTime:0.000783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13875916 [ RunTime:0.000781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64330099 LIMIT 5 [ RunTime:0.003717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64330099 ORDER BY `minOrder` ASC [ RunTime:0.002557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64330099 ORDER BY `unit` DESC [ RunTime:0.006387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64330099 LIMIT 2 [ RunTime:0.018715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64330099 ORDER BY `minOrder` ASC [ RunTime:0.000716s ]
select * from pdf where partno='MD212S-03I5' and brandshort='MicroPower Direct' limit 1 [ RunTime:0.001089s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MD212S-03I5' OR `brand` LIKE 'MicroPower Direct%' ) ) LIMIT 1 [ RunTime:0.000547s ]
SELECT `id` FROM `stock` WHERE `id` <> 64330099 AND `partno` = 'MD212S-03I5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%micropower direct%' ) [ RunTime:0.000514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13875910 [ RunTime:0.002063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64327359 LIMIT 5 [ RunTime:0.000576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64327359 ORDER BY `minOrder` ASC [ RunTime:0.016898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64327359 ORDER BY `unit` DESC [ RunTime:0.009664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64327359 LIMIT 2 [ RunTime:0.002462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64327359 ORDER BY `minOrder` ASC [ RunTime:0.005527s ]
select * from pdf where partno='MD212S-03C' and brandshort='MicroPower Direct' limit 1 [ RunTime:0.011182s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MD212S-03C' OR `brand` LIKE 'MicroPower Direct%' ) ) LIMIT 1 [ RunTime:0.007458s ]
SELECT `id` FROM `stock` WHERE `id` <> 64327359 AND `partno` = 'MD212S-03C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%micropower direct%' ) [ RunTime:0.005454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64327009 LIMIT 5 [ RunTime:0.001805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64327009 ORDER BY `minOrder` ASC [ RunTime:0.002556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64327009 ORDER BY `unit` DESC [ RunTime:0.009906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64327009 LIMIT 2 [ RunTime:0.017038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64327009 ORDER BY `minOrder` ASC [ RunTime:0.010169s ]
select * from pdf where partno='MD212S-03I' and brandshort='MicroPower Direct' limit 1 [ RunTime:0.000957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MD212S-03I' OR `brand` LIKE 'MicroPower Direct%' ) ) LIMIT 1 [ RunTime:0.002362s ]
SELECT `id` FROM `stock` WHERE `id` <> 64327009 AND `partno` = 'MD212S-03I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%micropower direct%' ) [ RunTime:0.001745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14766808 [ RunTime:0.001153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64327002 LIMIT 5 [ RunTime:0.000495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64327002 ORDER BY `minOrder` ASC [ RunTime:0.002276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64327002 ORDER BY `unit` DESC [ RunTime:0.005496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64327002 LIMIT 2 [ RunTime:0.012836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64327002 ORDER BY `minOrder` ASC [ RunTime:0.007156s ]
select * from pdf where partno='MD212S-03' and brandshort='MicroPower Direct' limit 1 [ RunTime:0.005301s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MD212S-03' OR `brand` LIKE 'MicroPower Direct%' ) ) LIMIT 1 [ RunTime:0.006073s ]
SELECT `id` FROM `stock` WHERE `id` <> 64327002 AND `partno` = 'MD212S-03' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%micropower direct%' ) [ RunTime:0.003227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13874178 [ RunTime:0.014857s ]
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 'MD212S-03%' OR `brand` LIKE 'MD212S-03%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014830s ]
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 'MD212S-03%' OR `brand` LIKE 'MD212S-03%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020533s ]
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 'MD212S-03%' OR `brand` LIKE 'MD212S-03%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013357s ]
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 'MD212S-03%' OR `brand` LIKE 'MD212S-03%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001759s ]
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 'MD212S-03%' OR `brand` LIKE 'MD212S-03%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001165s ]
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 'MD212S-03%' OR `brand` LIKE 'MD212S-03%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002877s ]
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 'MD212S-03%' OR `brand` LIKE 'MD212S-03%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016567s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MD212S-03%' OR `brand` LIKE 'MD212S-03%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007220s ]