Don Madge

Messages Request Timeline Exceptions Views14 Queries127 Models130 Mails Gate

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

status

200 OK

full_url

https://dev.pflmma.com/regular-fighter/don-madge

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:264-533

middleware

web

duration

403ms

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 => "Thu, 03 Apr 2025 18:32:20 GMT"
  ]
]

session_attributes

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

Booting (14.3ms)time
Application (377ms)time
Routing (1.3ms)
View: components.widgets.articleviews
View: components.widgets.videoviews
Preparing Response (48.47ms)
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 (96.34%)
377ms
1 x Preparing Response (12.39%)
48.47ms
1 x Booting (3.65%)
14.30ms
1 x Routing (0.33%)
1.30ms
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

127 statements were executed (62 duplicates)Show only duplicates devpflmma_web278ms

# Query soft limit for Debugbar is reached after 100 queries, additional 27 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)

FighterController.php#1187devpflmma_webConnection Established

Backtrace

app/Http/Controllers/FighterController.php:1187
app/Http/Controllers/FighterController.php:284
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#1190devpflmma_web3.64ms

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

Backtrace

app/Http/Controllers/FighterController.php:1190
app/Http/Controllers/FighterController.php:284
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#309devpflmma_web1.35ms

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

Bindings	0: 315 1: 2020
Backtrace	app/Http/Controllers/FighterController.php:309 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#311devpflmma_web900μsselect * from `seasons` where `seasons`.`id` = 16 limit 1

Bindings	0: 16
Backtrace	app/Http/Controllers/FighterController.php:311 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#320devpflmma_web1.29ms

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

Bindings	0: 315 1: 2020
Backtrace	app/Http/Controllers/FighterController.php:320 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#332devpflmma_web1.32ms

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

Bindings	0: 315 1: 2024
Backtrace	app/Http/Controllers/FighterController.php:332 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.33ms

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

Bindings	0: 315 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_web690μsselect * from `seasons` where `seasons`.`id` = 16 limit 1

Bindings	0: 16
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.67ms

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

Bindings	0: 315 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_web1.08ms

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

Bindings	0: 315 1: 2024
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_web1.03msselect * from `seasons` where `year` = 2024 limit 1

Bindings	0: 2024
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_web970μsselect * from `fighter_records` where `fighter_id` = 315 and `season_id` = 10 limit 1

Bindings	0: 315 1: 10
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_web880μsselect * from `seasons` where `year` = 2024 limit 1

Bindings	0: 2024
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_web1.23ms

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 = '10'
WHERE
1=1
AND fs.season_year = '2024' AND f.id='315'

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_web690μsselect * from `seasons` where `year` = 2024 limit 1

Bindings	0: 2024
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_web860μs

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 = '10'
WHERE
1=1
AND fs.season_year = '2024' AND f.id='315'

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_web1.71msselect * from `seasons` where `year` = 2024 limit 1

Bindings	0: 2024
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_web850μ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 = '10'
WHERE
1=1
AND fs.season_year = '2024' AND f.id='315'

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_web750μsselect * from `seasons` where `year` = 2024 limit 1

Bindings	0: 2024
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_web5.59ms

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 = '10'
WHERE
1=1
AND fs.season_year = '2024' AND f.id='315'

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_web2.99msselect * from `seasons` where `year` = 2024 limit 1

Bindings	0: 2024
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_web1.42ms

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 = '10'
WHERE
1=1
AND fs.season_year = '2024' AND f.id='315'

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_web2.44msselect * from `seasons` where `year` = 2024 limit 1

Bindings	0: 2024
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_web4.55ms

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 = '10'
WHERE
1=1
AND fs.season_year = '2024' AND f.id='315'

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_web730μsselect * from `seasons` where `year` = 2024 limit 1

Bindings	0: 2024
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_web800μs

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 = '10'
WHERE
1=1
AND fs.season_year = '2024' AND f.id='315'

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_web980μsselect * from `seasons` where `year` = 2024 limit 1

Bindings	0: 2024
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_web2.44ms

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 = '10'
WHERE
1=1
AND fs.season_year = '2024' AND f.id='315'

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_web690μsselect * from `seasons` where `year` = 2024 limit 1

Bindings	0: 2024
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_web20.23ms

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=10
LEFT JOIN
fighter_classes fc
ON
fc.id = fr.fighter_class_id
WHERE
1=1
AND fs.season_year = '2024'
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.58msselect * from `fighters` where `fighters`.`id` = 844 limit 1

Bindings	0: 844
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.46ms

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` = 844 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc

Bindings	0: 844 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.36msselect * from `fighters` where `fighters`.`id` = 842 limit 1

Bindings	0: 842
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.23ms

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` = 842 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc

Bindings	0: 842 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.14msselect * from `fighters` where `fighters`.`id` = 690 limit 1

