Club Privilèges by BIGDeal

Messages Timeline Exceptions Views9 Route Queries9 Models1 Mails Gate Session Request

7.3.3391.05ms8MBGET p/{slug}

Booting (26.73ms)
Application (64.31ms)
1 x Application (70.63%)
64.31ms
1 x Booting (29.36%)
26.73ms

9 templates were rendered

bigdeal.details (resources/views/bigdeal/details.blade.php)6blade
Params
0
partner
1
partner_category
2
promotion
3
partner_location
4
statistics
5
pages

Params
0	`partner`
1	`partner_category`
2	`promotion`
3	`partner_location`
4	`statistics`
5	`pages`

bigdeal.components.top-bar (resources/views/bigdeal/components/top-bar.blade.php)12blade


obLevel
__env
app
uncontacted_manager_partner
nbr_manager_partner
errors
partner
partner_category
promotion
partner_location
statistics
pages

Params
0	`obLevel`
1	`__env`
2	`app`
3	`uncontacted_manager_partner`
4	`nbr_manager_partner`
5	`errors`
6	`partner`
7	`partner_category`
8	`promotion`
9	`partner_location`
10	`statistics`
11	`pages`

layouts.fo-bigdeal-pages (resources/views/layouts/fo-bigdeal-pages.blade.php)23blade


obLevel
__env
app
uncontacted_manager_partner
nbr_manager_partner
errors
partner
partner_category
promotion
partner_location
statistics
pages
__currentLoopData
item
loop
oh
k
times
key
time
i
loc
page_title

Params
0	`obLevel`
1	`__env`
2	`app`
3	`uncontacted_manager_partner`
4	`nbr_manager_partner`
5	`errors`
6	`partner`
7	`partner_category`
8	`promotion`
9	`partner_location`
10	`statistics`
11	`pages`
12	`__currentLoopData`
13	`item`
14	`loop`
15	`oh`
16	`k`
17	`times`
18	`key`
19	`time`
20	`i`
21	`loc`
22	`page_title`

layouts.components.tag-manager (resources/views/layouts/components/tag-manager.blade.php)23blade


obLevel
__env
app
uncontacted_manager_partner
nbr_manager_partner
errors
partner
partner_category
promotion
partner_location
statistics
pages
__currentLoopData
item
loop
oh
k
times
key
time
i
loc
page_title

Params
0	`obLevel`
1	`__env`
2	`app`
3	`uncontacted_manager_partner`
4	`nbr_manager_partner`
5	`errors`
6	`partner`
7	`partner_category`
8	`promotion`
9	`partner_location`
10	`statistics`
11	`pages`
12	`__currentLoopData`
13	`item`
14	`loop`
15	`oh`
16	`k`
17	`times`
18	`key`
19	`time`
20	`i`
21	`loc`
22	`page_title`

layouts.components.meta (resources/views/layouts/components/meta.blade.php)23blade


obLevel
__env
app
uncontacted_manager_partner
nbr_manager_partner
errors
partner
partner_category
promotion
partner_location
statistics
pages
__currentLoopData
item
loop
oh
k
times
key
time
i
loc
page_title

Params
0	`obLevel`
1	`__env`
2	`app`
3	`uncontacted_manager_partner`
4	`nbr_manager_partner`
5	`errors`
6	`partner`
7	`partner_category`
8	`promotion`
9	`partner_location`
10	`statistics`
11	`pages`
12	`__currentLoopData`
13	`item`
14	`loop`
15	`oh`
16	`k`
17	`times`
18	`key`
19	`time`
20	`i`
21	`loc`
22	`page_title`

layouts.components.favicons (resources/views/layouts/components/favicons.blade.php)23blade


obLevel
__env
app
uncontacted_manager_partner
nbr_manager_partner
errors
partner
partner_category
promotion
partner_location
statistics
pages
__currentLoopData
item
loop
oh
k
times
key
time
i
loc
page_title

Params
0	`obLevel`
1	`__env`
2	`app`
3	`uncontacted_manager_partner`
4	`nbr_manager_partner`
5	`errors`
6	`partner`
7	`partner_category`
8	`promotion`
9	`partner_location`
10	`statistics`
11	`pages`
12	`__currentLoopData`
13	`item`
14	`loop`
15	`oh`
16	`k`
17	`times`
18	`key`
19	`time`
20	`i`
21	`loc`
22	`page_title`

