SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003045s ]
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 'MR3451%' OR `brand` LIKE 'MR3451%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.215622s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.045350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18962509 LIMIT 5 [ RunTime:0.051362s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18962509 ORDER BY `minOrder` ASC [ RunTime:0.025003s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18962509 ORDER BY `unit` DESC [ RunTime:0.033406s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18962509 LIMIT 2 [ RunTime:0.051068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18962509 ORDER BY `minOrder` ASC [ RunTime:0.056398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904563 LIMIT 5 [ RunTime:0.059160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904563 ORDER BY `minOrder` ASC [ RunTime:0.078407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18904563 ORDER BY `unit` DESC [ RunTime:0.123333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18904563 LIMIT 2 [ RunTime:0.159776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904563 ORDER BY `minOrder` ASC [ RunTime:0.115064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904562 LIMIT 5 [ RunTime:0.019434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904562 ORDER BY `minOrder` ASC [ RunTime:0.051006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18904562 ORDER BY `unit` DESC [ RunTime:0.021852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18904562 LIMIT 2 [ RunTime:0.019109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904562 ORDER BY `minOrder` ASC [ RunTime:0.019824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904561 LIMIT 5 [ RunTime:0.083509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904561 ORDER BY `minOrder` ASC [ RunTime:0.141888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18904561 ORDER BY `unit` DESC [ RunTime:0.050907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18904561 LIMIT 2 [ RunTime:0.050950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904561 ORDER BY `minOrder` ASC [ RunTime:0.006078s ]
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 'MR3451%' OR `brand` LIKE 'MR3451%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.122912s ]
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 'MR3451%' OR `brand` LIKE 'MR3451%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.156966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58128903 LIMIT 5 [ RunTime:0.086311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58128903 ORDER BY `minOrder` ASC [ RunTime:0.090530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58128903 ORDER BY `unit` DESC [ RunTime:0.104660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58128903 LIMIT 2 [ RunTime:0.158646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58128903 ORDER BY `minOrder` ASC [ RunTime:0.137971s ]
select * from pdf where partno='MR34519MP7' and brandshort='onsemi' limit 1 [ RunTime:0.044727s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002674s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MR34519MP7' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.057859s ]
SELECT `id` FROM `stock` WHERE `id` <> 58128903 AND `partno` = 'MR34519MP7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.051278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904563 [ RunTime:0.135889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58128902 LIMIT 5 [ RunTime:0.047526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58128902 ORDER BY `minOrder` ASC [ RunTime:0.023807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58128902 ORDER BY `unit` DESC [ RunTime:0.036186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58128902 LIMIT 2 [ RunTime:0.031296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58128902 ORDER BY `minOrder` ASC [ RunTime:0.034626s ]
select * from pdf where partno='MR34519MP6' and brandshort='onsemi' limit 1 [ RunTime:0.035075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MR34519MP6' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.065324s ]
SELECT `id` FROM `stock` WHERE `id` <> 58128902 AND `partno` = 'MR34519MP6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.029423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904562 [ RunTime:0.052823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58128901 LIMIT 5 [ RunTime:0.160696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58128901 ORDER BY `minOrder` ASC [ RunTime:0.082544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58128901 ORDER BY `unit` DESC [ RunTime:0.108646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58128901 LIMIT 2 [ RunTime:0.165726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58128901 ORDER BY `minOrder` ASC [ RunTime:0.035225s ]
select * from pdf where partno='MR34519MP5' and brandshort='onsemi' limit 1 [ RunTime:0.124063s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MR34519MP5' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.085199s ]
SELECT `id` FROM `stock` WHERE `id` <> 58128901 AND `partno` = 'MR34519MP5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.125083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904561 [ RunTime:0.039939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41354125 LIMIT 5 [ RunTime:0.082213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41354125 ORDER BY `minOrder` ASC [ RunTime:0.066696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41354125 ORDER BY `unit` DESC [ RunTime:0.057482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41354125 LIMIT 2 [ RunTime:0.092745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41354125 ORDER BY `minOrder` ASC [ RunTime:0.029104s ]
select * from pdf where partno='MR3451' and brandshort='onsemi' limit 1 [ RunTime:0.054138s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MR3451' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.011019s ]
SELECT `id` FROM `stock` WHERE `id` <> 41354125 AND `partno` = 'MR3451' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.009072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18962509 [ RunTime:0.028717s ]
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 'MR3451%' OR `brand` LIKE 'MR3451%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.107900s ]
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 'MR3451%' OR `brand` LIKE 'MR3451%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053636s ]
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 'MR3451%' OR `brand` LIKE 'MR3451%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.085345s ]
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 'MR3451%' OR `brand` LIKE 'MR3451%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.099657s ]
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 'MR3451%' OR `brand` LIKE 'MR3451%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.152052s ]
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 'MR3451%' OR `brand` LIKE 'MR3451%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.099666s ]
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 'MR3451%' OR `brand` LIKE 'MR3451%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051931s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MR3451%' OR `brand` LIKE 'MR3451%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.129216s ]