SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001577s ]
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 'MRF1%' OR `brand` LIKE 'MRF1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047059s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12618070 LIMIT 5 [ RunTime:0.006506s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.014996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618070 ORDER BY `minOrder` ASC [ RunTime:0.025685s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12618070 ORDER BY `unit` DESC [ RunTime:0.017413s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12618070 LIMIT 2 [ RunTime:0.023460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618070 ORDER BY `minOrder` ASC [ RunTime:0.009882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610874 LIMIT 5 [ RunTime:0.012304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610874 ORDER BY `minOrder` ASC [ RunTime:0.100743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12610874 ORDER BY `unit` DESC [ RunTime:0.059728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12610874 LIMIT 2 [ RunTime:0.086522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610874 ORDER BY `minOrder` ASC [ RunTime:0.009940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610873 LIMIT 5 [ RunTime:0.014657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610873 ORDER BY `minOrder` ASC [ RunTime:0.030380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12610873 ORDER BY `unit` DESC [ RunTime:0.032311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12610873 LIMIT 2 [ RunTime:0.009973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610873 ORDER BY `minOrder` ASC [ RunTime:0.032261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610861 LIMIT 5 [ RunTime:0.011528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610861 ORDER BY `minOrder` ASC [ RunTime:0.042505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12610861 ORDER BY `unit` DESC [ RunTime:0.036566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12610861 LIMIT 2 [ RunTime:0.036272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610861 ORDER BY `minOrder` ASC [ RunTime:0.013810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12619654 LIMIT 5 [ RunTime:0.031172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12619654 ORDER BY `minOrder` ASC [ RunTime:0.023348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12619654 ORDER BY `unit` DESC [ RunTime:0.018625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12619654 LIMIT 2 [ RunTime:0.015170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12619654 ORDER BY `minOrder` ASC [ RunTime:0.026056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11488483 LIMIT 5 [ RunTime:0.075484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11488483 ORDER BY `minOrder` ASC [ RunTime:0.048044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11488483 ORDER BY `unit` DESC [ RunTime:0.078588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11488483 LIMIT 2 [ RunTime:0.038355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11488483 ORDER BY `minOrder` ASC [ RunTime:0.053825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610738 LIMIT 5 [ RunTime:0.054467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610738 ORDER BY `minOrder` ASC [ RunTime:0.017954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12610738 ORDER BY `unit` DESC [ RunTime:0.012984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12610738 LIMIT 2 [ RunTime:0.022164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610738 ORDER BY `minOrder` ASC [ RunTime:0.011992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11487607 LIMIT 5 [ RunTime:0.025370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11487607 ORDER BY `minOrder` ASC [ RunTime:0.030609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11487607 ORDER BY `unit` DESC [ RunTime:0.003120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11487607 LIMIT 2 [ RunTime:0.028858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11487607 ORDER BY `minOrder` ASC [ RunTime:0.004825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610862 LIMIT 5 [ RunTime:0.014209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610862 ORDER BY `minOrder` ASC [ RunTime:0.014480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12610862 ORDER BY `unit` DESC [ RunTime:0.002570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12610862 LIMIT 2 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610862 ORDER BY `minOrder` ASC [ RunTime:0.003600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11487344 LIMIT 5 [ RunTime:0.006081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11487344 ORDER BY `minOrder` ASC [ RunTime:0.012471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11487344 ORDER BY `unit` DESC [ RunTime:0.018442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11487344 LIMIT 2 [ RunTime:0.004664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11487344 ORDER BY `minOrder` ASC [ RunTime:0.006691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12406061 LIMIT 5 [ RunTime:0.008308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12406061 ORDER BY `minOrder` ASC [ RunTime:0.001503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12406061 ORDER BY `unit` DESC [ RunTime:0.005005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12406061 LIMIT 2 [ RunTime:0.012805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12406061 ORDER BY `minOrder` ASC [ RunTime:0.018639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11343720 LIMIT 5 [ RunTime:0.019271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11343720 ORDER BY `minOrder` ASC [ RunTime:0.005836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11343720 ORDER BY `unit` DESC [ RunTime:0.007454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11343720 LIMIT 2 [ RunTime:0.009134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11343720 ORDER BY `minOrder` ASC [ RunTime:0.002863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11343718 LIMIT 5 [ RunTime:0.001405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11343718 ORDER BY `minOrder` ASC [ RunTime:0.001481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11343718 ORDER BY `unit` DESC [ RunTime:0.002691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11343718 LIMIT 2 [ RunTime:0.004990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11343718 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17006283 LIMIT 5 [ RunTime:0.000735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17006283 ORDER BY `minOrder` ASC [ RunTime:0.002939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17006283 ORDER BY `unit` DESC [ RunTime:0.004904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17006283 LIMIT 2 [ RunTime:0.003376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17006283 ORDER BY `minOrder` ASC [ RunTime:0.001083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12407205 LIMIT 5 [ RunTime:0.001534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12407205 ORDER BY `minOrder` ASC [ RunTime:0.006317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12407205 ORDER BY `unit` DESC [ RunTime:0.010637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12407205 LIMIT 2 [ RunTime:0.003053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12407205 ORDER BY `minOrder` ASC [ RunTime:0.008672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12407042 LIMIT 5 [ RunTime:0.000781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12407042 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12407042 ORDER BY `unit` DESC [ RunTime:0.005452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12407042 LIMIT 2 [ RunTime:0.004656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12407042 ORDER BY `minOrder` ASC [ RunTime:0.006413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11344281 LIMIT 5 [ RunTime:0.019953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11344281 ORDER BY `minOrder` ASC [ RunTime:0.000860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11344281 ORDER BY `unit` DESC [ RunTime:0.011446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11344281 LIMIT 2 [ RunTime:0.002576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11344281 ORDER BY `minOrder` ASC [ RunTime:0.007868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20080820 LIMIT 5 [ RunTime:0.016279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20080820 ORDER BY `minOrder` ASC [ RunTime:0.011829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20080820 ORDER BY `unit` DESC [ RunTime:0.046373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20080820 LIMIT 2 [ RunTime:0.011028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20080820 ORDER BY `minOrder` ASC [ RunTime:0.002400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16633007 LIMIT 5 [ RunTime:0.023227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16633007 ORDER BY `minOrder` ASC [ RunTime:0.013273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16633007 ORDER BY `unit` DESC [ RunTime:0.020756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16633007 LIMIT 2 [ RunTime:0.019723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16633007 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16633006 LIMIT 5 [ RunTime:0.001033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16633006 ORDER BY `minOrder` ASC [ RunTime:0.000798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16633006 ORDER BY `unit` DESC [ RunTime:0.003426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16633006 LIMIT 2 [ RunTime:0.002359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16633006 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
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 'MRF1%' OR `brand` LIKE 'MRF1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51024915 LIMIT 5 [ RunTime:0.047623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024915 ORDER BY `minOrder` ASC [ RunTime:0.038752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51024915 ORDER BY `unit` DESC [ RunTime:0.023709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51024915 LIMIT 2 [ RunTime:0.009661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024915 ORDER BY `minOrder` ASC [ RunTime:0.035813s ]
select * from pdf where partno='mrf101an' and brandshort='nxp semiconductors' limit 1 [ RunTime:0.018846s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001296s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mrf101an' OR `brand` LIKE 'nxp semiconductors%' ) ) LIMIT 1 [ RunTime:0.025150s ]
SELECT `id` FROM `stock` WHERE `id` <> 51024915 AND `partno` = 'mrf101an' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nxp semiconductors%' ) [ RunTime:0.027388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51024675 LIMIT 5 [ RunTime:0.008175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024675 ORDER BY `minOrder` ASC [ RunTime:0.035427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51024675 ORDER BY `unit` DESC [ RunTime:0.001604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51024675 LIMIT 2 [ RunTime:0.034498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024675 ORDER BY `minOrder` ASC [ RunTime:0.003683s ]
select * from pdf where partno='mrf148a' and brandshort='macom' limit 1 [ RunTime:0.009840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mrf148a' OR `brand` LIKE 'macom%' ) ) LIMIT 1 [ RunTime:0.007757s ]
SELECT `id` FROM `stock` WHERE `id` <> 51024675 AND `partno` = 'mrf148a' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom%' ) [ RunTime:0.041093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51761714 [ RunTime:0.035430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51024687 LIMIT 5 [ RunTime:0.050667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024687 ORDER BY `minOrder` ASC [ RunTime:0.034566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51024687 ORDER BY `unit` DESC [ RunTime:0.014853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51024687 LIMIT 2 [ RunTime:0.027141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024687 ORDER BY `minOrder` ASC [ RunTime:0.018349s ]
select * from pdf where partno='mrf136' and brandshort='macom' limit 1 [ RunTime:0.083325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mrf136' OR `brand` LIKE 'macom%' ) ) LIMIT 1 [ RunTime:0.007891s ]
SELECT `id` FROM `stock` WHERE `id` <> 51024687 AND `partno` = 'mrf136' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom%' ) [ RunTime:0.050091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51760766 [ RunTime:0.027930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51028010 LIMIT 5 [ RunTime:0.025191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51028010 ORDER BY `minOrder` ASC [ RunTime:0.030960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51028010 ORDER BY `unit` DESC [ RunTime:0.035116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51028010 LIMIT 2 [ RunTime:0.026900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51028010 ORDER BY `minOrder` ASC [ RunTime:0.001880s ]
select * from pdf where partno='mrf158' and brandshort='macom' limit 1 [ RunTime:0.010625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mrf158' OR `brand` LIKE 'macom%' ) ) LIMIT 1 [ RunTime:0.017568s ]
SELECT `id` FROM `stock` WHERE `id` <> 51028010 AND `partno` = 'mrf158' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom%' ) [ RunTime:0.016052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51024592 [ RunTime:0.020061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51762365 [ RunTime:0.024128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51024592 LIMIT 5 [ RunTime:0.016618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024592 ORDER BY `minOrder` ASC [ RunTime:0.018861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51024592 ORDER BY `unit` DESC [ RunTime:0.008185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51024592 LIMIT 2 [ RunTime:0.033910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024592 ORDER BY `minOrder` ASC [ RunTime:0.003318s ]
select * from pdf where partno='mrf158' and brandshort='macom' limit 1 [ RunTime:0.004271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mrf158' OR `brand` LIKE 'macom%' ) ) LIMIT 1 [ RunTime:0.000469s ]
SELECT `id` FROM `stock` WHERE `id` <> 51024592 AND `partno` = 'mrf158' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom%' ) [ RunTime:0.011439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51028010 [ RunTime:0.018153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51762365 [ RunTime:0.000569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51027843 LIMIT 5 [ RunTime:0.001732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51027843 ORDER BY `minOrder` ASC [ RunTime:0.001229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51027843 ORDER BY `unit` DESC [ RunTime:0.003228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51027843 LIMIT 2 [ RunTime:0.001104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51027843 ORDER BY `minOrder` ASC [ RunTime:0.001247s ]
select * from pdf where partno='mrf150mp' and brandshort='macom' limit 1 [ RunTime:0.019164s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mrf150mp' OR `brand` LIKE 'macom%' ) ) LIMIT 1 [ RunTime:0.012584s ]
SELECT `id` FROM `stock` WHERE `id` <> 51027843 AND `partno` = 'mrf150mp' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom%' ) [ RunTime:0.009136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51762722 [ RunTime:0.010131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51024690 LIMIT 5 [ RunTime:0.024123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024690 ORDER BY `minOrder` ASC [ RunTime:0.018675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51024690 ORDER BY `unit` DESC [ RunTime:0.010250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51024690 LIMIT 2 [ RunTime:0.027830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024690 ORDER BY `minOrder` ASC [ RunTime:0.017433s ]
select * from pdf where partno='mrf177' and brandshort='macom' limit 1 [ RunTime:0.015427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mrf177' OR `brand` LIKE 'macom%' ) ) LIMIT 1 [ RunTime:0.018006s ]
SELECT `id` FROM `stock` WHERE `id` <> 51024690 AND `partno` = 'mrf177' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom%' ) [ RunTime:0.020635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51762680 [ RunTime:0.014411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51024688 LIMIT 5 [ RunTime:0.019237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024688 ORDER BY `minOrder` ASC [ RunTime:0.013317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51024688 ORDER BY `unit` DESC [ RunTime:0.012750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51024688 LIMIT 2 [ RunTime:0.005737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024688 ORDER BY `minOrder` ASC [ RunTime:0.001474s ]
select * from pdf where partno='mrf137' and brandshort='macom' limit 1 [ RunTime:0.012820s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mrf137' OR `brand` LIKE 'macom%' ) ) LIMIT 1 [ RunTime:0.008736s ]
SELECT `id` FROM `stock` WHERE `id` <> 51024688 AND `partno` = 'mrf137' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom%' ) [ RunTime:0.008270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51760829 [ RunTime:0.026049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51028217 LIMIT 5 [ RunTime:0.014426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51028217 ORDER BY `minOrder` ASC [ RunTime:0.011466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51028217 ORDER BY `unit` DESC [ RunTime:0.002709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51028217 LIMIT 2 [ RunTime:0.007825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51028217 ORDER BY `minOrder` ASC [ RunTime:0.007584s ]
select * from pdf where partno='mrf151a' and brandshort='macom' limit 1 [ RunTime:0.004986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mrf151a' OR `brand` LIKE 'macom%' ) ) LIMIT 1 [ RunTime:0.022397s ]
SELECT `id` FROM `stock` WHERE `id` <> 51028217 AND `partno` = 'mrf151a' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom%' ) [ RunTime:0.014752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51024596 [ RunTime:0.002209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51761590 [ RunTime:0.004245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51024596 LIMIT 5 [ RunTime:0.002027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024596 ORDER BY `minOrder` ASC [ RunTime:0.010987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51024596 ORDER BY `unit` DESC [ RunTime:0.023542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51024596 LIMIT 2 [ RunTime:0.011390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024596 ORDER BY `minOrder` ASC [ RunTime:0.004682s ]
select * from pdf where partno='mrf151a' and brandshort='macom' limit 1 [ RunTime:0.003080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mrf151a' OR `brand` LIKE 'macom%' ) ) LIMIT 1 [ RunTime:0.008041s ]
SELECT `id` FROM `stock` WHERE `id` <> 51024596 AND `partno` = 'mrf151a' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom%' ) [ RunTime:0.000853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51028217 [ RunTime:0.004746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51761590 [ RunTime:0.011714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51024903 LIMIT 5 [ RunTime:0.007420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024903 ORDER BY `minOrder` ASC [ RunTime:0.019675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51024903 ORDER BY `unit` DESC [ RunTime:0.017543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51024903 LIMIT 2 [ RunTime:0.004537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024903 ORDER BY `minOrder` ASC [ RunTime:0.004138s ]
select * from pdf where partno='mrf173' and brandshort='macom' limit 1 [ RunTime:0.006229s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mrf173' OR `brand` LIKE 'macom%' ) ) LIMIT 1 [ RunTime:0.007056s ]
SELECT `id` FROM `stock` WHERE `id` <> 51024903 AND `partno` = 'mrf173' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom%' ) [ RunTime:0.028275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51762544 [ RunTime:0.011741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51024795 LIMIT 5 [ RunTime:0.017198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024795 ORDER BY `minOrder` ASC [ RunTime:0.014007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51024795 ORDER BY `unit` DESC [ RunTime:0.008517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51024795 LIMIT 2 [ RunTime:0.019310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024795 ORDER BY `minOrder` ASC [ RunTime:0.018038s ]
select * from pdf where partno='mrf101bn' and brandshort='nxp semiconductors' limit 1 [ RunTime:0.010573s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mrf101bn' OR `brand` LIKE 'nxp semiconductors%' ) ) LIMIT 1 [ RunTime:0.032169s ]
SELECT `id` FROM `stock` WHERE `id` <> 51024795 AND `partno` = 'mrf101bn' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nxp semiconductors%' ) [ RunTime:0.035049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51024713 LIMIT 5 [ RunTime:0.008723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024713 ORDER BY `minOrder` ASC [ RunTime:0.022119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51024713 ORDER BY `unit` DESC [ RunTime:0.004498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51024713 LIMIT 2 [ RunTime:0.000943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024713 ORDER BY `minOrder` ASC [ RunTime:0.012149s ]
select * from pdf where partno='mrf1k50hr5' and brandshort='nxp semiconductors' limit 1 [ RunTime:0.010859s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mrf1k50hr5' OR `brand` LIKE 'nxp semiconductors%' ) ) LIMIT 1 [ RunTime:0.007084s ]
SELECT `id` FROM `stock` WHERE `id` <> 51024713 AND `partno` = 'mrf1k50hr5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nxp semiconductors%' ) [ RunTime:0.026648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51024612 LIMIT 5 [ RunTime:0.024918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024612 ORDER BY `minOrder` ASC [ RunTime:0.047127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51024612 ORDER BY `unit` DESC [ RunTime:0.016419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51024612 LIMIT 2 [ RunTime:0.031931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024612 ORDER BY `minOrder` ASC [ RunTime:0.005331s ]
select * from pdf where partno='mrf174' and brandshort='macom' limit 1 [ RunTime:0.016256s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mrf174' OR `brand` LIKE 'macom%' ) ) LIMIT 1 [ RunTime:0.018831s ]
SELECT `id` FROM `stock` WHERE `id` <> 51024612 AND `partno` = 'mrf174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom%' ) [ RunTime:0.018971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51760928 [ RunTime:0.036900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51024891 LIMIT 5 [ RunTime:0.031829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024891 ORDER BY `minOrder` ASC [ RunTime:0.039092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51024891 ORDER BY `unit` DESC [ RunTime:0.024752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51024891 LIMIT 2 [ RunTime:0.065668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024891 ORDER BY `minOrder` ASC [ RunTime:0.044098s ]
select * from pdf where partno='mrf1150mb' and brandshort='macom' limit 1 [ RunTime:0.058182s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mrf1150mb' OR `brand` LIKE 'macom%' ) ) LIMIT 1 [ RunTime:0.037417s ]
SELECT `id` FROM `stock` WHERE `id` <> 51024891 AND `partno` = 'mrf1150mb' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom%' ) [ RunTime:0.056370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51759531 [ RunTime:0.085775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51024729 LIMIT 5 [ RunTime:0.034312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024729 ORDER BY `minOrder` ASC [ RunTime:0.059266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51024729 ORDER BY `unit` DESC [ RunTime:0.049762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51024729 LIMIT 2 [ RunTime:0.024732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024729 ORDER BY `minOrder` ASC [ RunTime:0.004442s ]
select * from pdf where partno='mrf166c' and brandshort='macom' limit 1 [ RunTime:0.027931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mrf166c' OR `brand` LIKE 'macom%' ) ) LIMIT 1 [ RunTime:0.013699s ]
SELECT `id` FROM `stock` WHERE `id` <> 51024729 AND `partno` = 'mrf166c' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom%' ) [ RunTime:0.016099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51761712 [ RunTime:0.016075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51024928 LIMIT 5 [ RunTime:0.042003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024928 ORDER BY `minOrder` ASC [ RunTime:0.061166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51024928 ORDER BY `unit` DESC [ RunTime:0.040081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51024928 LIMIT 2 [ RunTime:0.028751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024928 ORDER BY `minOrder` ASC [ RunTime:0.010417s ]
select * from pdf where partno='mrf171a' and brandshort='macom' limit 1 [ RunTime:0.011380s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mrf171a' OR `brand` LIKE 'macom%' ) ) LIMIT 1 [ RunTime:0.041348s ]
SELECT `id` FROM `stock` WHERE `id` <> 51024928 AND `partno` = 'mrf171a' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom%' ) [ RunTime:0.044889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51760889 [ RunTime:0.005536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51024803 LIMIT 5 [ RunTime:0.016722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024803 ORDER BY `minOrder` ASC [ RunTime:0.016328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51024803 ORDER BY `unit` DESC [ RunTime:0.030529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51024803 LIMIT 2 [ RunTime:0.032276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024803 ORDER BY `minOrder` ASC [ RunTime:0.001925s ]
select * from pdf where partno='mrf1090mb' and brandshort='macom' limit 1 [ RunTime:0.064326s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mrf1090mb' OR `brand` LIKE 'macom%' ) ) LIMIT 1 [ RunTime:0.036949s ]
SELECT `id` FROM `stock` WHERE `id` <> 51024803 AND `partno` = 'mrf1090mb' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom%' ) [ RunTime:0.018171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51759529 [ RunTime:0.048232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51024927 LIMIT 5 [ RunTime:0.002399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024927 ORDER BY `minOrder` ASC [ RunTime:0.034861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51024927 ORDER BY `unit` DESC [ RunTime:0.053205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51024927 LIMIT 2 [ RunTime:0.019330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024927 ORDER BY `minOrder` ASC [ RunTime:0.004772s ]
select * from pdf where partno='mrf166w' and brandshort='macom' limit 1 [ RunTime:0.007408s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mrf166w' OR `brand` LIKE 'macom%' ) ) LIMIT 1 [ RunTime:0.007689s ]
SELECT `id` FROM `stock` WHERE `id` <> 51024927 AND `partno` = 'mrf166w' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom%' ) [ RunTime:0.013582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51762633 [ RunTime:0.024669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51024689 LIMIT 5 [ RunTime:0.023778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024689 ORDER BY `minOrder` ASC [ RunTime:0.034869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51024689 ORDER BY `unit` DESC [ RunTime:0.039025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51024689 LIMIT 2 [ RunTime:0.028135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51024689 ORDER BY `minOrder` ASC [ RunTime:0.011625s ]
select * from pdf where partno='mrf141g' and brandshort='macom' limit 1 [ RunTime:0.006472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mrf141g' OR `brand` LIKE 'macom%' ) ) LIMIT 1 [ RunTime:0.004081s ]
SELECT `id` FROM `stock` WHERE `id` <> 51024689 AND `partno` = 'mrf141g' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom%' ) [ RunTime:0.027420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51761593 [ RunTime:0.012163s ]
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 'MRF1%' OR `brand` LIKE 'MRF1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51761115 LIMIT 5 [ RunTime:0.014004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51761115 ORDER BY `minOrder` ASC [ RunTime:0.021212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51761115 ORDER BY `unit` DESC [ RunTime:0.008128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51761115 LIMIT 2 [ RunTime:0.002427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51761115 ORDER BY `minOrder` ASC [ RunTime:0.005377s ]
select * from pdf where partno='MRF1570FT1' and brandshort='Freescale Semiconductor' limit 1 [ RunTime:0.039370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRF1570FT1' OR `brand` LIKE 'Freescale Semiconductor%' ) ) LIMIT 1 [ RunTime:0.022103s ]
SELECT `id` FROM `stock` WHERE `id` <> 51761115 AND `partno` = 'MRF1570FT1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%freescale semiconductor%' ) [ RunTime:0.008790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51760766 LIMIT 5 [ RunTime:0.007916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51760766 ORDER BY `minOrder` ASC [ RunTime:0.008872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51760766 ORDER BY `unit` DESC [ RunTime:0.009441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51760766 LIMIT 2 [ RunTime:0.022221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51760766 ORDER BY `minOrder` ASC [ RunTime:0.005235s ]
select * from pdf where partno='MRF136' and brandshort='MACOM Technology Solutions' limit 1 [ RunTime:0.013381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRF136' OR `brand` LIKE 'MACOM Technology Solutions%' ) ) LIMIT 1 [ RunTime:0.012301s ]
SELECT `id` FROM `stock` WHERE `id` <> 51760766 AND `partno` = 'MRF136' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom technology solutions%' ) [ RunTime:0.033454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51761211 LIMIT 5 [ RunTime:0.024755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51761211 ORDER BY `minOrder` ASC [ RunTime:0.008864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51761211 ORDER BY `unit` DESC [ RunTime:0.012735s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51761211 LIMIT 2 [ RunTime:0.006794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51761211 ORDER BY `minOrder` ASC [ RunTime:0.001238s ]
select * from pdf where partno='MRF18060BLSR3' and brandshort='Freescale Semiconductor' limit 1 [ RunTime:0.001327s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRF18060BLSR3' OR `brand` LIKE 'Freescale Semiconductor%' ) ) LIMIT 1 [ RunTime:0.002716s ]
SELECT `id` FROM `stock` WHERE `id` <> 51761211 AND `partno` = 'MRF18060BLSR3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%freescale semiconductor%' ) [ RunTime:0.005077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51761354 LIMIT 5 [ RunTime:0.012535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51761354 ORDER BY `minOrder` ASC [ RunTime:0.008490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51761354 ORDER BY `unit` DESC [ RunTime:0.000751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51761354 LIMIT 2 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51761354 ORDER BY `minOrder` ASC [ RunTime:0.002037s ]
select * from pdf where partno='MRF19085LR3' and brandshort='Freescale Semiconductor' limit 1 [ RunTime:0.001353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRF19085LR3' OR `brand` LIKE 'Freescale Semiconductor%' ) ) LIMIT 1 [ RunTime:0.003595s ]
SELECT `id` FROM `stock` WHERE `id` <> 51761354 AND `partno` = 'MRF19085LR3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%freescale semiconductor%' ) [ RunTime:0.024771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51761129 LIMIT 5 [ RunTime:0.008041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51761129 ORDER BY `minOrder` ASC [ RunTime:0.002864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51761129 ORDER BY `unit` DESC [ RunTime:0.007009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51761129 LIMIT 2 [ RunTime:0.003787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51761129 ORDER BY `minOrder` ASC [ RunTime:0.007939s ]
select * from pdf where partno='MRF18030BLSR3' and brandshort='Freescale Semiconductor' limit 1 [ RunTime:0.001799s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRF18030BLSR3' OR `brand` LIKE 'Freescale Semiconductor%' ) ) LIMIT 1 [ RunTime:0.001177s ]
SELECT `id` FROM `stock` WHERE `id` <> 51761129 AND `partno` = 'MRF18030BLSR3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%freescale semiconductor%' ) [ RunTime:0.003434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51760829 LIMIT 5 [ RunTime:0.003347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51760829 ORDER BY `minOrder` ASC [ RunTime:0.003156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51760829 ORDER BY `unit` DESC [ RunTime:0.007438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51760829 LIMIT 2 [ RunTime:0.014040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51760829 ORDER BY `minOrder` ASC [ RunTime:0.000741s ]
select * from pdf where partno='MRF137' and brandshort='MACOM Technology Solutions' limit 1 [ RunTime:0.010703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRF137' OR `brand` LIKE 'MACOM Technology Solutions%' ) ) LIMIT 1 [ RunTime:0.013921s ]
SELECT `id` FROM `stock` WHERE `id` <> 51760829 AND `partno` = 'MRF137' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom technology solutions%' ) [ RunTime:0.021195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51761107 LIMIT 5 [ RunTime:0.006341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51761107 ORDER BY `minOrder` ASC [ RunTime:0.009609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51761107 ORDER BY `unit` DESC [ RunTime:0.017782s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51761107 LIMIT 2 [ RunTime:0.026305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51761107 ORDER BY `minOrder` ASC [ RunTime:0.006295s ]
select * from pdf where partno='MRF19045LSR5' and brandshort='Freescale Semiconductor' limit 1 [ RunTime:0.001731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRF19045LSR5' OR `brand` LIKE 'Freescale Semiconductor%' ) ) LIMIT 1 [ RunTime:0.002753s ]
SELECT `id` FROM `stock` WHERE `id` <> 51761107 AND `partno` = 'MRF19045LSR5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%freescale semiconductor%' ) [ RunTime:0.017036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51760889 LIMIT 5 [ RunTime:0.007948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51760889 ORDER BY `minOrder` ASC [ RunTime:0.015151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51760889 ORDER BY `unit` DESC [ RunTime:0.038234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51760889 LIMIT 2 [ RunTime:0.025636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51760889 ORDER BY `minOrder` ASC [ RunTime:0.006916s ]
select * from pdf where partno='MRF171A' and brandshort='MACOM Technology Solutions' limit 1 [ RunTime:0.022628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRF171A' OR `brand` LIKE 'MACOM Technology Solutions%' ) ) LIMIT 1 [ RunTime:0.025987s ]
SELECT `id` FROM `stock` WHERE `id` <> 51760889 AND `partno` = 'MRF171A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom technology solutions%' ) [ RunTime:0.036011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51761390 LIMIT 5 [ RunTime:0.036900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51761390 ORDER BY `minOrder` ASC [ RunTime:0.015326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51761390 ORDER BY `unit` DESC [ RunTime:0.009201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51761390 LIMIT 2 [ RunTime:0.014081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51761390 ORDER BY `minOrder` ASC [ RunTime:0.009277s ]
select * from pdf where partno='MRF1K50GNR5' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.016467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRF1K50GNR5' OR `brand` LIKE 'NXP USA Inc.%' ) ) LIMIT 1 [ RunTime:0.032614s ]
SELECT `id` FROM `stock` WHERE `id` <> 51761390 AND `partno` = 'MRF1K50GNR5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nxp usa inc.%' ) [ RunTime:0.025390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51760928 LIMIT 5 [ RunTime:0.021110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51760928 ORDER BY `minOrder` ASC [ RunTime:0.045341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51760928 ORDER BY `unit` DESC [ RunTime:0.015692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51760928 LIMIT 2 [ RunTime:0.058603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51760928 ORDER BY `minOrder` ASC [ RunTime:0.016360s ]
select * from pdf where partno='MRF174' and brandshort='MACOM Technology Solutions' limit 1 [ RunTime:0.044354s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRF174' OR `brand` LIKE 'MACOM Technology Solutions%' ) ) LIMIT 1 [ RunTime:0.020399s ]
SELECT `id` FROM `stock` WHERE `id` <> 51760928 AND `partno` = 'MRF174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom technology solutions%' ) [ RunTime:0.036967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51761130 LIMIT 5 [ RunTime:0.014724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51761130 ORDER BY `minOrder` ASC [ RunTime:0.015558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51761130 ORDER BY `unit` DESC [ RunTime:0.013698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51761130 LIMIT 2 [ RunTime:0.035431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51761130 ORDER BY `minOrder` ASC [ RunTime:0.010176s ]
select * from pdf where partno='MRF18030ALSR5' and brandshort='Freescale Semiconductor' limit 1 [ RunTime:0.009930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRF18030ALSR5' OR `brand` LIKE 'Freescale Semiconductor%' ) ) LIMIT 1 [ RunTime:0.038704s ]
SELECT `id` FROM `stock` WHERE `id` <> 51761130 AND `partno` = 'MRF18030ALSR5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%freescale semiconductor%' ) [ RunTime:0.038183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51760828 LIMIT 5 [ RunTime:0.033292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51760828 ORDER BY `minOrder` ASC [ RunTime:0.009522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51760828 ORDER BY `unit` DESC [ RunTime:0.025824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51760828 LIMIT 2 [ RunTime:0.044982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51760828 ORDER BY `minOrder` ASC [ RunTime:0.007791s ]
select * from pdf where partno='MRF160' and brandshort='MACOM Technology Solutions' limit 1 [ RunTime:0.031152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRF160' OR `brand` LIKE 'MACOM Technology Solutions%' ) ) LIMIT 1 [ RunTime:0.014400s ]
SELECT `id` FROM `stock` WHERE `id` <> 51760828 AND `partno` = 'MRF160' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom technology solutions%' ) [ RunTime:0.024094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53529607 LIMIT 5 [ RunTime:0.045245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53529607 ORDER BY `minOrder` ASC [ RunTime:0.012626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53529607 ORDER BY `unit` DESC [ RunTime:0.008857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53529607 LIMIT 2 [ RunTime:0.033976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53529607 ORDER BY `minOrder` ASC [ RunTime:0.018094s ]
select * from pdf where partno='MRF14-CON(M2)' and brandshort='Hirose Electric Co Ltd' limit 1 [ RunTime:0.012139s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRF14-CON(M2)' OR `brand` LIKE 'Hirose Electric Co Ltd%' ) ) LIMIT 1 [ RunTime:0.021915s ]
SELECT `id` FROM `stock` WHERE `id` <> 53529607 AND `partno` = 'MRF14-CON(M2)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirose electric co ltd%' ) [ RunTime:0.023946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610874 [ RunTime:0.021500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53529606 LIMIT 5 [ RunTime:0.015147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53529606 ORDER BY `minOrder` ASC [ RunTime:0.016965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53529606 ORDER BY `unit` DESC [ RunTime:0.020168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53529606 LIMIT 2 [ RunTime:0.015467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53529606 ORDER BY `minOrder` ASC [ RunTime:0.006290s ]
select * from pdf where partno='MRF14-CON(M1)' and brandshort='Hirose Electric Co Ltd' limit 1 [ RunTime:0.011598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRF14-CON(M1)' OR `brand` LIKE 'Hirose Electric Co Ltd%' ) ) LIMIT 1 [ RunTime:0.021801s ]
SELECT `id` FROM `stock` WHERE `id` <> 53529606 AND `partno` = 'MRF14-CON(M1)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirose electric co ltd%' ) [ RunTime:0.050998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610873 [ RunTime:0.045251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53529603 LIMIT 5 [ RunTime:0.027661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53529603 ORDER BY `minOrder` ASC [ RunTime:0.021436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53529603 ORDER BY `unit` DESC [ RunTime:0.019431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53529603 LIMIT 2 [ RunTime:0.013632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53529603 ORDER BY `minOrder` ASC [ RunTime:0.018593s ]
select * from pdf where partno='MRF14-CON(MC)' and brandshort='Hirose Electric Co Ltd' limit 1 [ RunTime:0.027654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRF14-CON(MC)' OR `brand` LIKE 'Hirose Electric Co Ltd%' ) ) LIMIT 1 [ RunTime:0.030089s ]
SELECT `id` FROM `stock` WHERE `id` <> 53529603 AND `partno` = 'MRF14-CON(MC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirose electric co ltd%' ) [ RunTime:0.030105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610861 [ RunTime:0.025407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51759166 LIMIT 5 [ RunTime:0.039095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51759166 ORDER BY `minOrder` ASC [ RunTime:0.005701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51759166 ORDER BY `unit` DESC [ RunTime:0.026308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51759166 LIMIT 2 [ RunTime:0.029780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51759166 ORDER BY `minOrder` ASC [ RunTime:0.014924s ]
select * from pdf where partno='MRF10031' and brandshort='MACOM Technology Solutions' limit 1 [ RunTime:0.013044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRF10031' OR `brand` LIKE 'MACOM Technology Solutions%' ) ) LIMIT 1 [ RunTime:0.013028s ]
SELECT `id` FROM `stock` WHERE `id` <> 51759166 AND `partno` = 'MRF10031' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom technology solutions%' ) [ RunTime:0.034846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53529272 LIMIT 5 [ RunTime:0.007239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53529272 ORDER BY `minOrder` ASC [ RunTime:0.039293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53529272 ORDER BY `unit` DESC [ RunTime:0.011630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53529272 LIMIT 2 [ RunTime:0.011819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53529272 ORDER BY `minOrder` ASC [ RunTime:0.010929s ]
select * from pdf where partno='MRF14-J-088NM-1' and brandshort='Hirose Electric Co Ltd' limit 1 [ RunTime:0.014145s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRF14-J-088NM-1' OR `brand` LIKE 'Hirose Electric Co Ltd%' ) ) LIMIT 1 [ RunTime:0.014169s ]
SELECT `id` FROM `stock` WHERE `id` <> 53529272 AND `partno` = 'MRF14-J-088NM-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirose electric co ltd%' ) [ RunTime:0.013530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610863 [ RunTime:0.017274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51761595 LIMIT 5 [ RunTime:0.012581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51761595 ORDER BY `minOrder` ASC [ RunTime:0.015756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51761595 ORDER BY `unit` DESC [ RunTime:0.018119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51761595 LIMIT 2 [ RunTime:0.012470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51761595 ORDER BY `minOrder` ASC [ RunTime:0.009291s ]
select * from pdf where partno='MRF154' and brandshort='MACOM Technology Solutions' limit 1 [ RunTime:0.021647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRF154' OR `brand` LIKE 'MACOM Technology Solutions%' ) ) LIMIT 1 [ RunTime:0.035088s ]
SELECT `id` FROM `stock` WHERE `id` <> 51761595 AND `partno` = 'MRF154' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom technology solutions%' ) [ RunTime:0.022495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51761590 LIMIT 5 [ RunTime:0.001569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51761590 ORDER BY `minOrder` ASC [ RunTime:0.002772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51761590 ORDER BY `unit` DESC [ RunTime:0.012064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51761590 LIMIT 2 [ RunTime:0.039337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51761590 ORDER BY `minOrder` ASC [ RunTime:0.005494s ]
select * from pdf where partno='MRF151A' and brandshort='MACOM Technology Solutions' limit 1 [ RunTime:0.010804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRF151A' OR `brand` LIKE 'MACOM Technology Solutions%' ) ) LIMIT 1 [ RunTime:0.002202s ]
SELECT `id` FROM `stock` WHERE `id` <> 51761590 AND `partno` = 'MRF151A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom technology solutions%' ) [ RunTime:0.014063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51761593 LIMIT 5 [ RunTime:0.003203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51761593 ORDER BY `minOrder` ASC [ RunTime:0.012927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51761593 ORDER BY `unit` DESC [ RunTime:0.005856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51761593 LIMIT 2 [ RunTime:0.019759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51761593 ORDER BY `minOrder` ASC [ RunTime:0.001008s ]
select * from pdf where partno='MRF141G' and brandshort='MACOM Technology Solutions' limit 1 [ RunTime:0.010330s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRF141G' OR `brand` LIKE 'MACOM Technology Solutions%' ) ) LIMIT 1 [ RunTime:0.007463s ]
SELECT `id` FROM `stock` WHERE `id` <> 51761593 AND `partno` = 'MRF141G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%macom technology solutions%' ) [ RunTime:0.023440s ]
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 'MRF1%' OR `brand` LIKE 'MRF1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011637s ]
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 'MRF1%' OR `brand` LIKE 'MRF1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012569s ]
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 'MRF1%' OR `brand` LIKE 'MRF1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002786s ]
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 'MRF1%' OR `brand` LIKE 'MRF1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003902s ]
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 'MRF1%' OR `brand` LIKE 'MRF1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003267s ]
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 'MRF1%' OR `brand` LIKE 'MRF1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031602s ]
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 'MRF1%' OR `brand` LIKE 'MRF1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010326s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MRF1%' OR `brand` LIKE 'MRF1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.011926s ]