Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.offer_type AS offer_type_3
FROM
  additional_service t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.offer_type AS offer_type_3 FROM additional_service t0 WHERE t0.id = 15;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.title AS title_3,
  t0.slug AS slug_4,
  t0.gibier_description AS gibier_description_5,
  t0.team_experience_description AS team_experience_description_6,
  t0.unfolds_day AS unfolds_day_7,
  t0.hunting_plan AS hunting_plan_8,
  t0.start_at AS start_at_9,
  t0.end_at AS end_at_10,
  t0.recurrence AS recurrence_11,
  t0.price AS price_12,
  t0.half_action_price AS half_action_price_13,
  t0.half_action_nb_days AS half_action_nb_days_14,
  t0.nb_actions_available AS nb_actions_available_15,
  t0.nb_bracelet_person_max AS nb_bracelet_person_max_16,
  t0.nb_bracelets_available AS nb_bracelets_available_17,
  t0.max_nb_persons_hunting_day AS max_nb_persons_hunting_day_18,
  t0.nb_places_day AS nb_places_day_19,
  t0.further_information AS further_information_20,
  t0.companions AS companions_21,
  t0.half_action AS half_action_22,
  t0.status AS status_23,
  t0.is_paused AS is_paused_24,
  t0.equipement AS equipement_25,
  t0.planning_text AS planning_text_26,
  t0.is_tuchassou_selected AS is_tuchassou_selected_27,
  t0.disponibilities AS disponibilities_28,
  t0.quantity_booked AS quantity_booked_29,
  t0.created_at AS created_at_30,
  t0.caracteric_gibier AS caracteric_gibier_31,
  t0.cover AS cover_32,
  t0.frais_chasseur AS frais_chasseur_33,
  t0.frais_hote AS frais_hote_34,
  t0.recurrence_exception AS recurrence_exception_35,
  t0.is_managed_by_tuchassou AS is_managed_by_tuchassou_36,
  t0.territory_id AS territory_id_37,
  t0.created_by_id AS created_by_id_38
FROM
  offer t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.slug AS slug_4, t0.gibier_description AS gibier_description_5, t0.team_experience_description AS team_experience_description_6, t0.unfolds_day AS unfolds_day_7, t0.hunting_plan AS hunting_plan_8, t0.start_at AS start_at_9, t0.end_at AS end_at_10, t0.recurrence AS recurrence_11, t0.price AS price_12, t0.half_action_price AS half_action_price_13, t0.half_action_nb_days AS half_action_nb_days_14, t0.nb_actions_available AS nb_actions_available_15, t0.nb_bracelet_person_max AS nb_bracelet_person_max_16, t0.nb_bracelets_available AS nb_bracelets_available_17, t0.max_nb_persons_hunting_day AS max_nb_persons_hunting_day_18, t0.nb_places_day AS nb_places_day_19, t0.further_information AS further_information_20, t0.companions AS companions_21, t0.half_action AS half_action_22, t0.status AS status_23, t0.is_paused AS is_paused_24, t0.equipement AS equipement_25, t0.planning_text AS planning_text_26, t0.is_tuchassou_selected AS is_tuchassou_selected_27, t0.disponibilities AS disponibilities_28, t0.quantity_booked AS quantity_booked_29, t0.created_at AS created_at_30, t0.caracteric_gibier AS caracteric_gibier_31, t0.cover AS cover_32, t0.frais_chasseur AS frais_chasseur_33, t0.frais_hote AS frais_hote_34, t0.recurrence_exception AS recurrence_exception_35, t0.is_managed_by_tuchassou AS is_managed_by_tuchassou_36, t0.territory_id AS territory_id_37, t0.created_by_id AS created_by_id_38 FROM offer t0 WHERE t0.slug = 'bracelet-de-sanglier-dans-le-cher' LIMIT 1;

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

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,
  (
    3959 * ACOS(
      COS(
        RADIANS('47.571661')
      ) * COS(
        RADIANS(t1_.latitude)
      ) * COS(
        RADIANS(t1_.longitude) - RADIANS('2.162478')
      ) + SIN(
        RADIANS('47.571661')
      ) * SIN(
        RADIANS(t1_.latitude)
      )
    )
  ) AS sclr_36,
  o0_.territory_id AS territory_id_37,
  o0_.created_by_id AS created_by_id_38
