Test

PROFESSIONAL FIGHTERS LEAGUE

Leandro Silva

Career Record: 25-10-1, 1 NC

Fight Results

Messages1Request302 FoundTimelineExceptionsViews12Queries39Models23MailsGate
SettingsRequest history2101msRequest 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/leandro-silva
action_name
fighter.show
controller_action
App\Http\Controllers\FighterController@show
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
  • warninglog[02:47:25] 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/leandro-silva
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
105ms
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=eyJpdiI6Inl4VkJIKytBNHdyc1Jpd3lJSWJOT0E9PSIsInZhbHVlIjoieEpNMHpPME9QbGFKbkZHOUFWeHIybWg3dEpKR29tOEJyWXd5OXlFd3hjNW9BS1ZMNHExWlJwb0p4WHJMbHdkR0lwb1VuMmwvMk4zOXhpVEh4ODVVbjBheXFNemsrODEwK0lUNXlUa2pxYU1sTWVQUW1aNVpLYTcrYzFiUDRCOVkiLCJtYWMiOiIyMWJmYzg5YTJmYzA1YzU3MGJjYmIzYTg1OTU3ZTFhNmFhM2VkYzZhZjA4NmFmYWQ2MDZlY2M2MThmOThjZWEzIiwidGFnIjoiIn0%3D; pfl_session=eyJpdiI6ImFlV1kvSkVldXB3akt3VGpNenpwa0E9PSIsInZhbHVlIjoiZkk5Zi9CL3QxbUI5dDFjRnVJMzZwcWovbjdOR3B3cUdvbUlNNEdXbkRLUlNWWk52Q3grTDU0UkZ1a0xhNXpTUCs2VHJTVWMyaUVNQmpQcnRLNndTUTNxL3ZNQzY0aGpMSnVmRDJ4M3dOSXVzd01QQlZQU0RyOG9BMVIvSHZTTGQiLCJtYWMiOiIwNzYzNDJkMzhkYjQyMzBhNjAxOGJiMzM4ZTMyMWUyOGY1MWUwMzhkMWEyYzJjMGViYTk4NDcwMTA4YmM0NTYxIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6Inl4VkJIKytBNHdyc1Jpd3lJSWJOT0E9PSIsInZhbHVlIjoieEpNMHpPME9QbGFKbkZHOUFWeHIybWg3dEpKR29tOEJyWXd5OXlFd3hjNW9BS1ZMNHExWlJwb0p4WHJMbHdkR0lwb1VuM ▶"
  ]
  "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" => "f3TpYLO3EMfbOFmdWzOKzwbPb4u3Cpqpe8CTOclN"
  "pfl_session" => "ttxh3wv7abv9LvmtGMErdcoDJZV0Ft67xL6duffB"
]
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 06:47:25 GMT"
  ]
]
session_attributes
  0 of 0   
