SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001397s ]
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 '01070%' OR `brand` LIKE '01070%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017441s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770173 LIMIT 5 [ RunTime:0.017499s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770173 ORDER BY `minOrder` ASC [ RunTime:0.010996s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18770173 ORDER BY `unit` DESC [ RunTime:0.007834s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.012292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18770173 LIMIT 2 [ RunTime:0.002936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770173 ORDER BY `minOrder` ASC [ RunTime:0.004402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770178 LIMIT 5 [ RunTime:0.005182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770178 ORDER BY `minOrder` ASC [ RunTime:0.013618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18770178 ORDER BY `unit` DESC [ RunTime:0.007093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18770178 LIMIT 2 [ RunTime:0.015123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770178 ORDER BY `minOrder` ASC [ RunTime:0.007433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770177 LIMIT 5 [ RunTime:0.040548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770177 ORDER BY `minOrder` ASC [ RunTime:0.033089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18770177 ORDER BY `unit` DESC [ RunTime:0.015241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18770177 LIMIT 2 [ RunTime:0.054984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770177 ORDER BY `minOrder` ASC [ RunTime:0.015437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223891 LIMIT 5 [ RunTime:0.052230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223891 ORDER BY `minOrder` ASC [ RunTime:0.047403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15223891 ORDER BY `unit` DESC [ RunTime:0.078733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15223891 LIMIT 2 [ RunTime:0.030656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223891 ORDER BY `minOrder` ASC [ RunTime:0.040768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770219 LIMIT 5 [ RunTime:0.032962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770219 ORDER BY `minOrder` ASC [ RunTime:0.092706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18770219 ORDER BY `unit` DESC [ RunTime:0.098281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18770219 LIMIT 2 [ RunTime:0.024320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770219 ORDER BY `minOrder` ASC [ RunTime:0.118784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770180 LIMIT 5 [ RunTime:0.046680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770180 ORDER BY `minOrder` ASC [ RunTime:0.045122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18770180 ORDER BY `unit` DESC [ RunTime:0.079524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18770180 LIMIT 2 [ RunTime:0.081425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770180 ORDER BY `minOrder` ASC [ RunTime:0.032963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223892 LIMIT 5 [ RunTime:0.046455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223892 ORDER BY `minOrder` ASC [ RunTime:0.123600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15223892 ORDER BY `unit` DESC [ RunTime:0.072333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15223892 LIMIT 2 [ RunTime:0.062400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223892 ORDER BY `minOrder` ASC [ RunTime:0.054711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774924 LIMIT 5 [ RunTime:0.051435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774924 ORDER BY `minOrder` ASC [ RunTime:0.109701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18774924 ORDER BY `unit` DESC [ RunTime:0.070191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18774924 LIMIT 2 [ RunTime:0.140752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774924 ORDER BY `minOrder` ASC [ RunTime:0.042578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774901 LIMIT 5 [ RunTime:0.066584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774901 ORDER BY `minOrder` ASC [ RunTime:0.156049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18774901 ORDER BY `unit` DESC [ RunTime:0.063505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18774901 LIMIT 2 [ RunTime:0.061872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774901 ORDER BY `minOrder` ASC [ RunTime:0.100781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15222895 LIMIT 5 [ RunTime:0.120640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15222895 ORDER BY `minOrder` ASC [ RunTime:0.030751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15222895 ORDER BY `unit` DESC [ RunTime:0.067186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15222895 LIMIT 2 [ RunTime:0.121317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15222895 ORDER BY `minOrder` ASC [ RunTime:0.008651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774906 LIMIT 5 [ RunTime:0.051062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774906 ORDER BY `minOrder` ASC [ RunTime:0.027558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18774906 ORDER BY `unit` DESC [ RunTime:0.060102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18774906 LIMIT 2 [ RunTime:0.068494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774906 ORDER BY `minOrder` ASC [ RunTime:0.039423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772559 LIMIT 5 [ RunTime:0.065749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772559 ORDER BY `minOrder` ASC [ RunTime:0.053263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18772559 ORDER BY `unit` DESC [ RunTime:0.023815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18772559 LIMIT 2 [ RunTime:0.015406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772559 ORDER BY `minOrder` ASC [ RunTime:0.013400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772558 LIMIT 5 [ RunTime:0.019047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772558 ORDER BY `minOrder` ASC [ RunTime:0.005849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18772558 ORDER BY `unit` DESC [ RunTime:0.019153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18772558 LIMIT 2 [ RunTime:0.016206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772558 ORDER BY `minOrder` ASC [ RunTime:0.012072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770947 LIMIT 5 [ RunTime:0.002917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770947 ORDER BY `minOrder` ASC [ RunTime:0.009578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18770947 ORDER BY `unit` DESC [ RunTime:0.024376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18770947 LIMIT 2 [ RunTime:0.011956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770947 ORDER BY `minOrder` ASC [ RunTime:0.001361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770946 LIMIT 5 [ RunTime:0.001713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770946 ORDER BY `minOrder` ASC [ RunTime:0.000493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18770946 ORDER BY `unit` DESC [ RunTime:0.022610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18770946 LIMIT 2 [ RunTime:0.028300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770946 ORDER BY `minOrder` ASC [ RunTime:0.039098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770943 LIMIT 5 [ RunTime:0.026387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770943 ORDER BY `minOrder` ASC [ RunTime:0.023256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18770943 ORDER BY `unit` DESC [ RunTime:0.041786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18770943 LIMIT 2 [ RunTime:0.023514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770943 ORDER BY `minOrder` ASC [ RunTime:0.034353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770179 LIMIT 5 [ RunTime:0.071046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770179 ORDER BY `minOrder` ASC [ RunTime:0.021105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18770179 ORDER BY `unit` DESC [ RunTime:0.038052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18770179 LIMIT 2 [ RunTime:0.036796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18770179 ORDER BY `minOrder` ASC [ RunTime:0.031434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17010483 LIMIT 5 [ RunTime:0.066038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17010483 ORDER BY `minOrder` ASC [ RunTime:0.032335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17010483 ORDER BY `unit` DESC [ RunTime:0.059899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17010483 LIMIT 2 [ RunTime:0.016228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17010483 ORDER BY `minOrder` ASC [ RunTime:0.002213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223049 LIMIT 5 [ RunTime:0.021222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223049 ORDER BY `minOrder` ASC [ RunTime:0.060351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15223049 ORDER BY `unit` DESC [ RunTime:0.112468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15223049 LIMIT 2 [ RunTime:0.031685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223049 ORDER BY `minOrder` ASC [ RunTime:0.036073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15222593 LIMIT 5 [ RunTime:0.117036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15222593 ORDER BY `minOrder` ASC [ RunTime:0.107742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15222593 ORDER BY `unit` DESC [ RunTime:0.095465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15222593 LIMIT 2 [ RunTime:0.052561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15222593 ORDER BY `minOrder` ASC [ RunTime:0.053796s ]
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 '01070%' OR `brand` LIKE '01070%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.142983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51127980 LIMIT 5 [ RunTime:0.071324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51127980 ORDER BY `minOrder` ASC [ RunTime:0.147841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51127980 ORDER BY `unit` DESC [ RunTime:0.124026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51127980 LIMIT 2 [ RunTime:0.048651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51127980 ORDER BY `minOrder` ASC [ RunTime:0.002967s ]
select * from pdf where partno='01070-1265' and brandshort='bei sensors' limit 1 [ RunTime:0.022947s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002285s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-1265' OR `brand` LIKE 'bei sensors%' ) ) LIMIT 1 [ RunTime:0.031441s ]
SELECT `id` FROM `stock` WHERE `id` <> 51127980 AND `partno` = '01070-1265' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bei sensors%' ) [ RunTime:0.014908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51128286 LIMIT 5 [ RunTime:0.029939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51128286 ORDER BY `minOrder` ASC [ RunTime:0.013563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51128286 ORDER BY `unit` DESC [ RunTime:0.000472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51128286 LIMIT 2 [ RunTime:0.017263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51128286 ORDER BY `minOrder` ASC [ RunTime:0.020809s ]
select * from pdf where partno='01070-1680' and brandshort='bei sensors' limit 1 [ RunTime:0.024257s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-1680' OR `brand` LIKE 'bei sensors%' ) ) LIMIT 1 [ RunTime:0.021883s ]
SELECT `id` FROM `stock` WHERE `id` <> 51128286 AND `partno` = '01070-1680' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bei sensors%' ) [ RunTime:0.042763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51128708 LIMIT 5 [ RunTime:0.023201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51128708 ORDER BY `minOrder` ASC [ RunTime:0.014269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51128708 ORDER BY `unit` DESC [ RunTime:0.014151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51128708 LIMIT 2 [ RunTime:0.012655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51128708 ORDER BY `minOrder` ASC [ RunTime:0.007285s ]
select * from pdf where partno='01070-154' and brandshort='bei sensors' limit 1 [ RunTime:0.050428s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-154' OR `brand` LIKE 'bei sensors%' ) ) LIMIT 1 [ RunTime:0.039871s ]
SELECT `id` FROM `stock` WHERE `id` <> 51128708 AND `partno` = '01070-154' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bei sensors%' ) [ RunTime:0.056313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51128136 LIMIT 5 [ RunTime:0.037843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51128136 ORDER BY `minOrder` ASC [ RunTime:0.016590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51128136 ORDER BY `unit` DESC [ RunTime:0.005497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51128136 LIMIT 2 [ RunTime:0.018270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51128136 ORDER BY `minOrder` ASC [ RunTime:0.032431s ]
select * from pdf where partno='01070-1395' and brandshort='bei sensors' limit 1 [ RunTime:0.030162s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-1395' OR `brand` LIKE 'bei sensors%' ) ) LIMIT 1 [ RunTime:0.007709s ]
SELECT `id` FROM `stock` WHERE `id` <> 51128136 AND `partno` = '01070-1395' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bei sensors%' ) [ RunTime:0.011248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51128158 LIMIT 5 [ RunTime:0.012885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51128158 ORDER BY `minOrder` ASC [ RunTime:0.021334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51128158 ORDER BY `unit` DESC [ RunTime:0.022588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51128158 LIMIT 2 [ RunTime:0.037245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51128158 ORDER BY `minOrder` ASC [ RunTime:0.003049s ]
select * from pdf where partno='01070-358' and brandshort='bei sensors' limit 1 [ RunTime:0.029405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-358' OR `brand` LIKE 'bei sensors%' ) ) LIMIT 1 [ RunTime:0.004493s ]
SELECT `id` FROM `stock` WHERE `id` <> 51128158 AND `partno` = '01070-358' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bei sensors%' ) [ RunTime:0.015294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51128306 LIMIT 5 [ RunTime:0.018067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51128306 ORDER BY `minOrder` ASC [ RunTime:0.001350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51128306 ORDER BY `unit` DESC [ RunTime:0.008484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51128306 LIMIT 2 [ RunTime:0.015403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51128306 ORDER BY `minOrder` ASC [ RunTime:0.005062s ]
select * from pdf where partno='01070-948' and brandshort='bei sensors' limit 1 [ RunTime:0.001912s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-948' OR `brand` LIKE 'bei sensors%' ) ) LIMIT 1 [ RunTime:0.004406s ]
SELECT `id` FROM `stock` WHERE `id` <> 51128306 AND `partno` = '01070-948' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bei sensors%' ) [ RunTime:0.052941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51128278 LIMIT 5 [ RunTime:0.061583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51128278 ORDER BY `minOrder` ASC [ RunTime:0.015669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51128278 ORDER BY `unit` DESC [ RunTime:0.029106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51128278 LIMIT 2 [ RunTime:0.001078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51128278 ORDER BY `minOrder` ASC [ RunTime:0.008129s ]
select * from pdf where partno='01070-583' and brandshort='bei sensors' limit 1 [ RunTime:0.022587s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-583' OR `brand` LIKE 'bei sensors%' ) ) LIMIT 1 [ RunTime:0.006315s ]
SELECT `id` FROM `stock` WHERE `id` <> 51128278 AND `partno` = '01070-583' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bei sensors%' ) [ RunTime:0.000894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51128274 LIMIT 5 [ RunTime:0.016704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51128274 ORDER BY `minOrder` ASC [ RunTime:0.014717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51128274 ORDER BY `unit` DESC [ RunTime:0.011254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51128274 LIMIT 2 [ RunTime:0.015297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51128274 ORDER BY `minOrder` ASC [ RunTime:0.017620s ]
select * from pdf where partno='01070-660' and brandshort='bei sensors' limit 1 [ RunTime:0.007784s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-660' OR `brand` LIKE 'bei sensors%' ) ) LIMIT 1 [ RunTime:0.000864s ]
SELECT `id` FROM `stock` WHERE `id` <> 51128274 AND `partno` = '01070-660' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bei sensors%' ) [ RunTime:0.003967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51128255 LIMIT 5 [ RunTime:0.016595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51128255 ORDER BY `minOrder` ASC [ RunTime:0.021889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51128255 ORDER BY `unit` DESC [ RunTime:0.012774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51128255 LIMIT 2 [ RunTime:0.005503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51128255 ORDER BY `minOrder` ASC [ RunTime:0.007473s ]
select * from pdf where partno='01070-581' and brandshort='bei sensors' limit 1 [ RunTime:0.010065s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-581' OR `brand` LIKE 'bei sensors%' ) ) LIMIT 1 [ RunTime:0.025447s ]
SELECT `id` FROM `stock` WHERE `id` <> 51128255 AND `partno` = '01070-581' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bei sensors%' ) [ RunTime:0.008091s ]
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 '01070%' OR `brand` LIKE '01070%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58199466 LIMIT 5 [ RunTime:0.006519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58199466 ORDER BY `minOrder` ASC [ RunTime:0.015041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58199466 ORDER BY `unit` DESC [ RunTime:0.016533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58199466 LIMIT 2 [ RunTime:0.018021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58199466 ORDER BY `minOrder` ASC [ RunTime:0.016166s ]
select * from pdf where partno='01070002Z' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.009851s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070002Z' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.008836s ]
SELECT `id` FROM `stock` WHERE `id` <> 58199466 AND `partno` = '01070002Z' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.005960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13816169 [ RunTime:0.025019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64797783 LIMIT 5 [ RunTime:0.016535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797783 ORDER BY `minOrder` ASC [ RunTime:0.025019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64797783 ORDER BY `unit` DESC [ RunTime:0.008406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64797783 LIMIT 2 [ RunTime:0.014686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797783 ORDER BY `minOrder` ASC [ RunTime:0.010593s ]
select * from pdf where partno='01070-156' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.012670s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-156' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.016559s ]
SELECT `id` FROM `stock` WHERE `id` <> 64797783 AND `partno` = '01070-156' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.012043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770177 [ RunTime:0.003790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64797782 LIMIT 5 [ RunTime:0.014800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797782 ORDER BY `minOrder` ASC [ RunTime:0.024357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64797782 ORDER BY `unit` DESC [ RunTime:0.012616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64797782 LIMIT 2 [ RunTime:0.017489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797782 ORDER BY `minOrder` ASC [ RunTime:0.011206s ]
select * from pdf where partno='01070-552' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.010104s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-552' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.050773s ]
SELECT `id` FROM `stock` WHERE `id` <> 64797782 AND `partno` = '01070-552' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.004675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774920 [ RunTime:0.004202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64797784 LIMIT 5 [ RunTime:0.013204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797784 ORDER BY `minOrder` ASC [ RunTime:0.023023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64797784 ORDER BY `unit` DESC [ RunTime:0.015009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64797784 LIMIT 2 [ RunTime:0.016094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797784 ORDER BY `minOrder` ASC [ RunTime:0.006241s ]
select * from pdf where partno='01070-1569' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.007821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-1569' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.002794s ]
SELECT `id` FROM `stock` WHERE `id` <> 64797784 AND `partno` = '01070-1569' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.001014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770178 [ RunTime:0.000531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64797778 LIMIT 5 [ RunTime:0.008259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797778 ORDER BY `minOrder` ASC [ RunTime:0.008386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64797778 ORDER BY `unit` DESC [ RunTime:0.006140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64797778 LIMIT 2 [ RunTime:0.025362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797778 ORDER BY `minOrder` ASC [ RunTime:0.004992s ]
select * from pdf where partno='01070-393' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.000830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-393' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.001123s ]
SELECT `id` FROM `stock` WHERE `id` <> 64797778 AND `partno` = '01070-393' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.000742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770173 [ RunTime:0.000613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64797777 LIMIT 5 [ RunTime:0.000545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797777 ORDER BY `minOrder` ASC [ RunTime:0.000582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64797777 ORDER BY `unit` DESC [ RunTime:0.011184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64797777 LIMIT 2 [ RunTime:0.006167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797777 ORDER BY `minOrder` ASC [ RunTime:0.002496s ]
select * from pdf where partno='01070-881' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.012385s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-881' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.006757s ]
SELECT `id` FROM `stock` WHERE `id` <> 64797777 AND `partno` = '01070-881' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.000683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770171 [ RunTime:0.001876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64797867 LIMIT 5 [ RunTime:0.000484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797867 ORDER BY `minOrder` ASC [ RunTime:0.000663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64797867 ORDER BY `unit` DESC [ RunTime:0.000258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64797867 LIMIT 2 [ RunTime:0.001730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797867 ORDER BY `minOrder` ASC [ RunTime:0.004502s ]
select * from pdf where partno='01070-926' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.000522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-926' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.003351s ]
SELECT `id` FROM `stock` WHERE `id` <> 64797867 AND `partno` = '01070-926' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.006525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774926 [ RunTime:0.000559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64798377 LIMIT 5 [ RunTime:0.002589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64798377 ORDER BY `minOrder` ASC [ RunTime:0.003994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64798377 ORDER BY `unit` DESC [ RunTime:0.003926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64798377 LIMIT 2 [ RunTime:0.000260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64798377 ORDER BY `minOrder` ASC [ RunTime:0.001597s ]
select * from pdf where partno='01070-761' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.006650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-761' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.001062s ]
SELECT `id` FROM `stock` WHERE `id` <> 64798377 AND `partno` = '01070-761' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.000759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223895 [ RunTime:0.000471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64798367 LIMIT 5 [ RunTime:0.001567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64798367 ORDER BY `minOrder` ASC [ RunTime:0.003843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64798367 ORDER BY `unit` DESC [ RunTime:0.001842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64798367 LIMIT 2 [ RunTime:0.000485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64798367 ORDER BY `minOrder` ASC [ RunTime:0.000923s ]
select * from pdf where partno='01070-951' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.000924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-951' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.000671s ]
SELECT `id` FROM `stock` WHERE `id` <> 64798367 AND `partno` = '01070-951' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.000660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774901 [ RunTime:0.002309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64798365 LIMIT 5 [ RunTime:0.006653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64798365 ORDER BY `minOrder` ASC [ RunTime:0.043810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64798365 ORDER BY `unit` DESC [ RunTime:0.001413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64798365 LIMIT 2 [ RunTime:0.000633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64798365 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
select * from pdf where partno='01070-1601' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.000648s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-1601' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.010954s ]
SELECT `id` FROM `stock` WHERE `id` <> 64798365 AND `partno` = '01070-1601' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.036244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223892 [ RunTime:0.014193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64797866 LIMIT 5 [ RunTime:0.057892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797866 ORDER BY `minOrder` ASC [ RunTime:0.007114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64797866 ORDER BY `unit` DESC [ RunTime:0.008836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64797866 LIMIT 2 [ RunTime:0.014110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797866 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
select * from pdf where partno='01070-925' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.006955s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-925' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.000945s ]
SELECT `id` FROM `stock` WHERE `id` <> 64797866 AND `partno` = '01070-925' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.002609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770179 [ RunTime:0.058865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64797856 LIMIT 5 [ RunTime:0.040970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797856 ORDER BY `minOrder` ASC [ RunTime:0.011707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64797856 ORDER BY `unit` DESC [ RunTime:0.011005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64797856 LIMIT 2 [ RunTime:0.003148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797856 ORDER BY `minOrder` ASC [ RunTime:0.004309s ]
select * from pdf where partno='01070-927' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.000672s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-927' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.000795s ]
SELECT `id` FROM `stock` WHERE `id` <> 64797856 AND `partno` = '01070-927' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.004514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775733 [ RunTime:0.019102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64797852 LIMIT 5 [ RunTime:0.006754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797852 ORDER BY `minOrder` ASC [ RunTime:0.001175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64797852 ORDER BY `unit` DESC [ RunTime:0.001241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64797852 LIMIT 2 [ RunTime:0.000520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797852 ORDER BY `minOrder` ASC [ RunTime:0.000586s ]
select * from pdf where partno='01070-1811' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.000586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-1811' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.004476s ]
SELECT `id` FROM `stock` WHERE `id` <> 64797852 AND `partno` = '01070-1811' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.005703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775727 [ RunTime:0.006889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64797786 LIMIT 5 [ RunTime:0.009102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797786 ORDER BY `minOrder` ASC [ RunTime:0.001931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64797786 ORDER BY `unit` DESC [ RunTime:0.007827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64797786 LIMIT 2 [ RunTime:0.006201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797786 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='01070-1281' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.002726s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-1281' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.000859s ]
SELECT `id` FROM `stock` WHERE `id` <> 64797786 AND `partno` = '01070-1281' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.000866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223898 [ RunTime:0.003275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64798364 LIMIT 5 [ RunTime:0.002533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64798364 ORDER BY `minOrder` ASC [ RunTime:0.000732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64798364 ORDER BY `unit` DESC [ RunTime:0.000647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64798364 LIMIT 2 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64798364 ORDER BY `minOrder` ASC [ RunTime:0.002319s ]
select * from pdf where partno='01070-1582' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.000898s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-1582' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.001644s ]
SELECT `id` FROM `stock` WHERE `id` <> 64798364 AND `partno` = '01070-1582' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.000923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223891 [ RunTime:0.000671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64797926 LIMIT 5 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797926 ORDER BY `minOrder` ASC [ RunTime:0.001874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64797926 ORDER BY `unit` DESC [ RunTime:0.002190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64797926 LIMIT 2 [ RunTime:0.007026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797926 ORDER BY `minOrder` ASC [ RunTime:0.001488s ]
select * from pdf where partno='01070-1002' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.000954s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-1002' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.007243s ]
SELECT `id` FROM `stock` WHERE `id` <> 64797926 AND `partno` = '01070-1002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.005959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772559 [ RunTime:0.006689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64797925 LIMIT 5 [ RunTime:0.002021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797925 ORDER BY `minOrder` ASC [ RunTime:0.008651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64797925 ORDER BY `unit` DESC [ RunTime:0.009559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64797925 LIMIT 2 [ RunTime:0.007382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797925 ORDER BY `minOrder` ASC [ RunTime:0.002308s ]
select * from pdf where partno='01070-1101' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.003746s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-1101' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.003477s ]
SELECT `id` FROM `stock` WHERE `id` <> 64797925 AND `partno` = '01070-1101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.017035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775716 [ RunTime:0.027876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64797868 LIMIT 5 [ RunTime:0.018468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797868 ORDER BY `minOrder` ASC [ RunTime:0.010089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64797868 ORDER BY `unit` DESC [ RunTime:0.027813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64797868 LIMIT 2 [ RunTime:0.000667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797868 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
select * from pdf where partno='01070-922' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.001049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-922' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.009902s ]
SELECT `id` FROM `stock` WHERE `id` <> 64797868 AND `partno` = '01070-922' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.007437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770947 [ RunTime:0.022798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64797864 LIMIT 5 [ RunTime:0.020024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797864 ORDER BY `minOrder` ASC [ RunTime:0.008774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64797864 ORDER BY `unit` DESC [ RunTime:0.036313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64797864 LIMIT 2 [ RunTime:0.036120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797864 ORDER BY `minOrder` ASC [ RunTime:0.007054s ]
select * from pdf where partno='01070-120' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.004038s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-120' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.008793s ]
SELECT `id` FROM `stock` WHERE `id` <> 64797864 AND `partno` = '01070-120' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.034073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15222744 [ RunTime:0.032283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64797862 LIMIT 5 [ RunTime:0.055104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797862 ORDER BY `minOrder` ASC [ RunTime:0.067785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64797862 ORDER BY `unit` DESC [ RunTime:0.058823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64797862 LIMIT 2 [ RunTime:0.043954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64797862 ORDER BY `minOrder` ASC [ RunTime:0.021525s ]
select * from pdf where partno='01070-358' and brandshort='Sensata-BEI Encoders' limit 1 [ RunTime:0.044558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01070-358' OR `brand` LIKE 'Sensata-BEI Encoders%' ) ) LIMIT 1 [ RunTime:0.060385s ]
SELECT `id` FROM `stock` WHERE `id` <> 64797862 AND `partno` = '01070-358' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sensata-bei encoders%' ) [ RunTime:0.034490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775739 [ RunTime:0.022134s ]
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 '01070%' OR `brand` LIKE '01070%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022470s ]
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 '01070%' OR `brand` LIKE '01070%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015271s ]
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 '01070%' OR `brand` LIKE '01070%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040914s ]
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 '01070%' OR `brand` LIKE '01070%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038366s ]
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 '01070%' OR `brand` LIKE '01070%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047513s ]
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 '01070%' OR `brand` LIKE '01070%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031762s ]
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 '01070%' OR `brand` LIKE '01070%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029969s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '01070%' OR `brand` LIKE '01070%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.032048s ]