layouts.components.links (resources/views/layouts/components/links.blade.php)23blade


obLevel
__env
app
uncontacted_manager_partner
nbr_manager_partner
errors
partner
partner_category
promotion
partner_location
statistics
pages
__currentLoopData
item
loop
oh
k
times
key
time
i
loc
page_title

Params
0	`obLevel`
1	`__env`
2	`app`
3	`uncontacted_manager_partner`
4	`nbr_manager_partner`
5	`errors`
6	`partner`
7	`partner_category`
8	`promotion`
9	`partner_location`
10	`statistics`
11	`pages`
12	`__currentLoopData`
13	`item`
14	`loop`
15	`oh`
16	`k`
17	`times`
18	`key`
19	`time`
20	`i`
21	`loc`
22	`page_title`

layouts.components.scripts (resources/views/layouts/components/scripts.blade.php)23blade


obLevel
__env
app
uncontacted_manager_partner
nbr_manager_partner
errors
partner
partner_category
promotion
partner_location
statistics
pages
__currentLoopData
item
loop
oh
k
times
key
time
i
loc
page_title

Params
0	`obLevel`
1	`__env`
2	`app`
3	`uncontacted_manager_partner`
4	`nbr_manager_partner`
5	`errors`
6	`partner`
7	`partner_category`
8	`promotion`
9	`partner_location`
10	`statistics`
11	`pages`
12	`__currentLoopData`
13	`item`
14	`loop`
15	`oh`
16	`k`
17	`times`
18	`key`
19	`time`
20	`i`
21	`loc`
22	`page_title`

bigdeal.components.footer (resources/views/bigdeal/components/footer.blade.php)24blade


obLevel
__env
app
uncontacted_manager_partner
nbr_manager_partner
errors
partner
partner_category
promotion
partner_location
statistics
pages
__currentLoopData
item
loop
oh
k
times
key
time
i
loc
page_title
bg_color

Params
0	`obLevel`
1	`__env`
2	`app`
3	`uncontacted_manager_partner`
4	`nbr_manager_partner`
5	`errors`
6	`partner`
7	`partner_category`
8	`promotion`
9	`partner_location`
10	`statistics`
11	`pages`
12	`__currentLoopData`
13	`item`
14	`loop`
15	`oh`
16	`k`
17	`times`
18	`key`
19	`time`
20	`i`
21	`loc`
22	`page_title`
23	`bg_color`

uri: GET p/{slug}
middleware: web
controller: App\Http\Controllers\HomeController@details
namespace: App\Http\Controllers
prefix
where
file: app/Http/Controllers/HomeController.php:203-239

9 statements were executed24.12ms

select * from `partner` where `partner`.`partener_active` = 1 and `partner`.`partner_slug` = 'eye-zone-optic' limit 11.38ms/app/Http/Controllers/HomeController.php:209clubprivileges

Metadata
Bindings	0. 1 1. eye-zone-optic
Backtrace	13. /app/Http/Controllers/HomeController.php:209 14. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 15. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 16. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 17. /app/Http/Controllers/HomeController.php:210

select * from `partner_category` where `partner_category_id` = 3 limit 1380μs/app/Http/Controllers/HomeController.php:219clubprivileges

Metadata
Bindings	0. 3
Backtrace	13. /app/Http/Controllers/HomeController.php:219 14. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 15. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 16. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 17. /app/Http/Controllers/HomeController.php:220

select * from `promotion` where `promotion`.`partner_id` = 678 and `promotion_active` = 1 and `promotion_date_start` < '2025-04-08 11:07:36' and `promotion_date_end` > '2025-04-08 11:07:36' order by `promotion_discount` desc

1.19ms/app/Http/Controllers/HomeController.php:229clubprivileges

Metadata
Bindings	0. 678 1. 1 2. 2025-04-08 11:07:36 3. 2025-04-08 11:07:36
Backtrace	12. /app/Http/Controllers/HomeController.php:229 13. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 14. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 15. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 16. /app/Http/Controllers/HomeController.php:230

select * from `partner_location` where `partner_location`.`partner_id` = 6781.11ms/app/Http/Controllers/HomeController.php:233clubprivileges

