Francesco Nuzzi

Messages Request Timeline Exceptions Views14 Queries90 Models92 Mails Gate

Settings Request history218ms6MB10.xGET {season_type}-fighter/{fighter}

status

200 OK

full_url

https://dev.pflmma.com/regular-fighter/francesco-nuzzi

action_name

fighter.show

controller_action

App\Http\Controllers\FighterController@show

uri

GET {season_type}-fighter/{fighter}

domain

dev.pflmma.com

controller

App\Http\Controllers\FighterController@show

namespace

App\Http\Controllers

file

app/Http/Controllers/FighterController.php:270-539

middleware

web

duration

226ms

peak_memory

8MB

response

text/html; charset=UTF-8

request_format

html

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:15 [▼
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "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)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "host" => array:1 [▶
    0 => "dev.pflmma.com"
  ]
]

request_cookies

[]

response_headers

  0 of 0   
array:3 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Fri, 25 Apr 2025 06:42:35 GMT"
  ]
]

session_attributes

  0 of 0   
array:1 [▼
  "_token" => "evrTVzUmxttEs7iBwdh3eMIgPVeEM7R5T335U9aX"
]

Booting (14.19ms)time
Application (204ms)time
Routing (1.32ms)
View: components.widgets.articleviews
View: components.widgets.videoviews
Preparing Response (48.38ms)
View: fighters.showviews
View: layouts.frontendviews
View: components.faviconsviews
View: components.stylesviews
View: components.frontend-tracking-headerviews
View: components.frontend-tracking-bodyviews
View: components.scriptsviews
View: components.countdown-timerviews
View: components.navviews
View: components.newsletter-signupviews
View: components.popupviews
View: components.preloaderviews
1 x Application (93.49%)
204ms
1 x Preparing Response (22.17%)
48.38ms
1 x Booting (6.5%)
14.19ms
1 x Routing (0.61%)
1.32ms
14 x View (0%)
0μs

14 templates were rendered

components.widgets.articlearticle.blade.php#?blade
components.widgets.videovideo.blade.php#?blade
fighters.showshow.blade.php#?blade
layouts.frontendfrontend.blade.php#?blade
components.faviconsfavicons.blade.php#?blade
components.stylesstyles.blade.php#?blade
components.frontend-tracking-headerfrontend-tracking-header.blade.php#?blade
components.frontend-tracking-bodyfrontend-tracking-body.blade.php#?blade
components.scriptsscripts.blade.php#?blade
components.countdown-timercountdown-timer.blade.php#?blade
components.navnav.blade.php#?blade
components.newsletter-signupnewsletter-signup.blade.php#?blade
components.popuppopup.blade.php#?blade
components.preloaderpreloader.blade.php#?blade

90 statements were executed (31 duplicates)Show only duplicates126ms

FighterController.php#1193devpflmma_webConnection Established

Backtrace

app/Http/Controllers/FighterController.php:1193
app/Http/Controllers/FighterController.php:290
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

FighterController.php#1196devpflmma_web4.86ms

select * from `fighters` where LOWER(REPLACE(REPLACE(first_name, " ", ""), "'", "")) = "francesco" and LOWER(REPLACE(REPLACE(last_name, " ", ""), "'", "")) = "nuzzi" limit 1

Backtrace

app/Http/Controllers/FighterController.php:1196
app/Http/Controllers/FighterController.php:290
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

FighterController.php#315devpflmma_web1.18ms

select * from `fighter_records` as `fr` left join `seasons` as `s` on `s`.`id` = `fr`.`season_id` where `fr`.`fighter_id` = 420 and `s`.`year` <> '2020' order by `s`.`year` desc limit 1

Bindings	0: 420 1: 2020
Backtrace	app/Http/Controllers/FighterController.php:315 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

FighterController.php#317devpflmma_web700μsselect * from `seasons` where `seasons`.`id` = 8 limit 1

Bindings	0: 8
Backtrace	app/Http/Controllers/FighterController.php:317 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

FighterController.php#326devpflmma_web6.76ms

select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 420 and `s`.`year` <> '2020' order by `s`.`year` desc

Bindings	0: 420 1: 2020
Backtrace	app/Http/Controllers/FighterController.php:326 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

FighterController.php#338devpflmma_web1.22ms

select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 420 and `s`.`year` = 2023 order by `s`.`year` desc

Bindings	0: 420 1: 2023
Backtrace	app/Http/Controllers/FighterController.php:338 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

Functions.php#1037devpflmma_web1.45ms

select * from `fighter_records` as `fr` left join `seasons` as `s` on `s`.`id` = `fr`.`season_id` where `fr`.`fighter_id` = 420 and `s`.`year` <> '2020' order by `s`.`year` desc limit 1

Bindings	0: 420 1: 2020
Backtrace	app/Helpers/Functions.php:1037 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

Functions.php#1039devpflmma_web780μsselect * from `seasons` where `seasons`.`id` = 8 limit 1

Bindings	0: 8
Backtrace	app/Helpers/Functions.php:1039 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

Functions.php#1048devpflmma_web1.75ms

select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 420 and `s`.`year` <> '2020' order by `s`.`year` desc

Bindings	0: 420 1: 2020
Backtrace	app/Helpers/Functions.php:1048 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

Functions.php#1060devpflmma_web780μs

select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 420 and `s`.`year` = 2023 order by `s`.`year` desc

Bindings	0: 420 1: 2023
Backtrace	app/Helpers/Functions.php:1060 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

FighterStatController.php#397devpflmma_web790μsselect * from `seasons` where `year` = 2023 limit 1

Bindings	0: 2023
Backtrace	app/Http/Controllers/FighterStatController.php:397 app/Helpers/Functions.php:1064 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

FighterStatController.php#398devpflmma_web980μsselect * from `fighter_records` where `fighter_id` = 420 and `season_id` = 7 limit 1

Bindings	0: 420 1: 7
Backtrace	app/Http/Controllers/FighterStatController.php:398 app/Helpers/Functions.php:1064 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

FighterStatController.php#304devpflmma_web640μsselect * from `seasons` where `year` = 2023 limit 1

Bindings	0: 2023
Backtrace	app/Http/Controllers/FighterStatController.php:304 app/Http/Controllers/FighterStatController.php:350 app/Http/Controllers/FighterStatController.php:401 app/Helpers/Functions.php:1064 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

FighterStatController.php#335devpflmma_web840μs

SELECT
TRUNCATE(MAX(fs.MaxPunchSpeed),2) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '7'
WHERE
1=1
AND fs.season_year = '2023' AND f.id='420'

Backtrace

app/Http/Controllers/FighterStatController.php:335
app/Http/Controllers/FighterStatController.php:350
app/Http/Controllers/FighterStatController.php:401
app/Helpers/Functions.php:1064
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

FighterStatController.php#304devpflmma_web640μsselect * from `seasons` where `year` = 2023 limit 1

Bindings	0: 2023
Backtrace	app/Http/Controllers/FighterStatController.php:304 app/Http/Controllers/FighterStatController.php:352 app/Http/Controllers/FighterStatController.php:401 app/Helpers/Functions.php:1064 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

FighterStatController.php#335devpflmma_web1.12ms

