Josh Silveira

Messages Request302 Found Timeline Exceptions Views14 Queries305 Models375 Mails Gate

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

status

200 OK

full_url

https://dev.pflmma.com/regular-fighter/josh-silveira

action_name

fighter.show

controller_action

App\Http\Controllers\FighterController@show

uri

GET {season_type}-fighter/{fighter}

domain

dev.pflmma.com

controller

App\Http\Controllers\FighterController@show

namespace

App\Http\Controllers

file

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

middleware

web

duration

684ms

peak_memory

12MB

response

text/html; charset=UTF-8

request_format

html

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkdqUUpvTlNIZzVBaHJaZlAyVXVkdkE9PSIsInZhbHVlIjoianRLaFg5cTNrbUNjMzJOTUVtL1JmQ3M5aTdQcWkyTHF3RkN5dHpFdXFkd2UvSG9abzJmYUlDTjdHV1R1L2cvZFpzb3hQWDdBYVFkSlZ6SjQ0YkJyMVVSS3ZlQTM3dTJrR093dElpR0JqVWRUQUhvd3R4WlJTOFVuaEY5bHM5cGoiLCJtYWMiOiIxY2FkZjEyNTVlZDA0OTA0ZjAwOTYwODRjMDZjYjdiZWJhMzNkYWFhMDI2NDY3MmRkOGJkMTZiYTg2OGExOWUxIiwidGFnIjoiIn0%3D; pfl_session=eyJpdiI6IjBzVHU0bUpONUp5eUd0eVZCaEYzK0E9PSIsInZhbHVlIjoiR0J5cHFPMWVyTS9FMlhsV1R4UU5PdVI1ck5kOHk3SWFyZlJycnYwb1V4THNoNkJkK3dHRXZ0N0l6c2NpMnBNblRtNnFuYkM2NHMvR3BIZDVmNkNUQ3R0WFBUTnhPN215M3BiOXhlZDVSSlFrc3ZqYmxIMXJ4c2t1cFN1cnBhM2kiLCJtYWMiOiI5NDJmYTdkOWE1M2JlNTdkNTcyZGM5NzcxYjRlOTU4OThjYTk0OGJjMWQ4YTlmZTUzMWZmMTFhZDkxMjU1ZWMzIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IkdqUUpvTlNIZzVBaHJaZlAyVXVkdkE9PSIsInZhbHVlIjoianRLaFg5cTNrbUNjMzJOTUVtL1JmQ3M5aTdQcWkyTHF3RkN5dHpFdXFkd2UvSG9abzJmYUlDTjdHV1R1L2cvZFpzb3hQW ▶"
  ]
  "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

  0 of 0   
array:2 [▼
  "XSRF-TOKEN" => "mSLLoAoC80ooIYi1fj3DyAMglA27aArr4MwAWNsR"
  "pfl_session" => "LgXCU6OjzFTBpfRNC9gAN5Z0zTwxuQFHiDLffv2h"
]

response_headers

  0 of 0   