array:4 [▼
  "_token" => "f3TpYLO3EMfbOFmdWzOKzwbPb4u3Cpqpe8CTOclN"
  "PHPDEBUGBAR_STACK_DATA" => array:1 [▶
    "01JS1815PAGHRV9T0R8PNWT3D6" => null
  ]
  "_previous" => array:1 [▶
    "url" => "https://dev.pflmma.com/fighter/leandro-silva"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
  • Booting (11.33ms)time
  • Application (90.14ms)time
  • Routing (1.2ms)
  • Preparing Response (43.18ms)
  • 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 (88.83%)
    90.14ms
    1 x Preparing Response (42.55%)
    43.18ms
    1 x Booting (11.17%)
    11.33ms
    1 x Routing (1.18%)
    1.20ms
    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 duplicates50.21ms
    • 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.44msselect * from `fighters` where LOWER(REPLACE(REPLACE(first_name, " ", ""), "'", "")) = "leandro" and LOWER(REPLACE(REPLACE(last_name, " ", ""), "'", "")) = "silva" 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.14msselect * from `fighter_records` as `fr` left join `seasons` as `s` on `s`.`id` = `fr`.`season_id` where `fr`.`fighter_id` = 308 and `s`.`year` <> '2020' order by `s`.`year` desc limit 1
      Bindings
      • 0: 308
      • 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_web590μ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_web1.18msselect * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 308 and `s`.`year` <> '2020' order by `s`.`year` desc
      Bindings
      • 0: 308
      • 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_web3.48msselect * from `fighter_records` as `fr` left join `seasons` as `s` on `s`.`id` = `fr`.`season_id` where `fr`.`fighter_id` = 308 and `s`.`year` <> '2020' order by `s`.`year` desc limit 1
      Bindings
      • 0: 308
      • 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_web2.58msselect * 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.73msselect * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 308 and `s`.`year` <> '2020' order by `s`.`year` desc
      Bindings
      • 0: 308
      • 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.61msselect `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` = 308 limit 1
      Bindings
      • 0: headshot
      • 1: App\Models\Fighter
      • 2: bodyshot
      • 3: App\Models\Fighter
      • 4: banner
      • 5: App\Models\Fighter
      • 6: 308
      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.09msselect * from `fighters` where `fighters`.`id` = 308 limit 1
      Bindings
      • 0: 308
      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_web6.06ms(select * from `fight_cards` where `fight_cards`.`fighter_id` = 308 and `fight_cards`.`fighter_id` is not null) union (select * from `fight_cards` where `fight_cards`.`vs_fighter_id` = 308 and `fight_cards`.`vs_fighter_id` is not null) order by `created_at` desc
      Bindings
      • 0: 308
      • 1: 308
      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_web710μsselect `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_web620μsselect * from `events` where `events`.`id` = 31 limit 1
      Bindings
      • 0: 31
      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_web590μsselect * from `seasons` where `seasons`.`id` = 4 limit 1
      Bindings
      • 0: 4
      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_web3.31msSELECT e.datetime AS event_datetime, 2021 AS season_year, s.season_type AS season_type, e.slug AS event_slug, fc.order_number, fc.id AS fight_card_id, fc.broadcaster, fc.winner_id, fc.match_details, fc.show_keys_to_victory, fc.show_match_details, fc.keys_to_victory AS fighter_keys_to_victory, fc.vs_keys_to_victory AS vs_fighter_keys_to_victory, fc.override_status, fc.pickem_status, IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.fighter_points, fr1.points) AS fighter_points, IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.vs_fighter_points, fr2.points) AS vs_fighter_points, fr1.points AS fighter_total_points, fr2.points AS vs_fighter_total_points, f1.gender AS fighter_gender, f2.gender AS vs_fighter_gender, f1.arm_reach AS fighter_arm_reach, f2.arm_reach AS vs_fighter_arm_reach, f1.leg_reach AS fighter_leg_reach, f2.leg_reach AS vs_fighter_leg_reach, f1.height AS fighter_height, f2.height AS vs_fighter_height, f1.weight AS fighter_weight, f2.weight AS vs_fighter_weight, fc.win_by, fc.round_time, CONCAT(f1.first_name, ' ', f1.last_name) AS fighter_name, CONCAT(f2.first_name, ' ', f2.last_name) AS vs_fighter_name, f1.first_name AS fighter_first_name, f1.last_name AS fighter_last_name, f2.first_name AS vs_fighter_first_name, f2.last_name AS vs_fighter_last_name, f1.id AS fighter_id, f2.id AS vs_fighter_id, f1.career_record AS fighter_career_record, f2.career_record AS vs_fighter_career_record, fr1.season_record AS fighter_season_record, fr2.season_record AS vs_fighter_season_record, f1.nation_flag AS fighter_nation_flag, f2.nation_flag AS vs_fighter_nation_flag, f1.challenger_highlights AS challenger_highlights, f2.challenger_highlights AS vs_challenger_highlights, fr1.ranking AS fighter_ranking, fr2.ranking AS vs_fighter_ranking, fc2.name AS weightclass, fc2.shortcode AS weightclass_shortcode, IF(fc.fighter_record<>'', fc.fighter_record, fr1.season_record) AS fighter_fight_card_record, IF(fc.vs_fighter_record<>'', fc.vs_fighter_record, fr2.season_record) AS vs_fighter_fight_card_record, b.name AS broadcast_name, b.url AS broadcast_url, fc.match_type, IF( IFNULL(m1.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m1.directory, '/', m1.filename, '.', m1.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f1.gender, '.png') ) AS fighter_thumbnail, IF( IFNULL(m2.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m2.directory, '/', m2.filename, '.', m2.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f1.gender, '.png') ) AS fighter_profile_image, IF( IFNULL(m3.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m3.directory, '/', m3.filename, '.', m3.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f2.gender, '.png') ) AS vs_fighter_thumbnail, IF( IFNULL(m4.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m4.directory, '/', m4.filename, '.', m4.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f2.gender, '.png') ) AS vs_fighter_profile_image, CONCAT('https://pflmma-dev.s3.amazonaws.com/', m5.directory, '/', m5.filename, '.', m5.extension) AS broadcast_logo, IF( IFNULL(m6.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m6.directory, '/', m6.filename, '.', m6.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f1.gender, '-left.png') ) AS fighter_bodyshot_side, IF( IFNULL(m7.filename, '')<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/', m7.directory, '/', m7.filename, '.', m7.extension), CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f2.gender, '-right.png') ) AS vs_fighter_bodyshot_side, IF( IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f1.nation_flag, '.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg') ) AS fighter_flag, IF( IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f2.nation_flag, '.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg') ) AS vs_fighter_flag, IF( IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f1.nation_flag, '_BACKDROP.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg') ) AS fighter_flag_backdrop, IF( IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'', CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f2.nation_flag, '_BACKDROP.jpg'), CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg') ) AS vs_fighter_flag_backdrop FROM fight_cards fc LEFT JOIN fighters f1 ON f1.id = fc.fighter_id LEFT JOIN fighters f2 ON f2.id = fc.vs_fighter_id INNER JOIN fighter_classes fc2 ON fc2.id = fc.fighter_class_id INNER JOIN events e ON e.id = fc.event_id LEFT JOIN seasons s ON e.season_id = s.id LEFT JOIN broadcasters b ON b.shortcode = fc.broadcaster LEFT JOIN fighter_records fr1 ON fr1.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 4 AND fighter_id = fc.fighter_id LIMIT 1 ) AND fr1.season_id = 4 LEFT JOIN fighter_records fr2 ON fr2.fighter_id = ( SELECT MIN(id) FROM fighter_records WHERE season_id = 4 AND fighter_id = fc.vs_fighter_id LIMIT 1 ) AND fr2.season_id = 4 LEFT JOIN mediables med1 ON med1.mediable_id=f1.id AND med1.tag='headshot' AND med1.mediable_type='App\\Models\\Fighter' LEFT JOIN media m1 ON m1.id=med1.media_id LEFT JOIN mediables med2 ON med2.mediable_id=f1.id AND med2.tag='bodyshot' AND med2.mediable_type='App\\Models\\Fighter' LEFT JOIN media m2 ON m2.id=med2.media_id LEFT JOIN mediables med3 ON med3.mediable_id=f2.id AND med3.tag='headshot' AND med3.mediable_type='App\\Models\\Fighter' LEFT JOIN media m3 ON m3.id=med3.media_id LEFT JOIN mediables med4 ON med4.mediable_id=f2.id AND med4.tag='bodyshot' AND med4.mediable_type='App\\Models\\Fighter' LEFT JOIN media m4 ON m4.id=med4.media_id LEFT JOIN mediables med5 ON med5.mediable_id=b.id AND med5.tag='logo' AND med5.mediable_type='App\\Models\\Broadcaster' LEFT JOIN media m5 ON m5.id=med5.media_id LEFT JOIN mediables med6 ON med6.mediable_id=fc.id AND med6.tag='fighter_bodyshot_side_left' AND med6.mediable_type='App\\Models\\FightCard' LEFT JOIN media m6 ON m6.id=med6.media_id LEFT JOIN mediables med7 ON med7.mediable_id=fc.id AND med7.tag='fighter_bodyshot_side_right' AND med7.mediable_type='App\\Models\\FightCard' LEFT JOIN media m7 ON m7.id=med7.media_id WHERE e.slug = '2021-pfl-7' AND (fc.fighter_id=308 OR fc.vs_fighter_id=308) 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_web630μsselect * from `fighters` where `fighters`.`id` = 308 limit 1
      Bindings
      • 0: 308
      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_web960μsselect `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` = 308 and `article_tags`.`article_tag_type` = 'App\\Models\\Fighter' order by `created_at` desc
      Bindings
      • 0: 308
      • 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_web610μsselect * from `fighters` where `fighters`.`id` = 308 limit 1
      Bindings
      • 0: 308
      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_web920μsselect `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` = 308 and `video_tags`.`video_tag_type` = 'App\\Models\\Fighter' order by `created_at` desc
      Bindings
      • 0: 308
      • 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_web570μsselect * 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_web1.12msSELECT 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=308 OR fc.vs_fighter_id=308) AND e.datetime>='2025-04-17 02:47:25' 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_web900μsselect `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_web760μsselect `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_web740μsselect `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_web870μsselect `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_web720μsselect * 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_web1.97msselect * 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_web680μsselect * 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_web610μsselect * 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_web620μsselect * 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_web670μ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_web580μ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_web580μ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_web570μsselect * 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_web610μsselect * 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_web680μ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_web610μ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_web730μ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_web690μ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_web680μ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 02:47:25GET/fighter/leandro-silva (stacked)
        #22025-04-17 02:47:25GET/regular-fighter/leandro-silva1123923