SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002439s ]
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 'PJ664R%' OR `brand` LIKE 'PJ664R%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016743s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19026492 LIMIT 5 [ RunTime:0.019262s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19026492 ORDER BY `minOrder` ASC [ RunTime:0.007397s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19026492 ORDER BY `unit` DESC [ RunTime:0.019547s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19026492 LIMIT 2 [ RunTime:0.020769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19026492 ORDER BY `minOrder` ASC [ RunTime:0.013599s ]
select * from pdf where partno='PJ664RHW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.015000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19026077 LIMIT 5 [ RunTime:0.001286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19026077 ORDER BY `minOrder` ASC [ RunTime:0.005703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19026077 ORDER BY `unit` DESC [ RunTime:0.006459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19026077 LIMIT 2 [ RunTime:0.011187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19026077 ORDER BY `minOrder` ASC [ RunTime:0.005446s ]
select * from pdf where partno='PJ664RL' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.001356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19025796 LIMIT 5 [ RunTime:0.005716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19025796 ORDER BY `minOrder` ASC [ RunTime:0.037188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19025796 ORDER BY `unit` DESC [ RunTime:0.035267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19025796 LIMIT 2 [ RunTime:0.002919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19025796 ORDER BY `minOrder` ASC [ RunTime:0.010825s ]
select * from pdf where partno='PJ664RH' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.018576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274585 LIMIT 5 [ RunTime:0.018048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274585 ORDER BY `minOrder` ASC [ RunTime:0.052267s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15274585 ORDER BY `unit` DESC [ RunTime:0.035232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15274585 LIMIT 2 [ RunTime:0.013726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274585 ORDER BY `minOrder` ASC [ RunTime:0.005500s ]
select * from pdf where partno='PJ664RTW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.015205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274584 LIMIT 5 [ RunTime:0.004241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274584 ORDER BY `minOrder` ASC [ RunTime:0.002783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15274584 ORDER BY `unit` DESC [ RunTime:0.016648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15274584 LIMIT 2 [ RunTime:0.011616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274584 ORDER BY `minOrder` ASC [ RunTime:0.003350s ]
select * from pdf where partno='PJ664RLW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.012151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274525 LIMIT 5 [ RunTime:0.015760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274525 ORDER BY `minOrder` ASC [ RunTime:0.028984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15274525 ORDER BY `unit` DESC [ RunTime:0.001837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15274525 LIMIT 2 [ RunTime:0.068518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274525 ORDER BY `minOrder` ASC [ RunTime:0.017833s ]
select * from pdf where partno='PJ664RW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.066780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274375 LIMIT 5 [ RunTime:0.069850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274375 ORDER BY `minOrder` ASC [ RunTime:0.053595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15274375 ORDER BY `unit` DESC [ RunTime:0.045285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15274375 LIMIT 2 [ RunTime:0.048072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274375 ORDER BY `minOrder` ASC [ RunTime:0.033513s ]
select * from pdf where partno='PJ664R' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.047468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14203303 LIMIT 5 [ RunTime:0.037548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14203303 ORDER BY `minOrder` ASC [ RunTime:0.049190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14203303 ORDER BY `unit` DESC [ RunTime:0.065174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14203303 LIMIT 2 [ RunTime:0.058172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14203303 ORDER BY `minOrder` ASC [ RunTime:0.016727s ]
select * from pdf where partno='PJ664RT' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.078851s ]
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 'PJ664R%' OR `brand` LIKE 'PJ664R%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.067381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32220779 LIMIT 5 [ RunTime:0.041022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220779 ORDER BY `minOrder` ASC [ RunTime:0.049143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32220779 ORDER BY `unit` DESC [ RunTime:0.010257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32220779 LIMIT 2 [ RunTime:0.035147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220779 ORDER BY `minOrder` ASC [ RunTime:0.008054s ]
select * from pdf where partno='pj664rt' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.036029s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pj664rt' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.015855s ]
SELECT `id` FROM `stock` WHERE `id` <> 32220779 AND `partno` = 'pj664rt' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.029419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14203303 [ RunTime:0.011718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32221002 LIMIT 5 [ RunTime:0.010439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32221002 ORDER BY `minOrder` ASC [ RunTime:0.008634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32221002 ORDER BY `unit` DESC [ RunTime:0.006768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32221002 LIMIT 2 [ RunTime:0.025479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32221002 ORDER BY `minOrder` ASC [ RunTime:0.011297s ]
select * from pdf where partno='pj664rl' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.003698s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pj664rl' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.014307s ]
SELECT `id` FROM `stock` WHERE `id` <> 32221002 AND `partno` = 'pj664rl' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.014359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19026077 [ RunTime:0.016090s ]
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 'PJ664R%' OR `brand` LIKE 'PJ664R%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63440494 LIMIT 5 [ RunTime:0.050387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63440494 ORDER BY `minOrder` ASC [ RunTime:0.024072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63440494 ORDER BY `unit` DESC [ RunTime:0.045612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63440494 LIMIT 2 [ RunTime:0.023151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63440494 ORDER BY `minOrder` ASC [ RunTime:0.035201s ]
select * from pdf where partno='PJ664RTW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.013282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ664RTW' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.012774s ]
SELECT `id` FROM `stock` WHERE `id` <> 63440494 AND `partno` = 'PJ664RTW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.036111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274585 [ RunTime:0.025326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63440493 LIMIT 5 [ RunTime:0.010891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63440493 ORDER BY `minOrder` ASC [ RunTime:0.006172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63440493 ORDER BY `unit` DESC [ RunTime:0.019363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63440493 LIMIT 2 [ RunTime:0.000610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63440493 ORDER BY `minOrder` ASC [ RunTime:0.014634s ]
select * from pdf where partno='PJ664RLW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.001060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ664RLW' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.007583s ]
SELECT `id` FROM `stock` WHERE `id` <> 63440493 AND `partno` = 'PJ664RLW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.002290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274584 [ RunTime:0.003505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63440030 LIMIT 5 [ RunTime:0.022482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63440030 ORDER BY `minOrder` ASC [ RunTime:0.019766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63440030 ORDER BY `unit` DESC [ RunTime:0.022026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63440030 LIMIT 2 [ RunTime:0.011359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63440030 ORDER BY `minOrder` ASC [ RunTime:0.002270s ]
select * from pdf where partno='PJ664RHW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.011034s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ664RHW' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.011828s ]
SELECT `id` FROM `stock` WHERE `id` <> 63440030 AND `partno` = 'PJ664RHW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.036016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19026492 [ RunTime:0.027818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63439945 LIMIT 5 [ RunTime:0.008874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63439945 ORDER BY `minOrder` ASC [ RunTime:0.006124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63439945 ORDER BY `unit` DESC [ RunTime:0.022109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63439945 LIMIT 2 [ RunTime:0.025496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63439945 ORDER BY `minOrder` ASC [ RunTime:0.030821s ]
select * from pdf where partno='PJ664RW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.002034s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ664RW' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.013712s ]
SELECT `id` FROM `stock` WHERE `id` <> 63439945 AND `partno` = 'PJ664RW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.035503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274525 [ RunTime:0.022499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63439349 LIMIT 5 [ RunTime:0.060621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63439349 ORDER BY `minOrder` ASC [ RunTime:0.034707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63439349 ORDER BY `unit` DESC [ RunTime:0.019449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63439349 LIMIT 2 [ RunTime:0.002955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63439349 ORDER BY `minOrder` ASC [ RunTime:0.010189s ]
select * from pdf where partno='PJ664RT' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.019594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ664RT' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.016801s ]
SELECT `id` FROM `stock` WHERE `id` <> 63439349 AND `partno` = 'PJ664RT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.020662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14203303 [ RunTime:0.013706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63439348 LIMIT 5 [ RunTime:0.005947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63439348 ORDER BY `minOrder` ASC [ RunTime:0.003116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63439348 ORDER BY `unit` DESC [ RunTime:0.003522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63439348 LIMIT 2 [ RunTime:0.005112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63439348 ORDER BY `minOrder` ASC [ RunTime:0.001330s ]
select * from pdf where partno='PJ664RL' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ664RL' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.005285s ]
SELECT `id` FROM `stock` WHERE `id` <> 63439348 AND `partno` = 'PJ664RL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.001247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19026077 [ RunTime:0.010268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63438905 LIMIT 5 [ RunTime:0.013032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63438905 ORDER BY `minOrder` ASC [ RunTime:0.046110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63438905 ORDER BY `unit` DESC [ RunTime:0.049046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63438905 LIMIT 2 [ RunTime:0.008720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63438905 ORDER BY `minOrder` ASC [ RunTime:0.002867s ]
select * from pdf where partno='PJ664RH' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.008726s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ664RH' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.022128s ]
SELECT `id` FROM `stock` WHERE `id` <> 63438905 AND `partno` = 'PJ664RH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.014499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19025796 [ RunTime:0.063251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63438676 LIMIT 5 [ RunTime:0.056366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63438676 ORDER BY `minOrder` ASC [ RunTime:0.026444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63438676 ORDER BY `unit` DESC [ RunTime:0.028614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63438676 LIMIT 2 [ RunTime:0.017993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63438676 ORDER BY `minOrder` ASC [ RunTime:0.070916s ]
select * from pdf where partno='PJ664R' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.014919s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ664R' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.003580s ]
SELECT `id` FROM `stock` WHERE `id` <> 63438676 AND `partno` = 'PJ664R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.023639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274375 [ RunTime:0.069974s ]
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 'PJ664R%' OR `brand` LIKE 'PJ664R%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.127325s ]
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 'PJ664R%' OR `brand` LIKE 'PJ664R%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013730s ]
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 'PJ664R%' OR `brand` LIKE 'PJ664R%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.083963s ]
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 'PJ664R%' OR `brand` LIKE 'PJ664R%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061436s ]
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 'PJ664R%' OR `brand` LIKE 'PJ664R%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052326s ]
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 'PJ664R%' OR `brand` LIKE 'PJ664R%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055170s ]
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 'PJ664R%' OR `brand` LIKE 'PJ664R%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.056905s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PJ664R%' OR `brand` LIKE 'PJ664R%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.040925s ]