TagMyFish

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->
    
    Gobiidae - Gobies->
    
    Neogobius - Black Sea gobies->
    
    Proterorhinus - Tubenose gobies->
    
    Gobius - Gobius->
    
    Ponticola - Ponticola->
    
    Babka - Babka->
    
    Economidichthys - Economidichthys->
    
    Benthophilus - Tadpole gobies->
    
    Mugilogobius - Mugilogobius->
    
    Valenciennea - Glider gobies->
    
    Knipowitschia - Knipowitsch gobies->
    
    Pomatoschistus - Pomatoschistus->
    
    Mauligobius - Mauligobius->
    
    Thorogobius - Thorogobius->
    
    Lesueurigobius - Lesueurigobius->
    
    Aphia - Aphia->
    
    Gobiosoma - Gobiosoma->
    
    Tridentiger - Tripletooth gobies->
    
    Rhinogobius - Rhinogobius->
    
    Bathygobius - Bathygobius->
    
    Cryptocentrus - Cryptocentrus->
    
    Cryptocentroides - Cryptocentroides->
    
    Aboma - Aboma->
    
    Acanthogobius - Acanthogobius->
    
    Acentrogobius - Acentrogobius->
    
    Afurcagobius - Afurcagobius->
    
    Akihito - Akihito->
    
    Akko - Akko->
    
    Awaouichthys - Awaouichthys->
    
    Awaous - Awaous->
    
    Chaenogobius - Chaenogobius->
    
    Amblychaeturichthys - Amblychaeturichthys->
    
    Amblyeleotris - Amblyeleotris->
    
    Amblygobius - Amblygobius->
    
    Amblyotrypauchen - Amblyotrypauchen->
    
    Anatirostrum - Anatirostrum->
    
    Ancistrogobius - Ancistrogobius->
    
    Antilligobius - Antilligobius->
    
    Arcygobius - Arcygobius->
    
    Arenigobius - Arenigobius->
    
    Aruma - Aruma->
    
    Asterropteryx - Asterropteryx->
    
    Astrabe - Astrabe->
    
    Aulopareia - Aulopareia->
    
    Austrolethops - Austrolethops->
    
    Barbulifer - Barbulifer->
    
    Barbuligobius - Barbuligobius->
    
    Benthophiloides - Benthophiloides->
    
    Biendongella - Biendongella->
    
    Bollmannia - Bollmannia->
    
    Brachyamblyopus - Brachyamblyopus->
    
    Brachygobius - Brachygobius->
    
    Bryaninops - Bryaninops->
    
    Buenia - Buenia->
    
    Cabillus - Cabillus->
    
    Caecogobius - Caecogobius->
    
    Caffrogobius - Caffrogobius->
    
    Callogobius - Callogobius->
    
    Caragobius - Caragobius->
    
    Carrigobius - Carrigobius->
    
    Caspiosoma - Caspiosoma->
    
    Cerogobius - Cerogobius->
    
    Chaeturichthys - Chaeturichthys->
    
    Chlamydogobius - Chlamydogobius->
    
    Chriolepis - Chriolepis->
    
    Chromogobius - Chromogobius->
    
    Clariger - Clariger->
    
    Clevelandia - Clevelandia->
    
    Corcyrogobius - Corcyrogobius->
    
    Coryogalops - Coryogalops->
    
    Coryphopterus - Coryphopterus->
    
    Cotylopus - Cotylopus->
    
    Cristatogobius - Cristatogobius->
    
    Croilia - Croilia->
    
    Cryptopsilotris - Cryptopsilotris->
    
    Crystallogobius - Crystallogobius->
    
    Ctenogobiops - Ctenogobiops->
    
    Ctenogobius - Ctenogobius->
    
    Ctenotrypauchen - Ctenotrypauchen->
    
    Deltentosteus - Deltentosteus->
    
    Didogobius - Didogobius->
    
    Discordipinna - Discordipinna->
    
    Dotsugobius - Dotsugobius->
    
    Drombus - Drombus->
    
    Ebomegobius - Ebomegobius->
    
    Echinogobius - Echinogobius->
    
    Egglestonichthys - Egglestonichthys->
    
    Ego - Ego->
    
    Elacatinus - Elacatinus->
    
    Eleotrica - Eleotrica->
    
    Eucyclogobius - Eucyclogobius->
    
    Eugnathogobius - Eugnathogobius->
    
    Eutaeniichthys - Eutaeniichthys->
    
    Evermannia - Evermannia->
    
    Evermannichthys - Evermannichthys->
    
    Eviota - Eviota->
    
    Evorthodus - Evorthodus->
    
    Exyrias - Exyrias->
    
    Favonigobius - Favonigobius->
    
    Feia - Feia->
    
    Fusigobius - Fusigobius->
    
    Gammogobius - Gammogobius->
    
    Gillichthys - Gillichthys->
    
    Ginsburgellus - Ginsburgellus->
    
    Gladiogobius - Gladiogobius->
    
    Glossogobius - Glossogobius->
    
    Gnatholepis - Gnatholepis->
    
    Gobiodon - Gobiodon->
    
    Gobioides - Gobioides->
    
    Gobionellus - Gobionellus->
    
    Gobiopsis - Gobiopsis->
    
    Gobiopterus - Gobiopterus->
    
    Gobulus - Gobulus->
    
    Gorogobius - Gorogobius->
    
    Grallenia - Grallenia->
    
    Gymneleotris - Gymneleotris->
    
    Gymnesigobius - Gymnesigobius->
    
    Gymnoamblyopus - Gymnoamblyopus->
    
    Gymnogobius - Gymnogobius->
    
    Hazeus - Hazeus->
    
    Hemigobius - Hemigobius->
    
    Karsten - Karsten->
    
    Mesogobius - Mesogobius->
    
    Hetereleotris - Hetereleotris->
    
    Heterogobius - Heterogobius->
    
    Heteroplopomus - Heteroplopomus->
    
    Hyrcanogobius - Hyrcanogobius->
    
    Ilypnus - Ilypnus->
    
    Inu - Inu->
    
    Istigobius - Istigobius->
    
    Kelloggella - Kelloggella->
    
    Koumansetta - Koumansetta->
    
    Larsonella - Larsonella->
    
    Lebetus - Lebetus->
    
    Lentipes - Lentipes->
    
    Lepidogobius - Lepidogobius->
    
    Lethops - Lethops->
    
    Leucopsarion - Leucopsarion->
    
    Lobulogobius - Lobulogobius->
    
    Lophiogobius - Lophiogobius->
    
    Lophogobius - Lophogobius->
    
    Lotilia - Lotilia->
    
    Lubricogobius - Lubricogobius->
    
    Luciogobius - Luciogobius->
    
    Luposicya - Luposicya->
    
    Lythrypnus - Lythrypnus->
    
    Macrodontogobius - Macrodontogobius->
    
    Mahidolia - Mahidolia->
    
    Mangarinus - Mangarinus->
    
    Microgobius - Microgobius->
    
    Millerigobius - Millerigobius->
    
    Minysicya - Minysicya->
    
    Mistichthys - Mistichthys->
    
    Mizogobius - Mizogobius->
    
    Myersina - Myersina->
    
    Nematogobius - Nematogobius->
    
    Nes - Nes->
    
    Nesogobius - Nesogobius->
    
    Ninnigobius - Ninnigobius->
    
    Obliquogobius - Obliquogobius->
    
    Odondebuenia - Odondebuenia->
    
    Odontamblyopus - Odontamblyopus->
    
    Oligolepis - Oligolepis->
    
    Ophiogobius - Ophiogobius->
    
    Oplopomops - Oplopomops->
    
    Oplopomus - Oplopomus->
    
    Opua - Opua->
    
    Orsinigobius - Orsinigobius->
    
    Oxyurichthys - Oxyurichthys->
    
    Padogobius - Padogobius->
    
    Paedogobius - Paedogobius->
    
    Paedovaricus - Paedovaricus->
    
    Palatogobius - Palatogobius->
    
    Palutrus - Palutrus->
    
    Pandaka - Pandaka->
    
    Papuligobius - Papuligobius->
    
    Parachaeturichthys - Parachaeturichthys->
    
    Paragobiodon - Paragobiodon->
    
    Paragobiopsis - Paragobiopsis->
    
    Parasicydium - Parasicydium->
    
    Paratrimma - Paratrimma->
    
    Paratrypauchen - Paratrypauchen->
    
    Parawaous - Parawaous->
    
    Pariah - Pariah->
    
    Parkraemeria - Parkraemeria->
    
    Parrella - Parrella->
    
    Pascua - Pascua->
    
    Pennatuleviota - Pennatuleviota->
    
    Phoxacromion - Phoxacromion->
    
    Phyllogobius - Phyllogobius->
    
    Rhinogobiops - Rhinogobiops->
    
    Pinnichthys - Pinnichthys->
    
    Platygobiopsis - Platygobiopsis->
    
    Pleurosicya - Pleurosicya->
    
    Polyspondylogobius - Polyspondylogobius->
    
    Porogobius - Porogobius->
    
    Priolepis - Priolepis->
    
    Psammogobius - Psammogobius->
    
    Pseudaphya - Pseudaphya->
    
    Pseudogobiopsis - Pseudogobiopsis->
    
    Pseudogobius - Pseudogobius->
    
    Pseudotrypauchen - Pseudotrypauchen->
    
    Psilogobius - Psilogobius->
    
    Psilotris - Psilotris->
    
    Pterogobius - Pterogobius->
    
    Quietula - Quietula->
    
    Redigobius - Redigobius->
    
    Reptiliceps - Reptiliceps->
    
    Risor - Risor->
    
    Robinsichthys - Robinsichthys->
    
    Sagamia - Sagamia->
    
    Tamanka - Tamanka->
    
    Schismatogobius - Schismatogobius->
    
    Sicydium - Sicydium->
    
    Sicyopterus - Sicyopterus->
    
    Sicyopus - Sicyopus->
    
    Signigobius - Signigobius->
    
    Silhouettea - Silhouettea->
    
    Siphonogobius - Siphonogobius->
    
    Smilosicyopus - Smilosicyopus->
    
    Sovvityazius - Sovvityazius->
    
    Speleogobius - Speleogobius->
    
    Stenogobius - Stenogobius->
    
    Stigmatogobius - Stigmatogobius->
    
    Stiphodon - Stiphodon->
    
    Stonogobiops - Stonogobiops->
    
    Sueviota - Sueviota->
    
    Sufflogobius - Sufflogobius->
    
    Suruga - Suruga->
    
    Taenioides - Taenioides->
    
    Tasmanogobius - Tasmanogobius->
    
    Tigrigobius - Tigrigobius->
    
    Tomiyamichthys - Tomiyamichthys->
    
    Trimma - Trimma->
    
    Trimmatom - Trimmatom->
    
    Trypauchen - Trypauchen->
    
    Trypauchenichthys - Trypauchenichthys->
    
    Trypauchenopsis - Trypauchenopsis->
    
    Tryssogobius - Tryssogobius->
    
    Typhlogobius - Typhlogobius->
    
    Vanderhorstia - Vanderhorstia->
    
    Vanneaugobius - Vanneaugobius->
    
    Varicus - Varicus->
    
    Vomerogobius - Vomerogobius->
    
    Wheelerigobius - Wheelerigobius->
    
    Wuhanlinigobius - Wuhanlinigobius->
    
    Yoga - Yoga->
    
    Yongeichthys - Yongeichthys->
    
    Zebrus - Zebrus->
    
    Odontobutidae - Freshwater sleepers->
    
    Oxudercidae - Mudskippers->
    
    Butidae - Butidae->
    
    Eleotridae - Sleeper gobies->
    
    Kraemeriidae - Sand darters->
    
    Microdesmidae - Wormfishes->
    
    Milyeringidae - Blind cave gudgeons->
    
    Rhyacichthyidae - Loach gobies->
    
    Schindleriidae - Infantfishes->
    
    Thalasseleotrididae - Ocean sleepers->
    
    Trichonotidae - Sanddivers->
    
    Xenisthmidae - Collared wrigglers->
  - 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->
  - 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 Queries27 Models480 Mails Gate Session Request

