loader
#1 o (09:48:58)8.1.31PHP Version70.87msRequest Duration3MBMemory UsageGET store/{search}Route
    • Booting (31.54ms)
    • Application (39.13ms)
    • 1 x Application (55.21%)
      39.13ms
      1 x Booting (44.5%)
      31.54ms
      4 templates were rendered
      • frontend.store.filter-store (resources/views/frontend/store/filter-store.blade.php)7bladefile
        Params
        0
        filters
        1
        allcategores
        2
        social_link
        3
        footers
        4
        settings
        5
        header_navbars
        6
        footer_navbars
      • frontend.layout.app (resources/views/frontend/layout/app.blade.php)13bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        filters
        4
        allcategores
        5
        social_link
        6
        footers
        7
        settings
        8
        header_navbars
        9
        footer_navbars
        10
        __currentLoopData
        11
        row
        12
        loop
      • frontend.layout.header (resources/views/frontend/layout/header.blade.php)13bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        filters
        4
        allcategores
        5
        social_link
        6
        footers
        7
        settings
        8
        header_navbars
        9
        footer_navbars
        10
        __currentLoopData
        11
        row
        12
        loop
      • frontend.layout.footer (resources/views/frontend/layout/footer.blade.php)13bladefile
        Params
        0
        __env
        1
        app
        2
        errors
        3
        filters
        4
        allcategores
        5
        social_link
        6
        footers
        7
        settings
        8
        header_navbars
        9
        footer_navbars
        10
        __currentLoopData
        11
        row
        12
        loop
      uri
      GET store/{search}
      middleware
      web
      controller
      App\Http\Controllers\FrontendController@filter_store
      namespace
      prefix
      where
      as
      filter.stores
      file
      app/Http/Controllers/FrontendController.php:123-138
      19 statements were executed, 12 of which were duplicated, 7 unique. Show only duplicated8.26ms
      • select count(*) as aggregate from `stores` where `store_name` LIKE 'o%'
        2.71ms/app/Http/Controllers/FrontendController.php:132u505932078_jg6FM
        Metadata
        Bindings
        • 0. o%
        Backtrace
        • 15. /app/Http/Controllers/FrontendController.php:132
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `stores` where `store_name` LIKE 'o%' limit 8 offset 0
        730μs/app/Http/Controllers/FrontendController.php:132u505932078_jg6FM
        Metadata
        Bindings
        • 0. o%
        Backtrace
        • 15. /app/Http/Controllers/FrontendController.php:132
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select count(*) as aggregate from `categories`
        210μs/app/Http/Controllers/FrontendController.php:133u505932078_jg6FM
        Metadata
        Backtrace
        • 18. /app/Http/Controllers/FrontendController.php:133
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `categories` limit 8 offset 0
        200μs/app/Http/Controllers/FrontendController.php:133u505932078_jg6FM
        Metadata
        Backtrace
        • 18. /app/Http/Controllers/FrontendController.php:133
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `stores` where `stores`.`category_id` in (1, 2, 3, 4, 5, 6, 7, 8)
        1.44ms/app/Http/Controllers/FrontendController.php:133u505932078_jg6FM
        Metadata
        Backtrace
        • 23. /app/Http/Controllers/FrontendController.php:133
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 26. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 27. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `socials` limit 1
        280μs/app/Http/Controllers/FrontendController.php:134u505932078_jg6FM
        Metadata
        Backtrace
        • 18. /app/Http/Controllers/FrontendController.php:134
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `footer_addresses` order by `id` desc
        220μs/app/Http/Controllers/FrontendController.php:135u505932078_jg6FM
        Metadata
        Backtrace
        • 14. /app/Http/Controllers/FrontendController.php:135
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • select * from `settings`
        230μs/app/Providers/AppServiceProvider.php:26u505932078_jg6FM
        Metadata
        Backtrace
        • 15. /app/Providers/AppServiceProvider.php:26
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:176
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:147
      • select * from `header_navbars` order by `created_at` desc
        320μs/app/Providers/AppServiceProvider.php:30u505932078_jg6FM
        Metadata
        Backtrace
        • 14. /app/Providers/AppServiceProvider.php:30
        • 15. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:176
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:147
      • select * from `footer_navbars`
        210μs/app/Providers/AppServiceProvider.php:34u505932078_jg6FM
        Metadata
        Backtrace
        • 17. /app/Providers/AppServiceProvider.php:34
        • 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 22. /vendor/laravel/framework/src/Illuminate/View/View.php:176
        • 23. /vendor/laravel/framework/src/Illuminate/View/View.php:147
      • select * from `settings`
        220μs/app/Providers/AppServiceProvider.php:26u505932078_jg6FM
        Metadata
        Backtrace
        • 15. /app/Providers/AppServiceProvider.php:26
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:176
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:147
      • select * from `header_navbars` order by `created_at` desc
        220μs/app/Providers/AppServiceProvider.php:30u505932078_jg6FM
        Metadata
        Backtrace
        • 14. /app/Providers/AppServiceProvider.php:30
        • 15. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:176
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:147
      • select * from `footer_navbars`
        140μs/app/Providers/AppServiceProvider.php:34u505932078_jg6FM
        Metadata
        Backtrace
        • 17. /app/Providers/AppServiceProvider.php:34
        • 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 22. /vendor/laravel/framework/src/Illuminate/View/View.php:176
        • 23. /vendor/laravel/framework/src/Illuminate/View/View.php:147
      • select * from `settings`
        200μs/app/Providers/AppServiceProvider.php:26u505932078_jg6FM
        Metadata
        Backtrace
        • 15. /app/Providers/AppServiceProvider.php:26
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:176
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:147
      • select * from `header_navbars` order by `created_at` desc
        230μs/app/Providers/AppServiceProvider.php:30u505932078_jg6FM
        Metadata
        Backtrace
        • 14. /app/Providers/AppServiceProvider.php:30
        • 15. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:176
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:147
      • select * from `footer_navbars`
        140μs/app/Providers/AppServiceProvider.php:34u505932078_jg6FM
        Metadata
        Backtrace
        • 17. /app/Providers/AppServiceProvider.php:34
        • 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 22. /vendor/laravel/framework/src/Illuminate/View/View.php:176
        • 23. /vendor/laravel/framework/src/Illuminate/View/View.php:147
      • select * from `settings`
        200μs/app/Providers/AppServiceProvider.php:26u505932078_jg6FM
        Metadata
        Backtrace
        • 15. /app/Providers/AppServiceProvider.php:26
        • 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:176
        • 21. /vendor/laravel/framework/src/Illuminate/View/View.php:147
      • select * from `header_navbars` order by `created_at` desc
        200μs/app/Providers/AppServiceProvider.php:30u505932078_jg6FM
        Metadata
        Backtrace
        • 14. /app/Providers/AppServiceProvider.php:30
        • 15. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:176
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:147
      • select * from `footer_navbars`
        160μs/app/Providers/AppServiceProvider.php:34u505932078_jg6FM
        Metadata
        Backtrace
        • 17. /app/Providers/AppServiceProvider.php:34
        • 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:162
        • 21. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 22. /vendor/laravel/framework/src/Illuminate/View/View.php:176
        • 23. /vendor/laravel/framework/src/Illuminate/View/View.php:147
      App\Models\Footer_navbar
      24
      App\Models\Header_navbar
      20
      App\Models\Settings
      4
      App\Models\FooterAddress
      1
      App\Models\Social
      1
      App\Models\Blogcategory
      8
      App\Models\Store
      162
        _token
        DeXdOWqxee25I6mGukPdOqKF6oEEqGLbvUwuvKaj
        _previous
        array:1 [ "url" => "https://couponthirst.com/store/o" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /store/o
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:15 [ "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" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "host" => array:1 [ 0 => "couponthirst.com" ] "pragma" => array:1 [ 0 => "no-cache" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cache-control" => array:1 [ 0 => "no-cache" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "priority" => array:1 [ 0 => "u=0, i" ] ]
        request_server
        0 of 0
        array:53 [ "LSPHP_ProcessGroup" => "on" "PATH" => "/usr/local/bin:/bin:/usr/bin" "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_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_HOST" => "couponthirst.com" "HTTP_PRAGMA" => "no-cache" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_PRIORITY" => "u=0, i" "DOCUMENT_ROOT" => "/home/u505932078/domains/couponthirst.com/public_html" "REMOTE_ADDR" => "52.15.65.43" "REMOTE_PORT" => "25368" "SERVER_ADDR" => "195.35.33.18" "SERVER_NAME" => "couponthirst.com" "SERVER_ADMIN" => "" "SERVER_PORT" => "443" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/store/o" "REDIRECT_URL" => "/public/store/o" "REDIRECT_REQUEST_METHOD" => "GET" "HTTPS" => "on" "CRAWLER_USLEEP" => "1000" "CRAWLER_LOAD_LIMIT_ENFORCE" => "25" "H_PLATFORM" => "Hostinger" "H_TYPE" => "shared" "H_CANARY" => "false" "H_STAGING" => "false" "REDIRECT_STATUS" => "200" "X_SPDY" => "HTTP2" "SSL_PROTOCOL" => "TLSv1.3" "SSL_CIPHER" => "TLS_AES_128_GCM_SHA256" "SSL_CIPHER_USEKEYSIZE" => "128" "SSL_CIPHER_ALGKEYSIZE" => "128" "SCRIPT_FILENAME" => "/home/u505932078/domains/couponthirst.com/public_html/public/index.php" "QUERY_STRING" => "" "SCRIPT_URI" => "https://couponthirst.com/store/o" "SCRIPT_URL" => "/store/o" "SCRIPT_NAME" => "/public/index.php" "SERVER_PROTOCOL" => "HTTP/1.1" "SERVER_SOFTWARE" => "LiteSpeed" "REQUEST_METHOD" => "GET" "X-LSCACHE" => "on,crawler,esi,combine" "PHP_SELF" => "/public/index.php" "REQUEST_TIME_FLOAT" => 1746006538.7554 "REQUEST_TIME" => 1746006538 ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Wed, 30 Apr 2025 09:48:58 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImMwUm1JanBLYnl1L2EzSURFSnhUL1E9PSIsInZhbHVlIjoicUxsMWtBOWlMUm9kWDVKa29TVDViSTZUNXVmMURmejJwVWxKZGYxZHFhblhuT3hmZjc0U3VGYklzVnNlcDVoOWVLa1o2TWR4dnVoVVI1K0w5NUsxOExTdzZGQkF2Slh6bjIyNGVnT0NRU2h1THIzQ2FPYTU5L2dSVlcrUGE3UFEiLCJtYWMiOiJkNDlkZTdhOGMxMTVhZDYzMThkZjhhYmIzMjFlODk1YWQxNTI4ZGVjOTQ2NzZlZTkyMDI2Y2RhMzQ0MmMyNmVlIiwidGFnIjoiIn0%3D; expires=Wed, 30 Apr 2025 11:48:58 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6ImMwUm1JanBLYnl1L2EzSURFSnhUL1E9PSIsInZhbHVlIjoicUxsMWtBOWlMUm9kWDVKa29TVDViSTZUNXVmMURmejJwVWxKZGYxZHFhblhuT3hmZjc0U3VGYklzVnNlcDVoOWVLa1o2T" 1 => "laravel_session=eyJpdiI6IlpPc0w3MmtjY3VsVTZCUmcwT1FOcmc9PSIsInZhbHVlIjoicDZ3SWVlU29abVdrOEpFeCtOb010OHdvQjcxUUNwVVludDYvMkR0UWRIWEhtYWw2OVJGdHY1WC8yQjVWQzZ0LzNkOS9YSGYyM2NtdmRwRmQvanhuVUNnUG5JNHpja203ZDQwbTFwUHZkbDBZMlRJUEs1SW1UZDd2UFZQeTNXZGkiLCJtYWMiOiJhM2RmNDZjZjI5ODJiNzlmMGRjZTVkYjBlNWY0NzZjODRlZDc1OWMzMzlhOTIxYzg2Zjc3ZGQzMDAyOGRjYzg2IiwidGFnIjoiIn0%3D; expires=Wed, 30 Apr 2025 11:48:58 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IlpPc0w3MmtjY3VsVTZCUmcwT1FOcmc9PSIsInZhbHVlIjoicDZ3SWVlU29abVdrOEpFeCtOb010OHdvQjcxUUNwVVludDYvMkR0UWRIWEhtYWw2OVJGdHY1WC8yQjVWQzZ0LzNk" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImMwUm1JanBLYnl1L2EzSURFSnhUL1E9PSIsInZhbHVlIjoicUxsMWtBOWlMUm9kWDVKa29TVDViSTZUNXVmMURmejJwVWxKZGYxZHFhblhuT3hmZjc0U3VGYklzVnNlcDVoOWVLa1o2TWR4dnVoVVI1K0w5NUsxOExTdzZGQkF2Slh6bjIyNGVnT0NRU2h1THIzQ2FPYTU5L2dSVlcrUGE3UFEiLCJtYWMiOiJkNDlkZTdhOGMxMTVhZDYzMThkZjhhYmIzMjFlODk1YWQxNTI4ZGVjOTQ2NzZlZTkyMDI2Y2RhMzQ0MmMyNmVlIiwidGFnIjoiIn0%3D; expires=Wed, 30-Apr-2025 11:48:58 GMT; path=/XSRF-TOKEN=eyJpdiI6ImMwUm1JanBLYnl1L2EzSURFSnhUL1E9PSIsInZhbHVlIjoicUxsMWtBOWlMUm9kWDVKa29TVDViSTZUNXVmMURmejJwVWxKZGYxZHFhblhuT3hmZjc0U3VGYklzVnNlcDVoOWVLa1o2T" 1 => "laravel_session=eyJpdiI6IlpPc0w3MmtjY3VsVTZCUmcwT1FOcmc9PSIsInZhbHVlIjoicDZ3SWVlU29abVdrOEpFeCtOb010OHdvQjcxUUNwVVludDYvMkR0UWRIWEhtYWw2OVJGdHY1WC8yQjVWQzZ0LzNkOS9YSGYyM2NtdmRwRmQvanhuVUNnUG5JNHpja203ZDQwbTFwUHZkbDBZMlRJUEs1SW1UZDd2UFZQeTNXZGkiLCJtYWMiOiJhM2RmNDZjZjI5ODJiNzlmMGRjZTVkYjBlNWY0NzZjODRlZDc1OWMzMzlhOTIxYzg2Zjc3ZGQzMDAyOGRjYzg2IiwidGFnIjoiIn0%3D; expires=Wed, 30-Apr-2025 11:48:58 GMT; path=/; httponlylaravel_session=eyJpdiI6IlpPc0w3MmtjY3VsVTZCUmcwT1FOcmc9PSIsInZhbHVlIjoicDZ3SWVlU29abVdrOEpFeCtOb010OHdvQjcxUUNwVVludDYvMkR0UWRIWEhtYWw2OVJGdHY1WC8yQjVWQzZ0LzNk" ] ]
        session_attributes
        0 of 0
        array:4 [ "_token" => "DeXdOWqxee25I6mGukPdOqKF6oEEqGLbvUwuvKaj" "_previous" => array:1 [ "url" => "https://couponthirst.com/store/o" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]