SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002408s ]
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 'TDR 3-1211%' OR `brand` LIKE 'TDR 3-1211%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031213s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.015865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13893407 LIMIT 5 [ RunTime:0.025477s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.028052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13893407 ORDER BY `minOrder` ASC [ RunTime:0.027315s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.037696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13893407 ORDER BY `unit` DESC [ RunTime:0.017705s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.019879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13893407 LIMIT 2 [ RunTime:0.068083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13893407 ORDER BY `minOrder` ASC [ RunTime:0.031420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14787412 LIMIT 5 [ RunTime:0.007985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14787412 ORDER BY `minOrder` ASC [ RunTime:0.021880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14787412 ORDER BY `unit` DESC [ RunTime:0.019956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14787412 LIMIT 2 [ RunTime:0.007107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14787412 ORDER BY `minOrder` ASC [ RunTime:0.007530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14778454 LIMIT 5 [ RunTime:0.030903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14778454 ORDER BY `minOrder` ASC [ RunTime:0.010240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14778454 ORDER BY `unit` DESC [ RunTime:0.021612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14778454 LIMIT 2 [ RunTime:0.002910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14778454 ORDER BY `minOrder` ASC [ RunTime:0.004528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13884195 LIMIT 5 [ RunTime:0.008812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13884195 ORDER BY `minOrder` ASC [ RunTime:0.008013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13884195 ORDER BY `unit` DESC [ RunTime:0.029734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13884195 LIMIT 2 [ RunTime:0.021664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13884195 ORDER BY `minOrder` ASC [ RunTime:0.011701s ]
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 'TDR 3-1211%' OR `brand` LIKE 'TDR 3-1211%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013362s ]
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 'TDR 3-1211%' OR `brand` LIKE 'TDR 3-1211%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57493177 LIMIT 5 [ RunTime:0.002475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57493177 ORDER BY `minOrder` ASC [ RunTime:0.014597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57493177 ORDER BY `unit` DESC [ RunTime:0.021172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57493177 LIMIT 2 [ RunTime:0.017572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57493177 ORDER BY `minOrder` ASC [ RunTime:0.003516s ]
select * from pdf where partno='TDR 3-1211WISM' and brandshort='Traco Power' limit 1 [ RunTime:0.009178s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001727s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TDR 3-1211WISM' OR `brand` LIKE 'Traco Power%' ) ) LIMIT 1 [ RunTime:0.010251s ]
SELECT `id` FROM `stock` WHERE `id` <> 57493177 AND `partno` = 'TDR 3-1211WISM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%traco power%' ) [ RunTime:0.002571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13893407 [ RunTime:0.000822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57490726 LIMIT 5 [ RunTime:0.002493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57490726 ORDER BY `minOrder` ASC [ RunTime:0.001891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57490726 ORDER BY `unit` DESC [ RunTime:0.000529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57490726 LIMIT 2 [ RunTime:0.000451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57490726 ORDER BY `minOrder` ASC [ RunTime:0.002066s ]
select * from pdf where partno='TDR 3-1211SM' and brandshort='Traco Power' limit 1 [ RunTime:0.001037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TDR 3-1211SM' OR `brand` LIKE 'Traco Power%' ) ) LIMIT 1 [ RunTime:0.001262s ]
SELECT `id` FROM `stock` WHERE `id` <> 57490726 AND `partno` = 'TDR 3-1211SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%traco power%' ) [ RunTime:0.014931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14787412 [ RunTime:0.004693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57541800 LIMIT 5 [ RunTime:0.003860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57541800 ORDER BY `minOrder` ASC [ RunTime:0.001337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57541800 ORDER BY `unit` DESC [ RunTime:0.004677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57541800 LIMIT 2 [ RunTime:0.009868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57541800 ORDER BY `minOrder` ASC [ RunTime:0.001862s ]
select * from pdf where partno='TDR 3-1211' and brandshort='Traco Power' limit 1 [ RunTime:0.003736s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TDR 3-1211' OR `brand` LIKE 'Traco Power%' ) ) LIMIT 1 [ RunTime:0.001524s ]
SELECT `id` FROM `stock` WHERE `id` <> 57541800 AND `partno` = 'TDR 3-1211' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%traco power%' ) [ RunTime:0.002459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13884195 [ RunTime:0.021886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50544295 LIMIT 5 [ RunTime:0.009231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50544295 ORDER BY `minOrder` ASC [ RunTime:0.005328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50544295 ORDER BY `unit` DESC [ RunTime:0.000512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50544295 LIMIT 2 [ RunTime:0.000495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50544295 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
select * from pdf where partno='TDR 3-1211WI' and brandshort='Traco Power' limit 1 [ RunTime:0.004812s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TDR 3-1211WI' OR `brand` LIKE 'Traco Power%' ) ) LIMIT 1 [ RunTime:0.001448s ]
SELECT `id` FROM `stock` WHERE `id` <> 50544295 AND `partno` = 'TDR 3-1211WI' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%traco power%' ) [ RunTime:0.008673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14778454 [ RunTime:0.011232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37783566 LIMIT 5 [ RunTime:0.003096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37783566 ORDER BY `minOrder` ASC [ RunTime:0.002832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37783566 ORDER BY `unit` DESC [ RunTime:0.000742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37783566 LIMIT 2 [ RunTime:0.001677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37783566 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
select * from pdf where partno='TDR 3-1211WI' and brandshort='Traco Power' limit 1 [ RunTime:0.002085s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TDR 3-1211WI' OR `brand` LIKE 'Traco Power%' ) ) LIMIT 1 [ RunTime:0.000517s ]
SELECT `id` FROM `stock` WHERE `id` <> 37783566 AND `partno` = 'TDR 3-1211WI' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%traco power%' ) [ RunTime:0.000998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14778454 [ RunTime:0.002638s ]
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 'TDR 3-1211%' OR `brand` LIKE 'TDR 3-1211%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020840s ]
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 'TDR 3-1211%' OR `brand` LIKE 'TDR 3-1211%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028411s ]
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 'TDR 3-1211%' OR `brand` LIKE 'TDR 3-1211%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011437s ]
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 'TDR 3-1211%' OR `brand` LIKE 'TDR 3-1211%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007771s ]
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 'TDR 3-1211%' OR `brand` LIKE 'TDR 3-1211%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005297s ]
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 'TDR 3-1211%' OR `brand` LIKE 'TDR 3-1211%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006372s ]
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 'TDR 3-1211%' OR `brand` LIKE 'TDR 3-1211%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015058s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TDR 3-1211%' OR `brand` LIKE 'TDR 3-1211%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002742s ]