TagMyFish

Taxonomy of Fishes

Osteichthyes - Bony fishes->
- Coelacanthi - Lobe-finned fishes->
- Teleostei - Ray-finned fishes->
  - Perciformes - Perches->
  - Cypriniformes - Carps->
    
    Cyprinidae - Carps->
    
    Cyprinus - Carps->
    
    Carassius - Crucian carps->
    
    Barbus - Barbel->
    
    Aulopyge - Barbel-gudgeons->
    
    Tor - Mahseer->
    
    Luciobarbus - Pike-like barbel->
    
    Catlocarpio - Siamese carps->
    
    Schizothorax - Marinkas (Snowtrouts)->
    
    Diptychus - Osman->
    
    Probarbus - Probarbus->
    
    Labeobarbus - African yellowfishes->
    
    Gymnocypris - Gymnocypris->
    
    Capoeta - Scrapers->
    
    Labeo - Labeo->
    
    Barbonymus - Tinfoil barbs->
    
    Opsarius - Opsarius->
    
    Neolissochilus - Asian smoothlip carps->
    
    Spinibarbus - Spinibarbus->
    
    Aaptosyax - Aaptosyax->
    
    Acapoeta - Acapoeta->
    
    Acrossocheilus - Acrossocheilus->
    
    Albulichthys - Albulichthys->
    
    Anematichthys - Anematichthys->
    
    Chuanchia - Chuanchia->
    
    Amatolacypris - Amatolacypris->
    
    Amblyrhynchichthys - Amblyrhynchichthys->
    
    Anchicyclocheilus - Anchicyclocheilus->
    
    Arabibarbus - Arabibarbus->
    
    Aspiorhynchus - Aspiorhynchus->
    
    Balantiocheilos - Balantiocheilos->
    
    Bangana - Bangana->
    
    Barbichthys - Barbichthys->
    
    Barbodes - Barbodes->
    
    Barboides - Barboides->
    
    Barbopsis - Barbopsis->
    
    Caecobarbus - Caecobarbus->
    
    Caecocypris - Caecocypris->
    
    Carasobarbus - Carasobarbus->
    
    Carassioides - Carassioides->
    
    Ceratogarra - Ceratogarra->
    
    Chagunius - Chagunius->
    
    Cheilobarbus - Cheilobarbus->
    
    Cirrhinus - Cirrhinus->
    
    Discherodontus - Discherodontus->
    
    Discocheilus - Discocheilus->
    
    Discogobio - Discogobio->
    
    Gibelion - Gibelion->
    
    Clypeobarbus - Clypeobarbus->
    
    Cophecheilus - Cophecheilus->
    
    Coptostomabarbus - Coptostomabarbus->
    
    Cosmochilus - Cosmochilus->
    
    Crossocheilus - Crossocheilus->
    
    Cyclocheilichthys - Cyclocheilichthys->
    
    Cyprinion - Cyprinion->
    
    Dawkinsia - Dawkinsia->
    
    Decorus - Decorus->
    
    Desmopuntius - Desmopuntius->
    
    Diplocheilichthys - Diplocheilichthys->
    
    Discolabeo - Discolabeo->
    
    Eechathalakenda - Eechathalakenda->
    
    Eirmotus - Eirmotus->
    
    Enteromius - Enteromius->
    
    Epalzeorhynchos - Epalzeorhynchos->
    
    Fivepearlus - Fivepearlus->
    
    Folifer - Folifer->
    
    Garra - Garra->
    
    Garroides - Garroides->
    
    Gymnodiptychus - Gymnodiptychus->
    
    Gymnostomus - Gymnostomus->
    
    Haludaria - Haludaria->
    
    Hampala - Hampala->
    
    Henicorhynchus - Henicorhynchus->
    
    Mesopotamichthys - Mesopotamichthys->
    
    Herzensteinia - Herzensteinia->
    
    Hongshuia - Hongshuia->
    
    Horalabiosa - Horalabiosa->
    
    Hypselobarbus - Hypselobarbus->
    
    Hypsibarbus - Hypsibarbus->
    
    Kalimantania - Kalimantania->
    
    Labiobarbus - Labiobarbus->
    
    Lanlabeo - Lanlabeo->
    
    Laocypris - Laocypris->
    
    Lepidopygopsis - Lepidopygopsis->
    
    Linichthys - Linichthys->
    
    Lobocheilos - Lobocheilos->
    
    Longanalus - Longanalus->
    
    Luciocyprinus - Luciocyprinus->
    
    Mekongina - Mekongina->
    
    Oxygymnocypris - Oxygymnocypris->
    
    Mystacoleucus - Mystacoleucus->
    
    Namaquacypris - Namaquacypris->
    
    Naziritor - Naziritor->
    
    Neobarynotus - Neobarynotus->
    
    Oliotius - Oliotius->
    
    Onychostoma - Onychostoma->
    
    Oreichthys - Oreichthys->
    
    Osteobrama - Osteobrama->
    
    Osteochilichthys - Osteochilichthys->
    
    Osteochilus - Osteochilus->
    
    Paracrossochilus - Paracrossochilus->
    
    Parapsilorhynchus - Parapsilorhynchus->
    
    Paraqianlabeo - Paraqianlabeo->
    
    Parasikukia - Parasikukia->
    
    Parasinilabeo - Parasinilabeo->
    
    Paraspinibarbus - Paraspinibarbus->
    
    Parator - Parator->
    
    Percocypris - Percocypris->
    
    Pethia - Pethia->
    
    Phreatichthys - Phreatichthys->
    
    Pterocapoeta - Pterocapoeta->
    
    Placocheilus - Placocheilus->
    
    Platypharodon - Platypharodon->
    
    Poropuntius - Poropuntius->
    
    Procypris - Procypris->
    
    Prolabeo - Prolabeo->
    
    Prolabeops - Prolabeops->
    
    Prolixicheilus - Prolixicheilus->
    
    Protolabeo - Protolabeo->
    
    Pseudobarbus - Pseudobarbus->
    
    Pseudocrossocheilus - Pseudocrossocheilus->
    
    Pseudogyrinocheilus - Pseudogyrinocheilus->
    
    Pseudosinocyclocheilus - Pseudosinocyclocheilus->
    
    Ptychidio - Ptychidio->
    
    Ptychobarbus - Ptychobarbus->
    
    Puntigrus - Puntigrus->
    
    Puntioplites - Puntioplites->
    
    Puntius - Puntius->
    
    Qianlabeo - Qianlabeo->
    
    Racoma - Racoma->
    
    Rectoris - Rectoris->
    
    Rohtee - Rohtee->
    
    Rohteichthys - Rohteichthys->
    
    Sanagia - Sanagia->
    
    Sawbwa - Sawbwa->
    
    Scaphiodonichthys - Scaphiodonichthys->
    
    Scaphognathops - Scaphognathops->
    
    Schismatorhynchos - Schismatorhynchos->
    
    Schizocypris - Schizocypris->
    
    Schizopyge - Schizopyge->
    
    Schizopygopsis - Schizopygopsis->
    
    Sedercypris - Sedercypris->
    
    Semilabeo - Semilabeo->
    
    Semiplotus - Semiplotus->
    
    Sikukia - Sikukia->
    
    Sinigarra - Sinigarra->
    
    Sinilabeo - Sinilabeo->
    
    Sinocrossocheilus - Sinocrossocheilus->
    
    Sinocyclocheilus - Sinocyclocheilus->
    
    Speolabeo - Speolabeo->
    
    Stenorynchoacrum - Stenorynchoacrum->
    
    Striuntius - Striuntius->
    
    Systomus - Systomus->
    
    Tariqilabeo - Tariqilabeo->
    
    Thynnichthys - Thynnichthys->
    
    Troglocyclocheilus - Troglocyclocheilus->
    
    Typhlobarbus - Typhlobarbus->
    
    Vinagarra - Vinagarra->
    
    Xenobarbus - Xenobarbus->
    
    Gobionidae - Gudgeons->
    
    Tincidae - Tench->
    
    Cobitidae - True loaches->
    
    Acheilognathidae - Bitterling-like cyprinids->
    
    Leuciscidae - Chub family->
    
    Nemacheilidae - Stone loaches->
    
    Xenocyprididae - East Asian minnows->
    
    Catostomidae - Suckers->
    
    Leptobarbidae - Cigar barbs->
    
    Balitoridae - River loaches->
    
    Barbuccidae - Fire-eyed loaches->
    
    Botiidae - Pointface loaches->
    
    Danionidae - Danios->
    
    Ellopostomatidae - Square-head loaches->
    
    Gastromyzontidae - Hillstream loaches->
    
    Gyrinocheilidae - Algae eaters->
    
    Paedocyprididae - Tiny carps->
    
    Psilorhynchidae - Mountain carps->
    
    Serpenticobitidae - Snake loaches->
    
    Sundadanionidae - Tiny danios->
    
    Tanichthyidae - Mountain minnows->
    
    Vaillantellidae - Longfin loaches->
  - 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->
  - 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 Views267 Route Queries27 Models407 Mails Gate Session Request

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