Request history8.2.28252ms4MBGET fish/{type}/{alias}

Booting (23.34ms)time
Application (228ms)time
1 x Application (90.73%)
228ms
1 x Booting (9.27%)
23.34ms

348 templates were rendered

1x fish.singlesingle.blade.php#?blade
1x fish.taxonomytaxonomy.blade.php#?blade
1x elements.tabnavtabnav.blade.php#?blade
1x layout.indexindex.blade.php#?blade
1x layout.headhead.blade.php#?blade
1x laravelpwa::metameta.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
336x fish.childrenchildren.blade.php#?blade
1x layout.mobilenavmobilenav.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-38

27 statements were executed (2 duplicates)Show only duplicates135ms

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

Bindings	0: OV5VESTKmgKzbKD0BFjSVDjC8itafNYBnZ8xgabD
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#27tmf570μsselect * from `fish` where `alias` = 'stenogobius' and `type` = 'genus' and `published` = 1 limit 1

Bindings	0: stenogobius 1: genus 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#23tmf440μsselect * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (7411)

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#27tmf720μs

with recursive `laravel_cte` as ((select `fish`.*, -1 as `depth`, cast(`id` as char(65535)) as `path` from `fish` where `fish`.`id` in (34)) 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#23tmf530μsselect * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (34, 202, 906, 908)

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#27tmf550μsselect * from `fish` where `fish`.`parent_id` in (7411)

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#23tmf680μs

select * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (8717, 11158, 11765, 13517, 17707, 18875, 19896, 20192, 20658, 21408, 22536, 22570, 23070, 23160, 23439, 25431, 26176, 26289, 26682, 30396, 32818, 33259, 33919, 37069, 40420, 40951, 41258)

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

FishController.php#23tmf28.31ms

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 (7411)) as `laravel_table` where `laravel_row` <= 20 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

