SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001374s ]
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 '20326%' OR `brand` LIKE '20326%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025275s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609724 LIMIT 5 [ RunTime:0.026404s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609724 ORDER BY `minOrder` ASC [ RunTime:0.060250s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609724 ORDER BY `unit` DESC [ RunTime:0.015439s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609724 LIMIT 2 [ RunTime:0.022598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609724 ORDER BY `minOrder` ASC [ RunTime:0.018376s ]
select * from pdf where partno='2032630136' and brandshort='Molex' limit 1 [ RunTime:0.033010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481710 LIMIT 5 [ RunTime:0.056538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481710 ORDER BY `minOrder` ASC [ RunTime:0.036916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481710 ORDER BY `unit` DESC [ RunTime:0.067532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481710 LIMIT 2 [ RunTime:0.022675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481710 ORDER BY `minOrder` ASC [ RunTime:0.016108s ]
select * from pdf where partno='2032630001' and brandshort='Molex' limit 1 [ RunTime:0.022687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481826 LIMIT 5 [ RunTime:0.027669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481826 ORDER BY `minOrder` ASC [ RunTime:0.011477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481826 ORDER BY `unit` DESC [ RunTime:0.049288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481826 LIMIT 2 [ RunTime:0.037051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481826 ORDER BY `minOrder` ASC [ RunTime:0.025397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481550 LIMIT 5 [ RunTime:0.012892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481550 ORDER BY `minOrder` ASC [ RunTime:0.055695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481550 ORDER BY `unit` DESC [ RunTime:0.055235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481550 LIMIT 2 [ RunTime:0.043528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481550 ORDER BY `minOrder` ASC [ RunTime:0.007121s ]
select * from pdf where partno='2032630034' and brandshort='Molex' limit 1 [ RunTime:0.049339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481711 LIMIT 5 [ RunTime:0.117402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481711 ORDER BY `minOrder` ASC [ RunTime:0.042256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481711 ORDER BY `unit` DESC [ RunTime:0.036674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481711 LIMIT 2 [ RunTime:0.054073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481711 ORDER BY `minOrder` ASC [ RunTime:0.079448s ]
select * from pdf where partno='2032636185' and brandshort='Molex' limit 1 [ RunTime:0.005753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609723 LIMIT 5 [ RunTime:0.053022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609723 ORDER BY `minOrder` ASC [ RunTime:0.096236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609723 ORDER BY `unit` DESC [ RunTime:0.054400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609723 LIMIT 2 [ RunTime:0.034137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609723 ORDER BY `minOrder` ASC [ RunTime:0.044757s ]
select * from pdf where partno='2032630006' and brandshort='Molex' limit 1 [ RunTime:0.034021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481712 LIMIT 5 [ RunTime:0.076441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481712 ORDER BY `minOrder` ASC [ RunTime:0.027500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481712 ORDER BY `unit` DESC [ RunTime:0.096476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481712 LIMIT 2 [ RunTime:0.083455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481712 ORDER BY `minOrder` ASC [ RunTime:0.039255s ]
select * from pdf where partno='2032634385' and brandshort='Molex' limit 1 [ RunTime:0.058850s ]
select foldpath,foldpath2,filename from pdf_file where id=1771321 limit 1 [ RunTime:0.101915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609720 LIMIT 5 [ RunTime:0.065872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609720 ORDER BY `minOrder` ASC [ RunTime:0.078066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609720 ORDER BY `unit` DESC [ RunTime:0.038972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609720 LIMIT 2 [ RunTime:0.041727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609720 ORDER BY `minOrder` ASC [ RunTime:0.024878s ]
select * from pdf where partno='2032631334' and brandshort='Molex' limit 1 [ RunTime:0.027255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481552 LIMIT 5 [ RunTime:0.043674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481552 ORDER BY `minOrder` ASC [ RunTime:0.050117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481552 ORDER BY `unit` DESC [ RunTime:0.057154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481552 LIMIT 2 [ RunTime:0.039797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481552 ORDER BY `minOrder` ASC [ RunTime:0.000941s ]
select * from pdf where partno='2032631234' and brandshort='Molex' limit 1 [ RunTime:0.055117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14707849 LIMIT 5 [ RunTime:0.031507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14707849 ORDER BY `minOrder` ASC [ RunTime:0.078172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14707849 ORDER BY `unit` DESC [ RunTime:0.080829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14707849 LIMIT 2 [ RunTime:0.069079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14707849 ORDER BY `minOrder` ASC [ RunTime:0.039277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14397120 LIMIT 5 [ RunTime:0.090817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14397120 ORDER BY `minOrder` ASC [ RunTime:0.038264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14397120 ORDER BY `unit` DESC [ RunTime:0.066723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14397120 LIMIT 2 [ RunTime:0.103328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14397120 ORDER BY `minOrder` ASC [ RunTime:0.010144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13525603 LIMIT 5 [ RunTime:0.010162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13525603 ORDER BY `minOrder` ASC [ RunTime:0.013926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13525603 ORDER BY `unit` DESC [ RunTime:0.029629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13525603 LIMIT 2 [ RunTime:0.059706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13525603 ORDER BY `minOrder` ASC [ RunTime:0.016070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612280 LIMIT 5 [ RunTime:0.053554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612280 ORDER BY `minOrder` ASC [ RunTime:0.043506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612280 ORDER BY `unit` DESC [ RunTime:0.021075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612280 LIMIT 2 [ RunTime:0.086617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612280 ORDER BY `minOrder` ASC [ RunTime:0.047500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612276 LIMIT 5 [ RunTime:0.103669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612276 ORDER BY `minOrder` ASC [ RunTime:0.039740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612276 ORDER BY `unit` DESC [ RunTime:0.008320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612276 LIMIT 2 [ RunTime:0.008613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612276 ORDER BY `minOrder` ASC [ RunTime:0.068062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612271 LIMIT 5 [ RunTime:0.059462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612271 ORDER BY `minOrder` ASC [ RunTime:0.047731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612271 ORDER BY `unit` DESC [ RunTime:0.018556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612271 LIMIT 2 [ RunTime:0.057602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612271 ORDER BY `minOrder` ASC [ RunTime:0.019034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612268 LIMIT 5 [ RunTime:0.078668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612268 ORDER BY `minOrder` ASC [ RunTime:0.033799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612268 ORDER BY `unit` DESC [ RunTime:0.019273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612268 LIMIT 2 [ RunTime:0.071457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612268 ORDER BY `minOrder` ASC [ RunTime:0.035973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612266 LIMIT 5 [ RunTime:0.013778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612266 ORDER BY `minOrder` ASC [ RunTime:0.047566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612266 ORDER BY `unit` DESC [ RunTime:0.033535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612266 LIMIT 2 [ RunTime:0.095910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612266 ORDER BY `minOrder` ASC [ RunTime:0.097890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612265 LIMIT 5 [ RunTime:0.136284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612265 ORDER BY `minOrder` ASC [ RunTime:0.082150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612265 ORDER BY `unit` DESC [ RunTime:0.043258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612265 LIMIT 2 [ RunTime:0.033917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612265 ORDER BY `minOrder` ASC [ RunTime:0.005501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612264 LIMIT 5 [ RunTime:0.079298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612264 ORDER BY `minOrder` ASC [ RunTime:0.045732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612264 ORDER BY `unit` DESC [ RunTime:0.020230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612264 LIMIT 2 [ RunTime:0.010653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612264 ORDER BY `minOrder` ASC [ RunTime:0.007782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612261 LIMIT 5 [ RunTime:0.023955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612261 ORDER BY `minOrder` ASC [ RunTime:0.022986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612261 ORDER BY `unit` DESC [ RunTime:0.034636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612261 LIMIT 2 [ RunTime:0.022638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612261 ORDER BY `minOrder` ASC [ RunTime:0.005326s ]
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 '20326%' OR `brand` LIKE '20326%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280005 LIMIT 5 [ RunTime:0.006050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280005 ORDER BY `minOrder` ASC [ RunTime:0.024019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280005 ORDER BY `unit` DESC [ RunTime:0.047377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280005 LIMIT 2 [ RunTime:0.007764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280005 ORDER BY `minOrder` ASC [ RunTime:0.012582s ]
select * from pdf where partno='203263-0001' and brandshort='molex' limit 1 [ RunTime:0.059493s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002584s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-0001' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.057180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280985 LIMIT 5 [ RunTime:0.010277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280985 ORDER BY `minOrder` ASC [ RunTime:0.044681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280985 ORDER BY `unit` DESC [ RunTime:0.031367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280985 LIMIT 2 [ RunTime:0.026948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280985 ORDER BY `minOrder` ASC [ RunTime:0.002382s ]
select * from pdf where partno='203263-0026' and brandshort='molex' limit 1 [ RunTime:0.017590s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-0026' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.037556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280171 LIMIT 5 [ RunTime:0.032116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280171 ORDER BY `minOrder` ASC [ RunTime:0.014037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280171 ORDER BY `unit` DESC [ RunTime:0.031451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280171 LIMIT 2 [ RunTime:0.022039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280171 ORDER BY `minOrder` ASC [ RunTime:0.006655s ]
select * from pdf where partno='203263-1234' and brandshort='molex' limit 1 [ RunTime:0.020213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-1234' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.030150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280137 LIMIT 5 [ RunTime:0.017671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280137 ORDER BY `minOrder` ASC [ RunTime:0.018599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280137 ORDER BY `unit` DESC [ RunTime:0.006685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280137 LIMIT 2 [ RunTime:0.010275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280137 ORDER BY `minOrder` ASC [ RunTime:0.002345s ]
select * from pdf where partno='203263-1434' and brandshort='molex' limit 1 [ RunTime:0.007039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-1434' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.013434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280232 LIMIT 5 [ RunTime:0.015581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280232 ORDER BY `minOrder` ASC [ RunTime:0.017556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280232 ORDER BY `unit` DESC [ RunTime:0.006025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280232 LIMIT 2 [ RunTime:0.009033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280232 ORDER BY `minOrder` ASC [ RunTime:0.005927s ]
select * from pdf where partno='203263-0116' and brandshort='molex' limit 1 [ RunTime:0.005427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-0116' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.018146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280100 LIMIT 5 [ RunTime:0.018281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280100 ORDER BY `minOrder` ASC [ RunTime:0.017850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280100 ORDER BY `unit` DESC [ RunTime:0.015444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280100 LIMIT 2 [ RunTime:0.004673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280100 ORDER BY `minOrder` ASC [ RunTime:0.004076s ]
select * from pdf where partno='203263-0006' and brandshort='molex' limit 1 [ RunTime:0.023587s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-0006' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.025574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280986 LIMIT 5 [ RunTime:0.000642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280986 ORDER BY `minOrder` ASC [ RunTime:0.018276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280986 ORDER BY `unit` DESC [ RunTime:0.047560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280986 LIMIT 2 [ RunTime:0.006531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280986 ORDER BY `minOrder` ASC [ RunTime:0.002734s ]
select * from pdf where partno='203263-0126' and brandshort='molex' limit 1 [ RunTime:0.002815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-0126' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.038255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280138 LIMIT 5 [ RunTime:0.025085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280138 ORDER BY `minOrder` ASC [ RunTime:0.032740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280138 ORDER BY `unit` DESC [ RunTime:0.016672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280138 LIMIT 2 [ RunTime:0.003881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280138 ORDER BY `minOrder` ASC [ RunTime:0.016183s ]
select * from pdf where partno='203263-6785' and brandshort='molex' limit 1 [ RunTime:0.001879s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-6785' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.028151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280514 LIMIT 5 [ RunTime:0.012214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280514 ORDER BY `minOrder` ASC [ RunTime:0.004894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280514 ORDER BY `unit` DESC [ RunTime:0.005763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280514 LIMIT 2 [ RunTime:0.011184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280514 ORDER BY `minOrder` ASC [ RunTime:0.002574s ]
select * from pdf where partno='203263-4285' and brandshort='molex' limit 1 [ RunTime:0.000867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-4285' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.020670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281199 LIMIT 5 [ RunTime:0.004929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281199 ORDER BY `minOrder` ASC [ RunTime:0.040676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281199 ORDER BY `unit` DESC [ RunTime:0.016167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281199 LIMIT 2 [ RunTime:0.029146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281199 ORDER BY `minOrder` ASC [ RunTime:0.022761s ]
select * from pdf where partno='203263-0011' and brandshort='molex' limit 1 [ RunTime:0.029521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-0011' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.030554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280464 LIMIT 5 [ RunTime:0.052684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280464 ORDER BY `minOrder` ASC [ RunTime:0.024729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280464 ORDER BY `unit` DESC [ RunTime:0.068926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280464 LIMIT 2 [ RunTime:0.050161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280464 ORDER BY `minOrder` ASC [ RunTime:0.003727s ]
select * from pdf where partno='203263-0136' and brandshort='molex' limit 1 [ RunTime:0.028059s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-0136' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.062666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281202 LIMIT 5 [ RunTime:0.032400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281202 ORDER BY `minOrder` ASC [ RunTime:0.004364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281202 ORDER BY `unit` DESC [ RunTime:0.016613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281202 LIMIT 2 [ RunTime:0.033246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281202 ORDER BY `minOrder` ASC [ RunTime:0.005735s ]
select * from pdf where partno='203263-0246' and brandshort='molex' limit 1 [ RunTime:0.018497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-0246' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.027485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281203 LIMIT 5 [ RunTime:0.039787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281203 ORDER BY `minOrder` ASC [ RunTime:0.026436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281203 ORDER BY `unit` DESC [ RunTime:0.025507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281203 LIMIT 2 [ RunTime:0.008706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281203 ORDER BY `minOrder` ASC [ RunTime:0.004011s ]
select * from pdf where partno='203263-8485' and brandshort='molex' limit 1 [ RunTime:0.022877s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-8485' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.039619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280720 LIMIT 5 [ RunTime:0.007725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280720 ORDER BY `minOrder` ASC [ RunTime:0.051456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280720 ORDER BY `unit` DESC [ RunTime:0.026472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280720 LIMIT 2 [ RunTime:0.020883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280720 ORDER BY `minOrder` ASC [ RunTime:0.004347s ]
select * from pdf where partno='203263-5380' and brandshort='molex' limit 1 [ RunTime:0.004677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-5380' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.018899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280721 LIMIT 5 [ RunTime:0.025134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280721 ORDER BY `minOrder` ASC [ RunTime:0.006868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280721 ORDER BY `unit` DESC [ RunTime:0.010391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280721 LIMIT 2 [ RunTime:0.002653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280721 ORDER BY `minOrder` ASC [ RunTime:0.006559s ]
select * from pdf where partno='203263-5480' and brandshort='molex' limit 1 [ RunTime:0.006266s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-5480' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.025048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280719 LIMIT 5 [ RunTime:0.007639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280719 ORDER BY `minOrder` ASC [ RunTime:0.005201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280719 ORDER BY `unit` DESC [ RunTime:0.004094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280719 LIMIT 2 [ RunTime:0.002781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280719 ORDER BY `minOrder` ASC [ RunTime:0.003684s ]
select * from pdf where partno='203263-5280' and brandshort='molex' limit 1 [ RunTime:0.001100s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-5280' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.013681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280718 LIMIT 5 [ RunTime:0.006771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280718 ORDER BY `minOrder` ASC [ RunTime:0.007470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280718 ORDER BY `unit` DESC [ RunTime:0.002369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280718 LIMIT 2 [ RunTime:0.005746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280718 ORDER BY `minOrder` ASC [ RunTime:0.017725s ]
select * from pdf where partno='203263-5180' and brandshort='molex' limit 1 [ RunTime:0.003708s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-5180' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.014189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280722 LIMIT 5 [ RunTime:0.007084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280722 ORDER BY `minOrder` ASC [ RunTime:0.003130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280722 ORDER BY `unit` DESC [ RunTime:0.010798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280722 LIMIT 2 [ RunTime:0.006808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280722 ORDER BY `minOrder` ASC [ RunTime:0.002061s ]
select * from pdf where partno='203263-7585' and brandshort='molex' limit 1 [ RunTime:0.001063s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-7585' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.017531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32280934 LIMIT 5 [ RunTime:0.011270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280934 ORDER BY `minOrder` ASC [ RunTime:0.007068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32280934 ORDER BY `unit` DESC [ RunTime:0.004564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32280934 LIMIT 2 [ RunTime:0.002963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32280934 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='203263-8085' and brandshort='molex' limit 1 [ RunTime:0.001683s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-8085' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.011059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281201 LIMIT 5 [ RunTime:0.005359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281201 ORDER BY `minOrder` ASC [ RunTime:0.000738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281201 ORDER BY `unit` DESC [ RunTime:0.005187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281201 LIMIT 2 [ RunTime:0.010651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281201 ORDER BY `minOrder` ASC [ RunTime:0.001925s ]
select * from pdf where partno='203263-0106' and brandshort='molex' limit 1 [ RunTime:0.004536s ]
select foldpath,foldpath2,filename from pdf_file where id=1569400 limit 1 [ RunTime:0.002465s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-0106' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.017671s ]
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 '20326%' OR `brand` LIKE '20326%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59948045 LIMIT 5 [ RunTime:0.004540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59948045 ORDER BY `minOrder` ASC [ RunTime:0.057830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59948045 ORDER BY `unit` DESC [ RunTime:0.020239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59948045 LIMIT 2 [ RunTime:0.033631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59948045 ORDER BY `minOrder` ASC [ RunTime:0.003668s ]
select * from pdf where partno='203263-4785' and brandshort='Molex' limit 1 [ RunTime:0.005394s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-4785' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.030369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60381938 LIMIT 5 [ RunTime:0.015708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381938 ORDER BY `minOrder` ASC [ RunTime:0.012392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60381938 ORDER BY `unit` DESC [ RunTime:0.025067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60381938 LIMIT 2 [ RunTime:0.008571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381938 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
select * from pdf where partno='2032630136' and brandshort='Molex' limit 1 [ RunTime:0.002201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032630136' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.035804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60382071 LIMIT 5 [ RunTime:0.039378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382071 ORDER BY `minOrder` ASC [ RunTime:0.034741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60382071 ORDER BY `unit` DESC [ RunTime:0.057872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60382071 LIMIT 2 [ RunTime:0.039466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382071 ORDER BY `minOrder` ASC [ RunTime:0.004175s ]
select * from pdf where partno='2032630031' and brandshort='Molex' limit 1 [ RunTime:0.021123s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032630031' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.033291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60382156 LIMIT 5 [ RunTime:0.052272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382156 ORDER BY `minOrder` ASC [ RunTime:0.023179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60382156 ORDER BY `unit` DESC [ RunTime:0.006898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60382156 LIMIT 2 [ RunTime:0.002541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382156 ORDER BY `minOrder` ASC [ RunTime:0.002106s ]
select * from pdf where partno='2032635180' and brandshort='Molex' limit 1 [ RunTime:0.005156s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032635180' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60381936 LIMIT 5 [ RunTime:0.002879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381936 ORDER BY `minOrder` ASC [ RunTime:0.057168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60381936 ORDER BY `unit` DESC [ RunTime:0.012661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60381936 LIMIT 2 [ RunTime:0.003292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381936 ORDER BY `minOrder` ASC [ RunTime:0.000539s ]
select * from pdf where partno='2032630001' and brandshort='Molex' limit 1 [ RunTime:0.002247s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032630001' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.019875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60381934 LIMIT 5 [ RunTime:0.023118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381934 ORDER BY `minOrder` ASC [ RunTime:0.037227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60381934 ORDER BY `unit` DESC [ RunTime:0.003877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60381934 LIMIT 2 [ RunTime:0.019822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381934 ORDER BY `minOrder` ASC [ RunTime:0.018417s ]
select * from pdf where partno='2032630116' and brandshort='Molex' limit 1 [ RunTime:0.001044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032630116' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.016726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60381739 LIMIT 5 [ RunTime:0.006464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381739 ORDER BY `minOrder` ASC [ RunTime:0.007448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60381739 ORDER BY `unit` DESC [ RunTime:0.008308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60381739 LIMIT 2 [ RunTime:0.012966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381739 ORDER BY `minOrder` ASC [ RunTime:0.016789s ]
select * from pdf where partno='2032631234' and brandshort='Molex' limit 1 [ RunTime:0.001505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032631234' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.018874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60381932 LIMIT 5 [ RunTime:0.002239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381932 ORDER BY `minOrder` ASC [ RunTime:0.003334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60381932 ORDER BY `unit` DESC [ RunTime:0.000583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60381932 LIMIT 2 [ RunTime:0.001427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381932 ORDER BY `minOrder` ASC [ RunTime:0.000815s ]
select * from pdf where partno='2032630034' and brandshort='Molex' limit 1 [ RunTime:0.000536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032630034' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.008824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60381810 LIMIT 5 [ RunTime:0.001114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381810 ORDER BY `minOrder` ASC [ RunTime:0.009735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60381810 ORDER BY `unit` DESC [ RunTime:0.007566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60381810 LIMIT 2 [ RunTime:0.002712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381810 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='2032630006' and brandshort='Molex' limit 1 [ RunTime:0.000710s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032630006' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.009096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60381939 LIMIT 5 [ RunTime:0.002082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381939 ORDER BY `minOrder` ASC [ RunTime:0.006380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60381939 ORDER BY `unit` DESC [ RunTime:0.005687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60381939 LIMIT 2 [ RunTime:0.013658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381939 ORDER BY `minOrder` ASC [ RunTime:0.001212s ]
select * from pdf where partno='2032634285' and brandshort='Molex' limit 1 [ RunTime:0.015766s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032634285' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60381943 LIMIT 5 [ RunTime:0.005730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381943 ORDER BY `minOrder` ASC [ RunTime:0.000608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60381943 ORDER BY `unit` DESC [ RunTime:0.012579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60381943 LIMIT 2 [ RunTime:0.005338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60381943 ORDER BY `minOrder` ASC [ RunTime:0.005599s ]
select * from pdf where partno='2032634385' and brandshort='Molex' limit 1 [ RunTime:0.000691s ]
select foldpath,foldpath2,filename from pdf_file where id=1771321 limit 1 [ RunTime:0.000391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032634385' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.007399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59947987 LIMIT 5 [ RunTime:0.001576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59947987 ORDER BY `minOrder` ASC [ RunTime:0.002827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59947987 ORDER BY `unit` DESC [ RunTime:0.000901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59947987 LIMIT 2 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59947987 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
select * from pdf where partno='203263-4185' and brandshort='Molex' limit 1 [ RunTime:0.003485s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203263-4185' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.005216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60382165 LIMIT 5 [ RunTime:0.000428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382165 ORDER BY `minOrder` ASC [ RunTime:0.000370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60382165 ORDER BY `unit` DESC [ RunTime:0.000326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60382165 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382165 ORDER BY `minOrder` ASC [ RunTime:0.003220s ]
select * from pdf where partno='2032635480' and brandshort='Molex' limit 1 [ RunTime:0.000537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032635480' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.000335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60382154 LIMIT 5 [ RunTime:0.003250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382154 ORDER BY `minOrder` ASC [ RunTime:0.001310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60382154 ORDER BY `unit` DESC [ RunTime:0.006869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60382154 LIMIT 2 [ RunTime:0.000724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382154 ORDER BY `minOrder` ASC [ RunTime:0.000470s ]
select * from pdf where partno='2032630036' and brandshort='Molex' limit 1 [ RunTime:0.000905s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032630036' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60382159 LIMIT 5 [ RunTime:0.006156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382159 ORDER BY `minOrder` ASC [ RunTime:0.020922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60382159 ORDER BY `unit` DESC [ RunTime:0.012004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60382159 LIMIT 2 [ RunTime:0.001820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382159 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
select * from pdf where partno='2032635280' and brandshort='Molex' limit 1 [ RunTime:0.002280s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032635280' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.012798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60382155 LIMIT 5 [ RunTime:0.006332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382155 ORDER BY `minOrder` ASC [ RunTime:0.000730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60382155 ORDER BY `unit` DESC [ RunTime:0.003212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60382155 LIMIT 2 [ RunTime:0.006776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382155 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
select * from pdf where partno='2032638085' and brandshort='Molex' limit 1 [ RunTime:0.012709s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032638085' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.012203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60382163 LIMIT 5 [ RunTime:0.001357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382163 ORDER BY `minOrder` ASC [ RunTime:0.002422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60382163 ORDER BY `unit` DESC [ RunTime:0.001423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60382163 LIMIT 2 [ RunTime:0.000966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382163 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
select * from pdf where partno='2032638485' and brandshort='Molex' limit 1 [ RunTime:0.001100s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032638485' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60382162 LIMIT 5 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382162 ORDER BY `minOrder` ASC [ RunTime:0.000806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60382162 ORDER BY `unit` DESC [ RunTime:0.000890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60382162 LIMIT 2 [ RunTime:0.000654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382162 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
select * from pdf where partno='2032635380' and brandshort='Molex' limit 1 [ RunTime:0.003244s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032635380' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.011830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60382166 LIMIT 5 [ RunTime:0.000401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382166 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60382166 ORDER BY `unit` DESC [ RunTime:0.000433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60382166 LIMIT 2 [ RunTime:0.000371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382166 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
select * from pdf where partno='2032637785' and brandshort='Molex' limit 1 [ RunTime:0.000483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032637785' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.000402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60382171 LIMIT 5 [ RunTime:0.000371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382171 ORDER BY `minOrder` ASC [ RunTime:0.000389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60382171 ORDER BY `unit` DESC [ RunTime:0.000379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60382171 LIMIT 2 [ RunTime:0.000410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60382171 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
select * from pdf where partno='2032637885' and brandshort='Molex' limit 1 [ RunTime:0.005374s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032637885' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.000420s ]
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 '20326%' OR `brand` LIKE '20326%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001270s ]
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 '20326%' OR `brand` LIKE '20326%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001566s ]
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 '20326%' OR `brand` LIKE '20326%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002746s ]
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 '20326%' OR `brand` LIKE '20326%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007720s ]
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 '20326%' OR `brand` LIKE '20326%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003120s ]
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 '20326%' OR `brand` LIKE '20326%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001883s ]
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 '20326%' OR `brand` LIKE '20326%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001379s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '20326%' OR `brand` LIKE '20326%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001758s ]