SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001401s ]
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 'MC33166D2T%' OR `brand` LIKE 'MC33166D2T%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016638s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19131373 LIMIT 5 [ RunTime:0.018949s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19131373 ORDER BY `minOrder` ASC [ RunTime:0.008988s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.025265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19131373 ORDER BY `unit` DESC [ RunTime:0.025328s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19131373 LIMIT 2 [ RunTime:0.005125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19131373 ORDER BY `minOrder` ASC [ RunTime:0.005674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19131347 LIMIT 5 [ RunTime:0.009532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19131347 ORDER BY `minOrder` ASC [ RunTime:0.010966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19131347 ORDER BY `unit` DESC [ RunTime:0.009162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19131347 LIMIT 2 [ RunTime:0.005881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19131347 ORDER BY `minOrder` ASC [ RunTime:0.019067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17093565 LIMIT 5 [ RunTime:0.006430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17093565 ORDER BY `minOrder` ASC [ RunTime:0.013753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17093565 ORDER BY `unit` DESC [ RunTime:0.014536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17093565 LIMIT 2 [ RunTime:0.013449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17093565 ORDER BY `minOrder` ASC [ RunTime:0.002926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15314380 LIMIT 5 [ RunTime:0.032060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15314380 ORDER BY `minOrder` ASC [ RunTime:0.011466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15314380 ORDER BY `unit` DESC [ RunTime:0.030962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15314380 LIMIT 2 [ RunTime:0.011331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15314380 ORDER BY `minOrder` ASC [ RunTime:0.037741s ]
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 'MC33166D2T%' OR `brand` LIKE 'MC33166D2T%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034557s ]
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 'MC33166D2T%' OR `brand` LIKE 'MC33166D2T%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37284147 LIMIT 5 [ RunTime:0.036602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37284147 ORDER BY `minOrder` ASC [ RunTime:0.060060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37284147 ORDER BY `unit` DESC [ RunTime:0.036173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37284147 LIMIT 2 [ RunTime:0.018763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37284147 ORDER BY `minOrder` ASC [ RunTime:0.051919s ]
select * from pdf where partno='MC33166D2TG' and brandshort='onsemi' limit 1 [ RunTime:0.087428s ]
select foldpath,foldpath2,filename from pdf_file where id=554630 limit 1 [ RunTime:0.089824s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001329s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC33166D2TG' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.084609s ]
SELECT `id` FROM `stock` WHERE `id` <> 37284147 AND `partno` = 'MC33166D2TG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.119799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19131373 [ RunTime:0.111340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57090564 LIMIT 5 [ RunTime:0.036397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57090564 ORDER BY `minOrder` ASC [ RunTime:0.023840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57090564 ORDER BY `unit` DESC [ RunTime:0.007533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57090564 LIMIT 2 [ RunTime:0.016360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57090564 ORDER BY `minOrder` ASC [ RunTime:0.035634s ]
select * from pdf where partno='MC33166D2TR4G' and brandshort='onsemi' limit 1 [ RunTime:0.047893s ]
select foldpath,foldpath2,filename from pdf_file where id=554630 limit 1 [ RunTime:0.039409s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC33166D2TR4G' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.025621s ]
SELECT `id` FROM `stock` WHERE `id` <> 57090564 AND `partno` = 'MC33166D2TR4G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.078928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19131347 [ RunTime:0.034940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57089719 LIMIT 5 [ RunTime:0.056867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57089719 ORDER BY `minOrder` ASC [ RunTime:0.037379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57089719 ORDER BY `unit` DESC [ RunTime:0.000367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57089719 LIMIT 2 [ RunTime:0.024815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57089719 ORDER BY `minOrder` ASC [ RunTime:0.016955s ]
select * from pdf where partno='MC33166D2T' and brandshort='onsemi' limit 1 [ RunTime:0.017730s ]
select foldpath,foldpath2,filename from pdf_file where id=428395 limit 1 [ RunTime:0.072002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC33166D2T' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.018641s ]
SELECT `id` FROM `stock` WHERE `id` <> 57089719 AND `partno` = 'MC33166D2T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.015617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15314380 [ RunTime:0.010766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57088670 LIMIT 5 [ RunTime:0.036783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57088670 ORDER BY `minOrder` ASC [ RunTime:0.023566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57088670 ORDER BY `unit` DESC [ RunTime:0.034626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57088670 LIMIT 2 [ RunTime:0.030044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57088670 ORDER BY `minOrder` ASC [ RunTime:0.037566s ]
select * from pdf where partno='MC33166D2TR4' and brandshort='onsemi' limit 1 [ RunTime:0.076338s ]
select foldpath,foldpath2,filename from pdf_file where id=428395 limit 1 [ RunTime:0.023370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC33166D2TR4' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.035143s ]
SELECT `id` FROM `stock` WHERE `id` <> 57088670 AND `partno` = 'MC33166D2TR4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.017509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17093565 [ RunTime:0.063915s ]
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 'MC33166D2T%' OR `brand` LIKE 'MC33166D2T%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050129s ]
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 'MC33166D2T%' OR `brand` LIKE 'MC33166D2T%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.096561s ]
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 'MC33166D2T%' OR `brand` LIKE 'MC33166D2T%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026342s ]
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 'MC33166D2T%' OR `brand` LIKE 'MC33166D2T%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024652s ]
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 'MC33166D2T%' OR `brand` LIKE 'MC33166D2T%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016745s ]
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 'MC33166D2T%' OR `brand` LIKE 'MC33166D2T%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027678s ]
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 'MC33166D2T%' OR `brand` LIKE 'MC33166D2T%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044025s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MC33166D2T%' OR `brand` LIKE 'MC33166D2T%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.023735s ]