SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001739s ]
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 '20004%' OR `brand` LIKE '20004%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033824s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634337 LIMIT 5 [ RunTime:0.019858s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634337 ORDER BY `minOrder` ASC [ RunTime:0.044301s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19634337 ORDER BY `unit` DESC [ RunTime:0.015232s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19634337 LIMIT 2 [ RunTime:0.020684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634337 ORDER BY `minOrder` ASC [ RunTime:0.026331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16995399 LIMIT 5 [ RunTime:0.007597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16995399 ORDER BY `minOrder` ASC [ RunTime:0.010389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16995399 ORDER BY `unit` DESC [ RunTime:0.009185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16995399 LIMIT 2 [ RunTime:0.016477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16995399 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584290 LIMIT 5 [ RunTime:0.001228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584290 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19584290 ORDER BY `unit` DESC [ RunTime:0.004050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19584290 LIMIT 2 [ RunTime:0.001281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584290 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18932088 LIMIT 5 [ RunTime:0.004390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932088 ORDER BY `minOrder` ASC [ RunTime:0.000689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18932088 ORDER BY `unit` DESC [ RunTime:0.000534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18932088 LIMIT 2 [ RunTime:0.006189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932088 ORDER BY `minOrder` ASC [ RunTime:0.003305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18932086 LIMIT 5 [ RunTime:0.001240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932086 ORDER BY `minOrder` ASC [ RunTime:0.001102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18932086 ORDER BY `unit` DESC [ RunTime:0.004518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18932086 LIMIT 2 [ RunTime:0.002331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932086 ORDER BY `minOrder` ASC [ RunTime:0.000348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18932085 LIMIT 5 [ RunTime:0.000467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932085 ORDER BY `minOrder` ASC [ RunTime:0.000677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18932085 ORDER BY `unit` DESC [ RunTime:0.002500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18932085 LIMIT 2 [ RunTime:0.001509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932085 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18932084 LIMIT 5 [ RunTime:0.000478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932084 ORDER BY `minOrder` ASC [ RunTime:0.001398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18932084 ORDER BY `unit` DESC [ RunTime:0.000456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18932084 LIMIT 2 [ RunTime:0.002718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932084 ORDER BY `minOrder` ASC [ RunTime:0.000350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18932083 LIMIT 5 [ RunTime:0.000833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932083 ORDER BY `minOrder` ASC [ RunTime:0.002287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18932083 ORDER BY `unit` DESC [ RunTime:0.001250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18932083 LIMIT 2 [ RunTime:0.000512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932083 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18932059 LIMIT 5 [ RunTime:0.000742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932059 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18932059 ORDER BY `unit` DESC [ RunTime:0.002285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18932059 LIMIT 2 [ RunTime:0.003780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932059 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18932058 LIMIT 5 [ RunTime:0.000449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932058 ORDER BY `minOrder` ASC [ RunTime:0.001227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18932058 ORDER BY `unit` DESC [ RunTime:0.001884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18932058 LIMIT 2 [ RunTime:0.000736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932058 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18932057 LIMIT 5 [ RunTime:0.000518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932057 ORDER BY `minOrder` ASC [ RunTime:0.002449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18932057 ORDER BY `unit` DESC [ RunTime:0.000581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18932057 LIMIT 2 [ RunTime:0.001294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932057 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18932056 LIMIT 5 [ RunTime:0.002488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932056 ORDER BY `minOrder` ASC [ RunTime:0.002210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18932056 ORDER BY `unit` DESC [ RunTime:0.001108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18932056 LIMIT 2 [ RunTime:0.004856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932056 ORDER BY `minOrder` ASC [ RunTime:0.003155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18823391 LIMIT 5 [ RunTime:0.002095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18823391 ORDER BY `minOrder` ASC [ RunTime:0.002399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18823391 ORDER BY `unit` DESC [ RunTime:0.001135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18823391 LIMIT 2 [ RunTime:0.002024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18823391 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18823122 LIMIT 5 [ RunTime:0.003195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18823122 ORDER BY `minOrder` ASC [ RunTime:0.003528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18823122 ORDER BY `unit` DESC [ RunTime:0.000830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18823122 LIMIT 2 [ RunTime:0.003172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18823122 ORDER BY `minOrder` ASC [ RunTime:0.000353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18822998 LIMIT 5 [ RunTime:0.000702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18822998 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18822998 ORDER BY `unit` DESC [ RunTime:0.009662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18822998 LIMIT 2 [ RunTime:0.005996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18822998 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18822997 LIMIT 5 [ RunTime:0.000783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18822997 ORDER BY `minOrder` ASC [ RunTime:0.012554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18822997 ORDER BY `unit` DESC [ RunTime:0.011910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18822997 LIMIT 2 [ RunTime:0.002211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18822997 ORDER BY `minOrder` ASC [ RunTime:0.005638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18822996 LIMIT 5 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18822996 ORDER BY `minOrder` ASC [ RunTime:0.005970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18822996 ORDER BY `unit` DESC [ RunTime:0.000522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18822996 LIMIT 2 [ RunTime:0.008696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18822996 ORDER BY `minOrder` ASC [ RunTime:0.010241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17311301 LIMIT 5 [ RunTime:0.021261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17311301 ORDER BY `minOrder` ASC [ RunTime:0.006688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17311301 ORDER BY `unit` DESC [ RunTime:0.003560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17311301 LIMIT 2 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17311301 ORDER BY `minOrder` ASC [ RunTime:0.001553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17038697 LIMIT 5 [ RunTime:0.000879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17038697 ORDER BY `minOrder` ASC [ RunTime:0.003403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17038697 ORDER BY `unit` DESC [ RunTime:0.000571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17038697 LIMIT 2 [ RunTime:0.003705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17038697 ORDER BY `minOrder` ASC [ RunTime:0.000932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17018833 LIMIT 5 [ RunTime:0.006797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17018833 ORDER BY `minOrder` ASC [ RunTime:0.001133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17018833 ORDER BY `unit` DESC [ RunTime:0.001568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17018833 LIMIT 2 [ RunTime:0.002069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17018833 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
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 '20004%' OR `brand` LIKE '20004%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005945s ]
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 '20004%' OR `brand` LIKE '20004%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58568235 LIMIT 5 [ RunTime:0.001368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58568235 ORDER BY `minOrder` ASC [ RunTime:0.004965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58568235 ORDER BY `unit` DESC [ RunTime:0.000631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58568235 LIMIT 2 [ RunTime:0.000435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58568235 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
select * from pdf where partno='20004' and brandshort='Excel Blades' limit 1 [ RunTime:0.008628s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002134s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20004' OR `brand` LIKE 'Excel Blades%' ) ) LIMIT 1 [ RunTime:0.003185s ]
SELECT `id` FROM `stock` WHERE `id` <> 58568235 AND `partno` = '20004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%excel blades%' ) [ RunTime:0.000909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58557497 LIMIT 5 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58557497 ORDER BY `minOrder` ASC [ RunTime:0.001129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58557497 ORDER BY `unit` DESC [ RunTime:0.001759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58557497 LIMIT 2 [ RunTime:0.006512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58557497 ORDER BY `minOrder` ASC [ RunTime:0.002421s ]
select * from pdf where partno='200048EINS' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.018669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '200048EINS' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.000669s ]
SELECT `id` FROM `stock` WHERE `id` <> 58557497 AND `partno` = '200048EINS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.006471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16995399 [ RunTime:0.002702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64705669 LIMIT 5 [ RunTime:0.001016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64705669 ORDER BY `minOrder` ASC [ RunTime:0.001437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64705669 ORDER BY `unit` DESC [ RunTime:0.005247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64705669 LIMIT 2 [ RunTime:0.004968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64705669 ORDER BY `minOrder` ASC [ RunTime:0.000987s ]
select * from pdf where partno='20004807-01' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.000886s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20004807-01' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.004153s ]
SELECT `id` FROM `stock` WHERE `id` <> 64705669 AND `partno` = '20004807-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.008355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64705668 LIMIT 5 [ RunTime:0.021574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64705668 ORDER BY `minOrder` ASC [ RunTime:0.019100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64705668 ORDER BY `unit` DESC [ RunTime:0.002429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64705668 LIMIT 2 [ RunTime:0.000618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64705668 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
select * from pdf where partno='20004807-02' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.001072s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20004807-02' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.006900s ]
SELECT `id` FROM `stock` WHERE `id` <> 64705668 AND `partno` = '20004807-02' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.005535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64686857 LIMIT 5 [ RunTime:0.000522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64686857 ORDER BY `minOrder` ASC [ RunTime:0.011672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64686857 ORDER BY `unit` DESC [ RunTime:0.010085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64686857 LIMIT 2 [ RunTime:0.032854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64686857 ORDER BY `minOrder` ASC [ RunTime:0.012273s ]
select * from pdf where partno='20004709-09' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.021131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20004709-09' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.013118s ]
SELECT `id` FROM `stock` WHERE `id` <> 64686857 AND `partno` = '20004709-09' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.074003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63505699 LIMIT 5 [ RunTime:0.039440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505699 ORDER BY `minOrder` ASC [ RunTime:0.032637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63505699 ORDER BY `unit` DESC [ RunTime:0.015246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63505699 LIMIT 2 [ RunTime:0.017495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505699 ORDER BY `minOrder` ASC [ RunTime:0.003282s ]
select * from pdf where partno='20004559-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.029679s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20004559-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.028733s ]
SELECT `id` FROM `stock` WHERE `id` <> 63505699 AND `partno` = '20004559-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.019026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18932088 [ RunTime:0.023212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63505698 LIMIT 5 [ RunTime:0.006525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505698 ORDER BY `minOrder` ASC [ RunTime:0.013601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63505698 ORDER BY `unit` DESC [ RunTime:0.010412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63505698 LIMIT 2 [ RunTime:0.037172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505698 ORDER BY `minOrder` ASC [ RunTime:0.000923s ]
select * from pdf where partno='20004563-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.001203s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20004563-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.008662s ]
SELECT `id` FROM `stock` WHERE `id` <> 63505698 AND `partno` = '20004563-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.016657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18932086 [ RunTime:0.007277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63505697 LIMIT 5 [ RunTime:0.002354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505697 ORDER BY `minOrder` ASC [ RunTime:0.000930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63505697 ORDER BY `unit` DESC [ RunTime:0.000667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63505697 LIMIT 2 [ RunTime:0.010259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505697 ORDER BY `minOrder` ASC [ RunTime:0.002391s ]
select * from pdf where partno='20004557-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.002785s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20004557-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.006107s ]
SELECT `id` FROM `stock` WHERE `id` <> 63505697 AND `partno` = '20004557-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.014499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18932085 [ RunTime:0.003183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63505696 LIMIT 5 [ RunTime:0.018505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505696 ORDER BY `minOrder` ASC [ RunTime:0.000817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63505696 ORDER BY `unit` DESC [ RunTime:0.000715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63505696 LIMIT 2 [ RunTime:0.009991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505696 ORDER BY `minOrder` ASC [ RunTime:0.014336s ]
select * from pdf where partno='20004558-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.001127s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20004558-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.009453s ]
SELECT `id` FROM `stock` WHERE `id` <> 63505696 AND `partno` = '20004558-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.007000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18932084 [ RunTime:0.002223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63505695 LIMIT 5 [ RunTime:0.003147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505695 ORDER BY `minOrder` ASC [ RunTime:0.009179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63505695 ORDER BY `unit` DESC [ RunTime:0.004319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63505695 LIMIT 2 [ RunTime:0.000659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505695 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
select * from pdf where partno='20004560-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.001124s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20004560-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.005841s ]
SELECT `id` FROM `stock` WHERE `id` <> 63505695 AND `partno` = '20004560-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.012526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18932083 [ RunTime:0.009020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63505622 LIMIT 5 [ RunTime:0.001116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505622 ORDER BY `minOrder` ASC [ RunTime:0.000790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63505622 ORDER BY `unit` DESC [ RunTime:0.000755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63505622 LIMIT 2 [ RunTime:0.000661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505622 ORDER BY `minOrder` ASC [ RunTime:0.000776s ]
select * from pdf where partno='20004551-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.011363s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20004551-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.004986s ]
SELECT `id` FROM `stock` WHERE `id` <> 63505622 AND `partno` = '20004551-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.025411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17038697 [ RunTime:0.003157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63505621 LIMIT 5 [ RunTime:0.011500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505621 ORDER BY `minOrder` ASC [ RunTime:0.005077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63505621 ORDER BY `unit` DESC [ RunTime:0.003604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63505621 LIMIT 2 [ RunTime:0.001000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505621 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
select * from pdf where partno='20004553-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.001801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20004553-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.000816s ]
SELECT `id` FROM `stock` WHERE `id` <> 63505621 AND `partno` = '20004553-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.000819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14192462 [ RunTime:0.008025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63505620 LIMIT 5 [ RunTime:0.000889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505620 ORDER BY `minOrder` ASC [ RunTime:0.002053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63505620 ORDER BY `unit` DESC [ RunTime:0.001912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63505620 LIMIT 2 [ RunTime:0.004794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505620 ORDER BY `minOrder` ASC [ RunTime:0.000572s ]
select * from pdf where partno='20004554-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.002977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20004554-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.000807s ]
SELECT `id` FROM `stock` WHERE `id` <> 63505620 AND `partno` = '20004554-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.000743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18932059 [ RunTime:0.000542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63505619 LIMIT 5 [ RunTime:0.002973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505619 ORDER BY `minOrder` ASC [ RunTime:0.004191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63505619 ORDER BY `unit` DESC [ RunTime:0.000509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63505619 LIMIT 2 [ RunTime:0.000533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505619 ORDER BY `minOrder` ASC [ RunTime:0.000256s ]
select * from pdf where partno='20004549-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.000664s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20004549-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.002131s ]
SELECT `id` FROM `stock` WHERE `id` <> 63505619 AND `partno` = '20004549-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.001180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18932058 [ RunTime:0.001698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63505618 LIMIT 5 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505618 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63505618 ORDER BY `unit` DESC [ RunTime:0.001571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63505618 LIMIT 2 [ RunTime:0.006306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505618 ORDER BY `minOrder` ASC [ RunTime:0.000272s ]
select * from pdf where partno='20004545-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.000731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20004545-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.000630s ]
SELECT `id` FROM `stock` WHERE `id` <> 63505618 AND `partno` = '20004545-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.008173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18932057 [ RunTime:0.000643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63505617 LIMIT 5 [ RunTime:0.000471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505617 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63505617 ORDER BY `unit` DESC [ RunTime:0.005147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63505617 LIMIT 2 [ RunTime:0.000734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505617 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
select * from pdf where partno='20004522-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.000765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20004522-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.000689s ]
SELECT `id` FROM `stock` WHERE `id` <> 63505617 AND `partno` = '20004522-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.000738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18932056 [ RunTime:0.000470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63505616 LIMIT 5 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505616 ORDER BY `minOrder` ASC [ RunTime:0.003259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63505616 ORDER BY `unit` DESC [ RunTime:0.003006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63505616 LIMIT 2 [ RunTime:0.000482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505616 ORDER BY `minOrder` ASC [ RunTime:0.000279s ]
select * from pdf where partno='20004546-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.000792s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20004546-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.002511s ]
SELECT `id` FROM `stock` WHERE `id` <> 63505616 AND `partno` = '20004546-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.018247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14192461 [ RunTime:0.008728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63505615 LIMIT 5 [ RunTime:0.005057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505615 ORDER BY `minOrder` ASC [ RunTime:0.006276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63505615 ORDER BY `unit` DESC [ RunTime:0.005925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63505615 LIMIT 2 [ RunTime:0.004373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63505615 ORDER BY `minOrder` ASC [ RunTime:0.000996s ]
select * from pdf where partno='20004552-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.004278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20004552-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.012800s ]
SELECT `id` FROM `stock` WHERE `id` <> 63505615 AND `partno` = '20004552-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.023313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15255068 [ RunTime:0.015732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63327075 LIMIT 5 [ RunTime:0.006897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63327075 ORDER BY `minOrder` ASC [ RunTime:0.013929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63327075 ORDER BY `unit` DESC [ RunTime:0.014808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63327075 LIMIT 2 [ RunTime:0.001689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63327075 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
select * from pdf where partno='20004835-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.000978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20004835-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.005522s ]
SELECT `id` FROM `stock` WHERE `id` <> 63327075 AND `partno` = '20004835-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.003277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63327074 LIMIT 5 [ RunTime:0.003139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63327074 ORDER BY `minOrder` ASC [ RunTime:0.005860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63327074 ORDER BY `unit` DESC [ RunTime:0.006196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63327074 LIMIT 2 [ RunTime:0.003319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63327074 ORDER BY `minOrder` ASC [ RunTime:0.003036s ]
select * from pdf where partno='20004146-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.001998s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20004146-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.002529s ]
SELECT `id` FROM `stock` WHERE `id` <> 63327074 AND `partno` = '20004146-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.001076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13372153 [ RunTime:0.002812s ]
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 '20004%' OR `brand` LIKE '20004%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008676s ]
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 '20004%' OR `brand` LIKE '20004%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007513s ]
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 '20004%' OR `brand` LIKE '20004%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002523s ]
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 '20004%' OR `brand` LIKE '20004%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001750s ]
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 '20004%' OR `brand` LIKE '20004%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002104s ]
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 '20004%' OR `brand` LIKE '20004%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002696s ]
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 '20004%' OR `brand` LIKE '20004%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001421s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '20004%' OR `brand` LIKE '20004%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005181s ]