SELECT
CONCAT(TRUNCATE(SUM(fs.StrikesLanded),0), ' / ', TRUNCATE(SUM(fs.StrikesThrown),0)) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '7'
WHERE
1=1
AND fs.season_year = '2023' AND f.id='420'

Backtrace

app/Http/Controllers/FighterStatController.php:335
app/Http/Controllers/FighterStatController.php:352
app/Http/Controllers/FighterStatController.php:401
app/Helpers/Functions.php:1064
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

FighterStatController.php#304devpflmma_web690μsselect * from `seasons` where `year` = 2023 limit 1

Bindings	0: 2023
Backtrace	app/Http/Controllers/FighterStatController.php:304 app/Http/Controllers/FighterStatController.php:353 app/Http/Controllers/FighterStatController.php:401 app/Helpers/Functions.php:1064 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

FighterStatController.php#335devpflmma_web940μs

SELECT
CONCAT(TRUNCATE(SUM(fs.ArmStrikesLanded),0), ' / ', TRUNCATE(SUM(fs.ArmStrikesThrown),0)) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '7'
WHERE
1=1
AND fs.season_year = '2023' AND f.id='420'

Backtrace

app/Http/Controllers/FighterStatController.php:335
app/Http/Controllers/FighterStatController.php:353
app/Http/Controllers/FighterStatController.php:401
app/Helpers/Functions.php:1064
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

FighterStatController.php#304devpflmma_web1.37msselect * from `seasons` where `year` = 2023 limit 1

Bindings	0: 2023
Backtrace	app/Http/Controllers/FighterStatController.php:304 app/Http/Controllers/FighterStatController.php:354 app/Http/Controllers/FighterStatController.php:401 app/Helpers/Functions.php:1064 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

FighterStatController.php#335devpflmma_web1.51ms

SELECT
CONCAT(TRUNCATE(SUM(fs.LegStrikesLanded),0), ' / ', TRUNCATE(SUM(fs.LegStrikesThrown),0)) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '7'
WHERE
1=1
AND fs.season_year = '2023' AND f.id='420'

Backtrace

app/Http/Controllers/FighterStatController.php:335
app/Http/Controllers/FighterStatController.php:354
app/Http/Controllers/FighterStatController.php:401
app/Helpers/Functions.php:1064
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

FighterStatController.php#304devpflmma_web950μsselect * from `seasons` where `year` = 2023 limit 1

Bindings	0: 2023
Backtrace	app/Http/Controllers/FighterStatController.php:304 app/Http/Controllers/FighterStatController.php:355 app/Http/Controllers/FighterStatController.php:401 app/Helpers/Functions.php:1064 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

FighterStatController.php#335devpflmma_web940μs

SELECT
CONCAT(TRUNCATE(SUM(fs.GroundStrikesLanded),0), ' / ', TRUNCATE(SUM(fs.GroundStrikesThrown),0)) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '7'
WHERE
1=1
AND fs.season_year = '2023' AND f.id='420'

Backtrace

app/Http/Controllers/FighterStatController.php:335
app/Http/Controllers/FighterStatController.php:355
app/Http/Controllers/FighterStatController.php:401
app/Helpers/Functions.php:1064
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

FighterStatController.php#304devpflmma_web660μsselect * from `seasons` where `year` = 2023 limit 1

Bindings	0: 2023
Backtrace	app/Http/Controllers/FighterStatController.php:304 app/Http/Controllers/FighterStatController.php:356 app/Http/Controllers/FighterStatController.php:401 app/Helpers/Functions.php:1064 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

FighterStatController.php#335devpflmma_web1.23ms

SELECT
CONCAT(TRUNCATE(SUM(fs.Takedowns),0), ' / ', TRUNCATE(SUM(fs.TakedownAttempts),0)) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '7'
WHERE
1=1
AND fs.season_year = '2023' AND f.id='420'

Backtrace

app/Http/Controllers/FighterStatController.php:335
app/Http/Controllers/FighterStatController.php:356
app/Http/Controllers/FighterStatController.php:401
app/Helpers/Functions.php:1064
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

FighterStatController.php#304devpflmma_web1.14msselect * from `seasons` where `year` = 2023 limit 1

Bindings	0: 2023
Backtrace	app/Http/Controllers/FighterStatController.php:304 app/Http/Controllers/FighterStatController.php:358 app/Http/Controllers/FighterStatController.php:401 app/Helpers/Functions.php:1064 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

FighterStatController.php#335devpflmma_web1.53ms

SELECT
TRUNCATE(SUM(fs.ElapsedTimeInnerZone),0) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '7'
WHERE
1=1
AND fs.season_year = '2023' AND f.id='420'

Backtrace

app/Http/Controllers/FighterStatController.php:335
app/Http/Controllers/FighterStatController.php:358
app/Http/Controllers/FighterStatController.php:401
app/Helpers/Functions.php:1064
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

FighterStatController.php#304devpflmma_web650μsselect * from `seasons` where `year` = 2023 limit 1

Bindings	0: 2023
Backtrace	app/Http/Controllers/FighterStatController.php:304 app/Http/Controllers/FighterStatController.php:360 app/Http/Controllers/FighterStatController.php:401 app/Helpers/Functions.php:1064 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

FighterStatController.php#335devpflmma_web1.08ms

SELECT
TRUNCATE(SUM(fs.ElapsedTimeOuterZone),0) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '7'
WHERE
1=1
AND fs.season_year = '2023' AND f.id='420'

Backtrace

app/Http/Controllers/FighterStatController.php:335
app/Http/Controllers/FighterStatController.php:360
app/Http/Controllers/FighterStatController.php:401
app/Helpers/Functions.php:1064
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

FighterStatController.php#225devpflmma_web1.18msselect * from `seasons` where `year` = 2023 limit 1

Bindings	0: 2023
Backtrace	app/Http/Controllers/FighterStatController.php:225 app/Http/Controllers/FighterStatController.php:384 app/Http/Controllers/FighterStatController.php:401 app/Helpers/Functions.php:1064 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

FighterStatController.php#267devpflmma_web9.02ms

SELECT
f.id,
CONCAT(f.first_name,' ',f.last_name) AS Name,
TRUNCATE(MAX(fs.MaxPunchSpeed),2) AS Value
FROM
`fighter_stats` fs
INNER JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id=7
LEFT JOIN
fighter_classes fc
ON
fc.id = fr.fighter_class_id
WHERE
1=1
AND fs.season_year = '2023'
GROUP BY
f.id, f.first_name, f.last_name
ORDER BY CONVERT(MAX(fs.MaxPunchSpeed), DECIMAL) DESC
LIMIT 5

Backtrace

app/Http/Controllers/FighterStatController.php:267
app/Http/Controllers/FighterStatController.php:384
app/Http/Controllers/FighterStatController.php:401
app/Helpers/Functions.php:1064
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

FighterStatController.php#270devpflmma_web1.17msselect * from `fighters` where `fighters`.`id` = 384 limit 1

Bindings	0: 384
Backtrace	app/Http/Controllers/FighterStatController.php:270 app/Http/Controllers/FighterStatController.php:384 app/Http/Controllers/FighterStatController.php:401 app/Helpers/Functions.php:1064 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

Mediable.php#385devpflmma_web1.11ms

select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 384 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc

Bindings	0: 384 1: App\Models\Fighter
Backtrace	vendor/plank/laravel-mediable/src/Mediable.php:385 vendor/plank/laravel-mediable/src/Mediable.php:427 app/Http/Controllers/FighterStatController.php:272 app/Http/Controllers/FighterStatController.php:384 app/Http/Controllers/FighterStatController.php:401

FighterStatController.php#270devpflmma_web2.78msselect * from `fighters` where `fighters`.`id` = 454 limit 1

Bindings	0: 454
Backtrace	app/Http/Controllers/FighterStatController.php:270 app/Http/Controllers/FighterStatController.php:384 app/Http/Controllers/FighterStatController.php:401 app/Helpers/Functions.php:1064 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

Mediable.php#385devpflmma_web1.39ms

select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 454 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc

Bindings	0: 454 1: App\Models\Fighter
Backtrace	vendor/plank/laravel-mediable/src/Mediable.php:385 vendor/plank/laravel-mediable/src/Mediable.php:427 app/Http/Controllers/FighterStatController.php:272 app/Http/Controllers/FighterStatController.php:384 app/Http/Controllers/FighterStatController.php:401

FighterStatController.php#270devpflmma_web1.12msselect * from `fighters` where `fighters`.`id` = 405 limit 1

Bindings	0: 405
Backtrace	app/Http/Controllers/FighterStatController.php:270 app/Http/Controllers/FighterStatController.php:384 app/Http/Controllers/FighterStatController.php:401 app/Helpers/Functions.php:1064 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

Mediable.php#385devpflmma_web1.55ms

select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 405 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc

Bindings	0: 405 1: App\Models\Fighter
Backtrace	vendor/plank/laravel-mediable/src/Mediable.php:385 vendor/plank/laravel-mediable/src/Mediable.php:427 app/Http/Controllers/FighterStatController.php:272 app/Http/Controllers/FighterStatController.php:384 app/Http/Controllers/FighterStatController.php:401

FighterStatController.php#270devpflmma_web800μsselect * from `fighters` where `fighters`.`id` = 234 limit 1

Bindings	0: 234
Backtrace	app/Http/Controllers/FighterStatController.php:270 app/Http/Controllers/FighterStatController.php:384 app/Http/Controllers/FighterStatController.php:401 app/Helpers/Functions.php:1064 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

Mediable.php#385devpflmma_web2.77ms

select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 234 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc

Bindings	0: 234 1: App\Models\Fighter
Backtrace	vendor/plank/laravel-mediable/src/Mediable.php:385 vendor/plank/laravel-mediable/src/Mediable.php:427 app/Http/Controllers/FighterStatController.php:272 app/Http/Controllers/FighterStatController.php:384 app/Http/Controllers/FighterStatController.php:401

FighterStatController.php#270devpflmma_web1.43msselect * from `fighters` where `fighters`.`id` = 75 limit 1

Bindings	0: 75
Backtrace	app/Http/Controllers/FighterStatController.php:270 app/Http/Controllers/FighterStatController.php:384 app/Http/Controllers/FighterStatController.php:401 app/Helpers/Functions.php:1064 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

Mediable.php#385devpflmma_web1.13ms

select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 75 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc

Bindings	0: 75 1: App\Models\Fighter
Backtrace	vendor/plank/laravel-mediable/src/Mediable.php:385 vendor/plank/laravel-mediable/src/Mediable.php:427 app/Http/Controllers/FighterStatController.php:272 app/Http/Controllers/FighterStatController.php:384 app/Http/Controllers/FighterStatController.php:401

FighterController.php#429devpflmma_web1.67ms

