Carlos Leal

Messages Request Timeline Exceptions Views14 Queries182 Models205 Mails Gate

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

status

200 OK

full_url

https://dev.pflmma.com/regular-fighter/carlos-leal

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

456ms

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 => "Sat, 05 Apr 2025 04:29:56 GMT"
  ]
]

session_attributes

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

Booting (20.79ms)time
Application (417ms)time
Routing (2.39ms)
View: components.widgets.articleviews
View: components.widgets.videoviews
Preparing Response (40.17ms)
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 (95.25%)
417ms
1 x Preparing Response (9.17%)
40.17ms
1 x Booting (4.74%)
20.79ms
1 x Routing (0.55%)
2.39ms
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

182 statements were executed (148 duplicates)Show only duplicates devpflmma_web269ms

# Query soft limit for Debugbar is reached after 100 queries, additional 82 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_web4.01ms

select * from `fighters` where LOWER(REPLACE(REPLACE(first_name, " ", ""), "'", "")) = "carlos" and LOWER(REPLACE(REPLACE(last_name, " ", ""), "'", "")) = "leal" 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_web2.83ms

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

Bindings	0: 330 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_web1.01msselect * from `seasons` where `seasons`.`id` = 9 limit 1

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

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

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

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

Bindings	0: 330 1: 2023
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_web2.09ms

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

Bindings	0: 330 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_web1.33msselect * from `seasons` where `seasons`.`id` = 9 limit 1

Bindings	0: 9
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_web2.55ms

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

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

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

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

FighterStatController.php#397devpflmma_web2.35msselect * from `seasons` where `year` = 2023 limit 1

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

FighterStatController.php#398devpflmma_web1.16msselect * from `fighter_records` where `fighter_id` = 330 and `season_id` = 7 limit 1

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

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

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

FighterStatController.php#335devpflmma_web1.64ms

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

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

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

FighterStatController.php#335devpflmma_web1.63ms

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

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.65msselect * from `seasons` where `year` = 2023 limit 1

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

FighterStatController.php#335devpflmma_web2.25ms

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

Backtrace

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

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

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

FighterStatController.php#335devpflmma_web1.31ms

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

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

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

FighterStatController.php#335devpflmma_web3.72ms

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

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_web4.73msselect * from `seasons` where `year` = 2023 limit 1

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

FighterStatController.php#335devpflmma_web9.24ms

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

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

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

FighterStatController.php#335devpflmma_web2.73ms

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

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

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

FighterStatController.php#335devpflmma_web1.23ms

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

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

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

FighterStatController.php#267devpflmma_web18.35ms

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

Backtrace

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

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

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

Mediable.php#385devpflmma_web1.19ms

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

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

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

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

Mediable.php#385devpflmma_web930μ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` = 454 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc

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

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

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

Mediable.php#385devpflmma_web1.15ms

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

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

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

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

Mediable.php#385devpflmma_web950μ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` = 234 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc

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

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

Bindings	0: 353
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.19ms

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

Bindings	0: 353 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_web570μ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_web770μsselect * from `fighter_records` where `fighter_id` = 330 and `season_id` = 5 limit 1

Bindings	0: 330 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_web590μ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.03ms

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='330'

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_web840μ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.04ms

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='330'

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_web640μ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_web830μ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='330'

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_web560μ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_web840μs

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='330'

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_web680μ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_web1.21ms

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='330'

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_web740μ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_web970μ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='330'

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_web570μ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_web890μ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='330'

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_web1.26msselect * 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_web1ms

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='330'

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_web600μ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_web13.09ms

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_web1.01msselect * 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_web1.53ms

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` = 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_web920μ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` = 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

FighterStatController.php#270devpflmma_web990μ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_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` = 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_web640μsselect * 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_web1.11ms

