Blackchin tilapia (Sarotherodon melanotheron)
Follow

General data

Main name: Blackchin tilapia
Local names: Blackfin Tilapia
Climates: Tropical
Habitat: Freshwater
Native: Africa
Introduced: Asia, North America
Distribution: Corubal (Tomine), Senegal, Geba, Sanaga River, Gambia River, Everglades (Florida)

Classification

Description

The blackchin tilapia (Sarotherodon melanotheron) is a species of cichlid native to coastal west Africa. It is a paternal mouthbrooder which has been introduced to Asia and North America. In the Philippines, it is also informally called gloria or tilapiang arroyo after former Philippine President Gloria Macapagal-Arroyo because of its small size and mole-like dark pigmentation under its lower jaw, resembling that of the short stature and mole on the former presidents left cheek. The blackchin tilapia, is pale in colour, that colour varying in shades including light blue, orange and golden yellow which normally has dark patches on the chin of adults. It also normally has dark colouration on the posterior edge of the gill and on the tips of the soft rays of the dorsal fin. The body is typically marked with irregular bars, spots or splotches. It has a small mouth which is equipped with as many as a few hundred tiny teeth which are arranged in 3-6 rows. They display minimal sexual dimorphism with the heads of adult males usually being slightly larger than the heads of females, some males may also show gold tinting on the operculum. The dorsal fin has 15 - 17 spines and 10-12 soft rays, the anal fin has 3 spines and 8-10 soft rays and the length of caudal peduncle is equal to 0.6-0.9 times its depth. It can grow to a maximum length of 28 centimetres (11 in) but more normally attains 18 centimetres (7 in). The blackchin tilapia is native to western Africa from Mauritania to Cameroon. It has been introduced to several countries in Asia, USA and Europe. It has also become an invasive species in Florida, Thailand, and the Philippines.

Catches

Taxonomy of Fishes