FROM
  offer o0_
  INNER JOIN territory t1_ ON o0_.territory_id = t1_.id
WHERE
  o0_.id <> ?
  AND o0_.type = ?
HAVING
  sclr_36 <= ?
ORDER BY
  sclr_36 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, (3959 * ACOS(COS(RADIANS('47.571661')) * COS(RADIANS(t1_.latitude)) * COS(RADIANS(t1_.longitude) - RADIANS('2.162478')) + SIN(RADIANS('47.571661')) * SIN(RADIANS(t1_.latitude)))) AS sclr_36, o0_.territory_id AS territory_id_37, o0_.created_by_id AS created_by_id_38 FROM offer o0_ INNER JOIN territory t1_ ON o0_.territory_id = t1_.id WHERE o0_.id <> 82 AND o0_.type = 'br' HAVING sclr_36 <= 50 ORDER BY sclr_36 ASC;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  k.CONSTRAINT_NAME,
  k.COLUMN_NAME,
  k.REFERENCED_TABLE_NAME,
  k.REFERENCED_COLUMN_NAME
  /*!50116 , c.UPDATE_RULE, c.DELETE_RULE */
FROM
  INFORMATION_SCHEMA.KEY_COLUMN_USAGE k
  /*!50116 INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */
WHERE
  k.TABLE_NAME = 'doctrine_migration_versions'
  AND k.TABLE_SCHEMA = 'tuchassou'
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'tuchassou' */
ORDER BY
  k.ORDINAL_POSITION

SELECT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME /*!50116 , c.UPDATE_RULE, c.DELETE_RULE */ FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE k /*!50116 INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_NAME = 'doctrine_migration_versions' AND k.TABLE_SCHEMA = 'tuchassou' /*!50116 AND c.CONSTRAINT_SCHEMA = 'tuchassou' */ORDER BY k.ORDINAL_POSITION;

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
  t.ENGINE,
  t.AUTO_INCREMENT,
  t.TABLE_COMMENT,
  t.CREATE_OPTIONS,
  t.TABLE_COLLATION,
  ccsa.CHARACTER_SET_NAME
FROM
  information_schema.TABLES t
  INNER JOIN information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION
WHERE
  TABLE_TYPE = 'BASE TABLE'
  AND TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'doctrine_migration_versions'

SELECT t.ENGINE,
       t.AUTO_INCREMENT,
       t.TABLE_COMMENT,
       t.CREATE_OPTIONS,
       t.TABLE_COLLATION,
       ccsa.CHARACTER_SET_NAME
