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;
444ms/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 ('707','1886','2331','3297','3346','1582','2338','2339','3246','11577','11578','11579','1590','2346','2347','2348','2349','2359','3115','1918','1596','1599','11097','1926','5017','11107','2920','1605','2372','2376','2386','3105','3106','2378','3128','2379','4201','4202','4199','2383','722','4310','11022','4185','1946','5023','5024','5025','1948','5074','5075','5076','5077','1949','1950','1951','1952','3576','1622','1624','1633','958','2406','2407','2454','2455','11569','11019','11018','11017','11015','11427','3217','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','3241','10980','10981','11106','3698','3330','2433','3334','3335','1643','10929','2002','5115','2013','3443','2440','2441','2015','2016','1663','2504','10187','10923','5082','2843','10925','11433','1669','11054','2450','2451','2452','10717','752','753','1686','1687','11109','1688')
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 ('707','1886','2331','3297','3346','1582','2338','2339','3246','11577','11578','11579','1590','2346','2347','2348','2349','2359','3115','1918','1596','1599','11097','1926','5017','11107','2920','1605','2372','2376','2386','3105','3106','2378','3128','2379','4201','4202','4199','2383','722','4310','11022','4185','1946','5023','5024','5025','1948','5074','5075','5076','5077','1949','1950','1951','1952','3576','1622','1624','1633','958','2406','2407','2454','2455','11569','11019','11018','11017','11015','11427','3217','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','3241','10980','10981','11106','3698','3330','2433','3334','3335','1643','10929','2002','5115','2013','3443','2440','2441','2015','2016','1663','2504','10187','10923','5082','2843','10925','11433','1669','11054','2450','2451','2452','10717','752','753','1686','1687','11109','1688')
and
l.targetcomp ='event'and
l.sourcecomp ='river'and
ed.event_date > now()
groupby l.sourceid
3.2ms/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 (707,1886,2331,3297,3346,1582,2338,2339,3246,11577,11578,11579,1590,2346,2347,2348,2349,2359,3115,1918,1596,1599,11097,1926,5017,11107,2920,1605,2372,2376,2386,3105,3106,2378,3128,2379,4201,4202,4199,2383,722,4310,11022,4185,1946,5023,5024,5025,1948,5074,5075,5076,5077,1949,1950,1951,1952,3576,1622,1624,1633,958,2406,2407,2454,2455,11569,11019,11018,11017,11015,11427,3217,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,3241,10980,10981,11106,3698,3330,2433,3334,3335,1643,10929,2002,5115,2013,3443,2440,2441,2015,2016,1663,2504,10187,10923,5082,2843,10925,11433,1669,11054,2450,2451,2452,10717,752,753,1686,1687,11109,1688)
and
c.post_date > now()- ( interval'1 year')
groupby reach_id
40.48ms/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476legacy db
