SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001968s ]
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 'TSM-104-01-T-SH%' OR `brand` LIKE 'TSM-104-01-T-SH%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035726s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19853514 LIMIT 5 [ RunTime:0.026514s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19853514 ORDER BY `minOrder` ASC [ RunTime:0.034013s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002228s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19853514 ORDER BY `unit` DESC [ RunTime:0.003901s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19853514 LIMIT 2 [ RunTime:0.047718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19853514 ORDER BY `minOrder` ASC [ RunTime:0.031907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19750245 LIMIT 5 [ RunTime:0.019999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19750245 ORDER BY `minOrder` ASC [ RunTime:0.034276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19750245 ORDER BY `unit` DESC [ RunTime:0.003549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19750245 LIMIT 2 [ RunTime:0.049502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19750245 ORDER BY `minOrder` ASC [ RunTime:0.018573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19850954 LIMIT 5 [ RunTime:0.028839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19850954 ORDER BY `minOrder` ASC [ RunTime:0.025819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19850954 ORDER BY `unit` DESC [ RunTime:0.032951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19850954 LIMIT 2 [ RunTime:0.069500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19850954 ORDER BY `minOrder` ASC [ RunTime:0.027346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16236117 LIMIT 5 [ RunTime:0.003267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16236117 ORDER BY `minOrder` ASC [ RunTime:0.043268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16236117 ORDER BY `unit` DESC [ RunTime:0.040007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16236117 LIMIT 2 [ RunTime:0.009555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16236117 ORDER BY `minOrder` ASC [ RunTime:0.004063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16237801 LIMIT 5 [ RunTime:0.026698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16237801 ORDER BY `minOrder` ASC [ RunTime:0.039477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16237801 ORDER BY `unit` DESC [ RunTime:0.027897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16237801 LIMIT 2 [ RunTime:0.041648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16237801 ORDER BY `minOrder` ASC [ RunTime:0.009416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19852655 LIMIT 5 [ RunTime:0.033029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19852655 ORDER BY `minOrder` ASC [ RunTime:0.014862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19852655 ORDER BY `unit` DESC [ RunTime:0.055790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19852655 LIMIT 2 [ RunTime:0.018675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19852655 ORDER BY `minOrder` ASC [ RunTime:0.002509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12729131 LIMIT 5 [ RunTime:0.001283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12729131 ORDER BY `minOrder` ASC [ RunTime:0.004166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12729131 ORDER BY `unit` DESC [ RunTime:0.023758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12729131 LIMIT 2 [ RunTime:0.003219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12729131 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12729130 LIMIT 5 [ RunTime:0.003239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12729130 ORDER BY `minOrder` ASC [ RunTime:0.002646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12729130 ORDER BY `unit` DESC [ RunTime:0.011390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12729130 LIMIT 2 [ RunTime:0.003333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12729130 ORDER BY `minOrder` ASC [ RunTime:0.000406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12726873 LIMIT 5 [ RunTime:0.000974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12726873 ORDER BY `minOrder` ASC [ RunTime:0.002243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12726873 ORDER BY `unit` DESC [ RunTime:0.000635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12726873 LIMIT 2 [ RunTime:0.000554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12726873 ORDER BY `minOrder` ASC [ RunTime:0.001003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12726120 LIMIT 5 [ RunTime:0.000850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12726120 ORDER BY `minOrder` ASC [ RunTime:0.000981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12726120 ORDER BY `unit` DESC [ RunTime:0.001004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12726120 LIMIT 2 [ RunTime:0.000501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12726120 ORDER BY `minOrder` ASC [ RunTime:0.002745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12723434 LIMIT 5 [ RunTime:0.004482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12723434 ORDER BY `minOrder` ASC [ RunTime:0.000604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12723434 ORDER BY `unit` DESC [ RunTime:0.014435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12723434 LIMIT 2 [ RunTime:0.001682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12723434 ORDER BY `minOrder` ASC [ RunTime:0.009649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12722026 LIMIT 5 [ RunTime:0.014296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12722026 ORDER BY `minOrder` ASC [ RunTime:0.008923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12722026 ORDER BY `unit` DESC [ RunTime:0.003710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12722026 LIMIT 2 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12722026 ORDER BY `minOrder` ASC [ RunTime:0.001828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12721010 LIMIT 5 [ RunTime:0.004312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12721010 ORDER BY `minOrder` ASC [ RunTime:0.005719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12721010 ORDER BY `unit` DESC [ RunTime:0.005000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12721010 LIMIT 2 [ RunTime:0.000803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12721010 ORDER BY `minOrder` ASC [ RunTime:0.003736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12720376 LIMIT 5 [ RunTime:0.001303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12720376 ORDER BY `minOrder` ASC [ RunTime:0.012086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12720376 ORDER BY `unit` DESC [ RunTime:0.001344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12720376 LIMIT 2 [ RunTime:0.008357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12720376 ORDER BY `minOrder` ASC [ RunTime:0.000547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12716751 LIMIT 5 [ RunTime:0.007405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12716751 ORDER BY `minOrder` ASC [ RunTime:0.004390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12716751 ORDER BY `unit` DESC [ RunTime:0.008950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12716751 LIMIT 2 [ RunTime:0.000818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12716751 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11562120 LIMIT 5 [ RunTime:0.002193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11562120 ORDER BY `minOrder` ASC [ RunTime:0.009707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11562120 ORDER BY `unit` DESC [ RunTime:0.016147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11562120 LIMIT 2 [ RunTime:0.000756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11562120 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
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 'TSM-104-01-T-SH%' OR `brand` LIKE 'TSM-104-01-T-SH%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005466s ]
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 'TSM-104-01-T-SH%' OR `brand` LIKE 'TSM-104-01-T-SH%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59539856 LIMIT 5 [ RunTime:0.005385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59539856 ORDER BY `minOrder` ASC [ RunTime:0.002371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59539856 ORDER BY `unit` DESC [ RunTime:0.011480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59539856 LIMIT 2 [ RunTime:0.003441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59539856 ORDER BY `minOrder` ASC [ RunTime:0.003635s ]
select * from pdf where partno='TSM-104-01-T-SH-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009362s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-104-01-T-SH-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004333s ]
SELECT `id` FROM `stock` WHERE `id` <> 59539856 AND `partno` = 'TSM-104-01-T-SH-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19853514 [ RunTime:0.003226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59444098 LIMIT 5 [ RunTime:0.011629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59444098 ORDER BY `minOrder` ASC [ RunTime:0.017806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59444098 ORDER BY `unit` DESC [ RunTime:0.009690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59444098 LIMIT 2 [ RunTime:0.020527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59444098 ORDER BY `minOrder` ASC [ RunTime:0.010333s ]
select * from pdf where partno='TSM-104-01-T-SH-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002199s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-104-01-T-SH-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002396s ]
SELECT `id` FROM `stock` WHERE `id` <> 59444098 AND `partno` = 'TSM-104-01-T-SH-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19750245 [ RunTime:0.002448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59539119 LIMIT 5 [ RunTime:0.041469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59539119 ORDER BY `minOrder` ASC [ RunTime:0.061689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59539119 ORDER BY `unit` DESC [ RunTime:0.012379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59539119 LIMIT 2 [ RunTime:0.024570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59539119 ORDER BY `minOrder` ASC [ RunTime:0.017269s ]
select * from pdf where partno='TSM-104-01-T-SH' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-104-01-T-SH' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.016180s ]
SELECT `id` FROM `stock` WHERE `id` <> 59539119 AND `partno` = 'TSM-104-01-T-SH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.021935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16236117 [ RunTime:0.045372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59542199 LIMIT 5 [ RunTime:0.013959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59542199 ORDER BY `minOrder` ASC [ RunTime:0.021098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59542199 ORDER BY `unit` DESC [ RunTime:0.008593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59542199 LIMIT 2 [ RunTime:0.001988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59542199 ORDER BY `minOrder` ASC [ RunTime:0.001692s ]
select * from pdf where partno='TSM-104-01-T-SH-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.028931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-104-01-T-SH-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.027102s ]
SELECT `id` FROM `stock` WHERE `id` <> 59542199 AND `partno` = 'TSM-104-01-T-SH-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.024632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19850954 [ RunTime:0.011927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59448581 LIMIT 5 [ RunTime:0.006857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448581 ORDER BY `minOrder` ASC [ RunTime:0.001684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59448581 ORDER BY `unit` DESC [ RunTime:0.008833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59448581 LIMIT 2 [ RunTime:0.000506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59448581 ORDER BY `minOrder` ASC [ RunTime:0.005609s ]
select * from pdf where partno='TSM-104-01-T-SH-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015786s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-104-01-T-SH-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.026923s ]
SELECT `id` FROM `stock` WHERE `id` <> 59448581 AND `partno` = 'TSM-104-01-T-SH-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.031255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19852655 [ RunTime:0.003982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59626001 LIMIT 5 [ RunTime:0.027387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59626001 ORDER BY `minOrder` ASC [ RunTime:0.028341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59626001 ORDER BY `unit` DESC [ RunTime:0.012381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59626001 LIMIT 2 [ RunTime:0.017964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59626001 ORDER BY `minOrder` ASC [ RunTime:0.024976s ]
select * from pdf where partno='TSM-104-01-T-SH-LC-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-104-01-T-SH-LC-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.020540s ]
SELECT `id` FROM `stock` WHERE `id` <> 59626001 AND `partno` = 'TSM-104-01-T-SH-LC-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.018173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12729131 [ RunTime:0.009025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59626000 LIMIT 5 [ RunTime:0.013066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59626000 ORDER BY `minOrder` ASC [ RunTime:0.013690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59626000 ORDER BY `unit` DESC [ RunTime:0.013056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59626000 LIMIT 2 [ RunTime:0.018631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59626000 ORDER BY `minOrder` ASC [ RunTime:0.008728s ]
select * from pdf where partno='TSM-104-01-T-SH-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007543s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-104-01-T-SH-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.018348s ]
SELECT `id` FROM `stock` WHERE `id` <> 59626000 AND `partno` = 'TSM-104-01-T-SH-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.044816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12729130 [ RunTime:0.018006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59622142 LIMIT 5 [ RunTime:0.018518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59622142 ORDER BY `minOrder` ASC [ RunTime:0.011683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59622142 ORDER BY `unit` DESC [ RunTime:0.012296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59622142 LIMIT 2 [ RunTime:0.000764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59622142 ORDER BY `minOrder` ASC [ RunTime:0.001589s ]
select * from pdf where partno='TSM-104-01-T-SH-A-003' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019905s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-104-01-T-SH-A-003' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009590s ]
SELECT `id` FROM `stock` WHERE `id` <> 59622142 AND `partno` = 'TSM-104-01-T-SH-A-003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.018496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12726873 [ RunTime:0.009552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59622141 LIMIT 5 [ RunTime:0.007209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59622141 ORDER BY `minOrder` ASC [ RunTime:0.018699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59622141 ORDER BY `unit` DESC [ RunTime:0.013053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59622141 LIMIT 2 [ RunTime:0.011430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59622141 ORDER BY `minOrder` ASC [ RunTime:0.005317s ]
select * from pdf where partno='TSM-104-01-T-SH-A-002' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008853s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-104-01-T-SH-A-002' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007064s ]
SELECT `id` FROM `stock` WHERE `id` <> 59622141 AND `partno` = 'TSM-104-01-T-SH-A-002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11562120 [ RunTime:0.004388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59620804 LIMIT 5 [ RunTime:0.001938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59620804 ORDER BY `minOrder` ASC [ RunTime:0.001318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59620804 ORDER BY `unit` DESC [ RunTime:0.001399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59620804 LIMIT 2 [ RunTime:0.003062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59620804 ORDER BY `minOrder` ASC [ RunTime:0.000487s ]
select * from pdf where partno='TSM-104-01-T-SH-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-104-01-T-SH-A-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009865s ]
SELECT `id` FROM `stock` WHERE `id` <> 59620804 AND `partno` = 'TSM-104-01-T-SH-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.009762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12726120 [ RunTime:0.013905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59616167 LIMIT 5 [ RunTime:0.012114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59616167 ORDER BY `minOrder` ASC [ RunTime:0.008119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59616167 ORDER BY `unit` DESC [ RunTime:0.012700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59616167 LIMIT 2 [ RunTime:0.017904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59616167 ORDER BY `minOrder` ASC [ RunTime:0.002586s ]
select * from pdf where partno='TSM-104-01-T-SH-LC-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008059s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-104-01-T-SH-LC-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004177s ]
SELECT `id` FROM `stock` WHERE `id` <> 59616167 AND `partno` = 'TSM-104-01-T-SH-LC-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12723434 [ RunTime:0.000913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59613845 LIMIT 5 [ RunTime:0.006017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59613845 ORDER BY `minOrder` ASC [ RunTime:0.004602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59613845 ORDER BY `unit` DESC [ RunTime:0.007496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59613845 LIMIT 2 [ RunTime:0.009116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59613845 ORDER BY `minOrder` ASC [ RunTime:0.000520s ]
select * from pdf where partno='TSM-104-01-T-SH-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001069s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-104-01-T-SH-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009309s ]
SELECT `id` FROM `stock` WHERE `id` <> 59613845 AND `partno` = 'TSM-104-01-T-SH-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.017206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12722026 [ RunTime:0.002205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59612185 LIMIT 5 [ RunTime:0.005008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59612185 ORDER BY `minOrder` ASC [ RunTime:0.025947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59612185 ORDER BY `unit` DESC [ RunTime:0.006050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59612185 LIMIT 2 [ RunTime:0.009622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59612185 ORDER BY `minOrder` ASC [ RunTime:0.000536s ]
select * from pdf where partno='TSM-104-01-T-SH-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001135s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-104-01-T-SH-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002168s ]
SELECT `id` FROM `stock` WHERE `id` <> 59612185 AND `partno` = 'TSM-104-01-T-SH-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.017331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12721010 [ RunTime:0.001896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59611047 LIMIT 5 [ RunTime:0.001155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59611047 ORDER BY `minOrder` ASC [ RunTime:0.005321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59611047 ORDER BY `unit` DESC [ RunTime:0.003849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59611047 LIMIT 2 [ RunTime:0.000377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59611047 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
select * from pdf where partno='TSM-104-01-T-SH-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005576s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-104-01-T-SH-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003063s ]
SELECT `id` FROM `stock` WHERE `id` <> 59611047 AND `partno` = 'TSM-104-01-T-SH-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12720376 [ RunTime:0.003069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59606928 LIMIT 5 [ RunTime:0.004192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59606928 ORDER BY `minOrder` ASC [ RunTime:0.000974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59606928 ORDER BY `unit` DESC [ RunTime:0.000523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59606928 LIMIT 2 [ RunTime:0.000974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59606928 ORDER BY `minOrder` ASC [ RunTime:0.001162s ]
select * from pdf where partno='TSM-104-01-T-SH-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001247s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-104-01-T-SH-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002225s ]
SELECT `id` FROM `stock` WHERE `id` <> 59606928 AND `partno` = 'TSM-104-01-T-SH-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59605092 LIMIT 5 [ RunTime:0.001493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59605092 ORDER BY `minOrder` ASC [ RunTime:0.005144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59605092 ORDER BY `unit` DESC [ RunTime:0.001886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59605092 LIMIT 2 [ RunTime:0.004055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59605092 ORDER BY `minOrder` ASC [ RunTime:0.008267s ]
select * from pdf where partno='TSM-104-01-T-SH-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002920s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-104-01-T-SH-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006470s ]
SELECT `id` FROM `stock` WHERE `id` <> 59605092 AND `partno` = 'TSM-104-01-T-SH-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12716751 [ RunTime:0.001084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59597990 LIMIT 5 [ RunTime:0.000872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59597990 ORDER BY `minOrder` ASC [ RunTime:0.010960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59597990 ORDER BY `unit` DESC [ RunTime:0.009680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59597990 LIMIT 2 [ RunTime:0.024672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59597990 ORDER BY `minOrder` ASC [ RunTime:0.007080s ]
select * from pdf where partno='TSM-104-01-T-SH-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002885s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-104-01-T-SH-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.032444s ]
SELECT `id` FROM `stock` WHERE `id` <> 59597990 AND `partno` = 'TSM-104-01-T-SH-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.035570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59539854 LIMIT 5 [ RunTime:0.024503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59539854 ORDER BY `minOrder` ASC [ RunTime:0.016942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59539854 ORDER BY `unit` DESC [ RunTime:0.043167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59539854 LIMIT 2 [ RunTime:0.013747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59539854 ORDER BY `minOrder` ASC [ RunTime:0.019499s ]
select * from pdf where partno='TSM-104-01-T-SH-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.033131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-104-01-T-SH-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.028864s ]
SELECT `id` FROM `stock` WHERE `id` <> 59539854 AND `partno` = 'TSM-104-01-T-SH-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.024248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16237801 [ RunTime:0.053104s ]
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 'TSM-104-01-T-SH%' OR `brand` LIKE 'TSM-104-01-T-SH%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.077934s ]
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 'TSM-104-01-T-SH%' OR `brand` LIKE 'TSM-104-01-T-SH%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020800s ]
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 'TSM-104-01-T-SH%' OR `brand` LIKE 'TSM-104-01-T-SH%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048785s ]
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 'TSM-104-01-T-SH%' OR `brand` LIKE 'TSM-104-01-T-SH%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.070219s ]
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 'TSM-104-01-T-SH%' OR `brand` LIKE 'TSM-104-01-T-SH%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.089453s ]
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 'TSM-104-01-T-SH%' OR `brand` LIKE 'TSM-104-01-T-SH%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008719s ]
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 'TSM-104-01-T-SH%' OR `brand` LIKE 'TSM-104-01-T-SH%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027637s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TSM-104-01-T-SH%' OR `brand` LIKE 'TSM-104-01-T-SH%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.024691s ]