Bindings	0: 690
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.65ms

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` = 690 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc

Bindings	0: 690 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_web830μsselect * from `fighters` where `fighters`.`id` = 698 limit 1

Bindings	0: 698
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_web960μs

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` = 698 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc

Bindings	0: 698 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_web6.88msselect * from `fighters` where `fighters`.`id` = 691 limit 1

Bindings	0: 691
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.21ms

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` = 691 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc

Bindings	0: 691 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#397devpflmma_web830μsselect * from `seasons` where `year` = 2022 limit 1

Bindings	0: 2022
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_web890μsselect * from `fighter_records` where `fighter_id` = 315 and `season_id` = 5 limit 1

Bindings	0: 315 1: 5
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_web760μsselect * from `seasons` where `year` = 2022 limit 1

Bindings	0: 2022
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_web1.12ms

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 = '5'
WHERE
1=1
AND fs.season_year = '2022' AND f.id='315'

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_web780μsselect * from `seasons` where `year` = 2022 limit 1

Bindings	0: 2022
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.3ms

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 = '5'
WHERE
1=1
AND fs.season_year = '2022' AND f.id='315'

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_web770μsselect * from `seasons` where `year` = 2022 limit 1

Bindings	0: 2022
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_web960μ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 = '5'
WHERE
1=1
AND fs.season_year = '2022' AND f.id='315'

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_web750μsselect * from `seasons` where `year` = 2022 limit 1

Bindings	0: 2022
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.63ms

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 = '5'
WHERE
1=1
AND fs.season_year = '2022' AND f.id='315'

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_web840μsselect * from `seasons` where `year` = 2022 limit 1

Bindings	0: 2022
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_web900μ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 = '5'
WHERE
1=1
AND fs.season_year = '2022' AND f.id='315'

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_web690μsselect * from `seasons` where `year` = 2022 limit 1

Bindings	0: 2022
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_web930μs

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 = '5'
WHERE
1=1
AND fs.season_year = '2022' AND f.id='315'

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_web630μsselect * from `seasons` where `year` = 2022 limit 1

Bindings	0: 2022
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_web960μs

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 = '5'
WHERE
1=1
AND fs.season_year = '2022' AND f.id='315'

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_web610μsselect * from `seasons` where `year` = 2022 limit 1

Bindings	0: 2022
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_web930μs

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 = '5'
WHERE
1=1
AND fs.season_year = '2022' AND f.id='315'

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_web650μsselect * from `seasons` where `year` = 2022 limit 1

Bindings	0: 2022
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_web11.39ms

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=5
LEFT JOIN
fighter_classes fc
ON
fc.id = fr.fighter_class_id
WHERE
1=1
AND fs.season_year = '2022'
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_web1msselect * from `fighters` where `fighters`.`id` = 233 limit 1

Bindings	0: 233
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_web940μs

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` = 233 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc

Bindings	0: 233 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_web760μsselect * from `fighters` where `fighters`.`id` = 389 limit 1

Bindings	0: 389
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` = 389 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc

Bindings	0: 389 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_web8.29msselect * from `fighters` where `fighters`.`id` = 22 limit 1

Bindings	0: 22
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_web960μs

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` = 22 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc

Bindings	0: 22 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` = 385 limit 1

Bindings	0: 385
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.29ms

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` = 385 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc

Bindings	0: 385 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.02msselect * from `fighters` where `fighters`.`id` = 330 limit 1

Bindings	0: 330
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.02ms

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` = 330 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc

Bindings	0: 330 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#423devpflmma_web4.91ms

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` = 16 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` = 315 limit 1

Bindings	0: 16 1: headshot 2: App\Models\Fighter 3: bodyshot 4: App\Models\Fighter 5: banner 6: App\Models\Fighter 7: 315
Backtrace	app/Http/Controllers/FighterController.php:423 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#425devpflmma_web1.57msselect * from `fighters` where `fighters`.`id` = 315 limit 1

Bindings	0: 315
Backtrace	app/Http/Controllers/FighterController.php:425 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#426devpflmma_web5.34ms

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

Bindings	0: 315 1: 315
Backtrace	app/Http/Controllers/FighterController.php:426 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_web2.4msselect `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:430 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

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

Bindings	0: 93
Backtrace	app/Http/Controllers/FightCardController.php:436 app/Http/Controllers/FighterController.php:430 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_web1.78msselect * from `seasons` where `seasons`.`id` = 16 limit 1

Bindings	0: 16
Backtrace	app/Http/Controllers/FightCardController.php:440 app/Http/Controllers/FighterController.php:430 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_web17.3ms

SELECT
e.datetime AS event_datetime,
2024 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 = 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
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 = '2024-pfl-6'
AND (fc.fighter_id=315 OR fc.vs_fighter_id=315)
ORDER BY
fc.order_number ASC

