SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001621s ]
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 'PCA600F-24%' OR `brand` LIKE 'PCA600F-24%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013508s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12108673 LIMIT 5 [ RunTime:0.009932s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12108673 ORDER BY `minOrder` ASC [ RunTime:0.005185s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12108673 ORDER BY `unit` DESC [ RunTime:0.004962s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12108673 LIMIT 2 [ RunTime:0.012230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12108673 ORDER BY `minOrder` ASC [ RunTime:0.008077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12111576 LIMIT 5 [ RunTime:0.016036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12111576 ORDER BY `minOrder` ASC [ RunTime:0.008650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12111576 ORDER BY `unit` DESC [ RunTime:0.007475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12111576 LIMIT 2 [ RunTime:0.003592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12111576 ORDER BY `minOrder` ASC [ RunTime:0.002452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12111575 LIMIT 5 [ RunTime:0.006295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12111575 ORDER BY `minOrder` ASC [ RunTime:0.000595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12111575 ORDER BY `unit` DESC [ RunTime:0.003907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12111575 LIMIT 2 [ RunTime:0.005504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12111575 ORDER BY `minOrder` ASC [ RunTime:0.001870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12094446 LIMIT 5 [ RunTime:0.001374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12094446 ORDER BY `minOrder` ASC [ RunTime:0.007886s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12094446 ORDER BY `unit` DESC [ RunTime:0.006277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12094446 LIMIT 2 [ RunTime:0.003276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12094446 ORDER BY `minOrder` ASC [ RunTime:0.000693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12092282 LIMIT 5 [ RunTime:0.004779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12092282 ORDER BY `minOrder` ASC [ RunTime:0.010875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12092282 ORDER BY `unit` DESC [ RunTime:0.001761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12092282 LIMIT 2 [ RunTime:0.001598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12092282 ORDER BY `minOrder` ASC [ RunTime:0.004758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11135830 LIMIT 5 [ RunTime:0.009617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11135830 ORDER BY `minOrder` ASC [ RunTime:0.000751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11135830 ORDER BY `unit` DESC [ RunTime:0.002966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11135830 LIMIT 2 [ RunTime:0.004549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11135830 ORDER BY `minOrder` ASC [ RunTime:0.002050s ]
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 'PCA600F-24%' OR `brand` LIKE 'PCA600F-24%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51076427 LIMIT 5 [ RunTime:0.002334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51076427 ORDER BY `minOrder` ASC [ RunTime:0.002360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51076427 ORDER BY `unit` DESC [ RunTime:0.002701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51076427 LIMIT 2 [ RunTime:0.008919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51076427 ORDER BY `minOrder` ASC [ RunTime:0.001109s ]
select * from pdf where partno='pca600f-24-p2' and brandshort='cosel' limit 1 [ RunTime:0.003997s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001187s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pca600f-24-p2' OR `brand` LIKE 'cosel%' ) ) LIMIT 1 [ RunTime:0.009840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32169628 LIMIT 5 [ RunTime:0.006659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32169628 ORDER BY `minOrder` ASC [ RunTime:0.016904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32169628 ORDER BY `unit` DESC [ RunTime:0.000467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32169628 LIMIT 2 [ RunTime:0.020566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32169628 ORDER BY `minOrder` ASC [ RunTime:0.009352s ]
select * from pdf where partno='pca600f-24' and brandshort='cosel' limit 1 [ RunTime:0.005187s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pca600f-24' OR `brand` LIKE 'cosel%' ) ) LIMIT 1 [ RunTime:0.002616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51076878 LIMIT 5 [ RunTime:0.003474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51076878 ORDER BY `minOrder` ASC [ RunTime:0.009595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51076878 ORDER BY `unit` DESC [ RunTime:0.002816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51076878 LIMIT 2 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51076878 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
select * from pdf where partno='pca600f-24-f2' and brandshort='cosel' limit 1 [ RunTime:0.001740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pca600f-24-f2' OR `brand` LIKE 'cosel%' ) ) LIMIT 1 [ RunTime:0.006419s ]
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 'PCA600F-24%' OR `brand` LIKE 'PCA600F-24%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41586308 LIMIT 5 [ RunTime:0.006991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41586308 ORDER BY `minOrder` ASC [ RunTime:0.020692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41586308 ORDER BY `unit` DESC [ RunTime:0.008024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41586308 LIMIT 2 [ RunTime:0.008197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41586308 ORDER BY `minOrder` ASC [ RunTime:0.005249s ]
select * from pdf where partno='PCA600F-24-T' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.002021s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PCA600F-24-T' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.000923s ]
SELECT `id` FROM `stock` WHERE `id` <> 41586308 AND `partno` = 'PCA600F-24-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.000620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12108673 [ RunTime:0.000557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41602451 LIMIT 5 [ RunTime:0.009096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41602451 ORDER BY `minOrder` ASC [ RunTime:0.002665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41602451 ORDER BY `unit` DESC [ RunTime:0.002346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41602451 LIMIT 2 [ RunTime:0.006499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41602451 ORDER BY `minOrder` ASC [ RunTime:0.004600s ]
select * from pdf where partno='PCA600F-24-P2' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.001710s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PCA600F-24-P2' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.000457s ]
SELECT `id` FROM `stock` WHERE `id` <> 41602451 AND `partno` = 'PCA600F-24-P2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.003813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41611467 LIMIT 5 [ RunTime:0.001647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41611467 ORDER BY `minOrder` ASC [ RunTime:0.006259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41611467 ORDER BY `unit` DESC [ RunTime:0.003042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41611467 LIMIT 2 [ RunTime:0.011515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41611467 ORDER BY `minOrder` ASC [ RunTime:0.003234s ]
select * from pdf where partno='PCA600F-24' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.002836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PCA600F-24' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.004516s ]
SELECT `id` FROM `stock` WHERE `id` <> 41611467 AND `partno` = 'PCA600F-24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.028354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12111576 [ RunTime:0.017205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41611466 LIMIT 5 [ RunTime:0.005850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41611466 ORDER BY `minOrder` ASC [ RunTime:0.018747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41611466 ORDER BY `unit` DESC [ RunTime:0.010437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41611466 LIMIT 2 [ RunTime:0.033870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41611466 ORDER BY `minOrder` ASC [ RunTime:0.014995s ]
select * from pdf where partno='PCA600F-24-TP2' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.011362s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PCA600F-24-TP2' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.000975s ]
SELECT `id` FROM `stock` WHERE `id` <> 41611466 AND `partno` = 'PCA600F-24-TP2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.000985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12111575 [ RunTime:0.012146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41677747 LIMIT 5 [ RunTime:0.003144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41677747 ORDER BY `minOrder` ASC [ RunTime:0.009617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41677747 ORDER BY `unit` DESC [ RunTime:0.019629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41677747 LIMIT 2 [ RunTime:0.019343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41677747 ORDER BY `minOrder` ASC [ RunTime:0.016497s ]
select * from pdf where partno='PCA600F-24-CT' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.008546s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PCA600F-24-CT' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.012839s ]
SELECT `id` FROM `stock` WHERE `id` <> 41677747 AND `partno` = 'PCA600F-24-CT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.017553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41677743 LIMIT 5 [ RunTime:0.002308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41677743 ORDER BY `minOrder` ASC [ RunTime:0.017543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41677743 ORDER BY `unit` DESC [ RunTime:0.000570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41677743 LIMIT 2 [ RunTime:0.000367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41677743 ORDER BY `minOrder` ASC [ RunTime:0.000269s ]
select * from pdf where partno='PCA600F-24-C' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.008288s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PCA600F-24-C' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.009272s ]
SELECT `id` FROM `stock` WHERE `id` <> 41677743 AND `partno` = 'PCA600F-24-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.004678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41670665 LIMIT 5 [ RunTime:0.006979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41670665 ORDER BY `minOrder` ASC [ RunTime:0.024199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41670665 ORDER BY `unit` DESC [ RunTime:0.033555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41670665 LIMIT 2 [ RunTime:0.009259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41670665 ORDER BY `minOrder` ASC [ RunTime:0.017532s ]
select * from pdf where partno='PCA600F-24-F2' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.000902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PCA600F-24-F2' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.007955s ]
SELECT `id` FROM `stock` WHERE `id` <> 41670665 AND `partno` = 'PCA600F-24-F2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.007021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41670649 LIMIT 5 [ RunTime:0.008131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41670649 ORDER BY `minOrder` ASC [ RunTime:0.013419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41670649 ORDER BY `unit` DESC [ RunTime:0.007727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41670649 LIMIT 2 [ RunTime:0.001310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41670649 ORDER BY `minOrder` ASC [ RunTime:0.002194s ]
select * from pdf where partno='PCA600F-24-G' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.017018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PCA600F-24-G' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.007325s ]
SELECT `id` FROM `stock` WHERE `id` <> 41670649 AND `partno` = 'PCA600F-24-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.016570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11135830 [ RunTime:0.031747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41670645 LIMIT 5 [ RunTime:0.033411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41670645 ORDER BY `minOrder` ASC [ RunTime:0.039100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41670645 ORDER BY `unit` DESC [ RunTime:0.021117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41670645 LIMIT 2 [ RunTime:0.045882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41670645 ORDER BY `minOrder` ASC [ RunTime:0.010567s ]
select * from pdf where partno='PCA600F-24-P3' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.014604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PCA600F-24-P3' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.018773s ]
SELECT `id` FROM `stock` WHERE `id` <> 41670645 AND `partno` = 'PCA600F-24-P3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.009168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12094446 [ RunTime:0.026880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41670463 LIMIT 5 [ RunTime:0.023635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41670463 ORDER BY `minOrder` ASC [ RunTime:0.046478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41670463 ORDER BY `unit` DESC [ RunTime:0.036888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41670463 LIMIT 2 [ RunTime:0.020258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41670463 ORDER BY `minOrder` ASC [ RunTime:0.033451s ]
select * from pdf where partno='PCA600F-24-W1' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.005078s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PCA600F-24-W1' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.015877s ]
SELECT `id` FROM `stock` WHERE `id` <> 41670463 AND `partno` = 'PCA600F-24-W1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.059564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41670169 LIMIT 5 [ RunTime:0.015062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41670169 ORDER BY `minOrder` ASC [ RunTime:0.011114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41670169 ORDER BY `unit` DESC [ RunTime:0.027845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41670169 LIMIT 2 [ RunTime:0.023047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41670169 ORDER BY `minOrder` ASC [ RunTime:0.005578s ]
select * from pdf where partno='PCA600F-24-I' and brandshort='Cosel USA, Inc.' limit 1 [ RunTime:0.009558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PCA600F-24-I' OR `brand` LIKE 'Cosel USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.020005s ]
SELECT `id` FROM `stock` WHERE `id` <> 41670169 AND `partno` = 'PCA600F-24-I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cosel usa, inc.%' ) [ RunTime:0.025565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12092282 [ RunTime:0.044512s ]
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 'PCA600F-24%' OR `brand` LIKE 'PCA600F-24%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038272s ]
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 'PCA600F-24%' OR `brand` LIKE 'PCA600F-24%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051926s ]
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 'PCA600F-24%' OR `brand` LIKE 'PCA600F-24%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028887s ]
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 'PCA600F-24%' OR `brand` LIKE 'PCA600F-24%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047365s ]
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 'PCA600F-24%' OR `brand` LIKE 'PCA600F-24%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034496s ]
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 'PCA600F-24%' OR `brand` LIKE 'PCA600F-24%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057307s ]
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 'PCA600F-24%' OR `brand` LIKE 'PCA600F-24%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033949s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PCA600F-24%' OR `brand` LIKE 'PCA600F-24%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.025373s ]