Symfony Profiler

SELECT
  h0_.id AS id_0,
  h0_.title AS title_1
FROM
  hunting_mode h0_
ORDER BY
  h0_.title ASC

SELECT h0_.id AS id_0, h0_.title AS title_1 FROM hunting_mode h0_ ORDER BY h0_.title ASC;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.gibier_id AS gibier_id_2
FROM
  animal a0_
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.gibier_id AS gibier_id_2 FROM animal a0_ ORDER BY a0_.name ASC;

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1
FROM
  weapon w0_
ORDER BY
  w0_.name ASC

SELECT w0_.id AS id_0, w0_.name AS name_1 FROM weapon w0_ ORDER BY w0_.name ASC;

SELECT
  g0_.id AS id_0,
  g0_.title AS title_1
FROM
  gibier g0_
ORDER BY
  g0_.title ASC

SELECT g0_.id AS id_0, g0_.title AS title_1 FROM gibier g0_ ORDER BY g0_.title ASC;

SELECT
  o0_.id AS id_0,
  o0_.type AS type_1,
  o0_.title AS title_2,
  o0_.slug AS slug_3,
  o0_.gibier_description AS gibier_description_4,
  o0_.team_experience_description AS team_experience_description_5,
  o0_.unfolds_day AS unfolds_day_6,
  o0_.hunting_plan AS hunting_plan_7,
  o0_.start_at AS start_at_8,
  o0_.end_at AS end_at_9,
  o0_.recurrence AS recurrence_10,
  o0_.price AS price_11,
  o0_.half_action_price AS half_action_price_12,
  o0_.half_action_nb_days AS half_action_nb_days_13,
  o0_.nb_actions_available AS nb_actions_available_14,
  o0_.nb_bracelet_person_max AS nb_bracelet_person_max_15,
  o0_.nb_bracelets_available AS nb_bracelets_available_16,
  o0_.max_nb_persons_hunting_day AS max_nb_persons_hunting_day_17,
  o0_.nb_places_day AS nb_places_day_18,
  o0_.further_information AS further_information_19,
  o0_.companions AS companions_20,
  o0_.half_action AS half_action_21,
  o0_.status AS status_22,
  o0_.is_paused AS is_paused_23,
  o0_.equipement AS equipement_24,
  o0_.planning_text AS planning_text_25,
  o0_.is_tuchassou_selected AS is_tuchassou_selected_26,
  o0_.disponibilities AS disponibilities_27,
  o0_.quantity_booked AS quantity_booked_28,
  o0_.created_at AS created_at_29,
  o0_.caracteric_gibier AS caracteric_gibier_30,
  o0_.cover AS cover_31,
  o0_.frais_chasseur AS frais_chasseur_32,
  o0_.frais_hote AS frais_hote_33,
  o0_.recurrence_exception AS recurrence_exception_34,
  o0_.is_managed_by_tuchassou AS is_managed_by_tuchassou_35,
  o0_.territory_id AS territory_id_36,
  o0_.created_by_id AS created_by_id_37
FROM
  offer o0_
  LEFT JOIN territory t1_ ON o0_.territory_id = t1_.id
  LEFT JOIN offer_weapon o3_ ON o0_.id = o3_.offer_id
  LEFT JOIN weapon w2_ ON w2_.id = o3_.weapon_id
WHERE
  o0_.status IN (?)
GROUP BY
  o0_.id
ORDER BY
  o0_.id DESC,
  o0_.is_tuchassou_selected DESC

