select r.id as rid,*from reach_map r
where
status!='d'and r.state in (select gmi from geo_states where aw_region ='SE') and (r.reading between0and1) and ( class>='I'and class<='V' ) and (1=1)
orderby river,section
limit 750;
291ms/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 ('3178','3374','464','1037','64','1692','1691','1690','1042','469','1045','470','3418','1047','1046','3934','472','471','4086','4475','474','3659','477','475','476','478','4334','1730','1731','1732','4786','3647','4028','3086','3875','481','3905','5147','1720','1719','1053','1061','1065','1062','1063','1060','1776','1697','4644','4453','485','1075','1083','1084','1089','1093','69','3358','68','4448','1096','491','4454','72','1101','5007','1973','1105','11269','4579','10714','10755','3863','4642','11128','11061','11142','11143','11145','11144','1782','1108','4398','1109','1118','1701','1700','1703','4051','11180','78','1126','3181','502','79','1132','1790','3392','1138','1709','1711','1712','1710','82','3901','1145','1797','1146','11275','1151','1153','1152')
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 ('3178','3374','464','1037','64','1692','1691','1690','1042','469','1045','470','3418','1047','1046','3934','472','471','4086','4475','474','3659','477','475','476','478','4334','1730','1731','1732','4786','3647','4028','3086','3875','481','3905','5147','1720','1719','1053','1061','1065','1062','1063','1060','1776','1697','4644','4453','485','1075','1083','1084','1089','1093','69','3358','68','4448','1096','491','4454','72','1101','5007','1973','1105','11269','4579','10714','10755','3863','4642','11128','11061','11142','11143','11145','11144','1782','1108','4398','1109','1118','1701','1700','1703','4051','11180','78','1126','3181','502','79','1132','1790','3392','1138','1709','1711','1712','1710','82','3901','1145','1797','1146','11275','1151','1153','1152')
and
l.targetcomp ='event'and
l.sourcecomp ='river'and
ed.event_date > now()
groupby l.sourceid
2.86ms/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 (3178,3374,464,1037,64,1692,1691,1690,1042,469,1045,470,3418,1047,1046,3934,472,471,4086,4475,474,3659,477,475,476,478,4334,1730,1731,1732,4786,3647,4028,3086,3875,481,3905,5147,1720,1719,1053,1061,1065,1062,1063,1060,1776,1697,4644,4453,485,1075,1083,1084,1089,1093,69,3358,68,4448,1096,491,4454,72,1101,5007,1973,1105,11269,4579,10714,10755,3863,4642,11128,11061,11142,11143,11145,11144,1782,1108,4398,1109,1118,1701,1700,1703,4051,11180,78,1126,3181,502,79,1132,1790,3392,1138,1709,1711,1712,1710,82,3901,1145,1797,1146,11275,1151,1153,1152)
and
c.post_date > now()- ( interval'1 year')
groupby reach_id
16.11ms/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php:476legacy db
