SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002803s ]
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 '40C24-N250%' OR `brand` LIKE '40C24-N250%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016578s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13868747 LIMIT 5 [ RunTime:0.036315s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13868747 ORDER BY `minOrder` ASC [ RunTime:0.016316s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.019918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13868747 ORDER BY `unit` DESC [ RunTime:0.004917s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13868747 LIMIT 2 [ RunTime:0.004988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13868747 ORDER BY `minOrder` ASC [ RunTime:0.014699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652105 LIMIT 5 [ RunTime:0.011196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652105 ORDER BY `minOrder` ASC [ RunTime:0.028123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652105 ORDER BY `unit` DESC [ RunTime:0.036690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652105 LIMIT 2 [ RunTime:0.021783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652105 ORDER BY `minOrder` ASC [ RunTime:0.017870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652100 LIMIT 5 [ RunTime:0.013585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652100 ORDER BY `minOrder` ASC [ RunTime:0.051772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652100 ORDER BY `unit` DESC [ RunTime:0.013322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652100 LIMIT 2 [ RunTime:0.014782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652100 ORDER BY `minOrder` ASC [ RunTime:0.008175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652087 LIMIT 5 [ RunTime:0.018536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652087 ORDER BY `minOrder` ASC [ RunTime:0.020322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652087 ORDER BY `unit` DESC [ RunTime:0.039937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652087 LIMIT 2 [ RunTime:0.025833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652087 ORDER BY `minOrder` ASC [ RunTime:0.006753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652086 LIMIT 5 [ RunTime:0.009730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652086 ORDER BY `minOrder` ASC [ RunTime:0.045212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652086 ORDER BY `unit` DESC [ RunTime:0.007382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652086 LIMIT 2 [ RunTime:0.018107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652086 ORDER BY `minOrder` ASC [ RunTime:0.027076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652084 LIMIT 5 [ RunTime:0.029187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652084 ORDER BY `minOrder` ASC [ RunTime:0.034308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652084 ORDER BY `unit` DESC [ RunTime:0.025878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652084 LIMIT 2 [ RunTime:0.020506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652084 ORDER BY `minOrder` ASC [ RunTime:0.011286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652077 LIMIT 5 [ RunTime:0.010397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652077 ORDER BY `minOrder` ASC [ RunTime:0.040326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652077 ORDER BY `unit` DESC [ RunTime:0.062380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652077 LIMIT 2 [ RunTime:0.016566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652077 ORDER BY `minOrder` ASC [ RunTime:0.026873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652076 LIMIT 5 [ RunTime:0.017137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652076 ORDER BY `minOrder` ASC [ RunTime:0.051938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652076 ORDER BY `unit` DESC [ RunTime:0.025759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652076 LIMIT 2 [ RunTime:0.018903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652076 ORDER BY `minOrder` ASC [ RunTime:0.017910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652072 LIMIT 5 [ RunTime:0.029330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652072 ORDER BY `minOrder` ASC [ RunTime:0.034467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652072 ORDER BY `unit` DESC [ RunTime:0.056949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652072 LIMIT 2 [ RunTime:0.066609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652072 ORDER BY `minOrder` ASC [ RunTime:0.042064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652067 LIMIT 5 [ RunTime:0.010233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652067 ORDER BY `minOrder` ASC [ RunTime:0.009045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652067 ORDER BY `unit` DESC [ RunTime:0.038631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652067 LIMIT 2 [ RunTime:0.020448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652067 ORDER BY `minOrder` ASC [ RunTime:0.002984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652065 LIMIT 5 [ RunTime:0.008255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652065 ORDER BY `minOrder` ASC [ RunTime:0.022115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652065 ORDER BY `unit` DESC [ RunTime:0.058784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652065 LIMIT 2 [ RunTime:0.020461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652065 ORDER BY `minOrder` ASC [ RunTime:0.084332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14790288 LIMIT 5 [ RunTime:0.048361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790288 ORDER BY `minOrder` ASC [ RunTime:0.057008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14790288 ORDER BY `unit` DESC [ RunTime:0.114258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14790288 LIMIT 2 [ RunTime:0.133899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790288 ORDER BY `minOrder` ASC [ RunTime:0.007832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14790285 LIMIT 5 [ RunTime:0.028225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790285 ORDER BY `minOrder` ASC [ RunTime:0.063409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14790285 ORDER BY `unit` DESC [ RunTime:0.047934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14790285 LIMIT 2 [ RunTime:0.060540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790285 ORDER BY `minOrder` ASC [ RunTime:0.055774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14790276 LIMIT 5 [ RunTime:0.015590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790276 ORDER BY `minOrder` ASC [ RunTime:0.002536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14790276 ORDER BY `unit` DESC [ RunTime:0.015787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14790276 LIMIT 2 [ RunTime:0.035758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790276 ORDER BY `minOrder` ASC [ RunTime:0.017018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14790263 LIMIT 5 [ RunTime:0.012013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790263 ORDER BY `minOrder` ASC [ RunTime:0.008852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14790263 ORDER BY `unit` DESC [ RunTime:0.027077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14790263 LIMIT 2 [ RunTime:0.028885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790263 ORDER BY `minOrder` ASC [ RunTime:0.012680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14790255 LIMIT 5 [ RunTime:0.029302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790255 ORDER BY `minOrder` ASC [ RunTime:0.021730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14790255 ORDER BY `unit` DESC [ RunTime:0.027945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14790255 LIMIT 2 [ RunTime:0.057822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790255 ORDER BY `minOrder` ASC [ RunTime:0.005230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14790245 LIMIT 5 [ RunTime:0.049443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790245 ORDER BY `minOrder` ASC [ RunTime:0.030999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14790245 ORDER BY `unit` DESC [ RunTime:0.050263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14790245 LIMIT 2 [ RunTime:0.027761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790245 ORDER BY `minOrder` ASC [ RunTime:0.005137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13895905 LIMIT 5 [ RunTime:0.029809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13895905 ORDER BY `minOrder` ASC [ RunTime:0.019194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13895905 ORDER BY `unit` DESC [ RunTime:0.008097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13895905 LIMIT 2 [ RunTime:0.004613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13895905 ORDER BY `minOrder` ASC [ RunTime:0.006019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13895901 LIMIT 5 [ RunTime:0.039915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13895901 ORDER BY `minOrder` ASC [ RunTime:0.046577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13895901 ORDER BY `unit` DESC [ RunTime:0.002040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13895901 LIMIT 2 [ RunTime:0.017167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13895901 ORDER BY `minOrder` ASC [ RunTime:0.017944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13895899 LIMIT 5 [ RunTime:0.009323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13895899 ORDER BY `minOrder` ASC [ RunTime:0.030627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13895899 ORDER BY `unit` DESC [ RunTime:0.022897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13895899 LIMIT 2 [ RunTime:0.025393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13895899 ORDER BY `minOrder` ASC [ RunTime:0.019141s ]
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 '40C24-N250%' OR `brand` LIKE '40C24-N250%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004610s ]
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 '40C24-N250%' OR `brand` LIKE '40C24-N250%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57504654 LIMIT 5 [ RunTime:0.016301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57504654 ORDER BY `minOrder` ASC [ RunTime:0.039903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57504654 ORDER BY `unit` DESC [ RunTime:0.014236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57504654 LIMIT 2 [ RunTime:0.027585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57504654 ORDER BY `minOrder` ASC [ RunTime:0.002747s ]
select * from pdf where partno='40C24-N250-I5-H' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.007749s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002138s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40C24-N250-I5-H' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.010417s ]
SELECT `id` FROM `stock` WHERE `id` <> 57504654 AND `partno` = '40C24-N250-I5-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.012971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13868747 [ RunTime:0.010559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57564179 LIMIT 5 [ RunTime:0.004176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57564179 ORDER BY `minOrder` ASC [ RunTime:0.011222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57564179 ORDER BY `unit` DESC [ RunTime:0.000681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57564179 LIMIT 2 [ RunTime:0.029513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57564179 ORDER BY `minOrder` ASC [ RunTime:0.008733s ]
select * from pdf where partno='40C24-N250-H' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.019324s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40C24-N250-H' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.052126s ]
SELECT `id` FROM `stock` WHERE `id` <> 57564179 AND `partno` = '40C24-N250-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.076918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57564178 LIMIT 5 [ RunTime:0.039610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57564178 ORDER BY `minOrder` ASC [ RunTime:0.015253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57564178 ORDER BY `unit` DESC [ RunTime:0.014607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57564178 LIMIT 2 [ RunTime:0.041354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57564178 ORDER BY `minOrder` ASC [ RunTime:0.042042s ]
select * from pdf where partno='40C24-N250-I5-AQ-WS' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.024841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40C24-N250-I5-AQ-WS' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.021172s ]
SELECT `id` FROM `stock` WHERE `id` <> 57564178 AND `partno` = '40C24-N250-I5-AQ-WS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.072622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57564166 LIMIT 5 [ RunTime:0.099897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57564166 ORDER BY `minOrder` ASC [ RunTime:0.032227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57564166 ORDER BY `unit` DESC [ RunTime:0.021369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57564166 LIMIT 2 [ RunTime:0.056444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57564166 ORDER BY `minOrder` ASC [ RunTime:0.023820s ]
select * from pdf where partno='40C24-N250-I5' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.015047s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40C24-N250-I5' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.086013s ]
SELECT `id` FROM `stock` WHERE `id` <> 57564166 AND `partno` = '40C24-N250-I5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.056221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57564160 LIMIT 5 [ RunTime:0.062674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57564160 ORDER BY `minOrder` ASC [ RunTime:0.116013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57564160 ORDER BY `unit` DESC [ RunTime:0.079106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57564160 LIMIT 2 [ RunTime:0.117784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57564160 ORDER BY `minOrder` ASC [ RunTime:0.037282s ]
select * from pdf where partno='40C24-N250' and brandshort='ULTRAVOLT / Advanced Energy' limit 1 [ RunTime:0.074413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40C24-N250' OR `brand` LIKE 'ULTRAVOLT / Advanced Energy%' ) ) LIMIT 1 [ RunTime:0.036975s ]
SELECT `id` FROM `stock` WHERE `id` <> 57564160 AND `partno` = '40C24-N250' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ultravolt / advanced energy%' ) [ RunTime:0.050406s ]
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 '40C24-N250%' OR `brand` LIKE '40C24-N250%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.096177s ]
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 '40C24-N250%' OR `brand` LIKE '40C24-N250%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.087930s ]
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 '40C24-N250%' OR `brand` LIKE '40C24-N250%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.119825s ]
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 '40C24-N250%' OR `brand` LIKE '40C24-N250%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.186176s ]
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 '40C24-N250%' OR `brand` LIKE '40C24-N250%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041861s ]
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 '40C24-N250%' OR `brand` LIKE '40C24-N250%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055631s ]
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 '40C24-N250%' OR `brand` LIKE '40C24-N250%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.103551s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '40C24-N250%' OR `brand` LIKE '40C24-N250%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.068538s ]