array:3 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Thu, 17 Apr 2025 03:32:08 GMT"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "mSLLoAoC80ooIYi1fj3DyAMglA27aArr4MwAWNsR"
  "PHPDEBUGBAR_STACK_DATA" => array:1 [▶
    "01JS0WVJ3N7H6NT02FJSNPKZRA" => null
  ]
  "_previous" => array:1 [▶
    "url" => "https://dev.pflmma.com/fighter/josh-silveira"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

Booting (11.77ms)time
Application (639ms)time
Routing (1.26ms)
View: components.widgets.articleviews
View: components.widgets.videoviews
Preparing Response (44.07ms)
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 (98.19%)
639ms
1 x Preparing Response (6.77%)
44.07ms
1 x Booting (1.81%)
11.77ms
1 x Routing (0.19%)
1.26ms
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

305 statements were executed (226 duplicates)Show only duplicates devpflmma_web405ms

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

FighterController.php#1193devpflmma_webConnection Established

Backtrace

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

FighterController.php#1196devpflmma_web3.37ms

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

Backtrace

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

FighterController.php#315devpflmma_web1.62ms

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

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

FighterController.php#317devpflmma_web1.02msselect * from `seasons` where `seasons`.`id` = 18 limit 1

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

FighterController.php#326devpflmma_web2.25ms

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

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

FighterController.php#338devpflmma_web770μs

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

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

Functions.php#1037devpflmma_web1.01ms

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

Bindings	0: 323 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_web600μsselect * from `seasons` where `seasons`.`id` = 18 limit 1

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

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

Bindings	0: 323 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_web690μs

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

Bindings	0: 323 1: 2025
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_web570μsselect * from `seasons` where `year` = 2025 limit 1

Bindings	0: 2025
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_web590μsselect * from `fighter_records` where `fighter_id` = 323 and `season_id` = 17 limit 1

Bindings	0: 323 1: 17
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_web500μsselect * from `seasons` where `year` = 2025 limit 1

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

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

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

Bindings	0: 2025
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_web750μs

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

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

Bindings	0: 2025
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_web680μ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 = '17'
WHERE
1=1
AND fs.season_year = '2025' AND f.id='323'

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

Bindings	0: 2025
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_web790μ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 = '17'
WHERE
1=1
AND fs.season_year = '2025' AND f.id='323'

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

Bindings	0: 2025
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_web660μ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 = '17'
WHERE
1=1
AND fs.season_year = '2025' AND f.id='323'

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

Bindings	0: 2025
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_web660μ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 = '17'
WHERE
1=1
AND fs.season_year = '2025' AND f.id='323'

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

Bindings	0: 2025
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_web850μ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 = '17'
WHERE
1=1
AND fs.season_year = '2025' AND f.id='323'

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

Bindings	0: 2025
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_web960μ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 = '17'
WHERE
1=1
AND fs.season_year = '2025' AND f.id='323'

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

Bindings	0: 2025
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_web4.59ms

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=17
LEFT JOIN
fighter_classes fc
ON
fc.id = fr.fighter_class_id
WHERE
1=1
AND fs.season_year = '2025'
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.03msselect * from `fighters` where `fighters`.`id` = 172 limit 1

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

Bindings	0: 172 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_web860μsselect * from `fighters` where `fighters`.`id` = 171 limit 1

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

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

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

Bindings	0: 621 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` = 716 limit 1

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

Bindings	0: 716 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_web610μsselect * from `fighters` where `fighters`.`id` = 922 limit 1

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

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

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

FighterStatController.php#398devpflmma_web620μsselect * from `fighter_records` where `fighter_id` = 323 and `season_id` = 10 limit 1

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

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

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

FighterStatController.php#335devpflmma_web870μs

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

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

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

FighterStatController.php#335devpflmma_web1.14ms

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

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

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

FighterStatController.php#335devpflmma_web1.05ms

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

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

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

FighterStatController.php#335devpflmma_web830μ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 = '10'
WHERE
1=1
AND fs.season_year = '2024' AND f.id='323'

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

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

FighterStatController.php#335devpflmma_web1ms

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

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

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

FighterStatController.php#335devpflmma_web740μ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 = '10'
WHERE
1=1
AND fs.season_year = '2024' AND f.id='323'

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

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

FighterStatController.php#335devpflmma_web910μs

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

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

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

FighterStatController.php#335devpflmma_web830μ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 = '10'
WHERE
1=1
AND fs.season_year = '2024' AND f.id='323'

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

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

FighterStatController.php#267devpflmma_web17.52ms

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

Backtrace

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Mediable.php#385devpflmma_web870μs

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

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

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

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

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

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

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

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

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

Bindings	0: 323 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_web590μsselect * from `seasons` where `year` = 2023 limit 1

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

FighterStatController.php#335devpflmma_web1.1ms

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

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

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

FighterStatController.php#335devpflmma_web800μs

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

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

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

FighterStatController.php#335devpflmma_web850μs

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

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_web540μsselect * 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_web890μ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 = '7'
WHERE
1=1
AND fs.season_year = '2023' AND f.id='323'

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

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

FighterStatController.php#335devpflmma_web920μs

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

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

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

FighterStatController.php#335devpflmma_web830μ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 = '7'
WHERE
1=1
AND fs.season_year = '2023' AND f.id='323'

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

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

FighterStatController.php#335devpflmma_web1.33ms

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

Backtrace

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

FighterStatController.php#304devpflmma_web610μsselect * from `seasons` where `year` = 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_web700μ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 = '7'
WHERE
1=1
AND fs.season_year = '2023' AND f.id='323'

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_web510μ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_web10.12ms

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_web770μ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.13ms

select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 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_web630μ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_web780μ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_web630μsselect * 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_web760μ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` = 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_web590μ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_web790μ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_web670μsselect * from `fighters` where `fighters`.`id` = 75 limit 1

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

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

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

FighterStatController.php#397devpflmma_web670μ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

devpflmma_web1.36msselect * from `fighter_records` where `fighter_id` = ? and `season_id` = ? limit 1
devpflmma_web710μsselect * from `seasons` where `year` = ? limit 1
devpflmma_web1.6msSELECT 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='323'
devpflmma_web770μsselect * from `seasons` where `year` = ? limit 1
devpflmma_web900μsSELECT 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='323'
devpflmma_web610μsselect * from `seasons` where `year` = ? limit 1
devpflmma_web1.53msSELECT 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='323'
devpflmma_web550μsselect * from `seasons` where `year` = ? limit 1
devpflmma_web740μsSELECT 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='323'
devpflmma_web510μsselect * from `seasons` where `year` = ? limit 1
devpflmma_web770μsSELECT 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='323'
devpflmma_web590μsselect * from `seasons` where `year` = ? limit 1
devpflmma_web930μsSELECT 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='323'
devpflmma_web570μsselect * from `seasons` where `year` = ? limit 1
devpflmma_web1.23msSELECT 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='323'
devpflmma_web570μsselect * from `seasons` where `year` = ? limit 1
devpflmma_web750μsSELECT 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='323'
devpflmma_web930μsselect * from `seasons` where `year` = ? limit 1
devpflmma_web8.84msSELECT 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
devpflmma_web680μsselect * from `fighters` where `fighters`.`id` = ? limit 1
devpflmma_web1.52msselect `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.09msselect * from `fighters` where `fighters`.`id` = ? limit 1
devpflmma_web1.41msselect `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.14msselect * from `fighters` where `fighters`.`id` = ? limit 1
devpflmma_web1.16msselect `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.06msselect * from `fighters` where `fighters`.`id` = ? limit 1
devpflmma_web1.55msselect `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.15msselect * from `fighters` where `fighters`.`id` = ? limit 1
devpflmma_web790μ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_web930μsselect * from `seasons` where `year` = ? limit 1
devpflmma_web1.04msselect * from `fighter_records` where `fighter_id` = ? and `season_id` = ? limit 1
devpflmma_web520μsselect * from `seasons` where `year` = ? limit 1
devpflmma_web780μsSELECT 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='323'
devpflmma_web520μsselect * from `seasons` where `year` = ? limit 1
devpflmma_web870μsSELECT 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='323'
devpflmma_web510μsselect * from `seasons` where `year` = ? limit 1
devpflmma_web730μsSELECT 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='323'
devpflmma_web620μsselect * from `seasons` where `year` = ? limit 1
devpflmma_web900μsSELECT 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='323'
devpflmma_web510μsselect * from `seasons` where `year` = ? limit 1
devpflmma_web740μsSELECT 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='323'
devpflmma_web510μsselect * from `seasons` where `year` = ? limit 1
devpflmma_web750μsSELECT 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='323'
devpflmma_web500μsselect * from `seasons` where `year` = ? limit 1
devpflmma_web690μsSELECT 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='323'
devpflmma_web530μsselect * from `seasons` where `year` = ? limit 1
devpflmma_web680μsSELECT 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='323'
devpflmma_web510μsselect * from `seasons` where `year` = ? limit 1
devpflmma_web10.57msSELECT 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
devpflmma_web740μsselect * from `fighters` where `fighters`.`id` = ? limit 1
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_web900μsselect * from `fighters` where `fighters`.`id` = ? limit 1
devpflmma_web1.4msselect `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 * from `fighters` where `fighters`.`id` = ? limit 1
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_web800μsselect * from `fighters` where `fighters`.`id` = ? limit 1
devpflmma_web790μ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.09msselect * from `fighters` where `fighters`.`id` = ? limit 1
devpflmma_web1.08msselect `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.22msselect `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` = ? left join `mediables` as `med` on `med`.`mediable_id` = `f`.`id` and `med`.`tag` = ? and `med`.`mediable_type` = ? 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` = ? and `med2`.`mediable_type` = ? 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` = ? and `med3`.`mediable_type` = ? 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` = ? limit 1
devpflmma_web630μsselect * from `fighters` where `fighters`.`id` = ? limit 1
devpflmma_web3.44ms(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_web740μsselect `val`, `name` from `settings` where `group` = ?
devpflmma_web640μsselect * from `events` where `events`.`id` = ? limit 1
devpflmma_web600μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web3.44msSELECT e.datetime AS event_datetime, 2025 AS season_year, s.season_type AS season_type, e.slug AS event_slug, fc.order_number, fc.id AS fight_card_id, fc.broadcaster, fc.winner_id, fc.match_details, fc.show_keys_to_victory, fc.show_match_details, fc.keys_to_victory AS fighter_keys_to_victory, fc.vs_keys_to_victory AS vs_fighter_keys_to_victory, fc.override_status, fc.pickem_status, IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.fighter_points, fr1.points) AS fighter_points, IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.vs_fighter_points, fr2.points) AS vs_fighter_points, fr1.points AS fighter_total_points, fr2.points AS vs_fighter_total_points, f1.gender AS fighter_gender, f2.gender AS vs_fighter_gender, f1.arm_reach AS fighter_arm_reach, f2.arm_reach AS vs_fighter_arm_reach, f1.leg_reach AS fighter_leg_reach, f2.leg_reach AS vs_fighter_leg_reach, f1.height AS fighter_height, f2.height AS vs_fighter_height, f1.weight AS fighter_weight, f2.weight AS vs_fighter_weight, fc.win_by, fc.round_time, CONCAT(f1.first_name, ' ', f1.last_name) AS fighter_name, CONCAT(f2.first_name, ' ', f2.last_name) AS vs_fighter_name, f1.first_name AS fighter_first_name, f1.last_name AS fighter_last_name, f2.first_name AS vs_fighter_first_name, f2.last_name AS vs_fighter_last_name, f1.id AS fighter_id, f2.id AS vs_fighter_id, f1.career_record AS fighter_career_record, f2.career_record AS vs_fighter_career_record, fr1.season_record AS fighter_season_record, fr2.season_record AS vs_fighter_season_record, f1.nation_flag AS fighter_nation_flag, f2.nation_flag AS vs_fighter_nation_flag, f1.challenger_highlights AS challenger_highlights, f2.challenger_highlights AS vs_challenger_highlights, fr1.ranking AS fighter_ranking, fr2.ranking AS vs_fighter_ranking, fc2.name AS weightclass, fc2.shortcode AS weightclass_shortcode, IF(fc.fighter_record<>'', fc.fighter_record, fr1.season_record) AS fighter_fight_card_record, IF(fc.vs_fighter_record<>'', fc.vs_fighter_record, fr2.season_record) AS vs_fighter_fight_card_record, b.name AS broadcast_name, b.url AS broadcast_url, fc.match_type, IF( IFNULL(m1.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m1.directory, '/', m1.filename, '.', m1.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f1.gender, '.png') ) AS fighter_thumbnail, IF( IFNULL(m2.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m2.directory, '/', m2.filename, '.', m2.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f1.gender, '.png') ) AS fighter_profile_image, IF( IFNULL(m3.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m3.directory, '/', m3.filename, '.', m3.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f2.gender, '.png') ) AS vs_fighter_thumbnail, IF( IFNULL(m4.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m4.directory, '/', m4.filename, '.', m4.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f2.gender, '.png') ) AS vs_fighter_profile_image, CONCAT('https://pflmma-dev.s3.amazonaws.com/', m5.directory, '/', m5.filename, '.', m5.extension) AS broadcast_logo, IF( IFNULL(m6.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m6.directory, '/', m6.filename, '.', m6.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f1.gender, '-left.png') ) AS fighter_bodyshot_side, IF( IFNULL(m7.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m7.directory, '/', m7.filename, '.', m7.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f2.gender, '-right.png') ) AS vs_fighter_bodyshot_side, IF( IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f1.nation_flag, '.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg') ) AS fighter_flag, IF( IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f2.nation_flag, '.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg') ) AS vs_fighter_flag, IF( IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f1.nation_flag, '_BACKDROP.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg') ) AS fighter_flag_backdrop, IF( IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f2.nation_flag, '_BACKDROP.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg') ) AS vs_fighter_flag_backdrop FROM fight_cards fc LEFT JOIN fighters f1 ON f1.id = fc.fighter_id LEFT JOIN fighters f2 ON f2.id = fc.vs_fighter_id INNER JOIN fighter_classes fc2 ON fc2.id = fc.fighter_class_id INNER JOIN events e ON e.id = fc.event_id LEFT JOIN seasons s ON e.season_id = s.id LEFT JOIN broadcasters b ON b.shortcode = fc.broadcaster LEFT JOIN fighter_records fr1 ON fr1.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 18 AND fighter_id = fc.fighter_id LIMIT 1 ) AND fr1.season_id = 18 LEFT JOIN fighter_records fr2 ON fr2.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 18 AND fighter_id = fc.vs_fighter_id LIMIT 1 ) AND fr2.season_id = 18 LEFT JOIN mediables med1 ON med1.mediable_id=f1.id AND med1.tag='headshot' AND med1.mediable_type='App\\Models\\Fighter' LEFT JOIN media m1 ON m1.id=med1.media_id LEFT JOIN mediables med2 ON med2.mediable_id=f1.id AND med2.tag='bodyshot' AND med2.mediable_type='App\\Models\\Fighter' LEFT JOIN media m2 ON m2.id=med2.media_id LEFT JOIN mediables med3 ON med3.mediable_id=f2.id AND med3.tag='headshot' AND med3.mediable_type='App\\Models\\Fighter' LEFT JOIN media m3 ON m3.id=med3.media_id LEFT JOIN mediables med4 ON med4.mediable_id=f2.id AND med4.tag='bodyshot' AND med4.mediable_type='App\\Models\\Fighter' LEFT JOIN media m4 ON m4.id=med4.media_id LEFT JOIN mediables med5 ON med5.mediable_id=b.id AND med5.tag='logo' AND med5.mediable_type='App\\Models\\Broadcaster' LEFT JOIN media m5 ON m5.id=med5.media_id LEFT JOIN mediables med6 ON med6.mediable_id=fc.id AND med6.tag='fighter_bodyshot_side_left' AND med6.mediable_type='App\\Models\\FightCard' LEFT JOIN media m6 ON m6.id=med6.media_id LEFT JOIN mediables med7 ON med7.mediable_id=fc.id AND med7.tag='fighter_bodyshot_side_right' AND med7.mediable_type='App\\Models\\FightCard' LEFT JOIN media m7 ON m7.id=med7.media_id WHERE e.slug = '2025-wt-3' AND (fc.fighter_id=323 OR fc.vs_fighter_id=323) ORDER BY fc.order_number ASC
devpflmma_web810μsselect `val`, `name` from `settings` where `group` = ?
devpflmma_web670μsselect * from `events` where `events`.`id` = ? limit 1
devpflmma_web680μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web19.09msSELECT e.datetime AS event_datetime, 2024 AS season_year, s.season_type AS season_type, e.slug AS event_slug, fc.order_number, fc.id AS fight_card_id, fc.broadcaster, fc.winner_id, fc.match_details, fc.show_keys_to_victory, fc.show_match_details, fc.keys_to_victory AS fighter_keys_to_victory, fc.vs_keys_to_victory AS vs_fighter_keys_to_victory, fc.override_status, fc.pickem_status, IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.fighter_points, fr1.points) AS fighter_points, IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.vs_fighter_points, fr2.points) AS vs_fighter_points, fr1.points AS fighter_total_points, fr2.points AS vs_fighter_total_points, f1.gender AS fighter_gender, f2.gender AS vs_fighter_gender, f1.arm_reach AS fighter_arm_reach, f2.arm_reach AS vs_fighter_arm_reach, f1.leg_reach AS fighter_leg_reach, f2.leg_reach AS vs_fighter_leg_reach, f1.height AS fighter_height, f2.height AS vs_fighter_height, f1.weight AS fighter_weight, f2.weight AS vs_fighter_weight, fc.win_by, fc.round_time, CONCAT(f1.first_name, ' ', f1.last_name) AS fighter_name, CONCAT(f2.first_name, ' ', f2.last_name) AS vs_fighter_name, f1.first_name AS fighter_first_name, f1.last_name AS fighter_last_name, f2.first_name AS vs_fighter_first_name, f2.last_name AS vs_fighter_last_name, f1.id AS fighter_id, f2.id AS vs_fighter_id, f1.career_record AS fighter_career_record, f2.career_record AS vs_fighter_career_record, fr1.season_record AS fighter_season_record, fr2.season_record AS vs_fighter_season_record, f1.nation_flag AS fighter_nation_flag, f2.nation_flag AS vs_fighter_nation_flag, f1.challenger_highlights AS challenger_highlights, f2.challenger_highlights AS vs_challenger_highlights, fr1.ranking AS fighter_ranking, fr2.ranking AS vs_fighter_ranking, fc2.name AS weightclass, fc2.shortcode AS weightclass_shortcode, IF(fc.fighter_record<>'', fc.fighter_record, fr1.season_record) AS fighter_fight_card_record, IF(fc.vs_fighter_record<>'', fc.vs_fighter_record, fr2.season_record) AS vs_fighter_fight_card_record, b.name AS broadcast_name, b.url AS broadcast_url, fc.match_type, IF( IFNULL(m1.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m1.directory, '/', m1.filename, '.', m1.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f1.gender, '.png') ) AS fighter_thumbnail, IF( IFNULL(m2.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m2.directory, '/', m2.filename, '.', m2.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f1.gender, '.png') ) AS fighter_profile_image, IF( IFNULL(m3.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m3.directory, '/', m3.filename, '.', m3.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f2.gender, '.png') ) AS vs_fighter_thumbnail, IF( IFNULL(m4.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m4.directory, '/', m4.filename, '.', m4.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f2.gender, '.png') ) AS vs_fighter_profile_image, CONCAT('https://pflmma-dev.s3.amazonaws.com/', m5.directory, '/', m5.filename, '.', m5.extension) AS broadcast_logo, IF( IFNULL(m6.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m6.directory, '/', m6.filename, '.', m6.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f1.gender, '-left.png') ) AS fighter_bodyshot_side, IF( IFNULL(m7.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m7.directory, '/', m7.filename, '.', m7.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f2.gender, '-right.png') ) AS vs_fighter_bodyshot_side, IF( IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f1.nation_flag, '.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg') ) AS fighter_flag, IF( IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f2.nation_flag, '.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg') ) AS vs_fighter_flag, IF( IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f1.nation_flag, '_BACKDROP.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg') ) AS fighter_flag_backdrop, IF( IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f2.nation_flag, '_BACKDROP.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg') ) AS vs_fighter_flag_backdrop FROM fight_cards fc LEFT JOIN fighters f1 ON f1.id = fc.fighter_id LEFT JOIN fighters f2 ON f2.id = fc.vs_fighter_id INNER JOIN fighter_classes fc2 ON fc2.id = fc.fighter_class_id INNER JOIN events e ON e.id = fc.event_id LEFT JOIN seasons s ON e.season_id = s.id LEFT JOIN broadcasters b ON b.shortcode = fc.broadcaster LEFT JOIN fighter_records fr1 ON fr1.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 16 AND fighter_id = fc.fighter_id LIMIT 1 ) AND fr1.season_id = 16 LEFT JOIN fighter_records fr2 ON fr2.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 16 AND fighter_id = fc.vs_fighter_id LIMIT 1 ) AND fr2.season_id = 16 LEFT JOIN mediables med1 ON med1.mediable_id=f1.id AND med1.tag='headshot' AND med1.mediable_type='App\\Models\\Fighter' LEFT JOIN media m1 ON m1.id=med1.media_id LEFT JOIN mediables med2 ON med2.mediable_id=f1.id AND med2.tag='bodyshot' AND med2.mediable_type='App\\Models\\Fighter' LEFT JOIN media m2 ON m2.id=med2.media_id LEFT JOIN mediables med3 ON med3.mediable_id=f2.id AND med3.tag='headshot' AND med3.mediable_type='App\\Models\\Fighter' LEFT JOIN media m3 ON m3.id=med3.media_id LEFT JOIN mediables med4 ON med4.mediable_id=f2.id AND med4.tag='bodyshot' AND med4.mediable_type='App\\Models\\Fighter' LEFT JOIN media m4 ON m4.id=med4.media_id LEFT JOIN mediables med5 ON med5.mediable_id=b.id AND med5.tag='logo' AND med5.mediable_type='App\\Models\\Broadcaster' LEFT JOIN media m5 ON m5.id=med5.media_id LEFT JOIN mediables med6 ON med6.mediable_id=fc.id AND med6.tag='fighter_bodyshot_side_left' AND med6.mediable_type='App\\Models\\FightCard' LEFT JOIN media m6 ON m6.id=med6.media_id LEFT JOIN mediables med7 ON med7.mediable_id=fc.id AND med7.tag='fighter_bodyshot_side_right' AND med7.mediable_type='App\\Models\\FightCard' LEFT JOIN media m7 ON m7.id=med7.media_id WHERE e.slug = '2024-pfl-8' AND (fc.fighter_id=323 OR fc.vs_fighter_id=323) ORDER BY fc.order_number ASC
devpflmma_web3.82msselect `val`, `name` from `settings` where `group` = ?
devpflmma_web2.1msselect * from `events` where `events`.`id` = ? limit 1
devpflmma_web3.6msselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web12.53msSELECT e.datetime AS event_datetime, 2024 AS season_year, s.season_type AS season_type, e.slug AS event_slug, fc.order_number, fc.id AS fight_card_id, fc.broadcaster, fc.winner_id, fc.match_details, fc.show_keys_to_victory, fc.show_match_details, fc.keys_to_victory AS fighter_keys_to_victory, fc.vs_keys_to_victory AS vs_fighter_keys_to_victory, fc.override_status, fc.pickem_status, IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.fighter_points, fr1.points) AS fighter_points, IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.vs_fighter_points, fr2.points) AS vs_fighter_points, fr1.points AS fighter_total_points, fr2.points AS vs_fighter_total_points, f1.gender AS fighter_gender, f2.gender AS vs_fighter_gender, f1.arm_reach AS fighter_arm_reach, f2.arm_reach AS vs_fighter_arm_reach, f1.leg_reach AS fighter_leg_reach, f2.leg_reach AS vs_fighter_leg_reach, f1.height AS fighter_height, f2.height AS vs_fighter_height, f1.weight AS fighter_weight, f2.weight AS vs_fighter_weight, fc.win_by, fc.round_time, CONCAT(f1.first_name, ' ', f1.last_name) AS fighter_name, CONCAT(f2.first_name, ' ', f2.last_name) AS vs_fighter_name, f1.first_name AS fighter_first_name, f1.last_name AS fighter_last_name, f2.first_name AS vs_fighter_first_name, f2.last_name AS vs_fighter_last_name, f1.id AS fighter_id, f2.id AS vs_fighter_id, f1.career_record AS fighter_career_record, f2.career_record AS vs_fighter_career_record, fr1.season_record AS fighter_season_record, fr2.season_record AS vs_fighter_season_record, f1.nation_flag AS fighter_nation_flag, f2.nation_flag AS vs_fighter_nation_flag, f1.challenger_highlights AS challenger_highlights, f2.challenger_highlights AS vs_challenger_highlights, fr1.ranking AS fighter_ranking, fr2.ranking AS vs_fighter_ranking, fc2.name AS weightclass, fc2.shortcode AS weightclass_shortcode, IF(fc.fighter_record<>'', fc.fighter_record, fr1.season_record) AS fighter_fight_card_record, IF(fc.vs_fighter_record<>'', fc.vs_fighter_record, fr2.season_record) AS vs_fighter_fight_card_record, b.name AS broadcast_name, b.url AS broadcast_url, fc.match_type, IF( IFNULL(m1.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m1.directory, '/', m1.filename, '.', m1.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f1.gender, '.png') ) AS fighter_thumbnail, IF( IFNULL(m2.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m2.directory, '/', m2.filename, '.', m2.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f1.gender, '.png') ) AS fighter_profile_image, IF( IFNULL(m3.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m3.directory, '/', m3.filename, '.', m3.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f2.gender, '.png') ) AS vs_fighter_thumbnail, IF( IFNULL(m4.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m4.directory, '/', m4.filename, '.', m4.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f2.gender, '.png') ) AS vs_fighter_profile_image, CONCAT('https://pflmma-dev.s3.amazonaws.com/', m5.directory, '/', m5.filename, '.', m5.extension) AS broadcast_logo, IF( IFNULL(m6.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m6.directory, '/', m6.filename, '.', m6.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f1.gender, '-left.png') ) AS fighter_bodyshot_side, IF( IFNULL(m7.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m7.directory, '/', m7.filename, '.', m7.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f2.gender, '-right.png') ) AS vs_fighter_bodyshot_side, IF( IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f1.nation_flag, '.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg') ) AS fighter_flag, IF( IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f2.nation_flag, '.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg') ) AS vs_fighter_flag, IF( IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f1.nation_flag, '_BACKDROP.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg') ) AS fighter_flag_backdrop, IF( IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f2.nation_flag, '_BACKDROP.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg') ) AS vs_fighter_flag_backdrop FROM fight_cards fc LEFT JOIN fighters f1 ON f1.id = fc.fighter_id LEFT JOIN fighters f2 ON f2.id = fc.vs_fighter_id INNER JOIN fighter_classes fc2 ON fc2.id = fc.fighter_class_id INNER JOIN events e ON e.id = fc.event_id LEFT JOIN seasons s ON e.season_id = s.id LEFT JOIN broadcasters b ON b.shortcode = fc.broadcaster LEFT JOIN fighter_records fr1 ON fr1.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 16 AND fighter_id = fc.fighter_id LIMIT 1 ) AND fr1.season_id = 16 LEFT JOIN fighter_records fr2 ON fr2.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 16 AND fighter_id = fc.vs_fighter_id LIMIT 1 ) AND fr2.season_id = 16 LEFT JOIN mediables med1 ON med1.mediable_id=f1.id AND med1.tag='headshot' AND med1.mediable_type='App\\Models\\Fighter' LEFT JOIN media m1 ON m1.id=med1.media_id LEFT JOIN mediables med2 ON med2.mediable_id=f1.id AND med2.tag='bodyshot' AND med2.mediable_type='App\\Models\\Fighter' LEFT JOIN media m2 ON m2.id=med2.media_id LEFT JOIN mediables med3 ON med3.mediable_id=f2.id AND med3.tag='headshot' AND med3.mediable_type='App\\Models\\Fighter' LEFT JOIN media m3 ON m3.id=med3.media_id LEFT JOIN mediables med4 ON med4.mediable_id=f2.id AND med4.tag='bodyshot' AND med4.mediable_type='App\\Models\\Fighter' LEFT JOIN media m4 ON m4.id=med4.media_id LEFT JOIN mediables med5 ON med5.mediable_id=b.id AND med5.tag='logo' AND med5.mediable_type='App\\Models\\Broadcaster' LEFT JOIN media m5 ON m5.id=med5.media_id LEFT JOIN mediables med6 ON med6.mediable_id=fc.id AND med6.tag='fighter_bodyshot_side_left' AND med6.mediable_type='App\\Models\\FightCard' LEFT JOIN media m6 ON m6.id=med6.media_id LEFT JOIN mediables med7 ON med7.mediable_id=fc.id AND med7.tag='fighter_bodyshot_side_right' AND med7.mediable_type='App\\Models\\FightCard' LEFT JOIN media m7 ON m7.id=med7.media_id WHERE e.slug = '2024-pfl-5' AND (fc.fighter_id=323 OR fc.vs_fighter_id=323) ORDER BY fc.order_number ASC
devpflmma_web2.79msselect `val`, `name` from `settings` where `group` = ?
devpflmma_web1.66msselect * from `events` where `events`.`id` = ? limit 1
devpflmma_web2.27msselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web10.06msSELECT e.datetime AS event_datetime, 2024 AS season_year, s.season_type AS season_type, e.slug AS event_slug, fc.order_number, fc.id AS fight_card_id, fc.broadcaster, fc.winner_id, fc.match_details, fc.show_keys_to_victory, fc.show_match_details, fc.keys_to_victory AS fighter_keys_to_victory, fc.vs_keys_to_victory AS vs_fighter_keys_to_victory, fc.override_status, fc.pickem_status, IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.fighter_points, fr1.points) AS fighter_points, IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.vs_fighter_points, fr2.points) AS vs_fighter_points, fr1.points AS fighter_total_points, fr2.points AS vs_fighter_total_points, f1.gender AS fighter_gender, f2.gender AS vs_fighter_gender, f1.arm_reach AS fighter_arm_reach, f2.arm_reach AS vs_fighter_arm_reach, f1.leg_reach AS fighter_leg_reach, f2.leg_reach AS vs_fighter_leg_reach, f1.height AS fighter_height, f2.height AS vs_fighter_height, f1.weight AS fighter_weight, f2.weight AS vs_fighter_weight, fc.win_by, fc.round_time, CONCAT(f1.first_name, ' ', f1.last_name) AS fighter_name, CONCAT(f2.first_name, ' ', f2.last_name) AS vs_fighter_name, f1.first_name AS fighter_first_name, f1.last_name AS fighter_last_name, f2.first_name AS vs_fighter_first_name, f2.last_name AS vs_fighter_last_name, f1.id AS fighter_id, f2.id AS vs_fighter_id, f1.career_record AS fighter_career_record, f2.career_record AS vs_fighter_career_record, fr1.season_record AS fighter_season_record, fr2.season_record AS vs_fighter_season_record, f1.nation_flag AS fighter_nation_flag, f2.nation_flag AS vs_fighter_nation_flag, f1.challenger_highlights AS challenger_highlights, f2.challenger_highlights AS vs_challenger_highlights, fr1.ranking AS fighter_ranking, fr2.ranking AS vs_fighter_ranking, fc2.name AS weightclass, fc2.shortcode AS weightclass_shortcode, IF(fc.fighter_record<>'', fc.fighter_record, fr1.season_record) AS fighter_fight_card_record, IF(fc.vs_fighter_record<>'', fc.vs_fighter_record, fr2.season_record) AS vs_fighter_fight_card_record, b.name AS broadcast_name, b.url AS broadcast_url, fc.match_type, IF( IFNULL(m1.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m1.directory, '/', m1.filename, '.', m1.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f1.gender, '.png') ) AS fighter_thumbnail, IF( IFNULL(m2.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m2.directory, '/', m2.filename, '.', m2.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f1.gender, '.png') ) AS fighter_profile_image, IF( IFNULL(m3.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m3.directory, '/', m3.filename, '.', m3.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f2.gender, '.png') ) AS vs_fighter_thumbnail, IF( IFNULL(m4.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m4.directory, '/', m4.filename, '.', m4.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f2.gender, '.png') ) AS vs_fighter_profile_image, CONCAT('https://pflmma-dev.s3.amazonaws.com/', m5.directory, '/', m5.filename, '.', m5.extension) AS broadcast_logo, IF( IFNULL(m6.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m6.directory, '/', m6.filename, '.', m6.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f1.gender, '-left.png') ) AS fighter_bodyshot_side, IF( IFNULL(m7.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m7.directory, '/', m7.filename, '.', m7.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f2.gender, '-right.png') ) AS vs_fighter_bodyshot_side, IF( IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f1.nation_flag, '.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg') ) AS fighter_flag, IF( IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f2.nation_flag, '.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg') ) AS vs_fighter_flag, IF( IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f1.nation_flag, '_BACKDROP.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg') ) AS fighter_flag_backdrop, IF( IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f2.nation_flag, '_BACKDROP.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg') ) AS vs_fighter_flag_backdrop FROM fight_cards fc LEFT JOIN fighters f1 ON f1.id = fc.fighter_id LEFT JOIN fighters f2 ON f2.id = fc.vs_fighter_id INNER JOIN fighter_classes fc2 ON fc2.id = fc.fighter_class_id INNER JOIN events e ON e.id = fc.event_id LEFT JOIN seasons s ON e.season_id = s.id LEFT JOIN broadcasters b ON b.shortcode = fc.broadcaster LEFT JOIN fighter_records fr1 ON fr1.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 16 AND fighter_id = fc.fighter_id LIMIT 1 ) AND fr1.season_id = 16 LEFT JOIN fighter_records fr2 ON fr2.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 16 AND fighter_id = fc.vs_fighter_id LIMIT 1 ) AND fr2.season_id = 16 LEFT JOIN mediables med1 ON med1.mediable_id=f1.id AND med1.tag='headshot' AND med1.mediable_type='App\\Models\\Fighter' LEFT JOIN media m1 ON m1.id=med1.media_id LEFT JOIN mediables med2 ON med2.mediable_id=f1.id AND med2.tag='bodyshot' AND med2.mediable_type='App\\Models\\Fighter' LEFT JOIN media m2 ON m2.id=med2.media_id LEFT JOIN mediables med3 ON med3.mediable_id=f2.id AND med3.tag='headshot' AND med3.mediable_type='App\\Models\\Fighter' LEFT JOIN media m3 ON m3.id=med3.media_id LEFT JOIN mediables med4 ON med4.mediable_id=f2.id AND med4.tag='bodyshot' AND med4.mediable_type='App\\Models\\Fighter' LEFT JOIN media m4 ON m4.id=med4.media_id LEFT JOIN mediables med5 ON med5.mediable_id=b.id AND med5.tag='logo' AND med5.mediable_type='App\\Models\\Broadcaster' LEFT JOIN media m5 ON m5.id=med5.media_id LEFT JOIN mediables med6 ON med6.mediable_id=fc.id AND med6.tag='fighter_bodyshot_side_left' AND med6.mediable_type='App\\Models\\FightCard' LEFT JOIN media m6 ON m6.id=med6.media_id LEFT JOIN mediables med7 ON med7.mediable_id=fc.id AND med7.tag='fighter_bodyshot_side_right' AND med7.mediable_type='App\\Models\\FightCard' LEFT JOIN media m7 ON m7.id=med7.media_id WHERE e.slug = '2024-pfl-2' AND (fc.fighter_id=323 OR fc.vs_fighter_id=323) ORDER BY fc.order_number ASC
devpflmma_web2.01msselect `val`, `name` from `settings` where `group` = ?
devpflmma_web2.58msselect * from `events` where `events`.`id` = ? limit 1
devpflmma_web2.23msselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web10.85msSELECT 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-10' AND (fc.fighter_id=323 OR fc.vs_fighter_id=323) ORDER BY fc.order_number ASC
devpflmma_web740μsselect `val`, `name` from `settings` where `group` = ?
devpflmma_web1.8msselect * from `events` where `events`.`id` = ? limit 1
devpflmma_web670μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web2.74msSELECT 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-7' AND (fc.fighter_id=323 OR fc.vs_fighter_id=323) ORDER BY fc.order_number ASC
devpflmma_web4.64msselect `val`, `name` from `settings` where `group` = ?
devpflmma_web650μsselect * from `events` where `events`.`id` = ? limit 1
devpflmma_web560μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web3.07msSELECT 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-4' AND (fc.fighter_id=323 OR fc.vs_fighter_id=323) ORDER BY fc.order_number ASC
devpflmma_web780μsselect `val`, `name` from `settings` where `group` = ?
devpflmma_web720μsselect * from `events` where `events`.`id` = ? limit 1
devpflmma_web1.23msselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web13.92msSELECT 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-1' AND (fc.fighter_id=323 OR fc.vs_fighter_id=323) ORDER BY fc.order_number ASC
devpflmma_web2.4msselect `val`, `name` from `settings` where `group` = ?
devpflmma_web680μsselect * from `events` where `events`.`id` = ? limit 1
devpflmma_web990μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web5.97msSELECT 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-7' AND (fc.fighter_id=323 OR fc.vs_fighter_id=323) ORDER BY fc.order_number ASC
devpflmma_web770μsselect `val`, `name` from `settings` where `group` = ?
devpflmma_web700μsselect * from `events` where `events`.`id` = ? limit 1
devpflmma_web560μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web4.07msSELECT 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-4' AND (fc.fighter_id=323 OR fc.vs_fighter_id=323) ORDER BY fc.order_number ASC
devpflmma_web840μsselect `val`, `name` from `settings` where `group` = ?
devpflmma_web660μsselect * from `events` where `events`.`id` = ? limit 1
devpflmma_web510μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web3.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-1' AND (fc.fighter_id=323 OR fc.vs_fighter_id=323) ORDER BY fc.order_number ASC
devpflmma_web800μsselect * from `fighters` where `fighters`.`id` = ? limit 1
devpflmma_web1.64msselect `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_web890μ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_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_web1.19msselect `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_web890μ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_web860μ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_web710μ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_web890μ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_web720μ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_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_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_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_web920μ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.16msselect `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_web960μsselect * from `fighters` where `fighters`.`id` = ? limit 1
devpflmma_web1.75msselect `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_web1.02msselect `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_web710μ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_web800μ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_web850μ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.14msselect `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_web700μ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_web670μ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_web930μ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.88msselect `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_web960μ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_web810μ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.11msselect `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_web700μ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_web670μ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_web700μ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_web660μ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_web850μ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_web680μ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_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_web670μ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_web640μ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_web800μ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_web950μ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_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_web940μsselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` asc
devpflmma_web810μ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_web700μ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_web670μ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_web660μ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_web710μ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_web800μ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_web790μ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_web660μ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_web630μ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_web870μ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_web1.26msselect `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_web950μ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_web670μ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_web640μ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_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_web910μsselect * from `seasons` where `season_type` = ? order by `year` desc limit 1
devpflmma_web2.03msSELECT 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=323 OR fc.vs_fighter_id=323) AND e.datetime>='2025-04-16 23:32:08' AND e.event_status = 'scheduled' ORDER BY fc.order_number ASC
devpflmma_web690μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web550μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web600μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web820μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web550μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web560μsselect * from `seasons` where `seasons`.`id` = ? limit 1
devpflmma_web2.07msselect `val`, `name` from `settings` where `group` = ?
devpflmma_web1.14msselect `val`, `name` from `settings` where `group` = ?
devpflmma_web770μsselect `val`, `name` from `settings` where `group` = ?
devpflmma_web1.08msselect `val`, `name` from `settings` where `group` = ?
devpflmma_web660μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web950μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web600μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web610μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web570μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web560μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web570μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web640μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web550μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web610μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web710μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web1.07msselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web760μsselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web1.01msselect * from `media` where `media`.`id` = ? limit 1
devpflmma_web600μsselect * from `media` where `media`.`id` = ? limit 1

Plank\Mediable\Media: 172Media.php#?
App\Models\Season: 70Season.php#?
App\Models\Video: 51Video.php#?
App\Models\Fighter: 29Fighter.php#?
App\Models\Article: 17Article.php#?
App\Models\FighterRecord: 14FighterRecord.php#?
App\Models\FightCard: 11FightCard.php#?
App\Models\Event: 11Event.php#?

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-16 23:32:07	GET	/fighter/josh-silveira (stacked)
#2	2025-04-16 23:32:08	GET	/regular-fighter/josh-silveira	14 305 375

1 x Application (98.19%)	639ms
1 x Preparing Response (6.77%)	44.07ms
1 x Booting (1.81%)	11.77ms
1 x Routing (0.19%)	1.26ms
14 x View (0%)	0μs

Test

Fighter Details

PFL Records

Career Fight Record

Career Notes

Fight Results

News

MAIN CARDS ANNOUNCED FOR THREE PFL PLAYOFF EVENTS IN AUGUST

Joshua Silveira scores six points after bizarre injury finish in first round

BIAGGIO ALI WALSH, BUBBA JENKINS AND CHRIS WADE ADDED TO STAR-STUDDED 2023 PFL WORLD CHAMPIONSHIP CA...

Videos

PFL Fight Week: VLOG Series | Hollywood | Ep. 10 [WEIGH INS & FACE OFFS]

PFL Fight Week: VLOG Series | Hollywood | Ep. 9 [ MEDIA DAY ]

Josh Silveira & Impa Kasanganay Watch Back Their 1st Fight | TALKIN SH*T