select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 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_web940μ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.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` = 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#397devpflmma_web940μ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_web680μsselect * from `fighter_records` where `fighter_id` = 330 and `season_id` = 5 limit 1

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

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='330'

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_web630μ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.27ms

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='330'

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_web610μ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_web940μs

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

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_web570μ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_web940μs

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='330'

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_web690μ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_web980μ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='330'

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_web590μ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_web840μ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='330'

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_web650μ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_web840μ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='330'

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_web580μ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_web880μ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='330'

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_web800μ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.04ms

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_web710μsselect * 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_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` = 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_web960μsselect * 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.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` = 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

FighterStatController.php#270devpflmma_web660μ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_web990μ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` = 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_web690μsselect * 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_web1.16ms

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_web680μ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_web990μ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` = 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

FighterController.php#423devpflmma_web1.62ms

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` = 9 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` = 330 limit 1

Bindings	0: 9 1: headshot 2: App\Models\Fighter 3: bodyshot 4: App\Models\Fighter 5: banner 6: App\Models\Fighter 7: 330
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

devpflmma_web720μsselect * from `fighters` where `fighters`.`id` = ? limit 1
devpflmma_web2ms(select * from `fight_cards` where `fight_cards`.`fighter_id` = ? and `fight_cards`.`fighter_id` is not null) union (select * from `fight_cards` where `fight_cards`.`vs_fighter_id` = ? and `fight_cards`.`vs_fighter_id` is not null) order by `created_at` desc
devpflmma_web1.02msselect `val`, `name` from `settings` where `group` = ?
devpflmma_web650μsselect * from `events` where `events`.`id` = ? limit 1
devpflmma_web670μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web4.32msSELECT e.datetime AS event_datetime, 2023 AS season_year, s.season_type AS season_type, e.slug AS event_slug, fc.order_number, fc.id AS fight_card_id, fc.broadcaster, fc.winner_id, fc.match_details, fc.show_keys_to_victory, fc.show_match_details, fc.keys_to_victory AS fighter_keys_to_victory, fc.vs_keys_to_victory AS vs_fighter_keys_to_victory, fc.override_status, fc.pickem_status, IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.fighter_points, fr1.points) AS fighter_points, IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.vs_fighter_points, fr2.points) AS vs_fighter_points, fr1.points AS fighter_total_points, fr2.points AS vs_fighter_total_points, f1.gender AS fighter_gender, f2.gender AS vs_fighter_gender, f1.arm_reach AS fighter_arm_reach, f2.arm_reach AS vs_fighter_arm_reach, f1.leg_reach AS fighter_leg_reach, f2.leg_reach AS vs_fighter_leg_reach, f1.height AS fighter_height, f2.height AS vs_fighter_height, f1.weight AS fighter_weight, f2.weight AS vs_fighter_weight, fc.win_by, fc.round_time, CONCAT(f1.first_name, ' ', f1.last_name) AS fighter_name, CONCAT(f2.first_name, ' ', f2.last_name) AS vs_fighter_name, f1.first_name AS fighter_first_name, f1.last_name AS fighter_last_name, f2.first_name AS vs_fighter_first_name, f2.last_name AS vs_fighter_last_name, f1.id AS fighter_id, f2.id AS vs_fighter_id, f1.career_record AS fighter_career_record, f2.career_record AS vs_fighter_career_record, fr1.season_record AS fighter_season_record, fr2.season_record AS vs_fighter_season_record, f1.nation_flag AS fighter_nation_flag, f2.nation_flag AS vs_fighter_nation_flag, f1.challenger_highlights AS challenger_highlights, f2.challenger_highlights AS vs_challenger_highlights, fr1.ranking AS fighter_ranking, fr2.ranking AS vs_fighter_ranking, fc2.name AS weightclass, fc2.shortcode AS weightclass_shortcode, IF(fc.fighter_record<>'', fc.fighter_record, fr1.season_record) AS fighter_fight_card_record, IF(fc.vs_fighter_record<>'', fc.vs_fighter_record, fr2.season_record) AS vs_fighter_fight_card_record, b.name AS broadcast_name, b.url AS broadcast_url, fc.match_type, IF( IFNULL(m1.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m1.directory, '/', m1.filename, '.', m1.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f1.gender, '.png') ) AS fighter_thumbnail, IF( IFNULL(m2.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m2.directory, '/', m2.filename, '.', m2.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f1.gender, '.png') ) AS fighter_profile_image, IF( IFNULL(m3.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m3.directory, '/', m3.filename, '.', m3.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f2.gender, '.png') ) AS vs_fighter_thumbnail, IF( IFNULL(m4.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m4.directory, '/', m4.filename, '.', m4.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f2.gender, '.png') ) AS vs_fighter_profile_image, CONCAT('https://pflmma-dev.s3.amazonaws.com/', m5.directory, '/', m5.filename, '.', m5.extension) AS broadcast_logo, IF( IFNULL(m6.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m6.directory, '/', m6.filename, '.', m6.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f1.gender, '-left.png') ) AS fighter_bodyshot_side, IF( IFNULL(m7.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m7.directory, '/', m7.filename, '.', m7.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f2.gender, '-right.png') ) AS vs_fighter_bodyshot_side, IF( IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f1.nation_flag, '.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg') ) AS fighter_flag, IF( IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f2.nation_flag, '.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg') ) AS vs_fighter_flag, IF( IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f1.nation_flag, '_BACKDROP.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg') ) AS fighter_flag_backdrop, IF( IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f2.nation_flag, '_BACKDROP.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg') ) AS vs_fighter_flag_backdrop FROM fight_cards fc LEFT JOIN fighters f1 ON f1.id = fc.fighter_id LEFT JOIN fighters f2 ON f2.id = fc.vs_fighter_id INNER JOIN fighter_classes fc2 ON fc2.id = fc.fighter_class_id INNER JOIN events e ON e.id = fc.event_id LEFT JOIN seasons s ON e.season_id = s.id LEFT JOIN broadcasters b ON b.shortcode = fc.broadcaster LEFT JOIN fighter_records fr1 ON fr1.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 9 AND fighter_id = fc.fighter_id LIMIT 1 ) AND fr1.season_id = 9 LEFT JOIN fighter_records fr2 ON fr2.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 9 AND fighter_id = fc.vs_fighter_id LIMIT 1 ) AND fr2.season_id = 9 LEFT JOIN mediables med1 ON med1.mediable_id=f1.id AND med1.tag='headshot' AND med1.mediable_type='App\\Models\\Fighter' LEFT JOIN media m1 ON m1.id=med1.media_id LEFT JOIN mediables med2 ON med2.mediable_id=f1.id AND med2.tag='bodyshot' AND med2.mediable_type='App\\Models\\Fighter' LEFT JOIN media m2 ON m2.id=med2.media_id LEFT JOIN mediables med3 ON med3.mediable_id=f2.id AND med3.tag='headshot' AND med3.mediable_type='App\\Models\\Fighter' LEFT JOIN media m3 ON m3.id=med3.media_id LEFT JOIN mediables med4 ON med4.mediable_id=f2.id AND med4.tag='bodyshot' AND med4.mediable_type='App\\Models\\Fighter' LEFT JOIN media m4 ON m4.id=med4.media_id LEFT JOIN mediables med5 ON med5.mediable_id=b.id AND med5.tag='logo' AND med5.mediable_type='App\\Models\\Broadcaster' LEFT JOIN media m5 ON m5.id=med5.media_id LEFT JOIN mediables med6 ON med6.mediable_id=fc.id AND med6.tag='fighter_bodyshot_side_left' AND med6.mediable_type='App\\Models\\FightCard' LEFT JOIN media m6 ON m6.id=med6.media_id LEFT JOIN mediables med7 ON med7.mediable_id=fc.id AND med7.tag='fighter_bodyshot_side_right' AND med7.mediable_type='App\\Models\\FightCard' LEFT JOIN media m7 ON m7.id=med7.media_id WHERE e.slug = '2023-pfl-9' AND (fc.fighter_id=330 OR fc.vs_fighter_id=330) ORDER BY fc.order_number ASC
devpflmma_web870μsselect `val`, `name` from `settings` where `group` = ?
devpflmma_web640μsselect * from `events` where `events`.`id` = ? limit 1
devpflmma_web680μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web3.44msSELECT e.datetime AS event_datetime, 2023 AS season_year, s.season_type AS season_type, e.slug AS event_slug, fc.order_number, fc.id AS fight_card_id, fc.broadcaster, fc.winner_id, fc.match_details, fc.show_keys_to_victory, fc.show_match_details, fc.keys_to_victory AS fighter_keys_to_victory, fc.vs_keys_to_victory AS vs_fighter_keys_to_victory, fc.override_status, fc.pickem_status, IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.fighter_points, fr1.points) AS fighter_points, IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.vs_fighter_points, fr2.points) AS vs_fighter_points, fr1.points AS fighter_total_points, fr2.points AS vs_fighter_total_points, f1.gender AS fighter_gender, f2.gender AS vs_fighter_gender, f1.arm_reach AS fighter_arm_reach, f2.arm_reach AS vs_fighter_arm_reach, f1.leg_reach AS fighter_leg_reach, f2.leg_reach AS vs_fighter_leg_reach, f1.height AS fighter_height, f2.height AS vs_fighter_height, f1.weight AS fighter_weight, f2.weight AS vs_fighter_weight, fc.win_by, fc.round_time, CONCAT(f1.first_name, ' ', f1.last_name) AS fighter_name, CONCAT(f2.first_name, ' ', f2.last_name) AS vs_fighter_name, f1.first_name AS fighter_first_name, f1.last_name AS fighter_last_name, f2.first_name AS vs_fighter_first_name, f2.last_name AS vs_fighter_last_name, f1.id AS fighter_id, f2.id AS vs_fighter_id, f1.career_record AS fighter_career_record, f2.career_record AS vs_fighter_career_record, fr1.season_record AS fighter_season_record, fr2.season_record AS vs_fighter_season_record, f1.nation_flag AS fighter_nation_flag, f2.nation_flag AS vs_fighter_nation_flag, f1.challenger_highlights AS challenger_highlights, f2.challenger_highlights AS vs_challenger_highlights, fr1.ranking AS fighter_ranking, fr2.ranking AS vs_fighter_ranking, fc2.name AS weightclass, fc2.shortcode AS weightclass_shortcode, IF(fc.fighter_record<>'', fc.fighter_record, fr1.season_record) AS fighter_fight_card_record, IF(fc.vs_fighter_record<>'', fc.vs_fighter_record, fr2.season_record) AS vs_fighter_fight_card_record, b.name AS broadcast_name, b.url AS broadcast_url, fc.match_type, IF( IFNULL(m1.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m1.directory, '/', m1.filename, '.', m1.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f1.gender, '.png') ) AS fighter_thumbnail, IF( IFNULL(m2.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m2.directory, '/', m2.filename, '.', m2.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f1.gender, '.png') ) AS fighter_profile_image, IF( IFNULL(m3.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m3.directory, '/', m3.filename, '.', m3.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f2.gender, '.png') ) AS vs_fighter_thumbnail, IF( IFNULL(m4.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m4.directory, '/', m4.filename, '.', m4.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f2.gender, '.png') ) AS vs_fighter_profile_image, CONCAT('https://pflmma-dev.s3.amazonaws.com/', m5.directory, '/', m5.filename, '.', m5.extension) AS broadcast_logo, IF( IFNULL(m6.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m6.directory, '/', m6.filename, '.', m6.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f1.gender, '-left.png') ) AS fighter_bodyshot_side, IF( IFNULL(m7.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m7.directory, '/', m7.filename, '.', m7.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f2.gender, '-right.png') ) AS vs_fighter_bodyshot_side, IF( IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f1.nation_flag, '.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg') ) AS fighter_flag, IF( IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f2.nation_flag, '.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg') ) AS vs_fighter_flag, IF( IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f1.nation_flag, '_BACKDROP.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg') ) AS fighter_flag_backdrop, IF( IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f2.nation_flag, '_BACKDROP.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg') ) AS vs_fighter_flag_backdrop FROM fight_cards fc LEFT JOIN fighters f1 ON f1.id = fc.fighter_id LEFT JOIN fighters f2 ON f2.id = fc.vs_fighter_id INNER JOIN fighter_classes fc2 ON fc2.id = fc.fighter_class_id INNER JOIN events e ON e.id = fc.event_id LEFT JOIN seasons s ON e.season_id = s.id LEFT JOIN broadcasters b ON b.shortcode = fc.broadcaster LEFT JOIN fighter_records fr1 ON fr1.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 9 AND fighter_id = fc.fighter_id LIMIT 1 ) AND fr1.season_id = 9 LEFT JOIN fighter_records fr2 ON fr2.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 9 AND fighter_id = fc.vs_fighter_id LIMIT 1 ) AND fr2.season_id = 9 LEFT JOIN mediables med1 ON med1.mediable_id=f1.id AND med1.tag='headshot' AND med1.mediable_type='App\\Models\\Fighter' LEFT JOIN media m1 ON m1.id=med1.media_id LEFT JOIN mediables med2 ON med2.mediable_id=f1.id AND med2.tag='bodyshot' AND med2.mediable_type='App\\Models\\Fighter' LEFT JOIN media m2 ON m2.id=med2.media_id LEFT JOIN mediables med3 ON med3.mediable_id=f2.id AND med3.tag='headshot' AND med3.mediable_type='App\\Models\\Fighter' LEFT JOIN media m3 ON m3.id=med3.media_id LEFT JOIN mediables med4 ON med4.mediable_id=f2.id AND med4.tag='bodyshot' AND med4.mediable_type='App\\Models\\Fighter' LEFT JOIN media m4 ON m4.id=med4.media_id LEFT JOIN mediables med5 ON med5.mediable_id=b.id AND med5.tag='logo' AND med5.mediable_type='App\\Models\\Broadcaster' LEFT JOIN media m5 ON m5.id=med5.media_id LEFT JOIN mediables med6 ON med6.mediable_id=fc.id AND med6.tag='fighter_bodyshot_side_left' AND med6.mediable_type='App\\Models\\FightCard' LEFT JOIN media m6 ON m6.id=med6.media_id LEFT JOIN mediables med7 ON med7.mediable_id=fc.id AND med7.tag='fighter_bodyshot_side_right' AND med7.mediable_type='App\\Models\\FightCard' LEFT JOIN media m7 ON m7.id=med7.media_id WHERE e.slug = '2023-pfl-6' AND (fc.fighter_id=330 OR fc.vs_fighter_id=330) ORDER BY fc.order_number ASC
devpflmma_web840μsselect `val`, `name` from `settings` where `group` = ?
devpflmma_web730μsselect * from `events` where `events`.`id` = ? limit 1
devpflmma_web730μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web4.33msSELECT e.datetime AS event_datetime, 2023 AS season_year, s.season_type AS season_type, e.slug AS event_slug, fc.order_number, fc.id AS fight_card_id, fc.broadcaster, fc.winner_id, fc.match_details, fc.show_keys_to_victory, fc.show_match_details, fc.keys_to_victory AS fighter_keys_to_victory, fc.vs_keys_to_victory AS vs_fighter_keys_to_victory, fc.override_status, fc.pickem_status, IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.fighter_points, fr1.points) AS fighter_points, IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.vs_fighter_points, fr2.points) AS vs_fighter_points, fr1.points AS fighter_total_points, fr2.points AS vs_fighter_total_points, f1.gender AS fighter_gender, f2.gender AS vs_fighter_gender, f1.arm_reach AS fighter_arm_reach, f2.arm_reach AS vs_fighter_arm_reach, f1.leg_reach AS fighter_leg_reach, f2.leg_reach AS vs_fighter_leg_reach, f1.height AS fighter_height, f2.height AS vs_fighter_height, f1.weight AS fighter_weight, f2.weight AS vs_fighter_weight, fc.win_by, fc.round_time, CONCAT(f1.first_name, ' ', f1.last_name) AS fighter_name, CONCAT(f2.first_name, ' ', f2.last_name) AS vs_fighter_name, f1.first_name AS fighter_first_name, f1.last_name AS fighter_last_name, f2.first_name AS vs_fighter_first_name, f2.last_name AS vs_fighter_last_name, f1.id AS fighter_id, f2.id AS vs_fighter_id, f1.career_record AS fighter_career_record, f2.career_record AS vs_fighter_career_record, fr1.season_record AS fighter_season_record, fr2.season_record AS vs_fighter_season_record, f1.nation_flag AS fighter_nation_flag, f2.nation_flag AS vs_fighter_nation_flag, f1.challenger_highlights AS challenger_highlights, f2.challenger_highlights AS vs_challenger_highlights, fr1.ranking AS fighter_ranking, fr2.ranking AS vs_fighter_ranking, fc2.name AS weightclass, fc2.shortcode AS weightclass_shortcode, IF(fc.fighter_record<>'', fc.fighter_record, fr1.season_record) AS fighter_fight_card_record, IF(fc.vs_fighter_record<>'', fc.vs_fighter_record, fr2.season_record) AS vs_fighter_fight_card_record, b.name AS broadcast_name, b.url AS broadcast_url, fc.match_type, IF( IFNULL(m1.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m1.directory, '/', m1.filename, '.', m1.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f1.gender, '.png') ) AS fighter_thumbnail, IF( IFNULL(m2.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m2.directory, '/', m2.filename, '.', m2.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f1.gender, '.png') ) AS fighter_profile_image, IF( IFNULL(m3.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m3.directory, '/', m3.filename, '.', m3.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f2.gender, '.png') ) AS vs_fighter_thumbnail, IF( IFNULL(m4.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m4.directory, '/', m4.filename, '.', m4.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f2.gender, '.png') ) AS vs_fighter_profile_image, CONCAT('https://pflmma-dev.s3.amazonaws.com/', m5.directory, '/', m5.filename, '.', m5.extension) AS broadcast_logo, IF( IFNULL(m6.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m6.directory, '/', m6.filename, '.', m6.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f1.gender, '-left.png') ) AS fighter_bodyshot_side, IF( IFNULL(m7.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m7.directory, '/', m7.filename, '.', m7.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f2.gender, '-right.png') ) AS vs_fighter_bodyshot_side, IF( IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f1.nation_flag, '.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg') ) AS fighter_flag, IF( IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f2.nation_flag, '.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg') ) AS vs_fighter_flag, IF( IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f1.nation_flag, '_BACKDROP.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg') ) AS fighter_flag_backdrop, IF( IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f2.nation_flag, '_BACKDROP.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg') ) AS vs_fighter_flag_backdrop FROM fight_cards fc LEFT JOIN fighters f1 ON f1.id = fc.fighter_id LEFT JOIN fighters f2 ON f2.id = fc.vs_fighter_id INNER JOIN fighter_classes fc2 ON fc2.id = fc.fighter_class_id INNER JOIN events e ON e.id = fc.event_id LEFT JOIN seasons s ON e.season_id = s.id LEFT JOIN broadcasters b ON b.shortcode = fc.broadcaster LEFT JOIN fighter_records fr1 ON fr1.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 9 AND fighter_id = fc.fighter_id LIMIT 1 ) AND fr1.season_id = 9 LEFT JOIN fighter_records fr2 ON fr2.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 9 AND fighter_id = fc.vs_fighter_id LIMIT 1 ) AND fr2.season_id = 9 LEFT JOIN mediables med1 ON med1.mediable_id=f1.id AND med1.tag='headshot' AND med1.mediable_type='App\\Models\\Fighter' LEFT JOIN media m1 ON m1.id=med1.media_id LEFT JOIN mediables med2 ON med2.mediable_id=f1.id AND med2.tag='bodyshot' AND med2.mediable_type='App\\Models\\Fighter' LEFT JOIN media m2 ON m2.id=med2.media_id LEFT JOIN mediables med3 ON med3.mediable_id=f2.id AND med3.tag='headshot' AND med3.mediable_type='App\\Models\\Fighter' LEFT JOIN media m3 ON m3.id=med3.media_id LEFT JOIN mediables med4 ON med4.mediable_id=f2.id AND med4.tag='bodyshot' AND med4.mediable_type='App\\Models\\Fighter' LEFT JOIN media m4 ON m4.id=med4.media_id LEFT JOIN mediables med5 ON med5.mediable_id=b.id AND med5.tag='logo' AND med5.mediable_type='App\\Models\\Broadcaster' LEFT JOIN media m5 ON m5.id=med5.media_id LEFT JOIN mediables med6 ON med6.mediable_id=fc.id AND med6.tag='fighter_bodyshot_side_left' AND med6.mediable_type='App\\Models\\FightCard' LEFT JOIN media m6 ON m6.id=med6.media_id LEFT JOIN mediables med7 ON med7.mediable_id=fc.id AND med7.tag='fighter_bodyshot_side_right' AND med7.mediable_type='App\\Models\\FightCard' LEFT JOIN media m7 ON m7.id=med7.media_id WHERE e.slug = '2023-pfl-3' AND (fc.fighter_id=330 OR fc.vs_fighter_id=330) ORDER BY fc.order_number ASC
devpflmma_web970μsselect `val`, `name` from `settings` where `group` = ?
devpflmma_web780μsselect * from `events` where `events`.`id` = ? limit 1
devpflmma_web580μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web4.32msSELECT e.datetime AS event_datetime, 2022 AS season_year, s.season_type AS season_type, e.slug AS event_slug, fc.order_number, fc.id AS fight_card_id, fc.broadcaster, fc.winner_id, fc.match_details, fc.show_keys_to_victory, fc.show_match_details, fc.keys_to_victory AS fighter_keys_to_victory, fc.vs_keys_to_victory AS vs_fighter_keys_to_victory, fc.override_status, fc.pickem_status, IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.fighter_points, fr1.points) AS fighter_points, IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.vs_fighter_points, fr2.points) AS vs_fighter_points, fr1.points AS fighter_total_points, fr2.points AS vs_fighter_total_points, f1.gender AS fighter_gender, f2.gender AS vs_fighter_gender, f1.arm_reach AS fighter_arm_reach, f2.arm_reach AS vs_fighter_arm_reach, f1.leg_reach AS fighter_leg_reach, f2.leg_reach AS vs_fighter_leg_reach, f1.height AS fighter_height, f2.height AS vs_fighter_height, f1.weight AS fighter_weight, f2.weight AS vs_fighter_weight, fc.win_by, fc.round_time, CONCAT(f1.first_name, ' ', f1.last_name) AS fighter_name, CONCAT(f2.first_name, ' ', f2.last_name) AS vs_fighter_name, f1.first_name AS fighter_first_name, f1.last_name AS fighter_last_name, f2.first_name AS vs_fighter_first_name, f2.last_name AS vs_fighter_last_name, f1.id AS fighter_id, f2.id AS vs_fighter_id, f1.career_record AS fighter_career_record, f2.career_record AS vs_fighter_career_record, fr1.season_record AS fighter_season_record, fr2.season_record AS vs_fighter_season_record, f1.nation_flag AS fighter_nation_flag, f2.nation_flag AS vs_fighter_nation_flag, f1.challenger_highlights AS challenger_highlights, f2.challenger_highlights AS vs_challenger_highlights, fr1.ranking AS fighter_ranking, fr2.ranking AS vs_fighter_ranking, fc2.name AS weightclass, fc2.shortcode AS weightclass_shortcode, IF(fc.fighter_record<>'', fc.fighter_record, fr1.season_record) AS fighter_fight_card_record, IF(fc.vs_fighter_record<>'', fc.vs_fighter_record, fr2.season_record) AS vs_fighter_fight_card_record, b.name AS broadcast_name, b.url AS broadcast_url, fc.match_type, IF( IFNULL(m1.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m1.directory, '/', m1.filename, '.', m1.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f1.gender, '.png') ) AS fighter_thumbnail, IF( IFNULL(m2.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m2.directory, '/', m2.filename, '.', m2.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f1.gender, '.png') ) AS fighter_profile_image, IF( IFNULL(m3.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m3.directory, '/', m3.filename, '.', m3.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f2.gender, '.png') ) AS vs_fighter_thumbnail, IF( IFNULL(m4.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m4.directory, '/', m4.filename, '.', m4.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f2.gender, '.png') ) AS vs_fighter_profile_image, CONCAT('https://pflmma-dev.s3.amazonaws.com/', m5.directory, '/', m5.filename, '.', m5.extension) AS broadcast_logo, IF( IFNULL(m6.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m6.directory, '/', m6.filename, '.', m6.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f1.gender, '-left.png') ) AS fighter_bodyshot_side, IF( IFNULL(m7.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m7.directory, '/', m7.filename, '.', m7.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f2.gender, '-right.png') ) AS vs_fighter_bodyshot_side, IF( IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f1.nation_flag, '.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg') ) AS fighter_flag, IF( IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f2.nation_flag, '.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg') ) AS vs_fighter_flag, IF( IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f1.nation_flag, '_BACKDROP.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg') ) AS fighter_flag_backdrop, IF( IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f2.nation_flag, '_BACKDROP.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg') ) AS vs_fighter_flag_backdrop FROM fight_cards fc LEFT JOIN fighters f1 ON f1.id = fc.fighter_id LEFT JOIN fighters f2 ON f2.id = fc.vs_fighter_id INNER JOIN fighter_classes fc2 ON fc2.id = fc.fighter_class_id INNER JOIN events e ON e.id = fc.event_id LEFT JOIN seasons s ON e.season_id = s.id LEFT JOIN broadcasters b ON b.shortcode = fc.broadcaster LEFT JOIN fighter_records fr1 ON fr1.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 6 AND fighter_id = fc.fighter_id LIMIT 1 ) AND fr1.season_id = 6 LEFT JOIN fighter_records fr2 ON fr2.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 6 AND fighter_id = fc.vs_fighter_id LIMIT 1 ) AND fr2.season_id = 6 LEFT JOIN mediables med1 ON med1.mediable_id=f1.id AND med1.tag='headshot' AND med1.mediable_type='App\\Models\\Fighter' LEFT JOIN media m1 ON m1.id=med1.media_id LEFT JOIN mediables med2 ON med2.mediable_id=f1.id AND med2.tag='bodyshot' AND med2.mediable_type='App\\Models\\Fighter' LEFT JOIN media m2 ON m2.id=med2.media_id LEFT JOIN mediables med3 ON med3.mediable_id=f2.id AND med3.tag='headshot' AND med3.mediable_type='App\\Models\\Fighter' LEFT JOIN media m3 ON m3.id=med3.media_id LEFT JOIN mediables med4 ON med4.mediable_id=f2.id AND med4.tag='bodyshot' AND med4.mediable_type='App\\Models\\Fighter' LEFT JOIN media m4 ON m4.id=med4.media_id LEFT JOIN mediables med5 ON med5.mediable_id=b.id AND med5.tag='logo' AND med5.mediable_type='App\\Models\\Broadcaster' LEFT JOIN media m5 ON m5.id=med5.media_id LEFT JOIN mediables med6 ON med6.mediable_id=fc.id AND med6.tag='fighter_bodyshot_side_left' AND med6.mediable_type='App\\Models\\FightCard' LEFT JOIN media m6 ON m6.id=med6.media_id LEFT JOIN mediables med7 ON med7.mediable_id=fc.id AND med7.tag='fighter_bodyshot_side_right' AND med7.mediable_type='App\\Models\\FightCard' LEFT JOIN media m7 ON m7.id=med7.media_id WHERE e.slug = '2022-pfl-8' AND (fc.fighter_id=330 OR fc.vs_fighter_id=330) ORDER BY fc.order_number ASC
devpflmma_web810μsselect `val`, `name` from `settings` where `group` = ?
devpflmma_web700μsselect * from `events` where `events`.`id` = ? limit 1
devpflmma_web680μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web4.88msSELECT 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 = 5 AND fighter_id = fc.fighter_id LIMIT 1 ) AND fr1.season_id = 5 LEFT JOIN fighter_records fr2 ON fr2.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 5 AND fighter_id = fc.vs_fighter_id LIMIT 1 ) AND fr2.season_id = 5 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-challenger-series-week-8' AND (fc.fighter_id=330 OR fc.vs_fighter_id=330) ORDER BY fc.order_number ASC
devpflmma_web990μsselect `val`, `name` from `settings` where `group` = ?
devpflmma_web830μsselect * from `events` where `events`.`id` = ? limit 1
devpflmma_web1.02msselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web4.76msSELECT 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-3' AND (fc.fighter_id=330 OR fc.vs_fighter_id=330) ORDER BY fc.order_number ASC
devpflmma_web820μsselect `val`, `name` from `settings` where `group` = ?
devpflmma_web590μsselect * from `events` where `events`.`id` = ? limit 1
devpflmma_web570μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web4.5msSELECT 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 = 5 AND fighter_id = fc.fighter_id LIMIT 1 ) AND fr1.season_id = 5 LEFT JOIN fighter_records fr2 ON fr2.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 5 AND fighter_id = fc.vs_fighter_id LIMIT 1 ) AND fr2.season_id = 5 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-challenger-series-week-2' AND (fc.fighter_id=330 OR fc.vs_fighter_id=330) ORDER BY fc.order_number ASC
devpflmma_web680μsselect * from `fighters` where `fighters`.`id` = ? limit 1
devpflmma_web1.51msselect `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` = ? and `article_tags`.`article_tag_type` = ? order by `created_at` desc
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_web1.94msselect `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_web1.05msselect `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_web760μ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_web5.49msselect `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_web3.17msselect `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_web970μ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_web970μ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_web780μ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_web760μ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_web770μ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_web830μ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_web610μsselect * from `fighters` where `fighters`.`id` = ? limit 1
devpflmma_web1.54msselect `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` = ? and `video_tags`.`video_tag_type` = ? order by `created_at` desc
devpflmma_web780μ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_web840μ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_web750μ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_web820μ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_web730μ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_web690μ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_web690μ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_web650μ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_web830μ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_web820μ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_web830μ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_web920μsselect * from `seasons` where `season_type` = ? order by `year` desc limit 1
devpflmma_web1.31msSELECT 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=330 OR fc.vs_fighter_id=330) AND e.datetime>='2025-04-05 00:29:56' AND e.event_status = 'scheduled' ORDER BY fc.order_number ASC
devpflmma_web720μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web490μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web720μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web1.19msselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web810μsselect `val`, `name` from `settings` where `group` = ?
devpflmma_web650μsselect `val`, `name` from `settings` where `group` = ?
devpflmma_web630μsselect `val`, `name` from `settings` where `group` = ?
devpflmma_web790μsselect `val`, `name` from `settings` where `group` = ?
devpflmma_web690μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web670μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web780μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web1.38msselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web820μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web660μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web600μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web590μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web580μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web540μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web580μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web730μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web540μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web600μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web630μsselect * from `media` where `media`.`id` = ? limit 1

Plank\Mediable\Media: 95Media.php#?
App\Models\Season: 44Season.php#?
App\Models\Fighter: 19Fighter.php#?
App\Models\Article: 12Article.php#?
App\Models\Video: 11Video.php#?
App\Models\FighterRecord: 10FighterRecord.php#?
App\Models\FightCard: 7FightCard.php#?
App\Models\Event: 7Event.php#?

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-05 00:29:56	GET	/regular-fighter/carlos-leal	14 182 205

1 x Application (95.25%)	417ms
1 x Preparing Response (9.17%)	40.17ms
1 x Booting (4.74%)	20.79ms
1 x Routing (0.55%)	2.39ms
14 x View (0%)	0μs

Test

"THE LION"

Fighter Details

PFL Records

Career Fight Record

Career Notes

Fight Results

News

2023 PFL PLAYOFF CARDS FINALIZED FOR NEW YORK CITY AUGUST 18 & 23

Carlos Leal heads to the playoffs with a brutal knockout in striking battle

The Quick Sixes keep coming as Carlos Leal devastates David Zawada

Videos

Top 10 KNOCKOUTS | 2023 PFL Season

MMA Fight of the Year Behind the Scenes | Fight Week: Road to Championship Ep 33

Clay Collard vs Shane Burgos Final Face Off | Fight Week: Road to Championship Ep 31