FROM information_schema.TABLES t
    INNER JOIN information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` ccsa
        ON ccsa.COLLATION_NAME = t.TABLE_COLLATION
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions';

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;

SELECT
  COLUMN_NAME AS Field,
  COLUMN_TYPE AS Type,
  IS_NULLABLE AS `Null`,
  COLUMN_KEY AS `Key`,
  COLUMN_DEFAULT AS `Default`,
  EXTRA AS Extra,
  COLUMN_COMMENT AS Comment,
  CHARACTER_SET_NAME AS CharacterSet,
  COLLATION_NAME AS Collation
FROM
  information_schema.COLUMNS
WHERE
  TABLE_SCHEMA = 'tuchassou'
  AND TABLE_NAME = 'doctrine_migration_versions'
ORDER BY
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'tuchassou' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.title AS title_3,
  t0.slug AS slug_4,
  t0.gibier_description AS gibier_description_5,
  t0.team_experience_description AS team_experience_description_6,
  t0.unfolds_day AS unfolds_day_7,
  t0.hunting_plan AS hunting_plan_8,
  t0.start_at AS start_at_9,
  t0.end_at AS end_at_10,
  t0.recurrence AS recurrence_11,
  t0.price AS price_12,
  t0.half_action_price AS half_action_price_13,
  t0.half_action_nb_days AS half_action_nb_days_14,
  t0.nb_actions_available AS nb_actions_available_15,
  t0.nb_bracelet_person_max AS nb_bracelet_person_max_16,
  t0.nb_bracelets_available AS nb_bracelets_available_17,
  t0.max_nb_persons_hunting_day AS max_nb_persons_hunting_day_18,
  t0.nb_places_day AS nb_places_day_19,
  t0.further_information AS further_information_20,
  t0.companions AS companions_21,
  t0.half_action AS half_action_22,
  t0.status AS status_23,
  t0.is_paused AS is_paused_24,
  t0.equipement AS equipement_25,
  t0.planning_text AS planning_text_26,
  t0.is_tuchassou_selected AS is_tuchassou_selected_27,
  t0.disponibilities AS disponibilities_28,
  t0.quantity_booked AS quantity_booked_29,
  t0.created_at AS created_at_30,
  t0.caracteric_gibier AS caracteric_gibier_31,
  t0.cover AS cover_32,
  t0.frais_chasseur AS frais_chasseur_33,
  t0.frais_hote AS frais_hote_34,
  t0.recurrence_exception AS recurrence_exception_35,
  t0.is_managed_by_tuchassou AS is_managed_by_tuchassou_36,
  t0.territory_id AS territory_id_37,
  t0.created_by_id AS created_by_id_38
FROM
  offer t0
WHERE
  t0.territory_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.slug AS slug_4, t0.gibier_description AS gibier_description_5, t0.team_experience_description AS team_experience_description_6, t0.unfolds_day AS unfolds_day_7, t0.hunting_plan AS hunting_plan_8, t0.start_at AS start_at_9, t0.end_at AS end_at_10, t0.recurrence AS recurrence_11, t0.price AS price_12, t0.half_action_price AS half_action_price_13, t0.half_action_nb_days AS half_action_nb_days_14, t0.nb_actions_available AS nb_actions_available_15, t0.nb_bracelet_person_max AS nb_bracelet_person_max_16, t0.nb_bracelets_available AS nb_bracelets_available_17, t0.max_nb_persons_hunting_day AS max_nb_persons_hunting_day_18, t0.nb_places_day AS nb_places_day_19, t0.further_information AS further_information_20, t0.companions AS companions_21, t0.half_action AS half_action_22, t0.status AS status_23, t0.is_paused AS is_paused_24, t0.equipement AS equipement_25, t0.planning_text AS planning_text_26, t0.is_tuchassou_selected AS is_tuchassou_selected_27, t0.disponibilities AS disponibilities_28, t0.quantity_booked AS quantity_booked_29, t0.created_at AS created_at_30, t0.caracteric_gibier AS caracteric_gibier_31, t0.cover AS cover_32, t0.frais_chasseur AS frais_chasseur_33, t0.frais_hote AS frais_hote_34, t0.recurrence_exception AS recurrence_exception_35, t0.is_managed_by_tuchassou AS is_managed_by_tuchassou_36, t0.territory_id AS territory_id_37, t0.created_by_id AS created_by_id_38 FROM offer t0 WHERE t0.territory_id = 112;

SELECT
  t0.id AS id_1,
  t0.civility AS civility_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.phone AS phone_5,
  t0.address AS address_6,
  t0.city AS city_7,
  t0.department AS department_8,
  t0.country AS country_9,
  t0.postcode AS postcode_10,
  t0.total_ht AS total_ht_11,
  t0.total_ttc AS total_ttc_12,
  t0.offer_type AS offer_type_13,
  t0.quantity AS quantity_14,
  t0.commission AS commission_15,
  t0.token AS token_16,
  t0.date_start AS date_start_17,
  t0.created_at AS created_at_18,
  t0.is_half_action AS is_half_action_19,
  t0.transaction_id AS transaction_id_20,
  t0.payed_at AS payed_at_21,
  t0.status AS status_22,
  t0.email AS email_23,
  t0.date_end AS date_end_24,
  t0.status_updated_at AS status_updated_at_25,
  t0.is_hote_paid AS is_hote_paid_26,
  t0.confirmation_email_sent AS confirmation_email_sent_27,
  t0.user_id AS user_id_28,
  t0.offer_id AS offer_id_29
FROM
  booking t0
WHERE
  t0.offer_id = ?

SELECT t0.id AS id_1, t0.civility AS civility_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.phone AS phone_5, t0.address AS address_6, t0.city AS city_7, t0.department AS department_8, t0.country AS country_9, t0.postcode AS postcode_10, t0.total_ht AS total_ht_11, t0.total_ttc AS total_ttc_12, t0.offer_type AS offer_type_13, t0.quantity AS quantity_14, t0.commission AS commission_15, t0.token AS token_16, t0.date_start AS date_start_17, t0.created_at AS created_at_18, t0.is_half_action AS is_half_action_19, t0.transaction_id AS transaction_id_20, t0.payed_at AS payed_at_21, t0.status AS status_22, t0.email AS email_23, t0.date_end AS date_end_24, t0.status_updated_at AS status_updated_at_25, t0.is_hote_paid AS is_hote_paid_26, t0.confirmation_email_sent AS confirmation_email_sent_27, t0.user_id AS user_id_28, t0.offer_id AS offer_id_29 FROM booking t0 WHERE t0.offer_id = 82;

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.offer_id AS offer_id_3
FROM
  offer_image t0
WHERE
  t0.offer_id = ?

SELECT t0.id AS id_1, t0.path AS path_2, t0.offer_id AS offer_id_3 FROM offer_image t0 WHERE t0.offer_id = 82;

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  hunting_mode t0
  INNER JOIN offer_hunting_mode ON t0.id = offer_hunting_mode.hunting_mode_id
WHERE
  offer_hunting_mode.offer_id = ?

SELECT t0.id AS id_1, t0.title AS title_2 FROM hunting_mode t0 INNER JOIN offer_hunting_mode ON t0.id = offer_hunting_mode.hunting_mode_id WHERE offer_hunting_mode.offer_id = 82;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.price AS price_3,
  t0.offer_id AS offer_id_4,
  t0.additional_service_id AS additional_service_id_5
FROM
  offer_additional_service t0
WHERE
  t0.offer_id = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.price AS price_3, t0.offer_id AS offer_id_4, t0.additional_service_id AS additional_service_id_5 FROM offer_additional_service t0 WHERE t0.offer_id = 82;

SELECT
  NON_UNIQUE AS Non_Unique,
  INDEX_NAME AS Key_name,
  COLUMN_NAME AS Column_Name,
  SUB_PART AS Sub_Part,
  INDEX_TYPE AS Index_Type
FROM
  information_schema.STATISTICS
WHERE
  TABLE_NAME = 'doctrine_migration_versions'
  AND TABLE_SCHEMA = 'tuchassou'
ORDER BY
  SEQ_IN_INDEX ASC

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'tuchassou' ORDER BY SEQ_IN_INDEX ASC;

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.gibier_id AS gibier_id_3
FROM
  animal t0
  INNER JOIN offer_animal ON t0.id = offer_animal.animal_id
WHERE
  offer_animal.offer_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.gibier_id AS gibier_id_3 FROM animal t0 INNER JOIN offer_animal ON t0.id = offer_animal.animal_id WHERE offer_animal.offer_id = 82;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  weapon t0
  INNER JOIN offer_weapon ON t0.id = offer_weapon.weapon_id
WHERE
  offer_weapon.offer_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM weapon t0 INNER JOIN offer_weapon ON t0.id = offer_weapon.weapon_id WHERE offer_weapon.offer_id = 82;