Osteichthyes - Bony fishes->
- Coelacanthi - Lobe-finned fishes->
- Teleostei - Ray-finned fishes->
  - Perciformes - Perches->
  - Cypriniformes - Carps->
  - Esociformes - Pikes->
  - Salmoniformes - Salmons and Trouts->
  - Siluriformes - Catfishes->
  - Scorpaeniformes - Mail-cheeked fishes->
  - Gasterosteiformes - Sticklebacks->
  - Gadiformes - Cods->
  - Anguilliformes - Eels and morays->
  - Clupeiformes - Herrings->
  - Syngnathiformes - Pipefishes and Seahorses->
  - Gobiiformes - Gobies->
  - Mugiliformes - Mullets->
  - Carangiformes - Jacks->
  - Beloniformes - Needlefishes->
  - Labriformes - Wrasses->
  - Scombriformes - Mackerels->
  - Mulliformes - Goatfishes->
  - Pleuronectiformes - Flatfishes->
  - Aulopiformes - Grinners->
  - Blenniiformes - Blennies->
  - Cyprinodontiformes - Toothcarps->
  - Osmeriformes - Smelts->
  - Centrarchiformes - Basses and sunfishes->
  - Cichliformes - Cichlids->
    
    Cichlidae - Cichlids->
    
    Cichla - Peacock cichlids->
    
    Oreochromis - Oreochromis->
    
    Cyphotilapia - Cyphotilapia->
    
    Parachromis - Parachromis->
    
    Astronotus - Oscars->
    
    Nimbochromis - Sleeper cichlids->
    
    Dimidiochromis - Dimidiochromis->
    
    Boulengerochromis - Giant cichlids->
    
    Crenicichla - Crenicichla->
    
    Geophagus - Eartheaters ->
    
    Herichthys - Mexican cichlids->
    
    Amatitlania - Central American cichlids->
    
    Andinoacara - Andinoacara->
    
    Neolamprologus - Neolamprologus->
    
    Mayaheros - Mayaheros->
    
    Thorichthys - Thorichthys->
    
    Sarotherodon - Sarotherodon->
    
    Blackchin tilapia (Sarotherodon melanotheron)
    
    Mango tilapia (Sarotherodon galilaeus)
    
    Fissi (Sarotherodon caroli)
    
    Sarotherodon caudomarginatus (Sarotherodon caudomarginatus)
    
    Sarotherodon knauerae (Sarotherodon knauerae)
    
    Sarotherodon lamprechti (Sarotherodon lamprechti)
    
    Blackfin tilapia (Sarotherodon linnellii)
    
    Keppi (Sarotherodon lohbergeri)
    
    Sarotherodon mvogoi (Sarotherodon mvogoi)
    
    Sarotherodon nigripinnis (Sarotherodon nigripinnis)
    
    Sarotherodon occidentalis (Sarotherodon occidentalis)
    
    Kululu (Sarotherodon steinbachi)
    
    Sarotherodon tournieri (Sarotherodon tournieri)
    
    Coptodon - Coptodon->
    
    Pelmatolapia - Pelmatolapia->
    
    Ophthalmotilapia - Ophthalmotilapia->
    
    Xenotilapia - Xenotilapia->
    
    Benthochromis - Benthochromis->
    
    Julidochromis - Julies->
    
    Melanochromis - Melanochromis->
    
    Mikrogeophagus - Ram cichlids->
    
    Abactochromis - Abactochromis->
    
    Acarichthys - Acarichthys->
    
    Acaronia - Acaronia->
    
    Aequidens - Aequidens->
    
    Chaetobranchopsis - Chaetobranchopsis->
    
    Chaetobranchus - Chaetobranchus->
    
    Chuco - Chuco->
    
    Cichlasoma - Cichlasoma->
    
    Allochromis - Allochromis->
    
    Alticorpus - Alticorpus->
    
    Altolamprologus - Altolamprologus->
    
    Amphilophus - Amphilophus->
    
    Anomalochromis - Anomalochromis->
    
    Apistogramma - Apistogramma->
    
    Apistogrammoides - Apistogrammoides->
    
    Archocentrus - Archocentrus->
    
    Aristochromis - Aristochromis->
    
    Astatheros - Astatheros->
    
    Astatoreochromis - Astatoreochromis->
    
    Astatotilapia - Astatotilapia->
    
    Aulonocara - Aulonocara->
    
    Aulonocranus - Aulonocranus->
    
    Australoheros - Australoheros->
    
    Baileychromis - Baileychromis->
    
    Bathybates - Bathybates->
    
    Benitochromis - Benitochromis->
    
    Biotodoma - Biotodoma->
    
    Biotoecus - Biotoecus->
    
    Buccochromis - Buccochromis->
    
    Bujurquina - Bujurquina->
    
    Callochromis - Callochromis->
    
    Caprichromis - Caprichromis->
    
    Caquetaia - Caquetaia->
    
    Cardiopharynx - Cardiopharynx->
    
    Chalinochromis - Chalinochromis->
    
    Champsochromis - Champsochromis->
    
    Cheilochromis - Cheilochromis->
    
    Chetia - Chetia->
    
    Chiapaheros - Chiapaheros->
    
    Chilochromis - Chilochromis->
    
    Chilotilapia - Chilotilapia->
    
    Chindongo - Chindongo->
    
    Chocoheros - Chocoheros->
    
    Chortiheros - Chortiheros->
    
    Chromidotilapia - Chromidotilapia->
    
    Cincelichthys - Cincelichthys->
    
    Diplotaxodon - Diplotaxodon->
    
    Enigmatochromis - Enigmatochromis->
    
    Hemitaeniochromis - Hemitaeniochromis->
    
    Hemitilapia - Hemitilapia->
    
    Cleithracara - Cleithracara->
    
    Coelotilapia - Coelotilapia->
    
    Congochromis - Congochromis->
    
    Congolapia - Congolapia->
    
    Copadichromis - Copadichromis->
    
    Corematodus - Corematodus->
    
    Crenicara - Crenicara->
    
    Cribroheros - Cribroheros->
    
    Cryptoheros - Cryptoheros->
    
    Ctenochromis - Ctenochromis->
    
    Ctenopharynx - Ctenopharynx->
    
    Cunningtonia - Cunningtonia->
    
    Cyathochromis - Cyathochromis->
    
    Cyathopharynx - Cyathopharynx->
    
    Cyclopharynx - Cyclopharynx->
    
    Cynotilapia - Cynotilapia->
    
    Cyprichromis - Cyprichromis->
    
    Cyrtocara - Cyrtocara->
    
    Danakilia - Danakilia->
    
    Darienheros - Darienheros->
    
    Dicrossus - Dicrossus->
    
    Divandu - Divandu->
    
    Docimodus - Docimodus->
    
    Eclectochromis - Eclectochromis->
    
    Ectodus - Ectodus->
    
    Eretmodus - Eretmodus->
    
    Etia - Etia->
    
    Etroplus - Etroplus->
    
    Exochochromis - Exochochromis->
    
    Fossorochromis - Fossorochromis->
    
    Gaurochromis - Gaurochromis->
    
    Genyochromis - Genyochromis->
    
    Gephyrochromis - Gephyrochromis->
    
    Gnathochromis - Gnathochromis->
    
    Gobiocichla - Gobiocichla->
    
    Grammatotria - Grammatotria->
    
    Greenwoodochromis - Greenwoodochromis->
    
    Guianacara - Guianacara->
    
    Gymnogeophagus - Gymnogeophagus->
    
    Haplochromis - Haplochromis->
    
    Haplotaxodon - Haplotaxodon->
    
    Hemibates - Hemibates->
    
    Hemichromis - Hemichromis->
    
    Katria - Katria->
    
    Mesoheros - Mesoheros->
    
    Mesonauta - Mesonauta->
    
    Heroina - Heroina->
    
    Heros - Heros->
    
    Herotilapia - Herotilapia->
    
    Heterochromis - Heterochromis->
    
    Heterotilapia - Heterotilapia->
    
    Hoplarchus - Hoplarchus->
    
    Hypselecara - Hypselecara->
    
    Hypsophrys - Hypsophrys->
    
    Interochromis - Interochromis->
    
    Iodotropheus - Iodotropheus->
    
    Iranocichla - Iranocichla->
    
    Isthmoheros - Isthmoheros->
    
    Kihnichthys - Kihnichthys->
    
    Konia - Konia->
    
    Krobia - Krobia->
    
    Kronoheros - Kronoheros->
    
    Labeotropheus - Labeotropheus->
    
    Labidochromis - Labidochromis->
    
    Laetacara - Laetacara->
    
    Lamprologus - Lamprologus->
    
    Lepidiolamprologus - Lepidiolamprologus->
    
    Lestradea - Lestradea->
    
    Lethrinops - Lethrinops->
    
    Lichnochromis - Lichnochromis->
    
    Limbochromis - Limbochromis->
    
    Limnochromis - Limnochromis->
    
    Limnotilapia - Limnotilapia->
    
    Lithochromis - Lithochromis->
    
    Lobochilotes - Lobochilotes->
    
    Lufubuchromis - Lufubuchromis->
    
    Maskaheros - Maskaheros->
    
    Maylandia - Maylandia->
    
    Mazarunia - Mazarunia->
    
    Mbipia - Mbipia->
    
    Mchenga - Mchenga->
    
    Microchromis - Microchromis->
    
    Otopharynx - Otopharynx->
    
    Oxylapia - Oxylapia->
    
    Paralabidochromis - Paralabidochromis->
    
    Myaka - Myaka->
    
    Mylochromis - Mylochromis->
    
    Naevochromis - Naevochromis->
    
    Nandopsis - Nandopsis->
    
    Nannacara - Nannacara->
    
    Nanochromis - Nanochromis->
    
    Neochromis - Neochromis->
    
    Nyassachromis - Nyassachromis->
    
    Orthochromis - Orthochromis->
    
    Oscura - Oscura->
    
    Palaeoplex - Palaeoplex->
    
    Pallidochromis - Pallidochromis->
    
    Panamius - Panamius->
    
    Paracyprichromis - Paracyprichromis->
    
    Paragobiocichla - Paragobiocichla->
    
    Parananochromis - Parananochromis->
    
    Paraneetroplus - Paraneetroplus->
    
    Paratilapia - Paratilapia->
    
    Paretroplus - Paretroplus->
    
    Pelmatochromis - Pelmatochromis->
    
    Pelvicachromis - Pelvicachromis->
    
    Perissodus - Perissodus->
    
    Petenia - Petenia->
    
    Petrochromis - Petrochromis->
    
    Petrotilapia - Petrotilapia->
    
    Pharyngochromis - Pharyngochromis->
    
    Pterochromis - Pterochromis->
    
    Placidochromis - Placidochromis->
    
    Platytaeniodus - Platytaeniodus->
    
    Plecodus - Plecodus->
    
    Protomelas - Protomelas->
    
    Pseudetroplus - Pseudetroplus->
    
    Pseudocrenilabrus - Pseudocrenilabrus->
    
    Pseudosimochromis - Pseudosimochromis->
    
    Pseudotropheus - Pseudotropheus->
    
    Pterophyllum - Pterophyllum->
    
    Ptychochromis - Ptychochromis->
    
    Ptychochromoides - Ptychochromoides->
    
    Pundamilia - Pundamilia->
    
    Pungu - Pungu->
    
    Pyxichromis - Pyxichromis->
    
    Reganochromis - Reganochromis->
    
    Retroculus - Retroculus->
    
    Rhamphochromis - Rhamphochromis->
    
    Rheoheros - Rheoheros->
    
    Rocio - Rocio->
    
    Rondonacara - Rondonacara->
    
    Sargochromis - Sargochromis->
    
    Tangachromis - Tangachromis->
    
    Tanganicodus - Tanganicodus->
    
    Satanoperca - Satanoperca->
    
    Schwetzochromis - Schwetzochromis->
    
    Sciaenochromis - Sciaenochromis->
    
    Serranochromis - Serranochromis->
    
    Shuja - Shuja->
    
    Simochromis - Simochromis->
    
    Spathodus - Spathodus->
    
    Steatocranus - Steatocranus->
    
    Stigmatochromis - Stigmatochromis->
    
    Stomatepia - Stomatepia->
    
    Symphysodon - Symphysodon->
    
    Taeniacara - Taeniacara->
    
    Taeniochromis - Taeniochromis->
    
    Taeniolethrinops - Taeniolethrinops->
    
    Tahuantinsuyoa - Tahuantinsuyoa->
    
    Talamancaheros - Talamancaheros->
    
    Teleocichla - Teleocichla->
    
    Teleogramma - Teleogramma->
    
    Telmatochromis - Telmatochromis->
    
    Theraps - Theraps->
    
    Thoracochromis - Thoracochromis->
    
    Thysochromis - Thysochromis->
    
    Tilapia - Tilapia->
    
    Tomocichla - Tomocichla->
    
    Tramitichromis - Tramitichromis->
    
    Trematocara - Trematocara->
    
    Trematochromis - Trematochromis->
    
    Trematocranus - Trematocranus->
    
    Trichromis - Trichromis->
    
    Triglachromis - Triglachromis->
    
    Tristramella - Tristramella->
    
    Tropheops - Tropheops->
    
    Tropheus - Tropheus->
    
    Tylochromis - Tylochromis->
    
    Tyrannochromis - Tyrannochromis->
    
    Uaru - Uaru->
    
    Variabilichromis - Variabilichromis->
    
    Vieja - Vieja->
    
    Wajpamheros - Wajpamheros->
    
    Wallaceochromis - Wallaceochromis->
    
    Xenochromis - Xenochromis->
    
    Yssichromis - Yssichromis->
    
    Rubricatochromis - Rubricatochromis->
    
    Pholidichthyidae - Convict blenny->
    
    Polycentridae - Leaffishes->
  - Characiformes - Characins->
  - Osteoglossiformes - Bony tongues->
  - Elopiformes - Tarpons and tenpounders->
  - Anabantiformes - Gouramies and snakeheads->
  - Gymnotiformes - South American knifefish->
  - Istiophoriformes - Barracudas->
  - Albuliformes - Bonefishes->
  - Lepidogalaxiiformes - Salamanderfishes->
  - Lophiiformes - Anglerfishes->
  - Spariformes - Breams and porgies->
  - Trachiniformes - Weeverfishes->
  - Moroniformes - Temperate basses->
  - Acanthuriformes - Surgeonfishes->
  - Zeiformes - Dories->
  - Tetraodontiformes - Puffers and filefishes->
  - Holocentriformes - Squirrelfishes->
  - Dactylopteriformes - Flying gurnards->
  - Lampriformes - Lamprids->
  - Galaxiiformes - Southern smelts->
  - Batrachoidiformes - Toadfishes->
  - Hiodontiformes - Mooneyes->
  - Percopsiformes - Trout-perches->
  - Callionymiformes - Dragonets->
  - Atheriniformes - Silversides->
  - Notacanthiformes - Spiny eels->
  - Saccopharyngiformes - Swallowers and Gulpers->
  - Alepocephaliformes - Slickheads and tubeshoulders->
  - Gonorynchiformes - Milkfishes->
  - Argentiniformes - Marine smelts->
  - Stomiiformes - Lightfishes and dragonfishes->
  - Ateleopodiformes - Jellynose fishes->
  - Myctophiformes - Lanternfishes->
  - Stylephoriformes - Tube-eyes->
  - Polymixiiformes - Beardfishes->
  - Beryciformes - Sawbellies->
  - Trachichthyiformes - Rughies->
  - Ophidiiformes - Cusk-eels->
  - Kurtiformes - Nurseryfishes & Cardinalfishes->
  - Synbranchiformes - Swamp eels->
  - Gobiesociformes - Clingfishes->
  - Acropomatiformes - Oceanic basses->
