SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001336s ]
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 '1001932%' OR `brand` LIKE '1001932%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025492s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13259956 LIMIT 5 [ RunTime:0.025394s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.019070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13259956 ORDER BY `minOrder` ASC [ RunTime:0.011174s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13259956 ORDER BY `unit` DESC [ RunTime:0.013430s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13259956 LIMIT 2 [ RunTime:0.047197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13259956 ORDER BY `minOrder` ASC [ RunTime:0.050814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13259970 LIMIT 5 [ RunTime:0.013855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13259970 ORDER BY `minOrder` ASC [ RunTime:0.030104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13259970 ORDER BY `unit` DESC [ RunTime:0.010534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13259970 LIMIT 2 [ RunTime:0.036834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13259970 ORDER BY `minOrder` ASC [ RunTime:0.043407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13257931 LIMIT 5 [ RunTime:0.015437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13257931 ORDER BY `minOrder` ASC [ RunTime:0.016513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13257931 ORDER BY `unit` DESC [ RunTime:0.044781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13257931 LIMIT 2 [ RunTime:0.021575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13257931 ORDER BY `minOrder` ASC [ RunTime:0.024930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11985962 LIMIT 5 [ RunTime:0.085637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985962 ORDER BY `minOrder` ASC [ RunTime:0.023049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11985962 ORDER BY `unit` DESC [ RunTime:0.075668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11985962 LIMIT 2 [ RunTime:0.031211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985962 ORDER BY `minOrder` ASC [ RunTime:0.035218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13257218 LIMIT 5 [ RunTime:0.023242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13257218 ORDER BY `minOrder` ASC [ RunTime:0.057711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13257218 ORDER BY `unit` DESC [ RunTime:0.051508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13257218 LIMIT 2 [ RunTime:0.037201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13257218 ORDER BY `minOrder` ASC [ RunTime:0.017194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13258537 LIMIT 5 [ RunTime:0.015342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258537 ORDER BY `minOrder` ASC [ RunTime:0.029277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13258537 ORDER BY `unit` DESC [ RunTime:0.014566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13258537 LIMIT 2 [ RunTime:0.017800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258537 ORDER BY `minOrder` ASC [ RunTime:0.003854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13258518 LIMIT 5 [ RunTime:0.010467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258518 ORDER BY `minOrder` ASC [ RunTime:0.002647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13258518 ORDER BY `unit` DESC [ RunTime:0.005557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13258518 LIMIT 2 [ RunTime:0.005477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258518 ORDER BY `minOrder` ASC [ RunTime:0.011612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13258507 LIMIT 5 [ RunTime:0.023932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258507 ORDER BY `minOrder` ASC [ RunTime:0.007124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13258507 ORDER BY `unit` DESC [ RunTime:0.004961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13258507 LIMIT 2 [ RunTime:0.018183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258507 ORDER BY `minOrder` ASC [ RunTime:0.001389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13258506 LIMIT 5 [ RunTime:0.006838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258506 ORDER BY `minOrder` ASC [ RunTime:0.002811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13258506 ORDER BY `unit` DESC [ RunTime:0.000790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13258506 LIMIT 2 [ RunTime:0.008317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258506 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13258494 LIMIT 5 [ RunTime:0.011550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258494 ORDER BY `minOrder` ASC [ RunTime:0.001939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13258494 ORDER BY `unit` DESC [ RunTime:0.000622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13258494 LIMIT 2 [ RunTime:0.002430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258494 ORDER BY `minOrder` ASC [ RunTime:0.002135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987486 LIMIT 5 [ RunTime:0.003854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987486 ORDER BY `minOrder` ASC [ RunTime:0.000875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987486 ORDER BY `unit` DESC [ RunTime:0.008981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987486 LIMIT 2 [ RunTime:0.001472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987486 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987354 LIMIT 5 [ RunTime:0.000682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987354 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987354 ORDER BY `unit` DESC [ RunTime:0.000425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987354 LIMIT 2 [ RunTime:0.002445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987354 ORDER BY `minOrder` ASC [ RunTime:0.002027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987326 LIMIT 5 [ RunTime:0.000311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987326 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987326 ORDER BY `unit` DESC [ RunTime:0.000303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987326 LIMIT 2 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987326 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987312 LIMIT 5 [ RunTime:0.000539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987312 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987312 ORDER BY `unit` DESC [ RunTime:0.006358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987312 LIMIT 2 [ RunTime:0.018372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987312 ORDER BY `minOrder` ASC [ RunTime:0.001988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987295 LIMIT 5 [ RunTime:0.004223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987295 ORDER BY `minOrder` ASC [ RunTime:0.005056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987295 ORDER BY `unit` DESC [ RunTime:0.000860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987295 LIMIT 2 [ RunTime:0.000472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987295 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
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 '1001932%' OR `brand` LIKE '1001932%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114161 LIMIT 5 [ RunTime:0.004172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114161 ORDER BY `minOrder` ASC [ RunTime:0.017157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51114161 ORDER BY `unit` DESC [ RunTime:0.000605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51114161 LIMIT 2 [ RunTime:0.000442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114161 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
select * from pdf where partno='1001932pt-ac10l0100' and brandshort='kyocera avx' limit 1 [ RunTime:0.000974s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932pt-ac10l0100' OR `brand` LIKE 'kyocera avx%' ) ) LIMIT 1 [ RunTime:0.005860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32303998 LIMIT 5 [ RunTime:0.011792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32303998 ORDER BY `minOrder` ASC [ RunTime:0.020467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32303998 ORDER BY `unit` DESC [ RunTime:0.001784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32303998 LIMIT 2 [ RunTime:0.005828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32303998 ORDER BY `minOrder` ASC [ RunTime:0.002154s ]
select * from pdf where partno='1001932pt-ac10l0100' and brandshort='kyocera avx' limit 1 [ RunTime:0.000461s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932pt-ac10l0100' OR `brand` LIKE 'kyocera avx%' ) ) LIMIT 1 [ RunTime:0.000379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32295960 LIMIT 5 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32295960 ORDER BY `minOrder` ASC [ RunTime:0.008388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32295960 ORDER BY `unit` DESC [ RunTime:0.006482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32295960 LIMIT 2 [ RunTime:0.004369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32295960 ORDER BY `minOrder` ASC [ RunTime:0.020844s ]
select * from pdf where partno='1001932pt-ac10l0100' and brandshort='kyocera avx' limit 1 [ RunTime:0.002804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932pt-ac10l0100' OR `brand` LIKE 'kyocera avx%' ) ) LIMIT 1 [ RunTime:0.002755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114236 LIMIT 5 [ RunTime:0.003594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114236 ORDER BY `minOrder` ASC [ RunTime:0.012156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51114236 ORDER BY `unit` DESC [ RunTime:0.015482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51114236 LIMIT 2 [ RunTime:0.024892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114236 ORDER BY `minOrder` ASC [ RunTime:0.000569s ]
select * from pdf where partno='1001932ft-aa10l0200' and brandshort='kyocera avx' limit 1 [ RunTime:0.017514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932ft-aa10l0200' OR `brand` LIKE 'kyocera avx%' ) ) LIMIT 1 [ RunTime:0.024876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304190 LIMIT 5 [ RunTime:0.008865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304190 ORDER BY `minOrder` ASC [ RunTime:0.010427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304190 ORDER BY `unit` DESC [ RunTime:0.024667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304190 LIMIT 2 [ RunTime:0.004237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304190 ORDER BY `minOrder` ASC [ RunTime:0.019023s ]
select * from pdf where partno='1001932ft-aa10l0200' and brandshort='kyocera avx' limit 1 [ RunTime:0.003013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932ft-aa10l0200' OR `brand` LIKE 'kyocera avx%' ) ) LIMIT 1 [ RunTime:0.011872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296064 LIMIT 5 [ RunTime:0.014527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296064 ORDER BY `minOrder` ASC [ RunTime:0.019608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296064 ORDER BY `unit` DESC [ RunTime:0.024546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296064 LIMIT 2 [ RunTime:0.006413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296064 ORDER BY `minOrder` ASC [ RunTime:0.018542s ]
select * from pdf where partno='1001932ft-aa10l0200' and brandshort='kyocera avx' limit 1 [ RunTime:0.000500s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932ft-aa10l0200' OR `brand` LIKE 'kyocera avx%' ) ) LIMIT 1 [ RunTime:0.015311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304343 LIMIT 5 [ RunTime:0.010407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304343 ORDER BY `minOrder` ASC [ RunTime:0.024938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304343 ORDER BY `unit` DESC [ RunTime:0.008691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304343 LIMIT 2 [ RunTime:0.004071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304343 ORDER BY `minOrder` ASC [ RunTime:0.012226s ]
select * from pdf where partno='1001932pt-aa10l0100' and brandshort='kyocera avx' limit 1 [ RunTime:0.007778s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932pt-aa10l0100' OR `brand` LIKE 'kyocera avx%' ) ) LIMIT 1 [ RunTime:0.001098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296207 LIMIT 5 [ RunTime:0.003836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296207 ORDER BY `minOrder` ASC [ RunTime:0.034283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296207 ORDER BY `unit` DESC [ RunTime:0.053019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296207 LIMIT 2 [ RunTime:0.026252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296207 ORDER BY `minOrder` ASC [ RunTime:0.020971s ]
select * from pdf where partno='1001932pt-aa10l0100' and brandshort='kyocera avx' limit 1 [ RunTime:0.021758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932pt-aa10l0100' OR `brand` LIKE 'kyocera avx%' ) ) LIMIT 1 [ RunTime:0.019380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114399 LIMIT 5 [ RunTime:0.015386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114399 ORDER BY `minOrder` ASC [ RunTime:0.067389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51114399 ORDER BY `unit` DESC [ RunTime:0.044564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51114399 LIMIT 2 [ RunTime:0.053828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114399 ORDER BY `minOrder` ASC [ RunTime:0.044357s ]
select * from pdf where partno='1001932pt-aa10l0100' and brandshort='kyocera avx' limit 1 [ RunTime:0.040981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932pt-aa10l0100' OR `brand` LIKE 'kyocera avx%' ) ) LIMIT 1 [ RunTime:0.041206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114314 LIMIT 5 [ RunTime:0.106969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114314 ORDER BY `minOrder` ASC [ RunTime:0.081893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51114314 ORDER BY `unit` DESC [ RunTime:0.042675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51114314 LIMIT 2 [ RunTime:0.082954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114314 ORDER BY `minOrder` ASC [ RunTime:0.029321s ]
select * from pdf where partno='1001932pt-ac10l0200' and brandshort='kyocera avx' limit 1 [ RunTime:0.044054s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932pt-ac10l0200' OR `brand` LIKE 'kyocera avx%' ) ) LIMIT 1 [ RunTime:0.031985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304170 LIMIT 5 [ RunTime:0.027059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304170 ORDER BY `minOrder` ASC [ RunTime:0.058764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304170 ORDER BY `unit` DESC [ RunTime:0.024382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304170 LIMIT 2 [ RunTime:0.063544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304170 ORDER BY `minOrder` ASC [ RunTime:0.049144s ]
select * from pdf where partno='1001932pt-ac10l0200' and brandshort='kyocera avx' limit 1 [ RunTime:0.025662s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932pt-ac10l0200' OR `brand` LIKE 'kyocera avx%' ) ) LIMIT 1 [ RunTime:0.007723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296046 LIMIT 5 [ RunTime:0.024907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296046 ORDER BY `minOrder` ASC [ RunTime:0.021547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296046 ORDER BY `unit` DESC [ RunTime:0.027231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296046 LIMIT 2 [ RunTime:0.023868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296046 ORDER BY `minOrder` ASC [ RunTime:0.019740s ]
select * from pdf where partno='1001932pt-ac10l0200' and brandshort='kyocera avx' limit 1 [ RunTime:0.016738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932pt-ac10l0200' OR `brand` LIKE 'kyocera avx%' ) ) LIMIT 1 [ RunTime:0.010624s ]
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 '1001932%' OR `brand` LIKE '1001932%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64224048 LIMIT 5 [ RunTime:0.023198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64224048 ORDER BY `minOrder` ASC [ RunTime:0.031663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64224048 ORDER BY `unit` DESC [ RunTime:0.022166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64224048 LIMIT 2 [ RunTime:0.004783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64224048 ORDER BY `minOrder` ASC [ RunTime:0.023693s ]
select * from pdf where partno='1001932FT-AA10L0100' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.031585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932FT-AA10L0100' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.023905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64225137 LIMIT 5 [ RunTime:0.038750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225137 ORDER BY `minOrder` ASC [ RunTime:0.009564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64225137 ORDER BY `unit` DESC [ RunTime:0.006014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64225137 LIMIT 2 [ RunTime:0.000317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225137 ORDER BY `minOrder` ASC [ RunTime:0.005840s ]
select * from pdf where partno='1001932PT-AC10L0075' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.005141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932PT-AC10L0075' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.006325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64225092 LIMIT 5 [ RunTime:0.004804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225092 ORDER BY `minOrder` ASC [ RunTime:0.030633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64225092 ORDER BY `unit` DESC [ RunTime:0.041821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64225092 LIMIT 2 [ RunTime:0.021960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225092 ORDER BY `minOrder` ASC [ RunTime:0.010387s ]
select * from pdf where partno='1001932FT-AA10L0250' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.057029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932FT-AA10L0250' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.036786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64225059 LIMIT 5 [ RunTime:0.036321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225059 ORDER BY `minOrder` ASC [ RunTime:0.047892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64225059 ORDER BY `unit` DESC [ RunTime:0.013040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64225059 LIMIT 2 [ RunTime:0.042482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225059 ORDER BY `minOrder` ASC [ RunTime:0.010764s ]
select * from pdf where partno='1001932PT-AA10L0050' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.015177s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932PT-AA10L0050' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.020379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64225028 LIMIT 5 [ RunTime:0.000899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225028 ORDER BY `minOrder` ASC [ RunTime:0.039101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64225028 ORDER BY `unit` DESC [ RunTime:0.055158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64225028 LIMIT 2 [ RunTime:0.051412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225028 ORDER BY `minOrder` ASC [ RunTime:0.017416s ]
select * from pdf where partno='1001932FT-AA10L0050' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.015625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932FT-AA10L0050' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.047550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64224604 LIMIT 5 [ RunTime:0.078227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64224604 ORDER BY `minOrder` ASC [ RunTime:0.061386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64224604 ORDER BY `unit` DESC [ RunTime:0.046811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64224604 LIMIT 2 [ RunTime:0.035461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64224604 ORDER BY `minOrder` ASC [ RunTime:0.015452s ]
select * from pdf where partno='1001932PT-AD10L0050' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.033674s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932PT-AD10L0050' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.030638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64225127 LIMIT 5 [ RunTime:0.011941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225127 ORDER BY `minOrder` ASC [ RunTime:0.004359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64225127 ORDER BY `unit` DESC [ RunTime:0.020314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64225127 LIMIT 2 [ RunTime:0.017802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225127 ORDER BY `minOrder` ASC [ RunTime:0.006946s ]
select * from pdf where partno='1001932PT-AC10L0050' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.026793s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932PT-AC10L0050' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.017982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64225046 LIMIT 5 [ RunTime:0.043723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225046 ORDER BY `minOrder` ASC [ RunTime:0.042055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64225046 ORDER BY `unit` DESC [ RunTime:0.022474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64225046 LIMIT 2 [ RunTime:0.032708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225046 ORDER BY `minOrder` ASC [ RunTime:0.023421s ]
select * from pdf where partno='1001932FT-AA10L0075' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.026761s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932FT-AA10L0075' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.034967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64225128 LIMIT 5 [ RunTime:0.007921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225128 ORDER BY `minOrder` ASC [ RunTime:0.011449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64225128 ORDER BY `unit` DESC [ RunTime:0.009832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64225128 LIMIT 2 [ RunTime:0.005134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225128 ORDER BY `minOrder` ASC [ RunTime:0.004278s ]
select * from pdf where partno='1001932PT-AC10L0025' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.000667s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932PT-AC10L0025' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.023566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64225159 LIMIT 5 [ RunTime:0.013105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225159 ORDER BY `minOrder` ASC [ RunTime:0.040418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64225159 ORDER BY `unit` DESC [ RunTime:0.040140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64225159 LIMIT 2 [ RunTime:0.036272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225159 ORDER BY `minOrder` ASC [ RunTime:0.028191s ]
select * from pdf where partno='1001932PT-AC10L0200' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.011452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932PT-AC10L0200' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.059920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64225111 LIMIT 5 [ RunTime:0.034523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225111 ORDER BY `minOrder` ASC [ RunTime:0.014804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64225111 ORDER BY `unit` DESC [ RunTime:0.067877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64225111 LIMIT 2 [ RunTime:0.025517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225111 ORDER BY `minOrder` ASC [ RunTime:0.017276s ]
select * from pdf where partno='1001932PT-AA10L0200' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.033985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932PT-AA10L0200' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.043797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64225150 LIMIT 5 [ RunTime:0.017532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225150 ORDER BY `minOrder` ASC [ RunTime:0.008871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64225150 ORDER BY `unit` DESC [ RunTime:0.013067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64225150 LIMIT 2 [ RunTime:0.009560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225150 ORDER BY `minOrder` ASC [ RunTime:0.005512s ]
select * from pdf where partno='1001932PT-AC10L0150' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.011854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932PT-AC10L0150' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.032390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64225093 LIMIT 5 [ RunTime:0.012013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225093 ORDER BY `minOrder` ASC [ RunTime:0.002779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64225093 ORDER BY `unit` DESC [ RunTime:0.002131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64225093 LIMIT 2 [ RunTime:0.005300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64225093 ORDER BY `minOrder` ASC [ RunTime:0.011410s ]
select * from pdf where partno='1001932PT-AA10L0150' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.003735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932PT-AA10L0150' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.004095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64224069 LIMIT 5 [ RunTime:0.002797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64224069 ORDER BY `minOrder` ASC [ RunTime:0.011490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64224069 ORDER BY `unit` DESC [ RunTime:0.028503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64224069 LIMIT 2 [ RunTime:0.038711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64224069 ORDER BY `minOrder` ASC [ RunTime:0.019450s ]
select * from pdf where partno='1001932PT-AA10L0100' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.006503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932PT-AA10L0100' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.011409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64229808 LIMIT 5 [ RunTime:0.012660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64229808 ORDER BY `minOrder` ASC [ RunTime:0.020717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64229808 ORDER BY `unit` DESC [ RunTime:0.002415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64229808 LIMIT 2 [ RunTime:0.004918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64229808 ORDER BY `minOrder` ASC [ RunTime:0.005983s ]
select * from pdf where partno='1001932FT-AA10L0150' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.001401s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932FT-AA10L0150' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.017503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64231208 LIMIT 5 [ RunTime:0.009855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64231208 ORDER BY `minOrder` ASC [ RunTime:0.020111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64231208 ORDER BY `unit` DESC [ RunTime:0.008728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64231208 LIMIT 2 [ RunTime:0.006736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64231208 ORDER BY `minOrder` ASC [ RunTime:0.005805s ]
select * from pdf where partno='1001932PT-AD10L0200' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.002537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932PT-AD10L0200' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.000484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64231155 LIMIT 5 [ RunTime:0.014844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64231155 ORDER BY `minOrder` ASC [ RunTime:0.039785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64231155 ORDER BY `unit` DESC [ RunTime:0.009333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64231155 LIMIT 2 [ RunTime:0.014992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64231155 ORDER BY `minOrder` ASC [ RunTime:0.012806s ]
select * from pdf where partno='1001932PT-AD10L0150' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.017149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932PT-AD10L0150' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.012593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64231134 LIMIT 5 [ RunTime:0.009267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64231134 ORDER BY `minOrder` ASC [ RunTime:0.035497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64231134 ORDER BY `unit` DESC [ RunTime:0.011703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64231134 LIMIT 2 [ RunTime:0.016645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64231134 ORDER BY `minOrder` ASC [ RunTime:0.008446s ]
select * from pdf where partno='1001932PT-AD10L0100' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.024078s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932PT-AD10L0100' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.031968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64231024 LIMIT 5 [ RunTime:0.025179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64231024 ORDER BY `minOrder` ASC [ RunTime:0.013014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64231024 ORDER BY `unit` DESC [ RunTime:0.026269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64231024 LIMIT 2 [ RunTime:0.044368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64231024 ORDER BY `minOrder` ASC [ RunTime:0.010571s ]
select * from pdf where partno='1001932PT-AD10L0075' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.030418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932PT-AD10L0075' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.010244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64230891 LIMIT 5 [ RunTime:0.020292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64230891 ORDER BY `minOrder` ASC [ RunTime:0.018324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64230891 ORDER BY `unit` DESC [ RunTime:0.022051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64230891 LIMIT 2 [ RunTime:0.013635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64230891 ORDER BY `minOrder` ASC [ RunTime:0.011502s ]
select * from pdf where partno='1001932PT-AC10L0100' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.033557s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1001932PT-AC10L0100' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.008120s ]
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 '1001932%' OR `brand` LIKE '1001932%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020875s ]
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 '1001932%' OR `brand` LIKE '1001932%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013039s ]
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 '1001932%' OR `brand` LIKE '1001932%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008178s ]
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 '1001932%' OR `brand` LIKE '1001932%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024043s ]
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 '1001932%' OR `brand` LIKE '1001932%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016989s ]
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 '1001932%' OR `brand` LIKE '1001932%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018327s ]
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 '1001932%' OR `brand` LIKE '1001932%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.062870s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1001932%' OR `brand` LIKE '1001932%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.030274s ]