FishController.php#23tmf1.55ms

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

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#23tmf29.69msselect * from `tags` where `type` = 'species' and `tags`.`context_id` in (7411)

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#27tmf52.54msselect * 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:25 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#25tmf660μ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:25 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 `fish`.`parent_id` in (908, 909, 910)

Backtrace

vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:27
app/Http/Controllers/FishController.php:25
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#25tmf640μ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:25 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#27tmf450μs

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

Bindings	0: 7411 1: en 2: 0
Backtrace	view::fish.single:27 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#32tmf1.31ms

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

Bindings	0: 7411
Backtrace	view::fish.single:32 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

Fish.php#248tmf1.55ms

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

Bindings	0: 7411 1: 1
Backtrace	app/Models/Fish.php:248 view::fish.single:40 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.52ms

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

Bindings	0: 7411 1: 0
Backtrace	app/Models/Fish.php:252 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

BuildsAdjacencyListQueries.php#27tmf450μ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` = 7411 and `is_basin` = 1

Bindings	0: 7411 1: 1
Backtrace	vendor/staudenmeir/laravel-adjacency-list/src/Eloquent/Traits/BuildsAdjacencyListQueries.php:27 view::fish.single:57 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#27tmf910μ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.37ms

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#27tmf550μsselect * from `fish` where `fish`.`parent_id` = 202 and `fish`.`parent_id` is not null