- Cladistii - Bichirs->
- Dipneusti - Lungfishes->
- Chondrostei - Sturgeons->
- Holostei - Gars and Bowfins->
Chondrichthyes - Cartilaginous fishes->
Agnatha - Jawless fishes->

Messages Timeline Exceptions Views348 Route Queries65 Models522 Mails Gate Session Request

Request history8.2.28342ms5MBGET fish/{type}/{alias}

Booting (23.67ms)time
Application (318ms)time
1 x Application (93.07%)
318ms
1 x Booting (6.92%)
23.67ms

348 templates were rendered

1x fish.singlesingle.blade.php#?blade
1x fish.taxonomytaxonomy.blade.php#?blade
1x elements.tabnavtabnav.blade.php#?blade
4x elements.gallery-itemgallery-item.blade.php#?blade
1x layout.indexindex.blade.php#?blade
1x layout.headhead.blade.php#?blade
1x layout.pwapwa.blade.php#?blade
1x layout.topnavtopnav.blade.php#?blade
1x layout.sidebar-leftsidebar-left.blade.php#?blade
1x layout.footerfooter.blade.php#?blade
1x layout.sidebar-rightsidebar-right.blade.php#?blade
1x fish.treetree.blade.php#?blade
331x fish.childrenchildren.blade.php#?blade
1x layout.mobilenavmobilenav.blade.php#?blade
1x modals.modalDefaultmodalDefault.blade.php#?blade