Metadata
Bindings	0. 678
Backtrace	14. /app/Http/Controllers/HomeController.php:233 15. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 16. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 17. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 18. /app/Http/Controllers/HomeController.php:234

select count(*) as aggregate from `partner_location` inner join `partner` on `partner_location`.`partner_id` = `partner`.`partner_id` where `partner`.`partener_active` = 1

1.54ms/app/Http/Controllers/HomeController.php:118clubprivileges

Metadata
Bindings	0. 1
Backtrace	14. /app/Http/Controllers/HomeController.php:118 15. /app/Http/Controllers/HomeController.php:236 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select count(*) as aggregate from `partner` where `partener_active` = 1600μs/app/Http/Controllers/HomeController.php:121clubprivileges

Metadata
Bindings	0. 1
Backtrace	14. /app/Http/Controllers/HomeController.php:121 15. /app/Http/Controllers/HomeController.php:236 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select count(*) as aggregate from `client`17.2ms/app/Http/Controllers/HomeController.php:123clubprivileges

Metadata
Backtrace	14. /app/Http/Controllers/HomeController.php:123 15. /app/Http/Controllers/HomeController.php:236 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `stores` where `store_slug` = 'clubprivileges' limit 1360μs/app/Http/Controllers/HomeController.php:127clubprivileges

Metadata
Bindings	0. clubprivileges
Backtrace	13. /app/Http/Controllers/HomeController.php:127 14. /app/Http/Controllers/HomeController.php:236 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `pages` where FIND_IN_SET(13,pages_stores)360μs/app/Http/Controllers/HomeController.php:132clubprivileges

Metadata
Backtrace	12. /app/Http/Controllers/HomeController.php:132 13. /app/Http/Controllers/HomeController.php:236 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

App\Models\backendpartnerlocation: 1

