Test

  • 4d
  • 3h
  • 33m
  • 59s
PROFESSIONAL FIGHTERS LEAGUE

Jeremy Kennedy

Career Record: 19-5-0, 1 NC

2025 World Tournament: 0-0-0

"JBC"

Fight Results

News

View All
Messages1RequestTimelineExceptionsViews13Queries162Models149MailsGate
SettingsRequest history343msRequest Duration6MBMemory Usage10.x
Laravel Version
10.48.29
PHP Version
8.3.16
Environment
development
Debug Mode
Enabled
URL
dev.pflmma.com
Timezone
America/New_York
Locale
en
GET {season_type}-fighter/{fighter}
status
200 OK
full_url
https://dev.pflmma.com/regular-fighter/jeremy-kennedy
action_name
fighter.show
controller_action
App\Http\Controllers\FighterController@show
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
  • warninglog[08:25:55] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
status
200 OK
full_url
https://dev.pflmma.com/regular-fighter/jeremy-kennedy
action_name
fighter.show
controller_action
App\Http\Controllers\FighterController@show
uri
GET {season_type}-fighter/{fighter}
domain
dev.pflmma.com
controller
App\Http\Controllers\FighterController@show
namespace
App\Http\Controllers
file
app/Http/Controllers/FighterController.php:264-533
middleware
web
duration
360ms
peak_memory
8MB
response
text/html; charset=UTF-8
request_format
html
request_query
[]
request_request
[]
request_headers
  0 of 0   
array:15 [▼
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "host" => array:1 [▶
    0 => "dev.pflmma.com"
  ]
]
request_cookies
[]
response_headers
  0 of 0   
array:3 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sat, 05 Apr 2025 12:25:55 GMT"
  ]
]
session_attributes
  0 of 0   
