SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001933s ]
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%' OR `brand` LIKE 'MTJ-88TX1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031290s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11672769 LIMIT 5 [ RunTime:0.033053s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11672769 ORDER BY `minOrder` ASC [ RunTime:0.021997s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11672769 ORDER BY `unit` DESC [ RunTime:0.007534s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11672769 LIMIT 2 [ RunTime:0.033217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11672769 ORDER BY `minOrder` ASC [ RunTime:0.003515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15546672 LIMIT 5 [ RunTime:0.023592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15546672 ORDER BY `minOrder` ASC [ RunTime:0.063190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15546672 ORDER BY `unit` DESC [ RunTime:0.068856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15546672 LIMIT 2 [ RunTime:0.033510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15546672 ORDER BY `minOrder` ASC [ RunTime:0.021882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11672813 LIMIT 5 [ RunTime:0.057231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11672813 ORDER BY `minOrder` ASC [ RunTime:0.052009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11672813 ORDER BY `unit` DESC [ RunTime:0.082417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11672813 LIMIT 2 [ RunTime:0.043559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11672813 ORDER BY `minOrder` ASC [ RunTime:0.034189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16353877 LIMIT 5 [ RunTime:0.061048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16353877 ORDER BY `minOrder` ASC [ RunTime:0.018963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16353877 ORDER BY `unit` DESC [ RunTime:0.057319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16353877 LIMIT 2 [ RunTime:0.014267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16353877 ORDER BY `minOrder` ASC [ RunTime:0.012673s ]
select * from pdf where partno='MTJ-88TX1-LH' and brandshort='Adam Tech' limit 1 [ RunTime:0.029737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20071516 LIMIT 5 [ RunTime:0.020931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071516 ORDER BY `minOrder` ASC [ RunTime:0.058973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20071516 ORDER BY `unit` DESC [ RunTime:0.027433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20071516 LIMIT 2 [ RunTime:0.009931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071516 ORDER BY `minOrder` ASC [ RunTime:0.025676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20071517 LIMIT 5 [ RunTime:0.033078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071517 ORDER BY `minOrder` ASC [ RunTime:0.008708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20071517 ORDER BY `unit` DESC [ RunTime:0.019852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20071517 LIMIT 2 [ RunTime:0.024313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071517 ORDER BY `minOrder` ASC [ RunTime:0.005923s ]
select * from pdf where partno='MTJ-88TX1-LV' and brandshort='Adam Tech' limit 1 [ RunTime:0.009891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17369624 LIMIT 5 [ RunTime:0.020138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17369624 ORDER BY `minOrder` ASC [ RunTime:0.005127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17369624 ORDER BY `unit` DESC [ RunTime:0.003541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17369624 LIMIT 2 [ RunTime:0.001767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17369624 ORDER BY `minOrder` ASC [ RunTime:0.007404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16353880 LIMIT 5 [ RunTime:0.007063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16353880 ORDER BY `minOrder` ASC [ RunTime:0.007522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16353880 ORDER BY `unit` DESC [ RunTime:0.002244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16353880 LIMIT 2 [ RunTime:0.017754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16353880 ORDER BY `minOrder` ASC [ RunTime:0.012279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16353881 LIMIT 5 [ RunTime:0.023010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16353881 ORDER BY `minOrder` ASC [ RunTime:0.004902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16353881 ORDER BY `unit` DESC [ RunTime:0.005059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16353881 LIMIT 2 [ RunTime:0.009891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16353881 ORDER BY `minOrder` ASC [ RunTime:0.011697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11672824 LIMIT 5 [ RunTime:0.001211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11672824 ORDER BY `minOrder` ASC [ RunTime:0.000810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11672824 ORDER BY `unit` DESC [ RunTime:0.008074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11672824 LIMIT 2 [ RunTime:0.000698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11672824 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16354107 LIMIT 5 [ RunTime:0.005486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16354107 ORDER BY `minOrder` ASC [ RunTime:0.017229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16354107 ORDER BY `unit` DESC [ RunTime:0.007524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16354107 LIMIT 2 [ RunTime:0.011266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16354107 ORDER BY `minOrder` ASC [ RunTime:0.001732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16354103 LIMIT 5 [ RunTime:0.003581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16354103 ORDER BY `minOrder` ASC [ RunTime:0.006121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16354103 ORDER BY `unit` DESC [ RunTime:0.017260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16354103 LIMIT 2 [ RunTime:0.004812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16354103 ORDER BY `minOrder` ASC [ RunTime:0.003077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20071832 LIMIT 5 [ RunTime:0.004542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071832 ORDER BY `minOrder` ASC [ RunTime:0.008716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20071832 ORDER BY `unit` DESC [ RunTime:0.000582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20071832 LIMIT 2 [ RunTime:0.000475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071832 ORDER BY `minOrder` ASC [ RunTime:0.000985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17369739 LIMIT 5 [ RunTime:0.001957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17369739 ORDER BY `minOrder` ASC [ RunTime:0.007965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17369739 ORDER BY `unit` DESC [ RunTime:0.014125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17369739 LIMIT 2 [ RunTime:0.018726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17369739 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12863581 LIMIT 5 [ RunTime:0.000960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12863581 ORDER BY `minOrder` ASC [ RunTime:0.006195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12863581 ORDER BY `unit` DESC [ RunTime:0.000697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12863581 LIMIT 2 [ RunTime:0.007805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12863581 ORDER BY `minOrder` ASC [ RunTime:0.001172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17370226 LIMIT 5 [ RunTime:0.010201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17370226 ORDER BY `minOrder` ASC [ RunTime:0.003808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17370226 ORDER BY `unit` DESC [ RunTime:0.018270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17370226 LIMIT 2 [ RunTime:0.008200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17370226 ORDER BY `minOrder` ASC [ RunTime:0.013721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20073684 LIMIT 5 [ RunTime:0.005419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073684 ORDER BY `minOrder` ASC [ RunTime:0.009714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20073684 ORDER BY `unit` DESC [ RunTime:0.004652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20073684 LIMIT 2 [ RunTime:0.001249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073684 ORDER BY `minOrder` ASC [ RunTime:0.002629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20073636 LIMIT 5 [ RunTime:0.000976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073636 ORDER BY `minOrder` ASC [ RunTime:0.002688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20073636 ORDER BY `unit` DESC [ RunTime:0.001193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20073636 LIMIT 2 [ RunTime:0.000566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073636 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20073480 LIMIT 5 [ RunTime:0.001541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073480 ORDER BY `minOrder` ASC [ RunTime:0.004253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20073480 ORDER BY `unit` DESC [ RunTime:0.011295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20073480 LIMIT 2 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073480 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20073227 LIMIT 5 [ RunTime:0.000715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073227 ORDER BY `minOrder` ASC [ RunTime:0.002299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20073227 ORDER BY `unit` DESC [ RunTime:0.008296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20073227 LIMIT 2 [ RunTime:0.003957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20073227 ORDER BY `minOrder` ASC [ RunTime:0.002467s ]
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%' OR `brand` LIKE 'MTJ-88TX1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004135s ]
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%' OR `brand` LIKE 'MTJ-88TX1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60417073 LIMIT 5 [ RunTime:0.000554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60417073 ORDER BY `minOrder` ASC [ RunTime:0.000816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60417073 ORDER BY `unit` DESC [ RunTime:0.000521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60417073 LIMIT 2 [ RunTime:0.000409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60417073 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
select * from pdf where partno='MTJ-88TX1-FSD-PGB' and brandshort='Adam Tech' limit 1 [ RunTime:0.001278s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001130s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-PGB' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.001121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60418272 LIMIT 5 [ RunTime:0.000407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418272 ORDER BY `minOrder` ASC [ RunTime:0.003568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60418272 ORDER BY `unit` DESC [ RunTime:0.002744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60418272 LIMIT 2 [ RunTime:0.001024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418272 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
select * from pdf where partno='MTJ-88TX1' and brandshort='Adam Tech' limit 1 [ RunTime:0.008775s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.002195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60411710 LIMIT 5 [ RunTime:0.000514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60411710 ORDER BY `minOrder` ASC [ RunTime:0.008329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60411710 ORDER BY `unit` DESC [ RunTime:0.002758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60411710 LIMIT 2 [ RunTime:0.000771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60411710 ORDER BY `minOrder` ASC [ RunTime:0.002634s ]
select * from pdf where partno='MTJ-88TX1-FSD-PG-LG-M4' and brandshort='Adam Tech' limit 1 [ RunTime:0.001436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-PG-LG-M4' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.002631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60417079 LIMIT 5 [ RunTime:0.001035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60417079 ORDER BY `minOrder` ASC [ RunTime:0.000613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60417079 ORDER BY `unit` DESC [ RunTime:0.000610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60417079 LIMIT 2 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60417079 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
select * from pdf where partno='MTJ-88TX1-FSD-LG' and brandshort='Adam Tech' limit 1 [ RunTime:0.001192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-LG' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.001441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60412112 LIMIT 5 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60412112 ORDER BY `minOrder` ASC [ RunTime:0.000745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60412112 ORDER BY `unit` DESC [ RunTime:0.010767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60412112 LIMIT 2 [ RunTime:0.005961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60412112 ORDER BY `minOrder` ASC [ RunTime:0.002212s ]
select * from pdf where partno='MTJ-88TX1-FSP-PG-LG-M4' and brandshort='Adam Tech' limit 1 [ RunTime:0.001890s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSP-PG-LG-M4' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.001308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60418344 LIMIT 5 [ RunTime:0.003425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418344 ORDER BY `minOrder` ASC [ RunTime:0.002950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60418344 ORDER BY `unit` DESC [ RunTime:0.000491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60418344 LIMIT 2 [ RunTime:0.000869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418344 ORDER BY `minOrder` ASC [ RunTime:0.011376s ]
select * from pdf where partno='MTJ-88TX1-LH' and brandshort='Adam Tech' limit 1 [ RunTime:0.001766s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-LH' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.016246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60418401 LIMIT 5 [ RunTime:0.004775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418401 ORDER BY `minOrder` ASC [ RunTime:0.006797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60418401 ORDER BY `unit` DESC [ RunTime:0.012777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60418401 LIMIT 2 [ RunTime:0.000698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418401 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
select * from pdf where partno='MTJ-88TX1-L16' and brandshort='Adam Tech' limit 1 [ RunTime:0.003680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-L16' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.000992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60418346 LIMIT 5 [ RunTime:0.022901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418346 ORDER BY `minOrder` ASC [ RunTime:0.027505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60418346 ORDER BY `unit` DESC [ RunTime:0.000940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60418346 LIMIT 2 [ RunTime:0.003476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418346 ORDER BY `minOrder` ASC [ RunTime:0.003638s ]
select * from pdf where partno='MTJ-88TX1-LV' and brandshort='Adam Tech' limit 1 [ RunTime:0.003567s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-LV' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.001242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60418410 LIMIT 5 [ RunTime:0.004719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418410 ORDER BY `minOrder` ASC [ RunTime:0.007164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60418410 ORDER BY `unit` DESC [ RunTime:0.019565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60418410 LIMIT 2 [ RunTime:0.018544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418410 ORDER BY `minOrder` ASC [ RunTime:0.006205s ]
select * from pdf where partno='MTJ-88TX1-FSD-L16' and brandshort='Adam Tech' limit 1 [ RunTime:0.006899s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-L16' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.018416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60418327 LIMIT 5 [ RunTime:0.017224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418327 ORDER BY `minOrder` ASC [ RunTime:0.010639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60418327 ORDER BY `unit` DESC [ RunTime:0.004614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60418327 LIMIT 2 [ RunTime:0.008403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418327 ORDER BY `minOrder` ASC [ RunTime:0.016481s ]
select * from pdf where partno='MTJ-88TX1-FSD-LD' and brandshort='Adam Tech' limit 1 [ RunTime:0.012578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-LD' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.005231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419039 LIMIT 5 [ RunTime:0.014043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419039 ORDER BY `minOrder` ASC [ RunTime:0.019396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419039 ORDER BY `unit` DESC [ RunTime:0.039371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419039 LIMIT 2 [ RunTime:0.004570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419039 ORDER BY `minOrder` ASC [ RunTime:0.010091s ]
select * from pdf where partno='MTJ-88TX1-FSD-PG-LP' and brandshort='Adam Tech' limit 1 [ RunTime:0.003997s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-PG-LP' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.005577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419035 LIMIT 5 [ RunTime:0.008663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419035 ORDER BY `minOrder` ASC [ RunTime:0.015720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419035 ORDER BY `unit` DESC [ RunTime:0.004801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419035 LIMIT 2 [ RunTime:0.016939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419035 ORDER BY `minOrder` ASC [ RunTime:0.009715s ]
select * from pdf where partno='MTJ-88TX1-FSD-PG-LV' and brandshort='Adam Tech' limit 1 [ RunTime:0.014057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-PG-LV' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.017514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419032 LIMIT 5 [ RunTime:0.011481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419032 ORDER BY `minOrder` ASC [ RunTime:0.004049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419032 ORDER BY `unit` DESC [ RunTime:0.004320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419032 LIMIT 2 [ RunTime:0.007232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419032 ORDER BY `minOrder` ASC [ RunTime:0.011669s ]
select * from pdf where partno='MTJ-88TX1-FSD-PG-L16' and brandshort='Adam Tech' limit 1 [ RunTime:0.001138s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-PG-L16' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.006747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419037 LIMIT 5 [ RunTime:0.011127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419037 ORDER BY `minOrder` ASC [ RunTime:0.004749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419037 ORDER BY `unit` DESC [ RunTime:0.001869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419037 LIMIT 2 [ RunTime:0.005745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419037 ORDER BY `minOrder` ASC [ RunTime:0.004664s ]
select * from pdf where partno='MTJ-88TX1-LG' and brandshort='Adam Tech' limit 1 [ RunTime:0.001449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-LG' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.017583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60412420 LIMIT 5 [ RunTime:0.001061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60412420 ORDER BY `minOrder` ASC [ RunTime:0.015909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60412420 ORDER BY `unit` DESC [ RunTime:0.012134s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60412420 LIMIT 2 [ RunTime:0.004842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60412420 ORDER BY `minOrder` ASC [ RunTime:0.003279s ]
select * from pdf where partno='MTJ-88TX1-FS-M4-SMT' and brandshort='Adam Tech' limit 1 [ RunTime:0.001366s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FS-M4-SMT' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.004995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60412413 LIMIT 5 [ RunTime:0.008437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60412413 ORDER BY `minOrder` ASC [ RunTime:0.000787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60412413 ORDER BY `unit` DESC [ RunTime:0.001853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60412413 LIMIT 2 [ RunTime:0.000605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60412413 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
select * from pdf where partno='MTJ-88TX1-FSD-LH1-M47C1' and brandshort='Adam Tech' limit 1 [ RunTime:0.000987s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-LH1-M47C1' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.006494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60421594 LIMIT 5 [ RunTime:0.005020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60421594 ORDER BY `minOrder` ASC [ RunTime:0.012862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60421594 ORDER BY `unit` DESC [ RunTime:0.000904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60421594 LIMIT 2 [ RunTime:0.007904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60421594 ORDER BY `minOrder` ASC [ RunTime:0.000673s ]
select * from pdf where partno='MTJ-88TX1-FSD-PG-LD' and brandshort='Adam Tech' limit 1 [ RunTime:0.001097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-PG-LD' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.010268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60423248 LIMIT 5 [ RunTime:0.034613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60423248 ORDER BY `minOrder` ASC [ RunTime:0.013721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60423248 ORDER BY `unit` DESC [ RunTime:0.004620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60423248 LIMIT 2 [ RunTime:0.011085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60423248 ORDER BY `minOrder` ASC [ RunTime:0.005995s ]
select * from pdf where partno='MTJ-88TX1-FSD-PG-LH-M5-SG' and brandshort='Adam Tech' limit 1 [ RunTime:0.012235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-PG-LH-M5-SG' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.019520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60423081 LIMIT 5 [ RunTime:0.014239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60423081 ORDER BY `minOrder` ASC [ RunTime:0.020269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60423081 ORDER BY `unit` DESC [ RunTime:0.008627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60423081 LIMIT 2 [ RunTime:0.007633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60423081 ORDER BY `minOrder` ASC [ RunTime:0.003052s ]
select * from pdf where partno='MTJ-88TX1-FSD-PG2T-M5C' and brandshort='Adam Tech' limit 1 [ RunTime:0.005462s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-PG2T-M5C' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.003740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60422905 LIMIT 5 [ RunTime:0.013308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60422905 ORDER BY `minOrder` ASC [ RunTime:0.010882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60422905 ORDER BY `unit` DESC [ RunTime:0.020409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60422905 LIMIT 2 [ RunTime:0.007727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60422905 ORDER BY `minOrder` ASC [ RunTime:0.006531s ]
select * from pdf where partno='MTJ-88TX1-FSD-PG-LH' and brandshort='Adam Tech' limit 1 [ RunTime:0.015427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MTJ-88TX1-FSD-PG-LH' OR `brand` LIKE 'Adam Tech%' ) ) LIMIT 1 [ RunTime:0.033185s ]
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%' OR `brand` LIKE 'MTJ-88TX1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034457s ]
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%' OR `brand` LIKE 'MTJ-88TX1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015049s ]
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%' OR `brand` LIKE 'MTJ-88TX1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009764s ]
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%' OR `brand` LIKE 'MTJ-88TX1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007571s ]
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%' OR `brand` LIKE 'MTJ-88TX1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014090s ]
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%' OR `brand` LIKE 'MTJ-88TX1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015563s ]
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%' OR `brand` LIKE 'MTJ-88TX1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019404s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MTJ-88TX1%' OR `brand` LIKE 'MTJ-88TX1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.037080s ]