SELECT o0_.id AS id_0, o0_.type AS type_1, o0_.title AS title_2, o0_.slug AS slug_3, o0_.gibier_description AS gibier_description_4, o0_.team_experience_description AS team_experience_description_5, o0_.unfolds_day AS unfolds_day_6, o0_.hunting_plan AS hunting_plan_7, o0_.start_at AS start_at_8, o0_.end_at AS end_at_9, o0_.recurrence AS recurrence_10, o0_.price AS price_11, o0_.half_action_price AS half_action_price_12, o0_.half_action_nb_days AS half_action_nb_days_13, o0_.nb_actions_available AS nb_actions_available_14, o0_.nb_bracelet_person_max AS nb_bracelet_person_max_15, o0_.nb_bracelets_available AS nb_bracelets_available_16, o0_.max_nb_persons_hunting_day AS max_nb_persons_hunting_day_17, o0_.nb_places_day AS nb_places_day_18, o0_.further_information AS further_information_19, o0_.companions AS companions_20, o0_.half_action AS half_action_21, o0_.status AS status_22, o0_.is_paused AS is_paused_23, o0_.equipement AS equipement_24, o0_.planning_text AS planning_text_25, o0_.is_tuchassou_selected AS is_tuchassou_selected_26, o0_.disponibilities AS disponibilities_27, o0_.quantity_booked AS quantity_booked_28, o0_.created_at AS created_at_29, o0_.caracteric_gibier AS caracteric_gibier_30, o0_.cover AS cover_31, o0_.frais_chasseur AS frais_chasseur_32, o0_.frais_hote AS frais_hote_33, o0_.recurrence_exception AS recurrence_exception_34, o0_.is_managed_by_tuchassou AS is_managed_by_tuchassou_35, o0_.territory_id AS territory_id_36, o0_.created_by_id AS created_by_id_37 FROM offer o0_ LEFT JOIN territory t1_ ON o0_.territory_id = t1_.id LEFT JOIN offer_weapon o3_ ON o0_.id = o3_.offer_id LEFT JOIN weapon w2_ ON w2_.id = o3_.weapon_id WHERE o0_.status IN (1, 3) GROUP BY o0_.id ORDER BY o0_.id DESC, o0_.is_tuchassou_selected DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.nb_hectares AS nb_hectares_4,
  t0.address AS address_5,
  t0.postcode AS postcode_6,
  t0.city AS city_7,
  t0.department AS department_8,
  t0.region AS region_9,
  t0.longitude AS longitude_10,
  t0.latitude AS latitude_11,
  t0.biotope AS biotope_12,
  t0.biotope_text AS biotope_text_13,
  t0.created_at AS created_at_14,
  t0.tuchassou_recommendations AS tuchassou_recommendations_15,
  t0.is_tuchassou_selected AS is_tuchassou_selected_16,
  t0.created_by_id AS created_by_id_17
FROM
  territory t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.nb_hectares AS nb_hectares_4, t0.address AS address_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.department AS department_8, t0.region AS region_9, t0.longitude AS longitude_10, t0.latitude AS latitude_11, t0.biotope AS biotope_12, t0.biotope_text AS biotope_text_13, t0.created_at AS created_at_14, t0.tuchassou_recommendations AS tuchassou_recommendations_15, t0.is_tuchassou_selected AS is_tuchassou_selected_16, t0.created_by_id AS created_by_id_17 FROM territory t0 WHERE t0.id = 116;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.nb_hectares AS nb_hectares_4,
  t0.address AS address_5,
  t0.postcode AS postcode_6,
  t0.city AS city_7,
  t0.department AS department_8,
  t0.region AS region_9,
  t0.longitude AS longitude_10,
  t0.latitude AS latitude_11,
  t0.biotope AS biotope_12,
  t0.biotope_text AS biotope_text_13,
  t0.created_at AS created_at_14,
  t0.tuchassou_recommendations AS tuchassou_recommendations_15,
  t0.is_tuchassou_selected AS is_tuchassou_selected_16,
  t0.created_by_id AS created_by_id_17
FROM
  territory t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.nb_hectares AS nb_hectares_4, t0.address AS address_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.department AS department_8, t0.region AS region_9, t0.longitude AS longitude_10, t0.latitude AS latitude_11, t0.biotope AS biotope_12, t0.biotope_text AS biotope_text_13, t0.created_at AS created_at_14, t0.tuchassou_recommendations AS tuchassou_recommendations_15, t0.is_tuchassou_selected AS is_tuchassou_selected_16, t0.created_by_id AS created_by_id_17 FROM territory t0 WHERE t0.id = 112;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.nb_hectares AS nb_hectares_4,
  t0.address AS address_5,
  t0.postcode AS postcode_6,
  t0.city AS city_7,
  t0.department AS department_8,
  t0.region AS region_9,
  t0.longitude AS longitude_10,
  t0.latitude AS latitude_11,
  t0.biotope AS biotope_12,
  t0.biotope_text AS biotope_text_13,
  t0.created_at AS created_at_14,
  t0.tuchassou_recommendations AS tuchassou_recommendations_15,
  t0.is_tuchassou_selected AS is_tuchassou_selected_16,
  t0.created_by_id AS created_by_id_17
