SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002417s ]
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 '17000%' OR `brand` LIKE '17000%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.073517s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.016793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17299445 LIMIT 5 [ RunTime:0.030720s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17299445 ORDER BY `minOrder` ASC [ RunTime:0.023904s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17299445 ORDER BY `unit` DESC [ RunTime:0.015328s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.018723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17299445 LIMIT 2 [ RunTime:0.030510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17299445 ORDER BY `minOrder` ASC [ RunTime:0.016367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418284 LIMIT 5 [ RunTime:0.020511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418284 ORDER BY `minOrder` ASC [ RunTime:0.005263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11418284 ORDER BY `unit` DESC [ RunTime:0.010475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11418284 LIMIT 2 [ RunTime:0.012579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418284 ORDER BY `minOrder` ASC [ RunTime:0.010584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12627272 LIMIT 5 [ RunTime:0.021562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12627272 ORDER BY `minOrder` ASC [ RunTime:0.018328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12627272 ORDER BY `unit` DESC [ RunTime:0.020363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12627272 LIMIT 2 [ RunTime:0.037517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12627272 ORDER BY `minOrder` ASC [ RunTime:0.004686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19588885 LIMIT 5 [ RunTime:0.036691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19588885 ORDER BY `minOrder` ASC [ RunTime:0.028676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19588885 ORDER BY `unit` DESC [ RunTime:0.034647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19588885 LIMIT 2 [ RunTime:0.030240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19588885 ORDER BY `minOrder` ASC [ RunTime:0.029027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417749 LIMIT 5 [ RunTime:0.026193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417749 ORDER BY `minOrder` ASC [ RunTime:0.035840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11417749 ORDER BY `unit` DESC [ RunTime:0.024194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11417749 LIMIT 2 [ RunTime:0.063718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417749 ORDER BY `minOrder` ASC [ RunTime:0.011225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6774 LIMIT 5 [ RunTime:0.008100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6774 ORDER BY `minOrder` ASC [ RunTime:0.052895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6774 ORDER BY `unit` DESC [ RunTime:0.039428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6774 LIMIT 2 [ RunTime:0.008600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6774 ORDER BY `minOrder` ASC [ RunTime:0.003335s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002667s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170001-0104' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.037717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12627188 LIMIT 5 [ RunTime:0.044296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12627188 ORDER BY `minOrder` ASC [ RunTime:0.033664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12627188 ORDER BY `unit` DESC [ RunTime:0.014536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12627188 LIMIT 2 [ RunTime:0.012986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12627188 ORDER BY `minOrder` ASC [ RunTime:0.005960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12627225 LIMIT 5 [ RunTime:0.001165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12627225 ORDER BY `minOrder` ASC [ RunTime:0.000563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12627225 ORDER BY `unit` DESC [ RunTime:0.024460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12627225 LIMIT 2 [ RunTime:0.006117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12627225 ORDER BY `minOrder` ASC [ RunTime:0.005124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12517234 LIMIT 5 [ RunTime:0.022576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517234 ORDER BY `minOrder` ASC [ RunTime:0.034562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12517234 ORDER BY `unit` DESC [ RunTime:0.007589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12517234 LIMIT 2 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12517234 ORDER BY `minOrder` ASC [ RunTime:0.002889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19588905 LIMIT 5 [ RunTime:0.015849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19588905 ORDER BY `minOrder` ASC [ RunTime:0.007964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19588905 ORDER BY `unit` DESC [ RunTime:0.012116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19588905 LIMIT 2 [ RunTime:0.031702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19588905 ORDER BY `minOrder` ASC [ RunTime:0.019783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19588909 LIMIT 5 [ RunTime:0.019505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19588909 ORDER BY `minOrder` ASC [ RunTime:0.007391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19588909 ORDER BY `unit` DESC [ RunTime:0.013347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19588909 LIMIT 2 [ RunTime:0.026632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19588909 ORDER BY `minOrder` ASC [ RunTime:0.012512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11494135 LIMIT 5 [ RunTime:0.019302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11494135 ORDER BY `minOrder` ASC [ RunTime:0.019701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11494135 ORDER BY `unit` DESC [ RunTime:0.029541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11494135 LIMIT 2 [ RunTime:0.031574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11494135 ORDER BY `minOrder` ASC [ RunTime:0.001818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12544282 LIMIT 5 [ RunTime:0.005154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12544282 ORDER BY `minOrder` ASC [ RunTime:0.028141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12544282 ORDER BY `unit` DESC [ RunTime:0.015712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12544282 LIMIT 2 [ RunTime:0.019179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12544282 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628527 LIMIT 5 [ RunTime:0.013605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628527 ORDER BY `minOrder` ASC [ RunTime:0.022872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12628527 ORDER BY `unit` DESC [ RunTime:0.004218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12628527 LIMIT 2 [ RunTime:0.022026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628527 ORDER BY `minOrder` ASC [ RunTime:0.006273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18600624 LIMIT 5 [ RunTime:0.011975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18600624 ORDER BY `minOrder` ASC [ RunTime:0.017634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18600624 ORDER BY `unit` DESC [ RunTime:0.011398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18600624 LIMIT 2 [ RunTime:0.015108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18600624 ORDER BY `minOrder` ASC [ RunTime:0.002894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6773 LIMIT 5 [ RunTime:0.003515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6773 ORDER BY `minOrder` ASC [ RunTime:0.027434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6773 ORDER BY `unit` DESC [ RunTime:0.034721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6773 LIMIT 2 [ RunTime:0.012624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6773 ORDER BY `minOrder` ASC [ RunTime:0.015725s ]
select * from pdf where partno='170001-0102' and brandshort='MOLEX' limit 1 [ RunTime:0.032777s ]
select foldpath,foldpath2,filename from pdf_file where id=2064077 limit 1 [ RunTime:0.022269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170001-0102' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.088951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16970134 LIMIT 5 [ RunTime:0.069945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16970134 ORDER BY `minOrder` ASC [ RunTime:0.017434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16970134 ORDER BY `unit` DESC [ RunTime:0.025553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16970134 LIMIT 2 [ RunTime:0.024468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16970134 ORDER BY `minOrder` ASC [ RunTime:0.106134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12544283 LIMIT 5 [ RunTime:0.003156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12544283 ORDER BY `minOrder` ASC [ RunTime:0.007350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12544283 ORDER BY `unit` DESC [ RunTime:0.030310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12544283 LIMIT 2 [ RunTime:0.012665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12544283 ORDER BY `minOrder` ASC [ RunTime:0.059626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13280135 LIMIT 5 [ RunTime:0.052054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13280135 ORDER BY `minOrder` ASC [ RunTime:0.012087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13280135 ORDER BY `unit` DESC [ RunTime:0.008023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13280135 LIMIT 2 [ RunTime:0.016865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13280135 ORDER BY `minOrder` ASC [ RunTime:0.018417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14169101 LIMIT 5 [ RunTime:0.031948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14169101 ORDER BY `minOrder` ASC [ RunTime:0.016740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14169101 ORDER BY `unit` DESC [ RunTime:0.014514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14169101 LIMIT 2 [ RunTime:0.023495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14169101 ORDER BY `minOrder` ASC [ RunTime:0.007176s ]
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 '17000%' OR `brand` LIKE '17000%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281309 LIMIT 5 [ RunTime:0.008986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281309 ORDER BY `minOrder` ASC [ RunTime:0.033265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281309 ORDER BY `unit` DESC [ RunTime:0.085909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281309 LIMIT 2 [ RunTime:0.038595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281309 ORDER BY `minOrder` ASC [ RunTime:0.009420s ]
select * from pdf where partno='170001-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.058117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170001-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.059476s ]
SELECT `id` FROM `stock` WHERE `id` <> 32281309 AND `partno` = '170001-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.036324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134841 LIMIT 5 [ RunTime:0.026041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134841 ORDER BY `minOrder` ASC [ RunTime:0.067044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134841 ORDER BY `unit` DESC [ RunTime:0.039817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134841 LIMIT 2 [ RunTime:0.041086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134841 ORDER BY `minOrder` ASC [ RunTime:0.018545s ]
select * from pdf where partno='1700018785' and brandshort='advantech' limit 1 [ RunTime:0.042113s ]
select foldpath,foldpath2,filename from pdf_file where id=2030511 limit 1 [ RunTime:0.017877s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1700018785' OR `brand` LIKE 'advantech%' ) ) LIMIT 1 [ RunTime:0.035116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51130008 LIMIT 5 [ RunTime:0.024776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51130008 ORDER BY `minOrder` ASC [ RunTime:0.030238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51130008 ORDER BY `unit` DESC [ RunTime:0.024124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51130008 LIMIT 2 [ RunTime:0.033173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51130008 ORDER BY `minOrder` ASC [ RunTime:0.045844s ]
select * from pdf where partno='17000' and brandshort='crystek corporation' limit 1 [ RunTime:0.018755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '17000' OR `brand` LIKE 'crystek corporation%' ) ) LIMIT 1 [ RunTime:0.005301s ]
SELECT `id` FROM `stock` WHERE `id` <> 51130008 AND `partno` = '17000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%crystek corporation%' ) [ RunTime:0.023399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134514 LIMIT 5 [ RunTime:0.050976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134514 ORDER BY `minOrder` ASC [ RunTime:0.092827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134514 ORDER BY `unit` DESC [ RunTime:0.061719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134514 LIMIT 2 [ RunTime:0.044059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134514 ORDER BY `minOrder` ASC [ RunTime:0.012646s ]
select * from pdf where partno='1700060202' and brandshort='advantech' limit 1 [ RunTime:0.012281s ]
select foldpath,foldpath2,filename from pdf_file where id=756593 limit 1 [ RunTime:0.052076s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1700060202' OR `brand` LIKE 'advantech%' ) ) LIMIT 1 [ RunTime:0.042432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32310745 LIMIT 5 [ RunTime:0.026120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32310745 ORDER BY `minOrder` ASC [ RunTime:0.037375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32310745 ORDER BY `unit` DESC [ RunTime:0.043017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32310745 LIMIT 2 [ RunTime:0.010591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32310745 ORDER BY `minOrder` ASC [ RunTime:0.010732s ]
select * from pdf where partno='1700017968' and brandshort='advantech' limit 1 [ RunTime:0.013591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1700017968' OR `brand` LIKE 'advantech%' ) ) LIMIT 1 [ RunTime:0.013396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114880 LIMIT 5 [ RunTime:0.005458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114880 ORDER BY `minOrder` ASC [ RunTime:0.031225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51114880 ORDER BY `unit` DESC [ RunTime:0.016562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51114880 LIMIT 2 [ RunTime:0.021739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114880 ORDER BY `minOrder` ASC [ RunTime:0.002101s ]
select * from pdf where partno='170003' and brandshort='digi' limit 1 [ RunTime:0.044954s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170003' OR `brand` LIKE 'digi%' ) ) LIMIT 1 [ RunTime:0.015435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32271834 LIMIT 5 [ RunTime:0.020773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32271834 ORDER BY `minOrder` ASC [ RunTime:0.020533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32271834 ORDER BY `unit` DESC [ RunTime:0.050914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32271834 LIMIT 2 [ RunTime:0.041014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32271834 ORDER BY `minOrder` ASC [ RunTime:0.042447s ]
select * from pdf where partno='1700008822' and brandshort='advantech' limit 1 [ RunTime:0.028292s ]
select foldpath,foldpath2,filename from pdf_file where id=2110766 limit 1 [ RunTime:0.016830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1700008822' OR `brand` LIKE 'advantech%' ) ) LIMIT 1 [ RunTime:0.005188s ]
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 '17000%' OR `brand` LIKE '17000%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60643736 LIMIT 5 [ RunTime:0.031901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60643736 ORDER BY `minOrder` ASC [ RunTime:0.052571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60643736 ORDER BY `unit` DESC [ RunTime:0.034420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60643736 LIMIT 2 [ RunTime:0.014709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60643736 ORDER BY `minOrder` ASC [ RunTime:0.007606s ]
select * from pdf where partno='170002-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.017199s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170002-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007428s ]
SELECT `id` FROM `stock` WHERE `id` <> 60643736 AND `partno` = '170002-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.010543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17299445 [ RunTime:0.018052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60640153 LIMIT 5 [ RunTime:0.012610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60640153 ORDER BY `minOrder` ASC [ RunTime:0.026457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60640153 ORDER BY `unit` DESC [ RunTime:0.018728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60640153 LIMIT 2 [ RunTime:0.006420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60640153 ORDER BY `minOrder` ASC [ RunTime:0.018644s ]
select * from pdf where partno='170001-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.024347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170001-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.005497s ]
SELECT `id` FROM `stock` WHERE `id` <> 60640153 AND `partno` = '170001-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418284 [ RunTime:0.014599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59937405 LIMIT 5 [ RunTime:0.018216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937405 ORDER BY `minOrder` ASC [ RunTime:0.029995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59937405 ORDER BY `unit` DESC [ RunTime:0.000734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59937405 LIMIT 2 [ RunTime:0.000572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937405 ORDER BY `minOrder` ASC [ RunTime:0.002627s ]
select * from pdf where partno='1700010112' and brandshort='Molex' limit 1 [ RunTime:0.016305s ]
select foldpath,foldpath2,filename from pdf_file where id=1509158 limit 1 [ RunTime:0.015861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1700010112' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.015334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60643626 LIMIT 5 [ RunTime:0.008501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60643626 ORDER BY `minOrder` ASC [ RunTime:0.017517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60643626 ORDER BY `unit` DESC [ RunTime:0.005942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60643626 LIMIT 2 [ RunTime:0.025786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60643626 ORDER BY `minOrder` ASC [ RunTime:0.017595s ]
select * from pdf where partno='170003-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.032761s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170003-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.020713s ]
SELECT `id` FROM `stock` WHERE `id` <> 60643626 AND `partno` = '170003-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.015710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19588885 [ RunTime:0.005159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54171284 LIMIT 5 [ RunTime:0.015995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54171284 ORDER BY `minOrder` ASC [ RunTime:0.026527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54171284 ORDER BY `unit` DESC [ RunTime:0.009806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54171284 LIMIT 2 [ RunTime:0.021696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54171284 ORDER BY `minOrder` ASC [ RunTime:0.003655s ]
select * from pdf where partno='170003-4' and brandshort='TE Connectivity' limit 1 [ RunTime:0.015411s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170003-4' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.054804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59934437 LIMIT 5 [ RunTime:0.009824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59934437 ORDER BY `minOrder` ASC [ RunTime:0.011718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59934437 ORDER BY `unit` DESC [ RunTime:0.008098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59934437 LIMIT 2 [ RunTime:0.004810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59934437 ORDER BY `minOrder` ASC [ RunTime:0.013383s ]
select * from pdf where partno='1700010104' and brandshort='Molex' limit 1 [ RunTime:0.020483s ]
select foldpath,foldpath2,filename from pdf_file where id=1509158 limit 1 [ RunTime:0.006480s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1700010104' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.038152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60640155 LIMIT 5 [ RunTime:0.009848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60640155 ORDER BY `minOrder` ASC [ RunTime:0.028677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60640155 ORDER BY `unit` DESC [ RunTime:0.048611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60640155 LIMIT 2 [ RunTime:0.011221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60640155 ORDER BY `minOrder` ASC [ RunTime:0.012603s ]
select * from pdf where partno='170001-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.018018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170001-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.036134s ]
SELECT `id` FROM `stock` WHERE `id` <> 60640155 AND `partno` = '170001-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.062839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417749 [ RunTime:0.034795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60643623 LIMIT 5 [ RunTime:0.029297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60643623 ORDER BY `minOrder` ASC [ RunTime:0.027265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60643623 ORDER BY `unit` DESC [ RunTime:0.043360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60643623 LIMIT 2 [ RunTime:0.055713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60643623 ORDER BY `minOrder` ASC [ RunTime:0.025922s ]
select * from pdf where partno='170002-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.020902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170002-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.039098s ]
SELECT `id` FROM `stock` WHERE `id` <> 60643623 AND `partno` = '170002-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.054174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19588905 [ RunTime:0.008634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59936809 LIMIT 5 [ RunTime:0.034633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936809 ORDER BY `minOrder` ASC [ RunTime:0.053449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59936809 ORDER BY `unit` DESC [ RunTime:0.036538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59936809 LIMIT 2 [ RunTime:0.074878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936809 ORDER BY `minOrder` ASC [ RunTime:0.022487s ]
select * from pdf where partno='1700010102' and brandshort='Molex' limit 1 [ RunTime:0.050043s ]
select foldpath,foldpath2,filename from pdf_file where id=1509158 limit 1 [ RunTime:0.033275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1700010102' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.028709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59384863 LIMIT 5 [ RunTime:0.016344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59384863 ORDER BY `minOrder` ASC [ RunTime:0.006645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59384863 ORDER BY `unit` DESC [ RunTime:0.029739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59384863 LIMIT 2 [ RunTime:0.027717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59384863 ORDER BY `minOrder` ASC [ RunTime:0.012881s ]
select * from pdf where partno='1700024' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.007062s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1700024' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.020181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59937097 LIMIT 5 [ RunTime:0.023669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937097 ORDER BY `minOrder` ASC [ RunTime:0.003930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59937097 ORDER BY `unit` DESC [ RunTime:0.010760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59937097 LIMIT 2 [ RunTime:0.013423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937097 ORDER BY `minOrder` ASC [ RunTime:0.008479s ]
select * from pdf where partno='1700010106' and brandshort='Molex' limit 1 [ RunTime:0.001326s ]
select foldpath,foldpath2,filename from pdf_file where id=1509158 limit 1 [ RunTime:0.002959s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1700010106' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.023909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60643597 LIMIT 5 [ RunTime:0.011666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60643597 ORDER BY `minOrder` ASC [ RunTime:0.007014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60643597 ORDER BY `unit` DESC [ RunTime:0.013143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60643597 LIMIT 2 [ RunTime:0.022866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60643597 ORDER BY `minOrder` ASC [ RunTime:0.004076s ]
select * from pdf where partno='170003-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006877s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170003-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002493s ]
SELECT `id` FROM `stock` WHERE `id` <> 60643597 AND `partno` = '170003-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19588909 [ RunTime:0.013755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53819202 LIMIT 5 [ RunTime:0.002199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53819202 ORDER BY `minOrder` ASC [ RunTime:0.024701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53819202 ORDER BY `unit` DESC [ RunTime:0.008404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53819202 LIMIT 2 [ RunTime:0.012046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53819202 ORDER BY `minOrder` ASC [ RunTime:0.015044s ]
select * from pdf where partno='170001-3' and brandshort='TE Connectivity' limit 1 [ RunTime:0.002383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170001-3' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.030379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60559906 LIMIT 5 [ RunTime:0.010704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60559906 ORDER BY `minOrder` ASC [ RunTime:0.031567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60559906 ORDER BY `unit` DESC [ RunTime:0.011324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60559906 LIMIT 2 [ RunTime:0.027695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60559906 ORDER BY `minOrder` ASC [ RunTime:0.009494s ]
select * from pdf where partno='1700008' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.016164s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1700008' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.030538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59937170 LIMIT 5 [ RunTime:0.011852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937170 ORDER BY `minOrder` ASC [ RunTime:0.044657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59937170 ORDER BY `unit` DESC [ RunTime:0.019796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59937170 LIMIT 2 [ RunTime:0.011869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937170 ORDER BY `minOrder` ASC [ RunTime:0.012495s ]
select * from pdf where partno='1700010108' and brandshort='Molex' limit 1 [ RunTime:0.015351s ]
select foldpath,foldpath2,filename from pdf_file where id=1509158 limit 1 [ RunTime:0.003977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1700010108' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59385169 LIMIT 5 [ RunTime:0.023750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59385169 ORDER BY `minOrder` ASC [ RunTime:0.015821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59385169 ORDER BY `unit` DESC [ RunTime:0.034495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59385169 LIMIT 2 [ RunTime:0.007988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59385169 ORDER BY `minOrder` ASC [ RunTime:0.031658s ]
select * from pdf where partno='1700011' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.016705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1700011' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59937562 LIMIT 5 [ RunTime:0.032371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937562 ORDER BY `minOrder` ASC [ RunTime:0.036676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59937562 ORDER BY `unit` DESC [ RunTime:0.014695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59937562 LIMIT 2 [ RunTime:0.034706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937562 ORDER BY `minOrder` ASC [ RunTime:0.007528s ]
select * from pdf where partno='1700010110' and brandshort='Molex' limit 1 [ RunTime:0.027001s ]
select foldpath,foldpath2,filename from pdf_file where id=1509158 limit 1 [ RunTime:0.004943s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1700010110' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.019107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58471999 LIMIT 5 [ RunTime:0.021325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471999 ORDER BY `minOrder` ASC [ RunTime:0.016125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58471999 ORDER BY `unit` DESC [ RunTime:0.021433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58471999 LIMIT 2 [ RunTime:0.025875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471999 ORDER BY `minOrder` ASC [ RunTime:0.005512s ]
select * from pdf where partno='17000539A' and brandshort='Comair Rotron' limit 1 [ RunTime:0.012496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '17000539A' OR `brand` LIKE 'Comair Rotron%' ) ) LIMIT 1 [ RunTime:0.006169s ]
SELECT `id` FROM `stock` WHERE `id` <> 58471999 AND `partno` = '17000539A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comair rotron%' ) [ RunTime:0.003051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18600624 [ RunTime:0.018609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60560609 LIMIT 5 [ RunTime:0.008645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560609 ORDER BY `minOrder` ASC [ RunTime:0.003904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60560609 ORDER BY `unit` DESC [ RunTime:0.000803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60560609 LIMIT 2 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560609 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
select * from pdf where partno='1700037' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1700037' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58471713 LIMIT 5 [ RunTime:0.012926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471713 ORDER BY `minOrder` ASC [ RunTime:0.018137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58471713 ORDER BY `unit` DESC [ RunTime:0.031132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58471713 LIMIT 2 [ RunTime:0.024971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471713 ORDER BY `minOrder` ASC [ RunTime:0.001040s ]
select * from pdf where partno='17000538A' and brandshort='Comair Rotron' limit 1 [ RunTime:0.002082s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '17000538A' OR `brand` LIKE 'Comair Rotron%' ) ) LIMIT 1 [ RunTime:0.008532s ]
SELECT `id` FROM `stock` WHERE `id` <> 58471713 AND `partno` = '17000538A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comair rotron%' ) [ RunTime:0.013869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14169463 [ RunTime:0.075148s ]
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 '17000%' OR `brand` LIKE '17000%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010797s ]
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 '17000%' OR `brand` LIKE '17000%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024507s ]
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 '17000%' OR `brand` LIKE '17000%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043317s ]
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 '17000%' OR `brand` LIKE '17000%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038829s ]
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 '17000%' OR `brand` LIKE '17000%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046725s ]
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 '17000%' OR `brand` LIKE '17000%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054196s ]
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 '17000%' OR `brand` LIKE '17000%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.169206s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '17000%' OR `brand` LIKE '17000%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.103907s ]