Oxford College / Baku

Messages Timeline Exceptions Views0 Route Queries3 Mails Gate Session Request

7.3.31-1+ubuntu18.04.1+deb.sury.org+1219.94ms19.14MBGET en/references/{reference_category?}/{reference?}

Booting (163.13ms)
Application (55.31ms)

0 templates were rendered

uri: GET en/references/{reference_category?}/{reference?}
middleware: web, localeSessionRedirect, localizationRedirect, localeViewPath
controller: App\Http\Controllers\User\PublicController@references
namespace: App\Http\Controllers\User
prefix: /en
where
as: references
file: app/Http/Controllers/User/PublicController.php:284-335

3 statements were executed4.26ms

select * from `reference_categories` where exists (select * from `reference_category_translations` where `reference_categories`.`id` = `reference_category_translations`.`reference_category_id` and `locale` = 'en' and `slug` = 'school-dormitory') or exists (select * from `reference_category_translations` where `reference_categories`.`id` = `reference_category_translations`.`reference_category_id` and `locale` = 'tr' and `slug` = 'school-dormitory') limit 1

2.16ms/app/Providers/RouteServiceProvider.php:91forge

Metadata
Bindings	0. en 1. school-dormitory 2. tr 3. school-dormitory
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/Providers/RouteServiceProvider.php:91 18. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:770 19. Route binding:37 20. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 21. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 22. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 24. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 25. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 26. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 27. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 30. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 31. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 32. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 33. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 34. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 36. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 37. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 39. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:657 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:623 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:612 42. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /vendor/spatie/laravel-honeypot/src/ProtectAgainstSpam.php:29 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `references` where exists (select * from `reference_translations` where `references`.`id` = `reference_translations`.`reference_id` and `locale` = 'en' and `slug` = 'oxford-college-baku') or exists (select * from `reference_translations` where `references`.`id` = `reference_translations`.`reference_id` and `locale` = 'tr' and `slug` = 'oxford-college-baku') limit 1

1.39ms/app/Providers/RouteServiceProvider.php:99forge

Metadata
Bindings	0. en 1. oxford-college-baku 2. tr 3. oxford-college-baku
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/Providers/RouteServiceProvider.php:99 18. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:770 19. Route binding:37 20. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 21. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 22. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 24. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 25. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 26. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 27. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 28. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 30. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 31. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 32. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 33. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 34. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 36. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 37. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 39. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:657 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:623 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:612 42. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /vendor/spatie/laravel-honeypot/src/ProtectAgainstSpam.php:29 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `media` where `media`.`model_id` in (38) and `media`.`model_type` = 'App\Models\Reference' order by `order_column` asc

710μs/app/Providers/RouteServiceProvider.php:99forge

Metadata
Bindings	0. App\Models\Reference
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /app/Providers/RouteServiceProvider.php:99 23. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:770 24. Route binding:37 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 26. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 27. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 28. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 29. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 30. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 32. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 33. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 35. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 36. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 37. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 38. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 39. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 41. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:657 45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:623 46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:612 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176 48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30

_token: lcsl4eaSeqhnjWDme6BXhxHXAbelb7TQc5co7rwS
locale: ru
_previous: array:1 [ "url" => "https://www.solenne.com.tr/index.php/en/references/school-dormitory/oxford-col...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/en/references/school-dormitory/oxford-college-baku

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:18 [▶
  "cookie" => array:1 [▶
    0 => "_fbp=fb.2.1752446524514.472486008233717922; XSRF-TOKEN=eyJpdiI6IlZ2RmdMSE54QXNGeG1veWRZUU9wOWc9PSIsInZhbHVlIjoiUk5KdXJcLzU1YklJXC8yN0V3MndcL3NRQ1BCS1o1R3hzcjVINVZockxGVXNuRXdHRXBcL29SVHJaeHEzSWZlcFwvNFNPIiwibWFjIjoiYmMzMTMyMWQ1MWZlYzlkZmViZGYzOWMwMTc3OTE2ZGM1OTBhYzYzZTU4YWJjM2NmMTk5ODhiZDQ2ZmQzYmNjNSJ9; laravel_session=eyJpdiI6IlowU2JMYUFXQ21qRWI4MnVtdWxHU3c9PSIsInZhbHVlIjoiK2g4ZnlUN3FoeVJZSnBtOVdSRHRENWdzeWJjZHJcL0RiNEZBV3RCZzQ5ZFp2VE5OSG5ramRkNU11MTJ1OEU1c2IiLCJtYWMiOiI5NzQwZmM1YmE4ZTk5ZjI3YjQzNzNhYmRlNDAxNTIwODgzOTM5Yzc1NmIzZTZjNTc5ZDYxZjcyZTQzOWE4YmViIn0%3D ◀_fbp=fb.2.1752446524514.472486008233717922; XSRF-TOKEN=eyJpdiI6IlZ2RmdMSE54QXNGeG1veWRZUU9wOWc9PSIsInZhbHVlIjoiUk5KdXJcLzU1YklJXC8yN0V3MndcL3NRQ1BCS1o1R3hzcjVIN ▶"
  ]
  "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 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "host" => array:1 [▶
    0 => "www.solenne.com.tr"
  ]
  "content-length" => array:1 [▶
    0 => ""
  ]
  "content-type" => array:1 [▶
    0 => ""
  ]
]

