The pallid sturgeon (Scaphirhynchus albus) is an endangered species of ray-finned fish, endemic to the waters of Missouri and lower Mississippi river basins of the United States. Named for its pale coloration, it is closely related to the relatively common shovelnose sturgeon (Scaphirhynchus platorynchus), but is much larger, averaging between 30 and 60 inches (76 and 152 cm) in length and 85 pounds (39 kg) in weight at maturity. The pallid sturgeon is one of the largest freshwater fish species in North America. This species takes 15 years to mature and spawns infrequently, but can live up to a century. A member of the sturgeon family, Acipenseridae, which originated during the Cretaceous period 70 million years ago, the pallid sturgeon has changed little since then. Although visually similar, the shovelnose sturgeon is much smaller and usually weighs no more than 5 pounds (2.3 kg). Pallid sturgeon are much paler in coloration with grayish-white backs and sides, while shovelnose sturgeon are brown. Pallid sturgeon turn whiter as they age and younger specimens are easily confused with adult shovelnose sturgeon since they are similar in color. Like the shovelnose sturgeon, their tails are heterocercal, with the top tail fin being longer than the bottom fin, though this is more pronounced in pallid sturgeon. As with other sturgeon, pallid sturgeon lack the scales or bones found in more modern species of fish. Instead, they have cartilaginous skeletons with five rows of thick cartilage plates that extend along their sides, undersides, and backs, as well as over most of the head. These thick cartilage plates are covered by the skin and serve as protective armor. The bony cartilage also extends along the backside, from the dorsal fin to the tail.. The snout and head are longer than that of the shovelnose sturgeon. In both species, the mouth is located well back from the tip of the snout. Lacking teeth, they use their extendable mouths to suck up small fish, mollusks, and other food sources from river bottoms. Both species also have four barbels that descend from the snout near the front of the mouth. The barbels are believed to be sensory features to locate food sources. On pallid sturgeon, the two inner barbels are about half as long as the outer ones, while on the shovelnose sturgeon, all four barbels are the same length. The inner barbels of the pallid sturgeon are positioned in front of the outer ones, but those on the shovelnose sturgeon are all located in essentially a straight line. The length and positioning of the barbels is one of the best ways to distinguish the two species.
| 1 x Application (87.06%) | 264ms |
| 1 x Booting (12.93%) | 39.28ms |
select * from `sessions` where `id` = 'LQlQzEeNblLZY1brwSf6qPEsmMMNHvlCth3T4Niz' limit 1| Bindings |
|
| Backtrace |
|
select * from `fish` where `alias` = 'scaphirhynchus-albus' 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 (725)| 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 (723)) 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 (67, 165, 723, 908, 2950)| Bindings |
|
| Backtrace |
|
select * from `fish` where `fish`.`parent_id` in (725)| 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 (725)) as `laravel_table` where `laravel_row` <= 20 order by `laravel_row`| 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 (725)| 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 (725)| 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` = 725 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` = 725| Bindings |
|
| Backtrace |
|
select * from `translations` where `translations`.`translatable_type` = 'App\\Models\\Climate' and `translations`.`translatable_id` = 2 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` = 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` = 725 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` = 725 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` = 725 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` = 725 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` = 725 and `tags`.`context_id` is not null and `type` = 'species'| Bindings |
|
| Backtrace |
|
select * from `fish` where `fish`.`parent_id` = 2950 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 (67)| Bindings |
|
| Backtrace |
|
select * from `fish` where `fish`.`parent_id` = 67 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 (165, 794)| Bindings |
|
| Backtrace |
|
select * from `fish` where `fish`.`parent_id` = 165 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 (166, 171, 721, 723)| Bindings |
|
| Backtrace |
|
select * from `fish` where `fish`.`parent_id` = 723 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 (724, 725, 37718)| Bindings |
|
| Backtrace |
|
select * from `sessions` where `id` = 'LQlQzEeNblLZY1brwSf6qPEsmMMNHvlCth3T4Niz' limit 1| Bindings |
|
| Backtrace |
|
insert into `sessions` (`payload`, `last_activity`, `user_id`, `ip_address`, `user_agent`, `id`) values ('YTozOntzOjY6Il90b2tlbiI7czo0MDoiT1pMcWcwMkdNMXdFMFNvMTBrV1h5NHZXVFlYdTNjRzVLVHJ2VXZDUCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTk6Imh0dHBzOi8vZGV2LnRhZ215ZmlzaC5jb20vZmlzaC9zcGVjaWVzL3NjYXBoaXJoeW5jaHVzLWFsYnVzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1746414270, null, '172.18.0.2', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'LQlQzEeNblLZY1brwSf6qPEsmMMNHvlCth3T4Niz')| Bindings |
|
| Backtrace |
|
200
[]
[]
0 of 0array:35 [▼ "x-real-ip" => array:1 [▶ 0 => "172.69.59.7" ] "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 => "172.69.59.7" ] "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" ] "cf-visitor" => array:1 [▶ 0 => "{"scheme":"https"}" ] "cf-timezone" => array:1 [▶ 0 => "America/New_York" ] "cf-region-code" => array:1 [▶ 0 => "OH" ] "cf-region" => array:1 [▶ 0 => "Ohio" ] "cf-ray" => array:1 [▶ 0 => "93ad02c55c0f4783-ORD" ] "cf-postal-code" => array:1 [▶ 0 => "43215" ] "cf-metro-code" => array:1 [▶ 0 => "535" ] "cf-iplongitude" => array:1 [▶ 0 => "-83.00610" ] "cf-iplatitude" => array:1 [▶ 0 => "39.96250" ] "cf-ipcountry" => array:1 [▶ 0 => "US" ] "cf-ipcontinent" => array:1 [▶ 0 => "NA" ] "cf-ipcity" => array:1 [▶ 0 => "Columbus" ] "cf-connecting-ip" => array:1 [▶ 0 => "3.145.194.173" ] "cdn-loop" => array:1 [▶ 0 => "cloudflare; loops=1" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "accept-encoding" => array:1 [▶ 0 => "gzip, br" ] "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 => "Mon, 05 May 2025 03:04:30 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjNLRXJiZVpRL2dQcUlUMDBvZTlMZ3c9PSIsInZhbHVlIjoiSHUyd2cvUndsbzVBUEZLYXlTRGlsSHFCWE9RU2tqTmdVUEtOR0w3d0pZSVFrejJjWW0ra2RHYnIwVkFPU1VUN25PcUlLQ0Q0N1hQemU3Z2ttOHU2ZUxhOHlPZkJjM2JudVNWVlgzVC9wQmtpaTI2R1M4RVF1bnJDN0xVL1ptOGIiLCJtYWMiOiIyMjdhZmVkMzhlMWVhMGQ1OWQyNWE4OWI4MTI0NTJlNjA5Y2Q2NTU4MGRlMGI3OWMxYTQxM2ZjNTk3ODYwYTM4IiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 05:04:30 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjNLRXJiZVpRL2dQcUlUMDBvZTlMZ3c9PSIsInZhbHVlIjoiSHUyd2cvUndsbzVBUEZLYXlTRGlsSHFCWE9RU2tqTmdVUEtOR0w3d0pZSVFrejJjWW0ra2RHYnIwVkFPU1VUN25PcUlLQ ▶" 1 => "tagmyfish_session=eyJpdiI6IlY1Mm5HQkEwaG5yZDF6cExucElaSmc9PSIsInZhbHVlIjoiL1NVMWlpWXdXdFpqbzRvM3JxNUhWbjBUeDlsUytyWm4wZjU4N2FZM3dZdWlxZFRUZ1pYUkJmcGtTc1VnMlY1UUNVOTk2UGhvTjFnN1crQkphVzVKM3lFQUk1MVJsZGJ0dDdXM2lWNHU3Z1J6dkdrNjEvYlNOYU1pYlE2bVBybXQiLCJtYWMiOiJlNzNlNTUzODZlMTBhY2FkZGI0Y2IwZTJiYmU5YmI5MmY0NTkyZTBmYjFiYzg0NjdjNzYwZWVkYzdjOWY3M2IyIiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 05:04:30 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀tagmyfish_session=eyJpdiI6IlY1Mm5HQkEwaG5yZDF6cExucElaSmc9PSIsInZhbHVlIjoiL1NVMWlpWXdXdFpqbzRvM3JxNUhWbjBUeDlsUytyWm4wZjU4N2FZM3dZdWlxZFRUZ1pYUkJmcGtTc1VnMlY1UU ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjNLRXJiZVpRL2dQcUlUMDBvZTlMZ3c9PSIsInZhbHVlIjoiSHUyd2cvUndsbzVBUEZLYXlTRGlsSHFCWE9RU2tqTmdVUEtOR0w3d0pZSVFrejJjWW0ra2RHYnIwVkFPU1VUN25PcUlLQ0Q0N1hQemU3Z2ttOHU2ZUxhOHlPZkJjM2JudVNWVlgzVC9wQmtpaTI2R1M4RVF1bnJDN0xVL1ptOGIiLCJtYWMiOiIyMjdhZmVkMzhlMWVhMGQ1OWQyNWE4OWI4MTI0NTJlNjA5Y2Q2NTU4MGRlMGI3OWMxYTQxM2ZjNTk3ODYwYTM4IiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 05:04:30 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IjNLRXJiZVpRL2dQcUlUMDBvZTlMZ3c9PSIsInZhbHVlIjoiSHUyd2cvUndsbzVBUEZLYXlTRGlsSHFCWE9RU2tqTmdVUEtOR0w3d0pZSVFrejJjWW0ra2RHYnIwVkFPU1VUN25PcUlLQ ▶" 1 => "tagmyfish_session=eyJpdiI6IlY1Mm5HQkEwaG5yZDF6cExucElaSmc9PSIsInZhbHVlIjoiL1NVMWlpWXdXdFpqbzRvM3JxNUhWbjBUeDlsUytyWm4wZjU4N2FZM3dZdWlxZFRUZ1pYUkJmcGtTc1VnMlY1UUNVOTk2UGhvTjFnN1crQkphVzVKM3lFQUk1MVJsZGJ0dDdXM2lWNHU3Z1J6dkdrNjEvYlNOYU1pYlE2bVBybXQiLCJtYWMiOiJlNzNlNTUzODZlMTBhY2FkZGI0Y2IwZTJiYmU5YmI5MmY0NTkyZTBmYjFiYzg0NjdjNzYwZWVkYzdjOWY3M2IyIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 05:04:30 GMT; path=/; secure; httponly ◀tagmyfish_session=eyJpdiI6IlY1Mm5HQkEwaG5yZDF6cExucElaSmc9PSIsInZhbHVlIjoiL1NVMWlpWXdXdFpqbzRvM3JxNUhWbjBUeDlsUytyWm4wZjU4N2FZM3dZdWlxZFRUZ1pYUkJmcGtTc1VnMlY1UU ▶" ] ]
0 of 0array:3 [▼ "_token" => "OZLqg02GM1wE0So10kWXy4vWTYXu3cG5KTrvUvCP" "_previous" => array:1 [▶ "url" => "https://dev.tagmyfish.com/fish/species/scaphirhynchus-albus" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]
