SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002568s ]
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-L-DV-EJ%' OR `brand` LIKE 'FTSH-120-01-L-DV-EJ%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014587s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19842571 LIMIT 5 [ RunTime:0.008257s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19842571 ORDER BY `minOrder` ASC [ RunTime:0.004220s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19842571 ORDER BY `unit` DESC [ RunTime:0.022743s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19842571 LIMIT 2 [ RunTime:0.022974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19842571 ORDER BY `minOrder` ASC [ RunTime:0.004542s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.025299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15477147 LIMIT 5 [ RunTime:0.035624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15477147 ORDER BY `minOrder` ASC [ RunTime:0.005139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15477147 ORDER BY `unit` DESC [ RunTime:0.005776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15477147 LIMIT 2 [ RunTime:0.031244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15477147 ORDER BY `minOrder` ASC [ RunTime:0.011702s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.020914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19852106 LIMIT 5 [ RunTime:0.024472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19852106 ORDER BY `minOrder` ASC [ RunTime:0.054629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19852106 ORDER BY `unit` DESC [ RunTime:0.023019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19852106 LIMIT 2 [ RunTime:0.038489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19852106 ORDER BY `minOrder` ASC [ RunTime:0.004751s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ-K-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.018842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19834034 LIMIT 5 [ RunTime:0.011154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19834034 ORDER BY `minOrder` ASC [ RunTime:0.042611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19834034 ORDER BY `unit` DESC [ RunTime:0.005508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19834034 LIMIT 2 [ RunTime:0.027012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19834034 ORDER BY `minOrder` ASC [ RunTime:0.009118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19834014 LIMIT 5 [ RunTime:0.041615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19834014 ORDER BY `minOrder` ASC [ RunTime:0.034582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19834014 ORDER BY `unit` DESC [ RunTime:0.034111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19834014 LIMIT 2 [ RunTime:0.036327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19834014 ORDER BY `minOrder` ASC [ RunTime:0.027352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16197122 LIMIT 5 [ RunTime:0.037417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197122 ORDER BY `minOrder` ASC [ RunTime:0.038933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16197122 ORDER BY `unit` DESC [ RunTime:0.045212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16197122 LIMIT 2 [ RunTime:0.050128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197122 ORDER BY `minOrder` ASC [ RunTime:0.025677s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16188054 LIMIT 5 [ RunTime:0.019373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16188054 ORDER BY `minOrder` ASC [ RunTime:0.042927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16188054 ORDER BY `unit` DESC [ RunTime:0.023876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16188054 LIMIT 2 [ RunTime:0.018471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16188054 ORDER BY `minOrder` ASC [ RunTime:0.031902s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.047063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12751064 LIMIT 5 [ RunTime:0.011009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12751064 ORDER BY `minOrder` ASC [ RunTime:0.019189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12751064 ORDER BY `unit` DESC [ RunTime:0.018422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12751064 LIMIT 2 [ RunTime:0.002962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12751064 ORDER BY `minOrder` ASC [ RunTime:0.007071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12749890 LIMIT 5 [ RunTime:0.009970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12749890 ORDER BY `minOrder` ASC [ RunTime:0.009420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12749890 ORDER BY `unit` DESC [ RunTime:0.017755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12749890 LIMIT 2 [ RunTime:0.003752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12749890 ORDER BY `minOrder` ASC [ RunTime:0.008784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12749196 LIMIT 5 [ RunTime:0.005782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12749196 ORDER BY `minOrder` ASC [ RunTime:0.005336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12749196 ORDER BY `unit` DESC [ RunTime:0.008396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12749196 LIMIT 2 [ RunTime:0.000720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12749196 ORDER BY `minOrder` ASC [ RunTime:0.003003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12747591 LIMIT 5 [ RunTime:0.000424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12747591 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12747591 ORDER BY `unit` DESC [ RunTime:0.003218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12747591 LIMIT 2 [ RunTime:0.005365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12747591 ORDER BY `minOrder` ASC [ RunTime:0.004124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12745630 LIMIT 5 [ RunTime:0.002521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12745630 ORDER BY `minOrder` ASC [ RunTime:0.004935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12745630 ORDER BY `unit` DESC [ RunTime:0.000644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12745630 LIMIT 2 [ RunTime:0.000738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12745630 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12744056 LIMIT 5 [ RunTime:0.000900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12744056 ORDER BY `minOrder` ASC [ RunTime:0.003005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12744056 ORDER BY `unit` DESC [ RunTime:0.003487s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12744056 LIMIT 2 [ RunTime:0.002817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12744056 ORDER BY `minOrder` ASC [ RunTime:0.008269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12741722 LIMIT 5 [ RunTime:0.011799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12741722 ORDER BY `minOrder` ASC [ RunTime:0.011143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12741722 ORDER BY `unit` DESC [ RunTime:0.007041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12741722 LIMIT 2 [ RunTime:0.006277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12741722 ORDER BY `minOrder` ASC [ RunTime:0.006445s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12740543 LIMIT 5 [ RunTime:0.002337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740543 ORDER BY `minOrder` ASC [ RunTime:0.000974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12740543 ORDER BY `unit` DESC [ RunTime:0.001239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12740543 LIMIT 2 [ RunTime:0.000420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740543 ORDER BY `minOrder` ASC [ RunTime:0.001019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12739183 LIMIT 5 [ RunTime:0.000421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12739183 ORDER BY `minOrder` ASC [ RunTime:0.003266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12739183 ORDER BY `unit` DESC [ RunTime:0.000431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12739183 LIMIT 2 [ RunTime:0.001484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12739183 ORDER BY `minOrder` ASC [ RunTime:0.003540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11579000 LIMIT 5 [ RunTime:0.012464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11579000 ORDER BY `minOrder` ASC [ RunTime:0.021134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11579000 ORDER BY `unit` DESC [ RunTime:0.001153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11579000 LIMIT 2 [ RunTime:0.001196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11579000 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
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-L-DV-EJ%' OR `brand` LIKE 'FTSH-120-01-L-DV-EJ%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002359s ]
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-L-DV-EJ%' OR `brand` LIKE 'FTSH-120-01-L-DV-EJ%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59447496 LIMIT 5 [ RunTime:0.000563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59447496 ORDER BY `minOrder` ASC [ RunTime:0.001217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59447496 ORDER BY `unit` DESC [ RunTime:0.000485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59447496 LIMIT 2 [ RunTime:0.001322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59447496 ORDER BY `minOrder` ASC [ RunTime:0.000353s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ-K-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000669s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001263s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-L-DV-EJ-K-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000536s ]
SELECT `id` FROM `stock` WHERE `id` <> 59447496 AND `partno` = 'FTSH-120-01-L-DV-EJ-K-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19852106 [ RunTime:0.001157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59447189 LIMIT 5 [ RunTime:0.000436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59447189 ORDER BY `minOrder` ASC [ RunTime:0.007541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59447189 ORDER BY `unit` DESC [ RunTime:0.000756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59447189 LIMIT 2 [ RunTime:0.001866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59447189 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-L-DV-EJ-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000751s ]
SELECT `id` FROM `stock` WHERE `id` <> 59447189 AND `partno` = 'FTSH-120-01-L-DV-EJ-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19842571 [ RunTime:0.000496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59723221 LIMIT 5 [ RunTime:0.003195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59723221 ORDER BY `minOrder` ASC [ RunTime:0.014492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59723221 ORDER BY `unit` DESC [ RunTime:0.004449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59723221 LIMIT 2 [ RunTime:0.002071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59723221 ORDER BY `minOrder` ASC [ RunTime:0.000938s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJC-K-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-L-DV-EJC-K-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002484s ]
SELECT `id` FROM `stock` WHERE `id` <> 59723221 AND `partno` = 'FTSH-120-01-L-DV-EJC-K-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59710655 LIMIT 5 [ RunTime:0.001571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59710655 ORDER BY `minOrder` ASC [ RunTime:0.001184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59710655 ORDER BY `unit` DESC [ RunTime:0.001208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59710655 LIMIT 2 [ RunTime:0.007279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59710655 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ-K-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-L-DV-EJ-K-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002412s ]
SELECT `id` FROM `stock` WHERE `id` <> 59710655 AND `partno` = 'FTSH-120-01-L-DV-EJ-K-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12751064 [ RunTime:0.000657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59709117 LIMIT 5 [ RunTime:0.000509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59709117 ORDER BY `minOrder` ASC [ RunTime:0.003961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59709117 ORDER BY `unit` DESC [ RunTime:0.014340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59709117 LIMIT 2 [ RunTime:0.004306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59709117 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ-K-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-L-DV-EJ-K-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002377s ]
SELECT `id` FROM `stock` WHERE `id` <> 59709117 AND `partno` = 'FTSH-120-01-L-DV-EJ-K-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11579000 [ RunTime:0.000611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59708785 LIMIT 5 [ RunTime:0.001839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59708785 ORDER BY `minOrder` ASC [ RunTime:0.001062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59708785 ORDER BY `unit` DESC [ RunTime:0.000512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59708785 LIMIT 2 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59708785 ORDER BY `minOrder` ASC [ RunTime:0.000770s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ-K-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-L-DV-EJ-K-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003091s ]
SELECT `id` FROM `stock` WHERE `id` <> 59708785 AND `partno` = 'FTSH-120-01-L-DV-EJ-K-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12749890 [ RunTime:0.003090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59707878 LIMIT 5 [ RunTime:0.000793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59707878 ORDER BY `minOrder` ASC [ RunTime:0.003780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59707878 ORDER BY `unit` DESC [ RunTime:0.012167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59707878 LIMIT 2 [ RunTime:0.000545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59707878 ORDER BY `minOrder` ASC [ RunTime:0.006251s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJC-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014380s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-L-DV-EJC-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004956s ]
SELECT `id` FROM `stock` WHERE `id` <> 59707878 AND `partno` = 'FTSH-120-01-L-DV-EJC-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.027781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12749196 [ RunTime:0.004489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59705281 LIMIT 5 [ RunTime:0.013503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59705281 ORDER BY `minOrder` ASC [ RunTime:0.006413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59705281 ORDER BY `unit` DESC [ RunTime:0.009486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59705281 LIMIT 2 [ RunTime:0.013335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59705281 ORDER BY `minOrder` ASC [ RunTime:0.006887s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ-K-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-L-DV-EJ-K-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006383s ]
SELECT `id` FROM `stock` WHERE `id` <> 59705281 AND `partno` = 'FTSH-120-01-L-DV-EJ-K-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12744056 [ RunTime:0.003100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59705250 LIMIT 5 [ RunTime:0.006617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59705250 ORDER BY `minOrder` ASC [ RunTime:0.007217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59705250 ORDER BY `unit` DESC [ RunTime:0.000644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59705250 LIMIT 2 [ RunTime:0.000880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59705250 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-L-DV-EJ-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000603s ]
SELECT `id` FROM `stock` WHERE `id` <> 59705250 AND `partno` = 'FTSH-120-01-L-DV-EJ-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12747591 [ RunTime:0.002616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59703069 LIMIT 5 [ RunTime:0.001126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59703069 ORDER BY `minOrder` ASC [ RunTime:0.009770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59703069 ORDER BY `unit` DESC [ RunTime:0.016763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59703069 LIMIT 2 [ RunTime:0.016617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59703069 ORDER BY `minOrder` ASC [ RunTime:0.008221s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ-K-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-L-DV-EJ-K-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.018498s ]
SELECT `id` FROM `stock` WHERE `id` <> 59703069 AND `partno` = 'FTSH-120-01-L-DV-EJ-K-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.030595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59701743 LIMIT 5 [ RunTime:0.003437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59701743 ORDER BY `minOrder` ASC [ RunTime:0.003754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59701743 ORDER BY `unit` DESC [ RunTime:0.012315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59701743 LIMIT 2 [ RunTime:0.027020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59701743 ORDER BY `minOrder` ASC [ RunTime:0.007927s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJM' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015838s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-L-DV-EJM' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003885s ]
SELECT `id` FROM `stock` WHERE `id` <> 59701743 AND `partno` = 'FTSH-120-01-L-DV-EJM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12745630 [ RunTime:0.026658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59701717 LIMIT 5 [ RunTime:0.015104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59701717 ORDER BY `minOrder` ASC [ RunTime:0.003494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59701717 ORDER BY `unit` DESC [ RunTime:0.010395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59701717 LIMIT 2 [ RunTime:0.005884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59701717 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004191s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-L-DV-EJC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001451s ]
SELECT `id` FROM `stock` WHERE `id` <> 59701717 AND `partno` = 'FTSH-120-01-L-DV-EJC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59701057 LIMIT 5 [ RunTime:0.000618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59701057 ORDER BY `minOrder` ASC [ RunTime:0.001138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59701057 ORDER BY `unit` DESC [ RunTime:0.000616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59701057 LIMIT 2 [ RunTime:0.010705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59701057 ORDER BY `minOrder` ASC [ RunTime:0.003787s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-L-DV-EJ-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000850s ]
SELECT `id` FROM `stock` WHERE `id` <> 59701057 AND `partno` = 'FTSH-120-01-L-DV-EJ-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12741722 [ RunTime:0.011221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59698785 LIMIT 5 [ RunTime:0.000503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59698785 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59698785 ORDER BY `unit` DESC [ RunTime:0.000466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59698785 LIMIT 2 [ RunTime:0.007292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59698785 ORDER BY `minOrder` ASC [ RunTime:0.004209s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-L-DV-EJ-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000504s ]
SELECT `id` FROM `stock` WHERE `id` <> 59698785 AND `partno` = 'FTSH-120-01-L-DV-EJ-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12740543 [ RunTime:0.000470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59696602 LIMIT 5 [ RunTime:0.000493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59696602 ORDER BY `minOrder` ASC [ RunTime:0.000493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59696602 ORDER BY `unit` DESC [ RunTime:0.000472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59696602 LIMIT 2 [ RunTime:0.000489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59696602 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-L-DV-EJ-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000504s ]
SELECT `id` FROM `stock` WHERE `id` <> 59696602 AND `partno` = 'FTSH-120-01-L-DV-EJ-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12739183 [ RunTime:0.000482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59568354 LIMIT 5 [ RunTime:0.007511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59568354 ORDER BY `minOrder` ASC [ RunTime:0.001335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59568354 ORDER BY `unit` DESC [ RunTime:0.007074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59568354 LIMIT 2 [ RunTime:0.005775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59568354 ORDER BY `minOrder` ASC [ RunTime:0.000692s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-L-DV-EJ-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001239s ]
SELECT `id` FROM `stock` WHERE `id` <> 59568354 AND `partno` = 'FTSH-120-01-L-DV-EJ-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16188054 [ RunTime:0.000619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59541443 LIMIT 5 [ RunTime:0.003085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59541443 ORDER BY `minOrder` ASC [ RunTime:0.004516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59541443 ORDER BY `unit` DESC [ RunTime:0.000397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59541443 LIMIT 2 [ RunTime:0.004364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59541443 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-L-DV-EJ' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000388s ]
SELECT `id` FROM `stock` WHERE `id` <> 59541443 AND `partno` = 'FTSH-120-01-L-DV-EJ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15477147 [ RunTime:0.000357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59511059 LIMIT 5 [ RunTime:0.000341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59511059 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59511059 ORDER BY `unit` DESC [ RunTime:0.000341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59511059 LIMIT 2 [ RunTime:0.000330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59511059 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-L-DV-EJ-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000351s ]
SELECT `id` FROM `stock` WHERE `id` <> 59511059 AND `partno` = 'FTSH-120-01-L-DV-EJ-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19834034 [ RunTime:0.002555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59511027 LIMIT 5 [ RunTime:0.003421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59511027 ORDER BY `minOrder` ASC [ RunTime:0.000946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59511027 ORDER BY `unit` DESC [ RunTime:0.002624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59511027 LIMIT 2 [ RunTime:0.003843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59511027 ORDER BY `minOrder` ASC [ RunTime:0.001948s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-L-DV-EJ-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008878s ]
SELECT `id` FROM `stock` WHERE `id` <> 59511027 AND `partno` = 'FTSH-120-01-L-DV-EJ-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19834014 [ RunTime:0.000966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59450889 LIMIT 5 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59450889 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59450889 ORDER BY `unit` DESC [ RunTime:0.000316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59450889 LIMIT 2 [ RunTime:0.004611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59450889 ORDER BY `minOrder` ASC [ RunTime:0.009311s ]
select * from pdf where partno='FTSH-120-01-L-DV-EJ-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000431s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-120-01-L-DV-EJ-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000289s ]
SELECT `id` FROM `stock` WHERE `id` <> 59450889 AND `partno` = 'FTSH-120-01-L-DV-EJ-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16197122 [ RunTime:0.000315s ]
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-L-DV-EJ%' OR `brand` LIKE 'FTSH-120-01-L-DV-EJ%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004748s ]
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-L-DV-EJ%' OR `brand` LIKE 'FTSH-120-01-L-DV-EJ%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011971s ]
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-L-DV-EJ%' OR `brand` LIKE 'FTSH-120-01-L-DV-EJ%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020543s ]
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-L-DV-EJ%' OR `brand` LIKE 'FTSH-120-01-L-DV-EJ%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015647s ]
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-L-DV-EJ%' OR `brand` LIKE 'FTSH-120-01-L-DV-EJ%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026423s ]
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-L-DV-EJ%' OR `brand` LIKE 'FTSH-120-01-L-DV-EJ%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012465s ]
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-L-DV-EJ%' OR `brand` LIKE 'FTSH-120-01-L-DV-EJ%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014035s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'FTSH-120-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-120-01-L-DV-EJ%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003447s ]