SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002259s ]
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 '14173%' OR `brand` LIKE '14173%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041420s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15561077 LIMIT 5 [ RunTime:0.039576s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.024234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15561077 ORDER BY `minOrder` ASC [ RunTime:0.028799s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15561077 ORDER BY `unit` DESC [ RunTime:0.023043s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15561077 LIMIT 2 [ RunTime:0.037485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15561077 ORDER BY `minOrder` ASC [ RunTime:0.014568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20121970 LIMIT 5 [ RunTime:0.051631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20121970 ORDER BY `minOrder` ASC [ RunTime:0.018606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20121970 ORDER BY `unit` DESC [ RunTime:0.060372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20121970 LIMIT 2 [ RunTime:0.026583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20121970 ORDER BY `minOrder` ASC [ RunTime:0.013628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15561087 LIMIT 5 [ RunTime:0.027069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15561087 ORDER BY `minOrder` ASC [ RunTime:0.040255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15561087 ORDER BY `unit` DESC [ RunTime:0.046608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15561087 LIMIT 2 [ RunTime:0.038759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15561087 ORDER BY `minOrder` ASC [ RunTime:0.007110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15561387 LIMIT 5 [ RunTime:0.012355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15561387 ORDER BY `minOrder` ASC [ RunTime:0.002536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15561387 ORDER BY `unit` DESC [ RunTime:0.005145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15561387 LIMIT 2 [ RunTime:0.025571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15561387 ORDER BY `minOrder` ASC [ RunTime:0.006859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17383202 LIMIT 5 [ RunTime:0.019241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17383202 ORDER BY `minOrder` ASC [ RunTime:0.013492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17383202 ORDER BY `unit` DESC [ RunTime:0.012840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17383202 LIMIT 2 [ RunTime:0.017764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17383202 ORDER BY `minOrder` ASC [ RunTime:0.012742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11854654 LIMIT 5 [ RunTime:0.019401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11854654 ORDER BY `minOrder` ASC [ RunTime:0.080048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11854654 ORDER BY `unit` DESC [ RunTime:0.020427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11854654 LIMIT 2 [ RunTime:0.036501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11854654 ORDER BY `minOrder` ASC [ RunTime:0.015357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17383713 LIMIT 5 [ RunTime:0.028334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17383713 ORDER BY `minOrder` ASC [ RunTime:0.026088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17383713 ORDER BY `unit` DESC [ RunTime:0.006938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17383713 LIMIT 2 [ RunTime:0.017012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17383713 ORDER BY `minOrder` ASC [ RunTime:0.030105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20122609 LIMIT 5 [ RunTime:0.037086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20122609 ORDER BY `minOrder` ASC [ RunTime:0.039066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20122609 ORDER BY `unit` DESC [ RunTime:0.029963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20122609 LIMIT 2 [ RunTime:0.024079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20122609 ORDER BY `minOrder` ASC [ RunTime:0.021407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16379555 LIMIT 5 [ RunTime:0.022005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16379555 ORDER BY `minOrder` ASC [ RunTime:0.021091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16379555 ORDER BY `unit` DESC [ RunTime:0.065295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16379555 LIMIT 2 [ RunTime:0.019319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16379555 ORDER BY `minOrder` ASC [ RunTime:0.012453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16379537 LIMIT 5 [ RunTime:0.028563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16379537 ORDER BY `minOrder` ASC [ RunTime:0.022092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16379537 ORDER BY `unit` DESC [ RunTime:0.011819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16379537 LIMIT 2 [ RunTime:0.006082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16379537 ORDER BY `minOrder` ASC [ RunTime:0.013842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16379724 LIMIT 5 [ RunTime:0.039859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16379724 ORDER BY `minOrder` ASC [ RunTime:0.007406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16379724 ORDER BY `unit` DESC [ RunTime:0.014463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16379724 LIMIT 2 [ RunTime:0.048519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16379724 ORDER BY `minOrder` ASC [ RunTime:0.024591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16379546 LIMIT 5 [ RunTime:0.010183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16379546 ORDER BY `minOrder` ASC [ RunTime:0.047040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16379546 ORDER BY `unit` DESC [ RunTime:0.035972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16379546 LIMIT 2 [ RunTime:0.020314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16379546 ORDER BY `minOrder` ASC [ RunTime:0.023513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15561084 LIMIT 5 [ RunTime:0.018102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15561084 ORDER BY `minOrder` ASC [ RunTime:0.017981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15561084 ORDER BY `unit` DESC [ RunTime:0.037792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15561084 LIMIT 2 [ RunTime:0.010193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15561084 ORDER BY `minOrder` ASC [ RunTime:0.003147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15560586 LIMIT 5 [ RunTime:0.007418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15560586 ORDER BY `minOrder` ASC [ RunTime:0.015954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15560586 ORDER BY `unit` DESC [ RunTime:0.007379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15560586 LIMIT 2 [ RunTime:0.006538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15560586 ORDER BY `minOrder` ASC [ RunTime:0.006407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19638182 LIMIT 5 [ RunTime:0.014266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638182 ORDER BY `minOrder` ASC [ RunTime:0.006225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19638182 ORDER BY `unit` DESC [ RunTime:0.016295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19638182 LIMIT 2 [ RunTime:0.008172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19638182 ORDER BY `minOrder` ASC [ RunTime:0.006458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634278 LIMIT 5 [ RunTime:0.004558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634278 ORDER BY `minOrder` ASC [ RunTime:0.006766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19634278 ORDER BY `unit` DESC [ RunTime:0.001257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19634278 LIMIT 2 [ RunTime:0.003282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634278 ORDER BY `minOrder` ASC [ RunTime:0.003612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634275 LIMIT 5 [ RunTime:0.006195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634275 ORDER BY `minOrder` ASC [ RunTime:0.005539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19634275 ORDER BY `unit` DESC [ RunTime:0.010707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19634275 LIMIT 2 [ RunTime:0.000816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634275 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634273 LIMIT 5 [ RunTime:0.000633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634273 ORDER BY `minOrder` ASC [ RunTime:0.005598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19634273 ORDER BY `unit` DESC [ RunTime:0.008207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19634273 LIMIT 2 [ RunTime:0.004102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634273 ORDER BY `minOrder` ASC [ RunTime:0.002056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19617278 LIMIT 5 [ RunTime:0.004438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19617278 ORDER BY `minOrder` ASC [ RunTime:0.007013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19617278 ORDER BY `unit` DESC [ RunTime:0.019530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19617278 LIMIT 2 [ RunTime:0.031960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19617278 ORDER BY `minOrder` ASC [ RunTime:0.006702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19024731 LIMIT 5 [ RunTime:0.025368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024731 ORDER BY `minOrder` ASC [ RunTime:0.004477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19024731 ORDER BY `unit` DESC [ RunTime:0.024206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19024731 LIMIT 2 [ RunTime:0.010746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19024731 ORDER BY `minOrder` ASC [ RunTime:0.001221s ]
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 '14173%' OR `brand` LIKE '14173%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51086344 LIMIT 5 [ RunTime:0.008475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086344 ORDER BY `minOrder` ASC [ RunTime:0.021597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51086344 ORDER BY `unit` DESC [ RunTime:0.000643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51086344 LIMIT 2 [ RunTime:0.008672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086344 ORDER BY `minOrder` ASC [ RunTime:0.002484s ]
select * from pdf where partno='1417389' and brandshort='phoenix contact' limit 1 [ RunTime:0.001675s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1417389' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.007845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51086658 LIMIT 5 [ RunTime:0.009993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086658 ORDER BY `minOrder` ASC [ RunTime:0.001565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51086658 ORDER BY `unit` DESC [ RunTime:0.005594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51086658 LIMIT 2 [ RunTime:0.004936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086658 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
select * from pdf where partno='1417302' and brandshort='phoenix contact' limit 1 [ RunTime:0.009655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1417302' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.008702s ]
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 '14173%' OR `brand` LIKE '14173%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53573727 LIMIT 5 [ RunTime:0.010697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53573727 ORDER BY `minOrder` ASC [ RunTime:0.007513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53573727 ORDER BY `unit` DESC [ RunTime:0.002457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53573727 LIMIT 2 [ RunTime:0.002846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53573727 ORDER BY `minOrder` ASC [ RunTime:0.005669s ]
select * from pdf where partno='1417372' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003389s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1417372' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53573831 LIMIT 5 [ RunTime:0.000410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53573831 ORDER BY `minOrder` ASC [ RunTime:0.004040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53573831 ORDER BY `unit` DESC [ RunTime:0.000796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53573831 LIMIT 2 [ RunTime:0.011204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53573831 ORDER BY `minOrder` ASC [ RunTime:0.003387s ]
select * from pdf where partno='1417373' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009928s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1417373' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.020208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53573746 LIMIT 5 [ RunTime:0.001488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53573746 ORDER BY `minOrder` ASC [ RunTime:0.004356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53573746 ORDER BY `unit` DESC [ RunTime:0.007712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53573746 LIMIT 2 [ RunTime:0.017707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53573746 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
select * from pdf where partno='1417389' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001022s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1417389' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53573921 LIMIT 5 [ RunTime:0.000487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53573921 ORDER BY `minOrder` ASC [ RunTime:0.005959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53573921 ORDER BY `unit` DESC [ RunTime:0.003475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53573921 LIMIT 2 [ RunTime:0.017340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53573921 ORDER BY `minOrder` ASC [ RunTime:0.011799s ]
select * from pdf where partno='1417390' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.023546s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1417390' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.018390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53574254 LIMIT 5 [ RunTime:0.019785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53574254 ORDER BY `minOrder` ASC [ RunTime:0.009920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53574254 ORDER BY `unit` DESC [ RunTime:0.020066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53574254 LIMIT 2 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53574254 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
select * from pdf where partno='1417387' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1417387' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.016073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53574308 LIMIT 5 [ RunTime:0.006496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53574308 ORDER BY `minOrder` ASC [ RunTime:0.014094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53574308 ORDER BY `unit` DESC [ RunTime:0.000727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53574308 LIMIT 2 [ RunTime:0.005989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53574308 ORDER BY `minOrder` ASC [ RunTime:0.001257s ]
select * from pdf where partno='1417392' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.008595s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1417392' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.015533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53574578 LIMIT 5 [ RunTime:0.022651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53574578 ORDER BY `minOrder` ASC [ RunTime:0.001794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53574578 ORDER BY `unit` DESC [ RunTime:0.003515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53574578 LIMIT 2 [ RunTime:0.001827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53574578 ORDER BY `minOrder` ASC [ RunTime:0.000717s ]
select * from pdf where partno='1417379' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1417379' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.013471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53580599 LIMIT 5 [ RunTime:0.009777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53580599 ORDER BY `minOrder` ASC [ RunTime:0.004385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53580599 ORDER BY `unit` DESC [ RunTime:0.001966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53580599 LIMIT 2 [ RunTime:0.009902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53580599 ORDER BY `minOrder` ASC [ RunTime:0.000580s ]
select * from pdf where partno='1417376' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004129s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1417376' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.009896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53581500 LIMIT 5 [ RunTime:0.010076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53581500 ORDER BY `minOrder` ASC [ RunTime:0.009187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53581500 ORDER BY `unit` DESC [ RunTime:0.023292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53581500 LIMIT 2 [ RunTime:0.005673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53581500 ORDER BY `minOrder` ASC [ RunTime:0.001663s ]
select * from pdf where partno='1417374' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.016845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1417374' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53575311 LIMIT 5 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53575311 ORDER BY `minOrder` ASC [ RunTime:0.000956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53575311 ORDER BY `unit` DESC [ RunTime:0.016155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53575311 LIMIT 2 [ RunTime:0.013748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53575311 ORDER BY `minOrder` ASC [ RunTime:0.007381s ]
select * from pdf where partno='1417371' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.006544s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1417371' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53574562 LIMIT 5 [ RunTime:0.023307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53574562 ORDER BY `minOrder` ASC [ RunTime:0.004751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53574562 ORDER BY `unit` DESC [ RunTime:0.008229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53574562 LIMIT 2 [ RunTime:0.004047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53574562 ORDER BY `minOrder` ASC [ RunTime:0.011692s ]
select * from pdf where partno='1417381' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.014300s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1417381' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.017619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49676834 LIMIT 5 [ RunTime:0.010292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49676834 ORDER BY `minOrder` ASC [ RunTime:0.007657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49676834 ORDER BY `unit` DESC [ RunTime:0.012473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49676834 LIMIT 2 [ RunTime:0.049662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49676834 ORDER BY `minOrder` ASC [ RunTime:0.002774s ]
select * from pdf where partno='14173' and brandshort='Desco' limit 1 [ RunTime:0.009863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '14173' OR `brand` LIKE 'Desco%' ) ) LIMIT 1 [ RunTime:0.032732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36870119 LIMIT 5 [ RunTime:0.008839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36870119 ORDER BY `minOrder` ASC [ RunTime:0.006206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36870119 ORDER BY `unit` DESC [ RunTime:0.013284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36870119 LIMIT 2 [ RunTime:0.007880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36870119 ORDER BY `minOrder` ASC [ RunTime:0.005897s ]
select * from pdf where partno='14173' and brandshort='Desco' limit 1 [ RunTime:0.000481s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '14173' OR `brand` LIKE 'Desco%' ) ) LIMIT 1 [ RunTime:0.000400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53575637 LIMIT 5 [ RunTime:0.017780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53575637 ORDER BY `minOrder` ASC [ RunTime:0.012795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53575637 ORDER BY `unit` DESC [ RunTime:0.013576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53575637 LIMIT 2 [ RunTime:0.008315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53575637 ORDER BY `minOrder` ASC [ RunTime:0.008838s ]
select * from pdf where partno='1417307' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.016311s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1417307' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.033255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53575577 LIMIT 5 [ RunTime:0.016855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53575577 ORDER BY `minOrder` ASC [ RunTime:0.009323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53575577 ORDER BY `unit` DESC [ RunTime:0.012800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53575577 LIMIT 2 [ RunTime:0.020939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53575577 ORDER BY `minOrder` ASC [ RunTime:0.020412s ]
select * from pdf where partno='1417302' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009389s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1417302' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.014733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53575570 LIMIT 5 [ RunTime:0.027152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53575570 ORDER BY `minOrder` ASC [ RunTime:0.016663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53575570 ORDER BY `unit` DESC [ RunTime:0.027233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53575570 LIMIT 2 [ RunTime:0.027050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53575570 ORDER BY `minOrder` ASC [ RunTime:0.031861s ]
select * from pdf where partno='1417303' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.024696s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1417303' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.025816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53575668 LIMIT 5 [ RunTime:0.041661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53575668 ORDER BY `minOrder` ASC [ RunTime:0.023153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53575668 ORDER BY `unit` DESC [ RunTime:0.008801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53575668 LIMIT 2 [ RunTime:0.021051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53575668 ORDER BY `minOrder` ASC [ RunTime:0.012242s ]
select * from pdf where partno='1417382' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.020413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1417382' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.026049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53575693 LIMIT 5 [ RunTime:0.017508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53575693 ORDER BY `minOrder` ASC [ RunTime:0.017161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53575693 ORDER BY `unit` DESC [ RunTime:0.005190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53575693 LIMIT 2 [ RunTime:0.033452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53575693 ORDER BY `minOrder` ASC [ RunTime:0.001843s ]
select * from pdf where partno='1417380' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1417380' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53575434 LIMIT 5 [ RunTime:0.009812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53575434 ORDER BY `minOrder` ASC [ RunTime:0.042120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53575434 ORDER BY `unit` DESC [ RunTime:0.010164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53575434 LIMIT 2 [ RunTime:0.007181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53575434 ORDER BY `minOrder` ASC [ RunTime:0.007252s ]
select * from pdf where partno='1417308' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.013526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1417308' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55368745 LIMIT 5 [ RunTime:0.024616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55368745 ORDER BY `minOrder` ASC [ RunTime:0.010816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55368745 ORDER BY `unit` DESC [ RunTime:0.004921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55368745 LIMIT 2 [ RunTime:0.007562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55368745 ORDER BY `minOrder` ASC [ RunTime:0.008847s ]
select * from pdf where partno='1417397' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.026968s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1417397' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.033456s ]
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 '14173%' OR `brand` LIKE '14173%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021017s ]
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 '14173%' OR `brand` LIKE '14173%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018057s ]
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 '14173%' OR `brand` LIKE '14173%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020736s ]
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 '14173%' OR `brand` LIKE '14173%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016270s ]
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 '14173%' OR `brand` LIKE '14173%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050146s ]
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 '14173%' OR `brand` LIKE '14173%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012510s ]
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 '14173%' OR `brand` LIKE '14173%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025862s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '14173%' OR `brand` LIKE '14173%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.045678s ]