uri: GET fish/{type}/{alias}
middleware: web
controller: App\Http\Controllers\FishController@show
namespace
prefix
where
as: fish.show
file: app/Http/Controllers/FishController.php:20-41

65 statements were executed (27 duplicates)Show only duplicates180ms

DatabaseSessionHandler.php#97tmf520μsselect * from `sessions` where `id` = 'cc8ReLXYInIaEGek4knEfJQak9wzaVw5yTnWk8Xk' limit 1

Bindings	0: cc8ReLXYInIaEGek4knEfJQak9wzaVw5yTnWk8Xk
Backtrace	vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:97 vendor/laravel/framework/src/Illuminate/Session/Store.php:116 vendor/laravel/framework/src/Illuminate/Session/Store.php:104 vendor/laravel/framework/src/Illuminate/Session/Store.php:88 vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:147

BuildsAdjacencyListQueries.php#27tmf410μsselect * from `fish` where `alias` = 'sarotherodon-melanotheron' and `type` = 'species' and `published` = 1 limit 1

Bindings	0: sarotherodon-melanotheron 1: species 2: 1
Backtrace	vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:27 app/Http/Controllers/FishController.php:23 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

FishController.php#23tmf470μsselect * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (2123)

Bindings	0: en 1: 1
Backtrace	app/Http/Controllers/FishController.php:23 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

BuildsAdjacencyListQueries.php#27tmf680μs

with recursive `laravel_cte` as ((select `fish`.*, -1 as `depth`, cast(`id` as char(65535)) as `path` from `fish` where `fish`.`id` in (2122)) 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	0: .
Backtrace	vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:27 app/Http/Controllers/FishController.php:23 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

FishController.php#23tmf550μsselect * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (555, 556, 906, 908, 2122)

Bindings	0: en 1: 1
Backtrace	app/Http/Controllers/FishController.php:23 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

BuildsAdjacencyListQueries.php#27tmf310μsselect * from `fish` where `fish`.`parent_id` in (2123)

Backtrace

vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:27
app/Http/Controllers/FishController.php:23
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

FishController.php#23tmf27.84ms

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 (2123)) as `laravel_table` where `laravel_row` <= 100 order by `laravel_row`

Bindings	0: species
Backtrace	app/Http/Controllers/FishController.php:23 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

BuildsAdjacencyListQueries.php#27tmf2.34msselect * from `fish` where `type` = 'species' and `fish`.`id` in (2123)

Bindings	0: species 1: 2123
Backtrace	vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:27 app/Http/Controllers/FishController.php:23 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

FishController.php#23tmf1.31msselect * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (2123)

Bindings	0: en 1: 1
Backtrace	app/Http/Controllers/FishController.php:23 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

BuildsAdjacencyListQueries.php#27tmf1.25msselect * from `waters` where `waters`.`id` in (2123)

Bindings	0: 2123
Backtrace	vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:27 app/Http/Controllers/FishController.php:23 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

FishController.php#23tmf1.35ms

select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (2123) and `translations`.`translatable_type` = 'App\\Models\\Water'

Bindings	0: en 1: App\Models\Water
Backtrace	app/Http/Controllers/FishController.php:23 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

FishController.php#23tmf1.09msselect * from `techniques` where `techniques`.`id` in (2123)

Bindings	0: 2123
Backtrace	app/Http/Controllers/FishController.php:23 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

BuildsAdjacencyListQueries.php#27tmf2.51msselect * from `waters` where `waters`.`id` in (2123)

Bindings	0: 2123
Backtrace	vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:27 app/Http/Controllers/FishController.php:23 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

FishController.php#23tmf1.28ms

select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (2123) and `translations`.`translatable_type` = 'App\\Models\\Water'

Bindings	0: en 1: App\Models\Water
Backtrace	app/Http/Controllers/FishController.php:23 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

FishController.php#23tmf1.63ms

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 (2123)

Backtrace

app/Http/Controllers/FishController.php:23
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

FishController.php#23tmf3.38ms

select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (1, 3, 4) and `translations`.`translatable_type` = 'App\\Models\\Continent'

Bindings	0: en 1: App\Models\Continent
Backtrace	app/Http/Controllers/FishController.php:23 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