Bindings	0: 202
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 (34, 203, 1091, 2228, 2604, 3147, 3174, 3176, 3274, 3280, 3313, 3322, 3328)

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.5msselect * from `fish` where `fish`.`parent_id` = 34 and `fish`.`parent_id` is not null

Bindings	0: 34
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.11ms

select * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (35, 199, 353, 407, 408, 866, 1460, 2188, 2190, 2350, 2353, 2403, 2472, 2484, 2494, 2509, 2516, 2521, 2884, 2926, 2943, 3345, 3369, 3386, 3425, 3444, 3445, 3478, 3479, 3490, 3531, 3534, 3537, 3539, 3573, 3584, 3606, 3673, 3674, 3699, 3729, 3731, 3779, 3792, 3827, 3828, 3910, 3922, 3945, 3964, 3969, 4004, 4017, 4030, 4034, 4040, 4049, 4070, 4082, 4084, 4122, 4139, 4214, 4228, 4233, 4304, 4311, 4378, 4392, 4393, 4403, 4421, 4424, 4440, 4448, 4456, 4457, 4464, 4557, 4602, 4624, 4653, 4658, 4669, 4673, 4688, 4689, 4697, 4706, 4781, 4783, 4804, 4810, 4811, 4812, 4815, 4828, 4833, 4834, 4875, 4883, 4923, 4925, 4930, 4940, 4952, 4961, 4962, 4964, 4966, 4967, 4969, 4981, 4986, 5019, 5022, 5023, 5036, 5095, 5123, 5154, 5172, 5190, 5197, 5203, 5299, 5325, 5337, 5362, 5394, 5417, 5484, 5492, 5500, 5517, 5579, 5586, 5635, 5646, 5652, 5660, 5665, 5674, 5684, 5702, 5706, 5719, 5739, 5834, 5864, 5873, 5881, 5887, 5958, 6039, 6105, 6107, 6118, 6162, 6170, 6171, 6193, 6219, 6232, 6233, 6238, 6249, 6269, 6279, 6281, 6282, 6287, 6291, 6297, 6307, 6325, 6348, 6349, 6402, 6421, 6423, 6427, 6445, 6452, 6463, 6467, 6495, 6576, 6587, 6610, 6638, 6665, 6693, 6724, 6730, 6753, 6817, 6839, 6877, 6878, 6935, 6941, 6943, 6951, 6994, 7028, 7038, 7098, 7105, 7136, 7156, 7205, 7288, 7289, 7290, 7294, 7296, 7326, 7333, 7351, 7359, 7411, 7432, 7435, 7443, 7458, 7461, 7468, 7499, 7516, 7587, 7599, 7665, 7666, 7689, 7690, 7691, 7692, 7708, 7734, 7736, 7740, 7761, 7767, 7770, 7822, 7823, 7832)

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` = 'OV5VESTKmgKzbKD0BFjSVDjC8itafNYBnZ8xgabD' limit 1

Bindings	0: OV5VESTKmgKzbKD0BFjSVDjC8itafNYBnZ8xgabD
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#158tmf5.51ms

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

Bindings

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

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: 372Fish.php#?
App\Models\FishName: 108FishName.php#?

_token: XaXp02nYglQm2Pv2A30hgiYHTdPmRJNbQp0LUGC5
_previous: array:1 [ "url" => "https://dev.tagmyfish.com/fish/genus/stenogobius" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/fish/genus/stenogobius

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:26 [▼
  "x-real-ip" => array:1 [▶
    0 => "172.69.58.162"
  ]
  "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.58.162"
  ]
  "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-ray" => array:1 [▶
    0 => "93999d92dcee90cb-ORD"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "18.118.171.28"
  ]
  "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 => "Fri, 02 May 2025 18:34:56 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjhHM2xnRXhwakxqOTRmRlJUM3A2eXc9PSIsInZhbHVlIjoiSFJiOHhYWm03NFdrM2Y0T1A0aFdWM2V6Z3Z6N2lNeFR0alY5dSs0S3ZLbyt1Tzlub0xsdkY4YmxiZGZxY2dYNUUxdWxvTjZKZ0NRTjZDQ1cwL1JuNHVkYWorcHNUSWJtVlpDK0ZiQ3d5R2ZaNWdBTUd3Rm9rdlpFUkxPZ21QT0EiLCJtYWMiOiJiOGEzNTBmODAwNjI5ZTdiMWJjMjc4OTQ0MGQwYjRhNzQ0NjUzODUyMjgzYjFjOWU0YWZmODllM2Q4MzAzNzA0IiwidGFnIjoiIn0%3D; expires=Fri, 02 May 2025 20:34:56 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjhHM2xnRXhwakxqOTRmRlJUM3A2eXc9PSIsInZhbHVlIjoiSFJiOHhYWm03NFdrM2Y0T1A0aFdWM2V6Z3Z6N2lNeFR0alY5dSs0S3ZLbyt1Tzlub0xsdkY4YmxiZGZxY2dYNUUxdWxvT ▶"
    1 => "tagmyfish_session=eyJpdiI6IkpkSVpWMkdOdjdrMVVpdW5pb3hrV3c9PSIsInZhbHVlIjoiMnpRYlVtRUYveDdiVk5sVi9jVG9zUVVQSGlhd0s1alNoM0tuNnhxMnlMOGhhdm94K3NxcndlaEx1ZXlQQW9DdDJiVkFPZ2xhR1dlMmxFOW5SQ2ZNZXA1a2VzWDZBNVFvUnFYRFJiWHIxVnhUSVNhaVBIdnFISEM4ZkZSUlNjU1QiLCJtYWMiOiJlNjk3YWEyNWQwYTkwM2YwYzMxZTVkYTg1MmFmZDhkZGE5MzQwNGZlZGVkMTQzZmQ1NTExNTg5NDExMzA2M2YwIiwidGFnIjoiIn0%3D; expires=Fri, 02 May 2025 20:34:56 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀tagmyfish_session=eyJpdiI6IkpkSVpWMkdOdjdrMVVpdW5pb3hrV3c9PSIsInZhbHVlIjoiMnpRYlVtRUYveDdiVk5sVi9jVG9zUVVQSGlhd0s1alNoM0tuNnhxMnlMOGhhdm94K3NxcndlaEx1ZXlQQW9DdD ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjhHM2xnRXhwakxqOTRmRlJUM3A2eXc9PSIsInZhbHVlIjoiSFJiOHhYWm03NFdrM2Y0T1A0aFdWM2V6Z3Z6N2lNeFR0alY5dSs0S3ZLbyt1Tzlub0xsdkY4YmxiZGZxY2dYNUUxdWxvTjZKZ0NRTjZDQ1cwL1JuNHVkYWorcHNUSWJtVlpDK0ZiQ3d5R2ZaNWdBTUd3Rm9rdlpFUkxPZ21QT0EiLCJtYWMiOiJiOGEzNTBmODAwNjI5ZTdiMWJjMjc4OTQ0MGQwYjRhNzQ0NjUzODUyMjgzYjFjOWU0YWZmODllM2Q4MzAzNzA0IiwidGFnIjoiIn0%3D; expires=Fri, 02-May-2025 20:34:56 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IjhHM2xnRXhwakxqOTRmRlJUM3A2eXc9PSIsInZhbHVlIjoiSFJiOHhYWm03NFdrM2Y0T1A0aFdWM2V6Z3Z6N2lNeFR0alY5dSs0S3ZLbyt1Tzlub0xsdkY4YmxiZGZxY2dYNUUxdWxvT ▶"
    1 => "tagmyfish_session=eyJpdiI6IkpkSVpWMkdOdjdrMVVpdW5pb3hrV3c9PSIsInZhbHVlIjoiMnpRYlVtRUYveDdiVk5sVi9jVG9zUVVQSGlhd0s1alNoM0tuNnhxMnlMOGhhdm94K3NxcndlaEx1ZXlQQW9DdDJiVkFPZ2xhR1dlMmxFOW5SQ2ZNZXA1a2VzWDZBNVFvUnFYRFJiWHIxVnhUSVNhaVBIdnFISEM4ZkZSUlNjU1QiLCJtYWMiOiJlNjk3YWEyNWQwYTkwM2YwYzMxZTVkYTg1MmFmZDhkZGE5MzQwNGZlZGVkMTQzZmQ1NTExNTg5NDExMzA2M2YwIiwidGFnIjoiIn0%3D; expires=Fri, 02-May-2025 20:34:56 GMT; path=/; secure; httponly ◀tagmyfish_session=eyJpdiI6IkpkSVpWMkdOdjdrMVVpdW5pb3hrV3c9PSIsInZhbHVlIjoiMnpRYlVtRUYveDdiVk5sVi9jVG9zUVVQSGlhd0s1alNoM0tuNnhxMnlMOGhhdm94K3NxcndlaEx1ZXlQQW9DdD ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "XaXp02nYglQm2Pv2A30hgiYHTdPmRJNbQp0LUGC5"
  "_previous" => array:1 [▶
    "url" => "https://dev.tagmyfish.com/fish/genus/stenogobius"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-02 18:34:56	GET	/fish/genus/stenogobius	348 27 480

Stenogobius

General data

Classification

Species

Stenogobius alleni

Beaufort’s goby (Stenogobius beauforti)

Stenogobius blokzeyli

Stenogobius caudimaculosus

Stenogobius fehlmanni

Chinstripe goby (Stenogobius genivittatus)

Stenogobius gymnopomus

Stenogobius hawaiiensis

Stenogobius hoesei

Stenogobius ingeri

Keletaona’s Goby (Stenogobius keletaona)

Africa rivergoby (Stenogobius kenyae)

Stenogobius kyphosus

Bintuni goby (Stenogobius lachneri)

Stenogobius laterisquamatus

Stenogobius macropterus

Stenogobius marinus

Stenogobius marqueti

Stenogobius mekongensis

Stenogobius ophthalmoporus

Chinestripe goby (Stenogobius polyzona)

Stenogobius psilosinionus

Stenogobius randalli

Stenogobius squamosus

Stenogobius watsoni

Yate’s goby (Stenogobius yateiensis)

Stenogobius zurstrasseni

Taxonomy of Fishes

1 x Application (90.73%)	228ms
1 x Booting (9.27%)	23.34ms