Apolemichthys trimaculatus, the threespot angelfish or flagfin angelfish, is a demersal marine ray-finned fish, a marine angelfish belonging to the family Pomacanthidae. It has a wide Indo-Pacific distribution. Description Apolemichthys trimaculatus is a bright yellow species of angelfish which has blue lips, a wide black margin to the anal fin, a black spot on the forehead and an faint spot just to the rear of the operculum. The juveniles do not have the spots and show a thin black band running vertically through the eye and vertical golden barring on the flanks. The dorsal fin contains 14 spines and 16-18 soft rays while the anal fin has 3 spines and 17-19 soft rays. This species attains a maximum total length of 26 centimetres (10 in). Distribution Apolemichthys trimaculatus is widely distributed throughout the tropical waters of the Indian Ocean from the coast of East Africa between Tanzania and Mozambique to the western Pacific Ocean where it reaches as Far East as Samoa, as far north as southern Japan and as far south as New Caledonia. In Australia it is found at Ningaloo Reef, Rowley Shoals and Scott Reef all in Western Australia; Ashmore Reef in the Timor Sea and the Great Barrier Reef in Queensland.
| 1 x Application (89.35%) | 208ms |
| 1 x Booting (10.65%) | 24.73ms |
select * from `sessions` where `id` = 'RXfCXjyrkGYAg2vrwaxnKPOK0KsZ9tSOTk3EbdsC' limit 1| Bindings |
|
| Backtrace |
|
select * from `fish` where `alias` = 'apolemichthys-trimaculatus' 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 (1656)| 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 (1655)) 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 (906, 908, 961, 1651, 1655)| Bindings |
|
| Backtrace |
|
select * from `fish` where `fish`.`parent_id` in (1656)| 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 (1656)) 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 (1656)| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (1, 3, 6) and `translations`.`translatable_type` = 'App\\Models\\Continent'| Bindings |
|
| Backtrace |
|
select * from `tags` where `type` = 'species' and `tags`.`context_id` in (1656)| 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` = 1656 and `fish_names`.`fish_id` is not null and `locale` = 'en' and `main` = 0| Bindings |
|
| Backtrace |
|
select * from `fish_names` where `fish_names`.`fish_id` = 1656 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` = 1656| Bindings |
|
| Backtrace |
|
select * from `translations` where `translations`.`translatable_type` = 'App\\Models\\Climate' and `translations`.`translatable_id` = 1 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` = 1656 and `native` = 1| Bindings |
|
| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (1, 3, 6) 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` = 1656 and `native` = 1| Bindings |
|
| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (1, 3, 6) 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` = 1656 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` = 1656 and `is_basin` = 1| Bindings |
|
| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (375, 376) and `translations`.`translatable_type` = 'App\\Models\\Water'| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `tags` where `tags`.`context_id` = 1656 and `tags`.`context_id` is not null and `type` = 'species'| 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` = 961 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 (962, 1073, 1651, 1688, 1736, 1741, 2044, 2397, 2977, 3022, 3089, 3154, 3165, 3329)| Bindings |
|
| Backtrace |
|
select * from `fish` where `fish`.`parent_id` = 1651 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 (1652, 1655, 1658, 1660, 1758, 2635, 4137, 4901, 6320)| Bindings |
|
| Backtrace |
|
select * from `fish` where `fish`.`parent_id` = 1655 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 (1656, 1657, 2645, 9913, 19588, 19742, 22670, 40764, 40776)| Bindings |
|
| Backtrace |
|
select * from `sessions` where `id` = 'RXfCXjyrkGYAg2vrwaxnKPOK0KsZ9tSOTk3EbdsC' limit 1| Bindings |
|
| Backtrace |
|
insert into `sessions` (`payload`, `last_activity`, `user_id`, `ip_address`, `user_agent`, `id`) values ('YTozOntzOjY6Il90b2tlbiI7czo0MDoiREg3d1VmTXdCc0NpaHd1UURKRmJUZHk2ekozSHhYOU96dlh4UDlMZiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjU6Imh0dHBzOi8vZGV2LnRhZ215ZmlzaC5jb20vZmlzaC9zcGVjaWVzL2Fwb2xlbWljaHRoeXMtdHJpbWFjdWxhdHVzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1746408049, null, '172.18.0.2', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'RXfCXjyrkGYAg2vrwaxnKPOK0KsZ9tSOTk3EbdsC')| Bindings |
|
| Backtrace |
|
200
[]
[]
0 of 0array:35 [▼ "x-real-ip" => array:1 [▶ 0 => "172.69.6.74" ] "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.6.74" ] "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 => "93ac6ae4c8ab61fd-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 => "18.116.42.43" ] "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 01:20:49 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Iktxb2E3bVJyMUJ4Y3ZmbWtiNGVoQUE9PSIsInZhbHVlIjoiSlYvRFl5WlRIN2F1QVRXYUw0SjJqdUhPZmEveWFLVndvc1JHclU0Z3pNU0czNDRWa1d0VjFidlVHdktWUC9JU3dIZmxNclhBVEpETnlTSGc1YUZRcmFWYWJjOUc0a1d5UHB6U1doaWpBZzNmcEt5ZEhQNUZwUklsTG9lNjhmNGMiLCJtYWMiOiI2NmI2ZTQ0MWVjNDI0OTkxM2ZkMjY5ZjU2ZTM5ZjY1NjA1MjU5ZjRlMzA0OWI3ZjYzZDE1ODYwM2EwMTQxZTEyIiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 03:20:49 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Iktxb2E3bVJyMUJ4Y3ZmbWtiNGVoQUE9PSIsInZhbHVlIjoiSlYvRFl5WlRIN2F1QVRXYUw0SjJqdUhPZmEveWFLVndvc1JHclU0Z3pNU0czNDRWa1d0VjFidlVHdktWUC9JU3dIZmxNc ▶" 1 => "tagmyfish_session=eyJpdiI6IlJtYitzVHQ1MUN6dlk1Zm9YOUk1cHc9PSIsInZhbHVlIjoiV2tQMTZKOE56bWV6QnVPb2FLQ3B2ZitROHVYVFc3ZjJnS3V6c3VaVjBGUUZWSVA1Z1FZT3F0NzNiMUNBZ0t6UE5nSmE5ekVTV3o3Y1lBcFo5VEhXaFNHOXkxTDZvRExUbzhmdVRFZTdBa0g2TEhUYUpkbEpaNTJCRUoyREJIeHUiLCJtYWMiOiJmNmU0ODAzMjZkNzhlZDM2NjhiOWFhOGJhYzc0MTc0NzQzNDhmYjMxY2I3Y2JiYTA4ZWM2MDczN2VlYTk5ZDZkIiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 03:20:49 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀tagmyfish_session=eyJpdiI6IlJtYitzVHQ1MUN6dlk1Zm9YOUk1cHc9PSIsInZhbHVlIjoiV2tQMTZKOE56bWV6QnVPb2FLQ3B2ZitROHVYVFc3ZjJnS3V6c3VaVjBGUUZWSVA1Z1FZT3F0NzNiMUNBZ0t6UE ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Iktxb2E3bVJyMUJ4Y3ZmbWtiNGVoQUE9PSIsInZhbHVlIjoiSlYvRFl5WlRIN2F1QVRXYUw0SjJqdUhPZmEveWFLVndvc1JHclU0Z3pNU0czNDRWa1d0VjFidlVHdktWUC9JU3dIZmxNclhBVEpETnlTSGc1YUZRcmFWYWJjOUc0a1d5UHB6U1doaWpBZzNmcEt5ZEhQNUZwUklsTG9lNjhmNGMiLCJtYWMiOiI2NmI2ZTQ0MWVjNDI0OTkxM2ZkMjY5ZjU2ZTM5ZjY1NjA1MjU5ZjRlMzA0OWI3ZjYzZDE1ODYwM2EwMTQxZTEyIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 03:20:49 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Iktxb2E3bVJyMUJ4Y3ZmbWtiNGVoQUE9PSIsInZhbHVlIjoiSlYvRFl5WlRIN2F1QVRXYUw0SjJqdUhPZmEveWFLVndvc1JHclU0Z3pNU0czNDRWa1d0VjFidlVHdktWUC9JU3dIZmxNc ▶" 1 => "tagmyfish_session=eyJpdiI6IlJtYitzVHQ1MUN6dlk1Zm9YOUk1cHc9PSIsInZhbHVlIjoiV2tQMTZKOE56bWV6QnVPb2FLQ3B2ZitROHVYVFc3ZjJnS3V6c3VaVjBGUUZWSVA1Z1FZT3F0NzNiMUNBZ0t6UE5nSmE5ekVTV3o3Y1lBcFo5VEhXaFNHOXkxTDZvRExUbzhmdVRFZTdBa0g2TEhUYUpkbEpaNTJCRUoyREJIeHUiLCJtYWMiOiJmNmU0ODAzMjZkNzhlZDM2NjhiOWFhOGJhYzc0MTc0NzQzNDhmYjMxY2I3Y2JiYTA4ZWM2MDczN2VlYTk5ZDZkIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 03:20:49 GMT; path=/; secure; httponly ◀tagmyfish_session=eyJpdiI6IlJtYitzVHQ1MUN6dlk1Zm9YOUk1cHc9PSIsInZhbHVlIjoiV2tQMTZKOE56bWV6QnVPb2FLQ3B2ZitROHVYVFc3ZjJnS3V6c3VaVjBGUUZWSVA1Z1FZT3F0NzNiMUNBZ0t6UE ▶" ] ]
0 of 0array:3 [▼ "_token" => "DH7wUfMwBsCihwuQDJFbTdy6zJ3HxX9OzvXxP9Lf" "_previous" => array:1 [▶ "url" => "https://dev.tagmyfish.com/fish/species/apolemichthys-trimaculatus" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]
