SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001917s ]
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 'EHF-108-01-L-D%' OR `brand` LIKE 'EHF-108-01-L-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029189s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19767619 LIMIT 5 [ RunTime:0.051647s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19767619 ORDER BY `minOrder` ASC [ RunTime:0.022795s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19767619 ORDER BY `unit` DESC [ RunTime:0.037558s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19767619 LIMIT 2 [ RunTime:0.043038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19767619 ORDER BY `minOrder` ASC [ RunTime:0.007905s ]
select * from pdf where partno='EHF-108-01-L-D-SM-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.029815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15478162 LIMIT 5 [ RunTime:0.027968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15478162 ORDER BY `minOrder` ASC [ RunTime:0.045472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15478162 ORDER BY `unit` DESC [ RunTime:0.082180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15478162 LIMIT 2 [ RunTime:0.017661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15478162 ORDER BY `minOrder` ASC [ RunTime:0.041563s ]
select * from pdf where partno='EHF-108-01-L-D-SM-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.043928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19773401 LIMIT 5 [ RunTime:0.019800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19773401 ORDER BY `minOrder` ASC [ RunTime:0.057333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19773401 ORDER BY `unit` DESC [ RunTime:0.050755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19773401 LIMIT 2 [ RunTime:0.019386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19773401 ORDER BY `minOrder` ASC [ RunTime:0.013169s ]
select * from pdf where partno='EHF-108-01-L-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16230805 LIMIT 5 [ RunTime:0.039253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16230805 ORDER BY `minOrder` ASC [ RunTime:0.015158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16230805 ORDER BY `unit` DESC [ RunTime:0.021605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16230805 LIMIT 2 [ RunTime:0.033410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16230805 ORDER BY `minOrder` ASC [ RunTime:0.011775s ]
select * from pdf where partno='EHF-108-01-L-D-RA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19768235 LIMIT 5 [ RunTime:0.018603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19768235 ORDER BY `minOrder` ASC [ RunTime:0.012397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19768235 ORDER BY `unit` DESC [ RunTime:0.011987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19768235 LIMIT 2 [ RunTime:0.002596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19768235 ORDER BY `minOrder` ASC [ RunTime:0.002448s ]
select * from pdf where partno='EHF-108-01-L-D-SM-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16192857 LIMIT 5 [ RunTime:0.003747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16192857 ORDER BY `minOrder` ASC [ RunTime:0.001087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16192857 ORDER BY `unit` DESC [ RunTime:0.006229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16192857 LIMIT 2 [ RunTime:0.008889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16192857 ORDER BY `minOrder` ASC [ RunTime:0.016972s ]
select * from pdf where partno='EHF-108-01-L-D-SM-LC-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15494505 LIMIT 5 [ RunTime:0.013909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15494505 ORDER BY `minOrder` ASC [ RunTime:0.025042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15494505 ORDER BY `unit` DESC [ RunTime:0.015416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15494505 LIMIT 2 [ RunTime:0.018488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15494505 ORDER BY `minOrder` ASC [ RunTime:0.022563s ]
select * from pdf where partno='EHF-108-01-L-D-SM-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19833978 LIMIT 5 [ RunTime:0.007934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833978 ORDER BY `minOrder` ASC [ RunTime:0.014280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19833978 ORDER BY `unit` DESC [ RunTime:0.020512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19833978 LIMIT 2 [ RunTime:0.007018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833978 ORDER BY `minOrder` ASC [ RunTime:0.012326s ]
select * from pdf where partno='EHF-108-01-L-D-SM-LC-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19833916 LIMIT 5 [ RunTime:0.011918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833916 ORDER BY `minOrder` ASC [ RunTime:0.052513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19833916 ORDER BY `unit` DESC [ RunTime:0.014741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19833916 LIMIT 2 [ RunTime:0.004291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833916 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19806938 LIMIT 5 [ RunTime:0.002193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19806938 ORDER BY `minOrder` ASC [ RunTime:0.000672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19806938 ORDER BY `unit` DESC [ RunTime:0.006449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19806938 LIMIT 2 [ RunTime:0.003975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19806938 ORDER BY `minOrder` ASC [ RunTime:0.002881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19766303 LIMIT 5 [ RunTime:0.002424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19766303 ORDER BY `minOrder` ASC [ RunTime:0.003067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19766303 ORDER BY `unit` DESC [ RunTime:0.013001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19766303 LIMIT 2 [ RunTime:0.000650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19766303 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
select * from pdf where partno='EHF-108-01-L-D-SM' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16227540 LIMIT 5 [ RunTime:0.010343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16227540 ORDER BY `minOrder` ASC [ RunTime:0.001522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16227540 ORDER BY `unit` DESC [ RunTime:0.010670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16227540 LIMIT 2 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16227540 ORDER BY `minOrder` ASC [ RunTime:0.000964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12772915 LIMIT 5 [ RunTime:0.001328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12772915 ORDER BY `minOrder` ASC [ RunTime:0.000572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12772915 ORDER BY `unit` DESC [ RunTime:0.006371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12772915 LIMIT 2 [ RunTime:0.000682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12772915 ORDER BY `minOrder` ASC [ RunTime:0.002780s ]
select * from pdf where partno='EHF-108-01-L-D-SM-LC-08-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12759360 LIMIT 5 [ RunTime:0.004128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759360 ORDER BY `minOrder` ASC [ RunTime:0.000802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12759360 ORDER BY `unit` DESC [ RunTime:0.009356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12759360 LIMIT 2 [ RunTime:0.001765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759360 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12759358 LIMIT 5 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759358 ORDER BY `minOrder` ASC [ RunTime:0.002200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12759358 ORDER BY `unit` DESC [ RunTime:0.007964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12759358 LIMIT 2 [ RunTime:0.001069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12759358 ORDER BY `minOrder` ASC [ RunTime:0.001489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12757142 LIMIT 5 [ RunTime:0.001228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12757142 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12757142 ORDER BY `unit` DESC [ RunTime:0.012310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12757142 LIMIT 2 [ RunTime:0.002250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12757142 ORDER BY `minOrder` ASC [ RunTime:0.002193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12741478 LIMIT 5 [ RunTime:0.020004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12741478 ORDER BY `minOrder` ASC [ RunTime:0.016363s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12741478 ORDER BY `unit` DESC [ RunTime:0.013490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12741478 LIMIT 2 [ RunTime:0.013661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12741478 ORDER BY `minOrder` ASC [ RunTime:0.003730s ]
select * from pdf where partno='EHF-108-01-L-D-SM-LC-01-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12740176 LIMIT 5 [ RunTime:0.007388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740176 ORDER BY `minOrder` ASC [ RunTime:0.005480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12740176 ORDER BY `unit` DESC [ RunTime:0.023906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12740176 LIMIT 2 [ RunTime:0.002845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740176 ORDER BY `minOrder` ASC [ RunTime:0.003855s ]
select * from pdf where partno='EHF-108-01-L-D-SM-LC-01' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12739830 LIMIT 5 [ RunTime:0.010225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12739830 ORDER BY `minOrder` ASC [ RunTime:0.001665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12739830 ORDER BY `unit` DESC [ RunTime:0.014298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12739830 LIMIT 2 [ RunTime:0.010468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12739830 ORDER BY `minOrder` ASC [ RunTime:0.007141s ]
select * from pdf where partno='EHF-108-01-L-D-SM-16-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11596057 LIMIT 5 [ RunTime:0.004901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11596057 ORDER BY `minOrder` ASC [ RunTime:0.003333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11596057 ORDER BY `unit` DESC [ RunTime:0.001451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11596057 LIMIT 2 [ RunTime:0.004954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11596057 ORDER BY `minOrder` ASC [ RunTime:0.005264s ]
select * from pdf where partno='EHF-108-01-L-D-SM-16-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014049s ]
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 'EHF-108-01-L-D%' OR `brand` LIKE 'EHF-108-01-L-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004673s ]
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 'EHF-108-01-L-D%' OR `brand` LIKE 'EHF-108-01-L-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59435085 LIMIT 5 [ RunTime:0.007960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59435085 ORDER BY `minOrder` ASC [ RunTime:0.009283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59435085 ORDER BY `unit` DESC [ RunTime:0.002645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59435085 LIMIT 2 [ RunTime:0.006390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59435085 ORDER BY `minOrder` ASC [ RunTime:0.004449s ]
select * from pdf where partno='EHF-108-01-L-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004001s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-108-01-L-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003339s ]
SELECT `id` FROM `stock` WHERE `id` <> 59435085 AND `partno` = 'EHF-108-01-L-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19773401 [ RunTime:0.004810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59441000 LIMIT 5 [ RunTime:0.000504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59441000 ORDER BY `minOrder` ASC [ RunTime:0.010140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59441000 ORDER BY `unit` DESC [ RunTime:0.005761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59441000 LIMIT 2 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59441000 ORDER BY `minOrder` ASC [ RunTime:0.005222s ]
select * from pdf where partno='EHF-108-01-L-D-RA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001378s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-108-01-L-D-RA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000943s ]
SELECT `id` FROM `stock` WHERE `id` <> 59441000 AND `partno` = 'EHF-108-01-L-D-RA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16230805 [ RunTime:0.000524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59435219 LIMIT 5 [ RunTime:0.002147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59435219 ORDER BY `minOrder` ASC [ RunTime:0.001724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59435219 ORDER BY `unit` DESC [ RunTime:0.000425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59435219 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59435219 ORDER BY `minOrder` ASC [ RunTime:0.000805s ]
select * from pdf where partno='EHF-108-01-L-D-SM-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-108-01-L-D-SM-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000521s ]
SELECT `id` FROM `stock` WHERE `id` <> 59435219 AND `partno` = 'EHF-108-01-L-D-SM-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15478162 [ RunTime:0.000699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59447113 LIMIT 5 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59447113 ORDER BY `minOrder` ASC [ RunTime:0.001298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59447113 ORDER BY `unit` DESC [ RunTime:0.005234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59447113 LIMIT 2 [ RunTime:0.004073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59447113 ORDER BY `minOrder` ASC [ RunTime:0.002446s ]
select * from pdf where partno='EHF-108-01-L-D-SM-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-108-01-L-D-SM-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000753s ]
SELECT `id` FROM `stock` WHERE `id` <> 59447113 AND `partno` = 'EHF-108-01-L-D-SM-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19767619 [ RunTime:0.001736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59447153 LIMIT 5 [ RunTime:0.001097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59447153 ORDER BY `minOrder` ASC [ RunTime:0.001775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59447153 ORDER BY `unit` DESC [ RunTime:0.000521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59447153 LIMIT 2 [ RunTime:0.003432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59447153 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
select * from pdf where partno='EHF-108-01-L-D-SM-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-108-01-L-D-SM-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005119s ]
SELECT `id` FROM `stock` WHERE `id` <> 59447153 AND `partno` = 'EHF-108-01-L-D-SM-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19768235 [ RunTime:0.001058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59541379 LIMIT 5 [ RunTime:0.002021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59541379 ORDER BY `minOrder` ASC [ RunTime:0.010691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59541379 ORDER BY `unit` DESC [ RunTime:0.003714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59541379 LIMIT 2 [ RunTime:0.002526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59541379 ORDER BY `minOrder` ASC [ RunTime:0.003651s ]
select * from pdf where partno='EHF-108-01-L-D-SM-LC-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-108-01-L-D-SM-LC-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000708s ]
SELECT `id` FROM `stock` WHERE `id` <> 59541379 AND `partno` = 'EHF-108-01-L-D-SM-LC-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16192857 [ RunTime:0.000781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59446710 LIMIT 5 [ RunTime:0.005106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446710 ORDER BY `minOrder` ASC [ RunTime:0.007183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59446710 ORDER BY `unit` DESC [ RunTime:0.012766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59446710 LIMIT 2 [ RunTime:0.002395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446710 ORDER BY `minOrder` ASC [ RunTime:0.000812s ]
select * from pdf where partno='EHF-108-01-L-D-SM-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002175s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-108-01-L-D-SM-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006615s ]
SELECT `id` FROM `stock` WHERE `id` <> 59446710 AND `partno` = 'EHF-108-01-L-D-SM-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15494505 [ RunTime:0.006419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59446585 LIMIT 5 [ RunTime:0.001767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446585 ORDER BY `minOrder` ASC [ RunTime:0.002583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59446585 ORDER BY `unit` DESC [ RunTime:0.000672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59446585 LIMIT 2 [ RunTime:0.000558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446585 ORDER BY `minOrder` ASC [ RunTime:0.002199s ]
select * from pdf where partno='EHF-108-01-L-D-SM' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-108-01-L-D-SM' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000742s ]
SELECT `id` FROM `stock` WHERE `id` <> 59446585 AND `partno` = 'EHF-108-01-L-D-SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19766303 [ RunTime:0.000621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59696899 LIMIT 5 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59696899 ORDER BY `minOrder` ASC [ RunTime:0.000961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59696899 ORDER BY `unit` DESC [ RunTime:0.002285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59696899 LIMIT 2 [ RunTime:0.002055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59696899 ORDER BY `minOrder` ASC [ RunTime:0.000368s ]
select * from pdf where partno='EHF-108-01-L-D-SM-LC-04-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-108-01-L-D-SM-LC-04-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000699s ]
SELECT `id` FROM `stock` WHERE `id` <> 59696899 AND `partno` = 'EHF-108-01-L-D-SM-LC-04-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11572423 [ RunTime:0.001051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59696898 LIMIT 5 [ RunTime:0.002201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59696898 ORDER BY `minOrder` ASC [ RunTime:0.000646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59696898 ORDER BY `unit` DESC [ RunTime:0.000607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59696898 LIMIT 2 [ RunTime:0.008239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59696898 ORDER BY `minOrder` ASC [ RunTime:0.000404s ]
select * from pdf where partno='EHF-108-01-L-D-SM-LC-01-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-108-01-L-D-SM-LC-01-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000696s ]
SELECT `id` FROM `stock` WHERE `id` <> 59696898 AND `partno` = 'EHF-108-01-L-D-SM-LC-01-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12741478 [ RunTime:0.000626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59694066 LIMIT 5 [ RunTime:0.000554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59694066 ORDER BY `minOrder` ASC [ RunTime:0.000948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59694066 ORDER BY `unit` DESC [ RunTime:0.003310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59694066 LIMIT 2 [ RunTime:0.005907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59694066 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
select * from pdf where partno='EHF-108-01-L-D-SM-LC-01' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002636s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-108-01-L-D-SM-LC-01' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000698s ]
SELECT `id` FROM `stock` WHERE `id` <> 59694066 AND `partno` = 'EHF-108-01-L-D-SM-LC-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12740176 [ RunTime:0.000619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59693474 LIMIT 5 [ RunTime:0.000668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59693474 ORDER BY `minOrder` ASC [ RunTime:0.000960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59693474 ORDER BY `unit` DESC [ RunTime:0.004228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59693474 LIMIT 2 [ RunTime:0.000982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59693474 ORDER BY `minOrder` ASC [ RunTime:0.004452s ]
select * from pdf where partno='EHF-108-01-L-D-SM-16-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-108-01-L-D-SM-16-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002122s ]
SELECT `id` FROM `stock` WHERE `id` <> 59693474 AND `partno` = 'EHF-108-01-L-D-SM-16-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12739830 [ RunTime:0.000750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59690489 LIMIT 5 [ RunTime:0.000556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59690489 ORDER BY `minOrder` ASC [ RunTime:0.003598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59690489 ORDER BY `unit` DESC [ RunTime:0.000692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59690489 LIMIT 2 [ RunTime:0.007976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59690489 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
select * from pdf where partno='EHF-108-01-L-D-SM-01' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001739s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-108-01-L-D-SM-01' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002587s ]
SELECT `id` FROM `stock` WHERE `id` <> 59690489 AND `partno` = 'EHF-108-01-L-D-SM-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11570009 [ RunTime:0.006330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59680535 LIMIT 5 [ RunTime:0.000689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59680535 ORDER BY `minOrder` ASC [ RunTime:0.005258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59680535 ORDER BY `unit` DESC [ RunTime:0.004408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59680535 LIMIT 2 [ RunTime:0.001195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59680535 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
select * from pdf where partno='EHF-108-01-L-D-01' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003937s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-108-01-L-D-01' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002739s ]
SELECT `id` FROM `stock` WHERE `id` <> 59680535 AND `partno` = 'EHF-108-01-L-D-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19806938 [ RunTime:0.000708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59510982 LIMIT 5 [ RunTime:0.002522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59510982 ORDER BY `minOrder` ASC [ RunTime:0.001069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59510982 ORDER BY `unit` DESC [ RunTime:0.001209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59510982 LIMIT 2 [ RunTime:0.001386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59510982 ORDER BY `minOrder` ASC [ RunTime:0.003028s ]
select * from pdf where partno='EHF-108-01-L-D-SM-LC-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007919s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-108-01-L-D-SM-LC-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001008s ]
SELECT `id` FROM `stock` WHERE `id` <> 59510982 AND `partno` = 'EHF-108-01-L-D-SM-LC-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19833978 [ RunTime:0.000703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59510913 LIMIT 5 [ RunTime:0.000795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59510913 ORDER BY `minOrder` ASC [ RunTime:0.000954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59510913 ORDER BY `unit` DESC [ RunTime:0.000709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59510913 LIMIT 2 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59510913 ORDER BY `minOrder` ASC [ RunTime:0.002826s ]
select * from pdf where partno='EHF-108-01-L-D-SM-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-108-01-L-D-SM-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001243s ]
SELECT `id` FROM `stock` WHERE `id` <> 59510913 AND `partno` = 'EHF-108-01-L-D-SM-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16227540 [ RunTime:0.009085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59510892 LIMIT 5 [ RunTime:0.000721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59510892 ORDER BY `minOrder` ASC [ RunTime:0.007922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59510892 ORDER BY `unit` DESC [ RunTime:0.000748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59510892 LIMIT 2 [ RunTime:0.007037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59510892 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
select * from pdf where partno='EHF-108-01-L-D-SM-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001441s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-108-01-L-D-SM-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000840s ]
SELECT `id` FROM `stock` WHERE `id` <> 59510892 AND `partno` = 'EHF-108-01-L-D-SM-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.009437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19833916 [ RunTime:0.000736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52866906 LIMIT 5 [ RunTime:0.000794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52866906 ORDER BY `minOrder` ASC [ RunTime:0.001084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52866906 ORDER BY `unit` DESC [ RunTime:0.000619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52866906 LIMIT 2 [ RunTime:0.003708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52866906 ORDER BY `minOrder` ASC [ RunTime:0.009632s ]
select * from pdf where partno='EHF-108-01-L-D-SM-LC-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001933s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-108-01-L-D-SM-LC-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000985s ]
SELECT `id` FROM `stock` WHERE `id` <> 52866906 AND `partno` = 'EHF-108-01-L-D-SM-LC-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52866696 LIMIT 5 [ RunTime:0.000817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52866696 ORDER BY `minOrder` ASC [ RunTime:0.005349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52866696 ORDER BY `unit` DESC [ RunTime:0.004366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52866696 LIMIT 2 [ RunTime:0.015361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52866696 ORDER BY `minOrder` ASC [ RunTime:0.003120s ]
select * from pdf where partno='EHF-108-01-L-D-SM-08-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-108-01-L-D-SM-08-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001985s ]
SELECT `id` FROM `stock` WHERE `id` <> 52866696 AND `partno` = 'EHF-108-01-L-D-SM-08-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52866694 LIMIT 5 [ RunTime:0.021906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52866694 ORDER BY `minOrder` ASC [ RunTime:0.004142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52866694 ORDER BY `unit` DESC [ RunTime:0.005055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52866694 LIMIT 2 [ RunTime:0.002614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52866694 ORDER BY `minOrder` ASC [ RunTime:0.003064s ]
select * from pdf where partno='EHF-108-01-L-D-SM-01-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009471s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-108-01-L-D-SM-01-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007395s ]
SELECT `id` FROM `stock` WHERE `id` <> 52866694 AND `partno` = 'EHF-108-01-L-D-SM-01-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11586380 [ RunTime:0.008207s ]
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 'EHF-108-01-L-D%' OR `brand` LIKE 'EHF-108-01-L-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008496s ]
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 'EHF-108-01-L-D%' OR `brand` LIKE 'EHF-108-01-L-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008762s ]
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 'EHF-108-01-L-D%' OR `brand` LIKE 'EHF-108-01-L-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013366s ]
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 'EHF-108-01-L-D%' OR `brand` LIKE 'EHF-108-01-L-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013346s ]
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 'EHF-108-01-L-D%' OR `brand` LIKE 'EHF-108-01-L-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009550s ]
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 'EHF-108-01-L-D%' OR `brand` LIKE 'EHF-108-01-L-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010546s ]
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 'EHF-108-01-L-D%' OR `brand` LIKE 'EHF-108-01-L-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019308s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'EHF-108-01-L-D%' OR `brand` LIKE 'EHF-108-01-L-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007885s ]