Test

PROFESSIONAL FIGHTERS LEAGUE

Jake Childers

Career Record: 9-3-0

Fight Results

Messages1Request302 FoundTimelineExceptionsViews12Queries39Models23MailsGate
SettingsRequest history2158msRequest Duration5MBMemory 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/jake-childers
action_name
fighter.show
controller_action
App\Http\Controllers\FighterController@show
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
  • warninglog[00:29:03] 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/jake-childers
action_name
fighter.show
controller_action
App\Http\Controllers\FighterController@show
uri
GET {season_type}-fighter/{fighter}
domain
dev.pflmma.com
controller
App\Http\Controllers\FighterController@show
namespace
App\Http\Controllers
file
app/Http/Controllers/FighterController.php:270-539
middleware
web
duration
161ms
peak_memory
6MB
response
text/html; charset=UTF-8
request_format
html
request_query
[]
request_request
[]
request_headers
  0 of 0   
array:16 [▼
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImpoV2JwcU9pa3RNMW0vaWJqTUVEckE9PSIsInZhbHVlIjoiUGxGUER2Y2FVcjdaNlVSUEN6RVVwSnk2UWlFcWNSSWNSWENnSnQxTXppaG9seStsVEpyQlhueEx5bFltT1p1d3lJYnVGcjIySW82aCtLeXV1VWdEZFRsMlpubWdsY3c3KzkyNFFUbDBoWGczcXNtVVFLeEwrSkVyRUR6cFVhNW4iLCJtYWMiOiJjNjM2NDE5YzFkNjNjNTI3MzdmNGY0ODU3NDEzYjgzMGY2ZGM5MzVmNGYyYWZkNjQxOGZkM2Y2YzlkZThmNDlmIiwidGFnIjoiIn0%3D; pfl_session=eyJpdiI6ImNrK3BqcmZEVFNTRGNnbEwzM214NlE9PSIsInZhbHVlIjoibHNiSkdoc2Y1N1YzVkRqUUhEd3E5WUZqVDJPUTE2SlRDRnA4TEs1cjVXazhYeTVGQ0RvSEtZcExpUFdJZVdSV1Juc3BaNk13ajRPNUpLK0tGanVTd0lwV1J2NEVUYmhlU3FGWk41UVBBMEhYNUVoRFZldHRaWnJCcDBpYldPVWYiLCJtYWMiOiIyYzQzNjBjYzNkODI4OTAwNGQzMzY3NmZmNGQyZGE0MzU5MjZkZmI4ZjQyYzMyNWIwOGExMDU2YjUwMTg4YTI3IiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6ImpoV2JwcU9pa3RNMW0vaWJqTUVEckE9PSIsInZhbHVlIjoiUGxGUER2Y2FVcjdaNlVSUEN6RVVwSnk2UWlFcWNSSWNSWENnSnQxTXppaG9seStsVEpyQlhueEx5bFltT1p1d3lJYnVGc ▶"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "host" => array:1 [▶
    0 => "dev.pflmma.com"
  ]
]
request_cookies
  0 of 0   
array:2 [▼
  "XSRF-TOKEN" => "1LsBDFEvlOupZbpScPaERR04sFuBMfozudITg2Fv"
  "pfl_session" => "Cbvkddp2l9W515L8FBUidkPbbzrvZuuZsJxGzzje"
]
response_headers
  0 of 0   
array:3 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Thu, 17 Apr 2025 04:29:03 GMT"
  ]
]
session_attributes
  0 of 0   
