SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001352s ]
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 '8032%' OR `brand` LIKE '8032%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049866s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343668 LIMIT 5 [ RunTime:0.063202s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343668 ORDER BY `minOrder` ASC [ RunTime:0.047130s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.042893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13343668 ORDER BY `unit` DESC [ RunTime:0.022696s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13343668 LIMIT 2 [ RunTime:0.064569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343668 ORDER BY `minOrder` ASC [ RunTime:0.051424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12063632 LIMIT 5 [ RunTime:0.030277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12063632 ORDER BY `minOrder` ASC [ RunTime:0.023708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12063632 ORDER BY `unit` DESC [ RunTime:0.066390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12063632 LIMIT 2 [ RunTime:0.063875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12063632 ORDER BY `minOrder` ASC [ RunTime:0.029841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12063637 LIMIT 5 [ RunTime:0.054434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12063637 ORDER BY `minOrder` ASC [ RunTime:0.074129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12063637 ORDER BY `unit` DESC [ RunTime:0.056802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12063637 LIMIT 2 [ RunTime:0.087996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12063637 ORDER BY `minOrder` ASC [ RunTime:0.057389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12063684 LIMIT 5 [ RunTime:0.015506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12063684 ORDER BY `minOrder` ASC [ RunTime:0.037692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12063684 ORDER BY `unit` DESC [ RunTime:0.045979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12063684 LIMIT 2 [ RunTime:0.026310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12063684 ORDER BY `minOrder` ASC [ RunTime:0.008969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343895 LIMIT 5 [ RunTime:0.009983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343895 ORDER BY `minOrder` ASC [ RunTime:0.002587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13343895 ORDER BY `unit` DESC [ RunTime:0.008224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13343895 LIMIT 2 [ RunTime:0.007068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343895 ORDER BY `minOrder` ASC [ RunTime:0.003889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343896 LIMIT 5 [ RunTime:0.003362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343896 ORDER BY `minOrder` ASC [ RunTime:0.040089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13343896 ORDER BY `unit` DESC [ RunTime:0.136353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13343896 LIMIT 2 [ RunTime:0.029612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343896 ORDER BY `minOrder` ASC [ RunTime:0.002967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343906 LIMIT 5 [ RunTime:0.029207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343906 ORDER BY `minOrder` ASC [ RunTime:0.037947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13343906 ORDER BY `unit` DESC [ RunTime:0.038559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13343906 LIMIT 2 [ RunTime:0.017611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343906 ORDER BY `minOrder` ASC [ RunTime:0.036590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343921 LIMIT 5 [ RunTime:0.034439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343921 ORDER BY `minOrder` ASC [ RunTime:0.057552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13343921 ORDER BY `unit` DESC [ RunTime:0.015570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13343921 LIMIT 2 [ RunTime:0.041402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343921 ORDER BY `minOrder` ASC [ RunTime:0.029053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343770 LIMIT 5 [ RunTime:0.033677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343770 ORDER BY `minOrder` ASC [ RunTime:0.044897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13343770 ORDER BY `unit` DESC [ RunTime:0.000260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13343770 LIMIT 2 [ RunTime:0.036059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343770 ORDER BY `minOrder` ASC [ RunTime:0.005621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343719 LIMIT 5 [ RunTime:0.074374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343719 ORDER BY `minOrder` ASC [ RunTime:0.008675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13343719 ORDER BY `unit` DESC [ RunTime:0.023581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13343719 LIMIT 2 [ RunTime:0.043439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343719 ORDER BY `minOrder` ASC [ RunTime:0.048108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343736 LIMIT 5 [ RunTime:0.018202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343736 ORDER BY `minOrder` ASC [ RunTime:0.037826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13343736 ORDER BY `unit` DESC [ RunTime:0.002422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13343736 LIMIT 2 [ RunTime:0.030459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343736 ORDER BY `minOrder` ASC [ RunTime:0.009565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12063670 LIMIT 5 [ RunTime:0.034676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12063670 ORDER BY `minOrder` ASC [ RunTime:0.058002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12063670 ORDER BY `unit` DESC [ RunTime:0.050731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12063670 LIMIT 2 [ RunTime:0.050590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12063670 ORDER BY `minOrder` ASC [ RunTime:0.092364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343961 LIMIT 5 [ RunTime:0.050995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343961 ORDER BY `minOrder` ASC [ RunTime:0.050717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13343961 ORDER BY `unit` DESC [ RunTime:0.050965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13343961 LIMIT 2 [ RunTime:0.050907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343961 ORDER BY `minOrder` ASC [ RunTime:0.050902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15261932 LIMIT 5 [ RunTime:0.051444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15261932 ORDER BY `minOrder` ASC [ RunTime:0.051048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15261932 ORDER BY `unit` DESC [ RunTime:0.051331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15261932 LIMIT 2 [ RunTime:0.051409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15261932 ORDER BY `minOrder` ASC [ RunTime:0.051346s ]
select * from pdf where partno='803268' and brandshort='Bergquist' limit 1 [ RunTime:0.051363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13337786 LIMIT 5 [ RunTime:0.052088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13337786 ORDER BY `minOrder` ASC [ RunTime:0.051524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13337786 ORDER BY `unit` DESC [ RunTime:0.051368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13337786 LIMIT 2 [ RunTime:0.051379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13337786 ORDER BY `minOrder` ASC [ RunTime:0.051322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13337785 LIMIT 5 [ RunTime:0.017348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13337785 ORDER BY `minOrder` ASC [ RunTime:0.034490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13337785 ORDER BY `unit` DESC [ RunTime:0.006826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13337785 LIMIT 2 [ RunTime:0.038520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13337785 ORDER BY `minOrder` ASC [ RunTime:0.052304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17044814 LIMIT 5 [ RunTime:0.097573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17044814 ORDER BY `minOrder` ASC [ RunTime:0.074520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17044814 ORDER BY `unit` DESC [ RunTime:0.042086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17044814 LIMIT 2 [ RunTime:0.057365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17044814 ORDER BY `minOrder` ASC [ RunTime:0.056601s ]
select * from pdf where partno='803266' and brandshort='Bergquist' limit 1 [ RunTime:0.056107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13365778 LIMIT 5 [ RunTime:0.037897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13365778 ORDER BY `minOrder` ASC [ RunTime:0.040047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13365778 ORDER BY `unit` DESC [ RunTime:0.018664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13365778 LIMIT 2 [ RunTime:0.070932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13365778 ORDER BY `minOrder` ASC [ RunTime:0.008894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12076655 LIMIT 5 [ RunTime:0.022942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12076655 ORDER BY `minOrder` ASC [ RunTime:0.041424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12076655 ORDER BY `unit` DESC [ RunTime:0.013622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12076655 LIMIT 2 [ RunTime:0.079760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12076655 ORDER BY `minOrder` ASC [ RunTime:0.009242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19572333 LIMIT 5 [ RunTime:0.037043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19572333 ORDER BY `minOrder` ASC [ RunTime:0.029288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19572333 ORDER BY `unit` DESC [ RunTime:0.015979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19572333 LIMIT 2 [ RunTime:0.043109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19572333 ORDER BY `minOrder` ASC [ RunTime:0.036007s ]
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 '8032%' OR `brand` LIKE '8032%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32291815 LIMIT 5 [ RunTime:0.033092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291815 ORDER BY `minOrder` ASC [ RunTime:0.036417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32291815 ORDER BY `unit` DESC [ RunTime:0.028422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32291815 LIMIT 2 [ RunTime:0.043833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291815 ORDER BY `minOrder` ASC [ RunTime:0.030387s ]
select * from pdf where partno='803274' and brandshort='amphenol i2s' limit 1 [ RunTime:0.063646s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002469s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '803274' OR `brand` LIKE 'amphenol i2s%' ) ) LIMIT 1 [ RunTime:0.023443s ]
SELECT `id` FROM `stock` WHERE `id` <> 32291815 AND `partno` = '803274' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol i2s%' ) [ RunTime:0.010786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57962665 [ RunTime:0.009303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32241508 LIMIT 5 [ RunTime:0.054205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32241508 ORDER BY `minOrder` ASC [ RunTime:0.042031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32241508 ORDER BY `unit` DESC [ RunTime:0.032146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32241508 LIMIT 2 [ RunTime:0.045705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32241508 ORDER BY `minOrder` ASC [ RunTime:0.088568s ]
select * from pdf where partno='803285' and brandshort='amphenol i2s' limit 1 [ RunTime:0.034877s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '803285' OR `brand` LIKE 'amphenol i2s%' ) ) LIMIT 1 [ RunTime:0.046681s ]
SELECT `id` FROM `stock` WHERE `id` <> 32241508 AND `partno` = '803285' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol i2s%' ) [ RunTime:0.018066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57826686 [ RunTime:0.013361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32241230 LIMIT 5 [ RunTime:0.038055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32241230 ORDER BY `minOrder` ASC [ RunTime:0.039319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32241230 ORDER BY `unit` DESC [ RunTime:0.030609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32241230 LIMIT 2 [ RunTime:0.078304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32241230 ORDER BY `minOrder` ASC [ RunTime:0.007811s ]
select * from pdf where partno='803252' and brandshort='amphenol i2s' limit 1 [ RunTime:0.033990s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '803252' OR `brand` LIKE 'amphenol i2s%' ) ) LIMIT 1 [ RunTime:0.018865s ]
SELECT `id` FROM `stock` WHERE `id` <> 32241230 AND `partno` = '803252' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol i2s%' ) [ RunTime:0.042753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13337785 [ RunTime:0.016218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32241334 LIMIT 5 [ RunTime:0.028643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32241334 ORDER BY `minOrder` ASC [ RunTime:0.010995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32241334 ORDER BY `unit` DESC [ RunTime:0.006741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32241334 LIMIT 2 [ RunTime:0.025121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32241334 ORDER BY `minOrder` ASC [ RunTime:0.020705s ]
select * from pdf where partno='803208' and brandshort='amphenol i2s' limit 1 [ RunTime:0.014940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '803208' OR `brand` LIKE 'amphenol i2s%' ) ) LIMIT 1 [ RunTime:0.012622s ]
SELECT `id` FROM `stock` WHERE `id` <> 32241334 AND `partno` = '803208' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol i2s%' ) [ RunTime:0.006071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56412678 [ RunTime:0.005179s ]
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 '8032%' OR `brand` LIKE '8032%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50753735 LIMIT 5 [ RunTime:0.017299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50753735 ORDER BY `minOrder` ASC [ RunTime:0.008694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50753735 ORDER BY `unit` DESC [ RunTime:0.009902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50753735 LIMIT 2 [ RunTime:0.009075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50753735 ORDER BY `minOrder` ASC [ RunTime:0.020041s ]
select * from pdf where partno='80321CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.004794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80321CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.003737s ]
SELECT `id` FROM `stock` WHERE `id` <> 50753735 AND `partno` = '80321CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.007426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12063684 [ RunTime:0.007298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38162210 LIMIT 5 [ RunTime:0.009178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38162210 ORDER BY `minOrder` ASC [ RunTime:0.008215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38162210 ORDER BY `unit` DESC [ RunTime:0.013634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38162210 LIMIT 2 [ RunTime:0.019919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38162210 ORDER BY `minOrder` ASC [ RunTime:0.009001s ]
select * from pdf where partno='80321CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.007168s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80321CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.008215s ]
SELECT `id` FROM `stock` WHERE `id` <> 38162210 AND `partno` = '80321CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.004015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12063684 [ RunTime:0.001006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57755272 LIMIT 5 [ RunTime:0.003954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57755272 ORDER BY `minOrder` ASC [ RunTime:0.016826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57755272 ORDER BY `unit` DESC [ RunTime:0.023049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57755272 LIMIT 2 [ RunTime:0.016546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57755272 ORDER BY `minOrder` ASC [ RunTime:0.010830s ]
select * from pdf where partno='80327SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.007731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80327SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.004418s ]
SELECT `id` FROM `stock` WHERE `id` <> 57755272 AND `partno` = '80327SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.007962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343921 [ RunTime:0.007630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57755287 LIMIT 5 [ RunTime:0.019206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57755287 ORDER BY `minOrder` ASC [ RunTime:0.011177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57755287 ORDER BY `unit` DESC [ RunTime:0.004865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57755287 LIMIT 2 [ RunTime:0.009948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57755287 ORDER BY `minOrder` ASC [ RunTime:0.009464s ]
select * from pdf where partno='80320SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.024533s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80320SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.010411s ]
SELECT `id` FROM `stock` WHERE `id` <> 57755287 AND `partno` = '80320SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.007663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57755354 LIMIT 5 [ RunTime:0.008907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57755354 ORDER BY `minOrder` ASC [ RunTime:0.001776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57755354 ORDER BY `unit` DESC [ RunTime:0.005418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57755354 LIMIT 2 [ RunTime:0.003369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57755354 ORDER BY `minOrder` ASC [ RunTime:0.008952s ]
select * from pdf where partno='80325SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.006044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80325SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.009430s ]
SELECT `id` FROM `stock` WHERE `id` <> 57755354 AND `partno` = '80325SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.013875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343895 [ RunTime:0.004579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57755017 LIMIT 5 [ RunTime:0.011040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57755017 ORDER BY `minOrder` ASC [ RunTime:0.052385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57755017 ORDER BY `unit` DESC [ RunTime:0.026408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57755017 LIMIT 2 [ RunTime:0.029788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57755017 ORDER BY `minOrder` ASC [ RunTime:0.025566s ]
select * from pdf where partno='80320CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.009755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80320CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.026729s ]
SELECT `id` FROM `stock` WHERE `id` <> 57755017 AND `partno` = '80320CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.018618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343668 [ RunTime:0.005225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57755140 LIMIT 5 [ RunTime:0.013002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57755140 ORDER BY `minOrder` ASC [ RunTime:0.030983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57755140 ORDER BY `unit` DESC [ RunTime:0.009316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57755140 LIMIT 2 [ RunTime:0.013890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57755140 ORDER BY `minOrder` ASC [ RunTime:0.012775s ]
select * from pdf where partno='80326CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.008852s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80326CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.012169s ]
SELECT `id` FROM `stock` WHERE `id` <> 57755140 AND `partno` = '80326CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.008551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343770 [ RunTime:0.017023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57755036 LIMIT 5 [ RunTime:0.023972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57755036 ORDER BY `minOrder` ASC [ RunTime:0.017490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57755036 ORDER BY `unit` DESC [ RunTime:0.024753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57755036 LIMIT 2 [ RunTime:0.004593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57755036 ORDER BY `minOrder` ASC [ RunTime:0.007932s ]
select * from pdf where partno='80329CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003261s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80329CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.014748s ]
SELECT `id` FROM `stock` WHERE `id` <> 57755036 AND `partno` = '80329CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.007533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12063670 [ RunTime:0.007072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57755396 LIMIT 5 [ RunTime:0.016389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57755396 ORDER BY `minOrder` ASC [ RunTime:0.004984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57755396 ORDER BY `unit` DESC [ RunTime:0.006539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57755396 LIMIT 2 [ RunTime:0.000706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57755396 ORDER BY `minOrder` ASC [ RunTime:0.004135s ]
select * from pdf where partno='80322SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.007019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80322SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.001134s ]
SELECT `id` FROM `stock` WHERE `id` <> 57755396 AND `partno` = '80322SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.006920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57755088 LIMIT 5 [ RunTime:0.004584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57755088 ORDER BY `minOrder` ASC [ RunTime:0.012013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57755088 ORDER BY `unit` DESC [ RunTime:0.006800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57755088 LIMIT 2 [ RunTime:0.005516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57755088 ORDER BY `minOrder` ASC [ RunTime:0.002565s ]
select * from pdf where partno='80322CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.004099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80322CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.006907s ]
SELECT `id` FROM `stock` WHERE `id` <> 57755088 AND `partno` = '80322CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.004733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51861003 LIMIT 5 [ RunTime:0.007352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51861003 ORDER BY `minOrder` ASC [ RunTime:0.002836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51861003 ORDER BY `unit` DESC [ RunTime:0.002113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51861003 LIMIT 2 [ RunTime:0.003881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51861003 ORDER BY `minOrder` ASC [ RunTime:0.001662s ]
select * from pdf where partno='803288-SF' and brandshort='WEC' limit 1 [ RunTime:0.003167s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '803288-SF' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.007346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51860982 LIMIT 5 [ RunTime:0.004929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51860982 ORDER BY `minOrder` ASC [ RunTime:0.005630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51860982 ORDER BY `unit` DESC [ RunTime:0.002441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51860982 LIMIT 2 [ RunTime:0.002824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51860982 ORDER BY `minOrder` ASC [ RunTime:0.001433s ]
select * from pdf where partno='803281-SF' and brandshort='WEC' limit 1 [ RunTime:0.005941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '803281-SF' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.006056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51860994 LIMIT 5 [ RunTime:0.003661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51860994 ORDER BY `minOrder` ASC [ RunTime:0.003452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51860994 ORDER BY `unit` DESC [ RunTime:0.001147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51860994 LIMIT 2 [ RunTime:0.000756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51860994 ORDER BY `minOrder` ASC [ RunTime:0.002109s ]
select * from pdf where partno='803288-SF' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001668s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '803288-SF' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000436s ]
SELECT `id` FROM `stock` WHERE `id` <> 51860994 AND `partno` = '803288-SF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51862402 LIMIT 5 [ RunTime:0.000652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51862402 ORDER BY `minOrder` ASC [ RunTime:0.005914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51862402 ORDER BY `unit` DESC [ RunTime:0.002766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51862402 LIMIT 2 [ RunTime:0.004296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51862402 ORDER BY `minOrder` ASC [ RunTime:0.005992s ]
select * from pdf where partno='803296-SF' and brandshort='WEC' limit 1 [ RunTime:0.005583s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '803296-SF' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.006347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57756289 LIMIT 5 [ RunTime:0.005264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57756289 ORDER BY `minOrder` ASC [ RunTime:0.002018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57756289 ORDER BY `unit` DESC [ RunTime:0.002398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57756289 LIMIT 2 [ RunTime:0.003636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57756289 ORDER BY `minOrder` ASC [ RunTime:0.001361s ]
select * from pdf where partno='80327CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.004256s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80327CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000962s ]
SELECT `id` FROM `stock` WHERE `id` <> 57756289 AND `partno` = '80327CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.002957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12063637 [ RunTime:0.008263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50754897 LIMIT 5 [ RunTime:0.003887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50754897 ORDER BY `minOrder` ASC [ RunTime:0.006208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50754897 ORDER BY `unit` DESC [ RunTime:0.000900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50754897 LIMIT 2 [ RunTime:0.005527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50754897 ORDER BY `minOrder` ASC [ RunTime:0.005487s ]
select * from pdf where partno='80324CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.002966s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80324CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.001372s ]
SELECT `id` FROM `stock` WHERE `id` <> 50754897 AND `partno` = '80324CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.007888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12063632 [ RunTime:0.000967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38163869 LIMIT 5 [ RunTime:0.001846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38163869 ORDER BY `minOrder` ASC [ RunTime:0.014785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38163869 ORDER BY `unit` DESC [ RunTime:0.003819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38163869 LIMIT 2 [ RunTime:0.004997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38163869 ORDER BY `minOrder` ASC [ RunTime:0.001515s ]
select * from pdf where partno='80324CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001679s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80324CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000583s ]
SELECT `id` FROM `stock` WHERE `id` <> 38163869 AND `partno` = '80324CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.001391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12063632 [ RunTime:0.000829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51862410 LIMIT 5 [ RunTime:0.001822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51862410 ORDER BY `minOrder` ASC [ RunTime:0.007812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51862410 ORDER BY `unit` DESC [ RunTime:0.005426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51862410 LIMIT 2 [ RunTime:0.003728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51862410 ORDER BY `minOrder` ASC [ RunTime:0.002252s ]
select * from pdf where partno='803291-SF' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001210s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '803291-SF' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000886s ]
SELECT `id` FROM `stock` WHERE `id` <> 51862410 AND `partno` = '803291-SF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51862409 LIMIT 5 [ RunTime:0.000732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51862409 ORDER BY `minOrder` ASC [ RunTime:0.002692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51862409 ORDER BY `unit` DESC [ RunTime:0.000685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51862409 LIMIT 2 [ RunTime:0.002577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51862409 ORDER BY `minOrder` ASC [ RunTime:0.001934s ]
select * from pdf where partno='803297-SF' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001177s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '803297-SF' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000839s ]
SELECT `id` FROM `stock` WHERE `id` <> 51862409 AND `partno` = '803297-SF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.006709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57756327 LIMIT 5 [ RunTime:0.008310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57756327 ORDER BY `minOrder` ASC [ RunTime:0.001413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57756327 ORDER BY `unit` DESC [ RunTime:0.002958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57756327 LIMIT 2 [ RunTime:0.001851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57756327 ORDER BY `minOrder` ASC [ RunTime:0.000959s ]
select * from pdf where partno='80329SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '80329SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.002331s ]
SELECT `id` FROM `stock` WHERE `id` <> 57756327 AND `partno` = '80329SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.001167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343906 [ RunTime:0.000439s ]
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 '8032%' OR `brand` LIKE '8032%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001357s ]
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 '8032%' OR `brand` LIKE '8032%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001450s ]
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 '8032%' OR `brand` LIKE '8032%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004020s ]
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 '8032%' OR `brand` LIKE '8032%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001372s ]
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 '8032%' OR `brand` LIKE '8032%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001258s ]
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 '8032%' OR `brand` LIKE '8032%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001542s ]
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 '8032%' OR `brand` LIKE '8032%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001598s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '8032%' OR `brand` LIKE '8032%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002632s ]