Backtrace

app/Http/Controllers/FightCardController.php:450
app/Http/Controllers/FighterController.php:430
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_web4.88msselect `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:430 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

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

Bindings	0: 81
Backtrace	app/Http/Controllers/FightCardController.php:436 app/Http/Controllers/FighterController.php:430 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_web630μsselect * from `seasons` where `seasons`.`id` = 16 limit 1

Bindings	0: 16
Backtrace	app/Http/Controllers/FightCardController.php:440 app/Http/Controllers/FighterController.php:430 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_web6.11ms

SELECT
e.datetime AS event_datetime,
2024 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 = 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
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 = '2024-pfl-3'
AND (fc.fighter_id=315 OR fc.vs_fighter_id=315)
ORDER BY
fc.order_number ASC

Backtrace

app/Http/Controllers/FightCardController.php:450
app/Http/Controllers/FighterController.php:430
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_web4.46msselect `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:430 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

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

Bindings	0: 43
Backtrace	app/Http/Controllers/FightCardController.php:436 app/Http/Controllers/FighterController.php:430 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_web900μsselect * from `seasons` where `seasons`.`id` = 6 limit 1

Bindings	0: 6
Backtrace	app/Http/Controllers/FightCardController.php:440 app/Http/Controllers/FighterController.php:430 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_web11.85ms

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-1'
AND (fc.fighter_id=315 OR fc.vs_fighter_id=315)
ORDER BY
fc.order_number ASC

Backtrace

app/Http/Controllers/FightCardController.php:450
app/Http/Controllers/FighterController.php:430
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_web2.36msselect `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:430 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

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

Bindings	0: 34
Backtrace	app/Http/Controllers/FightCardController.php:436 app/Http/Controllers/FighterController.php:430 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_web840μsselect * from `seasons` where `seasons`.`id` = 4 limit 1

Bindings	0: 4
Backtrace	app/Http/Controllers/FightCardController.php:440 app/Http/Controllers/FighterController.php:430 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_web17.62ms

SELECT
e.datetime AS event_datetime,
2021 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 = 4
AND
fighter_id = fc.fighter_id
LIMIT 1
)
AND
fr1.season_id = 4
LEFT JOIN
fighter_records fr2
ON
fr2.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 4
AND
fighter_id = fc.vs_fighter_id
LIMIT 1
)
AND
fr2.season_id = 4
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 = '2021-pfl-10'
AND (fc.fighter_id=315 OR fc.vs_fighter_id=315)
ORDER BY
fc.order_number ASC

Backtrace

app/Http/Controllers/FightCardController.php:450
app/Http/Controllers/FighterController.php:430
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_web3.19msselect * from `fighters` where `fighters`.`id` = 315 limit 1

Bindings	0: 315
Backtrace	app/Http/Controllers/WidgetController.php:464 app/Http/Controllers/FighterController.php:441 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_web5.96ms

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` = 315 and `article_tags`.`article_tag_type` = 'App\\Models\\Fighter' order by `created_at` desc

Bindings	0: 315 1: App\Models\Fighter
Backtrace	app/Http/Controllers/WidgetController.php:471 app/Http/Controllers/FighterController.php:441 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_web2.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` = 1764 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc

Bindings	0: 1764 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:441 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

Mediable.php#385devpflmma_web2.47ms

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` = 1746 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc

Bindings	0: 1746 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:441 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

Mediable.php#385devpflmma_web1.12ms

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` = 1445 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc

Bindings	0: 1445 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:441 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

Mediable.php#385devpflmma_web2.94ms

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` = 1233 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc

Bindings	0: 1233 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:441 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

Mediable.php#385devpflmma_web1.03ms

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` = 1228 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc

Bindings	0: 1228 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:441 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

WidgetController.php#500devpflmma_web850μsselect * from `fighters` where `fighters`.`id` = 315 limit 1

Bindings	0: 315
Backtrace	app/Http/Controllers/WidgetController.php:500 app/Http/Controllers/FighterController.php:442 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.86ms

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` = 315 and `video_tags`.`video_tag_type` = 'App\\Models\\Fighter' order by `created_at` desc

Bindings	0: 315 1: App\Models\Fighter
Backtrace	app/Http/Controllers/WidgetController.php:507 app/Http/Controllers/FighterController.php:442 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.24ms

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` = 1353 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc

Bindings	0: 1353 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:442 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

Mediable.php#385devpflmma_web820μs

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` = 1352 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc

Bindings	0: 1352 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:442 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

