Symfony Profiler

[
  "route" => "app_vendangeurs_home"
  "route_parameters" => [
    "_route" => "app_vendangeurs_home"
    "domain" => "www.vendangeur.com"
    "_controller" => "App\Controller\VendangeursController::index"
  ]
  "request_uri" => "https://www.vendangeur.com/"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "db"
    "port" => 3306
    "user" => "winejobr"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "winejobr"
    "serverVersion" => "11.4.0-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10, t0.photo AS photo_11, t0.duration AS duration_12, t0.has_housing AS has_housing_13, t0.latitude AS latitude_14, t0.longitude AS longitude_15, t0.created_at AS created_at_16, t0.view_count AS view_count_17, t0.status AS status_18, t0.offer_type AS offer_type_19, t0.stripe_session_id AS stripe_session_id_20, t0.company_id AS company_id_21, t0.category_id AS category_id_22 FROM job_offer t0 WHERE t0.contract_type = ? AND t0.status = ? ORDER BY t0.id DESC LIMIT 6"
  "params" => [
    1 => "Saisonnier / Vendanges"
    2 => "active"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1142
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1142}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.published AS published_7, t0.cover_image AS cover_image_8, t0.meta_description AS meta_description_9 FROM article t0 WHERE t0.published = ? ORDER BY t0.created_at DESC LIMIT 3"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1367
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.first_name AS first_name_1, e0_.last_name AS last_name_2, e0_.title AS title_3, e0_.bio AS bio_4, e0_.cv_url AS cv_url_5, e0_.avatar AS avatar_6, e0_.is_public AS is_public_7, e0_.phone AS phone_8, e0_.location AS location_9, e0_.skills_vigne AS skills_vigne_10, e0_.skills_cave AS skills_cave_11, e0_.engins AS engins_12, e0_.certifications AS certifications_13, e0_.cepages AS cepages_14, e0_.regions_voulu AS regions_voulu_15, e0_.disponibilites AS disponibilites_16, e0_.formation AS formation_17, e0_.mobilite_rayon AS mobilite_rayon_18, e0_.nourri_loge AS nourri_loge_19, e0_.user_id AS user_id_20 FROM employee_profile e0_ WHERE e0_.is_public = ? ORDER BY e0_.id DESC LIMIT 6"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1367
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.type AS type_1, r0_.status AS status_2, r0_.answers AS answers_3, r0_.comment AS comment_4, r0_.company_reply AS company_reply_5, r0_.company_reply_at AS company_reply_at_6, r0_.created_at AS created_at_7, r0_.deadline AS deadline_8, r0_.submitted_at AS submitted_at_9, r0_.published_at AS published_at_10, r0_.mission_id AS mission_id_11, r0_.author_id AS author_id_12 FROM review r0_ WHERE r0_.type = ? AND r0_.published_at IS NOT NULL ORDER BY r0_.published_at DESC LIMIT 3"
  "params" => [
    1 => "candidate_to_company"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1142
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3 FROM taxonomy t0 WHERE t0.type = ? ORDER BY t0.name ASC"
  "params" => [
    1 => "region"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1142
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT j0_.location AS location_0 FROM job_offer j0_ WHERE j0_.status = ? AND j0_.contract_type = ?"
  "params" => [
    1 => "active"
    2 => "Saisonnier / Vendanges"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1142
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1142}
  ]
]

[
  "sql" => "SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.account_type = ?"
  "params" => [
    1 => "candidate"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1142
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.account_type = ?"
  "params" => [
    1 => "recruiter"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1142
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(m0_.id) AS sclr_0 FROM mission m0_ WHERE m0_.status = ?"
  "params" => [
    1 => "completed"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1142
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(j0_.id) AS sclr_0 FROM job_offer j0_ WHERE j0_.status = ? AND j0_.contract_type = ?"
  "params" => [
    1 => "active"
    2 => "Saisonnier / Vendanges"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1142
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1142}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.domain AS domain_4, t0.is_active AS is_active_5 FROM faq t0 WHERE t0.is_active = ? AND t0.domain = ? ORDER BY t0.id ASC"
  "params" => [
    1 => 1
    2 => "vendangeurs.com"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1367
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1142
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.description AS description_3, t0.website AS website_4, t0.logo AS logo_5, t0.stripe_customer_id AS stripe_customer_id_6, t0.stripe_cvtheque_subscription_id AS stripe_cvtheque_subscription_id_7, t0.cvtheque_active AS cvtheque_active_8, t0.user_id AS user_id_9 FROM company_profile t0 WHERE t0.id = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1144
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.description AS description_3, t0.website AS website_4, t0.logo AS logo_5, t0.stripe_customer_id AS stripe_customer_id_6, t0.stripe_cvtheque_subscription_id AS stripe_cvtheque_subscription_id_7, t0.cvtheque_active AS cvtheque_active_8, t0.user_id AS user_id_9 FROM company_profile t0 WHERE t0.id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1144
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.description AS description_3, t0.website AS website_4, t0.logo AS logo_5, t0.stripe_customer_id AS stripe_customer_id_6, t0.stripe_cvtheque_subscription_id AS stripe_cvtheque_subscription_id_7, t0.cvtheque_active AS cvtheque_active_8, t0.user_id AS user_id_9 FROM company_profile t0 WHERE t0.id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1144
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.description AS description_3, t0.website AS website_4, t0.logo AS logo_5, t0.stripe_customer_id AS stripe_customer_id_6, t0.stripe_cvtheque_subscription_id AS stripe_cvtheque_subscription_id_7, t0.cvtheque_active AS cvtheque_active_8, t0.user_id AS user_id_9 FROM company_profile t0 WHERE t0.id = ?"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1144
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.description AS description_3, t0.website AS website_4, t0.logo AS logo_5, t0.stripe_customer_id AS stripe_customer_id_6, t0.stripe_cvtheque_subscription_id AS stripe_cvtheque_subscription_id_7, t0.cvtheque_active AS cvtheque_active_8, t0.user_id AS user_id_9 FROM company_profile t0 WHERE t0.id = ?"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1144
      +name: "INTEGER"
    }
  ]
]