Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.co_production AS co_production_1,
  s0_.stranger AS stranger_2,
  s0_.scenographie AS scenographie_3,
  s0_.duration AS duration_4,
  s0_.phone AS phone_5,
  s0_.short_description AS short_description_6,
  s0_.long_description AS long_description_7,
  s0_.presence_off_avignon AS presence_off_avignon_8,
  s0_.other_festival_presence AS other_festival_presence_9,
  s0_.scene_inde AS scene_inde_10,
  s0_.culture_box AS culture_box_11,
  s0_.festival_impatience AS festival_impatience_12,
  s0_.status AS status_13,
  s0_.fake_id AS fake_id_14,
  s0_.name AS name_15,
  s0_.co_real AS co_real_16,
  s0_.credit_photo AS credit_photo_17,
  s0_.show_adaptation AS show_adaptation_18,
  s0_.author AS author_19,
  s0_.mise_scene AS mise_scene_20,
  s0_.created_at AS created_at_21,
  s0_.oldid AS oldid_22,
  s0_.slug AS slug_23,
  s0_.updated_at AS updated_at_24,
  s0_.meta_title AS meta_title_25,
  s0_.meta_description AS meta_description_26,
  s0_.utilisateur_id AS utilisateur_id_27,
  s0_.affiche_id AS affiche_id_28,
  s0_.principal_img_id AS principal_img_id_29,
  s0_.full_img_id AS full_img_id_30,
  s0_.second_full_img_id AS second_full_img_id_31,
  s0_.third_full_img_id AS third_full_img_id_32,
  s0_.img_press_id AS img_press_id_33,
  s0_.seconf_img_press_id AS seconf_img_press_id_34,
  s0_.audio_id AS audio_id_35,
  s0_.extrait_id AS extrait_id_36,
  s0_.complete_id AS complete_id_37,
  s0_.technic_presentation_id AS technic_presentation_id_38,
  s0_.press_presentation_id AS press_presentation_id_39,
  s0_.flyer_id AS flyer_id_40,
  s0_.poster_id AS poster_id_41,
  s0_.price_id AS price_id_42,
  s0_.region_id AS region_id_43
FROM
  show s0_
  INNER JOIN "user" u1_ ON s0_.utilisateur_id = u1_.id
WHERE
  s0_.status IN (?, ?)
  AND u1_.status = ?

SELECT s0_.id AS id_0, s0_.co_production AS co_production_1, s0_.stranger AS stranger_2, s0_.scenographie AS scenographie_3, s0_.duration AS duration_4, s0_.phone AS phone_5, s0_.short_description AS short_description_6, s0_.long_description AS long_description_7, s0_.presence_off_avignon AS presence_off_avignon_8, s0_.other_festival_presence AS other_festival_presence_9, s0_.scene_inde AS scene_inde_10, s0_.culture_box AS culture_box_11, s0_.festival_impatience AS festival_impatience_12, s0_.status AS status_13, s0_.fake_id AS fake_id_14, s0_.name AS name_15, s0_.co_real AS co_real_16, s0_.credit_photo AS credit_photo_17, s0_.show_adaptation AS show_adaptation_18, s0_.author AS author_19, s0_.mise_scene AS mise_scene_20, s0_.created_at AS created_at_21, s0_.oldid AS oldid_22, s0_.slug AS slug_23, s0_.updated_at AS updated_at_24, s0_.meta_title AS meta_title_25, s0_.meta_description AS meta_description_26, s0_.utilisateur_id AS utilisateur_id_27, s0_.affiche_id AS affiche_id_28, s0_.principal_img_id AS principal_img_id_29, s0_.full_img_id AS full_img_id_30, s0_.second_full_img_id AS second_full_img_id_31, s0_.third_full_img_id AS third_full_img_id_32, s0_.img_press_id AS img_press_id_33, s0_.seconf_img_press_id AS seconf_img_press_id_34, s0_.audio_id AS audio_id_35, s0_.extrait_id AS extrait_id_36, s0_.complete_id AS complete_id_37, s0_.technic_presentation_id AS technic_presentation_id_38, s0_.press_presentation_id AS press_presentation_id_39, s0_.flyer_id AS flyer_id_40, s0_.poster_id AS poster_id_41, s0_.price_id AS price_id_42, s0_.region_id AS region_id_43 FROM show s0_ INNER JOIN "user" u1_ ON s0_.utilisateur_id = u1_.id WHERE s0_.status IN ('Publié', 'Archivé') AND u1_.status = 'active';

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.old_name AS old_name_2
FROM
  region r0_

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.old_name AS old_name_2 FROM region r0_;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.old_id AS old_id_2,
  c0_.slug AS slug_3
