SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001494s ]
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 'FTSH-122-01-L-D%' OR `brand` LIKE 'FTSH-122-01-L-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011468s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19833884 LIMIT 5 [ RunTime:0.024142s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833884 ORDER BY `minOrder` ASC [ RunTime:0.005786s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19833884 ORDER BY `unit` DESC [ RunTime:0.013368s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19833884 LIMIT 2 [ RunTime:0.027124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833884 ORDER BY `minOrder` ASC [ RunTime:0.015430s ]
select * from pdf where partno='FTSH-122-01-L-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.040673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19832836 LIMIT 5 [ RunTime:0.023330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19832836 ORDER BY `minOrder` ASC [ RunTime:0.023130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19832836 ORDER BY `unit` DESC [ RunTime:0.010876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19832836 LIMIT 2 [ RunTime:0.019021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19832836 ORDER BY `minOrder` ASC [ RunTime:0.005320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19810094 LIMIT 5 [ RunTime:0.032361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19810094 ORDER BY `minOrder` ASC [ RunTime:0.015463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19810094 ORDER BY `unit` DESC [ RunTime:0.036844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19810094 LIMIT 2 [ RunTime:0.044988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19810094 ORDER BY `minOrder` ASC [ RunTime:0.020787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16213856 LIMIT 5 [ RunTime:0.046043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16213856 ORDER BY `minOrder` ASC [ RunTime:0.027063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16213856 ORDER BY `unit` DESC [ RunTime:0.067256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16213856 LIMIT 2 [ RunTime:0.020798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16213856 ORDER BY `minOrder` ASC [ RunTime:0.019545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16187354 LIMIT 5 [ RunTime:0.016415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16187354 ORDER BY `minOrder` ASC [ RunTime:0.029982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16187354 ORDER BY `unit` DESC [ RunTime:0.026200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16187354 LIMIT 2 [ RunTime:0.032801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16187354 ORDER BY `minOrder` ASC [ RunTime:0.040961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12748328 LIMIT 5 [ RunTime:0.025526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12748328 ORDER BY `minOrder` ASC [ RunTime:0.016615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12748328 ORDER BY `unit` DESC [ RunTime:0.017888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12748328 LIMIT 2 [ RunTime:0.029798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12748328 ORDER BY `minOrder` ASC [ RunTime:0.017973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12747496 LIMIT 5 [ RunTime:0.063641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12747496 ORDER BY `minOrder` ASC [ RunTime:0.023598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12747496 ORDER BY `unit` DESC [ RunTime:0.030619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12747496 LIMIT 2 [ RunTime:0.013609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12747496 ORDER BY `minOrder` ASC [ RunTime:0.008628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12744205 LIMIT 5 [ RunTime:0.024180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12744205 ORDER BY `minOrder` ASC [ RunTime:0.029478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12744205 ORDER BY `unit` DESC [ RunTime:0.007750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12744205 LIMIT 2 [ RunTime:0.043460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12744205 ORDER BY `minOrder` ASC [ RunTime:0.016168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12743721 LIMIT 5 [ RunTime:0.030363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12743721 ORDER BY `minOrder` ASC [ RunTime:0.048358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12743721 ORDER BY `unit` DESC [ RunTime:0.027038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12743721 LIMIT 2 [ RunTime:0.007462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12743721 ORDER BY `minOrder` ASC [ RunTime:0.006622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12740073 LIMIT 5 [ RunTime:0.016917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740073 ORDER BY `minOrder` ASC [ RunTime:0.003936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12740073 ORDER BY `unit` DESC [ RunTime:0.000657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12740073 LIMIT 2 [ RunTime:0.006768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740073 ORDER BY `minOrder` ASC [ RunTime:0.011367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11579837 LIMIT 5 [ RunTime:0.000965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11579837 ORDER BY `minOrder` ASC [ RunTime:0.001077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11579837 ORDER BY `unit` DESC [ RunTime:0.001420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11579837 LIMIT 2 [ RunTime:0.000580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11579837 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
select * from pdf where partno='FTSH-122-01-L-DH' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11576402 LIMIT 5 [ RunTime:0.003613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11576402 ORDER BY `minOrder` ASC [ RunTime:0.003502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11576402 ORDER BY `unit` DESC [ RunTime:0.009024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11576402 LIMIT 2 [ RunTime:0.000546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11576402 ORDER BY `minOrder` ASC [ RunTime:0.004151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11575476 LIMIT 5 [ RunTime:0.001862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11575476 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11575476 ORDER BY `unit` DESC [ RunTime:0.005827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11575476 LIMIT 2 [ RunTime:0.014917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11575476 ORDER BY `minOrder` ASC [ RunTime:0.005116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11574594 LIMIT 5 [ RunTime:0.004613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11574594 ORDER BY `minOrder` ASC [ RunTime:0.006772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11574594 ORDER BY `unit` DESC [ RunTime:0.001693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11574594 LIMIT 2 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11574594 ORDER BY `minOrder` ASC [ RunTime:0.000900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11571572 LIMIT 5 [ RunTime:0.002629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11571572 ORDER BY `minOrder` ASC [ RunTime:0.003170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11571572 ORDER BY `unit` DESC [ RunTime:0.000540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11571572 LIMIT 2 [ RunTime:0.001210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11571572 ORDER BY `minOrder` ASC [ RunTime:0.002927s ]
select * from pdf where partno='FTSH-122-01-L-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001263s ]
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 'FTSH-122-01-L-D%' OR `brand` LIKE 'FTSH-122-01-L-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006698s ]
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 'FTSH-122-01-L-D%' OR `brand` LIKE 'FTSH-122-01-L-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59714705 LIMIT 5 [ RunTime:0.001861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59714705 ORDER BY `minOrder` ASC [ RunTime:0.002459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59714705 ORDER BY `unit` DESC [ RunTime:0.004536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59714705 LIMIT 2 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59714705 ORDER BY `minOrder` ASC [ RunTime:0.003698s ]
select * from pdf where partno='FTSH-122-01-L-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.016288s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001178s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-122-01-L-DV' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003577s ]
SELECT `id` FROM `stock` WHERE `id` <> 59714705 AND `partno` = 'FTSH-122-01-L-DV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11571572 [ RunTime:0.001800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59720144 LIMIT 5 [ RunTime:0.015323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59720144 ORDER BY `minOrder` ASC [ RunTime:0.002796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59720144 ORDER BY `unit` DESC [ RunTime:0.000620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59720144 LIMIT 2 [ RunTime:0.006842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59720144 ORDER BY `minOrder` ASC [ RunTime:0.002529s ]
select * from pdf where partno='FTSH-122-01-L-DH' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-122-01-L-DH' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004525s ]
SELECT `id` FROM `stock` WHERE `id` <> 59720144 AND `partno` = 'FTSH-122-01-L-DH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11579837 [ RunTime:0.001377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59706895 LIMIT 5 [ RunTime:0.001060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59706895 ORDER BY `minOrder` ASC [ RunTime:0.001176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59706895 ORDER BY `unit` DESC [ RunTime:0.002004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59706895 LIMIT 2 [ RunTime:0.006483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59706895 ORDER BY `minOrder` ASC [ RunTime:0.004609s ]
select * from pdf where partno='FTSH-122-01-L-DV-EJ-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-122-01-L-DV-EJ-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004569s ]
SELECT `id` FROM `stock` WHERE `id` <> 59706895 AND `partno` = 'FTSH-122-01-L-DV-EJ-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59706343 LIMIT 5 [ RunTime:0.002151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59706343 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59706343 ORDER BY `unit` DESC [ RunTime:0.000451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59706343 LIMIT 2 [ RunTime:0.000414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59706343 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
select * from pdf where partno='FTSH-122-01-L-DH-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-122-01-L-DH-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000562s ]
SELECT `id` FROM `stock` WHERE `id` <> 59706343 AND `partno` = 'FTSH-122-01-L-DH-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12748328 [ RunTime:0.000433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59705008 LIMIT 5 [ RunTime:0.002587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59705008 ORDER BY `minOrder` ASC [ RunTime:0.001183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59705008 ORDER BY `unit` DESC [ RunTime:0.011430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59705008 LIMIT 2 [ RunTime:0.003447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59705008 ORDER BY `minOrder` ASC [ RunTime:0.002806s ]
select * from pdf where partno='FTSH-122-01-L-DV-K-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001056s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-122-01-L-DV-K-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005166s ]
SELECT `id` FROM `stock` WHERE `id` <> 59705008 AND `partno` = 'FTSH-122-01-L-DV-K-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12747496 [ RunTime:0.003037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59703144 LIMIT 5 [ RunTime:0.007457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59703144 ORDER BY `minOrder` ASC [ RunTime:0.009807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59703144 ORDER BY `unit` DESC [ RunTime:0.014306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59703144 LIMIT 2 [ RunTime:0.000657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59703144 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
select * from pdf where partno='FTSH-122-01-L-DV-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-122-01-L-DV-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004699s ]
SELECT `id` FROM `stock` WHERE `id` <> 59703144 AND `partno` = 'FTSH-122-01-L-DV-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.027815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11576402 [ RunTime:0.005091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59700845 LIMIT 5 [ RunTime:0.003353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59700845 ORDER BY `minOrder` ASC [ RunTime:0.001461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59700845 ORDER BY `unit` DESC [ RunTime:0.008997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59700845 LIMIT 2 [ RunTime:0.005775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59700845 ORDER BY `minOrder` ASC [ RunTime:0.003849s ]
select * from pdf where partno='FTSH-122-01-L-D-EJ' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009517s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-122-01-L-D-EJ' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001084s ]
SELECT `id` FROM `stock` WHERE `id` <> 59700845 AND `partno` = 'FTSH-122-01-L-D-EJ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11575476 [ RunTime:0.010053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59699101 LIMIT 5 [ RunTime:0.000651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59699101 ORDER BY `minOrder` ASC [ RunTime:0.008831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59699101 ORDER BY `unit` DESC [ RunTime:0.005633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59699101 LIMIT 2 [ RunTime:0.014866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59699101 ORDER BY `minOrder` ASC [ RunTime:0.015983s ]
select * from pdf where partno='FTSH-122-01-L-D-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.034821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-122-01-L-D-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012616s ]
SELECT `id` FROM `stock` WHERE `id` <> 59699101 AND `partno` = 'FTSH-122-01-L-D-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.017056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12744205 [ RunTime:0.015538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59698733 LIMIT 5 [ RunTime:0.021724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59698733 ORDER BY `minOrder` ASC [ RunTime:0.048583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59698733 ORDER BY `unit` DESC [ RunTime:0.017759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59698733 LIMIT 2 [ RunTime:0.011145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59698733 ORDER BY `minOrder` ASC [ RunTime:0.009643s ]
select * from pdf where partno='FTSH-122-01-L-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.012657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-122-01-L-DV-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.013523s ]
SELECT `id` FROM `stock` WHERE `id` <> 59698733 AND `partno` = 'FTSH-122-01-L-DV-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11574594 [ RunTime:0.027400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59698267 LIMIT 5 [ RunTime:0.013137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59698267 ORDER BY `minOrder` ASC [ RunTime:0.028066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59698267 ORDER BY `unit` DESC [ RunTime:0.009813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59698267 LIMIT 2 [ RunTime:0.055609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59698267 ORDER BY `minOrder` ASC [ RunTime:0.007955s ]
select * from pdf where partno='FTSH-122-01-L-DV-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.016664s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-122-01-L-DV-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.025615s ]
SELECT `id` FROM `stock` WHERE `id` <> 59698267 AND `partno` = 'FTSH-122-01-L-DV-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.025473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12743721 [ RunTime:0.015587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59697978 LIMIT 5 [ RunTime:0.019865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59697978 ORDER BY `minOrder` ASC [ RunTime:0.046498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59697978 ORDER BY `unit` DESC [ RunTime:0.042626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59697978 LIMIT 2 [ RunTime:0.021724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59697978 ORDER BY `minOrder` ASC [ RunTime:0.005139s ]
select * from pdf where partno='FTSH-122-01-L-DV-K-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.029888s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-122-01-L-DV-K-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.069998s ]
SELECT `id` FROM `stock` WHERE `id` <> 59697978 AND `partno` = 'FTSH-122-01-L-DV-K-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.046769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12740073 [ RunTime:0.005363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59689876 LIMIT 5 [ RunTime:0.004675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59689876 ORDER BY `minOrder` ASC [ RunTime:0.042533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59689876 ORDER BY `unit` DESC [ RunTime:0.042553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59689876 LIMIT 2 [ RunTime:0.044508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59689876 ORDER BY `minOrder` ASC [ RunTime:0.006556s ]
select * from pdf where partno='FTSH-122-01-L-DV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.033877s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-122-01-L-DV-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.017051s ]
SELECT `id` FROM `stock` WHERE `id` <> 59689876 AND `partno` = 'FTSH-122-01-L-DV-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.022869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19810094 [ RunTime:0.080192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59687632 LIMIT 5 [ RunTime:0.051441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59687632 ORDER BY `minOrder` ASC [ RunTime:0.028874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59687632 ORDER BY `unit` DESC [ RunTime:0.079207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59687632 LIMIT 2 [ RunTime:0.032965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59687632 ORDER BY `minOrder` ASC [ RunTime:0.048040s ]
select * from pdf where partno='FTSH-122-01-L-DV-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.050000s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-122-01-L-DV-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.021024s ]
SELECT `id` FROM `stock` WHERE `id` <> 59687632 AND `partno` = 'FTSH-122-01-L-DV-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.053840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16213856 [ RunTime:0.032536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59565539 LIMIT 5 [ RunTime:0.040173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59565539 ORDER BY `minOrder` ASC [ RunTime:0.049759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59565539 ORDER BY `unit` DESC [ RunTime:0.039549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59565539 LIMIT 2 [ RunTime:0.033583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59565539 ORDER BY `minOrder` ASC [ RunTime:0.004074s ]
select * from pdf where partno='FTSH-122-01-L-DV-EJ' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.047305s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-122-01-L-DV-EJ' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.030099s ]
SELECT `id` FROM `stock` WHERE `id` <> 59565539 AND `partno` = 'FTSH-122-01-L-DV-EJ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.009985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16187354 [ RunTime:0.031232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59510845 LIMIT 5 [ RunTime:0.050131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59510845 ORDER BY `minOrder` ASC [ RunTime:0.039154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59510845 ORDER BY `unit` DESC [ RunTime:0.007797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59510845 LIMIT 2 [ RunTime:0.032241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59510845 ORDER BY `minOrder` ASC [ RunTime:0.017244s ]
select * from pdf where partno='FTSH-122-01-L-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.024770s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-122-01-L-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.031338s ]
SELECT `id` FROM `stock` WHERE `id` <> 59510845 AND `partno` = 'FTSH-122-01-L-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.073358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19833884 [ RunTime:0.050297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59508048 LIMIT 5 [ RunTime:0.021131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59508048 ORDER BY `minOrder` ASC [ RunTime:0.033885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59508048 ORDER BY `unit` DESC [ RunTime:0.021000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59508048 LIMIT 2 [ RunTime:0.037525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59508048 ORDER BY `minOrder` ASC [ RunTime:0.017586s ]
select * from pdf where partno='FTSH-122-01-L-D-RA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.034162s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-122-01-L-D-RA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.036975s ]
SELECT `id` FROM `stock` WHERE `id` <> 59508048 AND `partno` = 'FTSH-122-01-L-D-RA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.066966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19832836 [ RunTime:0.098606s ]
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 'FTSH-122-01-L-D%' OR `brand` LIKE 'FTSH-122-01-L-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027447s ]
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 'FTSH-122-01-L-D%' OR `brand` LIKE 'FTSH-122-01-L-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042749s ]
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 'FTSH-122-01-L-D%' OR `brand` LIKE 'FTSH-122-01-L-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.067556s ]
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 'FTSH-122-01-L-D%' OR `brand` LIKE 'FTSH-122-01-L-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.090063s ]
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 'FTSH-122-01-L-D%' OR `brand` LIKE 'FTSH-122-01-L-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058011s ]
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 'FTSH-122-01-L-D%' OR `brand` LIKE 'FTSH-122-01-L-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049281s ]
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 'FTSH-122-01-L-D%' OR `brand` LIKE 'FTSH-122-01-L-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047532s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'FTSH-122-01-L-D%' OR `brand` LIKE 'FTSH-122-01-L-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.037709s ]