SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002759s ]
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 '6187R1KL.5%' OR `brand` LIKE '6187R1KL.5%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.098964s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17840001 LIMIT 5 [ RunTime:0.064865s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17840001 ORDER BY `minOrder` ASC [ RunTime:0.041417s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.014400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17840001 ORDER BY `unit` DESC [ RunTime:0.067004s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17840001 LIMIT 2 [ RunTime:0.023740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17840001 ORDER BY `minOrder` ASC [ RunTime:0.018464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17839995 LIMIT 5 [ RunTime:0.061746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17839995 ORDER BY `minOrder` ASC [ RunTime:0.064730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17839995 ORDER BY `unit` DESC [ RunTime:0.010541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17839995 LIMIT 2 [ RunTime:0.070752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17839995 ORDER BY `minOrder` ASC [ RunTime:0.019490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17839808 LIMIT 5 [ RunTime:0.023934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17839808 ORDER BY `minOrder` ASC [ RunTime:0.020406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17839808 ORDER BY `unit` DESC [ RunTime:0.038061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17839808 LIMIT 2 [ RunTime:0.033646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17839808 ORDER BY `minOrder` ASC [ RunTime:0.029982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16798879 LIMIT 5 [ RunTime:0.033173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16798879 ORDER BY `minOrder` ASC [ RunTime:0.020979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16798879 ORDER BY `unit` DESC [ RunTime:0.041298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16798879 LIMIT 2 [ RunTime:0.036463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16798879 ORDER BY `minOrder` ASC [ RunTime:0.013099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16798794 LIMIT 5 [ RunTime:0.010299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16798794 ORDER BY `minOrder` ASC [ RunTime:0.044104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16798794 ORDER BY `unit` DESC [ RunTime:0.010879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16798794 LIMIT 2 [ RunTime:0.046076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16798794 ORDER BY `minOrder` ASC [ RunTime:0.033225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15718333 LIMIT 5 [ RunTime:0.012249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15718333 ORDER BY `minOrder` ASC [ RunTime:0.050893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15718333 ORDER BY `unit` DESC [ RunTime:0.041807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15718333 LIMIT 2 [ RunTime:0.020373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15718333 ORDER BY `minOrder` ASC [ RunTime:0.018249s ]
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 '6187R1KL.5%' OR `brand` LIKE '6187R1KL.5%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058594s ]
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 '6187R1KL.5%' OR `brand` LIKE '6187R1KL.5%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41278264 LIMIT 5 [ RunTime:0.013743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41278264 ORDER BY `minOrder` ASC [ RunTime:0.034579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41278264 ORDER BY `unit` DESC [ RunTime:0.006317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41278264 LIMIT 2 [ RunTime:0.004577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41278264 ORDER BY `minOrder` ASC [ RunTime:0.006743s ]
select * from pdf where partno='6187R1KL.5ES' and brandshort='TT Electronics/BI' limit 1 [ RunTime:0.005527s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002509s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6187R1KL.5ES' OR `brand` LIKE 'TT Electronics/BI%' ) ) LIMIT 1 [ RunTime:0.012857s ]
SELECT `id` FROM `stock` WHERE `id` <> 41278264 AND `partno` = '6187R1KL.5ES' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tt electronics/bi%' ) [ RunTime:0.037940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15718333 [ RunTime:0.025515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41278260 LIMIT 5 [ RunTime:0.030861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41278260 ORDER BY `minOrder` ASC [ RunTime:0.033702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41278260 ORDER BY `unit` DESC [ RunTime:0.022039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41278260 LIMIT 2 [ RunTime:0.031253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41278260 ORDER BY `minOrder` ASC [ RunTime:0.009302s ]
select * from pdf where partno='6187R1KL.5SL' and brandshort='TT Electronics/BI' limit 1 [ RunTime:0.008699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6187R1KL.5SL' OR `brand` LIKE 'TT Electronics/BI%' ) ) LIMIT 1 [ RunTime:0.004431s ]
SELECT `id` FROM `stock` WHERE `id` <> 41278260 AND `partno` = '6187R1KL.5SL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tt electronics/bi%' ) [ RunTime:0.000625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16798879 [ RunTime:0.003543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41277262 LIMIT 5 [ RunTime:0.033182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41277262 ORDER BY `minOrder` ASC [ RunTime:0.021599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41277262 ORDER BY `unit` DESC [ RunTime:0.024924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41277262 LIMIT 2 [ RunTime:0.009526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41277262 ORDER BY `minOrder` ASC [ RunTime:0.004672s ]
select * from pdf where partno='6187R1KL.5ST' and brandshort='TT Electronics/BI' limit 1 [ RunTime:0.006605s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6187R1KL.5ST' OR `brand` LIKE 'TT Electronics/BI%' ) ) LIMIT 1 [ RunTime:0.018099s ]
SELECT `id` FROM `stock` WHERE `id` <> 41277262 AND `partno` = '6187R1KL.5ST' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tt electronics/bi%' ) [ RunTime:0.006826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17840001 [ RunTime:0.031677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41277251 LIMIT 5 [ RunTime:0.019049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41277251 ORDER BY `minOrder` ASC [ RunTime:0.019035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41277251 ORDER BY `unit` DESC [ RunTime:0.017724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41277251 LIMIT 2 [ RunTime:0.048963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41277251 ORDER BY `minOrder` ASC [ RunTime:0.026448s ]
select * from pdf where partno='6187R1KL.5CT' and brandshort='TT Electronics/BI' limit 1 [ RunTime:0.036010s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6187R1KL.5CT' OR `brand` LIKE 'TT Electronics/BI%' ) ) LIMIT 1 [ RunTime:0.036698s ]
SELECT `id` FROM `stock` WHERE `id` <> 41277251 AND `partno` = '6187R1KL.5CT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tt electronics/bi%' ) [ RunTime:0.027716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16798794 [ RunTime:0.047352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41277240 LIMIT 5 [ RunTime:0.050645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41277240 ORDER BY `minOrder` ASC [ RunTime:0.081285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41277240 ORDER BY `unit` DESC [ RunTime:0.018943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41277240 LIMIT 2 [ RunTime:0.054549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41277240 ORDER BY `minOrder` ASC [ RunTime:0.034313s ]
select * from pdf where partno='6187R1KL.5LT' and brandshort='TT Electronics/BI' limit 1 [ RunTime:0.021985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6187R1KL.5LT' OR `brand` LIKE 'TT Electronics/BI%' ) ) LIMIT 1 [ RunTime:0.022792s ]
SELECT `id` FROM `stock` WHERE `id` <> 41277240 AND `partno` = '6187R1KL.5LT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tt electronics/bi%' ) [ RunTime:0.031106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17839995 [ RunTime:0.026936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41276826 LIMIT 5 [ RunTime:0.053107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41276826 ORDER BY `minOrder` ASC [ RunTime:0.047786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41276826 ORDER BY `unit` DESC [ RunTime:0.021134s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41276826 LIMIT 2 [ RunTime:0.045652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41276826 ORDER BY `minOrder` ASC [ RunTime:0.006819s ]
select * from pdf where partno='6187R1KL.5' and brandshort='TT Electronics/BI' limit 1 [ RunTime:0.014724s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6187R1KL.5' OR `brand` LIKE 'TT Electronics/BI%' ) ) LIMIT 1 [ RunTime:0.039022s ]
SELECT `id` FROM `stock` WHERE `id` <> 41276826 AND `partno` = '6187R1KL.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tt electronics/bi%' ) [ RunTime:0.053265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17839808 [ RunTime:0.014757s ]
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 '6187R1KL.5%' OR `brand` LIKE '6187R1KL.5%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007883s ]
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 '6187R1KL.5%' OR `brand` LIKE '6187R1KL.5%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018858s ]
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 '6187R1KL.5%' OR `brand` LIKE '6187R1KL.5%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021759s ]
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 '6187R1KL.5%' OR `brand` LIKE '6187R1KL.5%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030980s ]
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 '6187R1KL.5%' OR `brand` LIKE '6187R1KL.5%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018345s ]
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 '6187R1KL.5%' OR `brand` LIKE '6187R1KL.5%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018300s ]
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 '6187R1KL.5%' OR `brand` LIKE '6187R1KL.5%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048285s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '6187R1KL.5%' OR `brand` LIKE '6187R1KL.5%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.019139s ]