FROM
  category c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.old_id AS old_id_2, c0_.slug AS slug_3 FROM category c0_;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.old_id AS old_id_2,
  s0_.slug AS slug_3,
  s0_.categories_id AS categories_id_4
FROM
  sub_category s0_

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.old_id AS old_id_2, s0_.slug AS slug_3, s0_.categories_id AS categories_id_4 FROM sub_category s0_;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.old_name AS old_name_2
FROM
  transfer_price t0_

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.old_name AS old_name_2 FROM transfer_price t0_;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.old_id AS old_id_2
FROM
  tematic t0_

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.old_id AS old_id_2 FROM tematic t0_;

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.begin_at AS begin_at_2,
  f0_.end_at AS end_at_3,
  f0_.genre AS genre_4,
  f0_.phone AS phone_5,
  f0_.contact_mail AS contact_mail_6,
  f0_.website AS website_7,
  f0_.is_search AS is_search_8,
  f0_.logo AS logo_9,
  f0_.is_badge AS is_badge_10,
  f0_.wp_id AS wp_id_11,
  f0_.active AS active_12
FROM
  festival f0_
WHERE
  f0_.active = true
ORDER BY
  f0_.name ASC

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.begin_at AS begin_at_2, f0_.end_at AS end_at_3, f0_.genre AS genre_4, f0_.phone AS phone_5, f0_.contact_mail AS contact_mail_6, f0_.website AS website_7, f0_.is_search AS is_search_8, f0_.logo AS logo_9, f0_.is_badge AS is_badge_10, f0_.wp_id AS wp_id_11, f0_.active AS active_12 FROM festival f0_ WHERE f0_.active = true ORDER BY f0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.id_stripe AS id_stripe_7,
  t0.created_at AS created_at_8,
  t0.cgv AS cgv_9,
  t0.rgpd AS rgpd_10,
  t0.reset_token AS reset_token_11,
  t0.reset_requested_at AS reset_requested_at_12,
  t0.last_seen_at AS last_seen_at_13,
  t0.id_wp AS id_wp_14,
  t0.status AS status_15,
  t0.artist_id AS artist_id_16,
  t17.id AS id_18,
  t17.structure_name AS structure_name_19,
  t17.type AS type_20,
  t17.function AS function_21,
  t17.other_type AS other_type_22,
  t17.utilisateur_id AS utilisateur_id_23,
  t24.id AS id_25,
  t24.street AS street_26,
  t24.street_add AS street_add_27,
  t24.post_code AS post_code_28,
  t24.city AS city_29,
  t24.oldid AS oldid_30,
  t24.utilisateur_id AS utilisateur_id_31,
  t24.coordinate_id AS coordinate_id_32,
  t33.id AS id_34,
  t33.website AS website_35,
  t33.facebook AS facebook_36,
  t33.linkedin AS linkedin_37,
  t33.twitter AS twitter_38,
  t33.youtube AS youtube_39,
  t33.is_see_info_contact AS is_see_info_contact_40,
  t33.instagram AS instagram_41,
  t33.utilisateur_id AS utilisateur_id_42