FishController.php#23tmf24.46msselect * from `tags` where `type` = 'species' and `tags`.`context_id` in (2123)

Bindings	0: species
Backtrace	app/Http/Controllers/FishController.php:23 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

BuildsAdjacencyListQueries.php#27tmf520μsselect * from `fish` where `type` = 'species' and `fish`.`id` in (2123)

Bindings	0: species 1: 2123
Backtrace	vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:27 app/Http/Controllers/FishController.php:23 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

FishController.php#23tmf380μsselect * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (2123)

Bindings	0: en 1: 1
Backtrace	app/Http/Controllers/FishController.php:23 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

BuildsAdjacencyListQueries.php#27tmf410μsselect * from `waters` where `waters`.`id` in (2123)

Bindings	0: 2123
Backtrace	vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:27 app/Http/Controllers/FishController.php:23 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

FishController.php#23tmf420μs

select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (2123) and `translations`.`translatable_type` = 'App\\Models\\Water'

Bindings	0: en 1: App\Models\Water
Backtrace	app/Http/Controllers/FishController.php:23 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

FishController.php#23tmf480μsselect * from `techniques` where `techniques`.`id` in (2123)

Bindings	0: 2123
Backtrace	app/Http/Controllers/FishController.php:23 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

BuildsAdjacencyListQueries.php#27tmf360μsselect * from `waters` where `waters`.`id` in (2123)

Bindings	0: 2123
Backtrace	vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:27 app/Http/Controllers/FishController.php:23 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

FishController.php#23tmf440μs

select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (2123) and `translations`.`translatable_type` = 'App\\Models\\Water'

Bindings	0: en 1: App\Models\Water
Backtrace	app/Http/Controllers/FishController.php:23 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

BuildsAdjacencyListQueries.php#27tmf55.48msselect * from `fish` where `type` = 'superclass'

Bindings	0: superclass
Backtrace	vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:27 app/Http/Controllers/FishController.php:28 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

FishController.php#28tmf400μsselect * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (908, 909, 910)

Bindings	0: en 1: 1
Backtrace	app/Http/Controllers/FishController.php:28 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

BuildsAdjacencyListQueries.php#27tmf360μsselect * from `fish` where `fish`.`parent_id` in (908, 909, 910)

Backtrace

vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:27
app/Http/Controllers/FishController.php:28
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47
vendor/laravel/framework/src/Illuminate/Routing/Route.php:266
vendor/laravel/framework/src/Illuminate/Routing/Route.php:212

FishController.php#28tmf440μs

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	0: en 1: 1
Backtrace	app/Http/Controllers/FishController.php:28 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:47 vendor/laravel/framework/src/Illuminate/Routing/Route.php:266 vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 vendor/laravel/framework/src/Illuminate/Routing/Router.php:808

single.blade.php#33tmf340μs

select * from `fish_names` where `fish_names`.`fish_id` = 2123 and `fish_names`.`fish_id` is not null and `locale` = 'en' and `main` = 0

Bindings	0: 2123 1: en 2: 0
Backtrace	view::fish.single:33 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75 vendor/laravel/framework/src/Illuminate/View/View.php:209

single.blade.php#34tmf360μs

select * from `fish_names` where `fish_names`.`fish_id` = 2123 and `fish_names`.`fish_id` is not null and `locale` = 'en' and `main` = 0

Bindings	0: 2123 1: en 2: 0
Backtrace	view::fish.single:34 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75 vendor/laravel/framework/src/Illuminate/View/View.php:209

single.blade.php#38tmf1.32ms

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` = 2123

Bindings	0: 2123
Backtrace	view::fish.single:38 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75 vendor/laravel/framework/src/Illuminate/View/View.php:209

HasTranslations.php#16tmf620μs

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	0: App\Models\Climate 1: 1 2: en
Backtrace	app/Traits/HasTranslations.php:16 view::fish.single:39 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

Fish.php#248tmf1.59ms

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` = 2123 and `native` = 1

Bindings	0: 2123 1: 1
Backtrace	app/Models/Fish.php:248 view::fish.single:46 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

Fish.php#248tmf680μs

select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (1) and `translations`.`translatable_type` = 'App\\Models\\Continent'

Bindings	0: en 1: App\Models\Continent
Backtrace	app/Models/Fish.php:248 view::fish.single:46 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

Fish.php#248tmf1.65ms

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` = 2123 and `native` = 1

Bindings	0: 2123 1: 1
Backtrace	app/Models/Fish.php:248 view::fish.single:48 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

Fish.php#248tmf510μs

select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (1) and `translations`.`translatable_type` = 'App\\Models\\Continent'

Bindings	0: en 1: App\Models\Continent
Backtrace	app/Models/Fish.php:248 view::fish.single:48 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

Fish.php#252tmf1.56ms

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` = 2123 and `native` = 0

Bindings	0: 2123 1: 0
Backtrace	app/Models/Fish.php:252 view::fish.single:54 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

Fish.php#252tmf590μs

select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (3, 4) and `translations`.`translatable_type` = 'App\\Models\\Continent'

Bindings	0: en 1: App\Models\Continent
Backtrace	app/Models/Fish.php:252 view::fish.single:54 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

Fish.php#252tmf1.69ms

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` = 2123 and `native` = 0

Bindings	0: 2123 1: 0
Backtrace	app/Models/Fish.php:252 view::fish.single:56 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

Fish.php#252tmf420μs

select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (3, 4) and `translations`.`translatable_type` = 'App\\Models\\Continent'

Bindings	0: en 1: App\Models\Continent
Backtrace	app/Models/Fish.php:252 view::fish.single:56 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

BuildsAdjacencyListQueries.php#27tmf540μs

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` = 2123 and `is_basin` = 1

Bindings	0: 2123 1: 1
Backtrace	vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:27 view::fish.single:63 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