_token: bc1Vog4WseIzyMLthu9Lmp5A50qJAevRvGdMSKUZ
_previous: array:1 [ "url" => "https://tn.preprod.clubprivileges.app/p/eye-zone-optic" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/p/eye-zone-optic

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:15 [▶
  "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"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "host" => array:1 [▶
    0 => "tn.preprod.clubprivileges.app"
  ]
]

request_server

  0 of 0   
array:74 [▶
  "USER" => "www-data"
  "HOME" => "/var/www"
  "SCRIPT_NAME" => "/index.php"
  "REQUEST_URI" => "/p/eye-zone-optic"
  "QUERY_STRING" => ""
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_URL" => "/p/eye-zone-optic"
  "REMOTE_PORT" => "45070"
  "SCRIPT_FILENAME" => "/var/www/preprod/tn.preprod.clubprivileges.app/public/index.php"
  "SERVER_ADMIN" => "[no address given]"
  "CONTEXT_DOCUMENT_ROOT" => "/var/www/preprod/tn.preprod.clubprivileges.app/public/"
  "CONTEXT_PREFIX" => ""
  "REQUEST_SCHEME" => "https"
  "DOCUMENT_ROOT" => "/var/www/preprod/tn.preprod.clubprivileges.app/public/"
  "REMOTE_ADDR" => "18.222.35.177"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "172.31.28.18"
  "SERVER_NAME" => "tn.preprod.clubprivileges.app"
  "SERVER_SOFTWARE" => "Apache"
  "SERVER_SIGNATURE" => ""
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin"
  "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" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_HOST" => "tn.preprod.clubprivileges.app"
  "proxy-nokeepalive" => "1"
  "SSL_SESSION_RESUMED" => "Initial"
  "SSL_SESSION_ID" => "d048229e7af0ede6ebdc5304d8abe5db845e33adb72221abae459c3b6ae06f76"
  "SSL_SERVER_A_SIG" => "ecdsa-with-SHA384"
  "SSL_SERVER_A_KEY" => "******"
  "SSL_SERVER_I_DN" => "CN=E6,O=Let's Encrypt,C=US"
  "SSL_SERVER_S_DN" => "CN=tn.preprod.clubprivileges.app"
  "SSL_SERVER_V_END" => "Jun 29 18:29:25 2025 GMT"
  "SSL_SERVER_V_START" => "Mar 31 18:29:26 2025 GMT"
  "SSL_SERVER_M_SERIAL" => "069E5F1328338C0EC88E582FDB5C206FE62A"
  "SSL_SERVER_M_VERSION" => "3"
  "SSL_CLIENT_VERIFY" => "NONE"
  "SSL_CIPHER_ALGKEYSIZE" => "128"
  "SSL_CIPHER_USEKEYSIZE" => "128"
  "SSL_CIPHER_EXPORT" => "false"
  "SSL_CIPHER" => "TLS_AES_128_GCM_SHA256"
  "SSL_COMPRESS_METHOD" => "NULL"
  "SSL_SECURE_RENEG" => "false"
  "SSL_PROTOCOL" => "TLSv1.3"
  "SSL_VERSION_LIBRARY" => "OpenSSL/3.0.14"
  "SSL_VERSION_INTERFACE" => "mod_ssl/2.4.62"
  "SSL_SERVER_SAN_DNS_0" => "tn.preprod.clubprivileges.app"
  "SSL_SERVER_I_DN_CN" => "E6"
  "SSL_SERVER_I_DN_O" => "Let's Encrypt"
  "SSL_SERVER_I_DN_C" => "US"
  "SSL_SERVER_S_DN_CN" => "tn.preprod.clubprivileges.app"
  "SSL_TLS_SNI" => "tn.preprod.clubprivileges.app"
  "HTTPS" => "on"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_SSL_TLS_SNI" => "tn.preprod.clubprivileges.app"
  "REDIRECT_HTTPS" => "on"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744106856.5118
  "REQUEST_TIME" => 1744106856
  "HTTP" => true
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Tue, 08 Apr 2025 10:07:36 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:1 [▶
    0 => "laravel_session=eyJpdiI6Ijd5QXQwU2lIZGlTVHdneTR5YUU0MHc9PSIsInZhbHVlIjoiTGFzZjdGWU5sZ0doQ1RLQUFKMHdBaDdNaTdiXC9ZcStaZnRodGYzb3JOb0ZBSGY2VXljcEdNK0NQS1R1OFREYWQiLCJtYWMiOiJhOTIwNDkzZWJlMzg1YWUxYmZiYzFjNzkxOTE4YWM4OTAxZjgyMjhlZTY0N2E4YWRlYWU4MjRmMmVjNDA1M2JiIn0%3D; expires=Tue, 08-Apr-2025 12:07:36 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6Ijd5QXQwU2lIZGlTVHdneTR5YUU0MHc9PSIsInZhbHVlIjoiTGFzZjdGWU5sZ0doQ1RLQUFKMHdBaDdNaTdiXC9ZcStaZnRodGYzb3JOb0ZBSGY2VXljcEdNK0NQS1R1OFREYWQi ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "laravel_session=eyJpdiI6Ijd5QXQwU2lIZGlTVHdneTR5YUU0MHc9PSIsInZhbHVlIjoiTGFzZjdGWU5sZ0doQ1RLQUFKMHdBaDdNaTdiXC9ZcStaZnRodGYzb3JOb0ZBSGY2VXljcEdNK0NQS1R1OFREYWQiLCJtYWMiOiJhOTIwNDkzZWJlMzg1YWUxYmZiYzFjNzkxOTE4YWM4OTAxZjgyMjhlZTY0N2E4YWRlYWU4MjRmMmVjNDA1M2JiIn0%3D; expires=Tue, 08-Apr-2025 12:07:36 GMT; path=/; httponly ◀laravel_session=eyJpdiI6Ijd5QXQwU2lIZGlTVHdneTR5YUU0MHc9PSIsInZhbHVlIjoiTGFzZjdGWU5sZ0doQ1RLQUFKMHdBaDdNaTdiXC9ZcStaZnRodGYzb3JOb0ZBSGY2VXljcEdNK0NQS1R1OFREYWQi ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▶
  "_token" => "bc1Vog4WseIzyMLthu9Lmp5A50qJAevRvGdMSKUZ"
  "_previous" => array:1 [▶
    "url" => "https://tn.preprod.clubprivileges.app/p/eye-zone-optic"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

EYE ZONE OPTIC

Points de ventes

1 x Application (70.63%)	64.31ms
1 x Booting (29.36%)	26.73ms