FILTER BY

Filter Price

₤369 ₤369369369369369369

Review Score

Space not found
Request history8.3.16PHP Version871msRequest Duration7MBMemory UsageGET en/shopRouteAuth status
    • Booting (648ms)time
    • Application (223ms)time
    • 1 x Booting (74.35%)
      648ms
      1 x Application (25.64%)
      223ms
      29 templates were rendered
      • 1x Shop::frontend.searchsearch.blade.php#?blade
      • 1x Shop::frontend.layouts.search.form-searchform-search.blade.php#?blade
      • 1x Shop::frontend.layouts.search.fields.locationlocation.blade.php#?blade
      • 1x Shop::frontend.layouts.search.fields.service_nameservice_name.blade.php#?blade
      • 1x Shop::frontend.layouts.search.list-itemlist-item.blade.php#?blade
      • 1x Shop::frontend.layouts.search.filter-searchfilter-search.blade.php#?blade
      • 1x Layout::global.search.filters.attrsattrs.blade.php#?blade
      • 1x Layout::global.search.orderbyorderby.blade.php#?blade
      • 1x Shop::frontend.ajax.search-resultsearch-result.blade.php#?blade
      • 1x pagination::tailwindtailwind.blade.php#?blade
      • 1x vendor.pagination.defaultdefault.blade.php#?blade
      • 1x layouts.appapp.blade.php#?blade
      • 1x Layout::appapp.blade.php#?blade
      • 1x Layout::parts.faviconfavicon.blade.php#?blade
      • 1x Layout::parts.seo-metaseo-meta.blade.php#?blade
      • 1x Layout::parts.global-scriptglobal-script.blade.php#?blade
      • 1x Layout::parts.topbartopbar.blade.php#?blade
      • 2x Core::frontend.currency-switchercurrency-switcher.blade.php#?blade
      • 2x Language::frontend.switcherswitcher.blade.php#?blade
      • 1x Layout::parts.headerheader.blade.php#?blade
      • 1x Layout::parts.footerfooter.blade.php#?blade
      • 1x Layout::parts.login-register-modallogin-register-modal.blade.php#?blade
      • 1x Layout::auth.login-formlogin-form.blade.php#?blade
      • 1x Layout::auth.register-formregister-form.blade.php#?blade
      • 1x Popup::frontend.popuppopup.blade.php#?blade
      • 1x Layout::parts.cookie-consent-initcookie-consent-init.blade.php#?blade
      • 1x demo_scriptdemo_script.blade.php#?blade
      uri
      GET en/shop
      middleware
      web
      controller
      Modules\Shop\Controllers\ShopController@index
      namespace
      Modules\Shop\Controllers
      prefix
      en/shop
      where
      as
      shop.search
      file
      modules/Shop/Controllers/ShopController.php:38-101
      9 statements were executed, 2 of which were duplicates, 7 unique. Show only duplicated14.6ms
      • select * from `bravo_locations` where `id` = '7' and `status` = 'publish' and `bravo_locations`.`deleted_at` is null limit 13.54msaz_azShop.php#935
        Bindings
        • 0: 7
        • 1: publish
        Hints
        • 0: Use SELECT * only if you need all columns from table
        • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 16. modules/Shop/Models/Shop.php:935
        • 17. modules/Shop/Controllers/ShopController.php:52
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. modules/Shop/Controllers/ShopController.php:35
        • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select count(*) as aggregate from (select `bravo_shops`.* from `bravo_shops` inner join `bravo_locations` on `bravo_locations`.`id` = `bravo_shops`.`location_id` and `bravo_locations`.`_lft` >= 1 and `bravo_locations`.`_rgt` <= 2 where `bravo_shops`.`status` = 'publish' and `bravo_shops`.`deleted_at` is null group by `bravo_shops`.`id`) as `aggregate_table`3.25msaz_azShopController.php#53
        Bindings
        • 0: 1
        • 1: 2
        • 2: publish
        Backtrace
        • 16. modules/Shop/Controllers/ShopController.php:53
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. modules/Shop/Controllers/ShopController.php:35
        • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select * from `bravo_locations` where `status` = 'publish' and `bravo_locations`.`deleted_at` is null limit 10001.13msaz_azShopController.php#84
        Bindings
        • 0: publish
        Hints
        • 0: Use SELECT * only if you need all columns from table
        • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. modules/Shop/Controllers/ShopController.php:84
        • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. modules/Shop/Controllers/ShopController.php:35
        • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select * from `bravo_location_translations` where `locale` = 'en' and `bravo_location_translations`.`origin_id` in (6, 7, 10, 16, 17, 34, 35)1.02msaz_azShopController.php#84
        Bindings
        • 0: en
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 20. modules/Shop/Controllers/ShopController.php:84
        • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. modules/Shop/Controllers/ShopController.php:35
        • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select MIN( CASE WHEN sale_price > 0 THEN sale_price ELSE ( price ) END ) AS min_price , MAX( CASE WHEN sale_price > 0 THEN sale_price ELSE ( price ) END ) AS max_price from `bravo_shops` where `status` = 'publish' and `bravo_shops`.`deleted_at` is null limit 1930μsaz_azShop.php#624
        Bindings
        • 0: publish
        Hints
        • 0: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 16. modules/Shop/Models/Shop.php:624
        • 17. modules/Shop/Controllers/ShopController.php:85
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. modules/Shop/Controllers/ShopController.php:35
        • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `bravo_attrs` where `service` = 'shop' and `bravo_attrs`.`deleted_at` is null order by `position` desc1.11msaz_azShopController.php#92
        Bindings
        • 0: shop
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 15. modules/Shop/Controllers/ShopController.php:92
        • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. modules/Shop/Controllers/ShopController.php:35
        • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • select * from `core_menu_translations` where `core_menu_translations`.`origin_id` = 1 and `core_menu_translations`.`origin_id` is not null and `locale` = 'en' limit 11.29msaz_azHasTranslations.php#51
        Bindings
        • 0: 1
        • 1: en
        Hints
        • 0: Use SELECT * only if you need all columns from table
        • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 21. app/Traits/HasTranslations.php:51
        • 22. app/Helpers/AppHelper.php:112
        • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 27. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `core_menu_translations` where `core_menu_translations`.`origin_id` = 1 and `core_menu_translations`.`origin_id` is not null and `locale` = 'en' limit 1990μsaz_azHasTranslations.php#51
        Bindings
        • 0: 1
        • 1: en
        Hints
        • 0: Use SELECT * only if you need all columns from table
        • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 21. app/Traits/HasTranslations.php:51
        • 22. app/Helpers/AppHelper.php:112
        • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 27. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `core_pages` where `core_pages`.`id` = '14' and `core_pages`.`deleted_at` is null limit 11.34msaz_azAppHelper.php#629
        Bindings
        • 0: 14
        Hints
        • 0: Use SELECT * only if you need all columns from table
        • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 20. app/Helpers/AppHelper.php:629
        • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 26. vendor/laravel/framework/src/Illuminate/View/View.php:207
      Modules\Location\Models\Location
      8Location.php#?
      Modules\Core\Models\MenuTranslation
      2MenuTranslation.php#?
      Modules\Shop\Models\Shop
      1Shop.php#?
      Modules\Page\Models\Page
      1Page.php#?
        web
        null
        sanctum
        null
          _token
          2aQTsQaWdexA57uvU2ZpP9cAic0OqNKHFmwyIeFP
          _previous
          array:1 [ "url" => "https://a-z.com.tr/en/shop?location_id=7" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /en/shop
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          0 of 0
          array:1 [ "location_id" => "7" ]
          request_request
          []
          
          request_headers
          0 of 0
          array:23 [ "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, br" ] "cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IjE1VjRpYUYzZFRJSVBlbXRnbElDbnc9PSIsInZhbHVlIjoiRWJLTHJwek9DWWtVemlxcGxpS2hFWTVMenFWN3BlamkxU0phS0xyREd3UE5NU2tybEpManF0a2xGN2ZQWlh4RGFtSnk4anFyNVRTTVYvQWc5TTArcVQ3a29uNWRMMElieWl6QXVxdmtIcWJ3d2E5SWYwc2hFQVl1NnpMQXViK0MiLCJtYWMiOiI4OThmMWQxZDNjZjJlMTljYmZkNWI4NWY1NmU1YmM1N2Q0NTdmMDM2NTcyNWY3YjhmNmRhZDZiM2ZjZjA0NTdjIiwidGFnIjoiIn0%3D; a_ztr_al_sat_kirala_session=eyJpdiI6Ik1uYVE4emZZVVNQVU1hNXl1azA3cXc9PSIsInZhbHVlIjoicUhqQ2lqQ250TmFmUFBOYmwvc002TG9SaFM3Y0J6NHlwWHpabFdnRE5PazluWGNwbFdsdk12VVJ2M1ZtNVIzditnRVRRV202MGltMDBldkN4TTdCdkF6aWw3cm50dXRIcVlodGQ4VTFlMGpFMmZESHNoSFk5TlIxQ0lZbjYzeEwiLCJtYWMiOiIwNWU4Yjk5MDIyNTE2MDBiZmZlM2Y2YWM1ZmI0ZGExZWVjNWI0NzczNWFkNzJmNjBmZmEyZWIwMDJjOGQ4N2FhIiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6IjE1VjRpYUYzZFRJSVBlbXRnbElDbnc9PSIsInZhbHVlIjoiRWJLTHJwek9DWWtVemlxcGxpS2hFWTVMenFWN3BlamkxU0phS0xyREd3UE5NU2tybEpManF0a2xGN2ZQWlh4RGFtSnk4a" ] "host" => array:1 [ 0 => "a-z.com.tr" ] "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" ] "x-forwarded-for" => array:1 [ 0 => "3.142.50.218" ] "cf-ray" => array:1 [ 0 => "9142cd618c22f501-ORD" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "priority" => array:1 [ 0 => "u=0, i" ] "cf-ipcountry" => array:1 [ 0 => "US" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "cf-visitor" => array:1 [ 0 => "{"scheme":"https"}" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "cf-connecting-ip" => array:1 [ 0 => "3.142.50.218" ] "cdn-loop" => array:1 [ 0 => "cloudflare; loops=1" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] ]
          request_cookies
          0 of 0
          array:2 [ "XSRF-TOKEN" => "2aQTsQaWdexA57uvU2ZpP9cAic0OqNKHFmwyIeFP" "a_ztr_al_sat_kirala_session" => "egPlBhwH1UC3IfZOdbEHRegr4Pm9k1QB9ak9ZwVO" ]
          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, 19 Feb 2025 02:24:44 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ii8xK05ZZWhzb2Y1RVFGYytiYmdRZlE9PSIsInZhbHVlIjoiK29kWEo4SFBFbjRNUEhsMko4K3k4WEJDUllUcDBVSThnS0E5enJiYVRuZDB1eWtTMnRYSE1sZUl3SEFSZXVlajVpaExhRHh2NERabkVyOC9jWDAycVlTVWJGLzlISitVM1hqTys3REpGSTRuZWNLdE5jTHFZOE52MlJDRjdMWisiLCJtYWMiOiI2YTRiZTI3YjllMmQ3MzEzMTgyMTE2MWQ3Mzc4NzI1ZWExYWVjOWE0NjY0NjIzY2ZmNDJmYjc1ZjFhYmQ5ODMzIiwidGFnIjoiIn0%3D; expires=Wed, 19 Feb 2025 04:24:44 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Ii8xK05ZZWhzb2Y1RVFGYytiYmdRZlE9PSIsInZhbHVlIjoiK29kWEo4SFBFbjRNUEhsMko4K3k4WEJDUllUcDBVSThnS0E5enJiYVRuZDB1eWtTMnRYSE1sZUl3SEFSZXVlajVpaExhR" 1 => "a_ztr_al_sat_kirala_session=eyJpdiI6IkZGL2d4ZUwyWEhCeUVSYVQ5NWw4cFE9PSIsInZhbHVlIjoibXR0ZmwwM0lEVWNXUTY4WSsvbHRIaTE2OGJkLzRGMDNoUjl2VDZWZDd4QUFudGxlZ29XWnJjbTFHemExVXhuRHdxcllGdmJjRFhwalRUZDZoV2FwQ1RxbzljTEJUL1dHNEdFT3B6TFlKSUFoUFVTdCt3MWFsd3dpUlVHVFkxTDQiLCJtYWMiOiI3MzI2ODFmYjFlNmJhY2RjODdlZmI3YTU2ZjAxM2RmYzQ5NGQ1N2FkOGUwMmI3ZDg3MTY1NWY4MDNmYWFhMmM5IiwidGFnIjoiIn0%3D; expires=Wed, 19 Feb 2025 04:24:44 GMT; Max-Age=7200; path=/; httponly; samesite=laxa_ztr_al_sat_kirala_session=eyJpdiI6IkZGL2d4ZUwyWEhCeUVSYVQ5NWw4cFE9PSIsInZhbHVlIjoibXR0ZmwwM0lEVWNXUTY4WSsvbHRIaTE2OGJkLzRGMDNoUjl2VDZWZDd4QUFudGxlZ29XWnJjbTFH" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ii8xK05ZZWhzb2Y1RVFGYytiYmdRZlE9PSIsInZhbHVlIjoiK29kWEo4SFBFbjRNUEhsMko4K3k4WEJDUllUcDBVSThnS0E5enJiYVRuZDB1eWtTMnRYSE1sZUl3SEFSZXVlajVpaExhRHh2NERabkVyOC9jWDAycVlTVWJGLzlISitVM1hqTys3REpGSTRuZWNLdE5jTHFZOE52MlJDRjdMWisiLCJtYWMiOiI2YTRiZTI3YjllMmQ3MzEzMTgyMTE2MWQ3Mzc4NzI1ZWExYWVjOWE0NjY0NjIzY2ZmNDJmYjc1ZjFhYmQ5ODMzIiwidGFnIjoiIn0%3D; expires=Wed, 19-Feb-2025 04:24:44 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Ii8xK05ZZWhzb2Y1RVFGYytiYmdRZlE9PSIsInZhbHVlIjoiK29kWEo4SFBFbjRNUEhsMko4K3k4WEJDUllUcDBVSThnS0E5enJiYVRuZDB1eWtTMnRYSE1sZUl3SEFSZXVlajVpaExhR" 1 => "a_ztr_al_sat_kirala_session=eyJpdiI6IkZGL2d4ZUwyWEhCeUVSYVQ5NWw4cFE9PSIsInZhbHVlIjoibXR0ZmwwM0lEVWNXUTY4WSsvbHRIaTE2OGJkLzRGMDNoUjl2VDZWZDd4QUFudGxlZ29XWnJjbTFHemExVXhuRHdxcllGdmJjRFhwalRUZDZoV2FwQ1RxbzljTEJUL1dHNEdFT3B6TFlKSUFoUFVTdCt3MWFsd3dpUlVHVFkxTDQiLCJtYWMiOiI3MzI2ODFmYjFlNmJhY2RjODdlZmI3YTU2ZjAxM2RmYzQ5NGQ1N2FkOGUwMmI3ZDg3MTY1NWY4MDNmYWFhMmM5IiwidGFnIjoiIn0%3D; expires=Wed, 19-Feb-2025 04:24:44 GMT; path=/; httponlya_ztr_al_sat_kirala_session=eyJpdiI6IkZGL2d4ZUwyWEhCeUVSYVQ5NWw4cFE9PSIsInZhbHVlIjoibXR0ZmwwM0lEVWNXUTY4WSsvbHRIaTE2OGJkLzRGMDNoUjl2VDZWZDd4QUFudGxlZ29XWnJjbTFH" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "2aQTsQaWdexA57uvU2ZpP9cAic0OqNKHFmwyIeFP" "_previous" => array:1 [ "url" => "https://a-z.com.tr/en/shop?location_id=7" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-02-19 05:24:44GET/en/shop?location_id=729912