array:1 [▼
  "_token" => "tf9Rp317rQEwbC7psMcst0HDXuSXrg191Kvi483m"
]
  • Booting (14.16ms)time
  • Application (329ms)time
  • Routing (1.35ms)
  • View: components.widgets.articleviews
  • Preparing Response (51.15ms)
  • View: fighters.showviews
  • View: layouts.frontendviews
  • View: components.faviconsviews
  • View: components.stylesviews
  • View: components.frontend-tracking-headerviews
  • View: components.frontend-tracking-bodyviews
  • View: components.scriptsviews
  • View: components.countdown-timerviews
  • View: components.navviews
  • View: components.newsletter-signupviews
  • View: components.popupviews
  • View: components.preloaderviews
  • 1 x Application (95.87%)
    329ms
    1 x Preparing Response (14.91%)
    51.15ms
    1 x Booting (4.13%)
    14.16ms
    1 x Routing (0.39%)
    1.35ms
    13 x View (0%)
    0μs
    13 templates were rendered
    • components.widgets.articlearticle.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
    162 statements were executed (90 duplicates)Show only duplicatesdevpflmma_web222ms
    • # Query soft limit for Debugbar is reached after 100 queries, additional 62 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)
    • FighterController.php#1187devpflmma_webConnection Established
      Backtrace
      • app/Http/Controllers/FighterController.php:1187
      • app/Http/Controllers/FighterController.php:284
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FighterController.php#1190devpflmma_web3.36msselect * from `fighters` where LOWER(REPLACE(REPLACE(first_name, " ", ""), "'", "")) = "jeremy" and LOWER(REPLACE(REPLACE(last_name, " ", ""), "'", "")) = "kennedy" limit 1
      Backtrace
      • app/Http/Controllers/FighterController.php:1190
      • app/Http/Controllers/FighterController.php:284
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FighterController.php#309devpflmma_web1.37msselect * from `fighter_records` as `fr` left join `seasons` as `s` on `s`.`id` = `fr`.`season_id` where `fr`.`fighter_id` = 172 and `s`.`year` <> '2020' order by `s`.`year` desc limit 1
      Bindings
      • 0: 172
      • 1: 2020
      Backtrace
      • app/Http/Controllers/FighterController.php:309
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FighterController.php#311devpflmma_web750μsselect * from `seasons` where `seasons`.`id` = 18 limit 1
      Bindings
      • 0: 18
      Backtrace
      • app/Http/Controllers/FighterController.php:311
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FighterController.php#320devpflmma_web1.46msselect * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 172 and `s`.`year` <> '2020' order by `s`.`year` desc
      Bindings
      • 0: 172
      • 1: 2020
      Backtrace
      • app/Http/Controllers/FighterController.php:320
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FighterController.php#332devpflmma_web730μsselect * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 172 and `s`.`year` = 2025 order by `s`.`year` desc
      Bindings
      • 0: 172
      • 1: 2025
      Backtrace
      • app/Http/Controllers/FighterController.php:332
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • Functions.php#1037devpflmma_web1.54msselect * from `fighter_records` as `fr` left join `seasons` as `s` on `s`.`id` = `fr`.`season_id` where `fr`.`fighter_id` = 172 and `s`.`year` <> '2020' order by `s`.`year` desc limit 1
      Bindings
      • 0: 172
      • 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_web830μ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_web1.86msselect * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 172 and `s`.`year` <> '2020' order by `s`.`year` desc
      Bindings
      • 0: 172
      • 1: 2020
      Backtrace
      • app/Helpers/Functions.php:1048
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • Functions.php#1060devpflmma_web1.23msselect * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 172 and `s`.`year` = 2025 order by `s`.`year` desc
      Bindings
      • 0: 172
      • 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_web790μ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_web790μsselect * from `fighter_records` where `fighter_id` = 172 and `season_id` = 17 limit 1
      Bindings
      • 0: 172
      • 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_web600μ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_web2.43msSELECT 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='172'
      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_web1.05msselect * 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_web1.18msSELECT 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='172'
      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_web830μ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_web1.44msSELECT 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='172'
      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_web680μ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_web1.25msSELECT 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='172'
      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_web920μ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_web1.04msSELECT 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='172'
      Backtrace
      • app/Http/Controllers/FighterStatController.php:335
      • app/Http/Controllers/FighterStatController.php:355
      • app/Http/Controllers/FighterStatController.php:401
      • app/Helpers/Functions.php:1064
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • FighterStatController.php#304devpflmma_web690μsselect * from `seasons` where `year` = 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_web12.06msSELECT 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='172'
      Backtrace
      • app/Http/Controllers/FighterStatController.php:335
      • app/Http/Controllers/FighterStatController.php:356
      • app/Http/Controllers/FighterStatController.php:401
      • app/Helpers/Functions.php:1064
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • FighterStatController.php#304devpflmma_web2.43msselect * 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_web1.58msSELECT 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='172'
      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_web2.14msselect * 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_web2.59msSELECT 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='172'
      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_web760μ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_web5.95msSELECT 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_web740μsselect * from `fighters` where `fighters`.`id` = 416 limit 1
      Bindings
      • 0: 416
      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.13msselect `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` = 416 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
      Bindings
      • 0: 416
      • 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.47msselect * 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_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` = 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_web710μ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_web980μ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` = 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_web1.27msselect * 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_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` = 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#270devpflmma_web700μsselect * from `fighters` where `fighters`.`id` = 553 limit 1
      Bindings
      • 0: 553
      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.06msselect `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` = 553 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
      Bindings
      • 0: 553
      • 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_web610μ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_web670μsselect * from `fighter_records` where `fighter_id` = 172 and `season_id` = 10 limit 1
      Bindings
      • 0: 172
      • 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_web580μsselect * from `seasons` where `year` = 2024 limit 1
      Bindings
      • 0: 2024
      Backtrace
      • app/Http/Controllers/FighterStatController.php:304
      • app/Http/Controllers/FighterStatController.php:350
      • app/Http/Controllers/FighterStatController.php:401
      • app/Helpers/Functions.php:1064
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • FighterStatController.php#335devpflmma_web1.21msSELECT 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='172'
      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_web670μ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_web840μ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 = '10' WHERE 1=1 AND fs.season_year = '2024' AND f.id='172'
      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_web580μ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_web720μ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 = '10' WHERE 1=1 AND fs.season_year = '2024' AND f.id='172'
      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_web590μ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_web1.11msSELECT 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='172'
      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_web850μ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_web870μ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 = '10' WHERE 1=1 AND fs.season_year = '2024' AND f.id='172'
      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_web610μ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_web800μ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 = '10' WHERE 1=1 AND fs.season_year = '2024' AND f.id='172'
      Backtrace
      • app/Http/Controllers/FighterStatController.php:335
      • app/Http/Controllers/FighterStatController.php:356
      • app/Http/Controllers/FighterStatController.php:401
      • app/Helpers/Functions.php:1064
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • FighterStatController.php#304devpflmma_web1.49msselect * 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_web920μ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 = '10' WHERE 1=1 AND fs.season_year = '2024' AND f.id='172'
      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_web550μ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_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 = '10' WHERE 1=1 AND fs.season_year = '2024' AND f.id='172'
      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_web720μ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.21msSELECT 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_web700μsselect * 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.47msselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 844 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
      Bindings
      • 0: 844
      • 1: App\Models\Fighter
      Backtrace
      • vendor/plank/laravel-mediable/src/Mediable.php:385
      • vendor/plank/laravel-mediable/src/Mediable.php:427
      • app/Http/Controllers/FighterStatController.php:272
      • app/Http/Controllers/FighterStatController.php:384
      • app/Http/Controllers/FighterStatController.php:401
    • FighterStatController.php#270devpflmma_web1.09msselect * 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μ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` = 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_web630μ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_web1.1msselect `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_web930μ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_web910μ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` = 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_web860μ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_web1.87msselect `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_web950μsselect * from `seasons` where `year` = 2019 limit 1
      Bindings
      • 0: 2019
      Backtrace
      • app/Http/Controllers/FighterStatController.php:397
      • app/Helpers/Functions.php:1064
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FighterStatController.php#398devpflmma_web680μsselect * from `fighter_records` where `fighter_id` = 172 and `season_id` = 2 limit 1
      Bindings
      • 0: 172
      • 1: 2
      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_web690μsselect * from `seasons` where `year` = 2019 limit 1
      Bindings
      • 0: 2019
      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.03msSELECT 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 = '2' WHERE 1=1 AND fs.season_year = '2019' AND f.id='172'
      Backtrace
      • app/Http/Controllers/FighterStatController.php:335
      • app/Http/Controllers/FighterStatController.php:350
      • app/Http/Controllers/FighterStatController.php:401
      • app/Helpers/Functions.php:1064
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • FighterStatController.php#304devpflmma_web780μsselect * from `seasons` where `year` = 2019 limit 1
      Bindings
      • 0: 2019
      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.08msSELECT 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 = '2' WHERE 1=1 AND fs.season_year = '2019' AND f.id='172'
      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_web650μsselect * from `seasons` where `year` = 2019 limit 1
      Bindings
      • 0: 2019
      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_web2msSELECT 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 = '2' WHERE 1=1 AND fs.season_year = '2019' AND f.id='172'
      Backtrace
      • app/Http/Controllers/FighterStatController.php:335
      • app/Http/Controllers/FighterStatController.php:353
      • app/Http/Controllers/FighterStatController.php:401
      • app/Helpers/Functions.php:1064
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • FighterStatController.php#304devpflmma_web1.21msselect * from `seasons` where `year` = 2019 limit 1
      Bindings
      • 0: 2019
      Backtrace
      • app/Http/Controllers/FighterStatController.php:304
      • app/Http/Controllers/FighterStatController.php:354
      • app/Http/Controllers/FighterStatController.php:401
      • app/Helpers/Functions.php:1064
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • FighterStatController.php#335devpflmma_web5.04msSELECT 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 = '2' WHERE 1=1 AND fs.season_year = '2019' AND f.id='172'
      Backtrace
      • app/Http/Controllers/FighterStatController.php:335
      • app/Http/Controllers/FighterStatController.php:354
      • app/Http/Controllers/FighterStatController.php:401
      • app/Helpers/Functions.php:1064
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • FighterStatController.php#304devpflmma_web1.12msselect * from `seasons` where `year` = 2019 limit 1
      Bindings
      • 0: 2019
      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_web2.37msSELECT 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 = '2' WHERE 1=1 AND fs.season_year = '2019' AND f.id='172'
      Backtrace
      • app/Http/Controllers/FighterStatController.php:335
      • app/Http/Controllers/FighterStatController.php:355
      • app/Http/Controllers/FighterStatController.php:401
      • app/Helpers/Functions.php:1064
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • FighterStatController.php#304devpflmma_web2.44msselect * from `seasons` where `year` = 2019 limit 1
      Bindings
      • 0: 2019
      Backtrace
      • app/Http/Controllers/FighterStatController.php:304
      • app/Http/Controllers/FighterStatController.php:356
      • app/Http/Controllers/FighterStatController.php:401
      • app/Helpers/Functions.php:1064
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • FighterStatController.php#335devpflmma_web1.67msSELECT 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 = '2' WHERE 1=1 AND fs.season_year = '2019' AND f.id='172'
      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_web780μsselect * from `seasons` where `year` = 2019 limit 1
      Bindings
      • 0: 2019
      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.1msSELECT 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 = '2' WHERE 1=1 AND fs.season_year = '2019' AND f.id='172'
      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_web840μsselect * from `seasons` where `year` = 2019 limit 1
      Bindings
      • 0: 2019
      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_web890μ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 = '2' WHERE 1=1 AND fs.season_year = '2019' AND f.id='172'
      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_web620μsselect * from `seasons` where `year` = 2019 limit 1
      Bindings
      • 0: 2019
      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.43msSELECT 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=2 LEFT JOIN fighter_classes fc ON fc.id = fr.fighter_class_id WHERE 1=1 AND fs.season_year = '2019' 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_web780μsselect * from `fighters` where `fighters`.`id` = 160 limit 1
      Bindings
      • 0: 160
      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.22msselect `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` = 160 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
      Bindings
      • 0: 160
      • 1: App\Models\Fighter
      Backtrace
      • vendor/plank/laravel-mediable/src/Mediable.php:385
      • vendor/plank/laravel-mediable/src/Mediable.php:427
      • app/Http/Controllers/FighterStatController.php:272
      • app/Http/Controllers/FighterStatController.php:384
      • app/Http/Controllers/FighterStatController.php:401
    • FighterStatController.php#270devpflmma_web660μsselect * from `fighters` where `fighters`.`id` = 192 limit 1
      Bindings
      • 0: 192
      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.21msselect `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` = 192 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
      Bindings
      • 0: 192
      • 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` = 184 limit 1
      Bindings
      • 0: 184
      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.18msselect `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` = 184 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
      Bindings
      • 0: 184
      • 1: App\Models\Fighter
      Backtrace
      • vendor/plank/laravel-mediable/src/Mediable.php:385
      • vendor/plank/laravel-mediable/src/Mediable.php:427
      • app/Http/Controllers/FighterStatController.php:272
      • app/Http/Controllers/FighterStatController.php:384
      • app/Http/Controllers/FighterStatController.php:401
    • FighterStatController.php#270devpflmma_web660μsselect * from `fighters` where `fighters`.`id` = 27 limit 1
      Bindings
      • 0: 27
      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.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` = 27 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
      Bindings
      • 0: 27
      • 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` = 41 limit 1
      Bindings
      • 0: 41
      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.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` = 41 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
      Bindings
      • 0: 41
      • 1: App\Models\Fighter
      Backtrace
      • vendor/plank/laravel-mediable/src/Mediable.php:385
      • vendor/plank/laravel-mediable/src/Mediable.php:427
      • app/Http/Controllers/FighterStatController.php:272
      • app/Http/Controllers/FighterStatController.php:384
      • app/Http/Controllers/FighterStatController.php:401
    • FighterController.php#423devpflmma_web1.84msselect `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` = 18 left join `mediables` as `med` on `med`.`mediable_id` = `f`.`id` and `med`.`tag` = 'headshot' and `med`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m` on `m`.`id` = `med`.`media_id` left join `mediables` as `med2` on `med2`.`mediable_id` = `f`.`id` and `med2`.`tag` = 'bodyshot' and `med2`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m2` on `m2`.`id` = `med2`.`media_id` left join `mediables` as `med3` on `med3`.`mediable_id` = `f`.`id` and `med3`.`tag` = 'banner' and `med3`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m3` on `m3`.`id` = `med3`.`media_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fr`.`fighter_class_id` where `f`.`id` = 172 limit 1
      Bindings
      • 0: 18
      • 1: headshot
      • 2: App\Models\Fighter
      • 3: bodyshot
      • 4: App\Models\Fighter
      • 5: banner
      • 6: App\Models\Fighter
      • 7: 172
      Backtrace
      • app/Http/Controllers/FighterController.php:423
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • devpflmma_web1.62msselect * from `fighters` where `fighters`.`id` = ? limit 1
    • devpflmma_web2.18ms(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_web760μsselect `val`, `name` from `settings` where `group` = ?
    • devpflmma_web650μsselect * from `events` where `events`.`id` = ? limit 1
    • devpflmma_web850μsselect * from `seasons` where `seasons`.`id` = ? limit 1
    • devpflmma_web7.07msSELECT 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-1' AND (fc.fighter_id=172 OR fc.vs_fighter_id=172) ORDER BY fc.order_number ASC
    • devpflmma_web910μsselect `val`, `name` from `settings` where `group` = ?
    • devpflmma_web720μsselect * from `events` where `events`.`id` = ? limit 1
    • devpflmma_web640μsselect * from `seasons` where `seasons`.`id` = ? limit 1
    • devpflmma_web3.58msSELECT 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 = 15 AND fighter_id = fc.fighter_id LIMIT 1 ) AND fr1.season_id = 15 LEFT JOIN fighter_records fr2 ON fr2.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 15 AND fighter_id = fc.vs_fighter_id LIMIT 1 ) AND fr2.season_id = 15 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-mena-4' AND (fc.fighter_id=172 OR fc.vs_fighter_id=172) ORDER BY fc.order_number ASC
    • devpflmma_web700μsselect `val`, `name` from `settings` where `group` = ?
    • devpflmma_web770μsselect * from `events` where `events`.`id` = ? limit 1
    • devpflmma_web1.08msselect * from `seasons` where `seasons`.`id` = ? limit 1
    • devpflmma_web3.92msSELECT 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 = 14 AND fighter_id = fc.fighter_id LIMIT 1 ) AND fr1.season_id = 14 LEFT JOIN fighter_records fr2 ON fr2.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 14 AND fighter_id = fc.vs_fighter_id LIMIT 1 ) AND fr2.season_id = 14 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-bcs-1' AND (fc.fighter_id=172 OR fc.vs_fighter_id=172) ORDER BY fc.order_number ASC
    • devpflmma_web660μsselect `val`, `name` from `settings` where `group` = ?
    • devpflmma_web760μsselect * from `events` where `events`.`id` = ? limit 1
    • devpflmma_web520μsselect * from `seasons` where `seasons`.`id` = ? limit 1
    • devpflmma_web3.26msSELECT e.datetime AS event_datetime, 2019 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 = 2 AND fighter_id = fc.fighter_id LIMIT 1 ) AND fr1.season_id = 2 LEFT JOIN fighter_records fr2 ON fr2.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 2 AND fighter_id = fc.vs_fighter_id LIMIT 1 ) AND fr2.season_id = 2 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 = '2019-pfl-2' AND (fc.fighter_id=172 OR fc.vs_fighter_id=172) ORDER BY fc.order_number ASC
    • devpflmma_web840μsselect `val`, `name` from `settings` where `group` = ?
    • devpflmma_web860μsselect * from `events` where `events`.`id` = ? limit 1
    • devpflmma_web610μsselect * from `seasons` where `seasons`.`id` = ? limit 1
    • devpflmma_web3.22msSELECT e.datetime AS event_datetime, 2019 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 = 2 AND fighter_id = fc.fighter_id LIMIT 1 ) AND fr1.season_id = 2 LEFT JOIN fighter_records fr2 ON fr2.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 2 AND fighter_id = fc.vs_fighter_id LIMIT 1 ) AND fr2.season_id = 2 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 = '2019-pfl-5' AND (fc.fighter_id=172 OR fc.vs_fighter_id=172) ORDER BY fc.order_number ASC
    • devpflmma_web700μsselect `val`, `name` from `settings` where `group` = ?
    • devpflmma_web700μsselect * from `events` where `events`.`id` = ? limit 1
    • devpflmma_web580μsselect * from `seasons` where `seasons`.`id` = ? limit 1
    • devpflmma_web3.52msSELECT e.datetime AS event_datetime, 2019 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 = 2 AND fighter_id = fc.fighter_id LIMIT 1 ) AND fr1.season_id = 2 LEFT JOIN fighter_records fr2 ON fr2.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 2 AND fighter_id = fc.vs_fighter_id LIMIT 1 ) AND fr2.season_id = 2 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 = '2019-pfl-8' AND (fc.fighter_id=172 OR fc.vs_fighter_id=172) ORDER BY fc.order_number ASC
    • devpflmma_web750μsselect `val`, `name` from `settings` where `group` = ?
    • devpflmma_web640μsselect * from `events` where `events`.`id` = ? limit 1
    • devpflmma_web650μsselect * from `seasons` where `seasons`.`id` = ? limit 1
    • devpflmma_web3.58msSELECT e.datetime AS event_datetime, 2019 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 = 2 AND fighter_id = fc.fighter_id LIMIT 1 ) AND fr1.season_id = 2 LEFT JOIN fighter_records fr2 ON fr2.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 2 AND fighter_id = fc.vs_fighter_id LIMIT 1 ) AND fr2.season_id = 2 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 = '2019-pfl-8' AND (fc.fighter_id=172 OR fc.vs_fighter_id=172) ORDER BY fc.order_number ASC
    • devpflmma_web840μsselect * from `fighters` where `fighters`.`id` = ? limit 1
    • devpflmma_web1.95msselect `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_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_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_web610μsselect * from `fighters` where `fighters`.`id` = ? limit 1
    • devpflmma_web1.06msselect `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_web550μsselect * from `seasons` where `season_type` = ? order by `year` desc limit 1
    • devpflmma_web1.35msSELECT 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=172 OR fc.vs_fighter_id=172) AND e.datetime>='2025-04-05 08:25:55' AND e.event_status = 'scheduled' ORDER BY fc.order_number ASC
    • devpflmma_web690μsselect * from `seasons` where `seasons`.`id` = ? limit 1
    • devpflmma_web560μsselect * from `seasons` where `seasons`.`id` = ? limit 1
    • devpflmma_web730μsselect * from `seasons` where `seasons`.`id` = ? limit 1
    • devpflmma_web590μsselect * from `seasons` where `seasons`.`id` = ? limit 1
    • devpflmma_web1.02msselect `val`, `name` from `settings` where `group` = ?
    • devpflmma_web840μsselect `val`, `name` from `settings` where `group` = ?
    • devpflmma_web1.07msselect `val`, `name` from `settings` where `group` = ?
    • devpflmma_web830μsselect `val`, `name` from `settings` where `group` = ?
    • devpflmma_web630μsselect * from `media` where `media`.`id` = ? limit 1
    • devpflmma_web650μsselect * from `media` where `media`.`id` = ? limit 1
    • devpflmma_web780μsselect * from `media` where `media`.`id` = ? limit 1
    • devpflmma_web740μsselect * from `media` where `media`.`id` = ? limit 1
    • devpflmma_web630μsselect * from `media` where `media`.`id` = ? limit 1
    • devpflmma_web1.18msselect * from `media` where `media`.`id` = ? limit 1
    • devpflmma_web680μsselect * from `media` where `media`.`id` = ? limit 1
    • devpflmma_web670μsselect * from `media` where `media`.`id` = ? limit 1
    • devpflmma_web560μsselect * from `media` where `media`.`id` = ? limit 1
    • devpflmma_web580μsselect * from `media` where `media`.`id` = ? limit 1
    • devpflmma_web550μsselect * from `media` where `media`.`id` = ? limit 1
    • devpflmma_web620μsselect * from `media` where `media`.`id` = ? limit 1
    • devpflmma_web1.04msselect * from `media` where `media`.`id` = ? limit 1
    • devpflmma_web600μsselect * from `media` where `media`.`id` = ? limit 1
    • devpflmma_web550μsselect * from `media` where `media`.`id` = ? limit 1
    Plank\Mediable\Media
    60Media.php#?
    App\Models\Season
    44Season.php#?
    App\Models\Fighter
    19Fighter.php#?
    App\Models\FighterRecord
    9FighterRecord.php#?
    App\Models\FightCard
    7FightCard.php#?
    App\Models\Event
    7Event.php#?
    App\Models\Article
    3Article.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-04-05 08:25:55GET/regular-fighter/jeremy-kennedy113162149