SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001400s ]
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 '19128%' OR `brand` LIKE '19128%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008725s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19644583 LIMIT 5 [ RunTime:0.018873s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.013855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19644583 ORDER BY `minOrder` ASC [ RunTime:0.012167s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19644583 ORDER BY `unit` DESC [ RunTime:0.001363s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19644583 LIMIT 2 [ RunTime:0.024840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19644583 ORDER BY `minOrder` ASC [ RunTime:0.026929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19652555 LIMIT 5 [ RunTime:0.085077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19652555 ORDER BY `minOrder` ASC [ RunTime:0.040355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19652555 ORDER BY `unit` DESC [ RunTime:0.040392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19652555 LIMIT 2 [ RunTime:0.056785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19652555 ORDER BY `minOrder` ASC [ RunTime:0.032049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650122 LIMIT 5 [ RunTime:0.064573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650122 ORDER BY `minOrder` ASC [ RunTime:0.032158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19650122 ORDER BY `unit` DESC [ RunTime:0.024899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19650122 LIMIT 2 [ RunTime:0.019553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650122 ORDER BY `minOrder` ASC [ RunTime:0.013980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19649033 LIMIT 5 [ RunTime:0.032739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19649033 ORDER BY `minOrder` ASC [ RunTime:0.026793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19649033 ORDER BY `unit` DESC [ RunTime:0.050749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19649033 LIMIT 2 [ RunTime:0.051051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19649033 ORDER BY `minOrder` ASC [ RunTime:0.026532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19648393 LIMIT 5 [ RunTime:0.026224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19648393 ORDER BY `minOrder` ASC [ RunTime:0.024868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19648393 ORDER BY `unit` DESC [ RunTime:0.030181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19648393 LIMIT 2 [ RunTime:0.019706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19648393 ORDER BY `minOrder` ASC [ RunTime:0.011328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19642367 LIMIT 5 [ RunTime:0.046037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19642367 ORDER BY `minOrder` ASC [ RunTime:0.032029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19642367 ORDER BY `unit` DESC [ RunTime:0.024201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19642367 LIMIT 2 [ RunTime:0.021177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19642367 ORDER BY `minOrder` ASC [ RunTime:0.014916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19636653 LIMIT 5 [ RunTime:0.021955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636653 ORDER BY `minOrder` ASC [ RunTime:0.022658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19636653 ORDER BY `unit` DESC [ RunTime:0.006672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19636653 LIMIT 2 [ RunTime:0.023876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636653 ORDER BY `minOrder` ASC [ RunTime:0.018905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634843 LIMIT 5 [ RunTime:0.007855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634843 ORDER BY `minOrder` ASC [ RunTime:0.004117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19634843 ORDER BY `unit` DESC [ RunTime:0.000686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19634843 LIMIT 2 [ RunTime:0.005419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634843 ORDER BY `minOrder` ASC [ RunTime:0.002947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19623927 LIMIT 5 [ RunTime:0.001195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19623927 ORDER BY `minOrder` ASC [ RunTime:0.003020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19623927 ORDER BY `unit` DESC [ RunTime:0.000660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19623927 LIMIT 2 [ RunTime:0.003146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19623927 ORDER BY `minOrder` ASC [ RunTime:0.002832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19621869 LIMIT 5 [ RunTime:0.007633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19621869 ORDER BY `minOrder` ASC [ RunTime:0.012299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19621869 ORDER BY `unit` DESC [ RunTime:0.005705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19621869 LIMIT 2 [ RunTime:0.009376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19621869 ORDER BY `minOrder` ASC [ RunTime:0.003443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17309902 LIMIT 5 [ RunTime:0.005690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17309902 ORDER BY `minOrder` ASC [ RunTime:0.003074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17309902 ORDER BY `unit` DESC [ RunTime:0.005735s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17309902 LIMIT 2 [ RunTime:0.005266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17309902 ORDER BY `minOrder` ASC [ RunTime:0.014274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17309034 LIMIT 5 [ RunTime:0.005077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17309034 ORDER BY `minOrder` ASC [ RunTime:0.002881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17309034 ORDER BY `unit` DESC [ RunTime:0.000644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17309034 LIMIT 2 [ RunTime:0.014122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17309034 ORDER BY `minOrder` ASC [ RunTime:0.012505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16427635 LIMIT 5 [ RunTime:0.003826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427635 ORDER BY `minOrder` ASC [ RunTime:0.002655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16427635 ORDER BY `unit` DESC [ RunTime:0.007993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16427635 LIMIT 2 [ RunTime:0.012245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427635 ORDER BY `minOrder` ASC [ RunTime:0.004972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14401379 LIMIT 5 [ RunTime:0.005297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14401379 ORDER BY `minOrder` ASC [ RunTime:0.009213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14401379 ORDER BY `unit` DESC [ RunTime:0.008861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14401379 LIMIT 2 [ RunTime:0.003024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14401379 ORDER BY `minOrder` ASC [ RunTime:0.007105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14401368 LIMIT 5 [ RunTime:0.002691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14401368 ORDER BY `minOrder` ASC [ RunTime:0.002420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14401368 ORDER BY `unit` DESC [ RunTime:0.007464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14401368 LIMIT 2 [ RunTime:0.011803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14401368 ORDER BY `minOrder` ASC [ RunTime:0.003203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13531632 LIMIT 5 [ RunTime:0.001132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13531632 ORDER BY `minOrder` ASC [ RunTime:0.002689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13531632 ORDER BY `unit` DESC [ RunTime:0.000639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13531632 LIMIT 2 [ RunTime:0.002867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13531632 ORDER BY `minOrder` ASC [ RunTime:0.002399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13310860 LIMIT 5 [ RunTime:0.001174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13310860 ORDER BY `minOrder` ASC [ RunTime:0.002505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13310860 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13310860 LIMIT 2 [ RunTime:0.000571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13310860 ORDER BY `minOrder` ASC [ RunTime:0.002763s ]
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 '19128%' OR `brand` LIKE '19128%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007101s ]
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 '19128%' OR `brand` LIKE '19128%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53665018 LIMIT 5 [ RunTime:0.001332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53665018 ORDER BY `minOrder` ASC [ RunTime:0.004303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53665018 ORDER BY `unit` DESC [ RunTime:0.000541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53665018 LIMIT 2 [ RunTime:0.004919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53665018 ORDER BY `minOrder` ASC [ RunTime:0.010123s ]
select * from pdf where partno='1912854' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003109s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912854' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53666660 LIMIT 5 [ RunTime:0.003707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53666660 ORDER BY `minOrder` ASC [ RunTime:0.001996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53666660 ORDER BY `unit` DESC [ RunTime:0.000544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53666660 LIMIT 2 [ RunTime:0.015971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53666660 ORDER BY `minOrder` ASC [ RunTime:0.007724s ]
select * from pdf where partno='1912867' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001511s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912867' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53729227 LIMIT 5 [ RunTime:0.004581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53729227 ORDER BY `minOrder` ASC [ RunTime:0.008434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53729227 ORDER BY `unit` DESC [ RunTime:0.005517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53729227 LIMIT 2 [ RunTime:0.009385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53729227 ORDER BY `minOrder` ASC [ RunTime:0.011834s ]
select * from pdf where partno='1912838' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.006148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912838' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.011626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53728063 LIMIT 5 [ RunTime:0.009491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53728063 ORDER BY `minOrder` ASC [ RunTime:0.009239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53728063 ORDER BY `unit` DESC [ RunTime:0.000829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53728063 LIMIT 2 [ RunTime:0.004180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53728063 ORDER BY `minOrder` ASC [ RunTime:0.002150s ]
select * from pdf where partno='1912825' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912825' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53727107 LIMIT 5 [ RunTime:0.004230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53727107 ORDER BY `minOrder` ASC [ RunTime:0.002819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53727107 ORDER BY `unit` DESC [ RunTime:0.004542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53727107 LIMIT 2 [ RunTime:0.002855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53727107 ORDER BY `minOrder` ASC [ RunTime:0.001753s ]
select * from pdf where partno='1912812' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.010305s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912812' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53724818 LIMIT 5 [ RunTime:0.003705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53724818 ORDER BY `minOrder` ASC [ RunTime:0.001616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53724818 ORDER BY `unit` DESC [ RunTime:0.000505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53724818 LIMIT 2 [ RunTime:0.001731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53724818 ORDER BY `minOrder` ASC [ RunTime:0.001642s ]
select * from pdf where partno='1912809' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912809' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53720286 LIMIT 5 [ RunTime:0.001850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53720286 ORDER BY `minOrder` ASC [ RunTime:0.001610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53720286 ORDER BY `unit` DESC [ RunTime:0.004699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53720286 LIMIT 2 [ RunTime:0.004791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53720286 ORDER BY `minOrder` ASC [ RunTime:0.001630s ]
select * from pdf where partno='1912896' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003922s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912896' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53719498 LIMIT 5 [ RunTime:0.004712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53719498 ORDER BY `minOrder` ASC [ RunTime:0.002446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53719498 ORDER BY `unit` DESC [ RunTime:0.008962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53719498 LIMIT 2 [ RunTime:0.012496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53719498 ORDER BY `minOrder` ASC [ RunTime:0.020583s ]
select * from pdf where partno='1912883' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.011287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912883' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53713074 LIMIT 5 [ RunTime:0.011011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53713074 ORDER BY `minOrder` ASC [ RunTime:0.002654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53713074 ORDER BY `unit` DESC [ RunTime:0.002559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53713074 LIMIT 2 [ RunTime:0.004526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53713074 ORDER BY `minOrder` ASC [ RunTime:0.000829s ]
select * from pdf where partno='1912870' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912870' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.017109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53668333 LIMIT 5 [ RunTime:0.010041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53668333 ORDER BY `minOrder` ASC [ RunTime:0.006069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53668333 ORDER BY `unit` DESC [ RunTime:0.006397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53668333 LIMIT 2 [ RunTime:0.008309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53668333 ORDER BY `minOrder` ASC [ RunTime:0.007502s ]
select * from pdf where partno='1912841' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005331s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912841' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.009058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49349466 LIMIT 5 [ RunTime:0.013579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49349466 ORDER BY `minOrder` ASC [ RunTime:0.008152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49349466 ORDER BY `unit` DESC [ RunTime:0.000641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49349466 LIMIT 2 [ RunTime:0.007976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49349466 ORDER BY `minOrder` ASC [ RunTime:0.003022s ]
select * from pdf where partno='1912820000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912820000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003955s ]
SELECT `id` FROM `stock` WHERE `id` <> 49349466 AND `partno` = '1912820000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.008933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13531632 [ RunTime:0.013559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49349411 LIMIT 5 [ RunTime:0.007614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49349411 ORDER BY `minOrder` ASC [ RunTime:0.008861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49349411 ORDER BY `unit` DESC [ RunTime:0.008715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49349411 LIMIT 2 [ RunTime:0.007075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49349411 ORDER BY `minOrder` ASC [ RunTime:0.001732s ]
select * from pdf where partno='1912810000' and brandshort='Weidmüller' limit 1 [ RunTime:0.008369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912810000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.017501s ]
SELECT `id` FROM `stock` WHERE `id` <> 49349411 AND `partno` = '1912810000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.013552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14401379 [ RunTime:0.002807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49349385 LIMIT 5 [ RunTime:0.009166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49349385 ORDER BY `minOrder` ASC [ RunTime:0.005882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49349385 ORDER BY `unit` DESC [ RunTime:0.001974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49349385 LIMIT 2 [ RunTime:0.002239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49349385 ORDER BY `minOrder` ASC [ RunTime:0.006625s ]
select * from pdf where partno='1912800000' and brandshort='Weidmüller' limit 1 [ RunTime:0.004070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912800000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.004091s ]
SELECT `id` FROM `stock` WHERE `id` <> 49349385 AND `partno` = '1912800000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.003715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14401368 [ RunTime:0.002086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49348965 LIMIT 5 [ RunTime:0.008095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348965 ORDER BY `minOrder` ASC [ RunTime:0.011783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49348965 ORDER BY `unit` DESC [ RunTime:0.003570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49348965 LIMIT 2 [ RunTime:0.012766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348965 ORDER BY `minOrder` ASC [ RunTime:0.005726s ]
select * from pdf where partno='1912880000' and brandshort='Weidmüller' limit 1 [ RunTime:0.014636s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912880000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.006609s ]
SELECT `id` FROM `stock` WHERE `id` <> 49348965 AND `partno` = '1912880000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.007850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36540830 [ RunTime:0.003371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49348932 LIMIT 5 [ RunTime:0.009288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348932 ORDER BY `minOrder` ASC [ RunTime:0.011501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49348932 ORDER BY `unit` DESC [ RunTime:0.002182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49348932 LIMIT 2 [ RunTime:0.009295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348932 ORDER BY `minOrder` ASC [ RunTime:0.004218s ]
select * from pdf where partno='1912870000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001919s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912870000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002206s ]
SELECT `id` FROM `stock` WHERE `id` <> 49348932 AND `partno` = '1912870000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.004585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36540797 [ RunTime:0.009685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49348884 LIMIT 5 [ RunTime:0.017464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348884 ORDER BY `minOrder` ASC [ RunTime:0.003308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49348884 ORDER BY `unit` DESC [ RunTime:0.003552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49348884 LIMIT 2 [ RunTime:0.015045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49348884 ORDER BY `minOrder` ASC [ RunTime:0.005988s ]
select * from pdf where partno='1912860000' and brandshort='Weidmüller' limit 1 [ RunTime:0.014201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912860000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.005826s ]
SELECT `id` FROM `stock` WHERE `id` <> 49348884 AND `partno` = '1912860000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.010052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36540751 [ RunTime:0.000752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49347425 LIMIT 5 [ RunTime:0.006956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49347425 ORDER BY `minOrder` ASC [ RunTime:0.006065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49347425 ORDER BY `unit` DESC [ RunTime:0.001150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49347425 LIMIT 2 [ RunTime:0.009739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49347425 ORDER BY `minOrder` ASC [ RunTime:0.007934s ]
select * from pdf where partno='1912830000' and brandshort='Weidmüller' limit 1 [ RunTime:0.005321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912830000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.011649s ]
SELECT `id` FROM `stock` WHERE `id` <> 49347425 AND `partno` = '1912830000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.004043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36539271 [ RunTime:0.001040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49347263 LIMIT 5 [ RunTime:0.005907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49347263 ORDER BY `minOrder` ASC [ RunTime:0.007505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49347263 ORDER BY `unit` DESC [ RunTime:0.006582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49347263 LIMIT 2 [ RunTime:0.002330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49347263 ORDER BY `minOrder` ASC [ RunTime:0.011559s ]
select * from pdf where partno='1912840000' and brandshort='Weidmüller' limit 1 [ RunTime:0.019893s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912840000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.029668s ]
SELECT `id` FROM `stock` WHERE `id` <> 49347263 AND `partno` = '1912840000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.051628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36539131 [ RunTime:0.039531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49333868 LIMIT 5 [ RunTime:0.020526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49333868 ORDER BY `minOrder` ASC [ RunTime:0.006130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49333868 ORDER BY `unit` DESC [ RunTime:0.020551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49333868 LIMIT 2 [ RunTime:0.010384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49333868 ORDER BY `minOrder` ASC [ RunTime:0.022634s ]
select * from pdf where partno='19128.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.008690s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19128.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.005767s ]
SELECT `id` FROM `stock` WHERE `id` <> 49333868 AND `partno` = '19128.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.014680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16427635 [ RunTime:0.009878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36541341 LIMIT 5 [ RunTime:0.006235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36541341 ORDER BY `minOrder` ASC [ RunTime:0.009153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36541341 ORDER BY `unit` DESC [ RunTime:0.009650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36541341 LIMIT 2 [ RunTime:0.010938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36541341 ORDER BY `minOrder` ASC [ RunTime:0.016549s ]
select * from pdf where partno='1912820000' and brandshort='Weidmüller' limit 1 [ RunTime:0.016920s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1912820000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.005300s ]
SELECT `id` FROM `stock` WHERE `id` <> 36541341 AND `partno` = '1912820000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.004769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13531632 [ RunTime:0.003476s ]
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 '19128%' OR `brand` LIKE '19128%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006662s ]
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 '19128%' OR `brand` LIKE '19128%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005325s ]
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 '19128%' OR `brand` LIKE '19128%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001897s ]
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 '19128%' OR `brand` LIKE '19128%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002569s ]
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 '19128%' OR `brand` LIKE '19128%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006270s ]
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 '19128%' OR `brand` LIKE '19128%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004491s ]
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 '19128%' OR `brand` LIKE '19128%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005931s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '19128%' OR `brand` LIKE '19128%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002813s ]