select r.id as rid,*from reach_map r
where
status!='d'and r.state in (select gmi from geo_states where aw_region ='MC') and (r.reading between0and1) and ( class>='I'and class<='V' ) and (1=1)
orderby river,section
limit 750;
735ms/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476legacy db
selectmax(ed.event_date),l.targetid as id
from linker_lists as l
leftjoin event_dates as ed on ed.event_id::char(10) = l.sourceid
where
l.targetid in ('1886','3297','3346','11577','11578','11579','2346','2347','2348','2349','3115','1916','1918','1596','1599','11097','1926','5017','1928','11107','2920','3106','4201','4202','4199','2383','4185','5023','5024','5025','1948','5074','5075','5076','5077','1949','1950','1951','1952','3138','3137','3576','1622','1633','958','1097','11019','11018','11017','11015','11427','134','1973','1974','10859','10860','10861','10862','10863','4620','1975','4621','4622','4623','4627','2415','2416','2417','4119','2418','2419','11062','11064','11066','11284','11067','11285','11071','11073','3289','738','11075','10986','739','5560','742','11003','740','90','10980','10981','11106','3698','3330','2433','3334','3335','1987','961','1643','10929','2002','5115','1202','2011','4529','2013','3443','2440','2441','2015','2016','1660','1663','2504','10187','3784','10923','5082','11433','1669','2453','1686','1687','11109')
and
l.targetcomp ='river'and
l.sourcecomp ='event'and
ed.event_date > now()
groupby l.targetid unionselectmax(ed.event_date),l.sourceid as id
from linker_lists as l
leftjoin event_dates as ed on ed.event_id::char(10) = l.targetid
where
l.sourceid in ('1886','3297','3346','11577','11578','11579','2346','2347','2348','2349','3115','1916','1918','1596','1599','11097','1926','5017','1928','11107','2920','3106','4201','4202','4199','2383','4185','5023','5024','5025','1948','5074','5075','5076','5077','1949','1950','1951','1952','3138','3137','3576','1622','1633','958','1097','11019','11018','11017','11015','11427','134','1973','1974','10859','10860','10861','10862','10863','4620','1975','4621','4622','4623','4627','2415','2416','2417','4119','2418','2419','11062','11064','11066','11284','11067','11285','11071','11073','3289','738','11075','10986','739','5560','742','11003','740','90','10980','10981','11106','3698','3330','2433','3334','3335','1987','961','1643','10929','2002','5115','1202','2011','4529','2013','3443','2440','2441','2015','2016','1660','1663','2504','10187','3784','10923','5082','11433','1669','2453','1686','1687','11109')
and
l.targetcomp ='event'and
l.sourcecomp ='river'and
ed.event_date > now()
groupby l.sourceid
6.6ms/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476legacy db
selectmax(post_date),reach_id as id
from posts c
where
c.post_type=502and
c.reach_id in (1886,3297,3346,11577,11578,11579,2346,2347,2348,2349,3115,1916,1918,1596,1599,11097,1926,5017,1928,11107,2920,3106,4201,4202,4199,2383,4185,5023,5024,5025,1948,5074,5075,5076,5077,1949,1950,1951,1952,3138,3137,3576,1622,1633,958,1097,11019,11018,11017,11015,11427,134,1973,1974,10859,10860,10861,10862,10863,4620,1975,4621,4622,4623,4627,2415,2416,2417,4119,2418,2419,11062,11064,11066,11284,11067,11285,11071,11073,3289,738,11075,10986,739,5560,742,11003,740,90,10980,10981,11106,3698,3330,2433,3334,3335,1987,961,1643,10929,2002,5115,1202,2011,4529,2013,3443,2440,2441,2015,2016,1660,1663,2504,10187,3784,10923,5082,11433,1669,2453,1686,1687,11109)
and
c.post_date > now()- ( interval'1 year')
groupby reach_id
65.34ms/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476legacy db