Booting (26.07ms)time
Application (231ms)time
1 x Application (89.87%)
231ms
1 x Booting (10.13%)
26.07ms

267 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 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
256x 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 duplicates132ms

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

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

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

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

with recursive `laravel_cte` as ((select `fish`.*, -1 as `depth`, cast(`id` as char(65535)) as `path` from `fish` where `fish`.`id` in (26)) 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#23tmf610μsselect * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (25, 26, 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#27tmf720μsselect * from `fish` where `fish`.`parent_id` in (5633)

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#23tmf2.61ms

select * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (11772, 14796, 15113, 15592, 15703, 17142, 17503, 18311, 19377, 21819, 22348, 23649, 26855, 29357, 30694, 33684, 34268, 35631, 38259, 38284, 38409, 38818, 39442)

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#23tmf21.26ms

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 (5633)) 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#23tmf2.94ms

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

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

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#27tmf41.52msselect * 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#25tmf810μ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#27tmf780μ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#25tmf810μ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#27tmf600μs

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

Bindings	0: 5633 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.66ms

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

Bindings	0: 5633
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.68ms

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

Bindings	0: 5633 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.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` = 5633 and `native` = 0

Bindings	0: 5633 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#27tmf590μ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` = 5633 and `is_basin` = 1

Bindings	0: 5633 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#27tmf1.17msselect * 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.63ms

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

