SHOW FULL COLUMNS FROM `stock` [ RunTime:0.007373s ]
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 'MTJ-88TX1-FSD%' OR `brand` LIKE 'MTJ-88TX1-FSD%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.106560s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.087707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11672769 LIMIT 5 [ RunTime:0.077969s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.039593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11672769 ORDER BY `minOrder` ASC [ RunTime:0.064236s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.045621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11672769 ORDER BY `unit` DESC [ RunTime:0.027081s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.026400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11672769 LIMIT 2 [ RunTime:0.082510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11672769 ORDER BY `minOrder` ASC [ RunTime:0.021868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15546672 LIMIT 5 [ RunTime:0.058767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15546672 ORDER BY `minOrder` ASC [ RunTime:0.100394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15546672 ORDER BY `unit` DESC [ RunTime:0.083990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15546672 LIMIT 2 [ RunTime:0.013242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15546672 ORDER BY `minOrder` ASC [ RunTime:0.092026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17369624 LIMIT 5 [ RunTime:0.082387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17369624 ORDER BY `minOrder` ASC [ RunTime:0.094295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17369624 ORDER BY `unit` DESC [ RunTime:0.100315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17369624 LIMIT 2 [ RunTime:0.080152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17369624 ORDER BY `minOrder` ASC [ RunTime:0.040377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16353880 LIMIT 5 [ RunTime:0.040341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16353880 ORDER BY `minOrder` ASC [ RunTime:0.045631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16353880 ORDER BY `unit` DESC [ RunTime:0.060196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16353880 LIMIT 2 [ RunTime:0.051203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16353880 ORDER BY `minOrder` ASC [ RunTime:0.001540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16353881 LIMIT 5 [ RunTime:0.093702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16353881 ORDER BY `minOrder` ASC [ RunTime:0.056242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16353881 ORDER BY `unit` DESC [ RunTime:0.035184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16353881 LIMIT 2 [ RunTime:0.044834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16353881 ORDER BY `minOrder` ASC [ RunTime:0.018833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11672824 LIMIT 5 [ RunTime:0.047030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11672824 ORDER BY `minOrder` ASC [ RunTime:0.036675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11672824 ORDER BY `unit` DESC [ RunTime:0.031013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11672824 LIMIT 2 [ RunTime:0.004197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11672824 ORDER BY `minOrder` ASC [ RunTime:0.004290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16354107 LIMIT 5 [ RunTime:0.001080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16354107 ORDER BY `minOrder` ASC [ RunTime:0.004529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16354107 ORDER BY `unit` DESC [ RunTime:0.010651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16354107 LIMIT 2 [ RunTime:0.036861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16354107 ORDER BY `minOrder` ASC [ RunTime:0.015519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20071832 LIMIT 5 [ RunTime:0.004895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071832 ORDER BY `minOrder` ASC [ RunTime:0.019543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20071832 ORDER BY `unit` DESC [ RunTime:0.007151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20071832 LIMIT 2 [ RunTime:0.028476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071832 ORDER BY `minOrder` ASC [ RunTime:0.019060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17370226 LIMIT 5 [ RunTime:0.006162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17370226 ORDER BY `minOrder` ASC [ RunTime:0.019130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17370226 ORDER BY `unit` DESC [ RunTime:0.022418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17370226 LIMIT 2 [ RunTime:0.003826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17370226 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20073684 LIMIT 5 [ RunTime:0.013811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073684 ORDER BY `minOrder` ASC [ RunTime:0.002124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20073684 ORDER BY `unit` DESC [ RunTime:0.008151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20073684 LIMIT 2 [ RunTime:0.026001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073684 ORDER BY `minOrder` ASC [ RunTime:0.004764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20073636 LIMIT 5 [ RunTime:0.015803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073636 ORDER BY `minOrder` ASC [ RunTime:0.019048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20073636 ORDER BY `unit` DESC [ RunTime:0.003485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20073636 LIMIT 2 [ RunTime:0.003918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073636 ORDER BY `minOrder` ASC [ RunTime:0.002256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20073480 LIMIT 5 [ RunTime:0.012821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073480 ORDER BY `minOrder` ASC [ RunTime:0.015849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20073480 ORDER BY `unit` DESC [ RunTime:0.014353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20073480 LIMIT 2 [ RunTime:0.019565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073480 ORDER BY `minOrder` ASC [ RunTime:0.007085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20073227 LIMIT 5 [ RunTime:0.013004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073227 ORDER BY `minOrder` ASC [ RunTime:0.030724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20073227 ORDER BY `unit` DESC [ RunTime:0.006097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20073227 LIMIT 2 [ RunTime:0.029436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073227 ORDER BY `minOrder` ASC [ RunTime:0.007361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20073223 LIMIT 5 [ RunTime:0.017739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073223 ORDER BY `minOrder` ASC [ RunTime:0.012684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20073223 ORDER BY `unit` DESC [ RunTime:0.010409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20073223 LIMIT 2 [ RunTime:0.024975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073223 ORDER BY `minOrder` ASC [ RunTime:0.010065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072731 LIMIT 5 [ RunTime:0.009408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072731 ORDER BY `minOrder` ASC [ RunTime:0.005614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20072731 ORDER BY `unit` DESC [ RunTime:0.000460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20072731 LIMIT 2 [ RunTime:0.000780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072731 ORDER BY `minOrder` ASC [ RunTime:0.000886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072730 LIMIT 5 [ RunTime:0.000741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072730 ORDER BY `minOrder` ASC [ RunTime:0.007661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20072730 ORDER BY `unit` DESC [ RunTime:0.009097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20072730 LIMIT 2 [ RunTime:0.017234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072730 ORDER BY `minOrder` ASC [ RunTime:0.003249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072526 LIMIT 5 [ RunTime:0.002544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072526 ORDER BY `minOrder` ASC [ RunTime:0.003516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20072526 ORDER BY `unit` DESC [ RunTime:0.001558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20072526 LIMIT 2 [ RunTime:0.015269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072526 ORDER BY `minOrder` ASC [ RunTime:0.005785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17370307 LIMIT 5 [ RunTime:0.012895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17370307 ORDER BY `minOrder` ASC [ RunTime:0.018768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17370307 ORDER BY `unit` DESC [ RunTime:0.042254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17370307 LIMIT 2 [ RunTime:0.014757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17370307 ORDER BY `minOrder` ASC [ RunTime:0.017767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17370085 LIMIT 5 [ RunTime:0.012628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17370085 ORDER BY `minOrder` ASC [ RunTime:0.008802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17370085 ORDER BY `unit` DESC [ RunTime:0.011596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17370085 LIMIT 2 [ RunTime:0.028450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17370085 ORDER BY `minOrder` ASC [ RunTime:0.000560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17370084 LIMIT 5 [ RunTime:0.030563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17370084 ORDER BY `minOrder` ASC [ RunTime:0.031149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17370084 ORDER BY `unit` DESC [ RunTime:0.028963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17370084 LIMIT 2 [ RunTime:0.019451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17370084 ORDER BY `minOrder` ASC [ RunTime:0.014843s ]
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 'MTJ-88TX1-FSD%' OR `brand` LIKE 'MTJ-88TX1-FSD%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015255s ]
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 'MTJ-88TX1-FSD%' OR `brand` LIKE 'MTJ-88TX1-FSD%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60417073 LIMIT 5 [ RunTime:0.013038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60417073 ORDER BY `minOrder` ASC [ RunTime:0.026026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60417073 ORDER BY `unit` DESC [ RunTime:0.034470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60417073 LIMIT 2 [ RunTime:0.017337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60417073 ORDER BY `minOrder` ASC [ RunTime:0.034100s ]
select * from pdf where partno='MTJ-88TX1-FSD-PGB' and brandshort='Adam Tech' limit 1 [ RunTime:0.024689s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002582s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-PGB' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.043325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60411710 LIMIT 5 [ RunTime:0.027813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60411710 ORDER BY `minOrder` ASC [ RunTime:0.036339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60411710 ORDER BY `unit` DESC [ RunTime:0.035629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60411710 LIMIT 2 [ RunTime:0.018470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60411710 ORDER BY `minOrder` ASC [ RunTime:0.001913s ]
select * from pdf where partno='MTJ-88TX1-FSD-PG-LG-M4' and brandshort='Adam Tech' limit 1 [ RunTime:0.017912s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-PG-LG-M4' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.039988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60417079 LIMIT 5 [ RunTime:0.048349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60417079 ORDER BY `minOrder` ASC [ RunTime:0.041139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60417079 ORDER BY `unit` DESC [ RunTime:0.041922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60417079 LIMIT 2 [ RunTime:0.009929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60417079 ORDER BY `minOrder` ASC [ RunTime:0.034050s ]
select * from pdf where partno='MTJ-88TX1-FSD-LG' and brandshort='Adam Tech' limit 1 [ RunTime:0.054118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-LG' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.041776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60418410 LIMIT 5 [ RunTime:0.047978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418410 ORDER BY `minOrder` ASC [ RunTime:0.025261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60418410 ORDER BY `unit` DESC [ RunTime:0.007460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60418410 LIMIT 2 [ RunTime:0.013438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418410 ORDER BY `minOrder` ASC [ RunTime:0.067436s ]
select * from pdf where partno='MTJ-88TX1-FSD-L16' and brandshort='Adam Tech' limit 1 [ RunTime:0.014007s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-L16' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.013232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60418327 LIMIT 5 [ RunTime:0.020199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418327 ORDER BY `minOrder` ASC [ RunTime:0.044052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60418327 ORDER BY `unit` DESC [ RunTime:0.047893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60418327 LIMIT 2 [ RunTime:0.049812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418327 ORDER BY `minOrder` ASC [ RunTime:0.020639s ]
select * from pdf where partno='MTJ-88TX1-FSD-LD' and brandshort='Adam Tech' limit 1 [ RunTime:0.060911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-LD' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.033774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419039 LIMIT 5 [ RunTime:0.089385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419039 ORDER BY `minOrder` ASC [ RunTime:0.066711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419039 ORDER BY `unit` DESC [ RunTime:0.044516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419039 LIMIT 2 [ RunTime:0.072792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419039 ORDER BY `minOrder` ASC [ RunTime:0.003756s ]
select * from pdf where partno='MTJ-88TX1-FSD-PG-LP' and brandshort='Adam Tech' limit 1 [ RunTime:0.039588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-PG-LP' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.041857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419035 LIMIT 5 [ RunTime:0.020708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419035 ORDER BY `minOrder` ASC [ RunTime:0.057535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419035 ORDER BY `unit` DESC [ RunTime:0.061253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419035 LIMIT 2 [ RunTime:0.031604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419035 ORDER BY `minOrder` ASC [ RunTime:0.014167s ]
select * from pdf where partno='MTJ-88TX1-FSD-PG-LV' and brandshort='Adam Tech' limit 1 [ RunTime:0.064280s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-PG-LV' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.056051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419032 LIMIT 5 [ RunTime:0.018941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419032 ORDER BY `minOrder` ASC [ RunTime:0.058056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419032 ORDER BY `unit` DESC [ RunTime:0.053174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419032 LIMIT 2 [ RunTime:0.024276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419032 ORDER BY `minOrder` ASC [ RunTime:0.006372s ]
select * from pdf where partno='MTJ-88TX1-FSD-PG-L16' and brandshort='Adam Tech' limit 1 [ RunTime:0.018456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-PG-L16' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.019396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60412413 LIMIT 5 [ RunTime:0.034036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60412413 ORDER BY `minOrder` ASC [ RunTime:0.040870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60412413 ORDER BY `unit` DESC [ RunTime:0.035889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60412413 LIMIT 2 [ RunTime:0.044101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60412413 ORDER BY `minOrder` ASC [ RunTime:0.003681s ]
select * from pdf where partno='MTJ-88TX1-FSD-LH1-M47C1' and brandshort='Adam Tech' limit 1 [ RunTime:0.023964s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-LH1-M47C1' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.047431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60421594 LIMIT 5 [ RunTime:0.015151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60421594 ORDER BY `minOrder` ASC [ RunTime:0.012600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60421594 ORDER BY `unit` DESC [ RunTime:0.011242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60421594 LIMIT 2 [ RunTime:0.041499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60421594 ORDER BY `minOrder` ASC [ RunTime:0.035148s ]
select * from pdf where partno='MTJ-88TX1-FSD-PG-LD' and brandshort='Adam Tech' limit 1 [ RunTime:0.019555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-PG-LD' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.023225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60423248 LIMIT 5 [ RunTime:0.045189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60423248 ORDER BY `minOrder` ASC [ RunTime:0.026239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60423248 ORDER BY `unit` DESC [ RunTime:0.066616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60423248 LIMIT 2 [ RunTime:0.055956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60423248 ORDER BY `minOrder` ASC [ RunTime:0.004432s ]
select * from pdf where partno='MTJ-88TX1-FSD-PG-LH-M5-SG' and brandshort='Adam Tech' limit 1 [ RunTime:0.051035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-PG-LH-M5-SG' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.051878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60423081 LIMIT 5 [ RunTime:0.020752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60423081 ORDER BY `minOrder` ASC [ RunTime:0.004793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60423081 ORDER BY `unit` DESC [ RunTime:0.023299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60423081 LIMIT 2 [ RunTime:0.039198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60423081 ORDER BY `minOrder` ASC [ RunTime:0.011772s ]
select * from pdf where partno='MTJ-88TX1-FSD-PG2T-M5C' and brandshort='Adam Tech' limit 1 [ RunTime:0.016434s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-PG2T-M5C' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.003382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60422905 LIMIT 5 [ RunTime:0.004162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60422905 ORDER BY `minOrder` ASC [ RunTime:0.003915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60422905 ORDER BY `unit` DESC [ RunTime:0.007723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60422905 LIMIT 2 [ RunTime:0.002973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60422905 ORDER BY `minOrder` ASC [ RunTime:0.007131s ]
select * from pdf where partno='MTJ-88TX1-FSD-PG-LH' and brandshort='Adam Tech' limit 1 [ RunTime:0.031058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-PG-LH' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.025776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60422717 LIMIT 5 [ RunTime:0.017139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60422717 ORDER BY `minOrder` ASC [ RunTime:0.008728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60422717 ORDER BY `unit` DESC [ RunTime:0.007309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60422717 LIMIT 2 [ RunTime:0.006989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60422717 ORDER BY `minOrder` ASC [ RunTime:0.010191s ]
select * from pdf where partno='MTJ-88TX1-FSD-LP' and brandshort='Adam Tech' limit 1 [ RunTime:0.002061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-LP' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.011570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60422456 LIMIT 5 [ RunTime:0.014896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60422456 ORDER BY `minOrder` ASC [ RunTime:0.005135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60422456 ORDER BY `unit` DESC [ RunTime:0.012527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60422456 LIMIT 2 [ RunTime:0.022564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60422456 ORDER BY `minOrder` ASC [ RunTime:0.012369s ]
select * from pdf where partno='MTJ-88TX1-FSD-PG' and brandshort='Adam Tech' limit 1 [ RunTime:0.022056s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-PG' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.008546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60422406 LIMIT 5 [ RunTime:0.019365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60422406 ORDER BY `minOrder` ASC [ RunTime:0.002228s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60422406 ORDER BY `unit` DESC [ RunTime:0.005861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60422406 LIMIT 2 [ RunTime:0.000887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60422406 ORDER BY `minOrder` ASC [ RunTime:0.000510s ]
select * from pdf where partno='MTJ-88TX1-FSD-PG6-M3-X7-WOT' and brandshort='Adam Tech' limit 1 [ RunTime:0.010333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-PG6-M3-X7-WOT' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.003189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60422189 LIMIT 5 [ RunTime:0.008887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60422189 ORDER BY `minOrder` ASC [ RunTime:0.001509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60422189 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60422189 LIMIT 2 [ RunTime:0.001465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60422189 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
select * from pdf where partno='MTJ-88TX1-FSD-PG-LG' and brandshort='Adam Tech' limit 1 [ RunTime:0.006369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-PG-LG' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.002257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60421989 LIMIT 5 [ RunTime:0.002855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60421989 ORDER BY `minOrder` ASC [ RunTime:0.000749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60421989 ORDER BY `unit` DESC [ RunTime:0.000400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60421989 LIMIT 2 [ RunTime:0.012285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60421989 ORDER BY `minOrder` ASC [ RunTime:0.003896s ]
select * from pdf where partno='MTJ-88TX1-FSD-LV' and brandshort='Adam Tech' limit 1 [ RunTime:0.005102s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-LV' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.001882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60421326 LIMIT 5 [ RunTime:0.009889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60421326 ORDER BY `minOrder` ASC [ RunTime:0.001595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60421326 ORDER BY `unit` DESC [ RunTime:0.000944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60421326 LIMIT 2 [ RunTime:0.002817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60421326 ORDER BY `minOrder` ASC [ RunTime:0.007868s ]
select * from pdf where partno='MTJ-88TX1-FSD-LH' and brandshort='Adam Tech' limit 1 [ RunTime:0.009456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-LH' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.005760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419915 LIMIT 5 [ RunTime:0.008378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419915 ORDER BY `minOrder` ASC [ RunTime:0.004943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419915 ORDER BY `unit` DESC [ RunTime:0.006177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419915 LIMIT 2 [ RunTime:0.002455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419915 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
select * from pdf where partno='MTJ-88TX1-FSD' and brandshort='Adam Tech' limit 1 [ RunTime:0.000569s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.000428s ]
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 'MTJ-88TX1-FSD%' OR `brand` LIKE 'MTJ-88TX1-FSD%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001713s ]
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 'MTJ-88TX1-FSD%' OR `brand` LIKE 'MTJ-88TX1-FSD%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002760s ]
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 'MTJ-88TX1-FSD%' OR `brand` LIKE 'MTJ-88TX1-FSD%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007962s ]
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 'MTJ-88TX1-FSD%' OR `brand` LIKE 'MTJ-88TX1-FSD%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007778s ]
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 'MTJ-88TX1-FSD%' OR `brand` LIKE 'MTJ-88TX1-FSD%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005941s ]
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 'MTJ-88TX1-FSD%' OR `brand` LIKE 'MTJ-88TX1-FSD%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014152s ]
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 'MTJ-88TX1-FSD%' OR `brand` LIKE 'MTJ-88TX1-FSD%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014778s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MTJ-88TX1-FSD%' OR `brand` LIKE 'MTJ-88TX1-FSD%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003974s ]