SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001381s ]
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 '18575%' OR `brand` LIKE '18575%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009423s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265166 LIMIT 5 [ RunTime:0.008463s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265166 ORDER BY `minOrder` ASC [ RunTime:0.012805s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17265166 ORDER BY `unit` DESC [ RunTime:0.002453s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17265166 LIMIT 2 [ RunTime:0.022332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265166 ORDER BY `minOrder` ASC [ RunTime:0.004494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19663094 LIMIT 5 [ RunTime:0.011442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19663094 ORDER BY `minOrder` ASC [ RunTime:0.005411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19663094 ORDER BY `unit` DESC [ RunTime:0.010213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19663094 LIMIT 2 [ RunTime:0.020564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19663094 ORDER BY `minOrder` ASC [ RunTime:0.012922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19826408 LIMIT 5 [ RunTime:0.019035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19826408 ORDER BY `minOrder` ASC [ RunTime:0.009642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19826408 ORDER BY `unit` DESC [ RunTime:0.003060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19826408 LIMIT 2 [ RunTime:0.009678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19826408 ORDER BY `minOrder` ASC [ RunTime:0.007410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19571910 LIMIT 5 [ RunTime:0.010979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19571910 ORDER BY `minOrder` ASC [ RunTime:0.007499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19571910 ORDER BY `unit` DESC [ RunTime:0.010307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19571910 LIMIT 2 [ RunTime:0.007236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19571910 ORDER BY `minOrder` ASC [ RunTime:0.007251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19571908 LIMIT 5 [ RunTime:0.000719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19571908 ORDER BY `minOrder` ASC [ RunTime:0.007746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19571908 ORDER BY `unit` DESC [ RunTime:0.000694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19571908 LIMIT 2 [ RunTime:0.010567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19571908 ORDER BY `minOrder` ASC [ RunTime:0.006322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15439112 LIMIT 5 [ RunTime:0.011867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15439112 ORDER BY `minOrder` ASC [ RunTime:0.010331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15439112 ORDER BY `unit` DESC [ RunTime:0.005007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15439112 LIMIT 2 [ RunTime:0.005933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15439112 ORDER BY `minOrder` ASC [ RunTime:0.012286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14686240 LIMIT 5 [ RunTime:0.009794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14686240 ORDER BY `minOrder` ASC [ RunTime:0.005500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14686240 ORDER BY `unit` DESC [ RunTime:0.003580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14686240 LIMIT 2 [ RunTime:0.008214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14686240 ORDER BY `minOrder` ASC [ RunTime:0.009167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14682911 LIMIT 5 [ RunTime:0.004780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14682911 ORDER BY `minOrder` ASC [ RunTime:0.006216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14682911 ORDER BY `unit` DESC [ RunTime:0.003782s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14682911 LIMIT 2 [ RunTime:0.010843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14682911 ORDER BY `minOrder` ASC [ RunTime:0.011912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14679736 LIMIT 5 [ RunTime:0.004054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14679736 ORDER BY `minOrder` ASC [ RunTime:0.005947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14679736 ORDER BY `unit` DESC [ RunTime:0.008754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14679736 LIMIT 2 [ RunTime:0.010847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14679736 ORDER BY `minOrder` ASC [ RunTime:0.009791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14677527 LIMIT 5 [ RunTime:0.001243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14677527 ORDER BY `minOrder` ASC [ RunTime:0.005178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14677527 ORDER BY `unit` DESC [ RunTime:0.000768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14677527 LIMIT 2 [ RunTime:0.003927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14677527 ORDER BY `minOrder` ASC [ RunTime:0.007971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14677011 LIMIT 5 [ RunTime:0.001293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14677011 ORDER BY `minOrder` ASC [ RunTime:0.014596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14677011 ORDER BY `unit` DESC [ RunTime:0.002319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14677011 LIMIT 2 [ RunTime:0.012324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14677011 ORDER BY `minOrder` ASC [ RunTime:0.004027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14673708 LIMIT 5 [ RunTime:0.008170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14673708 ORDER BY `minOrder` ASC [ RunTime:0.011395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14673708 ORDER BY `unit` DESC [ RunTime:0.005623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14673708 LIMIT 2 [ RunTime:0.017344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14673708 ORDER BY `minOrder` ASC [ RunTime:0.003997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14673646 LIMIT 5 [ RunTime:0.003558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14673646 ORDER BY `minOrder` ASC [ RunTime:0.008333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14673646 ORDER BY `unit` DESC [ RunTime:0.004251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14673646 LIMIT 2 [ RunTime:0.004528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14673646 ORDER BY `minOrder` ASC [ RunTime:0.009886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13790154 LIMIT 5 [ RunTime:0.004162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13790154 ORDER BY `minOrder` ASC [ RunTime:0.003204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13790154 ORDER BY `unit` DESC [ RunTime:0.000768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13790154 LIMIT 2 [ RunTime:0.011057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13790154 ORDER BY `minOrder` ASC [ RunTime:0.008454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13789939 LIMIT 5 [ RunTime:0.003481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13789939 ORDER BY `minOrder` ASC [ RunTime:0.007338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13789939 ORDER BY `unit` DESC [ RunTime:0.000649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13789939 LIMIT 2 [ RunTime:0.003467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13789939 ORDER BY `minOrder` ASC [ RunTime:0.007199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13789397 LIMIT 5 [ RunTime:0.000872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13789397 ORDER BY `minOrder` ASC [ RunTime:0.002555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13789397 ORDER BY `unit` DESC [ RunTime:0.000430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13789397 LIMIT 2 [ RunTime:0.009436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13789397 ORDER BY `minOrder` ASC [ RunTime:0.002147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13272250 LIMIT 5 [ RunTime:0.006396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13272250 ORDER BY `minOrder` ASC [ RunTime:0.002509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13272250 ORDER BY `unit` DESC [ RunTime:0.000499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13272250 LIMIT 2 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13272250 ORDER BY `minOrder` ASC [ RunTime:0.007904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12830518 LIMIT 5 [ RunTime:0.000728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12830518 ORDER BY `minOrder` ASC [ RunTime:0.002601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12830518 ORDER BY `unit` DESC [ RunTime:0.000259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12830518 LIMIT 2 [ RunTime:0.000389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12830518 ORDER BY `minOrder` ASC [ RunTime:0.007482s ]
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 '18575%' OR `brand` LIKE '18575%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001335s ]
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 '18575%' OR `brand` LIKE '18575%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54121312 LIMIT 5 [ RunTime:0.000380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54121312 ORDER BY `minOrder` ASC [ RunTime:0.000525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54121312 ORDER BY `unit` DESC [ RunTime:0.000214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54121312 LIMIT 2 [ RunTime:0.000341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54121312 ORDER BY `minOrder` ASC [ RunTime:0.007788s ]
select * from pdf where partno='1857523-3' and brandshort='TE Connectivity' limit 1 [ RunTime:0.000441s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001423s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1857523-3' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.000296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54182300 LIMIT 5 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54182300 ORDER BY `minOrder` ASC [ RunTime:0.000941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54182300 ORDER BY `unit` DESC [ RunTime:0.000400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54182300 LIMIT 2 [ RunTime:0.007782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54182300 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
select * from pdf where partno='1857540000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1857540000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002009s ]
SELECT `id` FROM `stock` WHERE `id` <> 54182300 AND `partno` = '1857540000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19663094 [ RunTime:0.000383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55341005 LIMIT 5 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55341005 ORDER BY `minOrder` ASC [ RunTime:0.008387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55341005 ORDER BY `unit` DESC [ RunTime:0.000577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55341005 LIMIT 2 [ RunTime:0.000520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55341005 ORDER BY `minOrder` ASC [ RunTime:0.007473s ]
select * from pdf where partno='1857561000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000973s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1857561000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002316s ]
SELECT `id` FROM `stock` WHERE `id` <> 55341005 AND `partno` = '1857561000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14686240 [ RunTime:0.000702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55335485 LIMIT 5 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55335485 ORDER BY `minOrder` ASC [ RunTime:0.001117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55335485 ORDER BY `unit` DESC [ RunTime:0.000624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55335485 LIMIT 2 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55335485 ORDER BY `minOrder` ASC [ RunTime:0.000629s ]
select * from pdf where partno='1857551000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000914s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1857551000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002351s ]
SELECT `id` FROM `stock` WHERE `id` <> 55335485 AND `partno` = '1857551000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14682911 [ RunTime:0.000683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55330964 LIMIT 5 [ RunTime:0.000655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55330964 ORDER BY `minOrder` ASC [ RunTime:0.001098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55330964 ORDER BY `unit` DESC [ RunTime:0.000656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55330964 LIMIT 2 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55330964 ORDER BY `minOrder` ASC [ RunTime:0.000632s ]
select * from pdf where partno='1857560500' and brandshort='Weidmüller' limit 1 [ RunTime:0.000917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1857560500' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002491s ]
SELECT `id` FROM `stock` WHERE `id` <> 55330964 AND `partno` = '1857560500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14679736 [ RunTime:0.000681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55327993 LIMIT 5 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55327993 ORDER BY `minOrder` ASC [ RunTime:0.001071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55327993 ORDER BY `unit` DESC [ RunTime:0.000641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55327993 LIMIT 2 [ RunTime:0.001030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55327993 ORDER BY `minOrder` ASC [ RunTime:0.000635s ]
select * from pdf where partno='1857550500' and brandshort='Weidmüller' limit 1 [ RunTime:0.000905s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1857550500' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002625s ]
SELECT `id` FROM `stock` WHERE `id` <> 55327993 AND `partno` = '1857550500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14677527 [ RunTime:0.000683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55327316 LIMIT 5 [ RunTime:0.000642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55327316 ORDER BY `minOrder` ASC [ RunTime:0.001883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55327316 ORDER BY `unit` DESC [ RunTime:0.000668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55327316 LIMIT 2 [ RunTime:0.000618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55327316 ORDER BY `minOrder` ASC [ RunTime:0.000675s ]
select * from pdf where partno='1857560300' and brandshort='Weidmüller' limit 1 [ RunTime:0.000994s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1857560300' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003623s ]
SELECT `id` FROM `stock` WHERE `id` <> 55327316 AND `partno` = '1857560300' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14677011 [ RunTime:0.000777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55325493 LIMIT 5 [ RunTime:0.000695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55325493 ORDER BY `minOrder` ASC [ RunTime:0.001158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55325493 ORDER BY `unit` DESC [ RunTime:0.000706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55325493 LIMIT 2 [ RunTime:0.001699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55325493 ORDER BY `minOrder` ASC [ RunTime:0.000684s ]
select * from pdf where partno='1857550300' and brandshort='Weidmüller' limit 1 [ RunTime:0.000960s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1857550300' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003173s ]
SELECT `id` FROM `stock` WHERE `id` <> 55325493 AND `partno` = '1857550300' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13790154 [ RunTime:0.001837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55324917 LIMIT 5 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55324917 ORDER BY `minOrder` ASC [ RunTime:0.001612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55324917 ORDER BY `unit` DESC [ RunTime:0.000643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55324917 LIMIT 2 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55324917 ORDER BY `minOrder` ASC [ RunTime:0.001281s ]
select * from pdf where partno='1857560150' and brandshort='Weidmüller' limit 1 [ RunTime:0.000900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1857560150' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003952s ]
SELECT `id` FROM `stock` WHERE `id` <> 55324917 AND `partno` = '1857560150' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13789939 [ RunTime:0.000721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55323914 LIMIT 5 [ RunTime:0.000694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55323914 ORDER BY `minOrder` ASC [ RunTime:0.002435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55323914 ORDER BY `unit` DESC [ RunTime:0.000636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55323914 LIMIT 2 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55323914 ORDER BY `minOrder` ASC [ RunTime:0.002583s ]
select * from pdf where partno='1857550150' and brandshort='Weidmüller' limit 1 [ RunTime:0.000953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1857550150' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003784s ]
SELECT `id` FROM `stock` WHERE `id` <> 55323914 AND `partno` = '1857550150' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13789397 [ RunTime:0.000725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55322953 LIMIT 5 [ RunTime:0.000709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55322953 ORDER BY `minOrder` ASC [ RunTime:0.001083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55322953 ORDER BY `unit` DESC [ RunTime:0.000614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55322953 LIMIT 2 [ RunTime:0.002628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55322953 ORDER BY `minOrder` ASC [ RunTime:0.000646s ]
select * from pdf where partno='1857550030' and brandshort='Weidmüller' limit 1 [ RunTime:0.001015s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1857550030' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002982s ]
SELECT `id` FROM `stock` WHERE `id` <> 55322953 AND `partno` = '1857550030' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14673708 [ RunTime:0.000806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55322834 LIMIT 5 [ RunTime:0.000713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55322834 ORDER BY `minOrder` ASC [ RunTime:0.000846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55322834 ORDER BY `unit` DESC [ RunTime:0.003282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55322834 LIMIT 2 [ RunTime:0.002574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55322834 ORDER BY `minOrder` ASC [ RunTime:0.000595s ]
select * from pdf where partno='1857550010' and brandshort='Weidmüller' limit 1 [ RunTime:0.001129s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1857550010' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002302s ]
SELECT `id` FROM `stock` WHERE `id` <> 55322834 AND `partno` = '1857550010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14673646 [ RunTime:0.000693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53536266 LIMIT 5 [ RunTime:0.000664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53536266 ORDER BY `minOrder` ASC [ RunTime:0.003337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53536266 ORDER BY `unit` DESC [ RunTime:0.000692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53536266 LIMIT 2 [ RunTime:0.002552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53536266 ORDER BY `minOrder` ASC [ RunTime:0.000653s ]
select * from pdf where partno='1857547-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1857547-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002139s ]
SELECT `id` FROM `stock` WHERE `id` <> 53536266 AND `partno` = '1857547-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19571910 [ RunTime:0.000735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53536264 LIMIT 5 [ RunTime:0.007375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53536264 ORDER BY `minOrder` ASC [ RunTime:0.000633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53536264 ORDER BY `unit` DESC [ RunTime:0.000714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53536264 LIMIT 2 [ RunTime:0.002514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53536264 ORDER BY `minOrder` ASC [ RunTime:0.002241s ]
select * from pdf where partno='1857547-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001390s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1857547-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002293s ]
SELECT `id` FROM `stock` WHERE `id` <> 53536264 AND `partno` = '1857547-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19571908 [ RunTime:0.000735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53535399 LIMIT 5 [ RunTime:0.000621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53535399 ORDER BY `minOrder` ASC [ RunTime:0.000978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53535399 ORDER BY `unit` DESC [ RunTime:0.000363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53535399 LIMIT 2 [ RunTime:0.000532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53535399 ORDER BY `minOrder` ASC [ RunTime:0.003134s ]
select * from pdf where partno='1857523-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000482s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1857523-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000474s ]
SELECT `id` FROM `stock` WHERE `id` <> 53535399 AND `partno` = '1857523-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15439112 [ RunTime:0.000358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52628363 LIMIT 5 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52628363 ORDER BY `minOrder` ASC [ RunTime:0.003462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52628363 ORDER BY `unit` DESC [ RunTime:0.000660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52628363 LIMIT 2 [ RunTime:0.000562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52628363 ORDER BY `minOrder` ASC [ RunTime:0.002835s ]
select * from pdf where partno='1857567-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001175s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1857567-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000940s ]
SELECT `id` FROM `stock` WHERE `id` <> 52628363 AND `partno` = '1857567-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19826408 [ RunTime:0.000651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51902748 LIMIT 5 [ RunTime:0.000619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51902748 ORDER BY `minOrder` ASC [ RunTime:0.001114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51902748 ORDER BY `unit` DESC [ RunTime:0.000365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51902748 LIMIT 2 [ RunTime:0.000528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51902748 ORDER BY `minOrder` ASC [ RunTime:0.002759s ]
select * from pdf where partno='1857533-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1857533-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000378s ]
SELECT `id` FROM `stock` WHERE `id` <> 51902748 AND `partno` = '1857533-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12830518 [ RunTime:0.000363s ]
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 '18575%' OR `brand` LIKE '18575%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001180s ]
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 '18575%' OR `brand` LIKE '18575%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001015s ]
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 '18575%' OR `brand` LIKE '18575%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001083s ]
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 '18575%' OR `brand` LIKE '18575%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000972s ]
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 '18575%' OR `brand` LIKE '18575%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002324s ]
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 '18575%' OR `brand` LIKE '18575%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001317s ]
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 '18575%' OR `brand` LIKE '18575%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001649s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '18575%' OR `brand` LIKE '18575%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001404s ]