SHOW FULL COLUMNS FROM `stock` [ RunTime:0.004024s ]
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 '25511%' OR `brand` LIKE '25511%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018110s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13308302 LIMIT 5 [ RunTime:0.009051s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13308302 ORDER BY `minOrder` ASC [ RunTime:0.000697s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13308302 ORDER BY `unit` DESC [ RunTime:0.007163s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13308302 LIMIT 2 [ RunTime:0.003004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13308302 ORDER BY `minOrder` ASC [ RunTime:0.005803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14419211 LIMIT 5 [ RunTime:0.009301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14419211 ORDER BY `minOrder` ASC [ RunTime:0.014678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14419211 ORDER BY `unit` DESC [ RunTime:0.005206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14419211 LIMIT 2 [ RunTime:0.028117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14419211 ORDER BY `minOrder` ASC [ RunTime:0.002987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16588907 LIMIT 5 [ RunTime:0.007756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16588907 ORDER BY `minOrder` ASC [ RunTime:0.011116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16588907 ORDER BY `unit` DESC [ RunTime:0.021225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16588907 LIMIT 2 [ RunTime:0.013628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16588907 ORDER BY `minOrder` ASC [ RunTime:0.001997s ]
select * from pdf where partno='255110-01-12.00' and brandshort='Amphenol RF' limit 1 [ RunTime:0.013225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13751620 LIMIT 5 [ RunTime:0.025044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13751620 ORDER BY `minOrder` ASC [ RunTime:0.001061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13751620 ORDER BY `unit` DESC [ RunTime:0.019053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13751620 LIMIT 2 [ RunTime:0.007992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13751620 ORDER BY `minOrder` ASC [ RunTime:0.002183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17513089 LIMIT 5 [ RunTime:0.005419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17513089 ORDER BY `minOrder` ASC [ RunTime:0.000694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17513089 ORDER BY `unit` DESC [ RunTime:0.000413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17513089 LIMIT 2 [ RunTime:0.004197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17513089 ORDER BY `minOrder` ASC [ RunTime:0.004450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14628732 LIMIT 5 [ RunTime:0.002193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14628732 ORDER BY `minOrder` ASC [ RunTime:0.004897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14628732 ORDER BY `unit` DESC [ RunTime:0.001760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14628732 LIMIT 2 [ RunTime:0.004496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14628732 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14628715 LIMIT 5 [ RunTime:0.000738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14628715 ORDER BY `minOrder` ASC [ RunTime:0.000960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14628715 ORDER BY `unit` DESC [ RunTime:0.005079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14628715 LIMIT 2 [ RunTime:0.000581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14628715 ORDER BY `minOrder` ASC [ RunTime:0.000389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13752386 LIMIT 5 [ RunTime:0.004538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13752386 ORDER BY `minOrder` ASC [ RunTime:0.005207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13752386 ORDER BY `unit` DESC [ RunTime:0.004333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13752386 LIMIT 2 [ RunTime:0.000769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13752386 ORDER BY `minOrder` ASC [ RunTime:0.002754s ]
select * from pdf where partno='255110-01-36.00' and brandshort='Amphenol RF' limit 1 [ RunTime:0.008285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13753556 LIMIT 5 [ RunTime:0.007857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13753556 ORDER BY `minOrder` ASC [ RunTime:0.006432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13753556 ORDER BY `unit` DESC [ RunTime:0.007725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13753556 LIMIT 2 [ RunTime:0.000651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13753556 ORDER BY `minOrder` ASC [ RunTime:0.006587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16586375 LIMIT 5 [ RunTime:0.002005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16586375 ORDER BY `minOrder` ASC [ RunTime:0.000876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16586375 ORDER BY `unit` DESC [ RunTime:0.000658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16586375 LIMIT 2 [ RunTime:0.000629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16586375 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16586043 LIMIT 5 [ RunTime:0.001001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16586043 ORDER BY `minOrder` ASC [ RunTime:0.002371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16586043 ORDER BY `unit` DESC [ RunTime:0.001629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16586043 LIMIT 2 [ RunTime:0.000668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16586043 ORDER BY `minOrder` ASC [ RunTime:0.003591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16584874 LIMIT 5 [ RunTime:0.005407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16584874 ORDER BY `minOrder` ASC [ RunTime:0.000729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16584874 ORDER BY `unit` DESC [ RunTime:0.001142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16584874 LIMIT 2 [ RunTime:0.000623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16584874 ORDER BY `minOrder` ASC [ RunTime:0.002162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13756026 LIMIT 5 [ RunTime:0.006208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13756026 ORDER BY `minOrder` ASC [ RunTime:0.001918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13756026 ORDER BY `unit` DESC [ RunTime:0.004557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13756026 LIMIT 2 [ RunTime:0.000818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13756026 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13753451 LIMIT 5 [ RunTime:0.004155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13753451 ORDER BY `minOrder` ASC [ RunTime:0.001285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13753451 ORDER BY `unit` DESC [ RunTime:0.000821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13753451 LIMIT 2 [ RunTime:0.003024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13753451 ORDER BY `minOrder` ASC [ RunTime:0.002452s ]
select * from pdf where partno='255110-01-24.00' and brandshort='Amphenol RF' limit 1 [ RunTime:0.010058s ]
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 '25511%' OR `brand` LIKE '25511%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001621s ]
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 '25511%' OR `brand` LIKE '25511%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36765753 LIMIT 5 [ RunTime:0.002334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36765753 ORDER BY `minOrder` ASC [ RunTime:0.002265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36765753 ORDER BY `unit` DESC [ RunTime:0.004129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36765753 LIMIT 2 [ RunTime:0.007056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36765753 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
select * from pdf where partno='25511' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.010265s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001778s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25511' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.001600s ]
SELECT `id` FROM `stock` WHERE `id` <> 36765753 AND `partno` = '25511' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.001055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13308302 [ RunTime:0.000669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49572562 LIMIT 5 [ RunTime:0.000687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49572562 ORDER BY `minOrder` ASC [ RunTime:0.001286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49572562 ORDER BY `unit` DESC [ RunTime:0.000577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49572562 LIMIT 2 [ RunTime:0.003063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49572562 ORDER BY `minOrder` ASC [ RunTime:0.002651s ]
select * from pdf where partno='25511' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.000666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25511' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000248s ]
SELECT `id` FROM `stock` WHERE `id` <> 49572562 AND `partno` = '25511' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.004741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13308302 [ RunTime:0.000348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49248480 LIMIT 5 [ RunTime:0.002045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49248480 ORDER BY `minOrder` ASC [ RunTime:0.002083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49248480 ORDER BY `unit` DESC [ RunTime:0.000368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49248480 LIMIT 2 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49248480 ORDER BY `minOrder` ASC [ RunTime:0.000232s ]
select * from pdf where partno='25511.9' and brandshort='Pflitsch' limit 1 [ RunTime:0.003165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25511.9' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.005315s ]
SELECT `id` FROM `stock` WHERE `id` <> 49248480 AND `partno` = '25511.9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.002022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14419211 [ RunTime:0.001516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36452049 LIMIT 5 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36452049 ORDER BY `minOrder` ASC [ RunTime:0.001137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36452049 ORDER BY `unit` DESC [ RunTime:0.006822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36452049 LIMIT 2 [ RunTime:0.001989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36452049 ORDER BY `minOrder` ASC [ RunTime:0.005302s ]
select * from pdf where partno='25511.9' and brandshort='Pflitsch' limit 1 [ RunTime:0.001413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25511.9' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.002906s ]
SELECT `id` FROM `stock` WHERE `id` <> 36452049 AND `partno` = '25511.9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.001589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14419211 [ RunTime:0.000403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48622472 LIMIT 5 [ RunTime:0.000526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48622472 ORDER BY `minOrder` ASC [ RunTime:0.002603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48622472 ORDER BY `unit` DESC [ RunTime:0.006059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48622472 LIMIT 2 [ RunTime:0.001311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48622472 ORDER BY `minOrder` ASC [ RunTime:0.000230s ]
select * from pdf where partno='255110-01-24.00' and brandshort='Amphenol RF' limit 1 [ RunTime:0.015671s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '255110-01-24.00' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.019381s ]
SELECT `id` FROM `stock` WHERE `id` <> 48622472 AND `partno` = '255110-01-24.00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.001368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13753451 [ RunTime:0.018551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35820145 LIMIT 5 [ RunTime:0.003104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35820145 ORDER BY `minOrder` ASC [ RunTime:0.004392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35820145 ORDER BY `unit` DESC [ RunTime:0.002647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35820145 LIMIT 2 [ RunTime:0.004484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35820145 ORDER BY `minOrder` ASC [ RunTime:0.008149s ]
select * from pdf where partno='255110-01-24.00' and brandshort='Amphenol RF' limit 1 [ RunTime:0.000826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '255110-01-24.00' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.000480s ]
SELECT `id` FROM `stock` WHERE `id` <> 35820145 AND `partno` = '255110-01-24.00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.000948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13753451 [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35819124 LIMIT 5 [ RunTime:0.020153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35819124 ORDER BY `minOrder` ASC [ RunTime:0.024092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35819124 ORDER BY `unit` DESC [ RunTime:0.002534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35819124 LIMIT 2 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35819124 ORDER BY `minOrder` ASC [ RunTime:0.006550s ]
select * from pdf where partno='255110-01-12.00' and brandshort='Amphenol RF' limit 1 [ RunTime:0.001499s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '255110-01-12.00' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.002534s ]
SELECT `id` FROM `stock` WHERE `id` <> 35819124 AND `partno` = '255110-01-12.00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.004007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16588907 [ RunTime:0.009598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48622036 LIMIT 5 [ RunTime:0.006054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48622036 ORDER BY `minOrder` ASC [ RunTime:0.007098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48622036 ORDER BY `unit` DESC [ RunTime:0.008997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48622036 LIMIT 2 [ RunTime:0.000555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48622036 ORDER BY `minOrder` ASC [ RunTime:0.000295s ]
select * from pdf where partno='255110-01-12.00' and brandshort='Amphenol RF' limit 1 [ RunTime:0.000651s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '255110-01-12.00' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.000256s ]
SELECT `id` FROM `stock` WHERE `id` <> 48622036 AND `partno` = '255110-01-12.00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.000574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16588907 [ RunTime:0.000912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35819804 LIMIT 5 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35819804 ORDER BY `minOrder` ASC [ RunTime:0.007326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35819804 ORDER BY `unit` DESC [ RunTime:0.001127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35819804 LIMIT 2 [ RunTime:0.000337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35819804 ORDER BY `minOrder` ASC [ RunTime:0.000221s ]
select * from pdf where partno='255110-01-48.00' and brandshort='Amphenol RF' limit 1 [ RunTime:0.001015s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '255110-01-48.00' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.001701s ]
SELECT `id` FROM `stock` WHERE `id` <> 35819804 AND `partno` = '255110-01-48.00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.000595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13751620 [ RunTime:0.003844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 48622143 LIMIT 5 [ RunTime:0.001852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48622143 ORDER BY `minOrder` ASC [ RunTime:0.006275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 48622143 ORDER BY `unit` DESC [ RunTime:0.000418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 48622143 LIMIT 2 [ RunTime:0.000312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 48622143 ORDER BY `minOrder` ASC [ RunTime:0.002113s ]
select * from pdf where partno='255110-01-48.00' and brandshort='Amphenol RF' limit 1 [ RunTime:0.000341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '255110-01-48.00' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.000226s ]
SELECT `id` FROM `stock` WHERE `id` <> 48622143 AND `partno` = '255110-01-48.00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.001003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13751620 [ RunTime:0.000174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49709740 LIMIT 5 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49709740 ORDER BY `minOrder` ASC [ RunTime:0.001151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49709740 ORDER BY `unit` DESC [ RunTime:0.000376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49709740 LIMIT 2 [ RunTime:0.000283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49709740 ORDER BY `minOrder` ASC [ RunTime:0.011248s ]
select * from pdf where partno='25511' and brandshort='Wiha' limit 1 [ RunTime:0.002489s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25511' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.000930s ]
SELECT `id` FROM `stock` WHERE `id` <> 49709740 AND `partno` = '25511' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.000486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17513089 [ RunTime:0.009781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36902862 LIMIT 5 [ RunTime:0.003616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36902862 ORDER BY `minOrder` ASC [ RunTime:0.001665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36902862 ORDER BY `unit` DESC [ RunTime:0.000443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36902862 LIMIT 2 [ RunTime:0.000322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36902862 ORDER BY `minOrder` ASC [ RunTime:0.000207s ]
select * from pdf where partno='25511' and brandshort='Wiha' limit 1 [ RunTime:0.000339s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25511' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.000209s ]
SELECT `id` FROM `stock` WHERE `id` <> 36902862 AND `partno` = '25511' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.000593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17513089 [ RunTime:0.000330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49007026 LIMIT 5 [ RunTime:0.002943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49007026 ORDER BY `minOrder` ASC [ RunTime:0.005415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49007026 ORDER BY `unit` DESC [ RunTime:0.000509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49007026 LIMIT 2 [ RunTime:0.001945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49007026 ORDER BY `minOrder` ASC [ RunTime:0.006054s ]
select * from pdf where partno='255110-01-M0.25' and brandshort='Amphenol RF' limit 1 [ RunTime:0.008009s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '255110-01-M0.25' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.015472s ]
SELECT `id` FROM `stock` WHERE `id` <> 49007026 AND `partno` = '255110-01-M0.25' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.003123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14628732 [ RunTime:0.001758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36211331 LIMIT 5 [ RunTime:0.000578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36211331 ORDER BY `minOrder` ASC [ RunTime:0.001117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36211331 ORDER BY `unit` DESC [ RunTime:0.007209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36211331 LIMIT 2 [ RunTime:0.009104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36211331 ORDER BY `minOrder` ASC [ RunTime:0.004120s ]
select * from pdf where partno='255110-01-M0.25' and brandshort='Amphenol RF' limit 1 [ RunTime:0.000671s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '255110-01-M0.25' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.000371s ]
SELECT `id` FROM `stock` WHERE `id` <> 36211331 AND `partno` = '255110-01-M0.25' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.000715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14628732 [ RunTime:0.000534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36215728 LIMIT 5 [ RunTime:0.000414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36215728 ORDER BY `minOrder` ASC [ RunTime:0.001251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36215728 ORDER BY `unit` DESC [ RunTime:0.003505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36215728 LIMIT 2 [ RunTime:0.010343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36215728 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
select * from pdf where partno='255110-01-36.00' and brandshort='Amphenol RF' limit 1 [ RunTime:0.000599s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '255110-01-36.00' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.004678s ]
SELECT `id` FROM `stock` WHERE `id` <> 36215728 AND `partno` = '255110-01-36.00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.000808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13752386 [ RunTime:0.009145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49011529 LIMIT 5 [ RunTime:0.000700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49011529 ORDER BY `minOrder` ASC [ RunTime:0.004888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49011529 ORDER BY `unit` DESC [ RunTime:0.000735s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49011529 LIMIT 2 [ RunTime:0.001056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49011529 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
select * from pdf where partno='255110-01-M1.00' and brandshort='Amphenol RF' limit 1 [ RunTime:0.003887s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '255110-01-M1.00' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.000991s ]
SELECT `id` FROM `stock` WHERE `id` <> 49011529 AND `partno` = '255110-01-M1.00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.000907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13753556 [ RunTime:0.010106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36215763 LIMIT 5 [ RunTime:0.002895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36215763 ORDER BY `minOrder` ASC [ RunTime:0.003019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36215763 ORDER BY `unit` DESC [ RunTime:0.000870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36215763 LIMIT 2 [ RunTime:0.000683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36215763 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
select * from pdf where partno='255110-01-M1.00' and brandshort='Amphenol RF' limit 1 [ RunTime:0.000599s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '255110-01-M1.00' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.000418s ]
SELECT `id` FROM `stock` WHERE `id` <> 36215763 AND `partno` = '255110-01-M1.00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.000886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13753556 [ RunTime:0.003141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49011480 LIMIT 5 [ RunTime:0.006953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49011480 ORDER BY `minOrder` ASC [ RunTime:0.002580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49011480 ORDER BY `unit` DESC [ RunTime:0.001168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49011480 LIMIT 2 [ RunTime:0.000730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49011480 ORDER BY `minOrder` ASC [ RunTime:0.000617s ]
select * from pdf where partno='255110-01-M0.50' and brandshort='Amphenol RF' limit 1 [ RunTime:0.002198s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '255110-01-M0.50' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.009570s ]
SELECT `id` FROM `stock` WHERE `id` <> 49011480 AND `partno` = '255110-01-M0.50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.005073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16584874 [ RunTime:0.000807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36215716 LIMIT 5 [ RunTime:0.000531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36215716 ORDER BY `minOrder` ASC [ RunTime:0.003850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36215716 ORDER BY `unit` DESC [ RunTime:0.003488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36215716 LIMIT 2 [ RunTime:0.004025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36215716 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
select * from pdf where partno='255110-01-M0.50' and brandshort='Amphenol RF' limit 1 [ RunTime:0.000500s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '255110-01-M0.50' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.000384s ]
SELECT `id` FROM `stock` WHERE `id` <> 36215716 AND `partno` = '255110-01-M0.50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.003163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16584874 [ RunTime:0.000437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49020741 LIMIT 5 [ RunTime:0.000573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49020741 ORDER BY `minOrder` ASC [ RunTime:0.002759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49020741 ORDER BY `unit` DESC [ RunTime:0.000751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49020741 LIMIT 2 [ RunTime:0.003383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49020741 ORDER BY `minOrder` ASC [ RunTime:0.001157s ]
select * from pdf where partno='255110-01-M4.00' and brandshort='Amphenol RF' limit 1 [ RunTime:0.003399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '255110-01-M4.00' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.001515s ]
SELECT `id` FROM `stock` WHERE `id` <> 49020741 AND `partno` = '255110-01-M4.00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.001107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13756026 [ RunTime:0.000643s ]
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 '25511%' OR `brand` LIKE '25511%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000958s ]
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 '25511%' OR `brand` LIKE '25511%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002349s ]
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 '25511%' OR `brand` LIKE '25511%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001441s ]
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 '25511%' OR `brand` LIKE '25511%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002327s ]
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 '25511%' OR `brand` LIKE '25511%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001144s ]
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 '25511%' OR `brand` LIKE '25511%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001517s ]
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 '25511%' OR `brand` LIKE '25511%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010539s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '25511%' OR `brand` LIKE '25511%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001178s ]