SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003027s ]
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 '2985%' OR `brand` LIKE '2985%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033862s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12872709 LIMIT 5 [ RunTime:0.060385s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12872709 ORDER BY `minOrder` ASC [ RunTime:0.048827s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12872709 ORDER BY `unit` DESC [ RunTime:0.042067s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12872709 LIMIT 2 [ RunTime:0.060989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12872709 ORDER BY `minOrder` ASC [ RunTime:0.026785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880565 LIMIT 5 [ RunTime:0.042077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880565 ORDER BY `minOrder` ASC [ RunTime:0.033520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12880565 ORDER BY `unit` DESC [ RunTime:0.032223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12880565 LIMIT 2 [ RunTime:0.035389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880565 ORDER BY `minOrder` ASC [ RunTime:0.075522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14354880 LIMIT 5 [ RunTime:0.060332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14354880 ORDER BY `minOrder` ASC [ RunTime:0.019714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14354880 ORDER BY `unit` DESC [ RunTime:0.019399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14354880 LIMIT 2 [ RunTime:0.051948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14354880 ORDER BY `minOrder` ASC [ RunTime:0.021920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18851865 LIMIT 5 [ RunTime:0.025263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18851865 ORDER BY `minOrder` ASC [ RunTime:0.041609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18851865 ORDER BY `unit` DESC [ RunTime:0.048390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18851865 LIMIT 2 [ RunTime:0.011993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18851865 ORDER BY `minOrder` ASC [ RunTime:0.037699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18853208 LIMIT 5 [ RunTime:0.028324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18853208 ORDER BY `minOrder` ASC [ RunTime:0.021465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18853208 ORDER BY `unit` DESC [ RunTime:0.036250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18853208 LIMIT 2 [ RunTime:0.013112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18853208 ORDER BY `minOrder` ASC [ RunTime:0.017017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18851232 LIMIT 5 [ RunTime:0.027133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18851232 ORDER BY `minOrder` ASC [ RunTime:0.021880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18851232 ORDER BY `unit` DESC [ RunTime:0.007935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18851232 LIMIT 2 [ RunTime:0.024192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18851232 ORDER BY `minOrder` ASC [ RunTime:0.019406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18850772 LIMIT 5 [ RunTime:0.033995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18850772 ORDER BY `minOrder` ASC [ RunTime:0.021197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18850772 ORDER BY `unit` DESC [ RunTime:0.014562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18850772 LIMIT 2 [ RunTime:0.021365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18850772 ORDER BY `minOrder` ASC [ RunTime:0.013785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18850147 LIMIT 5 [ RunTime:0.005203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18850147 ORDER BY `minOrder` ASC [ RunTime:0.007080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18850147 ORDER BY `unit` DESC [ RunTime:0.009833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18850147 LIMIT 2 [ RunTime:0.006983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18850147 ORDER BY `minOrder` ASC [ RunTime:0.003030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18833956 LIMIT 5 [ RunTime:0.001238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18833956 ORDER BY `minOrder` ASC [ RunTime:0.001644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18833956 ORDER BY `unit` DESC [ RunTime:0.000670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18833956 LIMIT 2 [ RunTime:0.001916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18833956 ORDER BY `minOrder` ASC [ RunTime:0.001680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18833828 LIMIT 5 [ RunTime:0.001175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18833828 ORDER BY `minOrder` ASC [ RunTime:0.001485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18833828 ORDER BY `unit` DESC [ RunTime:0.000611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18833828 LIMIT 2 [ RunTime:0.001777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18833828 ORDER BY `minOrder` ASC [ RunTime:0.001511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18833775 LIMIT 5 [ RunTime:0.000622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18833775 ORDER BY `minOrder` ASC [ RunTime:0.001172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18833775 ORDER BY `unit` DESC [ RunTime:0.000603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18833775 LIMIT 2 [ RunTime:0.001662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18833775 ORDER BY `minOrder` ASC [ RunTime:0.001511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17023988 LIMIT 5 [ RunTime:0.001232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17023988 ORDER BY `minOrder` ASC [ RunTime:0.001590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17023988 ORDER BY `unit` DESC [ RunTime:0.000680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17023988 LIMIT 2 [ RunTime:0.001774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17023988 ORDER BY `minOrder` ASC [ RunTime:0.001478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15234935 LIMIT 5 [ RunTime:0.005463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15234935 ORDER BY `minOrder` ASC [ RunTime:0.001314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15234935 ORDER BY `unit` DESC [ RunTime:0.004324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15234935 LIMIT 2 [ RunTime:0.005172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15234935 ORDER BY `minOrder` ASC [ RunTime:0.005720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14186714 LIMIT 5 [ RunTime:0.004437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14186714 ORDER BY `minOrder` ASC [ RunTime:0.004541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14186714 ORDER BY `unit` DESC [ RunTime:0.004407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14186714 LIMIT 2 [ RunTime:0.005141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14186714 ORDER BY `minOrder` ASC [ RunTime:0.004962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13281167 LIMIT 5 [ RunTime:0.001051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281167 ORDER BY `minOrder` ASC [ RunTime:0.001461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13281167 ORDER BY `unit` DESC [ RunTime:0.000623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13281167 LIMIT 2 [ RunTime:0.001535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281167 ORDER BY `minOrder` ASC [ RunTime:0.001325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12564971 LIMIT 5 [ RunTime:0.001078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12564971 ORDER BY `minOrder` ASC [ RunTime:0.001105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12564971 ORDER BY `unit` DESC [ RunTime:0.000605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12564971 LIMIT 2 [ RunTime:0.005287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12564971 ORDER BY `minOrder` ASC [ RunTime:0.003474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12193487 LIMIT 5 [ RunTime:0.006508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12193487 ORDER BY `minOrder` ASC [ RunTime:0.000900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12193487 ORDER BY `unit` DESC [ RunTime:0.000633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12193487 LIMIT 2 [ RunTime:0.001632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12193487 ORDER BY `minOrder` ASC [ RunTime:0.001212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12193392 LIMIT 5 [ RunTime:0.000945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12193392 ORDER BY `minOrder` ASC [ RunTime:0.001213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12193392 ORDER BY `unit` DESC [ RunTime:0.000665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12193392 LIMIT 2 [ RunTime:0.003624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12193392 ORDER BY `minOrder` ASC [ RunTime:0.002030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11995382 LIMIT 5 [ RunTime:0.001005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11995382 ORDER BY `minOrder` ASC [ RunTime:0.005720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11995382 ORDER BY `unit` DESC [ RunTime:0.000660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11995382 LIMIT 2 [ RunTime:0.005794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11995382 ORDER BY `minOrder` ASC [ RunTime:0.002161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11994580 LIMIT 5 [ RunTime:0.004365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11994580 ORDER BY `minOrder` ASC [ RunTime:0.001450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11994580 ORDER BY `unit` DESC [ RunTime:0.000676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11994580 LIMIT 2 [ RunTime:0.002953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11994580 ORDER BY `minOrder` ASC [ RunTime:0.003695s ]
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 '2985%' OR `brand` LIKE '2985%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32274477 LIMIT 5 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32274477 ORDER BY `minOrder` ASC [ RunTime:0.006525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32274477 ORDER BY `unit` DESC [ RunTime:0.000807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32274477 LIMIT 2 [ RunTime:0.002710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32274477 ORDER BY `minOrder` ASC [ RunTime:0.000972s ]
select * from pdf where partno='2985-6036' and brandshort='amphenol / sv microwave' limit 1 [ RunTime:0.000885s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002238s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985-6036' OR `brand` LIKE 'amphenol / sv microwave%' ) ) LIMIT 1 [ RunTime:0.001215s ]
SELECT `id` FROM `stock` WHERE `id` <> 32274477 AND `partno` = '2985-6036' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol / sv microwave%' ) [ RunTime:0.002767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51088603 LIMIT 5 [ RunTime:0.000522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51088603 ORDER BY `minOrder` ASC [ RunTime:0.001293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51088603 ORDER BY `unit` DESC [ RunTime:0.000572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51088603 LIMIT 2 [ RunTime:0.000939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51088603 ORDER BY `minOrder` ASC [ RunTime:0.000750s ]
select * from pdf where partno='2985688' and brandshort='phoenix contact' limit 1 [ RunTime:0.000853s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985688' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.003327s ]
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 '2985%' OR `brand` LIKE '2985%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58306312 LIMIT 5 [ RunTime:0.001481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58306312 ORDER BY `minOrder` ASC [ RunTime:0.001534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58306312 ORDER BY `unit` DESC [ RunTime:0.000375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58306312 LIMIT 2 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58306312 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='2985' and brandshort='Pololu' limit 1 [ RunTime:0.002369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.003325s ]
SELECT `id` FROM `stock` WHERE `id` <> 58306312 AND `partno` = '2985' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.000566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14354880 [ RunTime:0.000351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61909750 LIMIT 5 [ RunTime:0.003374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909750 ORDER BY `minOrder` ASC [ RunTime:0.000997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61909750 ORDER BY `unit` DESC [ RunTime:0.000491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61909750 LIMIT 2 [ RunTime:0.000442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909750 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
select * from pdf where partno='2985-6038' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.001381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985-6038' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.000655s ]
SELECT `id` FROM `stock` WHERE `id` <> 61909750 AND `partno` = '2985-6038' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.000587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61909818 LIMIT 5 [ RunTime:0.003568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909818 ORDER BY `minOrder` ASC [ RunTime:0.001564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61909818 ORDER BY `unit` DESC [ RunTime:0.001132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61909818 LIMIT 2 [ RunTime:0.000401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909818 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
select * from pdf where partno='2985-6035' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.001086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985-6035' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.001047s ]
SELECT `id` FROM `stock` WHERE `id` <> 61909818 AND `partno` = '2985-6035' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.000451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61912864 LIMIT 5 [ RunTime:0.000374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61912864 ORDER BY `minOrder` ASC [ RunTime:0.000747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61912864 ORDER BY `unit` DESC [ RunTime:0.000376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61912864 LIMIT 2 [ RunTime:0.000368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61912864 ORDER BY `minOrder` ASC [ RunTime:0.000405s ]
select * from pdf where partno='2985-6037' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.003162s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985-6037' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.002769s ]
SELECT `id` FROM `stock` WHERE `id` <> 61912864 AND `partno` = '2985-6037' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.000487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880565 [ RunTime:0.000421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61914273 LIMIT 5 [ RunTime:0.000404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61914273 ORDER BY `minOrder` ASC [ RunTime:0.000878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61914273 ORDER BY `unit` DESC [ RunTime:0.000387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61914273 LIMIT 2 [ RunTime:0.000373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61914273 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
select * from pdf where partno='2985-6036' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.000720s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985-6036' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.002450s ]
SELECT `id` FROM `stock` WHERE `id` <> 61914273 AND `partno` = '2985-6036' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.002848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61912892 LIMIT 5 [ RunTime:0.000575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61912892 ORDER BY `minOrder` ASC [ RunTime:0.001710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61912892 ORDER BY `unit` DESC [ RunTime:0.000529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61912892 LIMIT 2 [ RunTime:0.001613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61912892 ORDER BY `minOrder` ASC [ RunTime:0.001422s ]
select * from pdf where partno='2985-6004' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.002790s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985-6004' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.000730s ]
SELECT `id` FROM `stock` WHERE `id` <> 61912892 AND `partno` = '2985-6004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.002759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12872709 [ RunTime:0.000609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64106416 LIMIT 5 [ RunTime:0.001182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64106416 ORDER BY `minOrder` ASC [ RunTime:0.002771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64106416 ORDER BY `unit` DESC [ RunTime:0.002120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64106416 LIMIT 2 [ RunTime:0.002823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64106416 ORDER BY `minOrder` ASC [ RunTime:0.006251s ]
select * from pdf where partno='2985631' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985631' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64383425 LIMIT 5 [ RunTime:0.003070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64383425 ORDER BY `minOrder` ASC [ RunTime:0.001953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64383425 ORDER BY `unit` DESC [ RunTime:0.000573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64383425 LIMIT 2 [ RunTime:0.001690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64383425 ORDER BY `minOrder` ASC [ RunTime:0.001546s ]
select * from pdf where partno='2985974' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002607s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985974' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64106969 LIMIT 5 [ RunTime:0.002584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64106969 ORDER BY `minOrder` ASC [ RunTime:0.001815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64106969 ORDER BY `unit` DESC [ RunTime:0.000556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64106969 LIMIT 2 [ RunTime:0.000930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64106969 ORDER BY `minOrder` ASC [ RunTime:0.000891s ]
select * from pdf where partno='2985688' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985688' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64419988 LIMIT 5 [ RunTime:0.002087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64419988 ORDER BY `minOrder` ASC [ RunTime:0.001757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64419988 ORDER BY `unit` DESC [ RunTime:0.000592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64419988 LIMIT 2 [ RunTime:0.001526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64419988 ORDER BY `minOrder` ASC [ RunTime:0.000911s ]
select * from pdf where partno='2985204' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985204' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64419964 LIMIT 5 [ RunTime:0.001822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64419964 ORDER BY `minOrder` ASC [ RunTime:0.003362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64419964 ORDER BY `unit` DESC [ RunTime:0.006317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64419964 LIMIT 2 [ RunTime:0.018284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64419964 ORDER BY `minOrder` ASC [ RunTime:0.007751s ]
select * from pdf where partno='2985194' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001717s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985194' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64419933 LIMIT 5 [ RunTime:0.001319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64419933 ORDER BY `minOrder` ASC [ RunTime:0.000494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64419933 ORDER BY `unit` DESC [ RunTime:0.000420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64419933 LIMIT 2 [ RunTime:0.000589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64419933 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
select * from pdf where partno='2985181' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000776s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985181' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64419808 LIMIT 5 [ RunTime:0.001591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64419808 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64419808 ORDER BY `unit` DESC [ RunTime:0.000381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64419808 LIMIT 2 [ RunTime:0.000384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64419808 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
select * from pdf where partno='2985149' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985149' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64419692 LIMIT 5 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64419692 ORDER BY `minOrder` ASC [ RunTime:0.000630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64419692 ORDER BY `unit` DESC [ RunTime:0.000407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64419692 LIMIT 2 [ RunTime:0.000408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64419692 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
select * from pdf where partno='2985152' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985152' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64419646 LIMIT 5 [ RunTime:0.000556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64419646 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64419646 ORDER BY `unit` DESC [ RunTime:0.000405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64419646 LIMIT 2 [ RunTime:0.000344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64419646 ORDER BY `minOrder` ASC [ RunTime:0.000370s ]
select * from pdf where partno='2985123' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000548s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985123' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64383411 LIMIT 5 [ RunTime:0.000755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64383411 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64383411 ORDER BY `unit` DESC [ RunTime:0.003966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64383411 LIMIT 2 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64383411 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='2985929' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000561s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985929' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64383394 LIMIT 5 [ RunTime:0.000813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64383394 ORDER BY `minOrder` ASC [ RunTime:0.000575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64383394 ORDER BY `unit` DESC [ RunTime:0.004851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64383394 LIMIT 2 [ RunTime:0.000623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64383394 ORDER BY `minOrder` ASC [ RunTime:0.000634s ]
select * from pdf where partno='2985071' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000886s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985071' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64178719 LIMIT 5 [ RunTime:0.000409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64178719 ORDER BY `minOrder` ASC [ RunTime:0.000968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64178719 ORDER BY `unit` DESC [ RunTime:0.000457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64178719 LIMIT 2 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64178719 ORDER BY `minOrder` ASC [ RunTime:0.000540s ]
select * from pdf where partno='2985.000.00.00' and brandshort='FEIG Electronic' limit 1 [ RunTime:0.000861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985.000.00.00' OR `brand` LIKE 'FEIG Electronic%' ) ) LIMIT 1 [ RunTime:0.001213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64178458 LIMIT 5 [ RunTime:0.000807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64178458 ORDER BY `minOrder` ASC [ RunTime:0.008185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64178458 ORDER BY `unit` DESC [ RunTime:0.015645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64178458 LIMIT 2 [ RunTime:0.061922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64178458 ORDER BY `minOrder` ASC [ RunTime:0.014278s ]
select * from pdf where partno='2985.000.00' and brandshort='FEIG Electronic' limit 1 [ RunTime:0.027410s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985.000.00' OR `brand` LIKE 'FEIG Electronic%' ) ) LIMIT 1 [ RunTime:0.026323s ]
SELECT `id` FROM `stock` WHERE `id` <> 64178458 AND `partno` = '2985.000.00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%feig electronic%' ) [ RunTime:0.017424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11995382 [ RunTime:0.001292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64107028 LIMIT 5 [ RunTime:0.016622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64107028 ORDER BY `minOrder` ASC [ RunTime:0.015436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64107028 ORDER BY `unit` DESC [ RunTime:0.011371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64107028 LIMIT 2 [ RunTime:0.031644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64107028 ORDER BY `minOrder` ASC [ RunTime:0.009368s ]
select * from pdf where partno='2985864' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.037054s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2985864' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.033543s ]
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 '2985%' OR `brand` LIKE '2985%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028816s ]
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 '2985%' OR `brand` LIKE '2985%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020093s ]
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 '2985%' OR `brand` LIKE '2985%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019621s ]
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 '2985%' OR `brand` LIKE '2985%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019101s ]
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 '2985%' OR `brand` LIKE '2985%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008707s ]
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 '2985%' OR `brand` LIKE '2985%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022233s ]
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 '2985%' OR `brand` LIKE '2985%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030058s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2985%' OR `brand` LIKE '2985%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.026521s ]