SHOW FULL COLUMNS FROM `stock` [ RunTime:0.007497s ]
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 '0250%' OR `brand` LIKE '0250%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024960s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.008096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19030002 LIMIT 5 [ RunTime:0.007826s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.012222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19030002 ORDER BY `minOrder` ASC [ RunTime:0.010887s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19030002 ORDER BY `unit` DESC [ RunTime:0.001030s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19030002 LIMIT 2 [ RunTime:0.000949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19030002 ORDER BY `minOrder` ASC [ RunTime:0.000953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831906 LIMIT 5 [ RunTime:0.005931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831906 ORDER BY `minOrder` ASC [ RunTime:0.007267s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18831906 ORDER BY `unit` DESC [ RunTime:0.007609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18831906 LIMIT 2 [ RunTime:0.007540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831906 ORDER BY `minOrder` ASC [ RunTime:0.003918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831894 LIMIT 5 [ RunTime:0.000965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831894 ORDER BY `minOrder` ASC [ RunTime:0.000970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18831894 ORDER BY `unit` DESC [ RunTime:0.000904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18831894 LIMIT 2 [ RunTime:0.000902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831894 ORDER BY `minOrder` ASC [ RunTime:0.000953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831891 LIMIT 5 [ RunTime:0.001175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831891 ORDER BY `minOrder` ASC [ RunTime:0.000943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18831891 ORDER BY `unit` DESC [ RunTime:0.000878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18831891 LIMIT 2 [ RunTime:0.000878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831891 ORDER BY `minOrder` ASC [ RunTime:0.000836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831813 LIMIT 5 [ RunTime:0.006199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831813 ORDER BY `minOrder` ASC [ RunTime:0.010179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18831813 ORDER BY `unit` DESC [ RunTime:0.010842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18831813 LIMIT 2 [ RunTime:0.010887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831813 ORDER BY `minOrder` ASC [ RunTime:0.010872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831794 LIMIT 5 [ RunTime:0.007554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831794 ORDER BY `minOrder` ASC [ RunTime:0.000996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18831794 ORDER BY `unit` DESC [ RunTime:0.000826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18831794 LIMIT 2 [ RunTime:0.000835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831794 ORDER BY `minOrder` ASC [ RunTime:0.000860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831789 LIMIT 5 [ RunTime:0.000972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831789 ORDER BY `minOrder` ASC [ RunTime:0.000948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18831789 ORDER BY `unit` DESC [ RunTime:0.001869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18831789 LIMIT 2 [ RunTime:0.001384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831789 ORDER BY `minOrder` ASC [ RunTime:0.000894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831618 LIMIT 5 [ RunTime:0.006701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831618 ORDER BY `minOrder` ASC [ RunTime:0.009890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18831618 ORDER BY `unit` DESC [ RunTime:0.010765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18831618 LIMIT 2 [ RunTime:0.010918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831618 ORDER BY `minOrder` ASC [ RunTime:0.010927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831608 LIMIT 5 [ RunTime:0.010611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831608 ORDER BY `minOrder` ASC [ RunTime:0.011138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18831608 ORDER BY `unit` DESC [ RunTime:0.010821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18831608 LIMIT 2 [ RunTime:0.010967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831608 ORDER BY `minOrder` ASC [ RunTime:0.010790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831605 LIMIT 5 [ RunTime:0.010778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831605 ORDER BY `minOrder` ASC [ RunTime:0.009894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18831605 ORDER BY `unit` DESC [ RunTime:0.010898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18831605 LIMIT 2 [ RunTime:0.010790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831605 ORDER BY `minOrder` ASC [ RunTime:0.010819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831604 LIMIT 5 [ RunTime:0.014797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831604 ORDER BY `minOrder` ASC [ RunTime:0.000783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18831604 ORDER BY `unit` DESC [ RunTime:0.000527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18831604 LIMIT 2 [ RunTime:0.000500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831604 ORDER BY `minOrder` ASC [ RunTime:0.009893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831553 LIMIT 5 [ RunTime:0.000809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831553 ORDER BY `minOrder` ASC [ RunTime:0.000635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18831553 ORDER BY `unit` DESC [ RunTime:0.000519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18831553 LIMIT 2 [ RunTime:0.004359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831553 ORDER BY `minOrder` ASC [ RunTime:0.007669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831535 LIMIT 5 [ RunTime:0.007591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831535 ORDER BY `minOrder` ASC [ RunTime:0.007287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18831535 ORDER BY `unit` DESC [ RunTime:0.007593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18831535 LIMIT 2 [ RunTime:0.007648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831535 ORDER BY `minOrder` ASC [ RunTime:0.007614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831512 LIMIT 5 [ RunTime:0.007608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831512 ORDER BY `minOrder` ASC [ RunTime:0.007309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18831512 ORDER BY `unit` DESC [ RunTime:0.007596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18831512 LIMIT 2 [ RunTime:0.007599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831512 ORDER BY `minOrder` ASC [ RunTime:0.001711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831293 LIMIT 5 [ RunTime:0.005511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831293 ORDER BY `minOrder` ASC [ RunTime:0.007302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18831293 ORDER BY `unit` DESC [ RunTime:0.007617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18831293 LIMIT 2 [ RunTime:0.007627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831293 ORDER BY `minOrder` ASC [ RunTime:0.007568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831292 LIMIT 5 [ RunTime:0.007560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831292 ORDER BY `minOrder` ASC [ RunTime:0.007306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18831292 ORDER BY `unit` DESC [ RunTime:0.005715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18831292 LIMIT 2 [ RunTime:0.008813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831292 ORDER BY `minOrder` ASC [ RunTime:0.007615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831291 LIMIT 5 [ RunTime:0.007539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831291 ORDER BY `minOrder` ASC [ RunTime:0.007294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18831291 ORDER BY `unit` DESC [ RunTime:0.007584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18831291 LIMIT 2 [ RunTime:0.007609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831291 ORDER BY `minOrder` ASC [ RunTime:0.007611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831164 LIMIT 5 [ RunTime:0.007542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831164 ORDER BY `minOrder` ASC [ RunTime:0.007307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18831164 ORDER BY `unit` DESC [ RunTime:0.007560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18831164 LIMIT 2 [ RunTime:0.007652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831164 ORDER BY `minOrder` ASC [ RunTime:0.007483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831163 LIMIT 5 [ RunTime:0.007552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831163 ORDER BY `minOrder` ASC [ RunTime:0.007335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18831163 ORDER BY `unit` DESC [ RunTime:0.007596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18831163 LIMIT 2 [ RunTime:0.000470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18831163 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18829084 LIMIT 5 [ RunTime:0.006103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18829084 ORDER BY `minOrder` ASC [ RunTime:0.007331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18829084 ORDER BY `unit` DESC [ RunTime:0.007606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18829084 LIMIT 2 [ RunTime:0.007648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18829084 ORDER BY `minOrder` ASC [ RunTime:0.007601s ]
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 '0250%' OR `brand` LIKE '0250%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007194s ]
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 '0250%' OR `brand` LIKE '0250%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70203177 LIMIT 5 [ RunTime:0.007292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70203177 ORDER BY `minOrder` ASC [ RunTime:0.007576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70203177 ORDER BY `unit` DESC [ RunTime:0.008001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70203177 LIMIT 2 [ RunTime:0.007642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70203177 ORDER BY `minOrder` ASC [ RunTime:0.011133s ]
select * from pdf where partno='0250' and brandshort='Davies Molding, LLC' limit 1 [ RunTime:0.007783s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.007781s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0250' OR `brand` LIKE 'Davies Molding, LLC%' ) ) LIMIT 1 [ RunTime:0.007332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70844754 LIMIT 5 [ RunTime:0.010756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844754 ORDER BY `minOrder` ASC [ RunTime:0.007638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70844754 ORDER BY `unit` DESC [ RunTime:0.007442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70844754 LIMIT 2 [ RunTime:0.007693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844754 ORDER BY `minOrder` ASC [ RunTime:0.007569s ]
select * from pdf where partno='0250125052' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.007634s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0250125052' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.007560s ]
SELECT `id` FROM `stock` WHERE `id` <> 70844754 AND `partno` = '0250125052' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.007537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14184878 [ RunTime:0.007550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70844742 LIMIT 5 [ RunTime:0.007358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844742 ORDER BY `minOrder` ASC [ RunTime:0.007620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70844742 ORDER BY `unit` DESC [ RunTime:0.007400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70844742 LIMIT 2 [ RunTime:0.007669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844742 ORDER BY `minOrder` ASC [ RunTime:0.007646s ]
select * from pdf where partno='0250101052' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.004297s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0250101052' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.000678s ]
SELECT `id` FROM `stock` WHERE `id` <> 70844742 AND `partno` = '0250101052' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.000643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14184877 [ RunTime:0.000504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70844702 LIMIT 5 [ RunTime:0.000866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844702 ORDER BY `minOrder` ASC [ RunTime:0.000931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70844702 ORDER BY `unit` DESC [ RunTime:0.000486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70844702 LIMIT 2 [ RunTime:0.000481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844702 ORDER BY `minOrder` ASC [ RunTime:0.000491s ]
select * from pdf where partno='0250062052' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.001394s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0250062052' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.001138s ]
SELECT `id` FROM `stock` WHERE `id` <> 70844702 AND `partno` = '0250062052' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.000754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831894 [ RunTime:0.000474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70844697 LIMIT 5 [ RunTime:0.000833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844697 ORDER BY `minOrder` ASC [ RunTime:0.000786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70844697 ORDER BY `unit` DESC [ RunTime:0.000760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70844697 LIMIT 2 [ RunTime:0.000806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844697 ORDER BY `minOrder` ASC [ RunTime:0.000600s ]
select * from pdf where partno='0250037052' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.001362s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0250037052' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.000637s ]
SELECT `id` FROM `stock` WHERE `id` <> 70844697 AND `partno` = '0250037052' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.000626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831891 [ RunTime:0.000501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70844689 LIMIT 5 [ RunTime:0.000465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844689 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70844689 ORDER BY `unit` DESC [ RunTime:0.000826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70844689 LIMIT 2 [ RunTime:0.000820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844689 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
select * from pdf where partno='0250026052' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.000862s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0250026052' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.000610s ]
SELECT `id` FROM `stock` WHERE `id` <> 70844689 AND `partno` = '0250026052' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.000815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14184872 [ RunTime:0.000903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70844642 LIMIT 5 [ RunTime:0.000531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844642 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70844642 ORDER BY `unit` DESC [ RunTime:0.000486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70844642 LIMIT 2 [ RunTime:0.000440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844642 ORDER BY `minOrder` ASC [ RunTime:0.000518s ]
select * from pdf where partno='0250087052' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.000751s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0250087052' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.000605s ]
SELECT `id` FROM `stock` WHERE `id` <> 70844642 AND `partno` = '0250087052' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.000649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831906 [ RunTime:0.000500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70844538 LIMIT 5 [ RunTime:0.000495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844538 ORDER BY `minOrder` ASC [ RunTime:0.006742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70844538 ORDER BY `unit` DESC [ RunTime:0.003717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70844538 LIMIT 2 [ RunTime:0.000857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844538 ORDER BY `minOrder` ASC [ RunTime:0.000823s ]
select * from pdf where partno='0250125050' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.000798s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0250125050' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.000594s ]
SELECT `id` FROM `stock` WHERE `id` <> 70844538 AND `partno` = '0250125050' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.000682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17020367 [ RunTime:0.039608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70844493 LIMIT 5 [ RunTime:0.009991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844493 ORDER BY `minOrder` ASC [ RunTime:0.011046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70844493 ORDER BY `unit` DESC [ RunTime:0.010208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70844493 LIMIT 2 [ RunTime:0.007523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844493 ORDER BY `minOrder` ASC [ RunTime:0.001126s ]
select * from pdf where partno='0250087050' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.001439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0250087050' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.001164s ]
SELECT `id` FROM `stock` WHERE `id` <> 70844493 AND `partno` = '0250087050' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.001169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14184858 [ RunTime:0.000908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70844480 LIMIT 5 [ RunTime:0.000855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844480 ORDER BY `minOrder` ASC [ RunTime:0.000940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70844480 ORDER BY `unit` DESC [ RunTime:0.000814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70844480 LIMIT 2 [ RunTime:0.000795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844480 ORDER BY `minOrder` ASC [ RunTime:0.000953s ]
select * from pdf where partno='0250037050' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.001366s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0250037050' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.001093s ]
SELECT `id` FROM `stock` WHERE `id` <> 70844480 AND `partno` = '0250037050' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.001210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831789 [ RunTime:0.000939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70844472 LIMIT 5 [ RunTime:0.000876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844472 ORDER BY `minOrder` ASC [ RunTime:0.000935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70844472 ORDER BY `unit` DESC [ RunTime:0.000912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70844472 LIMIT 2 [ RunTime:0.000774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844472 ORDER BY `minOrder` ASC [ RunTime:0.000847s ]
select * from pdf where partno='0250026050' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.001306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0250026050' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.001016s ]
SELECT `id` FROM `stock` WHERE `id` <> 70844472 AND `partno` = '0250026050' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.001184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15235051 [ RunTime:0.019360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70844469 LIMIT 5 [ RunTime:0.009889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844469 ORDER BY `minOrder` ASC [ RunTime:0.010836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70844469 ORDER BY `unit` DESC [ RunTime:0.010463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70844469 LIMIT 2 [ RunTime:0.010740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844469 ORDER BY `minOrder` ASC [ RunTime:0.010780s ]
select * from pdf where partno='0250101050' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.010769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0250101050' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.010433s ]
SELECT `id` FROM `stock` WHERE `id` <> 70844469 AND `partno` = '0250101050' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.001259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831813 [ RunTime:0.000873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70844437 LIMIT 5 [ RunTime:0.000709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844437 ORDER BY `minOrder` ASC [ RunTime:0.000970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70844437 ORDER BY `unit` DESC [ RunTime:0.000490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70844437 LIMIT 2 [ RunTime:0.000723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844437 ORDER BY `minOrder` ASC [ RunTime:0.000950s ]
select * from pdf where partno='0250062050' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.000869s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0250062050' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.001134s ]
SELECT `id` FROM `stock` WHERE `id` <> 70844437 AND `partno` = '0250062050' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.000663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831794 [ RunTime:0.000891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70844292 LIMIT 5 [ RunTime:0.000462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844292 ORDER BY `minOrder` ASC [ RunTime:0.011133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70844292 ORDER BY `unit` DESC [ RunTime:0.010627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70844292 LIMIT 2 [ RunTime:0.007635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844292 ORDER BY `minOrder` ASC [ RunTime:0.010672s ]
select * from pdf where partno='025000004100' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.010878s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '025000004100' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.010399s ]
SELECT `id` FROM `stock` WHERE `id` <> 70844292 AND `partno` = '025000004100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.010584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17020348 [ RunTime:0.010893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70844186 LIMIT 5 [ RunTime:0.005926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844186 ORDER BY `minOrder` ASC [ RunTime:0.010993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70844186 ORDER BY `unit` DESC [ RunTime:0.010208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70844186 LIMIT 2 [ RunTime:0.006880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844186 ORDER BY `minOrder` ASC [ RunTime:0.010900s ]
select * from pdf where partno='025000004000' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.010813s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '025000004000' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.010344s ]
SELECT `id` FROM `stock` WHERE `id` <> 70844186 AND `partno` = '025000004000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.010539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14184832 [ RunTime:0.010874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70844175 LIMIT 5 [ RunTime:0.009800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844175 ORDER BY `minOrder` ASC [ RunTime:0.010783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70844175 ORDER BY `unit` DESC [ RunTime:0.000998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70844175 LIMIT 2 [ RunTime:0.000876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844175 ORDER BY `minOrder` ASC [ RunTime:0.000929s ]
select * from pdf where partno='025000003500' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.003226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '025000003500' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.007880s ]
SELECT `id` FROM `stock` WHERE `id` <> 70844175 AND `partno` = '025000003500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.010799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831618 [ RunTime:0.007529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70844161 LIMIT 5 [ RunTime:0.007308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844161 ORDER BY `minOrder` ASC [ RunTime:0.007642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70844161 ORDER BY `unit` DESC [ RunTime:0.011458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70844161 LIMIT 2 [ RunTime:0.007646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844161 ORDER BY `minOrder` ASC [ RunTime:0.007630s ]
select * from pdf where partno='025000003800' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.007573s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '025000003800' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.007508s ]
SELECT `id` FROM `stock` WHERE `id` <> 70844161 AND `partno` = '025000003800' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.007581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831608 [ RunTime:0.007625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70844160 LIMIT 5 [ RunTime:0.007387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844160 ORDER BY `minOrder` ASC [ RunTime:0.007709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70844160 ORDER BY `unit` DESC [ RunTime:0.007404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70844160 LIMIT 2 [ RunTime:0.007698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844160 ORDER BY `minOrder` ASC [ RunTime:0.007595s ]
select * from pdf where partno='025000003900' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.007632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '025000003900' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.007473s ]
SELECT `id` FROM `stock` WHERE `id` <> 70844160 AND `partno` = '025000003900' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.007504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15235013 [ RunTime:0.007621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70844153 LIMIT 5 [ RunTime:0.007424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844153 ORDER BY `minOrder` ASC [ RunTime:0.007666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70844153 ORDER BY `unit` DESC [ RunTime:0.007465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70844153 LIMIT 2 [ RunTime:0.007686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844153 ORDER BY `minOrder` ASC [ RunTime:0.007635s ]
select * from pdf where partno='025000003700' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.007603s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '025000003700' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.002231s ]
SELECT `id` FROM `stock` WHERE `id` <> 70844153 AND `partno` = '025000003700' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.008921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831605 [ RunTime:0.007575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70844152 LIMIT 5 [ RunTime:0.007386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844152 ORDER BY `minOrder` ASC [ RunTime:0.007589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70844152 ORDER BY `unit` DESC [ RunTime:0.007369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70844152 LIMIT 2 [ RunTime:0.007711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70844152 ORDER BY `minOrder` ASC [ RunTime:0.010915s ]
select * from pdf where partno='025000003600' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.007588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '025000003600' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.007577s ]
SELECT `id` FROM `stock` WHERE `id` <> 70844152 AND `partno` = '025000003600' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.001240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18831604 [ RunTime:0.000944s ]
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 '0250%' OR `brand` LIKE '0250%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001198s ]
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 '0250%' OR `brand` LIKE '0250%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000876s ]
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 '0250%' OR `brand` LIKE '0250%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000852s ]
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 '0250%' OR `brand` LIKE '0250%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000884s ]
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 '0250%' OR `brand` LIKE '0250%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000850s ]
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 '0250%' OR `brand` LIKE '0250%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000858s ]
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 '0250%' OR `brand` LIKE '0250%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000937s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '0250%' OR `brand` LIKE '0250%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001912s ]