single.blade.php#63tmf490μs

select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (920, 921, 922, 923, 924, 940) and `translations`.`translatable_type` = 'App\\Models\\Water'

Bindings	0: en 1: App\Models\Water
Backtrace	view::fish.single:63 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75 vendor/laravel/framework/src/Illuminate/View/View.php:209

HasTags.php#23tmf18.42ms

select count(*) as aggregate from `tags` where `tags`.`context_id` = 2123 and `tags`.`context_id` is not null and `type` = 'species'

Bindings	0: 2123 1: species
Backtrace	app/Traits/HasTags.php:23 view::elements.tabnav:8 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

gallery-item.blade.php#2tmf570μsselect * from `posts` where `posts`.`id` = 12606 limit 1

Bindings	0: 12606
Backtrace	view::elements.gallery-item:2 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75 vendor/laravel/framework/src/Illuminate/View/View.php:209

gallery-item.blade.php#2tmf420μsselect * from `attachments` where `attachments`.`post_id` in (12606)

Backtrace

view::elements.gallery-item:2
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
vendor/laravel/framework/src/Illuminate/View/View.php:209

gallery-item.blade.php#4tmf420μsselect * from `attachments` where `attachments`.`post_id` = 12606 and `attachments`.`post_id` is not null limit 1

Bindings	0: 12606
Backtrace	view::elements.gallery-item:4 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75 vendor/laravel/framework/src/Illuminate/View/View.php:209

gallery-item.blade.php#2tmf370μsselect * from `posts` where `posts`.`id` = 8356 limit 1

Bindings	0: 8356
Backtrace	view::elements.gallery-item:2 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75 vendor/laravel/framework/src/Illuminate/View/View.php:209

gallery-item.blade.php#2tmf460μsselect * from `attachments` where `attachments`.`post_id` in (8356)

Backtrace

view::elements.gallery-item:2
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
vendor/laravel/framework/src/Illuminate/View/View.php:209

gallery-item.blade.php#4tmf500μsselect * from `attachments` where `attachments`.`post_id` = 8356 and `attachments`.`post_id` is not null limit 1

Bindings	0: 8356
Backtrace	view::elements.gallery-item:4 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75 vendor/laravel/framework/src/Illuminate/View/View.php:209

gallery-item.blade.php#2tmf450μsselect * from `posts` where `posts`.`id` = 7633 limit 1

Bindings	0: 7633
Backtrace	view::elements.gallery-item:2 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75 vendor/laravel/framework/src/Illuminate/View/View.php:209

gallery-item.blade.php#2tmf370μsselect * from `attachments` where `attachments`.`post_id` in (7633)

Backtrace

view::elements.gallery-item:2
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
vendor/laravel/framework/src/Illuminate/View/View.php:209

gallery-item.blade.php#4tmf330μsselect * from `attachments` where `attachments`.`post_id` = 7633 and `attachments`.`post_id` is not null limit 1

Bindings	0: 7633
Backtrace	view::elements.gallery-item:4 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75 vendor/laravel/framework/src/Illuminate/View/View.php:209

gallery-item.blade.php#2tmf330μsselect * from `posts` where `posts`.`id` = 2104 limit 1

Bindings	0: 2104
Backtrace	view::elements.gallery-item:2 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75 vendor/laravel/framework/src/Illuminate/View/View.php:209

gallery-item.blade.php#2tmf470μsselect * from `attachments` where `attachments`.`post_id` in (2104)

Backtrace

view::elements.gallery-item:2
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
vendor/laravel/framework/src/Illuminate/View/View.php:209

gallery-item.blade.php#4tmf420μsselect * from `attachments` where `attachments`.`post_id` = 2104 and `attachments`.`post_id` is not null limit 1

Bindings	0: 2104
Backtrace	view::elements.gallery-item:4 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75 vendor/laravel/framework/src/Illuminate/View/View.php:209

BuildsAdjacencyListQueries.php#27tmf840μsselect * from `fish` where `fish`.`parent_id` = 906 and `fish`.`parent_id` is not null

Bindings	0: 906
Backtrace	vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:27 view::fish.children:5 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

children.blade.php#5tmf1.26ms

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	0: en 1: 1
Backtrace	view::fish.children:5 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75 vendor/laravel/framework/src/Illuminate/View/View.php:209

BuildsAdjacencyListQueries.php#27tmf690μsselect * from `fish` where `fish`.`parent_id` = 555 and `fish`.`parent_id` is not null

Bindings	0: 555
Backtrace	vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:27 view::fish.children:5 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

children.blade.php#5tmf520μsselect * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (556, 3240, 3249)

Bindings	0: en 1: 1
Backtrace	view::fish.children:5 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75 vendor/laravel/framework/src/Illuminate/View/View.php:209

BuildsAdjacencyListQueries.php#27tmf1.71msselect * from `fish` where `fish`.`parent_id` = 556 and `fish`.`parent_id` is not null

Bindings	0: 556
Backtrace	vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:27 view::fish.children:5 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

children.blade.php#5tmf1.24ms

select * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (557, 976, 978, 1061, 1127, 1186, 1208, 1319, 1344, 1389, 1399, 1495, 1732, 1734, 2038, 2120, 2122, 2124, 2176, 2204, 2206, 2207, 2212, 2215, 2765, 3340, 3383, 3385, 3415, 3494, 3495, 3497, 3498, 3505, 3516, 3518, 3559, 3591, 3627, 3628, 3666, 3686, 3725, 3726, 3727, 3777, 3778, 3785, 3805, 3847, 3903, 3926, 3927, 4016, 4020, 4048, 4062, 4068, 4076, 4142, 4146, 4170, 4189, 4190, 4195, 4201, 4204, 4219, 4226, 4230, 4238, 4248, 4273, 4283, 4285, 4309, 4336, 4351, 4353, 4369, 4381, 4412, 4419, 4437, 4455, 4459, 4470, 4476, 4477, 4481, 4501, 4506, 4510, 4531, 4537, 4600, 4633, 4635, 4680, 4682, 4744, 4769, 4770, 4823, 4863, 4896, 4907, 4912, 4949, 4958, 4992, 4999, 5005, 5035, 5076, 5080, 5112, 5115, 5159, 5173, 5174, 5182, 5183, 5184, 5194, 5208, 5248, 5289, 5296, 5336, 5338, 5345, 5361, 5401, 5410, 5421, 5423, 5435, 5438, 5458, 5476, 5508, 5572, 5581, 5595, 5599, 5602, 5605, 5626, 5634, 5678, 5751, 5763, 5765, 5766, 5768, 5824, 5920, 5932, 5947, 5956, 5961, 5979, 5984, 5987, 6003, 6060, 6160, 6250, 6255, 6286, 6289, 6294, 6337, 6347, 6363, 6366, 6417, 6440, 6487, 6492, 6515, 6525, 6531, 6533, 6550, 6603, 6642, 6673, 6677, 6806, 6845, 6868, 6922, 6934, 6957, 6970, 6971, 6974, 6975, 6990, 7030, 7039, 7057, 7061, 7106, 7115, 7155, 7159, 7160, 7186, 7221, 7224, 7278, 7285, 7308, 7355, 7396, 7431, 7440, 7477, 7495, 7498, 7500, 7502, 7504, 7525, 7526, 7529, 7564, 7570, 7586, 7588, 7600, 7631, 7634, 7635, 7636, 7652, 7658, 7677, 7684, 7685, 7700, 7711, 7716, 7738, 7751, 7762, 7763, 7784, 7824, 41267)

Bindings	0: en 1: 1
Backtrace	view::fish.children:5 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75 vendor/laravel/framework/src/Illuminate/View/View.php:209

BuildsAdjacencyListQueries.php#27tmf760μsselect * from `fish` where `fish`.`parent_id` = 2122 and `fish`.`parent_id` is not null

Bindings	0: 2122
Backtrace	vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:27 view::fish.children:5 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

children.blade.php#5tmf590μs

select * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (2123, 2384, 13326, 13546, 22748, 23294, 24224, 24345, 28425, 29233, 29986, 37140, 38782)

Bindings	0: en 1: 1
Backtrace	view::fish.children:5 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75 vendor/laravel/framework/src/Illuminate/View/View.php:209

DatabaseSessionHandler.php#97tmf620μsselect * from `sessions` where `id` = 'cc8ReLXYInIaEGek4knEfJQak9wzaVw5yTnWk8Xk' limit 1

Bindings	0: cc8ReLXYInIaEGek4knEfJQak9wzaVw5yTnWk8Xk
Backtrace	vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:97 vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:136 vendor/laravel/framework/src/Illuminate/Session/Store.php:175 vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:245 vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:130

DatabaseSessionHandler.php#158tmf4.93ms