Bindings	0: 25
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#5tmf970μs

select * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (26, 38, 73, 74, 78, 81, 84, 85, 615, 2032, 2995, 2998, 3012, 3069, 3088, 3103, 3117, 3218, 3263, 3287, 3301, 3306, 3326)

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

Bindings	0: 26
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.82ms

select * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (27, 28, 29, 247, 751, 753, 830, 846, 847, 992, 1326, 1435, 1833, 1950, 2025, 2027, 2112, 2115, 3339, 3382, 3403, 3449, 3470, 3496, 3524, 3542, 3579, 3658, 3715, 3808, 3813, 3820, 3821, 3822, 3823, 4032, 4033, 4074, 4075, 4117, 4140, 4169, 4244, 4255, 4257, 4258, 4277, 4325, 4372, 4375, 4395, 4426, 4480, 4507, 4546, 4553, 4578, 4616, 4622, 4686, 4694, 4718, 4725, 4845, 4856, 4887, 4888, 5033, 5040, 5071, 5072, 5140, 5176, 5187, 5247, 5261, 5291, 5293, 5386, 5439, 5478, 5479, 5524, 5606, 5633, 5639, 5673, 5789, 5930, 5971, 5983, 6014, 6049, 6195, 6210, 6242, 6259, 6260, 6261, 6336, 6387, 6390, 6403, 6404, 6407, 6418, 6510, 6527, 6580, 6601, 6643, 6667, 6734, 6772, 6780, 6781, 6783, 6805, 6851, 6869, 6881, 6923, 6967, 6968, 6976, 6977, 6978, 6992, 7001, 7027, 7111, 7112, 7148, 7192, 7197, 7198, 7206, 7210, 7212, 7213, 7261, 7269, 7271, 7295, 7314, 7315, 7318, 7319, 7360, 7414, 7446, 7491, 7511, 7577, 7681, 7706, 7752, 7780)

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#97tmf630μsselect * from `sessions` where `id` = 'sQvLAynSuRwr25WbvssTGVtxhkOCWE7u0SVYi2pA' limit 1