FROM
  "user" t0
  LEFT JOIN programmer t17 ON t17.utilisateur_id = t0.id
  LEFT JOIN address t24 ON t24.utilisateur_id = t0.id
  LEFT JOIN more_information t33 ON t33.utilisateur_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.id_stripe AS id_stripe_7, t0.created_at AS created_at_8, t0.cgv AS cgv_9, t0.rgpd AS rgpd_10, t0.reset_token AS reset_token_11, t0.reset_requested_at AS reset_requested_at_12, t0.last_seen_at AS last_seen_at_13, t0.id_wp AS id_wp_14, t0.status AS status_15, t0.artist_id AS artist_id_16, t17.id AS id_18, t17.structure_name AS structure_name_19, t17.type AS type_20, t17.function AS function_21, t17.other_type AS other_type_22, t17.utilisateur_id AS utilisateur_id_23, t24.id AS id_25, t24.street AS street_26, t24.street_add AS street_add_27, t24.post_code AS post_code_28, t24.city AS city_29, t24.oldid AS oldid_30, t24.utilisateur_id AS utilisateur_id_31, t24.coordinate_id AS coordinate_id_32, t33.id AS id_34, t33.website AS website_35, t33.facebook AS facebook_36, t33.linkedin AS linkedin_37, t33.twitter AS twitter_38, t33.youtube AS youtube_39, t33.is_see_info_contact AS is_see_info_contact_40, t33.instagram AS instagram_41, t33.utilisateur_id AS utilisateur_id_42 FROM "user" t0 LEFT JOIN programmer t17 ON t17.utilisateur_id = t0.id LEFT JOIN address t24 ON t24.utilisateur_id = t0.id LEFT JOIN more_information t33 ON t33.utilisateur_id = t0.id WHERE t0.id = 529;

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.company_name AS company_name_3,
  t0.slug AS slug_4,
  t5.id AS id_6,
  t5.email AS email_7,
  t5.roles AS roles_8,
  t5.password AS password_9,
  t5.first_name AS first_name_10,
  t5.last_name AS last_name_11,
  t5.id_stripe AS id_stripe_12,
  t5.created_at AS created_at_13,
  t5.cgv AS cgv_14,
  t5.rgpd AS rgpd_15,
  t5.reset_token AS reset_token_16,
  t5.reset_requested_at AS reset_requested_at_17,
  t5.last_seen_at AS last_seen_at_18,
  t5.id_wp AS id_wp_19,
  t5.status AS status_20,
  t5.artist_id AS artist_id_21
FROM
  artist t0
  LEFT JOIN "user" t5 ON t5.artist_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.company_name AS company_name_3, t0.slug AS slug_4, t5.id AS id_6, t5.email AS email_7, t5.roles AS roles_8, t5.password AS password_9, t5.first_name AS first_name_10, t5.last_name AS last_name_11, t5.id_stripe AS id_stripe_12, t5.created_at AS created_at_13, t5.cgv AS cgv_14, t5.rgpd AS rgpd_15, t5.reset_token AS reset_token_16, t5.reset_requested_at AS reset_requested_at_17, t5.last_seen_at AS last_seen_at_18, t5.id_wp AS id_wp_19, t5.status AS status_20, t5.artist_id AS artist_id_21 FROM artist t0 LEFT JOIN "user" t5 ON t5.artist_id = t0.id WHERE t0.id = 414;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.show_id AS show_id_3
FROM
  photo t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.show_id AS show_id_3 FROM photo t0 WHERE t0.id = 4119;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.old_id AS old_id_3,
  t0.slug AS slug_4
FROM
  category t0
  INNER JOIN show_category ON t0.id = show_category.category_id
WHERE
  show_category.show_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.old_id AS old_id_3, t0.slug AS slug_4 FROM category t0 INNER JOIN show_category ON t0.id = show_category.category_id WHERE show_category.show_id = 564;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.old_id AS old_id_3,
  t0.slug AS slug_4,
  t0.categories_id AS categories_id_5
FROM
  sub_category t0
  INNER JOIN show_sub_category ON t0.id = show_sub_category.sub_category_id
WHERE
  show_sub_category.show_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.old_id AS old_id_3, t0.slug AS slug_4, t0.categories_id AS categories_id_5 FROM sub_category t0 INNER JOIN show_sub_category ON t0.id = show_sub_category.sub_category_id WHERE show_sub_category.show_id = 564;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.id_stripe AS id_stripe_7,
  t0.created_at AS created_at_8,
  t0.cgv AS cgv_9,
  t0.rgpd AS rgpd_10,
  t0.reset_token AS reset_token_11,
  t0.reset_requested_at AS reset_requested_at_12,
  t0.last_seen_at AS last_seen_at_13,
  t0.id_wp AS id_wp_14,
  t0.status AS status_15,
  t0.artist_id AS artist_id_16,
  t17.id AS id_18,
  t17.structure_name AS structure_name_19,
  t17.type AS type_20,
  t17.function AS function_21,
  t17.other_type AS other_type_22,
  t17.utilisateur_id AS utilisateur_id_23,
  t24.id AS id_25,
  t24.street AS street_26,
  t24.street_add AS street_add_27,
  t24.post_code AS post_code_28,
  t24.city AS city_29,
  t24.oldid AS oldid_30,
  t24.utilisateur_id AS utilisateur_id_31,
  t24.coordinate_id AS coordinate_id_32,
  t33.id AS id_34,
  t33.website AS website_35,
  t33.facebook AS facebook_36,
  t33.linkedin AS linkedin_37,
  t33.twitter AS twitter_38,
  t33.youtube AS youtube_39,
  t33.is_see_info_contact AS is_see_info_contact_40,
  t33.instagram AS instagram_41,
  t33.utilisateur_id AS utilisateur_id_42