insert into `sessions` (`payload`, `last_activity`, `user_id`, `ip_address`, `user_agent`, `id`) values ('YTozOntzOjY6Il90b2tlbiI7czo0MDoib0IxY28zNE9Ud2V4V2UxTGE1dWFYMXZPMll1bzdrc09YZm5JVFE1ZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjQ6Imh0dHBzOi8vZGV2LnRhZ215ZmlzaC5jb20vZmlzaC9zcGVjaWVzL3Nhcm90aGVyb2Rvbi1tZWxhbm90aGVyb24iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1750913272, null, '172.18.0.2', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'cc8ReLXYInIaEGek4knEfJQak9wzaVw5yTnWk8Xk')

Bindings

0: YTozOntzOjY6Il90b2tlbiI7czo0MDoib0IxY28zNE9Ud2V4V2UxTGE1dWFYMXZPMll1bzdrc09YZm5JVFE1ZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjQ6Imh0dHBzOi8vZGV2LnRhZ215ZmlzaC5jb20vZmlzaC9zcGVjaWVzL3Nhcm90aGVyb2Rvbi1tZWxhbm90aGVyb24iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19
1: 1750913272
2:
3: 172.18.0.2
4: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
5: cc8ReLXYInIaEGek4knEfJQak9wzaVw5yTnWk8Xk

Backtrace

vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:158
vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:142
vendor/laravel/framework/src/Illuminate/Session/Store.php:175
vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:245
vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:130

App\Models\Fish: 356Fish.php#?
App\Models\FishName: 106FishName.php#?
App\Models\Translation: 20Translation.php#?
App\Models\Water: 10Water.php#?
App\Models\Continent: 9Continent.php#?
App\Models\Tag: 8Tag.php#?
App\Models\Attachment: 8Attachment.php#?
App\Models\Post: 4Post.php#?
App\Models\Climate: 1Climate.php#?

_token: oB1co34OTwexWe1La5uaX1vO2Yuo7ksOXfnITQ5d
_previous: array:1 [ "url" => "https://dev.tagmyfish.com/fish/species/sarotherodon-melanotheron" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/fish/species/sarotherodon-melanotheron

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:35 [▼
  "x-real-ip" => array:1 [▶
    0 => "172.69.17.96"
  ]
  "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.17.96"
  ]
  "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 => "955a11ad8a147dd6-ORD"
  ]
  "cf-postal-code" => array:1 [▶
    0 => "43215"
  ]
  "cf-metro-code" => array:1 [▶
    0 => "0"
  ]
  "cf-iplongitude" => array:1 [▶
    0 => "-82.99879"
  ]
  "cf-iplatitude" => array:1 [▶
    0 => "39.96118"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "cf-ipcontinent" => array:1 [▶
    0 => "NA"
  ]
  "cf-ipcity" => array:1 [▶
    0 => "Columbus"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "216.73.216.67"
  ]
  "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"
  ]
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Thu, 26 Jun 2025 04:47:52 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjEwMXdYSFFURldHTjVHcThZYzRJWkE9PSIsInZhbHVlIjoiWHpmK2x0TUU1V0twalBaQjN0dnBYQ0hNdjZVNW9FdDE1MFNqcEQ5L2U2djcrdGg4eFliQkdMN0ptWWtOSHVyNXRDVTN4emp5Zzlxd09iektDQ2FPQmZPSHRPN3JuRHRSNkYxK0dBU1Y0OGhtVFZIT0M3bmtWNkNvZVVyTzBnMzYiLCJtYWMiOiJkNmY0NGRjYmQwOTkzOGJjMjRhNmE4YTk0NjM1ZmNiOGJjOGExYWJiY2MwOTFmNDJmMmQzZTIxNjUwOWU1YmE3IiwidGFnIjoiIn0%3D; expires=Thu, 26 Jun 2025 06:47:52 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjEwMXdYSFFURldHTjVHcThZYzRJWkE9PSIsInZhbHVlIjoiWHpmK2x0TUU1V0twalBaQjN0dnBYQ0hNdjZVNW9FdDE1MFNqcEQ5L2U2djcrdGg4eFliQkdMN0ptWWtOSHVyNXRDVTN4e ▶"
    1 => "tagmyfish_session=eyJpdiI6IkRyTGtwSTZ3aVI1QW9aeVhHNVFHUlE9PSIsInZhbHVlIjoiT0x5VEpLVzl6UGtGQlladC8vaGVaUy9iVDFUMS9BalZRZWZFNGFVRTRCUDB4SUlqdWRoend5S3cySTRKSkhhS0RtWEV6TldiR3FkWkxOS1Nmc3AvNndVOXhkVEd0WFRIa2lzeGgwVTZnWTZDeEJPVEFsZmE0RWRBR3k3WWIwRjgiLCJtYWMiOiJiNjI0MDg5NzFkMGY3YmFhOTYzMzkxOWU4MzM1MDI2NTgwYjE4YzRlNmZiYTkyMjVkZTYyYmUyNWUwNTA4ODBmIiwidGFnIjoiIn0%3D; expires=Thu, 26 Jun 2025 06:47:52 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀tagmyfish_session=eyJpdiI6IkRyTGtwSTZ3aVI1QW9aeVhHNVFHUlE9PSIsInZhbHVlIjoiT0x5VEpLVzl6UGtGQlladC8vaGVaUy9iVDFUMS9BalZRZWZFNGFVRTRCUDB4SUlqdWRoend5S3cySTRKSkhhS0 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjEwMXdYSFFURldHTjVHcThZYzRJWkE9PSIsInZhbHVlIjoiWHpmK2x0TUU1V0twalBaQjN0dnBYQ0hNdjZVNW9FdDE1MFNqcEQ5L2U2djcrdGg4eFliQkdMN0ptWWtOSHVyNXRDVTN4emp5Zzlxd09iektDQ2FPQmZPSHRPN3JuRHRSNkYxK0dBU1Y0OGhtVFZIT0M3bmtWNkNvZVVyTzBnMzYiLCJtYWMiOiJkNmY0NGRjYmQwOTkzOGJjMjRhNmE4YTk0NjM1ZmNiOGJjOGExYWJiY2MwOTFmNDJmMmQzZTIxNjUwOWU1YmE3IiwidGFnIjoiIn0%3D; expires=Thu, 26-Jun-2025 06:47:52 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IjEwMXdYSFFURldHTjVHcThZYzRJWkE9PSIsInZhbHVlIjoiWHpmK2x0TUU1V0twalBaQjN0dnBYQ0hNdjZVNW9FdDE1MFNqcEQ5L2U2djcrdGg4eFliQkdMN0ptWWtOSHVyNXRDVTN4e ▶"
    1 => "tagmyfish_session=eyJpdiI6IkRyTGtwSTZ3aVI1QW9aeVhHNVFHUlE9PSIsInZhbHVlIjoiT0x5VEpLVzl6UGtGQlladC8vaGVaUy9iVDFUMS9BalZRZWZFNGFVRTRCUDB4SUlqdWRoend5S3cySTRKSkhhS0RtWEV6TldiR3FkWkxOS1Nmc3AvNndVOXhkVEd0WFRIa2lzeGgwVTZnWTZDeEJPVEFsZmE0RWRBR3k3WWIwRjgiLCJtYWMiOiJiNjI0MDg5NzFkMGY3YmFhOTYzMzkxOWU4MzM1MDI2NTgwYjE4YzRlNmZiYTkyMjVkZTYyYmUyNWUwNTA4ODBmIiwidGFnIjoiIn0%3D; expires=Thu, 26-Jun-2025 06:47:52 GMT; path=/; secure; httponly ◀tagmyfish_session=eyJpdiI6IkRyTGtwSTZ3aVI1QW9aeVhHNVFHUlE9PSIsInZhbHVlIjoiT0x5VEpLVzl6UGtGQlladC8vaGVaUy9iVDFUMS9BalZRZWZFNGFVRTRCUDB4SUlqdWRoend5S3cySTRKSkhhS0 ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "oB1co34OTwexWe1La5uaX1vO2Yuo7ksOXfnITQ5d"
  "_previous" => array:1 [▶
    "url" => "https://dev.tagmyfish.com/fish/species/sarotherodon-melanotheron"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-06-26 04:47:52	GET	/fish/species/sarotherodon-melanotheron	348 65 522

1 x Application (93.07%)	318ms
1 x Booting (6.92%)	23.67ms

Blackchin tilapia (Sarotherodon melanotheron)Follow

General data

Classification

Description

Catches

Taxonomy of Fishes

Tag Your Catch and Win a Twin Power!

Post your catch and get a chance to win the Shimano Twin Power XD 4000 PG!

Blackchin tilapia (Sarotherodon melanotheron)
Follow

Tag Your Catch and
Win a Twin Power!