array:4 [▼
  "_token" => "1LsBDFEvlOupZbpScPaERR04sFuBMfozudITg2Fv"
  "PHPDEBUGBAR_STACK_DATA" => array:1 [▶
    "01JS103TAASCMDG0ZNEPGWHW0W" => null
  ]
  "_previous" => array:1 [▶
    "url" => "https://dev.pflmma.com/fighter/jake-childers"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
  • Booting (11.35ms)time
  • Application (147ms)time
  • Routing (1.23ms)
  • Preparing Response (65.01ms)
  • 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 (92.82%)
    147ms
    1 x Preparing Response (41.1%)
    65.01ms
    1 x Booting (7.18%)
    11.35ms
    1 x Routing (0.78%)
    1.23ms
    12 x View (0%)
    0μs
    12 templates were rendered
    • 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
    39 statements were executed (14 duplicates)Show only duplicates106ms
    • FighterController.php#1193devpflmma_webConnection Established
      Backtrace
      • app/Http/Controllers/FighterController.php:1193
      • app/Http/Controllers/FighterController.php:290
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FighterController.php#1196devpflmma_web3.82msselect * from `fighters` where LOWER(REPLACE(REPLACE(first_name, " ", ""), "'", "")) = "jake" and LOWER(REPLACE(REPLACE(last_name, " ", ""), "'", "")) = "childers" limit 1
      Backtrace
      • app/Http/Controllers/FighterController.php:1196
      • app/Http/Controllers/FighterController.php:290
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FighterController.php#315devpflmma_web1.2msselect * from `fighter_records` as `fr` left join `seasons` as `s` on `s`.`id` = `fr`.`season_id` where `fr`.`fighter_id` = 407 and `s`.`year` <> '2020' order by `s`.`year` desc limit 1
      Bindings
      • 0: 407
      • 1: 2020
      Backtrace
      • app/Http/Controllers/FighterController.php:315
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FighterController.php#317devpflmma_web570μsselect * from `seasons` where `seasons`.`id` is null limit 1
      Backtrace
      • app/Http/Controllers/FighterController.php:317
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FighterController.php#326devpflmma_web2.39msselect * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 407 and `s`.`year` <> '2020' order by `s`.`year` desc
      Bindings
      • 0: 407
      • 1: 2020
      Backtrace
      • app/Http/Controllers/FighterController.php:326
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • Functions.php#1037devpflmma_web8.86msselect * from `fighter_records` as `fr` left join `seasons` as `s` on `s`.`id` = `fr`.`season_id` where `fr`.`fighter_id` = 407 and `s`.`year` <> '2020' order by `s`.`year` desc limit 1
      Bindings
      • 0: 407
      • 1: 2020
      Backtrace
      • app/Helpers/Functions.php:1037
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • Functions.php#1039devpflmma_web1.96msselect * from `seasons` where `seasons`.`id` is null limit 1
      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_web3.51msselect * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 407 and `s`.`year` <> '2020' order by `s`.`year` desc
      Bindings
      • 0: 407
      • 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
    • FighterController.php#429devpflmma_web2.44msselect `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` 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` = 407 limit 1
      Bindings
      • 0: headshot
      • 1: App\Models\Fighter
      • 2: bodyshot
      • 3: App\Models\Fighter
      • 4: banner
      • 5: App\Models\Fighter
      • 6: 407
      Backtrace
      • app/Http/Controllers/FighterController.php:429
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FighterController.php#431devpflmma_web1.99msselect * from `fighters` where `fighters`.`id` = 407 limit 1
      Bindings
      • 0: 407
      Backtrace
      • app/Http/Controllers/FighterController.php:431
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FighterController.php#432devpflmma_web7.15ms(select * from `fight_cards` where `fight_cards`.`fighter_id` = 407 and `fight_cards`.`fighter_id` is not null) union (select * from `fight_cards` where `fight_cards`.`vs_fighter_id` = 407 and `fight_cards`.`vs_fighter_id` is not null) order by `created_at` desc
      Bindings
      • 0: 407
      • 1: 407
      Backtrace
      • app/Http/Controllers/FighterController.php:432
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • SettingEloquentStorage.php#30devpflmma_web1.89msselect `val`, `name` from `settings` where `group` = 'default'
      Bindings
      • 0: default
      Backtrace
      • vendor/qcod/laravel-settings/src/Setting/SettingEloquentStorage.php:30
      • app/Http/Controllers/FightCardController.php:434
      • app/Http/Controllers/FighterController.php:436
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • FightCardController.php#436devpflmma_web1.59msselect * from `events` where `events`.`id` = 47 limit 1
      Bindings
      • 0: 47
      Backtrace
      • app/Http/Controllers/FightCardController.php:436
      • app/Http/Controllers/FighterController.php:436
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FightCardController.php#440devpflmma_web1.41msselect * from `seasons` where `seasons`.`id` = 6 limit 1
      Bindings
      • 0: 6
      Backtrace
      • app/Http/Controllers/FightCardController.php:440
      • app/Http/Controllers/FighterController.php:436
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FightCardController.php#450devpflmma_web14.29msSELECT e.datetime AS event_datetime, 2022 AS season_year, s.season_type AS season_type, e.slug AS event_slug, fc.order_number, fc.id AS fight_card_id, fc.broadcaster, fc.winner_id, fc.match_details, fc.show_keys_to_victory, fc.show_match_details, fc.keys_to_victory AS fighter_keys_to_victory, fc.vs_keys_to_victory AS vs_fighter_keys_to_victory, fc.override_status, fc.pickem_status, IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.fighter_points, fr1.points) AS fighter_points, IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.vs_fighter_points, fr2.points) AS vs_fighter_points, fr1.points AS fighter_total_points, fr2.points AS vs_fighter_total_points, f1.gender AS fighter_gender, f2.gender AS vs_fighter_gender, f1.arm_reach AS fighter_arm_reach, f2.arm_reach AS vs_fighter_arm_reach, f1.leg_reach AS fighter_leg_reach, f2.leg_reach AS vs_fighter_leg_reach, f1.height AS fighter_height, f2.height AS vs_fighter_height, f1.weight AS fighter_weight, f2.weight AS vs_fighter_weight, fc.win_by, fc.round_time, CONCAT(f1.first_name, ' ', f1.last_name) AS fighter_name, CONCAT(f2.first_name, ' ', f2.last_name) AS vs_fighter_name, f1.first_name AS fighter_first_name, f1.last_name AS fighter_last_name, f2.first_name AS vs_fighter_first_name, f2.last_name AS vs_fighter_last_name, f1.id AS fighter_id, f2.id AS vs_fighter_id, f1.career_record AS fighter_career_record, f2.career_record AS vs_fighter_career_record, fr1.season_record AS fighter_season_record, fr2.season_record AS vs_fighter_season_record, f1.nation_flag AS fighter_nation_flag, f2.nation_flag AS vs_fighter_nation_flag, f1.challenger_highlights AS challenger_highlights, f2.challenger_highlights AS vs_challenger_highlights, fr1.ranking AS fighter_ranking, fr2.ranking AS vs_fighter_ranking, fc2.name AS weightclass, fc2.shortcode AS weightclass_shortcode, IF(fc.fighter_record<>'', fc.fighter_record, fr1.season_record) AS fighter_fight_card_record, IF(fc.vs_fighter_record<>'', fc.vs_fighter_record, fr2.season_record) AS vs_fighter_fight_card_record, b.name AS broadcast_name, b.url AS broadcast_url, fc.match_type, IF( IFNULL(m1.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m1.directory, '/', m1.filename, '.', m1.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f1.gender, '.png') ) AS fighter_thumbnail, IF( IFNULL(m2.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m2.directory, '/', m2.filename, '.', m2.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f1.gender, '.png') ) AS fighter_profile_image, IF( IFNULL(m3.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m3.directory, '/', m3.filename, '.', m3.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f2.gender, '.png') ) AS vs_fighter_thumbnail, IF( IFNULL(m4.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m4.directory, '/', m4.filename, '.', m4.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f2.gender, '.png') ) AS vs_fighter_profile_image, CONCAT('https://pflmma-dev.s3.amazonaws.com/', m5.directory, '/', m5.filename, '.', m5.extension) AS broadcast_logo, IF( IFNULL(m6.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m6.directory, '/', m6.filename, '.', m6.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f1.gender, '-left.png') ) AS fighter_bodyshot_side, IF( IFNULL(m7.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m7.directory, '/', m7.filename, '.', m7.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f2.gender, '-right.png') ) AS vs_fighter_bodyshot_side, IF( IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f1.nation_flag, '.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg') ) AS fighter_flag, IF( IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f2.nation_flag, '.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg') ) AS vs_fighter_flag, IF( IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f1.nation_flag, '_BACKDROP.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg') ) AS fighter_flag_backdrop, IF( IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f2.nation_flag, '_BACKDROP.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg') ) AS vs_fighter_flag_backdrop FROM fight_cards fc LEFT JOIN fighters f1 ON f1.id = fc.fighter_id LEFT JOIN fighters f2 ON f2.id = fc.vs_fighter_id INNER JOIN fighter_classes fc2 ON fc2.id = fc.fighter_class_id INNER JOIN events e ON e.id = fc.event_id LEFT JOIN seasons s ON e.season_id = s.id LEFT JOIN broadcasters b ON b.shortcode = fc.broadcaster LEFT JOIN fighter_records fr1 ON fr1.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 6 AND fighter_id = fc.fighter_id LIMIT 1 ) AND fr1.season_id = 6 LEFT JOIN fighter_records fr2 ON fr2.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 6 AND fighter_id = fc.vs_fighter_id LIMIT 1 ) AND fr2.season_id = 6 LEFT JOIN mediables med1 ON med1.mediable_id=f1.id AND med1.tag='headshot' AND med1.mediable_type='App\\Models\\Fighter' LEFT JOIN media m1 ON m1.id=med1.media_id LEFT JOIN mediables med2 ON med2.mediable_id=f1.id AND med2.tag='bodyshot' AND med2.mediable_type='App\\Models\\Fighter' LEFT JOIN media m2 ON m2.id=med2.media_id LEFT JOIN mediables med3 ON med3.mediable_id=f2.id AND med3.tag='headshot' AND med3.mediable_type='App\\Models\\Fighter' LEFT JOIN media m3 ON m3.id=med3.media_id LEFT JOIN mediables med4 ON med4.mediable_id=f2.id AND med4.tag='bodyshot' AND med4.mediable_type='App\\Models\\Fighter' LEFT JOIN media m4 ON m4.id=med4.media_id LEFT JOIN mediables med5 ON med5.mediable_id=b.id AND med5.tag='logo' AND med5.mediable_type='App\\Models\\Broadcaster' LEFT JOIN media m5 ON m5.id=med5.media_id LEFT JOIN mediables med6 ON med6.mediable_id=fc.id AND med6.tag='fighter_bodyshot_side_left' AND med6.mediable_type='App\\Models\\FightCard' LEFT JOIN media m6 ON m6.id=med6.media_id LEFT JOIN mediables med7 ON med7.mediable_id=fc.id AND med7.tag='fighter_bodyshot_side_right' AND med7.mediable_type='App\\Models\\FightCard' LEFT JOIN media m7 ON m7.id=med7.media_id WHERE e.slug = '2022-pfl-4' AND (fc.fighter_id=407 OR fc.vs_fighter_id=407) ORDER BY fc.order_number ASC
      Backtrace
      • app/Http/Controllers/FightCardController.php:450
      • app/Http/Controllers/FighterController.php:436
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • WidgetController.php#464devpflmma_web1.08msselect * from `fighters` where `fighters`.`id` = 407 limit 1
      Bindings
      • 0: 407
      Backtrace
      • app/Http/Controllers/WidgetController.php:464
      • app/Http/Controllers/FighterController.php:447
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • WidgetController.php#471devpflmma_web3.79msselect `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` = 407 and `article_tags`.`article_tag_type` = 'App\\Models\\Fighter' order by `created_at` desc
      Bindings
      • 0: 407
      • 1: App\Models\Fighter
      Backtrace
      • app/Http/Controllers/WidgetController.php:471
      • app/Http/Controllers/FighterController.php:447
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • WidgetController.php#500devpflmma_web1.67msselect * from `fighters` where `fighters`.`id` = 407 limit 1
      Bindings
      • 0: 407
      Backtrace
      • app/Http/Controllers/WidgetController.php:500
      • app/Http/Controllers/FighterController.php:448
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • WidgetController.php#507devpflmma_web4.45msselect `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` = 407 and `video_tags`.`video_tag_type` = 'App\\Models\\Fighter' order by `created_at` desc
      Bindings
      • 0: 407
      • 1: App\Models\Fighter
      Backtrace
      • app/Http/Controllers/WidgetController.php:507
      • app/Http/Controllers/FighterController.php:448
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • FighterController.php#451devpflmma_web1.2msselect * from `seasons` where `season_type` = 'regular' order by `year` desc limit 1
      Bindings
      • 0: regular
      Backtrace
      • app/Http/Controllers/FighterController.php:451
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • FighterController.php#459devpflmma_web5.16msSELECT 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=407 OR fc.vs_fighter_id=407) AND e.datetime>='2025-04-17 00:29:03' AND e.event_status = 'scheduled' ORDER BY fc.order_number ASC
      Backtrace
      • app/Http/Controllers/FighterController.php:459
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • SettingEloquentStorage.php#30devpflmma_web4.06msselect `val`, `name` from `settings` where `group` = 'default'
      Bindings
      • 0: default
      Backtrace
      • vendor/qcod/laravel-settings/src/Setting/SettingEloquentStorage.php:30
      • view::components.countdown-timer:23
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • SettingEloquentStorage.php#30devpflmma_web2.68msselect `val`, `name` from `settings` where `group` = 'default'
      Bindings
      • 0: default
      Backtrace
      • vendor/qcod/laravel-settings/src/Setting/SettingEloquentStorage.php:30
      • view::components.countdown-timer:24
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • SettingEloquentStorage.php#30devpflmma_web2.07msselect `val`, `name` from `settings` where `group` = 'default'
      Bindings
      • 0: default
      Backtrace
      • vendor/qcod/laravel-settings/src/Setting/SettingEloquentStorage.php:30
      • view::components.countdown-timer:25
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • SettingEloquentStorage.php#30devpflmma_web3.39msselect `val`, `name` from `settings` where `group` = 'default'
      Bindings
      • 0: default
      Backtrace
      • vendor/qcod/laravel-settings/src/Setting/SettingEloquentStorage.php:30
      • app/Helpers/Functions.php:470
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • Functions.php#473devpflmma_web1.5msselect * from `media` where `media`.`id` = '26718' limit 1
      Bindings
      • 0: 26718
      Backtrace
      • app/Helpers/Functions.php:473
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • Functions.php#482devpflmma_web3.38msselect * from `media` where `media`.`id` = '24074' limit 1
      Bindings
      • 0: 24074
      Backtrace
      • app/Helpers/Functions.php:482
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • Functions.php#488devpflmma_web2.18msselect * from `media` where `media`.`id` = '24072' limit 1
      Bindings
      • 0: 24072
      Backtrace
      • app/Helpers/Functions.php:488
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • Functions.php#494devpflmma_web1.71msselect * from `media` where `media`.`id` = '24075' limit 1
      Bindings
      • 0: 24075
      Backtrace
      • app/Helpers/Functions.php:494
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • Functions.php#518devpflmma_web2.38msselect * from `media` where `media`.`id` = '27787' limit 1
      Bindings
      • 0: 27787
      Backtrace
      • app/Helpers/Functions.php:518
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • Functions.php#524devpflmma_web700μsselect * from `media` where `media`.`id` = '23575' limit 1
      Bindings
      • 0: 23575
      Backtrace
      • app/Helpers/Functions.php:524
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • Functions.php#530devpflmma_web720μsselect * from `media` where `media`.`id` = '23576' limit 1
      Bindings
      • 0: 23576
      Backtrace
      • app/Helpers/Functions.php:530
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • Functions.php#536devpflmma_web770μsselect * from `media` where `media`.`id` = '27603' limit 1
      Bindings
      • 0: 27603
      Backtrace
      • app/Helpers/Functions.php:536
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • Functions.php#542devpflmma_web1.24msselect * from `media` where `media`.`id` = '27604' limit 1
      Bindings
      • 0: 27604
      Backtrace
      • app/Helpers/Functions.php:542
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • Functions.php#548devpflmma_web5.21msselect * from `media` where `media`.`id` = '27605' limit 1
      Bindings
      • 0: 27605
      Backtrace
      • app/Helpers/Functions.php:548
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • Functions.php#554devpflmma_web810μsselect * from `media` where `media`.`id` = '27606' limit 1
      Bindings
      • 0: 27606
      Backtrace
      • app/Helpers/Functions.php:554
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • Functions.php#560devpflmma_web660μsselect * from `media` where `media`.`id` = '26409' limit 1
      Bindings
      • 0: 26409
      Backtrace
      • app/Helpers/Functions.php:560
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • Functions.php#566devpflmma_web680μsselect * from `media` where `media`.`id` = '26408' limit 1
      Bindings
      • 0: 26408
      Backtrace
      • app/Helpers/Functions.php:566
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • Functions.php#572devpflmma_web650μsselect * from `media` where `media`.`id` = '26407' limit 1
      Bindings
      • 0: 26407
      Backtrace
      • app/Helpers/Functions.php:572
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    • Functions.php#578devpflmma_web750μsselect * from `media` where `media`.`id` = '26540' limit 1
      Bindings
      • 0: 26540
      Backtrace
      • app/Helpers/Functions.php:578
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • vendor/laravel/framework/src/Illuminate/View/View.php:207
    Plank\Mediable\Media
    15Media.php#?
    App\Models\Fighter
    4Fighter.php#?
    App\Models\Season
    2Season.php#?
    App\Models\FightCard
    1FightCard.php#?
    App\Models\Event
    1Event.php#?
        ClearShow all
        Date ↕MethodURLData
        #12025-04-17 00:29:03GET/fighter/jake-childers (stacked)
        #22025-04-17 00:29:03GET/regular-fighter/jake-childers1123923