SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001482s ]
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 '86%' OR `brand` LIKE '86%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.584052s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14903870 LIMIT 5 [ RunTime:0.000689s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14903870 ORDER BY `minOrder` ASC [ RunTime:0.000389s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14903870 ORDER BY `unit` DESC [ RunTime:0.000338s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14903870 LIMIT 2 [ RunTime:0.000321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14903870 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11482559 LIMIT 5 [ RunTime:0.000595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482559 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11482559 ORDER BY `unit` DESC [ RunTime:0.000291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11482559 LIMIT 2 [ RunTime:0.000282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482559 ORDER BY `minOrder` ASC [ RunTime:0.000295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14895514 LIMIT 5 [ RunTime:0.000561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14895514 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14895514 ORDER BY `unit` DESC [ RunTime:0.000291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14895514 LIMIT 2 [ RunTime:0.000279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14895514 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613649 LIMIT 5 [ RunTime:0.000543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613649 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12613649 ORDER BY `unit` DESC [ RunTime:0.000279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12613649 LIMIT 2 [ RunTime:0.000271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613649 ORDER BY `minOrder` ASC [ RunTime:0.000292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13972929 LIMIT 5 [ RunTime:0.000744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13972929 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13972929 ORDER BY `unit` DESC [ RunTime:0.000292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13972929 LIMIT 2 [ RunTime:0.000285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13972929 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13985409 LIMIT 5 [ RunTime:0.001084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13985409 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13985409 ORDER BY `unit` DESC [ RunTime:0.000285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13985409 LIMIT 2 [ RunTime:0.000276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13985409 ORDER BY `minOrder` ASC [ RunTime:0.000292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13984137 LIMIT 5 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13984137 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13984137 ORDER BY `unit` DESC [ RunTime:0.000280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13984137 LIMIT 2 [ RunTime:0.000278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13984137 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14889782 LIMIT 5 [ RunTime:0.000506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14889782 ORDER BY `minOrder` ASC [ RunTime:0.000250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14889782 ORDER BY `unit` DESC [ RunTime:0.000267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14889782 LIMIT 2 [ RunTime:0.000272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14889782 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667165 LIMIT 5 [ RunTime:0.000559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667165 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19667165 ORDER BY `unit` DESC [ RunTime:0.000283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19667165 LIMIT 2 [ RunTime:0.000262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667165 ORDER BY `minOrder` ASC [ RunTime:0.000246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14907775 LIMIT 5 [ RunTime:0.000611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14907775 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14907775 ORDER BY `unit` DESC [ RunTime:0.000351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14907775 LIMIT 2 [ RunTime:0.000293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14907775 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19018116 LIMIT 5 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19018116 ORDER BY `minOrder` ASC [ RunTime:0.000300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19018116 ORDER BY `unit` DESC [ RunTime:0.000328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19018116 LIMIT 2 [ RunTime:0.000291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19018116 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609611 LIMIT 5 [ RunTime:0.000596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609611 ORDER BY `minOrder` ASC [ RunTime:0.000367s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609611 ORDER BY `unit` DESC [ RunTime:0.000338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609611 LIMIT 2 [ RunTime:0.000302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609611 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13983024 LIMIT 5 [ RunTime:0.000648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13983024 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13983024 ORDER BY `unit` DESC [ RunTime:0.000361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13983024 LIMIT 2 [ RunTime:0.000326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13983024 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16208414 LIMIT 5 [ RunTime:0.000768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16208414 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16208414 ORDER BY `unit` DESC [ RunTime:0.000308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16208414 LIMIT 2 [ RunTime:0.000353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16208414 ORDER BY `minOrder` ASC [ RunTime:0.000389s ]
select * from pdf where partno='861400021YO10LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13975839 LIMIT 5 [ RunTime:0.000776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13975839 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13975839 ORDER BY `unit` DESC [ RunTime:0.000367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13975839 LIMIT 2 [ RunTime:0.000332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13975839 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11916677 LIMIT 5 [ RunTime:0.000747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11916677 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11916677 ORDER BY `unit` DESC [ RunTime:0.000380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11916677 LIMIT 2 [ RunTime:0.000342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11916677 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13972930 LIMIT 5 [ RunTime:0.000383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13972930 ORDER BY `minOrder` ASC [ RunTime:0.000270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13972930 ORDER BY `unit` DESC [ RunTime:0.000295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13972930 LIMIT 2 [ RunTime:0.000327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13972930 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13983025 LIMIT 5 [ RunTime:0.000356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13983025 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13983025 ORDER BY `unit` DESC [ RunTime:0.000318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13983025 LIMIT 2 [ RunTime:0.000330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13983025 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16208415 LIMIT 5 [ RunTime:0.000396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16208415 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16208415 ORDER BY `unit` DESC [ RunTime:0.000321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16208415 LIMIT 2 [ RunTime:0.000316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16208415 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11916673 LIMIT 5 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11916673 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11916673 ORDER BY `unit` DESC [ RunTime:0.000362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11916673 LIMIT 2 [ RunTime:0.000470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11916673 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
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 '86%' OR `brand` LIKE '86%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51118722 LIMIT 5 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51118722 ORDER BY `minOrder` ASC [ RunTime:0.000658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51118722 ORDER BY `unit` DESC [ RunTime:0.000324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51118722 LIMIT 2 [ RunTime:0.000266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51118722 ORDER BY `minOrder` ASC [ RunTime:0.000554s ]
select * from pdf where partno='865080545012' and brandshort='wurth elektronik' limit 1 [ RunTime:0.001260s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001187s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '865080545012' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.000821s ]
SELECT `id` FROM `stock` WHERE `id` <> 51118722 AND `partno` = '865080545012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.002637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14889714 [ RunTime:0.000726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51118723 LIMIT 5 [ RunTime:0.000401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51118723 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51118723 ORDER BY `unit` DESC [ RunTime:0.000389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51118723 LIMIT 2 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51118723 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
select * from pdf where partno='865080663020' and brandshort='wurth elektronik' limit 1 [ RunTime:0.000793s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '865080663020' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.000558s ]
SELECT `id` FROM `stock` WHERE `id` <> 51118723 AND `partno` = '865080663020' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.000692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14900540 [ RunTime:0.000849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32252418 LIMIT 5 [ RunTime:0.000367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252418 ORDER BY `minOrder` ASC [ RunTime:0.000856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32252418 ORDER BY `unit` DESC [ RunTime:0.000490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32252418 LIMIT 2 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252418 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
select * from pdf where partno='86566620064lf' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.001339s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86566620064lf' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.000615s ]
SELECT `id` FROM `stock` WHERE `id` <> 32252418 AND `partno` = '86566620064lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.001076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32254079 LIMIT 5 [ RunTime:0.000434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254079 ORDER BY `minOrder` ASC [ RunTime:0.000848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32254079 ORDER BY `unit` DESC [ RunTime:0.000483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32254079 LIMIT 2 [ RunTime:0.000363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254079 ORDER BY `minOrder` ASC [ RunTime:0.000520s ]
select * from pdf where partno='86656-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.001017s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86656-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000509s ]
SELECT `id` FROM `stock` WHERE `id` <> 32254079 AND `partno` = '86656-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.001031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32159941 LIMIT 5 [ RunTime:0.000403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32159941 ORDER BY `minOrder` ASC [ RunTime:0.000811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32159941 ORDER BY `unit` DESC [ RunTime:0.000421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32159941 LIMIT 2 [ RunTime:0.000421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32159941 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
select * from pdf where partno='8671' and brandshort='keystone electronics' limit 1 [ RunTime:0.002611s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8671' OR `brand` LIKE 'keystone electronics%' ) ) LIMIT 1 [ RunTime:0.000648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32253591 LIMIT 5 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32253591 ORDER BY `minOrder` ASC [ RunTime:0.000734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32253591 ORDER BY `unit` DESC [ RunTime:0.000502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32253591 LIMIT 2 [ RunTime:0.000360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32253591 ORDER BY `minOrder` ASC [ RunTime:0.000589s ]
select * from pdf where partno='86557-6' and brandshort='te connectivity' limit 1 [ RunTime:0.000908s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86557-6' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.011811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32253178 LIMIT 5 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32253178 ORDER BY `minOrder` ASC [ RunTime:0.000776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32253178 ORDER BY `unit` DESC [ RunTime:0.000421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32253178 LIMIT 2 [ RunTime:0.000331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32253178 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
select * from pdf where partno='86564520067lf' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.000835s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86564520067lf' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.000451s ]
SELECT `id` FROM `stock` WHERE `id` <> 32253178 AND `partno` = '86564520067lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.000704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32252318 LIMIT 5 [ RunTime:0.000344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252318 ORDER BY `minOrder` ASC [ RunTime:0.000514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32252318 ORDER BY `unit` DESC [ RunTime:0.000349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32252318 LIMIT 2 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252318 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
select * from pdf where partno='86566620065lf' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.000639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86566620065lf' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.000436s ]
SELECT `id` FROM `stock` WHERE `id` <> 32252318 AND `partno` = '86566620065lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.000454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276662 LIMIT 5 [ RunTime:0.000335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276662 ORDER BY `minOrder` ASC [ RunTime:0.000756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276662 ORDER BY `unit` DESC [ RunTime:0.000364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276662 LIMIT 2 [ RunTime:0.000322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276662 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
select * from pdf where partno='86286-1' and brandshort='te connectivity' limit 1 [ RunTime:0.001141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86286-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.010112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32254245 LIMIT 5 [ RunTime:0.000568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254245 ORDER BY `minOrder` ASC [ RunTime:0.001477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32254245 ORDER BY `unit` DESC [ RunTime:0.000384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32254245 LIMIT 2 [ RunTime:0.000323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254245 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
select * from pdf where partno='86566-4' and brandshort='te connectivity' limit 1 [ RunTime:0.000878s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86566-4' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.010062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32254538 LIMIT 5 [ RunTime:0.000543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254538 ORDER BY `minOrder` ASC [ RunTime:0.002003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32254538 ORDER BY `unit` DESC [ RunTime:0.000375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32254538 LIMIT 2 [ RunTime:0.000318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254538 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
select * from pdf where partno='86566-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000684s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86566-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000436s ]
SELECT `id` FROM `stock` WHERE `id` <> 32254538 AND `partno` = '86566-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32253177 LIMIT 5 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32253177 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32253177 ORDER BY `unit` DESC [ RunTime:0.000347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32253177 LIMIT 2 [ RunTime:0.000316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32253177 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
select * from pdf where partno='86564510065lf' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.001721s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86564510065lf' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.000475s ]
SELECT `id` FROM `stock` WHERE `id` <> 32253177 AND `partno` = '86564510065lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.000451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32253277 LIMIT 5 [ RunTime:0.000397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32253277 ORDER BY `minOrder` ASC [ RunTime:0.001073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32253277 ORDER BY `unit` DESC [ RunTime:0.000405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32253277 LIMIT 2 [ RunTime:0.000343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32253277 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
select * from pdf where partno='86566720064lf' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.001453s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86566720064lf' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.000463s ]
SELECT `id` FROM `stock` WHERE `id` <> 32253277 AND `partno` = '86566720064lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.000478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280606 LIMIT 5 [ RunTime:0.000348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280606 ORDER BY `minOrder` ASC [ RunTime:0.000901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280606 ORDER BY `unit` DESC [ RunTime:0.000360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280606 LIMIT 2 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280606 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
select * from pdf where partno='8637-0-15-15-25-27-10-0' and brandshort='mill-max' limit 1 [ RunTime:0.001824s ]
select foldpath,foldpath2,filename from pdf_file where id=1653269 limit 1 [ RunTime:0.000424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8637-0-15-15-25-27-10-0' OR `brand` LIKE 'mill-max%' ) ) LIMIT 1 [ RunTime:0.001261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276931 LIMIT 5 [ RunTime:0.000365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276931 ORDER BY `minOrder` ASC [ RunTime:0.001757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276931 ORDER BY `unit` DESC [ RunTime:0.000363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276931 LIMIT 2 [ RunTime:0.000336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276931 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
select * from pdf where partno='86130202114345e1lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.003070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86130202114345e1lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.000462s ]
SELECT `id` FROM `stock` WHERE `id` <> 32276931 AND `partno` = '86130202114345e1lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.000895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51086591 LIMIT 5 [ RunTime:0.000400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086591 ORDER BY `minOrder` ASC [ RunTime:0.000778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51086591 ORDER BY `unit` DESC [ RunTime:0.000345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51086591 LIMIT 2 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086591 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
select * from pdf where partno='8630740000' and brandshort='weidmuller' limit 1 [ RunTime:0.000519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8630740000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.000796s ]
SELECT `id` FROM `stock` WHERE `id` <> 51086591 AND `partno` = '8630740000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.001060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66196743 [ RunTime:0.000348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32232428 LIMIT 5 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32232428 ORDER BY `minOrder` ASC [ RunTime:0.000701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32232428 ORDER BY `unit` DESC [ RunTime:0.000386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32232428 LIMIT 2 [ RunTime:0.000328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32232428 ORDER BY `minOrder` ASC [ RunTime:0.000353s ]
select * from pdf where partno='86-' and brandshort='vcc' limit 1 [ RunTime:0.001074s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86-' OR `brand` LIKE 'vcc%' ) ) LIMIT 1 [ RunTime:0.000808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32252479 LIMIT 5 [ RunTime:0.000338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252479 ORDER BY `minOrder` ASC [ RunTime:0.000607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32252479 ORDER BY `unit` DESC [ RunTime:0.000414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32252479 LIMIT 2 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252479 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
select * from pdf where partno='863005lf' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.000483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '863005lf' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.000416s ]
SELECT `id` FROM `stock` WHERE `id` <> 32252479 AND `partno` = '863005lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.000942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32253133 LIMIT 5 [ RunTime:0.000335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32253133 ORDER BY `minOrder` ASC [ RunTime:0.000691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32253133 ORDER BY `unit` DESC [ RunTime:0.000349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32253133 LIMIT 2 [ RunTime:0.000332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32253133 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
select * from pdf where partno='86563006065lf' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.000912s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86563006065lf' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.000537s ]
SELECT `id` FROM `stock` WHERE `id` <> 32253133 AND `partno` = '86563006065lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.000528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32252285 LIMIT 5 [ RunTime:0.000360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252285 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32252285 ORDER BY `unit` DESC [ RunTime:0.000365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32252285 LIMIT 2 [ RunTime:0.000346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252285 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
select * from pdf where partno='86552097lf' and brandshort='amphenol commercial products' limit 1 [ RunTime:0.000529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86552097lf' OR `brand` LIKE 'amphenol commercial products%' ) ) LIMIT 1 [ RunTime:0.000535s ]
SELECT `id` FROM `stock` WHERE `id` <> 32252285 AND `partno` = '86552097lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol commercial products%' ) [ RunTime:0.000925s ]
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 '86%' OR `brand` LIKE '86%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:2.513638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39227858 LIMIT 5 [ RunTime:0.000806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39227858 ORDER BY `minOrder` ASC [ RunTime:0.000853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39227858 ORDER BY `unit` DESC [ RunTime:0.000377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39227858 LIMIT 2 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39227858 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
select * from pdf where partno='865090368008' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000668s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '865090368008' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000576s ]
SELECT `id` FROM `stock` WHERE `id` <> 39227858 AND `partno` = '865090368008' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15584406 [ RunTime:0.000602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39227852 LIMIT 5 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39227852 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39227852 ORDER BY `unit` DESC [ RunTime:0.000358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39227852 LIMIT 2 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39227852 ORDER BY `minOrder` ASC [ RunTime:0.000497s ]
select * from pdf where partno='865080543009' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '865080543009' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000548s ]
SELECT `id` FROM `stock` WHERE `id` <> 39227852 AND `partno` = '865080543009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13972930 [ RunTime:0.000393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67154596 LIMIT 5 [ RunTime:0.000373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154596 ORDER BY `minOrder` ASC [ RunTime:0.002579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67154596 ORDER BY `unit` DESC [ RunTime:0.000371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67154596 LIMIT 2 [ RunTime:0.000393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67154596 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
select * from pdf where partno='86492-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86492-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000527s ]
SELECT `id` FROM `stock` WHERE `id` <> 67154596 AND `partno` = '86492-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609611 [ RunTime:0.000384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39227847 LIMIT 5 [ RunTime:0.000448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39227847 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39227847 ORDER BY `unit` DESC [ RunTime:0.000405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39227847 LIMIT 2 [ RunTime:0.000402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39227847 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='860020672005' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.002189s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '860020672005' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000522s ]
SELECT `id` FROM `stock` WHERE `id` <> 39227847 AND `partno` = '860020672005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14903870 [ RunTime:0.000485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59947276 LIMIT 5 [ RunTime:0.000427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59947276 ORDER BY `minOrder` ASC [ RunTime:0.001106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59947276 ORDER BY `unit` DESC [ RunTime:0.000420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59947276 LIMIT 2 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59947276 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
select * from pdf where partno='86147-8' and brandshort='TE Connectivity' limit 1 [ RunTime:0.000936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86147-8' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.010848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39228614 LIMIT 5 [ RunTime:0.000500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39228614 ORDER BY `minOrder` ASC [ RunTime:0.000814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39228614 ORDER BY `unit` DESC [ RunTime:0.000444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39228614 LIMIT 2 [ RunTime:0.000359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39228614 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
select * from pdf where partno='865080340001' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000865s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '865080340001' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000481s ]
SELECT `id` FROM `stock` WHERE `id` <> 39228614 AND `partno` = '865080340001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14889707 [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66243627 LIMIT 5 [ RunTime:0.000703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66243627 ORDER BY `minOrder` ASC [ RunTime:0.001194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66243627 ORDER BY `unit` DESC [ RunTime:0.000656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66243627 LIMIT 2 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66243627 ORDER BY `minOrder` ASC [ RunTime:0.000775s ]
select * from pdf where partno='861400011YO2LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001243s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '861400011YO2LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.001009s ]
SELECT `id` FROM `stock` WHERE `id` <> 66243627 AND `partno` = '861400011YO2LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.001222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16211680 [ RunTime:0.001184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39228676 LIMIT 5 [ RunTime:0.000537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39228676 ORDER BY `minOrder` ASC [ RunTime:0.001793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39228676 ORDER BY `unit` DESC [ RunTime:0.000490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39228676 LIMIT 2 [ RunTime:0.000465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39228676 ORDER BY `minOrder` ASC [ RunTime:0.000529s ]
select * from pdf where partno='865080342006' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '865080342006' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000592s ]
SELECT `id` FROM `stock` WHERE `id` <> 39228676 AND `partno` = '865080342006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14897032 [ RunTime:0.000861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66243707 LIMIT 5 [ RunTime:0.000486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66243707 ORDER BY `minOrder` ASC [ RunTime:0.000991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66243707 ORDER BY `unit` DESC [ RunTime:0.000481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66243707 LIMIT 2 [ RunTime:0.000381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66243707 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
select * from pdf where partno='861400021YO1LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000572s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '861400021YO1LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000432s ]
SELECT `id` FROM `stock` WHERE `id` <> 66243707 AND `partno` = '861400021YO1LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16211684 [ RunTime:0.000477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39227866 LIMIT 5 [ RunTime:0.000297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39227866 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39227866 ORDER BY `unit` DESC [ RunTime:0.000295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39227866 LIMIT 2 [ RunTime:0.000294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39227866 ORDER BY `minOrder` ASC [ RunTime:0.000270s ]
select * from pdf where partno='865080545012' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '865080545012' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000312s ]
SELECT `id` FROM `stock` WHERE `id` <> 39227866 AND `partno` = '865080545012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14889714 [ RunTime:0.000294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67157084 LIMIT 5 [ RunTime:0.000264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67157084 ORDER BY `minOrder` ASC [ RunTime:0.002246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67157084 ORDER BY `unit` DESC [ RunTime:0.000513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67157084 LIMIT 2 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67157084 ORDER BY `minOrder` ASC [ RunTime:0.000516s ]
select * from pdf where partno='86492-9' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000702s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86492-9' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000577s ]
SELECT `id` FROM `stock` WHERE `id` <> 67157084 AND `partno` = '86492-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67125105 LIMIT 5 [ RunTime:0.000433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67125105 ORDER BY `minOrder` ASC [ RunTime:0.001019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67125105 ORDER BY `unit` DESC [ RunTime:0.000426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67125105 LIMIT 2 [ RunTime:0.000401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67125105 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
select * from pdf where partno='8637-0-15-15-21-27-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000850s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8637-0-15-15-21-27-10-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.000808s ]
SELECT `id` FROM `stock` WHERE `id` <> 67125105 AND `partno` = '8637-0-15-15-21-27-10-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.001435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593910 [ RunTime:0.000810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39227848 LIMIT 5 [ RunTime:0.000419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39227848 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39227848 ORDER BY `unit` DESC [ RunTime:0.000367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39227848 LIMIT 2 [ RunTime:0.000336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39227848 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
select * from pdf where partno='865080642006' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '865080642006' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000461s ]
SELECT `id` FROM `stock` WHERE `id` <> 39227848 AND `partno` = '865080642006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7543 [ RunTime:0.000344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14889708 [ RunTime:0.000386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39227851 LIMIT 5 [ RunTime:0.000354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39227851 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39227851 ORDER BY `unit` DESC [ RunTime:0.000350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39227851 LIMIT 2 [ RunTime:0.000326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39227851 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
select * from pdf where partno='860040573004' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001038s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '860040573004' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000411s ]
SELECT `id` FROM `stock` WHERE `id` <> 39227851 AND `partno` = '860040573004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15582259 [ RunTime:0.000834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39228615 LIMIT 5 [ RunTime:0.000451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39228615 ORDER BY `minOrder` ASC [ RunTime:0.000470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39228615 ORDER BY `unit` DESC [ RunTime:0.000256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39228615 LIMIT 2 [ RunTime:0.000253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39228615 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
select * from pdf where partno='865080440002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '865080440002' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000320s ]
SELECT `id` FROM `stock` WHERE `id` <> 39228615 AND `partno` = '865080440002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13985409 [ RunTime:0.000298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39228483 LIMIT 5 [ RunTime:0.000260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39228483 ORDER BY `minOrder` ASC [ RunTime:0.000663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39228483 ORDER BY `unit` DESC [ RunTime:0.000248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39228483 LIMIT 2 [ RunTime:0.000232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39228483 ORDER BY `minOrder` ASC [ RunTime:0.000277s ]
select * from pdf where partno='860020672010' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '860020672010' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000312s ]
SELECT `id` FROM `stock` WHERE `id` <> 39228483 AND `partno` = '860020672010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13983024 [ RunTime:0.000322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39227853 LIMIT 5 [ RunTime:0.000247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39227853 ORDER BY `minOrder` ASC [ RunTime:0.000285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39227853 ORDER BY `unit` DESC [ RunTime:0.000249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39227853 LIMIT 2 [ RunTime:0.000275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39227853 ORDER BY `minOrder` ASC [ RunTime:0.000323s ]
select * from pdf where partno='865080343009' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '865080343009' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000323s ]
SELECT `id` FROM `stock` WHERE `id` <> 39227853 AND `partno` = '865080343009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13972929 [ RunTime:0.000282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67161530 LIMIT 5 [ RunTime:0.000299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67161530 ORDER BY `minOrder` ASC [ RunTime:0.000542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67161530 ORDER BY `unit` DESC [ RunTime:0.000247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67161530 LIMIT 2 [ RunTime:0.000236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67161530 ORDER BY `minOrder` ASC [ RunTime:0.000303s ]
select * from pdf where partno='8656352064LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8656352064LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000325s ]
SELECT `id` FROM `stock` WHERE `id` <> 67161530 AND `partno` = '8656352064LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39228536 LIMIT 5 [ RunTime:0.000252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39228536 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39228536 ORDER BY `unit` DESC [ RunTime:0.000247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39228536 LIMIT 2 [ RunTime:0.000231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39228536 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
select * from pdf where partno='860160672009' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000366s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '860160672009' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000299s ]
SELECT `id` FROM `stock` WHERE `id` <> 39228536 AND `partno` = '860160672009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13984127 [ RunTime:0.000432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39229252 LIMIT 5 [ RunTime:0.000268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39229252 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39229252 ORDER BY `unit` DESC [ RunTime:0.000243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39229252 LIMIT 2 [ RunTime:0.000232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39229252 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
select * from pdf where partno='865080345012' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '865080345012' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000349s ]
SELECT `id` FROM `stock` WHERE `id` <> 39229252 AND `partno` = '865080345012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.000408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13972935 [ RunTime:0.000604s ]
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 '86%' OR `brand` LIKE '86%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000687s ]
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 '86%' OR `brand` LIKE '86%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000495s ]
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 '86%' OR `brand` LIKE '86%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000484s ]
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 '86%' OR `brand` LIKE '86%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000483s ]
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 '86%' OR `brand` LIKE '86%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000513s ]
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 '86%' OR `brand` LIKE '86%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000476s ]
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 '86%' OR `brand` LIKE '86%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000521s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '86%' OR `brand` LIKE '86%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.044735s ]