request_server

  0 of 0   
array:41 [▶
  "USER" => "forge"
  "HOME" => "/home/forge"
  "HTTP_COOKIE" => "_fbp=fb.2.1752446524514.472486008233717922; XSRF-TOKEN=eyJpdiI6IlZ2RmdMSE54QXNGeG1veWRZUU9wOWc9PSIsInZhbHVlIjoiUk5KdXJcLzU1YklJXC8yN0V3MndcL3NRQ1BCS1o1R3hzcjVINVZockxGVXNuRXdHRXBcL29SVHJaeHEzSWZlcFwvNFNPIiwibWFjIjoiYmMzMTMyMWQ1MWZlYzlkZmViZGYzOWMwMTc3OTE2ZGM1OTBhYzYzZTU4YWJjM2NmMTk5ODhiZDQ2ZmQzYmNjNSJ9; laravel_session=eyJpdiI6IlowU2JMYUFXQ21qRWI4MnVtdWxHU3c9PSIsInZhbHVlIjoiK2g4ZnlUN3FoeVJZSnBtOVdSRHRENWdzeWJjZHJcL0RiNEZBV3RCZzQ5ZFp2VE5OSG5ramRkNU11MTJ1OEU1c2IiLCJtYWMiOiI5NzQwZmM1YmE4ZTk5ZjI3YjQzNzNhYmRlNDAxNTIwODgzOTM5Yzc1NmIzZTZjNTc5ZDYxZjcyZTQzOWE4YmViIn0%3D ◀_fbp=fb.2.1752446524514.472486008233717922; XSRF-TOKEN=eyJpdiI6IlZ2RmdMSE54QXNGeG1veWRZUU9wOWc9PSIsInZhbHVlIjoiUk5KdXJcLzU1YklJXC8yN0V3MndcL3NRQ1BCS1o1R3hzcjVIN ▶"
  "HTTP_PRIORITY" => "u=0, i"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_ACCEPT" => "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"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_HOST" => "www.solenne.com.tr"
  "REDIRECT_STATUS" => "200"
  "HTTPS" => "on"
  "SERVER_NAME" => "www.solenne.com.tr"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "165.22.31.207"
  "REMOTE_PORT" => "56487"
  "REMOTE_ADDR" => "216.73.216.187"
  "SERVER_SOFTWARE" => "nginx/1.15.8"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/2.0"
  "DOCUMENT_ROOT" => "/home/forge/www.solenne.com.tr/public"
  "DOCUMENT_URI" => "/index.php"
  "REQUEST_URI" => "/index.php/en/references/school-dormitory/oxford-college-baku"
  "SCRIPT_NAME" => "/index.php"
  "SCRIPT_FILENAME" => "/home/forge/www.solenne.com.tr/public/index.php"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1752446525.1716
  "REQUEST_TIME" => 1752446525
]

request_cookies

  0 of 0   
array:3 [▶
  "_fbp" => null
  "XSRF-TOKEN" => "lcsl4eaSeqhnjWDme6BXhxHXAbelb7TQc5co7rwS"
  "laravel_session" => "zC9w9CkEoPUX0UdBcChhvfjhV0rA41CoohcR2Cp2"
]

response_headers

  0 of 0   