FROM
  territory t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.nb_hectares AS nb_hectares_4, t0.address AS address_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.department AS department_8, t0.region AS region_9, t0.longitude AS longitude_10, t0.latitude AS latitude_11, t0.biotope AS biotope_12, t0.biotope_text AS biotope_text_13, t0.created_at AS created_at_14, t0.tuchassou_recommendations AS tuchassou_recommendations_15, t0.is_tuchassou_selected AS is_tuchassou_selected_16, t0.created_by_id AS created_by_id_17 FROM territory t0 WHERE t0.id = 113;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.nb_hectares AS nb_hectares_4,
  t0.address AS address_5,
  t0.postcode AS postcode_6,
  t0.city AS city_7,
  t0.department AS department_8,
  t0.region AS region_9,
  t0.longitude AS longitude_10,
  t0.latitude AS latitude_11,
  t0.biotope AS biotope_12,
  t0.biotope_text AS biotope_text_13,
  t0.created_at AS created_at_14,
  t0.tuchassou_recommendations AS tuchassou_recommendations_15,
  t0.is_tuchassou_selected AS is_tuchassou_selected_16,
  t0.created_by_id AS created_by_id_17
FROM
  territory t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.nb_hectares AS nb_hectares_4, t0.address AS address_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.department AS department_8, t0.region AS region_9, t0.longitude AS longitude_10, t0.latitude AS latitude_11, t0.biotope AS biotope_12, t0.biotope_text AS biotope_text_13, t0.created_at AS created_at_14, t0.tuchassou_recommendations AS tuchassou_recommendations_15, t0.is_tuchassou_selected AS is_tuchassou_selected_16, t0.created_by_id AS created_by_id_17 FROM territory t0 WHERE t0.id = 115;

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  gibier t0
  INNER JOIN offer_gibier ON t0.id = offer_gibier.gibier_id
WHERE
  offer_gibier.offer_id = ?

SELECT t0.id AS id_1, t0.title AS title_2 FROM gibier t0 INNER JOIN offer_gibier ON t0.id = offer_gibier.gibier_id WHERE offer_gibier.offer_id = 88;

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  gibier t0
  INNER JOIN offer_gibier ON t0.id = offer_gibier.gibier_id
WHERE
  offer_gibier.offer_id = ?

SELECT t0.id AS id_1, t0.title AS title_2 FROM gibier t0 INNER JOIN offer_gibier ON t0.id = offer_gibier.gibier_id WHERE offer_gibier.offer_id = 87;

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.is_cover AS is_cover_3,
  t0.territory_id AS territory_id_4
FROM
  territory_image t0
WHERE
  t0.territory_id = ?

SELECT t0.id AS id_1, t0.path AS path_2, t0.is_cover AS is_cover_3, t0.territory_id AS territory_id_4 FROM territory_image t0 WHERE t0.territory_id = 112;

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  gibier t0
  INNER JOIN offer_gibier ON t0.id = offer_gibier.gibier_id
WHERE
  offer_gibier.offer_id = ?

SELECT t0.id AS id_1, t0.title AS title_2 FROM gibier t0 INNER JOIN offer_gibier ON t0.id = offer_gibier.gibier_id WHERE offer_gibier.offer_id = 86;

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  gibier t0
  INNER JOIN offer_gibier ON t0.id = offer_gibier.gibier_id
WHERE
  offer_gibier.offer_id = ?

SELECT t0.id AS id_1, t0.title AS title_2 FROM gibier t0 INNER JOIN offer_gibier ON t0.id = offer_gibier.gibier_id WHERE offer_gibier.offer_id = 85;

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  gibier t0
  INNER JOIN offer_gibier ON t0.id = offer_gibier.gibier_id
WHERE
  offer_gibier.offer_id = ?

SELECT t0.id AS id_1, t0.title AS title_2 FROM gibier t0 INNER JOIN offer_gibier ON t0.id = offer_gibier.gibier_id WHERE offer_gibier.offer_id = 84;

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  gibier t0
  INNER JOIN offer_gibier ON t0.id = offer_gibier.gibier_id
WHERE
  offer_gibier.offer_id = ?

SELECT t0.id AS id_1, t0.title AS title_2 FROM gibier t0 INNER JOIN offer_gibier ON t0.id = offer_gibier.gibier_id WHERE offer_gibier.offer_id = 83;

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  gibier t0
  INNER JOIN offer_gibier ON t0.id = offer_gibier.gibier_id
WHERE
  offer_gibier.offer_id = ?

SELECT t0.id AS id_1, t0.title AS title_2 FROM gibier t0 INNER JOIN offer_gibier ON t0.id = offer_gibier.gibier_id WHERE offer_gibier.offer_id = 82;