Bindings	0: sQvLAynSuRwr25WbvssTGVtxhkOCWE7u0SVYi2pA
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.52ms

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

Bindings

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

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

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

path_info

/fish/genus/lobocheilos

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:30 [▼
  "x-real-ip" => array:1 [▶
    0 => "108.162.216.109"
  ]
  "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 => "108.162.216.109"
  ]
  "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/Chicago"
  ]
  "cf-ray" => array:1 [▶
    0 => "93aa1fb7adda9121-ORD"
  ]
  "cf-iplongitude" => array:1 [▶
    0 => "-97.82200"
  ]
  "cf-iplatitude" => array:1 [▶
    0 => "37.75100"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "cf-ipcontinent" => array:1 [▶
    0 => "NA"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "3.138.151.162"
  ]
  "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 => "Sun, 04 May 2025 18:39:58 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InpQcjRjOU9XZXR3TFZHa0RCL1F1U2c9PSIsInZhbHVlIjoieUxYSi9HMU5yNTNPS1J0UDRDWFU4UGJpcG5vdUFzS0RBb2NDcUZmL3R1SDhtRDZhVElWYjYrVXdCd0ZVLzhIak56U2VWbGVIWXJ1UlNxaVhXL0kzTEJ1cTluV2FDSkVqbkVqTnd4OVU5SXZ0NjM0V05mUFg1Si9nWU5Zd2ZUaHEiLCJtYWMiOiIwNjYyNGJiMzNmM2ZkMGQwODFiYTBmY2NmOGU3Y2M4ZmMwYTYwYjFkZWI0NzNhNTkwMmQxYjRlNWU0NTk2NDM0IiwidGFnIjoiIn0%3D; expires=Sun, 04 May 2025 20:39:58 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InpQcjRjOU9XZXR3TFZHa0RCL1F1U2c9PSIsInZhbHVlIjoieUxYSi9HMU5yNTNPS1J0UDRDWFU4UGJpcG5vdUFzS0RBb2NDcUZmL3R1SDhtRDZhVElWYjYrVXdCd0ZVLzhIak56U2VWb ▶"
    1 => "tagmyfish_session=eyJpdiI6ImlvZzJKb2Y0ZUU4dlNlSUpYcFZwZ1E9PSIsInZhbHVlIjoiYVAxQ2pvU3lBcFIwZ3NyMkQyU1BBSVc2b0xEdXRXdTlsNzVVRGdCczRueWhIM2RJeVNjMVNzM1daTlB1djBzMjRGcUUzRG10WXRKekVjR3R0dFZFbmdJNmtXcW91emc2ak5EWXI2ZjhyVmlGaFNpRnNUaUV0R2FEcjRLelBxL04iLCJtYWMiOiIyMzI5NzIxZGQ5NGYyNmY5MjAxZjZlZDRjOTQ3Njk2NGMxZDNmZGEwZDc5YTU3NjkyNWRiNjc0NzE4YmMxNTk1IiwidGFnIjoiIn0%3D; expires=Sun, 04 May 2025 20:39:58 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀tagmyfish_session=eyJpdiI6ImlvZzJKb2Y0ZUU4dlNlSUpYcFZwZ1E9PSIsInZhbHVlIjoiYVAxQ2pvU3lBcFIwZ3NyMkQyU1BBSVc2b0xEdXRXdTlsNzVVRGdCczRueWhIM2RJeVNjMVNzM1daTlB1djBzMj ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InpQcjRjOU9XZXR3TFZHa0RCL1F1U2c9PSIsInZhbHVlIjoieUxYSi9HMU5yNTNPS1J0UDRDWFU4UGJpcG5vdUFzS0RBb2NDcUZmL3R1SDhtRDZhVElWYjYrVXdCd0ZVLzhIak56U2VWbGVIWXJ1UlNxaVhXL0kzTEJ1cTluV2FDSkVqbkVqTnd4OVU5SXZ0NjM0V05mUFg1Si9nWU5Zd2ZUaHEiLCJtYWMiOiIwNjYyNGJiMzNmM2ZkMGQwODFiYTBmY2NmOGU3Y2M4ZmMwYTYwYjFkZWI0NzNhNTkwMmQxYjRlNWU0NTk2NDM0IiwidGFnIjoiIn0%3D; expires=Sun, 04-May-2025 20:39:58 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InpQcjRjOU9XZXR3TFZHa0RCL1F1U2c9PSIsInZhbHVlIjoieUxYSi9HMU5yNTNPS1J0UDRDWFU4UGJpcG5vdUFzS0RBb2NDcUZmL3R1SDhtRDZhVElWYjYrVXdCd0ZVLzhIak56U2VWb ▶"
    1 => "tagmyfish_session=eyJpdiI6ImlvZzJKb2Y0ZUU4dlNlSUpYcFZwZ1E9PSIsInZhbHVlIjoiYVAxQ2pvU3lBcFIwZ3NyMkQyU1BBSVc2b0xEdXRXdTlsNzVVRGdCczRueWhIM2RJeVNjMVNzM1daTlB1djBzMjRGcUUzRG10WXRKekVjR3R0dFZFbmdJNmtXcW91emc2ak5EWXI2ZjhyVmlGaFNpRnNUaUV0R2FEcjRLelBxL04iLCJtYWMiOiIyMzI5NzIxZGQ5NGYyNmY5MjAxZjZlZDRjOTQ3Njk2NGMxZDNmZGEwZDc5YTU3NjkyNWRiNjc0NzE4YmMxNTk1IiwidGFnIjoiIn0%3D; expires=Sun, 04-May-2025 20:39:58 GMT; path=/; secure; httponly ◀tagmyfish_session=eyJpdiI6ImlvZzJKb2Y0ZUU4dlNlSUpYcFZwZ1E9PSIsInZhbHVlIjoiYVAxQ2pvU3lBcFIwZ3NyMkQyU1BBSVc2b0xEdXRXdTlsNzVVRGdCczRueWhIM2RJeVNjMVNzM1daTlB1djBzMj ▶"
  ]
]

session_attributes

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

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-04 18:39:58	GET	/fish/genus/lobocheilos	267 27 407

Lobocheilos

General data

Classification

Species

Lobocheilos bo

Lobocheilos cornutus

Lobocheilos cryptopogon

Lobocheilos davisi

Lobocheilos delacouri

Lobocheilos erinaceus

Lobocheilos falcifer

Lobocheilos fowleri

Lobocheilos gracilis

Lobocheilos ixocheilos

Lobocheilos kajanensis

Lobocheilos lehat

Lobocheilos melanotaenia

Lobocheilos nigrovittatus

Lobocheilos ovalis

Lobocheilos quadrilineatus

Lobocheilos rhabdoura

Lobocheilos schwanenfeldii

Lobocheilos tenura

Lobocheilos terminalis

Lobocheilos thavili

Lobocheilos trangensis

Lobocheilos unicornis

Taxonomy of Fishes

1 x Application (89.87%)	231ms
1 x Booting (10.13%)	26.07ms