Hiển thị 1-1 của 1 công việc
Trình diễn:
Sắp xếp theo:
Request history8.2.22PHP Version491msRequest Duration7MBMemory UsageGET job-tags/{slug}Route
    • Booting (83.88ms)time
    • Application (407ms)time
    • 1 x Application (82.92%)
      407ms
      1 x Booting (17.07%)
      83.88ms
      30 templates were rendered
      • theme.jobbox::views.job-board.job-tagjob-tag.blade.php#?blade
      • theme.jobbox::partials.breadcrumbsbreadcrumbs.blade.php#?blade
      • theme.jobbox::views.job-board.partials.job-itemsjob-items.blade.php#?blade
      • theme.jobbox::views.job-board.partials.sort-by-dropdownsort-by-dropdown.blade.php#?blade
      • theme.jobbox::partials.loadingloading.blade.php#?blade
      • theme.jobbox::views.job-board.partials.job-item-listjob-item-list.blade.php#?blade
      • theme.jobbox::partials.salarysalary.blade.php#?blade
      • theme.jobbox::partials.apply-buttonapply-button.blade.php#?blade
      • theme.jobbox::partials.paginationpagination.blade.php#?blade
      • theme.jobbox::views.job-board.partials.filtersfilters.blade.php#?blade
      • theme.jobbox::layouts.defaultdefault.blade.php#?blade
      • theme.jobbox::partials.headerheader.blade.php#?blade
      • theme.jobbox::partials.theme-metatheme-meta.blade.php#?blade
      • packages/theme::partials.headerheader.blade.php#?blade
      • theme.jobbox::partials.navbarnavbar.blade.php#?blade
      • theme.jobbox::partials.apply-modalapply-modal.blade.php#?blade
      • theme.jobbox::partials.main-menumain-menu.blade.php#?blade
      • theme.jobbox::partials.main-menumain-menu.blade.php#?blade
      • theme.jobbox::partials.language-and-currency-switcher-mobilelanguage-and-currency-switcher-mobile.blade.php#?blade
      • __components::f3563455b4bde30d1fbc156bd8af4463f3563455b4bde30d1fbc156bd8af4463.blade.php#?blade
      • __components::f3bda349c5da045c59e60207583e7008f3bda349c5da045c59e60207583e7008.blade.php#?blade
      • theme.jobbox::partials.footerfooter.blade.php#?blade
      • theme.jobbox::partials.support-menusupport-menu.blade.php#?blade
      • theme.jobbox::partials.support-menusupport-menu.blade.php#?blade
      • theme.jobbox::partials.support-menusupport-menu.blade.php#?blade
      • plugins/job-board::themes.dashboard.partials.language-switcherlanguage-switcher.blade.php#?blade
      • plugins/job-board::themes.dashboard.partials.currency-switchercurrency-switcher.blade.php#?blade
      • packages/theme::partials.footerfooter.blade.php#?blade
      • packages/theme::partials.facebook-integrationfacebook-integration.blade.php#?blade
      • plugins/cookie-consent::indexindex.blade.php#?blade
      uri
      GET job-tags/{slug}
      middleware
      web, core, localeSessionRedirect, localizationRedirect
      as
      public.job-tag
      controller
      Botble\JobBoard\Http\Controllers\Fronts\PublicController@getJobTag
      namespace
      Botble\JobBoard\Http\Controllers\Fronts
      prefix
      /
      where
      file
      platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:577-643
      41 statements were executed (4 duplicates)Show only duplicates229ms
      • BaseQueryBuilder.php#48viec_vietlamgap_15.81msselect * from `slugs` where (`key` = 'phong-chay-chua-chay' and `prefix` = 'job-tags') or exists (select * from `slugs_translations` where `slugs`.`id` = `slugs_translations`.`slugs_id` and (`key` = 'phong-chay-chua-chay' and `prefix` = 'job-tags')) limit 1
        Bindings
        • 0: phong-chay-chua-chay
        • 1: job-tags
        • 2: phong-chay-chua-chay
        • 3: job-tags
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/packages/slug/src/SlugHelper.php:161
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:579
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • BaseQueryBuilder.php#48viec_vietlamgap_1610μsselect * from `jb_tags` where (`id` = 1890 and `status` = 'published') limit 1
        Bindings
        • 0: 1890
        • 1: published
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:597
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • BaseQueryBuilder.php#48viec_vietlamgap_1550μsselect `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_type` = 'Botble\\JobBoard\\Models\\Tag' and `slugs`.`reference_id` = 1890 and `slugs`.`reference_id` is not null limit 1
        Bindings
        • 0: Botble\JobBoard\Models\Tag
        • 1: 1890
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/base/src/Models/BaseModel.php:28
        • platform/packages/slug/src/Providers/SlugServiceProvider.php:118
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:603
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • RepositoriesAbstract.php#363viec_vietlamgap_1810μsselect count(*) as aggregate from `jb_jobs` where (`jb_jobs`.`moderation_status` = 'approved' and `jb_jobs`.`status` = 'published') and (`expire_date` >= '2025-05-11 18:42:21' or `expire_date` is null or `never_expired` = 1) and exists (select * from `jb_tags` inner join `jb_jobs_tags` on `jb_tags`.`id` = `jb_jobs_tags`.`tag_id` where `jb_jobs`.`id` = `jb_jobs_tags`.`job_id` and `jb_tags`.`id` in (1890))
        Bindings
        • 0: approved
        • 1: published
        • 2: 2025-05-11 18:42:21
        • 3: 1
        • 4: 1890
        Backtrace
        • platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:363
        • platform/plugins/job-board/src/Repositories/Eloquent/JobRepository.php:73
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:622
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • BaseQueryBuilder.php#48viec_vietlamgap_12msselect `jb_jobs`.*, (select count(*) from `jb_applications` where `jb_jobs`.`id` = `jb_applications`.`job_id`) as `applicants_count` from `jb_jobs` where (`jb_jobs`.`moderation_status` = 'approved' and `jb_jobs`.`status` = 'published') and (`expire_date` >= '2025-05-11 18:42:21' or `expire_date` is null or `never_expired` = 1) and exists (select * from `jb_tags` inner join `jb_jobs_tags` on `jb_tags`.`id` = `jb_jobs_tags`.`tag_id` where `jb_jobs`.`id` = `jb_jobs_tags`.`job_id` and `jb_tags`.`id` in (1890)) order by `created_at` desc, `is_featured` desc limit 12 offset 0
        Bindings
        • 0: approved
        • 1: published
        • 2: 2025-05-11 18:42:21
        • 3: 1
        • 4: 1890
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:363
        • platform/plugins/job-board/src/Repositories/Eloquent/JobRepository.php:73
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:622
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • BaseQueryBuilder.php#48viec_vietlamgap_1510μsselect `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (1344) and `slugs`.`reference_type` = 'Botble\\JobBoard\\Models\\Job'
        Bindings
        • 0: Botble\JobBoard\Models\Job
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:363
        • platform/plugins/job-board/src/Repositories/Eloquent/JobRepository.php:73
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:622
      • BaseQueryBuilder.php#48viec_vietlamgap_1560μsselect `jb_tags`.*, `jb_jobs_tags`.`job_id` as `pivot_job_id`, `jb_jobs_tags`.`tag_id` as `pivot_tag_id` from `jb_tags` inner join `jb_jobs_tags` on `jb_tags`.`id` = `jb_jobs_tags`.`tag_id` where `jb_jobs_tags`.`job_id` in (1344)
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:363
        • platform/plugins/job-board/src/Repositories/Eloquent/JobRepository.php:73
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:622
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • BaseQueryBuilder.php#48viec_vietlamgap_1730μsselect `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (40, 52, 98, 1834, 1889, 1890, 1891, 1892, 1893, 1894, 1895, 1896, 1897) and `slugs`.`reference_type` = 'Botble\\JobBoard\\Models\\Tag'
        Bindings
        • 0: Botble\JobBoard\Models\Tag
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:363
        • platform/plugins/job-board/src/Repositories/Eloquent/JobRepository.php:73
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:622
      • BaseQueryBuilder.php#48viec_vietlamgap_11.59msselect `jb_job_types`.*, `jb_jobs_types`.`job_id` as `pivot_job_id`, `jb_jobs_types`.`job_type_id` as `pivot_job_type_id` from `jb_job_types` inner join `jb_jobs_types` on `jb_job_types`.`id` = `jb_jobs_types`.`job_type_id` where `jb_jobs_types`.`job_id` in (1344)
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:363
        • platform/plugins/job-board/src/Repositories/Eloquent/JobRepository.php:73
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:622
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • BaseQueryBuilder.php#48viec_vietlamgap_1680μsselect * from `jb_companies` where `jb_companies`.`id` in (918)
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:363
        • platform/plugins/job-board/src/Repositories/Eloquent/JobRepository.php:73
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:622
      • BaseQueryBuilder.php#48viec_vietlamgap_1590μsselect `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (918) and `slugs`.`reference_type` = 'Botble\\JobBoard\\Models\\Company'
        Bindings
        • 0: Botble\JobBoard\Models\Company
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:363
        • platform/plugins/job-board/src/Repositories/Eloquent/JobRepository.php:73
      • BaseQueryBuilder.php#48viec_vietlamgap_1440μsselect * from `jb_currencies` where `jb_currencies`.`id` in (1)
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:363
        • platform/plugins/job-board/src/Repositories/Eloquent/JobRepository.php:73
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:622
      • BaseQueryBuilder.php#48viec_vietlamgap_1400μsselect * from `countries` where `countries`.`id` in (1)
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:363
        • platform/plugins/job-board/src/Repositories/Eloquent/JobRepository.php:73
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:622
      • BaseQueryBuilder.php#48viec_vietlamgap_1400μsselect * from `states` where `states`.`id` in (33)
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/support/src/Repositories/Eloquent/RepositoriesAbstract.php:363
        • platform/plugins/job-board/src/Repositories/Eloquent/JobRepository.php:73
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:622
      • BaseQueryBuilder.php#48viec_vietlamgap_1610μsselect * from `jb_categories` where `status` = 'published'
        Bindings
        • 0: published
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:548
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:635
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • BaseQueryBuilder.php#48viec_vietlamgap_1430μsselect * from `jb_job_types` where `status` = 'published'
        Bindings
        • 0: published
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:549
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:635
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • BaseQueryBuilder.php#48viec_vietlamgap_1400μsselect * from `jb_job_experiences` where `status` = 'published'
        Bindings
        • 0: published
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:550
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:635
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • BaseQueryBuilder.php#48viec_vietlamgap_1400μsselect * from `jb_job_skills` where `status` = 'published'
        Bindings
        • 0: published
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:551
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:635
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • BaseQueryBuilder.php#48viec_vietlamgap_1102msselect `id`, (select count(*) from `jb_jobs` inner join `jb_jobs_categories` on `jb_jobs`.`id` = `jb_jobs_categories`.`job_id` where `jb_categories`.`id` = `jb_jobs_categories`.`category_id` and `jb_jobs`.`status` = 'published' and (`expire_date` >= '2025-05-11 18:42:21' or `expire_date` is null or `never_expired` = 1)) as `jobs_count` from `jb_categories` where `jb_categories`.`id` in (13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 60, 61, 62, 63, 64, 65)
        Bindings
        • 0: published
        • 1: 2025-05-11 18:42:21
        • 2: 1
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:563
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:635
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • BaseQueryBuilder.php#48viec_vietlamgap_16.64msselect `id`, (select count(*) from `jb_jobs` inner join `jb_jobs_types` on `jb_jobs`.`id` = `jb_jobs_types`.`job_id` where `jb_job_types`.`id` = `jb_jobs_types`.`job_type_id` and `jb_jobs`.`status` = 'published' and (`expire_date` >= '2025-05-11 18:42:21' or `expire_date` is null or `never_expired` = 1)) as `jobs_count` from `jb_job_types` where `jb_job_types`.`id` in (6, 7, 8, 9, 10, 11)
        Bindings
        • 0: published
        • 1: 2025-05-11 18:42:21
        • 2: 1
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:565
        • platform/plugins/job-board/src/Http/Controllers/Fronts/PublicController.php:635
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • BaseQueryBuilder.php#48viec_vietlamgap_1520μsselect `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_id` in (1890) and `meta_boxes`.`reference_type` = 'Botble\\JobBoard\\Models\\Tag'
        Bindings
        • 0: Botble\JobBoard\Models\Tag
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/packages/seo-helper/src/Providers/HookServiceProvider.php:86
        • platform/core/base/helpers/action-filter.php:46
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • BaseQueryBuilder.php#48viec_vietlamgap_1630μsselect * from `jb_currencies` order by `order` asc
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/plugins/job-board/src/Supports/CurrencySupport.php:101
        • platform/plugins/job-board/src/Supports/CurrencySupport.php:36
        • platform/plugins/job-board/helpers/currencies.php:142
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • BaseQueryBuilder.php#48viec_vietlamgap_169.71msselect `jb_categories`.*, (select count(*) from `jb_jobs` inner join `jb_jobs_categories` on `jb_jobs`.`id` = `jb_jobs_categories`.`job_id` where `jb_categories`.`id` = `jb_jobs_categories`.`category_id` and (`jb_jobs`.`moderation_status` = 'approved' and `jb_jobs`.`status` = 'published') and (`expire_date` >= '2025-05-11 18:42:22' or `expire_date` is null or `never_expired` = 1)) as `jobs_count` from `jb_categories` where `status` = 'published' order by `jobs_count` desc, `created_at` desc
        Bindings
        • 0: approved
        • 1: published
        • 2: 2025-05-11 18:42:22
        • 3: 1
        • 4: published
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/plugins/job-board/src/Supports/JobBoardHelper.php:456
        • platform/plugins/job-board/src/Supports/JobBoardHelper.php:524
        • view::theme.jobbox::views.job-board.partials.filters:3
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • BaseQueryBuilder.php#48viec_vietlamgap_13.32msselect `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 60, 61, 62, 63, 64, 65) and `slugs`.`reference_type` = 'Botble\\JobBoard\\Models\\Category'
        Bindings
        • 0: Botble\JobBoard\Models\Category
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/plugins/job-board/src/Supports/JobBoardHelper.php:456
        • platform/plugins/job-board/src/Supports/JobBoardHelper.php:524
        • view::theme.jobbox::views.job-board.partials.filters:3
      • BaseQueryBuilder.php#48viec_vietlamgap_121.49msselect `jb_job_types`.*, (select count(*) from `jb_jobs` inner join `jb_jobs_types` on `jb_jobs`.`id` = `jb_jobs_types`.`job_id` where `jb_job_types`.`id` = `jb_jobs_types`.`job_type_id` and (`jb_jobs`.`moderation_status` = 'approved' and `jb_jobs`.`status` = 'published') and (`expire_date` >= '2025-05-11 18:42:22' or `expire_date` is null or `never_expired` = 1)) as `jobs_count` from `jb_job_types` where `status` = 'published' order by `jobs_count` desc, `created_at` desc
        Bindings
        • 0: approved
        • 1: published
        • 2: 2025-05-11 18:42:22
        • 3: 1
        • 4: published
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/plugins/job-board/src/Supports/JobBoardHelper.php:471
        • platform/plugins/job-board/src/Supports/JobBoardHelper.php:525
        • view::theme.jobbox::views.job-board.partials.filters:3
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • BaseQueryBuilder.php#48viec_vietlamgap_1570μsselect `jb_job_experiences`.*, (select count(*) from `jb_jobs` where `jb_job_experiences`.`id` = `jb_jobs`.`job_experience_id` and (`jb_jobs`.`moderation_status` = 'approved' and `jb_jobs`.`status` = 'published') and (`expire_date` >= '2025-05-11 18:42:22' or `expire_date` is null or `never_expired` = 1)) as `jobs_count` from `jb_job_experiences` where `status` = 'published' order by `order` asc, `created_at` asc, `jobs_count` desc, `created_at` desc
        Bindings
        • 0: approved
        • 1: published
        • 2: 2025-05-11 18:42:22
        • 3: 1
        • 4: published
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/plugins/job-board/src/Supports/JobBoardHelper.php:488
        • platform/plugins/job-board/src/Supports/JobBoardHelper.php:526
        • view::theme.jobbox::views.job-board.partials.filters:3
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • BaseQueryBuilder.php#48viec_vietlamgap_1470μsselect `jb_job_skills`.*, (select count(*) from `jb_jobs` inner join `jb_jobs_skills` on `jb_jobs`.`id` = `jb_jobs_skills`.`job_id` where `jb_job_skills`.`id` = `jb_jobs_skills`.`job_skill_id` and (`jb_jobs`.`moderation_status` = 'approved' and `jb_jobs`.`status` = 'published') and (`expire_date` >= '2025-05-11 18:42:22' or `expire_date` is null or `never_expired` = 1)) as `jobs_count` from `jb_job_skills` where `status` = 'published' order by `jobs_count` desc, `created_at` desc
        Bindings
        • 0: approved
        • 1: published
        • 2: 2025-05-11 18:42:22
        • 3: 1
        • 4: published
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/plugins/job-board/src/Supports/JobBoardHelper.php:503
        • platform/plugins/job-board/src/Supports/JobBoardHelper.php:527
        • view::theme.jobbox::views.job-board.partials.filters:3
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • BaseQueryBuilder.php#48viec_vietlamgap_1300μsselect `id`, `name` from `pages` where (`id` = '19' and `status` = 'published') limit 1
        Bindings
        • 0: 19
        • 1: published
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/plugins/job-board/src/Supports/JobBoardHelper.php:167
        • platform/plugins/job-board/src/Supports/JobBoardHelper.php:176
        • view::theme.jobbox::views.job-board.partials.filters:42
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • BaseQueryBuilder.php#48viec_vietlamgap_12.44msselect `id`, `key`, `reference_type`, `reference_id`, `prefix` from `slugs` where `slugs`.`reference_id` in (19) and `slugs`.`reference_type` = 'Botble\\Page\\Models\\Page'
        Bindings
        • 0: Botble\Page\Models\Page
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/plugins/job-board/src/Supports/JobBoardHelper.php:167
        • platform/plugins/job-board/src/Supports/JobBoardHelper.php:176
        • view::theme.jobbox::views.job-board.partials.filters:42
      • BaseQueryBuilder.php#48viec_vietlamgap_1630μsselect * from `menus` where `status` = 'published' and exists (select * from `language_meta` where `menus`.`id` = `language_meta`.`reference_id` and `language_meta`.`reference_type` = 'Botble\\Menu\\Models\\Menu' and `lang_meta_code` = 'vi_VN' and `lang_meta_code` = 'vi_VN')
        Bindings
        • 0: published
        • 1: Botble\Menu\Models\Menu
        • 2: vi_VN
        • 3: vi_VN
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/packages/menu/src/Menu.php:214
        • platform/packages/menu/src/Menu.php:197
        • platform/packages/menu/src/Menu.php:165
        • view::theme.jobbox::partials.navbar:30
      • BaseQueryBuilder.php#48viec_vietlamgap_1340μsselect * from `menu_nodes` where `menu_nodes`.`menu_id` in (1, 2, 4)
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/packages/menu/src/Menu.php:214
        • platform/packages/menu/src/Menu.php:197
        • platform/packages/menu/src/Menu.php:165
      • BaseQueryBuilder.php#48viec_vietlamgap_1300μsselect * from `menu_nodes` where `menu_nodes`.`parent_id` in (1, 8, 14, 21, 23, 27, 30, 31, 32, 33, 38, 39, 40, 41) order by `position` asc
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/packages/menu/src/Menu.php:214
        • platform/packages/menu/src/Menu.php:197
      • BaseQueryBuilder.php#48viec_vietlamgap_1360μsselect `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_id` in (1, 8, 14, 21, 23, 27, 30, 31, 32, 33, 38, 39, 40, 41) and `meta_boxes`.`reference_type` = 'Botble\\Menu\\Models\\MenuNode'
        Bindings
        • 0: Botble\Menu\Models\MenuNode
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/packages/menu/src/Menu.php:214
        • platform/packages/menu/src/Menu.php:197
      • BaseQueryBuilder.php#48viec_vietlamgap_1260μsselect * from `menu_locations` where `menu_locations`.`menu_id` in (1, 2, 4)
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/packages/menu/src/Menu.php:214
        • platform/packages/menu/src/Menu.php:197
        • platform/packages/menu/src/Menu.php:165
      • BaseQueryBuilder.php#48viec_vietlamgap_1270μsselect * from `pages` where `pages`.`id` in (7, 8, 10, 12, 13)
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/packages/menu/src/Menu.php:257
        • platform/packages/menu/src/Menu.php:175
        • view::theme.jobbox::partials.navbar:30
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • BaseQueryBuilder.php#48viec_vietlamgap_1270μsselect `lang_flag` from `languages` where `lang_name` = 'Tiếng Việt' limit 1
        Bindings
        • 0: Tiếng Việt
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/plugins/language/src/Providers/HookServiceProvider.php:81
        • platform/core/base/helpers/action-filter.php:39
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • BaseQueryBuilder.php#48viec_vietlamgap_1230μsselect `lang_flag` from `languages` where `lang_name` = 'English' limit 1
        Bindings
        • 0: English
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/plugins/language/src/Providers/HookServiceProvider.php:81
        • platform/core/base/helpers/action-filter.php:39
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • BaseQueryBuilder.php#48viec_vietlamgap_1230μsselect * from `widgets` where (`theme` = 'jobbox')
        Bindings
        • 0: jobbox
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/packages/widget/src/WidgetGroupCollection.php:92
        • platform/packages/widget/src/WidgetGroupCollection.php:79
        • platform/packages/widget/src/WidgetGroupCollection.php:65
        • platform/packages/widget/helpers/helpers.php:32
      • BaseQueryBuilder.php#48viec_vietlamgap_1260μsselect * from `pages` where `pages`.`id` in (10, 12)
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/packages/menu/src/Menu.php:257
        • platform/packages/menu/src/Menu.php:175
        • view::theme.jobbox::partials.footer:20
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • BaseQueryBuilder.php#48viec_vietlamgap_1220μsselect `lang_flag` from `languages` where `lang_name` = 'Tiếng Việt' limit 1
        Bindings
        • 0: Tiếng Việt
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/plugins/language/src/Providers/HookServiceProvider.php:81
        • platform/core/base/helpers/action-filter.php:39
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • BaseQueryBuilder.php#48viec_vietlamgap_1210μsselect `lang_flag` from `languages` where `lang_name` = 'English' limit 1
        Bindings
        • 0: English
        Backtrace
        • platform/core/base/src/Models/BaseQueryBuilder.php:48
        • platform/plugins/language/src/Providers/HookServiceProvider.php:81
        • platform/core/base/helpers/action-filter.php:39
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      Botble\JobBoard\Models\Category
      156Category.php#?
      Botble\Slug\Models\Slug
      70Slug.php#?
      Botble\JobBoard\Models\JobType
      19JobType.php#?
      Botble\JobBoard\Models\Tag
      14Tag.php#?
      Botble\Menu\Models\MenuNode
      14MenuNode.php#?
      Botble\Menu\Models\MenuLocation
      4MenuLocation.php#?
      Botble\Language\Models\Language
      4Language.php#?
      Botble\Menu\Models\Menu
      3Menu.php#?
      Botble\JobBoard\Models\Currency
      2Currency.php#?
      Botble\JobBoard\Models\Job
      1Job.php#?
      Botble\JobBoard\Models\Company
      1Company.php#?
      Botble\Location\Models\Country
      1Country.php#?
      Botble\Location\Models\State
      1State.php#?
      Botble\Page\Models\Page
      1Page.php#?
          _token
          xhDV67JqrBFq4A9WjKpkVV5VEa4GCXjDh4qCA6jS
          language
          vi
          _flash
          array:2 [ "new" => [] "old" => [] ]
          _previous
          array:1 [ "url" => "https://vieclamgap.vn/job-tags/phong-chay-chua-chay" ]
          path_info
          /job-tags/phong-chay-chua-chay
          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: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=eyJpdiI6InlweVVWYnF2UzNMRHUraXd0YTV2MlE9PSIsInZhbHVlIjoiSVBNV2JYWW03b1VXNjRFK1YxM3VJN1pNT2t3dW04VzdZMlRrOFZLdEU2cDRPRVhvRi9HQzhoVUJqelBKNDJiZnNseGV1MmxwSG45SHhydmZwYlVxcHA3bXBQczRHc1VxSkhtOENKVVVHTEQ2NjlNbW5CczhqcjZDdlp3YUJmWDIiLCJtYWMiOiJlMTNhYzIzODg3YmViZDI0YzhiM2FiYTkzODVjNWMxYzhhYjJjYWYyMTgzYzMyNjVkZGVhN2U1OTcxMjdhOTE4IiwidGFnIjoiIn0%3D; botble_session=eyJpdiI6ImJpL1MzcmJPbEd2OW5Vc3RzdkV0aGc9PSIsInZhbHVlIjoic0FKOGJteUErcEtHRVJNb2JwWE42azduYko4TWtYcUFBRXhMeFJXUVNzeFJKUnVXL2VWMUlRT1lJdTBJdXpjODR2UlY5SC9oeHNVbGRGSy92S3k4dHN0enplc0orcm5yVEVIZXVyTnlnNzBoRVY2MWZVU1dLb01yUUU4OWFlek4iLCJtYWMiOiJjODBhNGY0MzBhNjNiMTZhOWM3NDc2YmE3NjQ2YmM1MWNjYmNmMTI4M2ZmYTg0ZTgzNmQwOGU3YjAxYTI3Y2RkIiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6InlweVVWYnF2UzNMRHUraXd0YTV2MlE9PSIsInZhbHVlIjoiSVBNV2JYWW03b1VXNjRFK1YxM3VJN1pNT2t3dW04VzdZMlRrOFZLdEU2cDRPRVhvRi9HQzhoVUJqelBKNDJiZnNseGV1M" ] "host" => array:1 [ 0 => "vieclamgap.vn" ] "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 => "52.15.61.81" ] "cf-visitor" => array:1 [ 0 => "{"scheme":"https"}" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "priority" => array:1 [ 0 => "u=0, i" ] "cf-ray" => array:1 [ 0 => "93e16998ee9d61ac-ORD" ] "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" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "cdn-loop" => array:1 [ 0 => "cloudflare; loops=1" ] "cf-connecting-ip" => array:1 [ 0 => "52.15.61.81" ] "cf-ipcountry" => array:1 [ 0 => "US" ] ]
          request_cookies
          0 of 0
          array:2 [ "XSRF-TOKEN" => "xhDV67JqrBFq4A9WjKpkVV5VEa4GCXjDh4qCA6jS" "botble_session" => "D43tz1EqlIn4JxVgGWIghEMROGN1PGT6uTZ7DXZ0" ]
          response_headers
          0 of 0
          array:8 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Sun, 11 May 2025 11:42:22 GMT" ] "cms-version" => array:1 [ 0 => "7.3.3" ] "authorization-at" => array:1 [ 0 => "2024-12-05 07:31:55" ] "activated-license" => array:1 [ 0 => "No" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkQ5WGpJUzc5OXF4aHhWR3dob29tUXc9PSIsInZhbHVlIjoiRjVpeDhsNjdBVVUxZjBWL202WGlrb2t6L1liYWxtaEtVQ3VZVURqR0dlcUdaSHpKL0tkYi83cEl0bXh3V3VReDRRZE5LeGY5NUVNRjZ0WEZBcW40MnpaSjhVQVkwNHdwZmZySTVySEpCU3B4TDkySlF4YlB5dGs4NnNIMFljWnYiLCJtYWMiOiI3NmMzYzczYzRiZTA5MWNiY2U5MDhkZmYzZTQwMzMyMDZlYzg2ODQxOWU5ZTFkOGMwMmQ4ZGU0MDM5MDliZmYwIiwidGFnIjoiIn0%3D; expires=Sun, 11 May 2025 13:42:22 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IkQ5WGpJUzc5OXF4aHhWR3dob29tUXc9PSIsInZhbHVlIjoiRjVpeDhsNjdBVVUxZjBWL202WGlrb2t6L1liYWxtaEtVQ3VZVURqR0dlcUdaSHpKL0tkYi83cEl0bXh3V3VReDRRZE5Le" 1 => "botble_session=eyJpdiI6IklQd0YxV0NQeG5xb1BLOVJCejE4L3c9PSIsInZhbHVlIjoiNXNBRTVpb0NhZkxVMkVyRWtNVWM1STlsbGpxUlBmNjZncXVMRVZNaWZzSlJ2WElENEJtenhBYjFKOUl3MWFXWG4zRkM0cnlGUUR2QjM0a0JOTWtrTnlxZ3NrSTh1dnNmdHIyUTYySThNakdORWpndEE4SzcyS2tWbjhjbmpFQ0siLCJtYWMiOiI0MTQxMmJmOTg0ZjU1MDY5ODJlZmZiZmQ2MGE5NjU0MTVjZjIwMDg0ZWIwNWZiYjdiNWM0ZDBlZjdlNDdkYmQ3IiwidGFnIjoiIn0%3D; expires=Sun, 11 May 2025 13:42:22 GMT; Max-Age=7200; path=/; httponly; samesite=laxbotble_session=eyJpdiI6IklQd0YxV0NQeG5xb1BLOVJCejE4L3c9PSIsInZhbHVlIjoiNXNBRTVpb0NhZkxVMkVyRWtNVWM1STlsbGpxUlBmNjZncXVMRVZNaWZzSlJ2WElENEJtenhBYjFKOUl3MWFXWG4zR" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkQ5WGpJUzc5OXF4aHhWR3dob29tUXc9PSIsInZhbHVlIjoiRjVpeDhsNjdBVVUxZjBWL202WGlrb2t6L1liYWxtaEtVQ3VZVURqR0dlcUdaSHpKL0tkYi83cEl0bXh3V3VReDRRZE5LeGY5NUVNRjZ0WEZBcW40MnpaSjhVQVkwNHdwZmZySTVySEpCU3B4TDkySlF4YlB5dGs4NnNIMFljWnYiLCJtYWMiOiI3NmMzYzczYzRiZTA5MWNiY2U5MDhkZmYzZTQwMzMyMDZlYzg2ODQxOWU5ZTFkOGMwMmQ4ZGU0MDM5MDliZmYwIiwidGFnIjoiIn0%3D; expires=Sun, 11-May-2025 13:42:22 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkQ5WGpJUzc5OXF4aHhWR3dob29tUXc9PSIsInZhbHVlIjoiRjVpeDhsNjdBVVUxZjBWL202WGlrb2t6L1liYWxtaEtVQ3VZVURqR0dlcUdaSHpKL0tkYi83cEl0bXh3V3VReDRRZE5Le" 1 => "botble_session=eyJpdiI6IklQd0YxV0NQeG5xb1BLOVJCejE4L3c9PSIsInZhbHVlIjoiNXNBRTVpb0NhZkxVMkVyRWtNVWM1STlsbGpxUlBmNjZncXVMRVZNaWZzSlJ2WElENEJtenhBYjFKOUl3MWFXWG4zRkM0cnlGUUR2QjM0a0JOTWtrTnlxZ3NrSTh1dnNmdHIyUTYySThNakdORWpndEE4SzcyS2tWbjhjbmpFQ0siLCJtYWMiOiI0MTQxMmJmOTg0ZjU1MDY5ODJlZmZiZmQ2MGE5NjU0MTVjZjIwMDg0ZWIwNWZiYjdiNWM0ZDBlZjdlNDdkYmQ3IiwidGFnIjoiIn0%3D; expires=Sun, 11-May-2025 13:42:22 GMT; path=/; httponlybotble_session=eyJpdiI6IklQd0YxV0NQeG5xb1BLOVJCejE4L3c9PSIsInZhbHVlIjoiNXNBRTVpb0NhZkxVMkVyRWtNVWM1STlsbGpxUlBmNjZncXVMRVZNaWZzSlJ2WElENEJtenhBYjFKOUl3MWFXWG4zR" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "xhDV67JqrBFq4A9WjKpkVV5VEa4GCXjDh4qCA6jS" "language" => "vi" "_flash" => array:2 [ "new" => [] "old" => [] ] "_previous" => array:1 [ "url" => "https://vieclamgap.vn/job-tags/phong-chay-chua-chay" ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-05-11 18:42:22GET/job-tags/phong-chay-chua-chay3041291