Mediable.php#385devpflmma_web3.2ms

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` = 1314 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc

Bindings	0: 1314 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:442 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

devpflmma_web1.37msselect `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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
devpflmma_web880μsselect `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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
devpflmma_web940μsselect `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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
devpflmma_web2.11msselect * from `seasons` where `season_type` = ? order by `year` desc limit 1
devpflmma_web4.29msSELECT 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=315 OR fc.vs_fighter_id=315) AND e.datetime>='2025-04-03 14:32:20' AND e.event_status = 'scheduled' ORDER BY fc.order_number ASC
devpflmma_web760μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web910μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web670μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web1.33msselect `val`, `name` from `settings` where `group` = ?
devpflmma_web2.77msselect `val`, `name` from `settings` where `group` = ?
devpflmma_web830μsselect `val`, `name` from `settings` where `group` = ?
devpflmma_web1.4msselect `val`, `name` from `settings` where `group` = ?
devpflmma_web640μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web780μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web940μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web1.7msselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web830μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web1.64msselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web770μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web1.26msselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web790μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web640μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web680μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web740μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web880μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web740μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web720μsselect * from `media` where `media`.`id` = ? limit 1

Plank\Mediable\Media: 61Media.php#?
App\Models\Season: 30Season.php#?
App\Models\Fighter: 14Fighter.php#?
App\Models\FighterRecord: 6FighterRecord.php#?
App\Models\Video: 6Video.php#?
App\Models\Article: 5Article.php#?
App\Models\FightCard: 4FightCard.php#?
App\Models\Event: 4Event.php#?

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-03 14:32:20	GET	/regular-fighter/don-madge	14 127 130

Fighter Details

PFL Records

Career Fight Record

Career Notes

Fight Results

News

PROFESSIONAL FIGHTERS LEAGUE ANNOUNCES FULL CARD FOR PFL 3: WELTERWEIGHTS AND LIGHTWEIGHTS APRIL 14...

OFFICIAL WEIGH-IN RESULTS FOR PFL 1, 2022

PFL MMA BOLSTERS EXPANSION TO KEY GLOBAL MARKETS WITH BROADCAST AGREEMENT WITH ESPN AFRICA FOR 2022...

PROFESSIONAL FIGHTERS LEAGUE MAKES SOUTH DAKOTA DEBUT JUNE 28 WITH 2024 PFL GLOBAL SEASON ACTION

Magic Man: Don Madge pulls a quick submission out of the hat for six

PROFESSIONAL FIGHTERS LEAGUE ANNOUNCES FULL CARD FOR PFL 3: WELTERWEIGHTS AND LIGHTWEIGHTS APRIL 14...

OFFICIAL WEIGH-IN RESULTS FOR PFL 1, 2022

PFL MMA BOLSTERS EXPANSION TO KEY GLOBAL MARKETS WITH BROADCAST AGREEMENT WITH ESPN AFRICA FOR 2022...

PROFESSIONAL FIGHTERS LEAGUE MAKES SOUTH DAKOTA DEBUT JUNE 28 WITH 2024 PFL GLOBAL SEASON ACTION

Magic Man: Don Madge pulls a quick submission out of the hat for six

PROFESSIONAL FIGHTERS LEAGUE ANNOUNCES FULL CARD FOR PFL 3: WELTERWEIGHTS AND LIGHTWEIGHTS APRIL 14...

OFFICIAL WEIGH-IN RESULTS FOR PFL 1, 2022

PFL MMA BOLSTERS EXPANSION TO KEY GLOBAL MARKETS WITH BROADCAST AGREEMENT WITH ESPN AFRICA FOR 2022...

Videos

Full Fight Highlights from PFL 3, 2024!

Don Madge Post-Fight Interview | 2024 PFL Regular Season

PFL Fight Week | Chicago: VLOG Series | Episode 14 (Final Media & Weight Cut)

Weight Cuts Begin | PFL 6, 2024 Fight Week: VLOG Series | Ep. 14

Don Madge & Neiman Gracie Break Down Each Other's Previous Fight | TALKIN SH*T

ALL Submissions of 1st Half | 2024 PFL Regular Season

Full Fight Highlights from PFL 3, 2024!

Don Madge Post-Fight Interview | 2024 PFL Regular Season

PFL Fight Week | Chicago: VLOG Series | Episode 14 (Final Media & Weight Cut)

Weight Cuts Begin | PFL 6, 2024 Fight Week: VLOG Series | Ep. 14

Don Madge & Neiman Gracie Break Down Each Other's Previous Fight | TALKIN SH*T

ALL Submissions of 1st Half | 2024 PFL Regular Season

Full Fight Highlights from PFL 3, 2024!

Don Madge Post-Fight Interview | 2024 PFL Regular Season

PFL Fight Week | Chicago: VLOG Series | Episode 14 (Final Media & Weight Cut)

1 x Application (96.34%)	377ms
1 x Preparing Response (12.39%)	48.47ms
1 x Booting (3.65%)	14.30ms
1 x Routing (0.33%)	1.30ms
14 x View (0%)	0μs