Tag my Fish - Sportfishing Community

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 Views269 Route Queries27 Models390 Mails Gate Session Request

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

Booting (23.53ms)time
Application (202ms)time
1 x Application (89.56%)
202ms
1 x Booting (10.44%)
23.53ms

269 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
256x 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-38

27 statements were executed (2 duplicates)Show only duplicates123ms

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

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

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

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#27tmf760μ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#23tmf590μ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#27tmf520μsselect * from `fish` where `fish`.`parent_id` in (6968)

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

select * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (14116, 14646, 16105, 22520)

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#23tmf31.6ms

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

FishController.php#23tmf1.74ms

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

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.9msselect * from `tags` where `type` = 'species' and `tags`.`context_id` in (6968)

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.59msselect * 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#25tmf700μ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#27tmf540μ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#25tmf600μ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#27tmf490μs

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

Bindings	0: 6968 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.28ms

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

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

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

Bindings	0: 6968 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` = 6968 and `is_basin` = 1

Bindings	0: 6968 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#27tmf760μ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.25ms

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#27tmf600μ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#5tmf640μ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.17msselect * 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.34ms

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

Bindings	0: PNqjbKl97nPfQXDLi0L37n0oA6FBRdlYRV4vUzTO
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.09ms

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

Bindings

0: YTozOntzOjY6Il90b2tlbiI7czo0MDoiSmtCeTRkU3A1SWdIOENmSDlYU2ZHYTNPSXl2THJCeW9sTUI1UXlNSCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDk6Imh0dHBzOi8vZGV2LnRhZ215ZmlzaC5jb20vZmlzaC9nZW51cy9wdHljaG9iYXJidXMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19
1: 1747652745
2:
3: 172.18.0.5
4: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
5: PNqjbKl97nPfQXDLi0L37n0oA6FBRdlYRV4vUzTO

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

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

path_info

/fish/genus/ptychobarbus

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.70.100.73"
  ]
  "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.70.100.73"
  ]
  "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 => "94231ef8acb6e255-ORD"
  ]
  "cf-postal-code" => array:1 [▶
    0 => "43215"
  ]
  "cf-metro-code" => array:1 [▶
    0 => "535"
  ]
  "cf-iplongitude" => array:1 [▶
    0 => "-83.00610"
  ]
  "cf-iplatitude" => array:1 [▶
    0 => "39.96250"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "cf-ipcontinent" => array:1 [▶
    0 => "NA"
  ]
  "cf-ipcity" => array:1 [▶
    0 => "Columbus"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "3.148.178.125"
  ]
  "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 => "Mon, 19 May 2025 11:05:45 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImUyUmh0QXV3b01FaDZUVFU0V21oMUE9PSIsInZhbHVlIjoiOWxXWXlXcTVXSXRQWUhHZjFLNzgzZGdhamJNblo1ejk5dlJFcVRXZTdwUkkyWFBVd2JaL3BDNWt2bGs3RXlIRlNpWXlyb2lHQm11V1Z3Njk1OUhMSEF1dGs5cHNBSTVkNldMcEZPcHc5b29hSjBFMU5pLzYvc2RKWnJKTjVKeC8iLCJtYWMiOiI4OTVmZmZiZDYwMTk5ZDVlMzc3YjgyNjQwZjZhODBiYjZlNjVhZWNiNmViYzlkNjE5NDBjNDUyZjZiZjU3YzE1IiwidGFnIjoiIn0%3D; expires=Mon, 19 May 2025 13:05:45 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImUyUmh0QXV3b01FaDZUVFU0V21oMUE9PSIsInZhbHVlIjoiOWxXWXlXcTVXSXRQWUhHZjFLNzgzZGdhamJNblo1ejk5dlJFcVRXZTdwUkkyWFBVd2JaL3BDNWt2bGs3RXlIRlNpWXlyb ▶"
    1 => "tagmyfish_session=eyJpdiI6ImFRV012a3F2YWR6OUhnQVJ6cGhjYnc9PSIsInZhbHVlIjoiVUpLUzdVekJvN01MblpNSWg2M2RJY2psVXlTcDRXMGxuOUM4c1VVOTd1ZlVTbmprYlB6SjlZV2VmZEdtZEZzbTNLUHZGQ0xwck5GQXZsQ0VNbkVyZkhaaU12djhWMjRjbWJlZUxZWThhQmtBQmYwa0tWUVMrbUp2cHpLZnF5ZjciLCJtYWMiOiJjZWY0MzVmYzQ3YjZhMThkN2FiMTJmN2E0MDQ1ZWI0NGZmMmY3ZmY3NzlhMTZiOTUzMTM4ZmE0MjJkNjk4NGZlIiwidGFnIjoiIn0%3D; expires=Mon, 19 May 2025 13:05:45 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀tagmyfish_session=eyJpdiI6ImFRV012a3F2YWR6OUhnQVJ6cGhjYnc9PSIsInZhbHVlIjoiVUpLUzdVekJvN01MblpNSWg2M2RJY2psVXlTcDRXMGxuOUM4c1VVOTd1ZlVTbmprYlB6SjlZV2VmZEdtZEZzbT ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImUyUmh0QXV3b01FaDZUVFU0V21oMUE9PSIsInZhbHVlIjoiOWxXWXlXcTVXSXRQWUhHZjFLNzgzZGdhamJNblo1ejk5dlJFcVRXZTdwUkkyWFBVd2JaL3BDNWt2bGs3RXlIRlNpWXlyb2lHQm11V1Z3Njk1OUhMSEF1dGs5cHNBSTVkNldMcEZPcHc5b29hSjBFMU5pLzYvc2RKWnJKTjVKeC8iLCJtYWMiOiI4OTVmZmZiZDYwMTk5ZDVlMzc3YjgyNjQwZjZhODBiYjZlNjVhZWNiNmViYzlkNjE5NDBjNDUyZjZiZjU3YzE1IiwidGFnIjoiIn0%3D; expires=Mon, 19-May-2025 13:05:45 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImUyUmh0QXV3b01FaDZUVFU0V21oMUE9PSIsInZhbHVlIjoiOWxXWXlXcTVXSXRQWUhHZjFLNzgzZGdhamJNblo1ejk5dlJFcVRXZTdwUkkyWFBVd2JaL3BDNWt2bGs3RXlIRlNpWXlyb ▶"
    1 => "tagmyfish_session=eyJpdiI6ImFRV012a3F2YWR6OUhnQVJ6cGhjYnc9PSIsInZhbHVlIjoiVUpLUzdVekJvN01MblpNSWg2M2RJY2psVXlTcDRXMGxuOUM4c1VVOTd1ZlVTbmprYlB6SjlZV2VmZEdtZEZzbTNLUHZGQ0xwck5GQXZsQ0VNbkVyZkhaaU12djhWMjRjbWJlZUxZWThhQmtBQmYwa0tWUVMrbUp2cHpLZnF5ZjciLCJtYWMiOiJjZWY0MzVmYzQ3YjZhMThkN2FiMTJmN2E0MDQ1ZWI0NGZmMmY3ZmY3NzlhMTZiOTUzMTM4ZmE0MjJkNjk4NGZlIiwidGFnIjoiIn0%3D; expires=Mon, 19-May-2025 13:05:45 GMT; path=/; secure; httponly ◀tagmyfish_session=eyJpdiI6ImFRV012a3F2YWR6OUhnQVJ6cGhjYnc9PSIsInZhbHVlIjoiVUpLUzdVekJvN01MblpNSWg2M2RJY2psVXlTcDRXMGxuOUM4c1VVOTd1ZlVTbmprYlB6SjlZV2VmZEdtZEZzbT ▶"
  ]
]

session_attributes

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

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-05-19 11:05:45	GET	/fish/genus/ptychobarbus	269 27 390

Ptychobarbus

General data

Classification

Species

Heavy lips fish (Ptychobarbus chungtienensis)

Indus snowtrout (Ptychobarbus conirostris)

Ptychobarbus dipogon

Ptychobarbus kaznakovi

Taxonomy of Fishes

1 x Application (89.56%)	202ms
1 x Booting (10.44%)	23.53ms

Ptychobarbus

General data

Classification

Species

Heavy lips fish (Ptychobarbus chungtienensis)

Indus snowtrout (Ptychobarbus conirostris)

Ptychobarbus dipogon

Ptychobarbus kaznakovi

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!

Tag Your Catch and
Win a Twin Power!