select r.id as rid,*from reach_map r
where
status!='d'and r.state in (select gmi from geo_states where aw_region ='NW') and (r.reading between0and1) and ( class>='I'and class<='V' ) and (1=1)
orderby river,section
limit 750;
572ms/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 ('1483','3476','2062','10402','2063','10391','1487','10992','3477','10401','2075','3489','2077','10279','3758','2084','2085','2086','2087','2090','2091','1492','1493','1494','1495','2102','1503','3759','1504','3031','3073','3074','10684','1505','3075','11052','1507','3084','2108','3798','2112','2113','2115','3523','2114','2116','10398','3081','3082','3083','2189','3353','2870','10446','2132','2133','2134','2136','2137','3412','4312','1517','10432','1518','10433','1519','22','1522','3169','2143','2145','3531','3495','2151','2152','2155','2157','2159','3270','34','4510','10889','10888','1526','3532','2164','2165','1529','2167','2168','3690','2170','3116','2172','2171','10690','2175','580','3764','1538','3881','2182','5068','1541','10452','1544','1545','1549','1550','1551','1552','10427','10429','1554','2198','2199','2201','2202','4131','1556','45','2206','2205','2207','2209','3409','2210','2213','3585','2216','2218','2219','2220','2221','3451','11443','2224','2233','2234','4228','3506','2242','3507','3508','3112','2247','5399','2255','2256','4690','11245','1561','10794','1562','10973','10455','3767','3771','2265','2266','2267','2268','3071','1564','2269','3064','1565','2723','1566','1567','1568','2275','2276')
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 ('1483','3476','2062','10402','2063','10391','1487','10992','3477','10401','2075','3489','2077','10279','3758','2084','2085','2086','2087','2090','2091','1492','1493','1494','1495','2102','1503','3759','1504','3031','3073','3074','10684','1505','3075','11052','1507','3084','2108','3798','2112','2113','2115','3523','2114','2116','10398','3081','3082','3083','2189','3353','2870','10446','2132','2133','2134','2136','2137','3412','4312','1517','10432','1518','10433','1519','22','1522','3169','2143','2145','3531','3495','2151','2152','2155','2157','2159','3270','34','4510','10889','10888','1526','3532','2164','2165','1529','2167','2168','3690','2170','3116','2172','2171','10690','2175','580','3764','1538','3881','2182','5068','1541','10452','1544','1545','1549','1550','1551','1552','10427','10429','1554','2198','2199','2201','2202','4131','1556','45','2206','2205','2207','2209','3409','2210','2213','3585','2216','2218','2219','2220','2221','3451','11443','2224','2233','2234','4228','3506','2242','3507','3508','3112','2247','5399','2255','2256','4690','11245','1561','10794','1562','10973','10455','3767','3771','2265','2266','2267','2268','3071','1564','2269','3064','1565','2723','1566','1567','1568','2275','2276')
and
l.targetcomp ='event'and
l.sourcecomp ='river'and
ed.event_date > now()
groupby l.sourceid
5.3ms/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 (1483,3476,2062,10402,2063,10391,1487,10992,3477,10401,2075,3489,2077,10279,3758,2084,2085,2086,2087,2090,2091,1492,1493,1494,1495,2102,1503,3759,1504,3031,3073,3074,10684,1505,3075,11052,1507,3084,2108,3798,2112,2113,2115,3523,2114,2116,10398,3081,3082,3083,2189,3353,2870,10446,2132,2133,2134,2136,2137,3412,4312,1517,10432,1518,10433,1519,22,1522,3169,2143,2145,3531,3495,2151,2152,2155,2157,2159,3270,34,4510,10889,10888,1526,3532,2164,2165,1529,2167,2168,3690,2170,3116,2172,2171,10690,2175,580,3764,1538,3881,2182,5068,1541,10452,1544,1545,1549,1550,1551,1552,10427,10429,1554,2198,2199,2201,2202,4131,1556,45,2206,2205,2207,2209,3409,2210,2213,3585,2216,2218,2219,2220,2221,3451,11443,2224,2233,2234,4228,3506,2242,3507,3508,3112,2247,5399,2255,2256,4690,11245,1561,10794,1562,10973,10455,3767,3771,2265,2266,2267,2268,3071,1564,2269,3064,1565,2723,1566,1567,1568,2275,2276)
and
c.post_date > now()- ( interval'1 year')
groupby reach_id
43.52ms/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476legacy db