array:6 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 13 Jul 2025 16:12:47 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "laravel-responsecache" => array:1 [▶
    0 => "Sun, 13 Jul 2025 19:12:47 +0300"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im0xVTBGRVZCVVg3OEJ2eVAzR1F6dkE9PSIsInZhbHVlIjoianczWjI0bEZYNVwva1VsK1NvOFphNDJGeXhmV3JIUVFOenJMQWRxZUtUK3h6Qk1DUkhta0czNXhLVTdFckRvbDEiLCJtYWMiOiJlMWNmMzU2MGRhMDFmZjQyMjA5ZGI4MGZhNWU5NTRjN2QyZmNmZmQxZmNlN2I3MzhlOTdmN2M4Mzg1MTQzMDI1In0%3D; expires=Mon, 14-Jul-2025 00:42:05 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6Im0xVTBGRVZCVVg3OEJ2eVAzR1F6dkE9PSIsInZhbHVlIjoianczWjI0bEZYNVwva1VsK1NvOFphNDJGeXhmV3JIUVFOenJMQWRxZUtUK3h6Qk1DUkhta0czNXhLVTdFckRvbDEiLCJtY ▶"
    1 => "laravel_session=eyJpdiI6IkdoNE5hSmpNaGMyYXdPNjYxamJCYmc9PSIsInZhbHVlIjoiQ1JPd2RMVG5qQkh1SzJQNDdDY29lNmE0c0lBZ3hZWGx5R0ludThXZUhxSVRWSUdBWnlDSHUxV0ZqeEpnaUtpdyIsIm1hYyI6IjE1NmM3ZGFjNzllZTU4NDA5ZWIzZDdkZGNiN2Y4MWYyNjMwNzJiNzBhNjg2NzYwODEwNWNiYjgwOWQ0MzkyMzQifQ%3D%3D; expires=Mon, 14-Jul-2025 00:42:05 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6IkdoNE5hSmpNaGMyYXdPNjYxamJCYmc9PSIsInZhbHVlIjoiQ1JPd2RMVG5qQkh1SzJQNDdDY29lNmE0c0lBZ3hZWGx5R0ludThXZUhxSVRWSUdBWnlDSHUxV0ZqeEpnaUtpdyIs ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im0xVTBGRVZCVVg3OEJ2eVAzR1F6dkE9PSIsInZhbHVlIjoianczWjI0bEZYNVwva1VsK1NvOFphNDJGeXhmV3JIUVFOenJMQWRxZUtUK3h6Qk1DUkhta0czNXhLVTdFckRvbDEiLCJtYWMiOiJlMWNmMzU2MGRhMDFmZjQyMjA5ZGI4MGZhNWU5NTRjN2QyZmNmZmQxZmNlN2I3MzhlOTdmN2M4Mzg1MTQzMDI1In0%3D; expires=Mon, 14-Jul-2025 00:42:05 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Im0xVTBGRVZCVVg3OEJ2eVAzR1F6dkE9PSIsInZhbHVlIjoianczWjI0bEZYNVwva1VsK1NvOFphNDJGeXhmV3JIUVFOenJMQWRxZUtUK3h6Qk1DUkhta0czNXhLVTdFckRvbDEiLCJtY ▶"
    1 => "laravel_session=eyJpdiI6IkdoNE5hSmpNaGMyYXdPNjYxamJCYmc9PSIsInZhbHVlIjoiQ1JPd2RMVG5qQkh1SzJQNDdDY29lNmE0c0lBZ3hZWGx5R0ludThXZUhxSVRWSUdBWnlDSHUxV0ZqeEpnaUtpdyIsIm1hYyI6IjE1NmM3ZGFjNzllZTU4NDA5ZWIzZDdkZGNiN2Y4MWYyNjMwNzJiNzBhNjg2NzYwODEwNWNiYjgwOWQ0MzkyMzQifQ%3D%3D; expires=Mon, 14-Jul-2025 00:42:05 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IkdoNE5hSmpNaGMyYXdPNjYxamJCYmc9PSIsInZhbHVlIjoiQ1JPd2RMVG5qQkh1SzJQNDdDY29lNmE0c0lBZ3hZWGx5R0ludThXZUhxSVRWSUdBWnlDSHUxV0ZqeEpnaUtpdyIs ▶"
  ]
]

session_attributes

  0 of 0   
array:5 [▶
  "_token" => "lcsl4eaSeqhnjWDme6BXhxHXAbelb7TQc5co7rwS"
  "locale" => "ru"
  "_previous" => array:1 [▶
    "url" => "https://www.solenne.com.tr/index.php/en/references/school-dormitory/oxford-college-baku"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Proje Detayları

Corporate

Useful Links

Office Furnitures