Apartement For sale in Nabeul

شعار طابو العقاري : لايوجد نتائج

Apartement - Posts: Tunisia - City Nabeul

House For sale

1,100,000 د.ت

Tunis - سكره
منزل مستقل مساحة البناء 370 متر و مساحة الارض 500 متر للبيع في منطقة سكرة
8.2.28PHP Version570msRequest Duration174MBMemory UsageGET en/{category}/{city?}/{region?}Route
  • warninglog[13:19:33] LOG.warning: Callables of the form ["Swift_SmtpTransport", "Swift_Transport_EsmtpTranspor...
  • warninglog[13:19:33] LOG.warning: Optional parameter $subdomain declared before required parameter $status is ...
  • warninglog[13:19:33] LOG.warning: Optional parameter $subdomain declared before required parameter $category_i...
  • warninglog[13:19:33] LOG.warning: Optional parameter $subdomain declared before required parameter $id is impl...
  • warninglog[13:19:33] LOG.warning: Optional parameter $subdomain declared before required parameter $id is impl...
  • warninglog[13:19:33] LOG.warning: Optional parameter $subdomain declared before required parameter $id is impl...
  • warninglog[13:19:33] LOG.warning: Optional parameter $subdomain declared before required parameter $id is impl...
  • warninglog[13:19:33] LOG.warning: Optional parameter $subdomain declared before required parameter $request is...
  • warninglog[13:19:33] LOG.warning: Optional parameter $other_key declared before required parameter $other is i...
  • warninglog[13:19:33] LOG.warning: Optional parameter $other_key declared before required parameter $other is i...
  • infolog[13:19:33] LOG.info: log_data {"url":"http:\/\/tn.6abbo.com\/en\/apartment-Offered-for-sale\/nabeul"...
  • Booting (222ms)
  • Application (348ms)
  • 1 x Application (61%)
    348ms
    1 x Booting (39%)
    222ms
    11 templates were rendered
    • website.Post.NewList (resources/views/website/Post/NewList.blade.php)19blade
      Params
      0
      Category
      1
      posts
      2
      categorySlug
      3
      CampaignMediaItems
      4
      CampaignSliderItem
      5
      randomArr
      6
      campaign_ids
      7
      string_type
      8
      DBselected_city
      9
      citySlug
      10
      regionSlug
      11
      activePromotionPosts
      12
      randomPosts
      13
      AllCountriesRandomPosts
      14
      countryName
      15
      cityOpj
      16
      regionOpj
      17
      Title
      18
      BannersIndexes
    • website.layouts.header (resources/views/website/layouts/header.blade.php)32blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      enable_promotion
      4
      subdomain
      5
      lang
      6
      Agent
      7
      AppSettings
      8
      asset_v
      9
      listNotifications
      10
      session_country
      11
      bk_sms_codes
      12
      Category
      13
      posts
      14
      categorySlug
      15
      CampaignMediaItems
      16
      CampaignSliderItem
      17
      randomArr
      18
      campaign_ids
      19
      string_type
      20
      DBselected_city
      21
      citySlug
      22
      regionSlug
      23
      activePromotionPosts
      24
      randomPosts
      25
      AllCountriesRandomPosts
      26
      countryName
      27
      cityOpj
      28
      regionOpj
      29
      Title
      30
      BannersIndexes
      31
      type
    • website.layouts.top-header (resources/views/website/layouts/top-header.blade.php)32blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      enable_promotion
      4
      subdomain
      5
      lang
      6
      Agent
      7
      AppSettings
      8
      asset_v
      9
      listNotifications
      10
      session_country
      11
      bk_sms_codes
      12
      Category
      13
      posts
      14
      categorySlug
      15
      CampaignMediaItems
      16
      CampaignSliderItem
      17
      randomArr
      18
      campaign_ids
      19
      string_type
      20
      DBselected_city
      21
      citySlug
      22
      regionSlug
      23
      activePromotionPosts
      24
      randomPosts
      25
      AllCountriesRandomPosts
      26
      countryName
      27
      cityOpj
      28
      regionOpj
      29
      Title
      30
      BannersIndexes
      31
      type
    • website.Post.Component.NewWebFilter (resources/views/website/Post/Component/NewWebFilter.blade.php)40blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      enable_promotion
      4
      subdomain
      5
      lang
      6
      Agent
      7
      AppSettings
      8
      asset_v
      9
      listNotifications
      10
      session_country
      11
      bk_sms_codes
      12
      Category
      13
      posts
      14
      categorySlug
      15
      CampaignMediaItems
      16
      CampaignSliderItem
      17
      randomArr
      18
      campaign_ids
      19
      string_type
      20
      DBselected_city
      21
      citySlug
      22
      regionSlug
      23
      activePromotionPosts
      24
      randomPosts
      25
      AllCountriesRandomPosts
      26
      countryName
      27
      cityOpj
      28
      regionOpj
      29
      Title
      30
      BannersIndexes
      31
      ext
      32
      counterCell
      33
      CAT_SLUG
      34
      __currentLoopData
      35
      cat
      36
      loop
      37
      plusIndex
      38
      CampmaignIndex
      39
      perIndexSplit
    • website.Post.Component.Select (resources/views/website/Post/Component/Select.blade.php)10blade
      Params
      0
      with_all
      1
      name
      2
      class
      3
      attr
      4
      placeholder
      5
      label
      6
      value
      7
      data
      8
      slot
      9
      __laravel_slots
    • website.Post.Component.NewListCell (resources/views/website/Post/Component/NewListCell.blade.php)44blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      enable_promotion
      4
      subdomain
      5
      lang
      6
      Agent
      7
      AppSettings
      8
      asset_v
      9
      listNotifications
      10
      session_country
      11
      bk_sms_codes
      12
      Category
      13
      posts
      14
      categorySlug
      15
      CampaignMediaItems
      16
      CampaignSliderItem
      17
      randomArr
      18
      campaign_ids
      19
      string_type
      20
      DBselected_city
      21
      citySlug
      22
      regionSlug
      23
      activePromotionPosts
      24
      randomPosts
      25
      AllCountriesRandomPosts
      26
      countryName
      27
      cityOpj
      28
      regionOpj
      29
      Title
      30
      BannersIndexes
      31
      ext
      32
      counterCell
      33
      CAT_SLUG
      34
      __currentLoopData
      35
      cat
      36
      loop
      37
      plusIndex
      38
      CampmaignIndex
      39
      perIndexSplit
      40
      colSize
      41
      post
      42
      __empty_1
      43
      class
    • pagination::bootstrap-4 (resources/views/vendor/pagination/bootstrap-4.blade.php)2blade
      Params
      0
      paginator
      1
      elements
    • website.layouts.footer (resources/views/website/layouts/footer.blade.php)43blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      enable_promotion
      4
      subdomain
      5
      lang
      6
      Agent
      7
      AppSettings
      8
      asset_v
      9
      listNotifications
      10
      session_country
      11
      bk_sms_codes
      12
      Category
      13
      posts
      14
      categorySlug
      15
      CampaignMediaItems
      16
      CampaignSliderItem
      17
      randomArr
      18
      campaign_ids
      19
      string_type
      20
      DBselected_city
      21
      citySlug
      22
      regionSlug
      23
      activePromotionPosts
      24
      randomPosts
      25
      AllCountriesRandomPosts
      26
      countryName
      27
      cityOpj
      28
      regionOpj
      29
      Title
      30
      BannersIndexes
      31
      ext
      32
      counterCell
      33
      CAT_SLUG
      34
      __currentLoopData
      35
      cat
      36
      loop
      37
      plusIndex
      38
      CampmaignIndex
      39
      perIndexSplit
      40
      colSize
      41
      post
      42
      __empty_1
    • website.Modals.mostLoggedIn (resources/views/website/Modals/mostLoggedIn.blade.php)43blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      enable_promotion
      4
      subdomain
      5
      lang
      6
      Agent
      7
      AppSettings
      8
      asset_v
      9
      listNotifications
      10
      session_country
      11
      bk_sms_codes
      12
      Category
      13
      posts
      14
      categorySlug
      15
      CampaignMediaItems
      16
      CampaignSliderItem
      17
      randomArr
      18
      campaign_ids
      19
      string_type
      20
      DBselected_city
      21
      citySlug
      22
      regionSlug
      23
      activePromotionPosts
      24
      randomPosts
      25
      AllCountriesRandomPosts
      26
      countryName
      27
      cityOpj
      28
      regionOpj
      29
      Title
      30
      BannersIndexes
      31
      ext
      32
      counterCell
      33
      CAT_SLUG
      34
      __currentLoopData
      35
      cat
      36
      loop
      37
      plusIndex
      38
      CampmaignIndex
      39
      perIndexSplit
      40
      colSize
      41
      post
      42
      __empty_1
    • website.Post.AddPostModals (resources/views/website/Post/AddPostModals.blade.php)43blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      enable_promotion
      4
      subdomain
      5
      lang
      6
      Agent
      7
      AppSettings
      8
      asset_v
      9
      listNotifications
      10
      session_country
      11
      bk_sms_codes
      12
      Category
      13
      posts
      14
      categorySlug
      15
      CampaignMediaItems
      16
      CampaignSliderItem
      17
      randomArr
      18
      campaign_ids
      19
      string_type
      20
      DBselected_city
      21
      citySlug
      22
      regionSlug
      23
      activePromotionPosts
      24
      randomPosts
      25
      AllCountriesRandomPosts
      26
      countryName
      27
      cityOpj
      28
      regionOpj
      29
      Title
      30
      BannersIndexes
      31
      ext
      32
      counterCell
      33
      CAT_SLUG
      34
      __currentLoopData
      35
      cat
      36
      loop
      37
      plusIndex
      38
      CampmaignIndex
      39
      perIndexSplit
      40
      colSize
      41
      post
      42
      __empty_1
    • mobile.layouts.bottom_add_post_sheet (resources/views/mobile/layouts/bottom_add_post_sheet.blade.php)44blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      enable_promotion
      4
      subdomain
      5
      lang
      6
      Agent
      7
      AppSettings
      8
      asset_v
      9
      listNotifications
      10
      session_country
      11
      bk_sms_codes
      12
      Category
      13
      posts
      14
      categorySlug
      15
      CampaignMediaItems
      16
      CampaignSliderItem
      17
      randomArr
      18
      campaign_ids
      19
      string_type
      20
      DBselected_city
      21
      citySlug
      22
      regionSlug
      23
      activePromotionPosts
      24
      randomPosts
      25
      AllCountriesRandomPosts
      26
      countryName
      27
      cityOpj
      28
      regionOpj
      29
      Title
      30
      BannersIndexes
      31
      ext
      32
      counterCell
      33
      CAT_SLUG
      34
      __currentLoopData
      35
      cat
      36
      loop
      37
      plusIndex
      38
      CampmaignIndex
      39
      perIndexSplit
      40
      colSize
      41
      post
      42
      __empty_1
      43
      flag
    uri
    GET en/{category}/{city?}/{region?}
    middleware
    web, GetUserAllDataMiddleware, promotion_check, localeViewPath, set_timezone, share_data, Notifications, log_middleware:web, sub_domain, canonical
    domain
    {subdomain}.6abbo.com
    controller
    App\Http\Controllers\website\PostController@index
    namespace
    App\Http\Controllers\website
    prefix
    /en
    where
    as
    posts.index
    file
    app/Http/Controllers/website/PostController.php:896-1323
    18 statements were executed15.46ms
    • select * from `countries` where `iso` = 'US' limit 1
      2.15msmiddleware::set_timezone:199tabbo_live_db_v3
      Metadata
      Bindings
      • 0. US
      Backtrace
      • 15. middleware::set_timezone:199
      • 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
      • 17. middleware::localeViewPath:33
      • 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
      • 19. middleware::promotion_check:18
    • select * from `app_settings` limit 1
      650μsmiddleware::share_data:126tabbo_live_db_v3
      Metadata
      Backtrace
      • 18. middleware::share_data:126
      • 19. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
      • 20. middleware::set_timezone:218
      • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
      • 22. middleware::localeViewPath:33
    • select * from `countries` where `iso` = 'tn' limit 1
      490μsmiddleware::sub_domain:62tabbo_live_db_v3
      Metadata
      Bindings
      • 0. tn
      Backtrace
      • 15. middleware::sub_domain:62
      • 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
      • 17. middleware::log_middleware:63
      • 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167
      • 19. middleware::Notifications:19
    • select * from `categories` where `ar_slug` = 'apartment' or `en_slug` = 'apartment' limit 1
      600μs/app/Http/Controllers/website/PostController.php:1031tabbo_live_db_v3
      Metadata
      Bindings
      • 0. apartment
      • 1. apartment
      Backtrace
      • 16. /app/Http/Controllers/website/PostController.php:1031
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `cities` where (`en_slug` = 'nabeul' or `en_slug` = 'nabeul') and `country_id` = 20 limit 1
      780μs/app/Http/Controllers/website/PostController.php:1093tabbo_live_db_v3
      Metadata
      Bindings
      • 0. nabeul
      • 1. nabeul
      • 2. 20
      Backtrace
      • 16. /app/Http/Controllers/website/PostController.php:1093
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `posts`.`id`, `posts`.`sold`, `posts`.`promotion_id`, `posts`.`valid_until`, `posts`.`sys_status`, `posts`.`reject_reason`, `posts`.`category_id`, `posts`.`approved_at`, `posts`.`status`, `posts`.`video`, `posts`.`video_thumb`, `posts`.`is_iskan`, `posts`.`company_id`, `posts`.`iskan_project_id`, `posts`.`description`, `posts`.`price_to`, `posts`.`price_from`, `posts`.`other_region`, `posts`.`country_id`, `posts`.`region_id`, `posts`.`city_id`, `posts`.`ad_type`, `posts`.`title`, `posts`.`long`, `posts`.`lat`, `posts`.`image`, `posts`.`price`, `posts`.`user_id`, `posts`.`created_at`, `posts`.`out_side_images`, `posts`.`out_side_thumb`, `posts`.`is_corporate`, `posts`.`report_result`, `posts`.`video360`, `posts`.`youtube_video`, `posts`.`qr_code`, `posts`.`exclusive`, `posts`.`uploaded_to_s3`, `posts`.`uploaded_to_s3_video`, (select count(*) from `favorite_posts` where `posts`.`id` = `favorite_posts`.`post_id` and `favorite_posts`.`user_id` = -50) as `user_fav_count` from `posts` where `country_id` = 20 and `posts`.`category_id` = 1 and `posts`.`is_promoted` = 1 and `posts`.`paid_posts` = 1 and (`posts`.`sys_status` = 1 and `posts`.`status` = 'enabled') and `posts`.`promotion_id` in (4, 3) and `posts`.`deleted_at` is null and exists (select * from `users` where `posts`.`user_id` = `users`.`id`) and `posts`.`user_id` != 5716 order by `posts`.`percent` asc limit 4
      1.35ms/app/Http/Controllers/website/PostController.php:1175tabbo_live_db_v3
      Metadata
      Bindings
      • 0. -50
      • 1. 20
      • 2. 1
      • 3. 1
      • 4. 1
      • 5. 1
      • 6. enabled
      • 7. 4
      • 8. 3
      • 9. 5716
      Backtrace
      • 14. /app/Http/Controllers/website/PostController.php:1175
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select count(*) as aggregate from `posts` where `country_id` = 20 and (`posts`.`sys_status` = 1 and `posts`.`status` = 'enabled') and `category_id` = 1 and `iskan_project_id` is null and `ad_type` = 1 and `posts`.`city_id` = 532 and `posts`.`percent` is null and `posts`.`is_promoted` = 0 and `posts`.`deleted_at` is null and exists (select * from `users` where `posts`.`user_id` = `users`.`id`) and `posts`.`user_id` != 5716
      850μs/app/Http/Controllers/website/PostController.php:1204tabbo_live_db_v3
      Metadata
      Bindings
      • 0. 20
      • 1. 1
      • 2. enabled
      • 3. 1
      • 4. 1
      • 5. 532
      • 6. 0
      • 7. 5716
      Backtrace
      • 15. /app/Http/Controllers/website/PostController.php:1204
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `posts`.`id`, `posts`.`sold`, `posts`.`promotion_id`, `posts`.`valid_until`, `posts`.`sys_status`, `posts`.`reject_reason`, `posts`.`category_id`, `posts`.`approved_at`, `posts`.`status`, `posts`.`video`, `posts`.`video_thumb`, `posts`.`is_iskan`, `posts`.`company_id`, `posts`.`iskan_project_id`, `posts`.`description`, `posts`.`price_to`, `posts`.`price_from`, `posts`.`other_region`, `posts`.`country_id`, `posts`.`region_id`, `posts`.`city_id`, `posts`.`ad_type`, `posts`.`title`, `posts`.`long`, `posts`.`lat`, `posts`.`image`, `posts`.`price`, `posts`.`user_id`, `posts`.`created_at`, `posts`.`out_side_images`, `posts`.`out_side_thumb`, `posts`.`is_corporate`, `posts`.`report_result`, `posts`.`video360`, `posts`.`youtube_video`, `posts`.`qr_code`, `posts`.`exclusive`, `posts`.`uploaded_to_s3`, `posts`.`uploaded_to_s3_video`, (select count(*) from `favorite_posts` where `posts`.`id` = `favorite_posts`.`post_id` and `favorite_posts`.`user_id` = -50) as `user_fav_count` from `posts` where (`category_id` = 1 and `country_id` = 20) and (`posts`.`sys_status` = 1 and `posts`.`status` = 'enabled') and `posts`.`deleted_at` is null and exists (select * from `users` where `posts`.`user_id` = `users`.`id`) and `posts`.`user_id` != 5716 order by RAND(id) limit 12
      1.75ms/app/Http/Controllers/website/PostController.php:1243tabbo_live_db_v3
      Metadata
      Bindings
      • 0. -50
      • 1. 1
      • 2. 20
      • 3. 1
      • 4. enabled
      • 5. 5716
      Backtrace
      • 14. /app/Http/Controllers/website/PostController.php:1243
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `posts`.`id`, `posts`.`sold`, `posts`.`promotion_id`, `posts`.`valid_until`, `posts`.`sys_status`, `posts`.`reject_reason`, `posts`.`category_id`, `posts`.`approved_at`, `posts`.`status`, `posts`.`video`, `posts`.`video_thumb`, `posts`.`is_iskan`, `posts`.`company_id`, `posts`.`iskan_project_id`, `posts`.`description`, `posts`.`price_to`, `posts`.`price_from`, `posts`.`other_region`, `posts`.`country_id`, `posts`.`region_id`, `posts`.`city_id`, `posts`.`ad_type`, `posts`.`title`, `posts`.`long`, `posts`.`lat`, `posts`.`image`, `posts`.`price`, `posts`.`user_id`, `posts`.`created_at`, `posts`.`out_side_images`, `posts`.`out_side_thumb`, `posts`.`is_corporate`, `posts`.`report_result`, `posts`.`video360`, `posts`.`youtube_video`, `posts`.`qr_code`, `posts`.`exclusive`, `posts`.`uploaded_to_s3`, `posts`.`uploaded_to_s3_video`, (select count(*) from `favorite_posts` where `posts`.`id` = `favorite_posts`.`post_id` and `favorite_posts`.`user_id` = -50) as `user_fav_count` from `posts` where (`country_id` = 20) and (`posts`.`sys_status` = 1 and `posts`.`status` = 'enabled') and `posts`.`deleted_at` is null and exists (select * from `users` where `posts`.`user_id` = `users`.`id`) and `posts`.`user_id` != 5716 order by RAND() limit 12
      1.43ms/app/Http/Controllers/website/PostController.php:1252tabbo_live_db_v3
      Metadata
      Bindings
      • 0. -50
      • 1. 20
      • 2. 1
      • 3. enabled
      • 4. 5716
      Backtrace
      • 14. /app/Http/Controllers/website/PostController.php:1252
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `en_name` as `name`, `id`, `iso`, `en_currency` as `currency`, `symbol` from `countries` where `countries`.`id` in (20)
      610μs/app/Http/Controllers/website/PostController.php:1252tabbo_live_db_v3
      Metadata
      Backtrace
      • 19. /app/Http/Controllers/website/PostController.php:1252
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `en_name` as `name`, `id` from `cities` where `cities`.`id` in (530)
      510μs/app/Http/Controllers/website/PostController.php:1252tabbo_live_db_v3
      Metadata
      Backtrace
      • 19. /app/Http/Controllers/website/PostController.php:1252
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `en_name` as `name`, `id` from `regions` where 0 = 1
      410μs/app/Http/Controllers/website/PostController.php:1252tabbo_live_db_v3
      Metadata
      Backtrace
      • 19. /app/Http/Controllers/website/PostController.php:1252
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `regions`.`en_name` as `name`, `regions`.`id`, `post_regions`.`post_id` as `pivot_post_id`, `post_regions`.`region_id` as `pivot_region_id` from `regions` inner join `post_regions` on `regions`.`id` = `post_regions`.`region_id` where `post_regions`.`post_id` in (8813)
      470μs/app/Http/Controllers/website/PostController.php:1252tabbo_live_db_v3
      Metadata
      Backtrace
      • 18. /app/Http/Controllers/website/PostController.php:1252
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `en_name` as `name`, `image`, `id`, `en_slug` as `slug`, `en_slug` from `categories` where `categories`.`id` in (10)
      370μs/app/Http/Controllers/website/PostController.php:1252tabbo_live_db_v3
      Metadata
      Backtrace
      • 19. /app/Http/Controllers/website/PostController.php:1252
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `promotion_packages` where 0 = 1
      380μs/app/Http/Controllers/website/PostController.php:1252tabbo_live_db_v3
      Metadata
      Backtrace
      • 19. /app/Http/Controllers/website/PostController.php:1252
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select `campaign_media`.*, `campaigns`.`user_id`, `campaigns`.`media_type`, `users`.`username`, `users`.`name` as `profile_name`, `campaigns`.`start_date`, `campaigns`.`end_date`, `registered_company`.`name` as `company_name`, `registered_company`.`id` as `company_id`, CONCAT('https://6aboo-uploads3.s3.me-south-1.amazonaws.com/profile/' , users.profile_image ) as profile_image, CONCAT('https://6aboo-uploads3.s3.me-south-1.amazonaws.com/companies/' , registered_company.logo ) as logo from `campaign_media` inner join `campaigns` on `campaigns`.`id` = `campaign_media`.`campaign_id` inner join `users` on `users`.`id` = `campaigns`.`user_id` left join `registered_company` on `registered_company`.`company_type` = `campaigns`.`company_type` and registered_company.user_id = campaigns.user_id where `campaigns`.`country_id` = 20 and exists (select * from `campaigns` where `campaign_media`.`campaign_id` = `campaigns`.`id` and exists (select * from `campaign_places` where `campaigns`.`id` = `campaign_places`.`campaign_id` and `place` in ('posts_list', 'all'))) and `campaigns`.`media_type` != 'slider' and `campaigns`.`status` = 'approved' and `campaigns`.`sys_status` = 1 and `campaigns`.`transaction_status` = 1 and `percent` <= 150 order by `percent` asc limit 20
      1.04ms/app/Http/Controllers/InjectionController.php:184tabbo_live_db_v3
      Metadata
      Bindings
      • 0. 20
      • 1. posts_list
      • 2. all
      • 3. slider
      • 4. approved
      • 5. 1
      • 6. 1
      • 7. 150
      Backtrace
      • 14. /app/Http/Controllers/InjectionController.php:184
      • 15. /app/Http/Controllers/website/PostController.php:1274
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
    • select `campaigns`.*, `users`.`username`, `registered_company`.`name` as `company_name`, `registered_company`.`id` as `company_id`, `users`.`name` as `profile_name`, CONCAT('https://6aboo-uploads3.s3.me-south-1.amazonaws.com/companies/' , registered_company.logo ) as logo, CONCAT('https://6aboo-uploads3.s3.me-south-1.amazonaws.com/profile/' , users.profile_image ) as profile_image from `campaigns` left join `registered_company` on `registered_company`.`company_type` = `campaigns`.`company_type` and registered_company.user_id = campaigns.user_id inner join `users` on `users`.`id` = `campaigns`.`user_id` where `campaigns`.`country_id` = 20 and exists (select * from `campaign_places` where `campaigns`.`id` = `campaign_places`.`campaign_id` and `place` in ('posts_list', 'all')) and `campaigns`.`status` = 'approved' and `campaigns`.`sys_status` = 1 and `campaigns`.`media_type` = 'slider' and `campaigns`.`transaction_status` = 1 and `percent` <= 150 and exists (select * from `campaign_media` where `campaigns`.`id` = `campaign_media`.`campaign_id`) order by `percent` asc limit 20
      990μs/app/Http/Controllers/InjectionController.php:100tabbo_live_db_v3
      Metadata
      Bindings
      • 0. 20
      • 1. posts_list
      • 2. all
      • 3. approved
      • 4. 1
      • 5. slider
      • 6. 1
      • 7. 150
      Backtrace
      • 14. /app/Http/Controllers/InjectionController.php:100
      • 15. /app/Http/Controllers/website/PostController.php:1275
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
    • select `id`, `screen`, `name`, `screen_value`, `position`, `banner_index`, `en_image` as `image` from `banners` where `page` = 'posts_list' and `position` = 'by_index' order by RAND()
      630μs/app/Http/Controllers/website/PostController.php:1295tabbo_live_db_v3
      Metadata
      Bindings
      • 0. posts_list
      • 1. by_index
      Backtrace
      • 14. /app/Http/Controllers/website/PostController.php:1295
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:261
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    App\Models\Post
    1
    App\Models\City
    2
    App\Models\Category
    2
    App\Models\Country
    2
    App\Models\AppSettings
    1
        _token
        9Wg1IZUeWdMHHQhnPRPjhdMFyEJuuhDS8wB7AK2n
        enable_promotion
        true
        request_location
        {#2740 +"countryName": "Jordan" +"countryCode": "US" +"latitude": "31.9522" +"longitude": "3...
        session_country
        array:9 [ "id" => 20 "name" => "Tunisia" "currency" => "TND" "ar_name" => "تونس" "en_name"...
        _previous
        array:1 [ "url" => "http://tn.6abbo.com/en/apartment-Offered-for-sale/nabeul" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /en/apartment-Offered-for-sale/nabeul
        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:22 [ "cf-visitor" => array:1 [ 0 => "{"scheme":"https"}" ] "cf-ipcountry" => array:1 [ 0 => "US" ] "cf-connecting-ip" => array:1 [ 0 => "216.73.216.109" ] "cdn-loop" => array:1 [ 0 => "cloudflare; loops=1" ] "host" => array:1 [ 0 => "tn.6abbo.com" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "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" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "cf-ray" => array:1 [ 0 => "9512d6d94df195c1-ORD" ] "accept-encoding" => array:1 [ 0 => "gzip, br" ] "priority" => array:1 [ 0 => "u=0, i" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "x-forwarded-for" => array:1 [ 0 => "216.73.216.109" ] ]
        request_server
        0 of 0
        array:51 [ "USER" => "www-data" "HOME" => "/var/www" "SCRIPT_NAME" => "/index.php" "REQUEST_URI" => "/en/apartment-Offered-for-sale/nabeul" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/1.1" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/en/apartment-Offered-for-sale/nabeul" "REMOTE_PORT" => "10520" "SCRIPT_FILENAME" => "//data/6abbo/v2/public/index.php" "SERVER_ADMIN" => "support@cloudvertex.net" "CONTEXT_DOCUMENT_ROOT" => "/data/6abbo/v2/public" "CONTEXT_PREFIX" => "" "REQUEST_SCHEME" => "http" "DOCUMENT_ROOT" => "/data/6abbo/v2/public" "REMOTE_ADDR" => "216.73.216.109" "SERVER_PORT" => "80" "SERVER_ADDR" => "10.0.0.4" "SERVER_NAME" => "tn.6abbo.com" "SERVER_SOFTWARE" => "Apache/2.4.52 (Ubuntu)" "SERVER_SIGNATURE" => "<address>Apache/2.4.52 (Ubuntu) Server at tn.6abbo.com Port 80</address>\n" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin" "HTTP_CF_VISITOR" => "{"scheme":"https"}" "HTTP_CF_IPCOUNTRY" => "US" "HTTP_CF_CONNECTING_IP" => "216.73.216.109" "HTTP_CDN_LOOP" => "cloudflare; loops=1" "HTTP_HOST" => "tn.6abbo.com" "HTTP_X_FORWARDED_PROTO" => "https" "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_SEC_FETCH_DEST" => "document" "HTTP_CF_RAY" => "9512d6d94df195c1-ORD" "HTTP_ACCEPT_ENCODING" => "gzip, br" "HTTP_PRIORITY" => "u=0, i" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_X_FORWARDED_FOR" => "216.73.216.109" "proxy-nokeepalive" => "1" "REDIRECT_STATUS" => "200" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1750166373.4711 "REQUEST_TIME" => 1750166373 ]
        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 => "Tue, 17 Jun 2025 13:19:34 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjM1Rkw1NTRlWmhiOEp6YWl4UVNWdlE9PSIsInZhbHVlIjoiNm1PWVNhMmhYQTU2blpNVWgyMncxalZTZGtZaS9MSkRyVnVwTkViV3VjSUVBRlJ6cGh2RzV6NkJEaUM0dE55Q0JxdnBYNFRqQmtNVlFCbHltWU1zdWM4NFRlZ2wwNW1HUmJrRWs0ZVBINlliQUdpLzgyU09hVmFvSE4rL1FDM1kiLCJtYWMiOiIwYmQ1Y2Q0OTliYTNiOTI0ODViNDJiM2JmY2U1NDMzNzU2M2Y0YjkwMmUyMzY3MmYyNTEzMTVmNmNhNjA5YTg3IiwidGFnIjoiIn0%3D; expires=Thu, 19-Jun-2025 13:19:34 GMT; Max-Age=172800; path=/; domain=.6abbo.com; samesite=laxXSRF-TOKEN=eyJpdiI6IjM1Rkw1NTRlWmhiOEp6YWl4UVNWdlE9PSIsInZhbHVlIjoiNm1PWVNhMmhYQTU2blpNVWgyMncxalZTZGtZaS9MSkRyVnVwTkViV3VjSUVBRlJ6cGh2RzV6NkJEaUM0dE55Q0JxdnBYN" 1 => "new_6abbo_com_session=eyJpdiI6InpmYmI1ZEpYMWg2T2crNFlRaE5QN1E9PSIsInZhbHVlIjoiWmVYdTNDMUFpZytLTm1JVW4wT3JLTTJyYzVWZDIyc0NSeUtJQUFOdjRDNVlrOGtseVFWcHZlZit3MWhWSHpiaG0rdndHbjBKWWROcUk3UE9JYWVMd1VhdjdrbVY5cVdMeVRvcnp5aW1Vcm9iYlY3Y0F2b3o5b0pNeDNmbkkyeGkiLCJtYWMiOiI1NjY0MjMzMDlhYThlMDkwY2QxYWMzZDMyMTdiMTlhYTAyNGQxZDk1ZWFhZjU1NmY0ZGZiYzI2NWUwZDNlMmNhIiwidGFnIjoiIn0%3D; expires=Thu, 19-Jun-2025 13:19:34 GMT; Max-Age=172800; path=/; domain=.6abbo.com; httponly; samesite=laxnew_6abbo_com_session=eyJpdiI6InpmYmI1ZEpYMWg2T2crNFlRaE5QN1E9PSIsInZhbHVlIjoiWmVYdTNDMUFpZytLTm1JVW4wT3JLTTJyYzVWZDIyc0NSeUtJQUFOdjRDNVlrOGtseVFWcHZlZit3MWhWSH" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjM1Rkw1NTRlWmhiOEp6YWl4UVNWdlE9PSIsInZhbHVlIjoiNm1PWVNhMmhYQTU2blpNVWgyMncxalZTZGtZaS9MSkRyVnVwTkViV3VjSUVBRlJ6cGh2RzV6NkJEaUM0dE55Q0JxdnBYNFRqQmtNVlFCbHltWU1zdWM4NFRlZ2wwNW1HUmJrRWs0ZVBINlliQUdpLzgyU09hVmFvSE4rL1FDM1kiLCJtYWMiOiIwYmQ1Y2Q0OTliYTNiOTI0ODViNDJiM2JmY2U1NDMzNzU2M2Y0YjkwMmUyMzY3MmYyNTEzMTVmNmNhNjA5YTg3IiwidGFnIjoiIn0%3D; expires=Thu, 19-Jun-2025 13:19:34 GMT; domain=.6abbo.com; path=/XSRF-TOKEN=eyJpdiI6IjM1Rkw1NTRlWmhiOEp6YWl4UVNWdlE9PSIsInZhbHVlIjoiNm1PWVNhMmhYQTU2blpNVWgyMncxalZTZGtZaS9MSkRyVnVwTkViV3VjSUVBRlJ6cGh2RzV6NkJEaUM0dE55Q0JxdnBYN" 1 => "new_6abbo_com_session=eyJpdiI6InpmYmI1ZEpYMWg2T2crNFlRaE5QN1E9PSIsInZhbHVlIjoiWmVYdTNDMUFpZytLTm1JVW4wT3JLTTJyYzVWZDIyc0NSeUtJQUFOdjRDNVlrOGtseVFWcHZlZit3MWhWSHpiaG0rdndHbjBKWWROcUk3UE9JYWVMd1VhdjdrbVY5cVdMeVRvcnp5aW1Vcm9iYlY3Y0F2b3o5b0pNeDNmbkkyeGkiLCJtYWMiOiI1NjY0MjMzMDlhYThlMDkwY2QxYWMzZDMyMTdiMTlhYTAyNGQxZDk1ZWFhZjU1NmY0ZGZiYzI2NWUwZDNlMmNhIiwidGFnIjoiIn0%3D; expires=Thu, 19-Jun-2025 13:19:34 GMT; domain=.6abbo.com; path=/; httponlynew_6abbo_com_session=eyJpdiI6InpmYmI1ZEpYMWg2T2crNFlRaE5QN1E9PSIsInZhbHVlIjoiWmVYdTNDMUFpZytLTm1JVW4wT3JLTTJyYzVWZDIyc0NSeUtJQUFOdjRDNVlrOGtseVFWcHZlZit3MWhWSH" ] ]
        session_attributes
        0 of 0
        array:7 [ "_token" => "9Wg1IZUeWdMHHQhnPRPjhdMFyEJuuhDS8wB7AK2n" "enable_promotion" => true "request_location" => {#2740 +"countryName": "Jordan" +"countryCode": "US" +"latitude": "31.9522" +"longitude": "35.939" +"timezone": "Asia/Amman" +"time_zone": array:29 [ 0 => "America/Adak" 1 => "America/Anchorage" 2 => "America/Boise" 3 => "America/Chicago" 4 => "America/Denver" 5 => "America/Detroit" 6 => "America/Indiana/Indianapolis" 7 => "America/Indiana/Knox" 8 => "America/Indiana/Marengo" 9 => "America/Indiana/Petersburg" 10 => "America/Indiana/Tell_City" 11 => "America/Indiana/Vevay" 12 => "America/Indiana/Vincennes" 13 => "America/Indiana/Winamac" 14 => "America/Juneau" 15 => "America/Kentucky/Louisville" 16 => "America/Kentucky/Monticello" 17 => "America/Los_Angeles" 18 => "America/Menominee" 19 => "America/Metlakatla" 20 => "America/New_York" 21 => "America/Nome" 22 => "America/North_Dakota/Beulah" 23 => "America/North_Dakota/Center" 24 => "America/North_Dakota/New_Salem" 25 => "America/Phoenix" 26 => "America/Sitka" 27 => "America/Yakutat" 28 => "Pacific/Honolulu" ] } "session_country" => array:9 [ "id" => 20 "name" => "Tunisia" "currency" => "TND" "ar_name" => "تونس" "en_name" => "Tunisia" "cover_photo" => "https://6abbo.com/assets/images/countries/Tunisia.webp" "iso" => "TN" "symbol" => "د.ت" "flag" => array:3 [ "png32" => "https://tn.6abbo.com/assets/flags/PNG-32/TN-32.png" "png128" => "https://tn.6abbo.com/assets/flags/PNG-128/TN-128.png" "svg" => "https://tn.6abbo.com/assets/flags/SVG/TN.svg" ] ] "_previous" => array:1 [ "url" => "http://tn.6abbo.com/en/apartment-Offered-for-sale/nabeul" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]