Symfony Profiler

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

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 = 'Saisonnier / Vendanges' AND t0.status = 'active' ORDER BY t0.id DESC LIMIT 6;

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

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 = 1 ORDER BY t0.created_at DESC LIMIT 3;

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

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 = 1 ORDER BY e0_.id DESC LIMIT 6;

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

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 = 'candidate_to_company' AND r0_.published_at IS NOT NULL ORDER BY r0_.published_at DESC LIMIT 3;

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

SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3 FROM taxonomy t0 WHERE t0.type = 'region' ORDER BY t0.name ASC;

SELECT
  j0_.location AS location_0
FROM
  job_offer j0_
WHERE
  j0_.status = ?
  AND j0_.contract_type = ?

SELECT j0_.location AS location_0 FROM job_offer j0_ WHERE j0_.status = 'active' AND j0_.contract_type = 'Saisonnier / Vendanges';

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user u0_
WHERE
  u0_.account_type = ?

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.account_type = 'candidate';

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user u0_
WHERE
  u0_.account_type = ?

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.account_type = 'recruiter';

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  mission m0_
WHERE
  m0_.status = ?

SELECT COUNT(m0_.id) AS sclr_0 FROM mission m0_ WHERE m0_.status = 'completed';

SELECT
  COUNT(j0_.id) AS sclr_0
FROM
  job_offer j0_
WHERE
  j0_.status = ?
  AND j0_.contract_type = ?

SELECT COUNT(j0_.id) AS sclr_0 FROM job_offer j0_ WHERE j0_.status = 'active' AND j0_.contract_type = 'Saisonnier / Vendanges';

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

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 = 1 AND t0.domain = 'vendangeurs.com' ORDER BY t0.id ASC;

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 = ?

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 = 7;

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 = ?

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 = 8;

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 = ?

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 = 6;

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 = ?

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 = 10;

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 = ?

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 = 9;