FROM
  "user" t0
  LEFT JOIN programmer t17 ON t17.utilisateur_id = t0.id
  LEFT JOIN address t24 ON t24.utilisateur_id = t0.id
  LEFT JOIN more_information t33 ON t33.utilisateur_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.id_stripe AS id_stripe_7, t0.created_at AS created_at_8, t0.cgv AS cgv_9, t0.rgpd AS rgpd_10, t0.reset_token AS reset_token_11, t0.reset_requested_at AS reset_requested_at_12, t0.last_seen_at AS last_seen_at_13, t0.id_wp AS id_wp_14, t0.status AS status_15, t0.artist_id AS artist_id_16, t17.id AS id_18, t17.structure_name AS structure_name_19, t17.type AS type_20, t17.function AS function_21, t17.other_type AS other_type_22, t17.utilisateur_id AS utilisateur_id_23, t24.id AS id_25, t24.street AS street_26, t24.street_add AS street_add_27, t24.post_code AS post_code_28, t24.city AS city_29, t24.oldid AS oldid_30, t24.utilisateur_id AS utilisateur_id_31, t24.coordinate_id AS coordinate_id_32, t33.id AS id_34, t33.website AS website_35, t33.facebook AS facebook_36, t33.linkedin AS linkedin_37, t33.twitter AS twitter_38, t33.youtube AS youtube_39, t33.is_see_info_contact AS is_see_info_contact_40, t33.instagram AS instagram_41, t33.utilisateur_id AS utilisateur_id_42 FROM "user" t0 LEFT JOIN programmer t17 ON t17.utilisateur_id = t0.id LEFT JOIN address t24 ON t24.utilisateur_id = t0.id LEFT JOIN more_information t33 ON t33.utilisateur_id = t0.id WHERE t0.id = 94;

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.company_name AS company_name_3,
  t0.slug AS slug_4,
  t5.id AS id_6,
  t5.email AS email_7,
  t5.roles AS roles_8,
  t5.password AS password_9,
  t5.first_name AS first_name_10,
  t5.last_name AS last_name_11,
  t5.id_stripe AS id_stripe_12,
  t5.created_at AS created_at_13,
  t5.cgv AS cgv_14,
  t5.rgpd AS rgpd_15,
  t5.reset_token AS reset_token_16,
  t5.reset_requested_at AS reset_requested_at_17,
  t5.last_seen_at AS last_seen_at_18,
  t5.id_wp AS id_wp_19,
  t5.status AS status_20,
  t5.artist_id AS artist_id_21
FROM
  artist t0
  LEFT JOIN "user" t5 ON t5.artist_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.company_name AS company_name_3, t0.slug AS slug_4, t5.id AS id_6, t5.email AS email_7, t5.roles AS roles_8, t5.password AS password_9, t5.first_name AS first_name_10, t5.last_name AS last_name_11, t5.id_stripe AS id_stripe_12, t5.created_at AS created_at_13, t5.cgv AS cgv_14, t5.rgpd AS rgpd_15, t5.reset_token AS reset_token_16, t5.reset_requested_at AS reset_requested_at_17, t5.last_seen_at AS last_seen_at_18, t5.id_wp AS id_wp_19, t5.status AS status_20, t5.artist_id AS artist_id_21 FROM artist t0 LEFT JOIN "user" t5 ON t5.artist_id = t0.id WHERE t0.id = 837;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.show_id AS show_id_3
FROM
  photo t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.show_id AS show_id_3 FROM photo t0 WHERE t0.id = 682;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.old_id AS old_id_3,
  t0.slug AS slug_4
FROM
  category t0
  INNER JOIN show_category ON t0.id = show_category.category_id
WHERE
  show_category.show_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.old_id AS old_id_3, t0.slug AS slug_4 FROM category t0 INNER JOIN show_category ON t0.id = show_category.category_id WHERE show_category.show_id = 105;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.old_id AS old_id_3,
  t0.slug AS slug_4,
  t0.categories_id AS categories_id_5
FROM
  sub_category t0
  INNER JOIN show_sub_category ON t0.id = show_sub_category.sub_category_id
WHERE
  show_sub_category.show_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.old_id AS old_id_3, t0.slug AS slug_4, t0.categories_id AS categories_id_5 FROM sub_category t0 INNER JOIN show_sub_category ON t0.id = show_sub_category.sub_category_id WHERE show_sub_category.show_id = 105;