The bantam sunfish (Lepomis symmetricus) is a species of freshwater fish in the genus Lepomis common throughout Louisiana, in extreme southeastern Texas, in southern Arkansas, and in a few places in western Kentucky and western Tennessee. Bantam sunfish are the smallest of all sunfish species that can be found in North America and are historically associated with the state of Illinois as they are found in the muddy and swampy waters of the Illinois region. However, the population of this fish in their native Illinois has been listed as endangered as they have suffered a steep decline due to human interference in the natural habitat which has led to the destruction of their ecosystem. Bantam sunfish (L. symmetricus) are protected by the forest service association in the state of Illinois as there have been efforts to bring the population of this fish back to their old numbers and hopefully it can be done as these fish are an important part of the natural ecosystem. Description The bantam sunfish is dark in color with around ten vertical stripes visible along each flank. The lower jaw protrudes noticeably beyond the upper. Distribution and habitat The northern and southern boundaries for the bantam sunfish coincide fairly heavily with the former Mississippi Embayment from southern Illinois to the Gulf of Mexico. As for the eastern and western boundaries, the bantam sunfish occurs along the Gulf Coast from Eagle Lake (in the Colorado River drainage) in Texas east through the Biloxi River system in Mississippi. The species is common only in a few states. These states include Louisiana where the fish resides statewide, extreme southeastern Texas, southern Arkansas, and a few places in western Kentucky and western Tennessee. The bantam sunfish is also known to occur, less commonly, in parts of extreme southwestern Illinois, the Bootheel of Missouri, McCurtain County in Oklahoma, and some Mississippi and Gulf Coast drainages of the State of Mississippi. Historically, isolated populations of the bantam sunfish occurred above the Fall Line in the Illinois River at Pekin, in backwater ponds and sloughs of the Wabash River drainage in White County, Illinois, and the Pine Hills. In Illinois, the range of the bantam sunfish is considered to be limited to the Wolf Lake region of Union County. Newer records extend the Illinois range of the bantam sunfish south through the Clear Creek drainage to Horseshoe Lake, Alexander County, and through the Cache River drainage in Buttonland Swamp, Limekiln Slough, and Grassy Slough. Previous collections in the Cache River drainage failed to produce any bantam sunfish.
| 1 x Application (91.1%) | 277ms |
| 1 x Booting (8.89%) | 27.04ms |
select * from `fish` where `alias` = 'lepomis-symmetricus' and `type` = 'species' and `published` = 1 limit 1| Bindings |
|
| Backtrace |
|
select * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (770)| Bindings |
|
| Backtrace |
|
with recursive `laravel_cte` as ((select `fish`.*, -1 as `depth`, cast(`id` as char(65535)) as `path` from `fish` where `fish`.`id` in (23)) union all (select `fish`.*, `depth` - 1 as `depth`, concat(`path`, '.', `fish`.`id`) from `fish` inner join `laravel_cte` on `laravel_cte`.`parent_id` = `fish`.`id`)) select * from `laravel_cte`| Bindings |
|
| Backtrace |
|
select * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (21, 23, 537, 906, 908)| Bindings |
|
| Backtrace |
|
select * from `fish` where `fish`.`parent_id` in (770)| Backtrace |
|
select * from (select *, row_number() over (partition by `tags`.`context_id` order by `created_at` desc) as `laravel_row` from `tags` where `type` = 'species' and `tags`.`context_id` in (770)) as `laravel_table` where `laravel_row` <= 20 order by `laravel_row`| Bindings |
|
| Backtrace |
|
select * from `fish` where `type` = 'species' and `fish`.`id` in (770)| Bindings |
|
| Backtrace |
|
select * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (770)| Bindings |
|
| Backtrace |
|
select * from `waters` where `waters`.`id` in (770)| Bindings |
|
| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (770) and `translations`.`translatable_type` = 'App\\Models\\Water'| Bindings |
|
| Backtrace |
|
select * from `techniques` where `techniques`.`id` in (770)| Bindings |
|
| Backtrace |
|
select * from `waters` where `waters`.`id` in (770)| Bindings |
|
| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (770) and `translations`.`translatable_type` = 'App\\Models\\Water'| Bindings |
|
| Backtrace |
|
select `continents`.*, `continent_fish`.`fish_id` as `pivot_fish_id`, `continent_fish`.`continent_id` as `pivot_continent_id` from `continents` inner join `continent_fish` on `continents`.`id` = `continent_fish`.`continent_id` where `continent_fish`.`fish_id` in (770)| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (4) and `translations`.`translatable_type` = 'App\\Models\\Continent'| Bindings |
|
| Backtrace |
|
select * from `tags` where `type` = 'species' and `tags`.`context_id` in (770)| Bindings |
|
| Backtrace |
|
select * from `fish` where `type` = 'species' and `fish`.`id` in (770)| Bindings |
|
| Backtrace |
|
select * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (770)| Bindings |
|
| Backtrace |
|
select * from `waters` where `waters`.`id` in (770)| Bindings |
|
| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (770) and `translations`.`translatable_type` = 'App\\Models\\Water'| Bindings |
|
| Backtrace |
|
select * from `techniques` where `techniques`.`id` in (770)| Bindings |
|
| Backtrace |
|
select * from `waters` where `waters`.`id` in (770)| Bindings |
|
| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (770) and `translations`.`translatable_type` = 'App\\Models\\Water'| Bindings |
|
| Backtrace |
|
select * from `fish` where `type` = 'superclass'| Bindings |
|
| Backtrace |
|
select * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (908, 909, 910)| Bindings |
|
| Backtrace |
|
select * from `fish` where `fish`.`parent_id` in (908, 909, 910)| Backtrace |
|
select * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (892, 897, 898, 904, 906, 1843, 1844, 1845, 2950, 2951)| Bindings |
|
| Backtrace |
|
select * from `fish_names` where `fish_names`.`fish_id` = 770 and `fish_names`.`fish_id` is not null and `locale` = 'en' and `main` = 0| Bindings |
|
| Backtrace |
|
select `climates`.*, `climate_fish`.`fish_id` as `pivot_fish_id`, `climate_fish`.`climate_id` as `pivot_climate_id` from `climates` inner join `climate_fish` on `climates`.`id` = `climate_fish`.`climate_id` where `climate_fish`.`fish_id` = 770| Bindings |
|
| Backtrace |
|
select * from `translations` where `translations`.`translatable_type` = 'App\\Models\\Climate' and `translations`.`translatable_id` = 3 and `translations`.`translatable_id` is not null and `lang` = 'en' limit 1| Bindings |
|
| Backtrace |
|
select * from `translations` where `translations`.`translatable_type` = 'App\\Models\\Climate' and `translations`.`translatable_id` = 4 and `translations`.`translatable_id` is not null and `lang` = 'en' limit 1| Bindings |
|
| Backtrace |
|
select `continents`.*, `continent_fish`.`fish_id` as `pivot_fish_id`, `continent_fish`.`continent_id` as `pivot_continent_id` from `continents` inner join `continent_fish` on `continents`.`id` = `continent_fish`.`continent_id` where `continent_fish`.`fish_id` = 770 and `native` = 1| Bindings |
|
| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (4) and `translations`.`translatable_type` = 'App\\Models\\Continent'| Bindings |
|
| Backtrace |
|
select `continents`.*, `continent_fish`.`fish_id` as `pivot_fish_id`, `continent_fish`.`continent_id` as `pivot_continent_id` from `continents` inner join `continent_fish` on `continents`.`id` = `continent_fish`.`continent_id` where `continent_fish`.`fish_id` = 770 and `native` = 1| Bindings |
|
| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (4) and `translations`.`translatable_type` = 'App\\Models\\Continent'| Bindings |
|
| Backtrace |
|
select `continents`.*, `continent_fish`.`fish_id` as `pivot_fish_id`, `continent_fish`.`continent_id` as `pivot_continent_id` from `continents` inner join `continent_fish` on `continents`.`id` = `continent_fish`.`continent_id` where `continent_fish`.`fish_id` = 770 and `native` = 0| Bindings |
|
| Backtrace |
|
select `waters`.*, `water_fish`.`fish_id` as `pivot_fish_id`, `water_fish`.`water_id` as `pivot_water_id` from `waters` inner join `water_fish` on `waters`.`id` = `water_fish`.`water_id` where `water_fish`.`fish_id` = 770 and `is_basin` = 1| Bindings |
|
| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (427) and `translations`.`translatable_type` = 'App\\Models\\Water'| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `tags` where `tags`.`context_id` = 770 and `tags`.`context_id` is not null and `type` = 'species'| Bindings |
|
| Backtrace |
|
select * from `posts` where `posts`.`id` = 13943 limit 1| Bindings |
|
| Backtrace |
|
select * from `attachments` where `attachments`.`post_id` in (13943)| Backtrace |
|
select * from `attachments` where `attachments`.`post_id` = 13943 and `attachments`.`post_id` is not null limit 1| Bindings |
|
| Backtrace |
|
select * from `posts` where `posts`.`id` = 12538 limit 1| Bindings |
|
| Backtrace |
|
select * from `attachments` where `attachments`.`post_id` in (12538)| Backtrace |
|
select * from `attachments` where `attachments`.`post_id` = 12538 and `attachments`.`post_id` is not null limit 1| Bindings |
|
| Backtrace |
|
select * from `posts` where `posts`.`id` = 9810 limit 1| Bindings |
|
| Backtrace |
|
select * from `attachments` where `attachments`.`post_id` in (9810)| Backtrace |
|
select * from `attachments` where `attachments`.`post_id` = 9810 and `attachments`.`post_id` is not null limit 1| Bindings |
|
| Backtrace |
|
select * from `fish` where `fish`.`parent_id` = 906 and `fish`.`parent_id` is not null| Bindings |
|
| Backtrace |
|
select * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (1, 25, 51, 58, 66, 68, 69, 70, 71, 72, 191, 202, 233, 272, 301, 305, 311, 348, 369, 381, 413, 431, 521, 537, 555, 571, 582, 586, 622, 627, 676, 697, 701, 705, 707, 711, 712, 961, 980, 1009, 1019, 1037, 1095, 1189, 1311, 1410, 1420, 1744, 1799, 1855, 1859, 1863, 1867, 1874, 1878, 1879, 1880, 1887, 1891, 1895, 1899, 1905, 1911, 1920, 1927, 1931)| Bindings |
|
| Backtrace |
|
select * from `fish` where `fish`.`parent_id` = 537 and `fish`.`parent_id` is not null| Bindings |
|
| Backtrace |
|
select * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (21, 742, 1067, 1103, 1108, 1300, 1331, 1356, 1664, 1704, 1773, 1968, 2280, 2982, 3042, 3050, 3086, 3090, 3149, 3213, 3226, 3235)| Bindings |
|
| Backtrace |
|
select * from `fish` where `fish`.`parent_id` = 21 and `fish`.`parent_id` is not null| Bindings |
|
| Backtrace |
|
select * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (22, 23, 540, 546, 772, 774, 776, 778, 1637)| Bindings |
|
| Backtrace |
|
select * from `fish` where `fish`.`parent_id` = 23 and `fish`.`parent_id` is not null| Bindings |
|
| Backtrace |
|
select * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (24, 536, 538, 539, 543, 544, 554, 766, 767, 768, 769, 770, 771, 41265, 41280)| Bindings |
|
| Backtrace |
|
200
[]
[]
0 of 0array:21 [▼ "x-real-ip" => array:1 [▶ 0 => "3.16.214.124" ] "x-forwarded-server" => array:1 [▶ 0 => "traefik" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "x-forwarded-port" => array:1 [▶ 0 => "443" ] "x-forwarded-host" => array:1 [▶ 0 => "dev.tagmyfish.com" ] "x-forwarded-for" => array:1 [▶ 0 => "3.16.214.124" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "priority" => array:1 [▶ 0 => "u=0, i" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "host" => array:1 [▶ 0 => "dev.tagmyfish.com" ] ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Tue, 06 May 2025 16:42:07 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlRiRkQvalF3QWFNeExuTFlaMnc4elE9PSIsInZhbHVlIjoiVituc1M1bHYyNmY0Uy9CMzgrYXk2eUptSnM3RW5CcXJ5d2ZTRlZMajEwSDBhZ090a0lYc29UWGt4V3ZWbVVuMTNmRVRIYUVXZzRVS1NnK1FnNzlGN2ZrZDZQNlAxL2ZGRCsrQTNBYUsvdEE0SE9jMjdqUUIxU1JqbkRBTVdzcm8iLCJtYWMiOiIwNjhiNzY3NjlhNGY0NjczODY2NGM0YWQxM2E3NGZhOTAzMWEzYjFmMDNmNTJmYTNjYTAwNjU3ZjAwNjM4ZDhlIiwidGFnIjoiIn0%3D; expires=Tue, 06 May 2025 18:42:07 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlRiRkQvalF3QWFNeExuTFlaMnc4elE9PSIsInZhbHVlIjoiVituc1M1bHYyNmY0Uy9CMzgrYXk2eUptSnM3RW5CcXJ5d2ZTRlZMajEwSDBhZ090a0lYc29UWGt4V3ZWbVVuMTNmRVRIY ▶" 1 => "tagmyfish_session=eyJpdiI6Im84bmhoVktYenNHWm1VNVRZUEFieUE9PSIsInZhbHVlIjoidXRmMEUzSmpBeitvZVpuVHZFUUpSMmlaNDlOLzBzbjd0S3k5NWo3aXg0YVZpdHFxR0JUVldINzQ4K2ZidWhvYnV2M1VTMGU2T0F3SUtwRnZPYUI1eGtIUHdOUFJzTkljdGhUSHloaWtycVorWmRlVko3SlRZeWEwYVgvYmViclgiLCJtYWMiOiIyZDEwNjY0ZWRkYzZmODliMTZiMDZkMGQ0MDI3NTc1Y2ZlODJmMGM0NTE0ODE3MGVkN2UyOTE1ZTJiZGJiOTBkIiwidGFnIjoiIn0%3D; expires=Tue, 06 May 2025 18:42:07 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀tagmyfish_session=eyJpdiI6Im84bmhoVktYenNHWm1VNVRZUEFieUE9PSIsInZhbHVlIjoidXRmMEUzSmpBeitvZVpuVHZFUUpSMmlaNDlOLzBzbjd0S3k5NWo3aXg0YVZpdHFxR0JUVldINzQ4K2ZidWhvYn ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlRiRkQvalF3QWFNeExuTFlaMnc4elE9PSIsInZhbHVlIjoiVituc1M1bHYyNmY0Uy9CMzgrYXk2eUptSnM3RW5CcXJ5d2ZTRlZMajEwSDBhZ090a0lYc29UWGt4V3ZWbVVuMTNmRVRIYUVXZzRVS1NnK1FnNzlGN2ZrZDZQNlAxL2ZGRCsrQTNBYUsvdEE0SE9jMjdqUUIxU1JqbkRBTVdzcm8iLCJtYWMiOiIwNjhiNzY3NjlhNGY0NjczODY2NGM0YWQxM2E3NGZhOTAzMWEzYjFmMDNmNTJmYTNjYTAwNjU3ZjAwNjM4ZDhlIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 18:42:07 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IlRiRkQvalF3QWFNeExuTFlaMnc4elE9PSIsInZhbHVlIjoiVituc1M1bHYyNmY0Uy9CMzgrYXk2eUptSnM3RW5CcXJ5d2ZTRlZMajEwSDBhZ090a0lYc29UWGt4V3ZWbVVuMTNmRVRIY ▶" 1 => "tagmyfish_session=eyJpdiI6Im84bmhoVktYenNHWm1VNVRZUEFieUE9PSIsInZhbHVlIjoidXRmMEUzSmpBeitvZVpuVHZFUUpSMmlaNDlOLzBzbjd0S3k5NWo3aXg0YVZpdHFxR0JUVldINzQ4K2ZidWhvYnV2M1VTMGU2T0F3SUtwRnZPYUI1eGtIUHdOUFJzTkljdGhUSHloaWtycVorWmRlVko3SlRZeWEwYVgvYmViclgiLCJtYWMiOiIyZDEwNjY0ZWRkYzZmODliMTZiMDZkMGQ0MDI3NTc1Y2ZlODJmMGM0NTE0ODE3MGVkN2UyOTE1ZTJiZGJiOTBkIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 18:42:07 GMT; path=/; secure; httponly ◀tagmyfish_session=eyJpdiI6Im84bmhoVktYenNHWm1VNVRZUEFieUE9PSIsInZhbHVlIjoidXRmMEUzSmpBeitvZVpuVHZFUUpSMmlaNDlOLzBzbjd0S3k5NWo3aXg0YVZpdHFxR0JUVldINzQ4K2ZidWhvYn ▶" ] ]
0 of 0array:3 [▼ "_token" => "Oc6UHsix3yejdArz3EwGUOJhH9X5WPLFysQygsdp" "_previous" => array:1 [▶ "url" => "https://dev.tagmyfish.com/fish/species/lepomis-symmetricus" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]
