SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001999s ]
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 'FC120N2%' OR `brand` LIKE 'FC120N2%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050543s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16147873 LIMIT 5 [ RunTime:0.013923s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.010152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16147873 ORDER BY `minOrder` ASC [ RunTime:0.017282s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.024615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16147873 ORDER BY `unit` DESC [ RunTime:0.034678s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.023516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16147873 LIMIT 2 [ RunTime:0.008391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16147873 ORDER BY `minOrder` ASC [ RunTime:0.015846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19580103 LIMIT 5 [ RunTime:0.037105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19580103 ORDER BY `minOrder` ASC [ RunTime:0.039821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19580103 ORDER BY `unit` DESC [ RunTime:0.018668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19580103 LIMIT 2 [ RunTime:0.035411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19580103 ORDER BY `minOrder` ASC [ RunTime:0.012777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578138 LIMIT 5 [ RunTime:0.023491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578138 ORDER BY `minOrder` ASC [ RunTime:0.051241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19578138 ORDER BY `unit` DESC [ RunTime:0.034658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19578138 LIMIT 2 [ RunTime:0.025341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578138 ORDER BY `minOrder` ASC [ RunTime:0.006781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577890 LIMIT 5 [ RunTime:0.020109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577890 ORDER BY `minOrder` ASC [ RunTime:0.042873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19577890 ORDER BY `unit` DESC [ RunTime:0.009001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19577890 LIMIT 2 [ RunTime:0.012677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577890 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440285 LIMIT 5 [ RunTime:0.006065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440285 ORDER BY `minOrder` ASC [ RunTime:0.001785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15440285 ORDER BY `unit` DESC [ RunTime:0.019531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15440285 LIMIT 2 [ RunTime:0.026170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440285 ORDER BY `minOrder` ASC [ RunTime:0.009155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579123 LIMIT 5 [ RunTime:0.007536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579123 ORDER BY `minOrder` ASC [ RunTime:0.001620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579123 ORDER BY `unit` DESC [ RunTime:0.001006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579123 LIMIT 2 [ RunTime:0.000342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579123 ORDER BY `minOrder` ASC [ RunTime:0.002263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579106 LIMIT 5 [ RunTime:0.010896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579106 ORDER BY `minOrder` ASC [ RunTime:0.008716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579106 ORDER BY `unit` DESC [ RunTime:0.000713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579106 LIMIT 2 [ RunTime:0.007717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579106 ORDER BY `minOrder` ASC [ RunTime:0.002500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579099 LIMIT 5 [ RunTime:0.019261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579099 ORDER BY `minOrder` ASC [ RunTime:0.007039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579099 ORDER BY `unit` DESC [ RunTime:0.014399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579099 LIMIT 2 [ RunTime:0.000725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579099 ORDER BY `minOrder` ASC [ RunTime:0.002222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579084 LIMIT 5 [ RunTime:0.010392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579084 ORDER BY `minOrder` ASC [ RunTime:0.015421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579084 ORDER BY `unit` DESC [ RunTime:0.012230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579084 LIMIT 2 [ RunTime:0.003632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579084 ORDER BY `minOrder` ASC [ RunTime:0.007018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579078 LIMIT 5 [ RunTime:0.005277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579078 ORDER BY `minOrder` ASC [ RunTime:0.005067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579078 ORDER BY `unit` DESC [ RunTime:0.014220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579078 LIMIT 2 [ RunTime:0.008779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579078 ORDER BY `minOrder` ASC [ RunTime:0.002693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579068 LIMIT 5 [ RunTime:0.002863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579068 ORDER BY `minOrder` ASC [ RunTime:0.000856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579068 ORDER BY `unit` DESC [ RunTime:0.003767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579068 LIMIT 2 [ RunTime:0.000918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579068 ORDER BY `minOrder` ASC [ RunTime:0.005962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579064 LIMIT 5 [ RunTime:0.009064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579064 ORDER BY `minOrder` ASC [ RunTime:0.007157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579064 ORDER BY `unit` DESC [ RunTime:0.003265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579064 LIMIT 2 [ RunTime:0.011307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579064 ORDER BY `minOrder` ASC [ RunTime:0.002577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579038 LIMIT 5 [ RunTime:0.000727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579038 ORDER BY `minOrder` ASC [ RunTime:0.008402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579038 ORDER BY `unit` DESC [ RunTime:0.014128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579038 LIMIT 2 [ RunTime:0.010107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579038 ORDER BY `minOrder` ASC [ RunTime:0.006698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579006 LIMIT 5 [ RunTime:0.021716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579006 ORDER BY `minOrder` ASC [ RunTime:0.007841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19579006 ORDER BY `unit` DESC [ RunTime:0.017195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19579006 LIMIT 2 [ RunTime:0.003313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19579006 ORDER BY `minOrder` ASC [ RunTime:0.015420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578850 LIMIT 5 [ RunTime:0.003967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578850 ORDER BY `minOrder` ASC [ RunTime:0.015833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19578850 ORDER BY `unit` DESC [ RunTime:0.011680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19578850 LIMIT 2 [ RunTime:0.016262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578850 ORDER BY `minOrder` ASC [ RunTime:0.019266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578192 LIMIT 5 [ RunTime:0.007086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578192 ORDER BY `minOrder` ASC [ RunTime:0.009953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19578192 ORDER BY `unit` DESC [ RunTime:0.007792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19578192 LIMIT 2 [ RunTime:0.010108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578192 ORDER BY `minOrder` ASC [ RunTime:0.007843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17298113 LIMIT 5 [ RunTime:0.001272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298113 ORDER BY `minOrder` ASC [ RunTime:0.010307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17298113 ORDER BY `unit` DESC [ RunTime:0.004122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17298113 LIMIT 2 [ RunTime:0.010668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17298113 ORDER BY `minOrder` ASC [ RunTime:0.000494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440589 LIMIT 5 [ RunTime:0.000955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440589 ORDER BY `minOrder` ASC [ RunTime:0.018916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15440589 ORDER BY `unit` DESC [ RunTime:0.028422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15440589 LIMIT 2 [ RunTime:0.035632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440589 ORDER BY `minOrder` ASC [ RunTime:0.017037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440582 LIMIT 5 [ RunTime:0.000808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440582 ORDER BY `minOrder` ASC [ RunTime:0.011787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15440582 ORDER BY `unit` DESC [ RunTime:0.000697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15440582 LIMIT 2 [ RunTime:0.009857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440582 ORDER BY `minOrder` ASC [ RunTime:0.000637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440530 LIMIT 5 [ RunTime:0.015408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440530 ORDER BY `minOrder` ASC [ RunTime:0.015245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15440530 ORDER BY `unit` DESC [ RunTime:0.032816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15440530 LIMIT 2 [ RunTime:0.006762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440530 ORDER BY `minOrder` ASC [ RunTime:0.022879s ]
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 'FC120N2%' OR `brand` LIKE 'FC120N2%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002953s ]
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 'FC120N2%' OR `brand` LIKE 'FC120N2%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354221 LIMIT 5 [ RunTime:0.016262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354221 ORDER BY `minOrder` ASC [ RunTime:0.032338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354221 ORDER BY `unit` DESC [ RunTime:0.061002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354221 LIMIT 2 [ RunTime:0.039172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354221 ORDER BY `minOrder` ASC [ RunTime:0.015194s ]
select * from pdf where partno='FC120N2' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.011404s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC120N2' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.001717s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354221 AND `partno` = 'FC120N2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.000913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16147873 [ RunTime:0.002719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354812 LIMIT 5 [ RunTime:0.008276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354812 ORDER BY `minOrder` ASC [ RunTime:0.002780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354812 ORDER BY `unit` DESC [ RunTime:0.000478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354812 LIMIT 2 [ RunTime:0.000435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354812 ORDER BY `minOrder` ASC [ RunTime:0.000272s ]
select * from pdf where partno='FC120N2/AA-1565.0' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.000997s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC120N2/AA-1565.0' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.000624s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354812 AND `partno` = 'FC120N2/AA-1565.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.000657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578138 [ RunTime:0.000490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354844 LIMIT 5 [ RunTime:0.001409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354844 ORDER BY `minOrder` ASC [ RunTime:0.007727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354844 ORDER BY `unit` DESC [ RunTime:0.001011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354844 LIMIT 2 [ RunTime:0.012247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354844 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
select * from pdf where partno='FC120N2-14' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.001203s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC120N2-14' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.001763s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354844 AND `partno` = 'FC120N2-14' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.011794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19580103 [ RunTime:0.001824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60355033 LIMIT 5 [ RunTime:0.013890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60355033 ORDER BY `minOrder` ASC [ RunTime:0.004370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60355033 ORDER BY `unit` DESC [ RunTime:0.000520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60355033 LIMIT 2 [ RunTime:0.002258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60355033 ORDER BY `minOrder` ASC [ RunTime:0.010101s ]
select * from pdf where partno='FC120N2-1565.0' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.000799s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC120N2-1565.0' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.011671s ]
SELECT `id` FROM `stock` WHERE `id` <> 60355033 AND `partno` = 'FC120N2-1565.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.013091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578192 [ RunTime:0.000602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60354970 LIMIT 5 [ RunTime:0.014035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354970 ORDER BY `minOrder` ASC [ RunTime:0.012348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60354970 ORDER BY `unit` DESC [ RunTime:0.002359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60354970 LIMIT 2 [ RunTime:0.002961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60354970 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
select * from pdf where partno='FC120N2/AA-14' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.003414s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC120N2/AA-14' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.004211s ]
SELECT `id` FROM `stock` WHERE `id` <> 60354970 AND `partno` = 'FC120N2/AA-14' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.000849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440285 [ RunTime:0.005123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60356834 LIMIT 5 [ RunTime:0.001875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60356834 ORDER BY `minOrder` ASC [ RunTime:0.001135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60356834 ORDER BY `unit` DESC [ RunTime:0.001325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60356834 LIMIT 2 [ RunTime:0.000821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60356834 ORDER BY `minOrder` ASC [ RunTime:0.000801s ]
select * from pdf where partno='FC120N2-15' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.000784s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC120N2-15' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.002854s ]
SELECT `id` FROM `stock` WHERE `id` <> 60356834 AND `partno` = 'FC120N2-15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.001181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579099 [ RunTime:0.004538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60356799 LIMIT 5 [ RunTime:0.001518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60356799 ORDER BY `minOrder` ASC [ RunTime:0.005850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60356799 ORDER BY `unit` DESC [ RunTime:0.002927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60356799 LIMIT 2 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60356799 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
select * from pdf where partno='FC120N2/AA-15' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.000827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC120N2/AA-15' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.009090s ]
SELECT `id` FROM `stock` WHERE `id` <> 60356799 AND `partno` = 'FC120N2/AA-15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.000801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579078 [ RunTime:0.002504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60356753 LIMIT 5 [ RunTime:0.008387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60356753 ORDER BY `minOrder` ASC [ RunTime:0.001992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60356753 ORDER BY `unit` DESC [ RunTime:0.001063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60356753 LIMIT 2 [ RunTime:0.002817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60356753 ORDER BY `minOrder` ASC [ RunTime:0.000745s ]
select * from pdf where partno='FC120N2-1613.0' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.006532s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC120N2-1613.0' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.003875s ]
SELECT `id` FROM `stock` WHERE `id` <> 60356753 AND `partno` = 'FC120N2-1613.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.003870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579106 [ RunTime:0.006265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60356705 LIMIT 5 [ RunTime:0.011725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60356705 ORDER BY `minOrder` ASC [ RunTime:0.000876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60356705 ORDER BY `unit` DESC [ RunTime:0.006188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60356705 LIMIT 2 [ RunTime:0.002535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60356705 ORDER BY `minOrder` ASC [ RunTime:0.004006s ]
select * from pdf where partno='FC120N2-14-1565.0' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.024203s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC120N2-14-1565.0' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.002315s ]
SELECT `id` FROM `stock` WHERE `id` <> 60356705 AND `partno` = 'FC120N2-14-1565.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.017373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440589 [ RunTime:0.003745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60356703 LIMIT 5 [ RunTime:0.006628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60356703 ORDER BY `minOrder` ASC [ RunTime:0.001109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60356703 ORDER BY `unit` DESC [ RunTime:0.000476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60356703 LIMIT 2 [ RunTime:0.012202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60356703 ORDER BY `minOrder` ASC [ RunTime:0.000973s ]
select * from pdf where partno='FC120N2/AA-1613.0' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.025283s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC120N2/AA-1613.0' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.003928s ]
SELECT `id` FROM `stock` WHERE `id` <> 60356703 AND `partno` = 'FC120N2/AA-1613.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.011473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579084 [ RunTime:0.008190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60356688 LIMIT 5 [ RunTime:0.016040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60356688 ORDER BY `minOrder` ASC [ RunTime:0.001595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60356688 ORDER BY `unit` DESC [ RunTime:0.005008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60356688 LIMIT 2 [ RunTime:0.010870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60356688 ORDER BY `minOrder` ASC [ RunTime:0.006548s ]
select * from pdf where partno='FC120N2-61' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.001315s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC120N2-61' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.006193s ]
SELECT `id` FROM `stock` WHERE `id` <> 60356688 AND `partno` = 'FC120N2-61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.000751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579068 [ RunTime:0.011221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60356677 LIMIT 5 [ RunTime:0.000529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60356677 ORDER BY `minOrder` ASC [ RunTime:0.000639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60356677 ORDER BY `unit` DESC [ RunTime:0.001563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60356677 LIMIT 2 [ RunTime:0.005312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60356677 ORDER BY `minOrder` ASC [ RunTime:0.009426s ]
select * from pdf where partno='FC120N2/AA-14-1565.0' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.000738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC120N2/AA-14-1565.0' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.013063s ]
SELECT `id` FROM `stock` WHERE `id` <> 60356677 AND `partno` = 'FC120N2/AA-14-1565.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.000951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19579064 [ RunTime:0.000583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60356647 LIMIT 5 [ RunTime:0.000468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60356647 ORDER BY `minOrder` ASC [ RunTime:0.003317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60356647 ORDER BY `unit` DESC [ RunTime:0.002111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60356647 LIMIT 2 [ RunTime:0.009908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60356647 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
select * from pdf where partno='FC120N2/AA-61' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.001229s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC120N2/AA-61' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.000697s ]
SELECT `id` FROM `stock` WHERE `id` <> 60356647 AND `partno` = 'FC120N2/AA-61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.002861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440582 [ RunTime:0.007519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60355503 LIMIT 5 [ RunTime:0.017010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60355503 ORDER BY `minOrder` ASC [ RunTime:0.007395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60355503 ORDER BY `unit` DESC [ RunTime:0.002186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60355503 LIMIT 2 [ RunTime:0.005672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60355503 ORDER BY `minOrder` ASC [ RunTime:0.009438s ]
select * from pdf where partno='FC120N2/AA' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.034783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FC120N2/AA' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.014337s ]
SELECT `id` FROM `stock` WHERE `id` <> 60355503 AND `partno` = 'FC120N2/AA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.009300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577890 [ RunTime:0.013548s ]
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 'FC120N2%' OR `brand` LIKE 'FC120N2%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001380s ]
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 'FC120N2%' OR `brand` LIKE 'FC120N2%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008586s ]
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 'FC120N2%' OR `brand` LIKE 'FC120N2%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023507s ]
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 'FC120N2%' OR `brand` LIKE 'FC120N2%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024490s ]
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 'FC120N2%' OR `brand` LIKE 'FC120N2%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021345s ]
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 'FC120N2%' OR `brand` LIKE 'FC120N2%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006019s ]
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 'FC120N2%' OR `brand` LIKE 'FC120N2%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048909s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'FC120N2%' OR `brand` LIKE 'FC120N2%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.012991s ]