SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002785s ]
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-120-01-F-DV%' OR `brand` LIKE 'FTSH-120-01-F-DV%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065045s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19767605 LIMIT 5 [ RunTime:0.028155s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.015149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19767605 ORDER BY `minOrder` ASC [ RunTime:0.059533s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19767605 ORDER BY `unit` DESC [ RunTime:0.037938s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007134s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19767605 LIMIT 2 [ RunTime:0.047288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19767605 ORDER BY `minOrder` ASC [ RunTime:0.016688s ]
select * from pdf where partno='FTSH-120-01-F-DV-K-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.054735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19764952 LIMIT 5 [ RunTime:0.034915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19764952 ORDER BY `minOrder` ASC [ RunTime:0.051969s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19764952 ORDER BY `unit` DESC [ RunTime:0.028198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19764952 LIMIT 2 [ RunTime:0.034403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19764952 ORDER BY `minOrder` ASC [ RunTime:0.030962s ]
select * from pdf where partno='FTSH-120-01-F-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.056704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16193550 LIMIT 5 [ RunTime:0.049681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16193550 ORDER BY `minOrder` ASC [ RunTime:0.054037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16193550 ORDER BY `unit` DESC [ RunTime:0.035256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16193550 LIMIT 2 [ RunTime:0.005543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16193550 ORDER BY `minOrder` ASC [ RunTime:0.018067s ]
select * from pdf where partno='FTSH-120-01-F-DV-K-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.030175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19766974 LIMIT 5 [ RunTime:0.016013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19766974 ORDER BY `minOrder` ASC [ RunTime:0.030231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19766974 ORDER BY `unit` DESC [ RunTime:0.026994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19766974 LIMIT 2 [ RunTime:0.024798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19766974 ORDER BY `minOrder` ASC [ RunTime:0.029728s ]
select * from pdf where partno='FTSH-120-01-F-DV-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.034845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19765616 LIMIT 5 [ RunTime:0.021419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19765616 ORDER BY `minOrder` ASC [ RunTime:0.026424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19765616 ORDER BY `unit` DESC [ RunTime:0.011653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19765616 LIMIT 2 [ RunTime:0.008992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19765616 ORDER BY `minOrder` ASC [ RunTime:0.010335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16197089 LIMIT 5 [ RunTime:0.006977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197089 ORDER BY `minOrder` ASC [ RunTime:0.009047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16197089 ORDER BY `unit` DESC [ RunTime:0.012449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16197089 LIMIT 2 [ RunTime:0.006267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197089 ORDER BY `minOrder` ASC [ RunTime:0.001559s ]
select * from pdf where partno='FTSH-120-01-F-DV-K-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19833929 LIMIT 5 [ RunTime:0.011973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833929 ORDER BY `minOrder` ASC [ RunTime:0.018465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19833929 ORDER BY `unit` DESC [ RunTime:0.004826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19833929 LIMIT 2 [ RunTime:0.014185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833929 ORDER BY `minOrder` ASC [ RunTime:0.004479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19811910 LIMIT 5 [ RunTime:0.009944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19811910 ORDER BY `minOrder` ASC [ RunTime:0.009807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19811910 ORDER BY `unit` DESC [ RunTime:0.003245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19811910 LIMIT 2 [ RunTime:0.000826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19811910 ORDER BY `minOrder` ASC [ RunTime:0.006993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19808842 LIMIT 5 [ RunTime:0.012129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19808842 ORDER BY `minOrder` ASC [ RunTime:0.001906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19808842 ORDER BY `unit` DESC [ RunTime:0.009275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19808842 LIMIT 2 [ RunTime:0.000892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19808842 ORDER BY `minOrder` ASC [ RunTime:0.011057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16227335 LIMIT 5 [ RunTime:0.001134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16227335 ORDER BY `minOrder` ASC [ RunTime:0.000667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16227335 ORDER BY `unit` DESC [ RunTime:0.008292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16227335 LIMIT 2 [ RunTime:0.003391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16227335 ORDER BY `minOrder` ASC [ RunTime:0.002218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16213492 LIMIT 5 [ RunTime:0.009222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16213492 ORDER BY `minOrder` ASC [ RunTime:0.020584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16213492 ORDER BY `unit` DESC [ RunTime:0.013467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16213492 LIMIT 2 [ RunTime:0.003421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16213492 ORDER BY `minOrder` ASC [ RunTime:0.003304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15490133 LIMIT 5 [ RunTime:0.006984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15490133 ORDER BY `minOrder` ASC [ RunTime:0.001792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15490133 ORDER BY `unit` DESC [ RunTime:0.004893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15490133 LIMIT 2 [ RunTime:0.000643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15490133 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15490073 LIMIT 5 [ RunTime:0.002445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15490073 ORDER BY `minOrder` ASC [ RunTime:0.005162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15490073 ORDER BY `unit` DESC [ RunTime:0.009179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15490073 LIMIT 2 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15490073 ORDER BY `minOrder` ASC [ RunTime:0.006759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12744510 LIMIT 5 [ RunTime:0.002955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12744510 ORDER BY `minOrder` ASC [ RunTime:0.008303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12744510 ORDER BY `unit` DESC [ RunTime:0.013444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12744510 LIMIT 2 [ RunTime:0.008284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12744510 ORDER BY `minOrder` ASC [ RunTime:0.020468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12744001 LIMIT 5 [ RunTime:0.004140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12744001 ORDER BY `minOrder` ASC [ RunTime:0.023344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12744001 ORDER BY `unit` DESC [ RunTime:0.016256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12744001 LIMIT 2 [ RunTime:0.005994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12744001 ORDER BY `minOrder` ASC [ RunTime:0.002372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12743559 LIMIT 5 [ RunTime:0.001037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12743559 ORDER BY `minOrder` ASC [ RunTime:0.000711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12743559 ORDER BY `unit` DESC [ RunTime:0.001144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12743559 LIMIT 2 [ RunTime:0.000536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12743559 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12738792 LIMIT 5 [ RunTime:0.001159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12738792 ORDER BY `minOrder` ASC [ RunTime:0.008701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12738792 ORDER BY `unit` DESC [ RunTime:0.004034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12738792 LIMIT 2 [ RunTime:0.015412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12738792 ORDER BY `minOrder` ASC [ RunTime:0.006437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11576894 LIMIT 5 [ RunTime:0.003577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11576894 ORDER BY `minOrder` ASC [ RunTime:0.000892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11576894 ORDER BY `unit` DESC [ RunTime:0.006104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11576894 LIMIT 2 [ RunTime:0.019337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11576894 ORDER BY `minOrder` ASC [ RunTime:0.003311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11576730 LIMIT 5 [ RunTime:0.015551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11576730 ORDER BY `minOrder` ASC [ RunTime:0.014797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11576730 ORDER BY `unit` DESC [ RunTime:0.010926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11576730 LIMIT 2 [ RunTime:0.004237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11576730 ORDER BY `minOrder` ASC [ RunTime:0.005377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11573795 LIMIT 5 [ RunTime:0.015657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11573795 ORDER BY `minOrder` ASC [ RunTime:0.003259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11573795 ORDER BY `unit` DESC [ RunTime:0.020841s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11573795 LIMIT 2 [ RunTime:0.001207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11573795 ORDER BY `minOrder` ASC [ RunTime:0.009609s ]
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-120-01-F-DV%' OR `brand` LIKE 'FTSH-120-01-F-DV%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009917s ]
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-120-01-F-DV%' OR `brand` LIKE 'FTSH-120-01-F-DV%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59441438 LIMIT 5 [ RunTime:0.007233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59441438 ORDER BY `minOrder` ASC [ RunTime:0.017775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59441438 ORDER BY `unit` DESC [ RunTime:0.023936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59441438 LIMIT 2 [ RunTime:0.003364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59441438 ORDER BY `minOrder` ASC [ RunTime:0.004578s ]
select * from pdf where partno='FTSH-120-01-F-DV-K-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002013s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002317s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-F-DV-K-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005748s ]
SELECT `id` FROM `stock` WHERE `id` <> 59441438 AND `partno` = 'FTSH-120-01-F-DV-K-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19767605 [ RunTime:0.015886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59446451 LIMIT 5 [ RunTime:0.005374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446451 ORDER BY `minOrder` ASC [ RunTime:0.013802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59446451 ORDER BY `unit` DESC [ RunTime:0.022871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59446451 LIMIT 2 [ RunTime:0.037808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446451 ORDER BY `minOrder` ASC [ RunTime:0.018681s ]
select * from pdf where partno='FTSH-120-01-F-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002193s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-F-DV' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.015343s ]
SELECT `id` FROM `stock` WHERE `id` <> 59446451 AND `partno` = 'FTSH-120-01-F-DV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.028465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19764952 [ RunTime:0.030540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59446919 LIMIT 5 [ RunTime:0.014840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446919 ORDER BY `minOrder` ASC [ RunTime:0.013128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59446919 ORDER BY `unit` DESC [ RunTime:0.020791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59446919 LIMIT 2 [ RunTime:0.050251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446919 ORDER BY `minOrder` ASC [ RunTime:0.009872s ]
select * from pdf where partno='FTSH-120-01-F-DV-K-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019886s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-F-DV-K-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.065429s ]
SELECT `id` FROM `stock` WHERE `id` <> 59446919 AND `partno` = 'FTSH-120-01-F-DV-K-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16193550 [ RunTime:0.030334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59446574 LIMIT 5 [ RunTime:0.041533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446574 ORDER BY `minOrder` ASC [ RunTime:0.053056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59446574 ORDER BY `unit` DESC [ RunTime:0.075912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59446574 LIMIT 2 [ RunTime:0.054933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446574 ORDER BY `minOrder` ASC [ RunTime:0.009720s ]
select * from pdf where partno='FTSH-120-01-F-DV-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.039348s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-F-DV-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019146s ]
SELECT `id` FROM `stock` WHERE `id` <> 59446574 AND `partno` = 'FTSH-120-01-F-DV-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.060826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19765616 [ RunTime:0.020416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59446817 LIMIT 5 [ RunTime:0.069635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446817 ORDER BY `minOrder` ASC [ RunTime:0.044170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59446817 ORDER BY `unit` DESC [ RunTime:0.068338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59446817 LIMIT 2 [ RunTime:0.085042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446817 ORDER BY `minOrder` ASC [ RunTime:0.022555s ]
select * from pdf where partno='FTSH-120-01-F-DV-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-F-DV-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.041026s ]
SELECT `id` FROM `stock` WHERE `id` <> 59446817 AND `partno` = 'FTSH-120-01-F-DV-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.053080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19766974 [ RunTime:0.022603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59450538 LIMIT 5 [ RunTime:0.029251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59450538 ORDER BY `minOrder` ASC [ RunTime:0.033651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59450538 ORDER BY `unit` DESC [ RunTime:0.013308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59450538 LIMIT 2 [ RunTime:0.082914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59450538 ORDER BY `minOrder` ASC [ RunTime:0.036647s ]
select * from pdf where partno='FTSH-120-01-F-DV-K-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013786s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-F-DV-K-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.085829s ]
SELECT `id` FROM `stock` WHERE `id` <> 59450538 AND `partno` = 'FTSH-120-01-F-DV-K-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16197089 [ RunTime:0.106317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59703553 LIMIT 5 [ RunTime:0.024705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59703553 ORDER BY `minOrder` ASC [ RunTime:0.065558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59703553 ORDER BY `unit` DESC [ RunTime:0.058343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59703553 LIMIT 2 [ RunTime:0.019611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59703553 ORDER BY `minOrder` ASC [ RunTime:0.015157s ]
select * from pdf where partno='FTSH-120-01-F-DV-EJ-K-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.062384s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-F-DV-EJ-K-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.074881s ]
SELECT `id` FROM `stock` WHERE `id` <> 59703553 AND `partno` = 'FTSH-120-01-F-DV-EJ-K-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.074270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11576894 [ RunTime:0.082743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59703124 LIMIT 5 [ RunTime:0.083451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59703124 ORDER BY `minOrder` ASC [ RunTime:0.074400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59703124 ORDER BY `unit` DESC [ RunTime:0.022232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59703124 LIMIT 2 [ RunTime:0.019782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59703124 ORDER BY `minOrder` ASC [ RunTime:0.025394s ]
select * from pdf where partno='FTSH-120-01-F-DV-EJ-K-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.029208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-F-DV-EJ-K-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.038112s ]
SELECT `id` FROM `stock` WHERE `id` <> 59703124 AND `partno` = 'FTSH-120-01-F-DV-EJ-K-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.037393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11576730 [ RunTime:0.038585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59699808 LIMIT 5 [ RunTime:0.026908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59699808 ORDER BY `minOrder` ASC [ RunTime:0.034618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59699808 ORDER BY `unit` DESC [ RunTime:0.012574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59699808 LIMIT 2 [ RunTime:0.012711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59699808 ORDER BY `minOrder` ASC [ RunTime:0.016581s ]
select * from pdf where partno='FTSH-120-01-F-DV-EJ-K-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-F-DV-EJ-K-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019091s ]
SELECT `id` FROM `stock` WHERE `id` <> 59699808 AND `partno` = 'FTSH-120-01-F-DV-EJ-K-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.027616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11572532 [ RunTime:0.046167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59698797 LIMIT 5 [ RunTime:0.020663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59698797 ORDER BY `minOrder` ASC [ RunTime:0.058779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59698797 ORDER BY `unit` DESC [ RunTime:0.052342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59698797 LIMIT 2 [ RunTime:0.006038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59698797 ORDER BY `minOrder` ASC [ RunTime:0.015826s ]
select * from pdf where partno='FTSH-120-01-F-DV-EJ-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.046323s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-F-DV-EJ-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.040093s ]
SELECT `id` FROM `stock` WHERE `id` <> 59698797 AND `partno` = 'FTSH-120-01-F-DV-EJ-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.033422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12744510 [ RunTime:0.004412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59697784 LIMIT 5 [ RunTime:0.017497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59697784 ORDER BY `minOrder` ASC [ RunTime:0.046551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59697784 ORDER BY `unit` DESC [ RunTime:0.034157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59697784 LIMIT 2 [ RunTime:0.011820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59697784 ORDER BY `minOrder` ASC [ RunTime:0.011554s ]
select * from pdf where partno='FTSH-120-01-F-DV-EJ-K-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010420s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-F-DV-EJ-K-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014125s ]
SELECT `id` FROM `stock` WHERE `id` <> 59697784 AND `partno` = 'FTSH-120-01-F-DV-EJ-K-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.013264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11571575 [ RunTime:0.017666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59697739 LIMIT 5 [ RunTime:0.008832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59697739 ORDER BY `minOrder` ASC [ RunTime:0.003836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59697739 ORDER BY `unit` DESC [ RunTime:0.000651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59697739 LIMIT 2 [ RunTime:0.000544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59697739 ORDER BY `minOrder` ASC [ RunTime:0.002940s ]
select * from pdf where partno='FTSH-120-01-F-DV-K-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.016477s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-F-DV-K-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.018591s ]
SELECT `id` FROM `stock` WHERE `id` <> 59697739 AND `partno` = 'FTSH-120-01-F-DV-K-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11572177 [ RunTime:0.012369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59697624 LIMIT 5 [ RunTime:0.001589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59697624 ORDER BY `minOrder` ASC [ RunTime:0.011027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59697624 ORDER BY `unit` DESC [ RunTime:0.008863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59697624 LIMIT 2 [ RunTime:0.004279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59697624 ORDER BY `minOrder` ASC [ RunTime:0.006638s ]
select * from pdf where partno='FTSH-120-01-F-DV-EJM' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000880s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-F-DV-EJM' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003160s ]
SELECT `id` FROM `stock` WHERE `id` <> 59697624 AND `partno` = 'FTSH-120-01-F-DV-EJM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.011867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59697290 LIMIT 5 [ RunTime:0.017726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59697290 ORDER BY `minOrder` ASC [ RunTime:0.016583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59697290 ORDER BY `unit` DESC [ RunTime:0.006680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59697290 LIMIT 2 [ RunTime:0.007421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59697290 ORDER BY `minOrder` ASC [ RunTime:0.002341s ]
select * from pdf where partno='FTSH-120-01-F-DV-EJ-K-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.016261s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-F-DV-EJ-K-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019403s ]
SELECT `id` FROM `stock` WHERE `id` <> 59697290 AND `partno` = 'FTSH-120-01-F-DV-EJ-K-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.018127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59696946 LIMIT 5 [ RunTime:0.006300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59696946 ORDER BY `minOrder` ASC [ RunTime:0.008465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59696946 ORDER BY `unit` DESC [ RunTime:0.012163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59696946 LIMIT 2 [ RunTime:0.020976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59696946 ORDER BY `minOrder` ASC [ RunTime:0.009210s ]
select * from pdf where partno='FTSH-120-01-F-DV-K-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008987s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-F-DV-K-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009953s ]
SELECT `id` FROM `stock` WHERE `id` <> 59696946 AND `partno` = 'FTSH-120-01-F-DV-K-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12743559 [ RunTime:0.005192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59696631 LIMIT 5 [ RunTime:0.009820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59696631 ORDER BY `minOrder` ASC [ RunTime:0.006321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59696631 ORDER BY `unit` DESC [ RunTime:0.004566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59696631 LIMIT 2 [ RunTime:0.015137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59696631 ORDER BY `minOrder` ASC [ RunTime:0.017704s ]
select * from pdf where partno='FTSH-120-01-F-DV-EJ' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-F-DV-EJ' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004311s ]
SELECT `id` FROM `stock` WHERE `id` <> 59696631 AND `partno` = 'FTSH-120-01-F-DV-EJ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.023928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12744001 [ RunTime:0.036870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59696560 LIMIT 5 [ RunTime:0.024000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59696560 ORDER BY `minOrder` ASC [ RunTime:0.043938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59696560 ORDER BY `unit` DESC [ RunTime:0.019701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59696560 LIMIT 2 [ RunTime:0.000953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59696560 ORDER BY `minOrder` ASC [ RunTime:0.010661s ]
select * from pdf where partno='FTSH-120-01-F-DV-EJ-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003261s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-F-DV-EJ-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008847s ]
SELECT `id` FROM `stock` WHERE `id` <> 59696560 AND `partno` = 'FTSH-120-01-F-DV-EJ-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.019863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59696021 LIMIT 5 [ RunTime:0.011659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59696021 ORDER BY `minOrder` ASC [ RunTime:0.029344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59696021 ORDER BY `unit` DESC [ RunTime:0.013771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59696021 LIMIT 2 [ RunTime:0.018340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59696021 ORDER BY `minOrder` ASC [ RunTime:0.011470s ]
select * from pdf where partno='FTSH-120-01-F-DV-EJ-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.021652s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-F-DV-EJ-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.040469s ]
SELECT `id` FROM `stock` WHERE `id` <> 59696021 AND `partno` = 'FTSH-120-01-F-DV-EJ-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.033097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11573795 [ RunTime:0.021314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59694928 LIMIT 5 [ RunTime:0.044084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59694928 ORDER BY `minOrder` ASC [ RunTime:0.016768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59694928 ORDER BY `unit` DESC [ RunTime:0.046026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59694928 LIMIT 2 [ RunTime:0.033992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59694928 ORDER BY `minOrder` ASC [ RunTime:0.010940s ]
select * from pdf where partno='FTSH-120-01-F-DV-EJ-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.028101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-F-DV-EJ-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.045035s ]
SELECT `id` FROM `stock` WHERE `id` <> 59694928 AND `partno` = 'FTSH-120-01-F-DV-EJ-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.052955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12738792 [ RunTime:0.034612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59692218 LIMIT 5 [ RunTime:0.059472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59692218 ORDER BY `minOrder` ASC [ RunTime:0.042319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59692218 ORDER BY `unit` DESC [ RunTime:0.023465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59692218 LIMIT 2 [ RunTime:0.021814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59692218 ORDER BY `minOrder` ASC [ RunTime:0.022909s ]
select * from pdf where partno='FTSH-120-01-F-DV-EJ-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013144s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-F-DV-EJ-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.077460s ]
SELECT `id` FROM `stock` WHERE `id` <> 59692218 AND `partno` = 'FTSH-120-01-F-DV-EJ-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.027394s ]
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-120-01-F-DV%' OR `brand` LIKE 'FTSH-120-01-F-DV%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030843s ]
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-120-01-F-DV%' OR `brand` LIKE 'FTSH-120-01-F-DV%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051125s ]
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-120-01-F-DV%' OR `brand` LIKE 'FTSH-120-01-F-DV%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011070s ]
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-120-01-F-DV%' OR `brand` LIKE 'FTSH-120-01-F-DV%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035322s ]
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-120-01-F-DV%' OR `brand` LIKE 'FTSH-120-01-F-DV%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049470s ]
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-120-01-F-DV%' OR `brand` LIKE 'FTSH-120-01-F-DV%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023758s ]
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-120-01-F-DV%' OR `brand` LIKE 'FTSH-120-01-F-DV%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031761s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'FTSH-120-01-F-DV%' OR `brand` LIKE 'FTSH-120-01-F-DV%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.031011s ]