select `f`.*, `fr`.`points`, `fr`.`season_record`, `fr`.`ranking`, `fr`.`final_decision`, `fc`.`name` as `fighter_class_name`,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/", f.nation_flag, ".jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg")
) AS flag_url,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/", f.nation_flag, "_BACKDROP.jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg")
) AS flag_backdrop_url,
IF(
IFNULL(m.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m.directory, "/", m.filename, ".", m.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-", f.gender, ".png")
) AS headshot_url,
IF(
IFNULL(m2.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m2.directory, "/", m2.filename, ".", m2.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-", f.gender, ".png")
) AS bodyshot_url,
IF(
IFNULL(m3.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m3.directory, "/", m3.filename, ".", m3.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/banners/default-banner-", f.gender, ".jpg")
) AS banner_url from `fighters` as `f` left join `fighter_records` as `fr` on `fr`.`fighter_id` = `f`.`id` and `fr`.`season_id` = 8 left join `mediables` as `med` on `med`.`mediable_id` = `f`.`id` and `med`.`tag` = 'headshot' and `med`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m` on `m`.`id` = `med`.`media_id` left join `mediables` as `med2` on `med2`.`mediable_id` = `f`.`id` and `med2`.`tag` = 'bodyshot' and `med2`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m2` on `m2`.`id` = `med2`.`media_id` left join `mediables` as `med3` on `med3`.`mediable_id` = `f`.`id` and `med3`.`tag` = 'banner' and `med3`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m3` on `m3`.`id` = `med3`.`media_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fr`.`fighter_class_id` where `f`.`id` = 420 limit 1

Bindings	0: 8 1: headshot 2: App\Models\Fighter 3: bodyshot 4: App\Models\Fighter 5: banner 6: App\Models\Fighter 7: 420
Backtrace	app/Http/Controllers/FighterController.php:429 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

FighterController.php#431devpflmma_web770μsselect * from `fighters` where `fighters`.`id` = 420 limit 1

Bindings	0: 420
Backtrace	app/Http/Controllers/FighterController.php:431 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

FighterController.php#432devpflmma_web2.68ms

(select * from `fight_cards` where `fight_cards`.`fighter_id` = 420 and `fight_cards`.`fighter_id` is not null) union (select * from `fight_cards` where `fight_cards`.`vs_fighter_id` = 420 and `fight_cards`.`vs_fighter_id` is not null) order by `created_at` desc

Bindings	0: 420 1: 420
Backtrace	app/Http/Controllers/FighterController.php:432 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

SettingEloquentStorage.php#30devpflmma_web850μsselect `val`, `name` from `settings` where `group` = 'default'

Bindings	0: default
Backtrace	vendor/qcod/laravel-settings/src/Setting/SettingEloquentStorage.php:30 app/Http/Controllers/FightCardController.php:434 app/Http/Controllers/FighterController.php:436 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

FightCardController.php#436devpflmma_web1.02msselect * from `events` where `events`.`id` = 106 limit 1

Bindings	0: 106
Backtrace	app/Http/Controllers/FightCardController.php:436 app/Http/Controllers/FighterController.php:436 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

FightCardController.php#440devpflmma_web680μsselect * from `seasons` where `seasons`.`id` = 18 limit 1

Bindings	0: 18
Backtrace	app/Http/Controllers/FightCardController.php:440 app/Http/Controllers/FighterController.php:436 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

FightCardController.php#450devpflmma_web3.76ms

SELECT
e.datetime AS event_datetime,
2025 AS season_year,
s.season_type AS season_type,
e.slug AS event_slug,
fc.order_number,
fc.id AS fight_card_id,
fc.broadcaster,
fc.winner_id,
fc.match_details,
fc.show_keys_to_victory,
fc.show_match_details,
fc.keys_to_victory AS fighter_keys_to_victory,
fc.vs_keys_to_victory AS vs_fighter_keys_to_victory,
fc.override_status,
fc.pickem_status,
IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.fighter_points, fr1.points) AS fighter_points,
IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.vs_fighter_points, fr2.points) AS vs_fighter_points,
fr1.points AS fighter_total_points,
fr2.points AS vs_fighter_total_points,
f1.gender AS fighter_gender,
f2.gender AS vs_fighter_gender,
f1.arm_reach AS fighter_arm_reach,
f2.arm_reach AS vs_fighter_arm_reach,
f1.leg_reach AS fighter_leg_reach,
f2.leg_reach AS vs_fighter_leg_reach,
f1.height AS fighter_height,
f2.height AS vs_fighter_height,
f1.weight AS fighter_weight,
f2.weight AS vs_fighter_weight,
fc.win_by,
fc.round_time,
CONCAT(f1.first_name, ' ', f1.last_name) AS fighter_name,
CONCAT(f2.first_name, ' ', f2.last_name) AS vs_fighter_name,
f1.first_name AS fighter_first_name,
f1.last_name AS fighter_last_name,
f2.first_name AS vs_fighter_first_name,
f2.last_name AS vs_fighter_last_name,
f1.id AS fighter_id,
f2.id AS vs_fighter_id,
f1.career_record AS fighter_career_record,
f2.career_record AS vs_fighter_career_record,
fr1.season_record AS fighter_season_record,
fr2.season_record AS vs_fighter_season_record,
f1.nation_flag AS fighter_nation_flag,
f2.nation_flag AS vs_fighter_nation_flag,
f1.challenger_highlights AS challenger_highlights,
f2.challenger_highlights AS vs_challenger_highlights,
fr1.ranking AS fighter_ranking,
fr2.ranking AS vs_fighter_ranking,
fc2.name AS weightclass,
fc2.shortcode AS weightclass_shortcode,
IF(fc.fighter_record<>'', fc.fighter_record, fr1.season_record) AS fighter_fight_card_record,
IF(fc.vs_fighter_record<>'', fc.vs_fighter_record, fr2.season_record) AS vs_fighter_fight_card_record,
b.name AS broadcast_name,
b.url AS broadcast_url,
fc.match_type,
IF(
IFNULL(m1.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m1.directory, '/', m1.filename, '.', m1.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f1.gender, '.png')
) AS fighter_thumbnail,
IF(
IFNULL(m2.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m2.directory, '/', m2.filename, '.', m2.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f1.gender, '.png')
) AS fighter_profile_image,
IF(
IFNULL(m3.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m3.directory, '/', m3.filename, '.', m3.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f2.gender, '.png')
) AS vs_fighter_thumbnail,
IF(
IFNULL(m4.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m4.directory, '/', m4.filename, '.', m4.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f2.gender, '.png')
) AS vs_fighter_profile_image,
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m5.directory, '/', m5.filename, '.', m5.extension) AS broadcast_logo,
IF(
IFNULL(m6.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m6.directory, '/', m6.filename, '.', m6.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f1.gender, '-left.png')
) AS fighter_bodyshot_side,
IF(
IFNULL(m7.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m7.directory, '/', m7.filename, '.', m7.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f2.gender, '-right.png')
) AS vs_fighter_bodyshot_side,
IF(
IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f1.nation_flag, '.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg')
) AS fighter_flag,
IF(
IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f2.nation_flag, '.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg')
) AS vs_fighter_flag,
IF(
IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f1.nation_flag, '_BACKDROP.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg')
) AS fighter_flag_backdrop,
IF(
IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f2.nation_flag, '_BACKDROP.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg')
) AS vs_fighter_flag_backdrop
FROM
fight_cards fc
LEFT JOIN
fighters f1
ON
f1.id = fc.fighter_id
LEFT JOIN
fighters f2
ON
f2.id = fc.vs_fighter_id
INNER JOIN
fighter_classes fc2
ON
fc2.id = fc.fighter_class_id
INNER JOIN
events e
ON
e.id = fc.event_id
LEFT JOIN
seasons s
ON
e.season_id = s.id
LEFT JOIN
broadcasters b
ON
b.shortcode = fc.broadcaster
LEFT JOIN
fighter_records fr1
ON
fr1.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 18
AND
fighter_id = fc.fighter_id
LIMIT 1
)
AND
fr1.season_id = 18
LEFT JOIN
fighter_records fr2
ON
fr2.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 18
AND
fighter_id = fc.vs_fighter_id
LIMIT 1
)
AND
fr2.season_id = 18
LEFT JOIN
mediables med1
ON
med1.mediable_id=f1.id
AND
med1.tag='headshot'
AND
med1.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m1
ON
m1.id=med1.media_id
LEFT JOIN
mediables med2
ON
med2.mediable_id=f1.id
AND
med2.tag='bodyshot'
AND
med2.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m2
ON
m2.id=med2.media_id
LEFT JOIN
mediables med3
ON
med3.mediable_id=f2.id
AND
med3.tag='headshot'
AND
med3.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m3
ON
m3.id=med3.media_id
LEFT JOIN
mediables med4
ON
med4.mediable_id=f2.id
AND
med4.tag='bodyshot'
AND
med4.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m4
ON
m4.id=med4.media_id
LEFT JOIN
mediables med5
ON
med5.mediable_id=b.id
AND
med5.tag='logo'
AND
med5.mediable_type='App\\Models\\Broadcaster'
LEFT JOIN
media m5
ON
m5.id=med5.media_id
LEFT JOIN
mediables med6
ON
med6.mediable_id=fc.id
AND
med6.tag='fighter_bodyshot_side_left'
AND
med6.mediable_type='App\\Models\\FightCard'
LEFT JOIN
media m6
ON
m6.id=med6.media_id
LEFT JOIN
mediables med7
ON
med7.mediable_id=fc.id
AND
med7.tag='fighter_bodyshot_side_right'
AND
med7.mediable_type='App\\Models\\FightCard'
LEFT JOIN
media m7
ON
m7.id=med7.media_id
WHERE
e.slug = '2025-wt-2'
AND (fc.fighter_id=420 OR fc.vs_fighter_id=420)
ORDER BY
fc.order_number ASC

Backtrace

app/Http/Controllers/FightCardController.php:450
app/Http/Controllers/FighterController.php:436
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

SettingEloquentStorage.php#30devpflmma_web1.08msselect `val`, `name` from `settings` where `group` = 'default'

Bindings	0: default
Backtrace	vendor/qcod/laravel-settings/src/Setting/SettingEloquentStorage.php:30 app/Http/Controllers/FightCardController.php:434 app/Http/Controllers/FighterController.php:436 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

FightCardController.php#436devpflmma_web1.1msselect * from `events` where `events`.`id` = 63 limit 1

Bindings	0: 63
Backtrace	app/Http/Controllers/FightCardController.php:436 app/Http/Controllers/FighterController.php:436 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

FightCardController.php#440devpflmma_web850μsselect * from `seasons` where `seasons`.`id` = 8 limit 1

Bindings	0: 8
Backtrace	app/Http/Controllers/FightCardController.php:440 app/Http/Controllers/FighterController.php:436 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

FightCardController.php#450devpflmma_web3.77ms

SELECT
e.datetime AS event_datetime,
2023 AS season_year,
s.season_type AS season_type,
e.slug AS event_slug,
fc.order_number,
fc.id AS fight_card_id,
fc.broadcaster,
fc.winner_id,
fc.match_details,
fc.show_keys_to_victory,
fc.show_match_details,
fc.keys_to_victory AS fighter_keys_to_victory,
fc.vs_keys_to_victory AS vs_fighter_keys_to_victory,
fc.override_status,
fc.pickem_status,
IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.fighter_points, fr1.points) AS fighter_points,
IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.vs_fighter_points, fr2.points) AS vs_fighter_points,
fr1.points AS fighter_total_points,
fr2.points AS vs_fighter_total_points,
f1.gender AS fighter_gender,
f2.gender AS vs_fighter_gender,
f1.arm_reach AS fighter_arm_reach,
f2.arm_reach AS vs_fighter_arm_reach,
f1.leg_reach AS fighter_leg_reach,
f2.leg_reach AS vs_fighter_leg_reach,
f1.height AS fighter_height,
f2.height AS vs_fighter_height,
f1.weight AS fighter_weight,
f2.weight AS vs_fighter_weight,
fc.win_by,
fc.round_time,
CONCAT(f1.first_name, ' ', f1.last_name) AS fighter_name,
CONCAT(f2.first_name, ' ', f2.last_name) AS vs_fighter_name,
f1.first_name AS fighter_first_name,
f1.last_name AS fighter_last_name,
f2.first_name AS vs_fighter_first_name,
f2.last_name AS vs_fighter_last_name,
f1.id AS fighter_id,
f2.id AS vs_fighter_id,
f1.career_record AS fighter_career_record,
f2.career_record AS vs_fighter_career_record,
fr1.season_record AS fighter_season_record,
fr2.season_record AS vs_fighter_season_record,
f1.nation_flag AS fighter_nation_flag,
f2.nation_flag AS vs_fighter_nation_flag,
f1.challenger_highlights AS challenger_highlights,
f2.challenger_highlights AS vs_challenger_highlights,
fr1.ranking AS fighter_ranking,
fr2.ranking AS vs_fighter_ranking,
fc2.name AS weightclass,
fc2.shortcode AS weightclass_shortcode,
IF(fc.fighter_record<>'', fc.fighter_record, fr1.season_record) AS fighter_fight_card_record,
IF(fc.vs_fighter_record<>'', fc.vs_fighter_record, fr2.season_record) AS vs_fighter_fight_card_record,
b.name AS broadcast_name,
b.url AS broadcast_url,
fc.match_type,
IF(
IFNULL(m1.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m1.directory, '/', m1.filename, '.', m1.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f1.gender, '.png')
) AS fighter_thumbnail,
IF(
IFNULL(m2.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m2.directory, '/', m2.filename, '.', m2.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f1.gender, '.png')
) AS fighter_profile_image,
IF(
IFNULL(m3.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m3.directory, '/', m3.filename, '.', m3.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f2.gender, '.png')
) AS vs_fighter_thumbnail,
IF(
IFNULL(m4.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m4.directory, '/', m4.filename, '.', m4.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f2.gender, '.png')
) AS vs_fighter_profile_image,
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m5.directory, '/', m5.filename, '.', m5.extension) AS broadcast_logo,
IF(
IFNULL(m6.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m6.directory, '/', m6.filename, '.', m6.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f1.gender, '-left.png')
) AS fighter_bodyshot_side,
IF(
IFNULL(m7.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m7.directory, '/', m7.filename, '.', m7.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f2.gender, '-right.png')
) AS vs_fighter_bodyshot_side,
IF(
IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f1.nation_flag, '.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg')
) AS fighter_flag,
IF(
IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f2.nation_flag, '.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg')
) AS vs_fighter_flag,
IF(
IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f1.nation_flag, '_BACKDROP.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg')
) AS fighter_flag_backdrop,
IF(
IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f2.nation_flag, '_BACKDROP.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg')
) AS vs_fighter_flag_backdrop
FROM
fight_cards fc
LEFT JOIN
fighters f1
ON
f1.id = fc.fighter_id
LEFT JOIN
fighters f2
ON
f2.id = fc.vs_fighter_id
INNER JOIN
fighter_classes fc2
ON
fc2.id = fc.fighter_class_id
INNER JOIN
events e
ON
e.id = fc.event_id
LEFT JOIN
seasons s
ON
e.season_id = s.id
LEFT JOIN
broadcasters b
ON
b.shortcode = fc.broadcaster
LEFT JOIN
fighter_records fr1
ON
fr1.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 8
AND
fighter_id = fc.fighter_id
LIMIT 1
)
AND
fr1.season_id = 8
LEFT JOIN
fighter_records fr2
ON
fr2.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 8
AND
fighter_id = fc.vs_fighter_id
LIMIT 1
)
AND
fr2.season_id = 8
LEFT JOIN
mediables med1
ON
med1.mediable_id=f1.id
AND
med1.tag='headshot'
AND
med1.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m1
ON
m1.id=med1.media_id
LEFT JOIN
mediables med2
ON
med2.mediable_id=f1.id
AND
med2.tag='bodyshot'
AND
med2.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m2
ON
m2.id=med2.media_id
LEFT JOIN
mediables med3
ON
med3.mediable_id=f2.id
AND
med3.tag='headshot'
AND
med3.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m3
ON
m3.id=med3.media_id
LEFT JOIN
mediables med4
ON
med4.mediable_id=f2.id
AND
med4.tag='bodyshot'
AND
med4.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m4
ON
m4.id=med4.media_id
LEFT JOIN
mediables med5
ON
med5.mediable_id=b.id
AND
med5.tag='logo'
AND
med5.mediable_type='App\\Models\\Broadcaster'
LEFT JOIN
media m5
ON
m5.id=med5.media_id
LEFT JOIN
mediables med6
ON
med6.mediable_id=fc.id
AND
med6.tag='fighter_bodyshot_side_left'
AND
med6.mediable_type='App\\Models\\FightCard'
LEFT JOIN
media m6
ON
m6.id=med6.media_id
LEFT JOIN
mediables med7
ON
med7.mediable_id=fc.id
AND
med7.tag='fighter_bodyshot_side_right'
AND
med7.mediable_type='App\\Models\\FightCard'
LEFT JOIN
media m7
ON
m7.id=med7.media_id
WHERE
e.slug = '2023-pfl-europe-2'
AND (fc.fighter_id=420 OR fc.vs_fighter_id=420)
ORDER BY
fc.order_number ASC

Backtrace

app/Http/Controllers/FightCardController.php:450
app/Http/Controllers/FighterController.php:436
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

SettingEloquentStorage.php#30devpflmma_web780μsselect `val`, `name` from `settings` where `group` = 'default'

Bindings	0: default
Backtrace	vendor/qcod/laravel-settings/src/Setting/SettingEloquentStorage.php:30 app/Http/Controllers/FightCardController.php:434 app/Http/Controllers/FighterController.php:436 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

FightCardController.php#436devpflmma_web800μsselect * from `events` where `events`.`id` = 51 limit 1

Bindings	0: 51
Backtrace	app/Http/Controllers/FightCardController.php:436 app/Http/Controllers/FighterController.php:436 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

FightCardController.php#440devpflmma_web740μsselect * from `seasons` where `seasons`.`id` = 6 limit 1

Bindings	0: 6
Backtrace	app/Http/Controllers/FightCardController.php:440 app/Http/Controllers/FighterController.php:436 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

FightCardController.php#450devpflmma_web3.1ms

SELECT
e.datetime AS event_datetime,
2022 AS season_year,
s.season_type AS season_type,
e.slug AS event_slug,
fc.order_number,
fc.id AS fight_card_id,
fc.broadcaster,
fc.winner_id,
fc.match_details,
fc.show_keys_to_victory,
fc.show_match_details,
fc.keys_to_victory AS fighter_keys_to_victory,
fc.vs_keys_to_victory AS vs_fighter_keys_to_victory,
fc.override_status,
fc.pickem_status,
IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.fighter_points, fr1.points) AS fighter_points,
IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.vs_fighter_points, fr2.points) AS vs_fighter_points,
fr1.points AS fighter_total_points,
fr2.points AS vs_fighter_total_points,
f1.gender AS fighter_gender,
f2.gender AS vs_fighter_gender,
f1.arm_reach AS fighter_arm_reach,
f2.arm_reach AS vs_fighter_arm_reach,
f1.leg_reach AS fighter_leg_reach,
f2.leg_reach AS vs_fighter_leg_reach,
f1.height AS fighter_height,
f2.height AS vs_fighter_height,
f1.weight AS fighter_weight,
f2.weight AS vs_fighter_weight,
fc.win_by,
fc.round_time,
CONCAT(f1.first_name, ' ', f1.last_name) AS fighter_name,
CONCAT(f2.first_name, ' ', f2.last_name) AS vs_fighter_name,
f1.first_name AS fighter_first_name,
f1.last_name AS fighter_last_name,
f2.first_name AS vs_fighter_first_name,
f2.last_name AS vs_fighter_last_name,
f1.id AS fighter_id,
f2.id AS vs_fighter_id,
f1.career_record AS fighter_career_record,
f2.career_record AS vs_fighter_career_record,
fr1.season_record AS fighter_season_record,
fr2.season_record AS vs_fighter_season_record,
f1.nation_flag AS fighter_nation_flag,
f2.nation_flag AS vs_fighter_nation_flag,
f1.challenger_highlights AS challenger_highlights,
f2.challenger_highlights AS vs_challenger_highlights,
fr1.ranking AS fighter_ranking,
fr2.ranking AS vs_fighter_ranking,
fc2.name AS weightclass,
fc2.shortcode AS weightclass_shortcode,
IF(fc.fighter_record<>'', fc.fighter_record, fr1.season_record) AS fighter_fight_card_record,
IF(fc.vs_fighter_record<>'', fc.vs_fighter_record, fr2.season_record) AS vs_fighter_fight_card_record,
b.name AS broadcast_name,
b.url AS broadcast_url,
fc.match_type,
IF(
IFNULL(m1.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m1.directory, '/', m1.filename, '.', m1.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f1.gender, '.png')
) AS fighter_thumbnail,
IF(
IFNULL(m2.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m2.directory, '/', m2.filename, '.', m2.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f1.gender, '.png')
) AS fighter_profile_image,
IF(
IFNULL(m3.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m3.directory, '/', m3.filename, '.', m3.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f2.gender, '.png')
) AS vs_fighter_thumbnail,
IF(
IFNULL(m4.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m4.directory, '/', m4.filename, '.', m4.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f2.gender, '.png')
) AS vs_fighter_profile_image,
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m5.directory, '/', m5.filename, '.', m5.extension) AS broadcast_logo,
IF(
IFNULL(m6.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m6.directory, '/', m6.filename, '.', m6.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f1.gender, '-left.png')
) AS fighter_bodyshot_side,
IF(
IFNULL(m7.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m7.directory, '/', m7.filename, '.', m7.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f2.gender, '-right.png')
) AS vs_fighter_bodyshot_side,
IF(
IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f1.nation_flag, '.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg')
) AS fighter_flag,
IF(
IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f2.nation_flag, '.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg')
) AS vs_fighter_flag,
IF(
IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f1.nation_flag, '_BACKDROP.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg')
) AS fighter_flag_backdrop,
IF(
IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f2.nation_flag, '_BACKDROP.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg')
) AS vs_fighter_flag_backdrop
FROM
fight_cards fc
LEFT JOIN
fighters f1
ON
f1.id = fc.fighter_id
LEFT JOIN
fighters f2
ON
f2.id = fc.vs_fighter_id
INNER JOIN
fighter_classes fc2
ON
fc2.id = fc.fighter_class_id
INNER JOIN
events e
ON
e.id = fc.event_id
LEFT JOIN
seasons s
ON
e.season_id = s.id
LEFT JOIN
broadcasters b
ON
b.shortcode = fc.broadcaster
LEFT JOIN
fighter_records fr1
ON
fr1.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 6
AND
fighter_id = fc.fighter_id
LIMIT 1
)
AND
fr1.season_id = 6
LEFT JOIN
fighter_records fr2
ON
fr2.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 6
AND
fighter_id = fc.vs_fighter_id
LIMIT 1
)
AND
fr2.season_id = 6
LEFT JOIN
mediables med1
ON
med1.mediable_id=f1.id
AND
med1.tag='headshot'
AND
med1.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m1
ON
m1.id=med1.media_id
LEFT JOIN
mediables med2
ON
med2.mediable_id=f1.id
AND
med2.tag='bodyshot'
AND
med2.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m2
ON
m2.id=med2.media_id
LEFT JOIN
mediables med3
ON
med3.mediable_id=f2.id
AND
med3.tag='headshot'
AND
med3.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m3
ON
m3.id=med3.media_id
LEFT JOIN
mediables med4
ON
med4.mediable_id=f2.id
AND
med4.tag='bodyshot'
AND
med4.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m4
ON
m4.id=med4.media_id
LEFT JOIN
mediables med5
ON
med5.mediable_id=b.id
AND
med5.tag='logo'
AND
med5.mediable_type='App\\Models\\Broadcaster'
LEFT JOIN
media m5
ON
m5.id=med5.media_id
LEFT JOIN
mediables med6
ON
med6.mediable_id=fc.id
AND
med6.tag='fighter_bodyshot_side_left'
AND
med6.mediable_type='App\\Models\\FightCard'
LEFT JOIN
media m6
ON
m6.id=med6.media_id
LEFT JOIN
mediables med7
ON
med7.mediable_id=fc.id
AND
med7.tag='fighter_bodyshot_side_right'
AND
med7.mediable_type='App\\Models\\FightCard'
LEFT JOIN
media m7
ON
m7.id=med7.media_id
WHERE
e.slug = '2022-pfl-8'
AND (fc.fighter_id=420 OR fc.vs_fighter_id=420)
ORDER BY
fc.order_number ASC

Backtrace

app/Http/Controllers/FightCardController.php:450
app/Http/Controllers/FighterController.php:436
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

WidgetController.php#464devpflmma_web800μsselect * from `fighters` where `fighters`.`id` = 420 limit 1

Bindings	0: 420
Backtrace	app/Http/Controllers/WidgetController.php:464 app/Http/Controllers/FighterController.php:447 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

WidgetController.php#471devpflmma_web1.53ms

select `articles`.*, `article_tags`.`article_tag_id` as `pivot_article_tag_id`, `article_tags`.`article_id` as `pivot_article_id`, `article_tags`.`article_tag_type` as `pivot_article_tag_type` from `articles` inner join `article_tags` on `articles`.`id` = `article_tags`.`article_id` where `article_tags`.`article_tag_id` = 420 and `article_tags`.`article_tag_type` = 'App\\Models\\Fighter' order by `created_at` desc

Bindings	0: 420 1: App\Models\Fighter
Backtrace	app/Http/Controllers/WidgetController.php:471 app/Http/Controllers/FighterController.php:447 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

Mediable.php#385devpflmma_web1.34ms

select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 1579 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc

Bindings	0: 1579 1: App\Models\Article
Backtrace	vendor/plank/laravel-mediable/src/Mediable.php:385 vendor/plank/laravel-mediable/src/Mediable.php:427 app/Http/Controllers/WidgetController.php:475 app/Http/Controllers/FighterController.php:447 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

Mediable.php#385devpflmma_web1.07ms

select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 1565 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc

Bindings	0: 1565 1: App\Models\Article
Backtrace	vendor/plank/laravel-mediable/src/Mediable.php:385 vendor/plank/laravel-mediable/src/Mediable.php:427 app/Http/Controllers/WidgetController.php:475 app/Http/Controllers/FighterController.php:447 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

Mediable.php#385devpflmma_web1.36ms

select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 1500 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc

Bindings	0: 1500 1: App\Models\Article
Backtrace	vendor/plank/laravel-mediable/src/Mediable.php:385 vendor/plank/laravel-mediable/src/Mediable.php:427 app/Http/Controllers/WidgetController.php:475 app/Http/Controllers/FighterController.php:447 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

Mediable.php#385devpflmma_web1.09ms

select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 1423 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc

Bindings	0: 1423 1: App\Models\Article
Backtrace	vendor/plank/laravel-mediable/src/Mediable.php:385 vendor/plank/laravel-mediable/src/Mediable.php:427 app/Http/Controllers/WidgetController.php:475 app/Http/Controllers/FighterController.php:447 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

Mediable.php#385devpflmma_web1.13ms

select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 1338 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc

Bindings	0: 1338 1: App\Models\Article
Backtrace	vendor/plank/laravel-mediable/src/Mediable.php:385 vendor/plank/laravel-mediable/src/Mediable.php:427 app/Http/Controllers/WidgetController.php:475 app/Http/Controllers/FighterController.php:447 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

Mediable.php#385devpflmma_web1.44ms

select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 1336 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc

Bindings	0: 1336 1: App\Models\Article
Backtrace	vendor/plank/laravel-mediable/src/Mediable.php:385 vendor/plank/laravel-mediable/src/Mediable.php:427 app/Http/Controllers/WidgetController.php:475 app/Http/Controllers/FighterController.php:447 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

Mediable.php#385devpflmma_web1.1ms

select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 1320 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc

Bindings	0: 1320 1: App\Models\Article
Backtrace	vendor/plank/laravel-mediable/src/Mediable.php:385 vendor/plank/laravel-mediable/src/Mediable.php:427 app/Http/Controllers/WidgetController.php:475 app/Http/Controllers/FighterController.php:447 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

WidgetController.php#500devpflmma_web1.03msselect * from `fighters` where `fighters`.`id` = 420 limit 1

Bindings	0: 420
Backtrace	app/Http/Controllers/WidgetController.php:500 app/Http/Controllers/FighterController.php:448 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

WidgetController.php#507devpflmma_web1.52ms

select `videos`.*, `video_tags`.`video_tag_id` as `pivot_video_tag_id`, `video_tags`.`video_id` as `pivot_video_id`, `video_tags`.`video_tag_type` as `pivot_video_tag_type` from `videos` inner join `video_tags` on `videos`.`id` = `video_tags`.`video_id` where `video_tags`.`video_tag_id` = 420 and `video_tags`.`video_tag_type` = 'App\\Models\\Fighter' order by `created_at` desc

Bindings	0: 420 1: App\Models\Fighter
Backtrace	app/Http/Controllers/WidgetController.php:507 app/Http/Controllers/FighterController.php:448 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259

Mediable.php#385devpflmma_web1.15ms

select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 1112 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc

Bindings	0: 1112 1: App\Models\Video
Backtrace	vendor/plank/laravel-mediable/src/Mediable.php:385 vendor/plank/laravel-mediable/src/Mediable.php:427 app/Http/Controllers/WidgetController.php:511 app/Http/Controllers/FighterController.php:448 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

Mediable.php#385devpflmma_web1.32ms

select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 1111 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc

Bindings	0: 1111 1: App\Models\Video
Backtrace	vendor/plank/laravel-mediable/src/Mediable.php:385 vendor/plank/laravel-mediable/src/Mediable.php:427 app/Http/Controllers/WidgetController.php:511 app/Http/Controllers/FighterController.php:448 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

FighterController.php#451devpflmma_web1.05msselect * from `seasons` where `season_type` = 'regular' order by `year` desc limit 1

Bindings	0: regular
Backtrace	app/Http/Controllers/FighterController.php:451 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:259 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

FighterController.php#459devpflmma_web1.5ms

SELECT
e.*
FROM
fight_cards fc
LEFT JOIN
fighters f1
ON
f1.id = fc.fighter_id
LEFT JOIN
fighters f2
ON
f2.id = fc.vs_fighter_id
INNER JOIN
fighter_classes fc2
ON
fc2.id = fc.fighter_class_id
INNER JOIN
events e
ON
e.id = fc.event_id
LEFT JOIN
fighter_records fr1
ON
fr1.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 16
AND
fighter_id = fc.fighter_id
LIMIT 1
)
AND
fr1.season_id = 16
LEFT JOIN
fighter_records fr2
ON
fr2.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 16
AND
fighter_id = fc.vs_fighter_id
LIMIT 1
)
AND
fr2.season_id = 16
WHERE
e.season_id=16
AND (fc.fighter_id=420 OR fc.vs_fighter_id=420)
AND
e.datetime>='2025-04-25 02:42:35'
AND
e.event_status = 'scheduled'
ORDER BY
fc.order_number ASC

Backtrace

app/Http/Controllers/FighterController.php:459
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

show.blade.php#121devpflmma_web1.04msselect * from `seasons` where `seasons`.`id` = 8 limit 1

Bindings	0: 8
Backtrace	view::fighters.show:121 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:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

show.blade.php#200devpflmma_web1.15msselect * from `seasons` where `seasons`.`id` = 8 limit 1

Bindings	0: 8
Backtrace	view::fighters.show:200 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:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

SettingEloquentStorage.php#30devpflmma_web1.99msselect `val`, `name` from `settings` where `group` = 'default'

Bindings	0: default
Backtrace	vendor/qcod/laravel-settings/src/Setting/SettingEloquentStorage.php:30 view::components.countdown-timer:23 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:72

SettingEloquentStorage.php#30devpflmma_web1.12msselect `val`, `name` from `settings` where `group` = 'default'

Bindings	0: default
Backtrace	vendor/qcod/laravel-settings/src/Setting/SettingEloquentStorage.php:30 view::components.countdown-timer:24 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:72

SettingEloquentStorage.php#30devpflmma_web1.14msselect `val`, `name` from `settings` where `group` = 'default'

Bindings	0: default
Backtrace	vendor/qcod/laravel-settings/src/Setting/SettingEloquentStorage.php:30 view::components.countdown-timer:25 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:72

SettingEloquentStorage.php#30devpflmma_web1.23msselect `val`, `name` from `settings` where `group` = 'default'

Bindings	0: default
Backtrace	vendor/qcod/laravel-settings/src/Setting/SettingEloquentStorage.php:30 app/Helpers/Functions.php:470 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:72

Functions.php#473devpflmma_web1.24msselect * from `media` where `media`.`id` = '26718' limit 1

Bindings	0: 26718
Backtrace	app/Helpers/Functions.php:473 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:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

Functions.php#482devpflmma_web960μsselect * from `media` where `media`.`id` = '24074' limit 1

Bindings	0: 24074
Backtrace	app/Helpers/Functions.php:482 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:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

Functions.php#488devpflmma_web840μsselect * from `media` where `media`.`id` = '24072' limit 1

Bindings	0: 24072
Backtrace	app/Helpers/Functions.php:488 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:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

Functions.php#494devpflmma_web1.03msselect * from `media` where `media`.`id` = '24075' limit 1

Bindings	0: 24075
Backtrace	app/Helpers/Functions.php:494 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:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

Functions.php#518devpflmma_web810μsselect * from `media` where `media`.`id` = '27787' limit 1

Bindings	0: 27787
Backtrace	app/Helpers/Functions.php:518 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:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

Functions.php#524devpflmma_web750μsselect * from `media` where `media`.`id` = '23575' limit 1

Bindings	0: 23575
Backtrace	app/Helpers/Functions.php:524 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:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

Functions.php#530devpflmma_web930μsselect * from `media` where `media`.`id` = '23576' limit 1

Bindings	0: 23576
Backtrace	app/Helpers/Functions.php:530 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:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

Functions.php#536devpflmma_web900μsselect * from `media` where `media`.`id` = '27603' limit 1

Bindings	0: 27603
Backtrace	app/Helpers/Functions.php:536 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:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

Functions.php#542devpflmma_web1.1msselect * from `media` where `media`.`id` = '27604' limit 1

Bindings	0: 27604
Backtrace	app/Helpers/Functions.php:542 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:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

Functions.php#548devpflmma_web750μsselect * from `media` where `media`.`id` = '27605' limit 1

Bindings	0: 27605
Backtrace	app/Helpers/Functions.php:548 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:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

Functions.php#554devpflmma_web1.12msselect * from `media` where `media`.`id` = '27606' limit 1

Bindings	0: 27606
Backtrace	app/Helpers/Functions.php:554 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:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

Functions.php#560devpflmma_web750μsselect * from `media` where `media`.`id` = '26409' limit 1

Bindings	0: 26409
Backtrace	app/Helpers/Functions.php:560 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:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

Functions.php#566devpflmma_web770μsselect * from `media` where `media`.`id` = '26408' limit 1

Bindings	0: 26408
Backtrace	app/Helpers/Functions.php:566 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:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

Functions.php#572devpflmma_web810μsselect * from `media` where `media`.`id` = '26407' limit 1

Bindings	0: 26407
Backtrace	app/Helpers/Functions.php:572 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:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

Functions.php#578devpflmma_web810μsselect * from `media` where `media`.`id` = '26540' limit 1

Bindings	0: 26540
Backtrace	app/Helpers/Functions.php:578 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:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

Plank\Mediable\Media: 46Media.php#?
App\Models\Season: 18Season.php#?
App\Models\Fighter: 9Fighter.php#?
App\Models\Article: 7Article.php#?
App\Models\FighterRecord: 4FighterRecord.php#?
App\Models\FightCard: 3FightCard.php#?
App\Models\Event: 3Event.php#?
App\Models\Video: 2Video.php#?

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-25 02:42:35	GET	/regular-fighter/francesco-nuzzi	14 90 92

First Round - Lightweights and Middleweights

"BERSERKER"

Fighter Details

PFL Records

Career Fight Record

Career Notes

Fight Results

News

OFFICIAL 2022 PFL PLAYOFFS CARDIFF WEIGH-IN RESULTS

2022 PFL PLAYOFFS CONTINUE WITH A PAIR OF CHANGES TO SATURDAY’S 13-BOUT CARD

PROFESSIONAL FIGHTERS LEAGUE CONTINUES GLOBAL EXPANSION WITH LAUNCH OF PFL EUROPE, NEW INTERNATIONAL...

PFL EUROPE ANNOUNCES HUGE CARD FOR PLAYOFFS IN PARIS LIVE ON DAZN

Francesco Nuzzi blasts his way into bantamweight PFL Europe Playoffs with devastating first-round he...

PROFESSIONAL FIGHTERS LEAGUE ANNOUNCES STACKED FULL CARD FOR PFL EUROPE 2 AHEAD OF A HUGE NIGHT OF M...

PROFESSIONAL FIGHTERS LEAGUE ANNOUNCES 2023 PFL EUROPE SEASON ROSTER

OFFICIAL 2022 PFL PLAYOFFS CARDIFF WEIGH-IN RESULTS

2022 PFL PLAYOFFS CONTINUE WITH A PAIR OF CHANGES TO SATURDAY’S 13-BOUT CARD

PROFESSIONAL FIGHTERS LEAGUE CONTINUES GLOBAL EXPANSION WITH LAUNCH OF PFL EUROPE, NEW INTERNATIONAL...

PFL EUROPE ANNOUNCES HUGE CARD FOR PLAYOFFS IN PARIS LIVE ON DAZN

Francesco Nuzzi blasts his way into bantamweight PFL Europe Playoffs with devastating first-round he...

PROFESSIONAL FIGHTERS LEAGUE ANNOUNCES STACKED FULL CARD FOR PFL EUROPE 2 AHEAD OF A HUGE NIGHT OF M...

PROFESSIONAL FIGHTERS LEAGUE ANNOUNCES 2023 PFL EUROPE SEASON ROSTER

OFFICIAL 2022 PFL PLAYOFFS CARDIFF WEIGH-IN RESULTS

2022 PFL PLAYOFFS CONTINUE WITH A PAIR OF CHANGES TO SATURDAY’S 13-BOUT CARD

PROFESSIONAL FIGHTERS LEAGUE CONTINUES GLOBAL EXPANSION WITH LAUNCH OF PFL EUROPE, NEW INTERNATIONAL...

Videos

PFL Europe: Berlin | Full Fight Highlights

Bantamweights & Lightweights Face Off ahead of PFL Paris Playoffs!

1 x Application (93.49%)	204ms
1 x Preparing Response (22.17%)	48.38ms
1 x Booting (6.5%)	14.19ms
1 x Routing (0.61%)	1.32ms
14 x View (0%)	0μs