SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002648s ]
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 'SH275-3/4%' OR `brand` LIKE 'SH275-3/4%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006594s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14427976 LIMIT 5 [ RunTime:0.003128s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14427976 ORDER BY `minOrder` ASC [ RunTime:0.000554s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14427976 ORDER BY `unit` DESC [ RunTime:0.000511s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14427976 LIMIT 2 [ RunTime:0.000504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14427976 ORDER BY `minOrder` ASC [ RunTime:0.000253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14426152 LIMIT 5 [ RunTime:0.001226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14426152 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14426152 ORDER BY `unit` DESC [ RunTime:0.000241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14426152 LIMIT 2 [ RunTime:0.003336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14426152 ORDER BY `minOrder` ASC [ RunTime:0.007304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16436439 LIMIT 5 [ RunTime:0.014884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16436439 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16436439 ORDER BY `unit` DESC [ RunTime:0.002749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16436439 LIMIT 2 [ RunTime:0.019699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16436439 ORDER BY `minOrder` ASC [ RunTime:0.010977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16439781 LIMIT 5 [ RunTime:0.029165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16439781 ORDER BY `minOrder` ASC [ RunTime:0.011700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16439781 ORDER BY `unit` DESC [ RunTime:0.009681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16439781 LIMIT 2 [ RunTime:0.021667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16439781 ORDER BY `minOrder` ASC [ RunTime:0.017838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16438329 LIMIT 5 [ RunTime:0.037455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16438329 ORDER BY `minOrder` ASC [ RunTime:0.105980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16438329 ORDER BY `unit` DESC [ RunTime:0.044648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16438329 LIMIT 2 [ RunTime:0.013865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16438329 ORDER BY `minOrder` ASC [ RunTime:0.051573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16434229 LIMIT 5 [ RunTime:0.025205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16434229 ORDER BY `minOrder` ASC [ RunTime:0.097255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16434229 ORDER BY `unit` DESC [ RunTime:0.059047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16434229 LIMIT 2 [ RunTime:0.042366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16434229 ORDER BY `minOrder` ASC [ RunTime:0.020320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14428854 LIMIT 5 [ RunTime:0.016575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14428854 ORDER BY `minOrder` ASC [ RunTime:0.016257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14428854 ORDER BY `unit` DESC [ RunTime:0.026045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14428854 LIMIT 2 [ RunTime:0.019714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14428854 ORDER BY `minOrder` ASC [ RunTime:0.007146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14428502 LIMIT 5 [ RunTime:0.015452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14428502 ORDER BY `minOrder` ASC [ RunTime:0.012461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14428502 ORDER BY `unit` DESC [ RunTime:0.008709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14428502 LIMIT 2 [ RunTime:0.022338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14428502 ORDER BY `minOrder` ASC [ RunTime:0.017246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14428345 LIMIT 5 [ RunTime:0.009934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14428345 ORDER BY `minOrder` ASC [ RunTime:0.027425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14428345 ORDER BY `unit` DESC [ RunTime:0.036169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14428345 LIMIT 2 [ RunTime:0.019342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14428345 ORDER BY `minOrder` ASC [ RunTime:0.026600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14426432 LIMIT 5 [ RunTime:0.008864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14426432 ORDER BY `minOrder` ASC [ RunTime:0.017343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14426432 ORDER BY `unit` DESC [ RunTime:0.009836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14426432 LIMIT 2 [ RunTime:0.005865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14426432 ORDER BY `minOrder` ASC [ RunTime:0.011038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13559718 LIMIT 5 [ RunTime:0.004745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13559718 ORDER BY `minOrder` ASC [ RunTime:0.002530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13559718 ORDER BY `unit` DESC [ RunTime:0.000403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13559718 LIMIT 2 [ RunTime:0.000597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13559718 ORDER BY `minOrder` ASC [ RunTime:0.005941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13559627 LIMIT 5 [ RunTime:0.011638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13559627 ORDER BY `minOrder` ASC [ RunTime:0.000521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13559627 ORDER BY `unit` DESC [ RunTime:0.000417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13559627 LIMIT 2 [ RunTime:0.000729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13559627 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13559408 LIMIT 5 [ RunTime:0.000951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13559408 ORDER BY `minOrder` ASC [ RunTime:0.009076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13559408 ORDER BY `unit` DESC [ RunTime:0.016111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13559408 LIMIT 2 [ RunTime:0.000548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13559408 ORDER BY `minOrder` ASC [ RunTime:0.000819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13557542 LIMIT 5 [ RunTime:0.002834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13557542 ORDER BY `minOrder` ASC [ RunTime:0.001407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13557542 ORDER BY `unit` DESC [ RunTime:0.001337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13557542 LIMIT 2 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13557542 ORDER BY `minOrder` ASC [ RunTime:0.000300s ]
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 'SH275-3/4%' OR `brand` LIKE 'SH275-3/4%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001195s ]
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 'SH275-3/4%' OR `brand` LIKE 'SH275-3/4%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63106716 LIMIT 5 [ RunTime:0.001065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63106716 ORDER BY `minOrder` ASC [ RunTime:0.001080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63106716 ORDER BY `unit` DESC [ RunTime:0.000363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63106716 LIMIT 2 [ RunTime:0.002255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63106716 ORDER BY `minOrder` ASC [ RunTime:0.004206s ]
select * from pdf where partno='SH275-3/4' and brandshort='Daburn Electronics' limit 1 [ RunTime:0.003793s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SH275-3/4' OR `brand` LIKE 'Daburn Electronics%' ) ) LIMIT 1 [ RunTime:0.000310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63100577 LIMIT 5 [ RunTime:0.000456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63100577 ORDER BY `minOrder` ASC [ RunTime:0.013549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63100577 ORDER BY `unit` DESC [ RunTime:0.005292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63100577 LIMIT 2 [ RunTime:0.015066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63100577 ORDER BY `minOrder` ASC [ RunTime:0.005289s ]
select * from pdf where partno='SH275-3/4-100' and brandshort='Daburn Electronics' limit 1 [ RunTime:0.017837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SH275-3/4-100' OR `brand` LIKE 'Daburn Electronics%' ) ) LIMIT 1 [ RunTime:0.018286s ]
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 'SH275-3/4%' OR `brand` LIKE 'SH275-3/4%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009983s ]
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 'SH275-3/4%' OR `brand` LIKE 'SH275-3/4%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002795s ]
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 'SH275-3/4%' OR `brand` LIKE 'SH275-3/4%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025860s ]
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 'SH275-3/4%' OR `brand` LIKE 'SH275-3/4%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002496s ]
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 'SH275-3/4%' OR `brand` LIKE 'SH275-3/4%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003059s ]
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 'SH275-3/4%' OR `brand` LIKE 'SH275-3/4%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003363s ]
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 'SH275-3/4%' OR `brand` LIKE 'SH275-3/4%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009539s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SH275-3/4%' OR `brand` LIKE 'SH275-3/4%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.016812s ]