Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.old_name AS old_name_3
FROM
  region t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.old_name AS old_name_3 FROM region t0;

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

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;

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

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;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.old_name AS old_name_3
FROM
  transfer_price t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.old_name AS old_name_3 FROM transfer_price t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.old_id AS old_id_3
FROM
  tematic t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.old_id AS old_id_3 FROM tematic t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.begin_at AS begin_at_3,
  t0.end_at AS end_at_4,
  t0.genre AS genre_5,
  t0.phone AS phone_6,
  t0.contact_mail AS contact_mail_7,
  t0.website AS website_8,
  t0.is_search AS is_search_9,
  t0.logo AS logo_10,
  t0.is_badge AS is_badge_11,
  t0.wp_id AS wp_id_12
FROM
  festival t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.begin_at AS begin_at_3, t0.end_at AS end_at_4, t0.genre AS genre_5, t0.phone AS phone_6, t0.contact_mail AS contact_mail_7, t0.website AS website_8, t0.is_search AS is_search_9, t0.logo AS logo_10, t0.is_badge AS is_badge_11, t0.wp_id AS wp_id_12 FROM festival t0;

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_.utilisateur_id AS utilisateur_id_24,
  s0_.affiche_id AS affiche_id_25,
  s0_.principal_img_id AS principal_img_id_26,
  s0_.full_img_id AS full_img_id_27,
  s0_.second_full_img_id AS second_full_img_id_28,
  s0_.third_full_img_id AS third_full_img_id_29,
  s0_.img_press_id AS img_press_id_30,
  s0_.seconf_img_press_id AS seconf_img_press_id_31,
  s0_.audio_id AS audio_id_32,
  s0_.extrait_id AS extrait_id_33,
  s0_.complete_id AS complete_id_34,
  s0_.technic_presentation_id AS technic_presentation_id_35,
  s0_.press_presentation_id AS press_presentation_id_36,
  s0_.flyer_id AS flyer_id_37,
  s0_.poster_id AS poster_id_38,
  s0_.price_id AS price_id_39,
  s0_.region_id AS region_id_40
FROM
  show s0_
  INNER JOIN "user" u1_ ON s0_.utilisateur_id = u1_.id
  LEFT JOIN region r2_ ON s0_.region_id = r2_.id
  LEFT JOIN show_category s4_ ON s0_.id = s4_.show_id
  LEFT JOIN category c3_ ON c3_.id = s4_.category_id
  LEFT JOIN show_sub_category s6_ ON s0_.id = s6_.show_id
  LEFT JOIN sub_category s5_ ON s5_.id = s6_.sub_category_id
  LEFT JOIN show_tematic s8_ ON s0_.id = s8_.show_id
  LEFT JOIN tematic t7_ ON t7_.id = s8_.tematic_id
  LEFT JOIN transfer_price t9_ ON s0_.price_id = t9_.id
WHERE
  s0_.status = ?
  AND u1_.artist_id IS NOT NULL
  AND r2_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
  AND s5_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )
  AND (
    t7_.id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?
    )
    OR t7_.id IS NULL
  )
  AND t9_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

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_.utilisateur_id AS utilisateur_id_24, s0_.affiche_id AS affiche_id_25, s0_.principal_img_id AS principal_img_id_26, s0_.full_img_id AS full_img_id_27, s0_.second_full_img_id AS second_full_img_id_28, s0_.third_full_img_id AS third_full_img_id_29, s0_.img_press_id AS img_press_id_30, s0_.seconf_img_press_id AS seconf_img_press_id_31, s0_.audio_id AS audio_id_32, s0_.extrait_id AS extrait_id_33, s0_.complete_id AS complete_id_34, s0_.technic_presentation_id AS technic_presentation_id_35, s0_.press_presentation_id AS press_presentation_id_36, s0_.flyer_id AS flyer_id_37, s0_.poster_id AS poster_id_38, s0_.price_id AS price_id_39, s0_.region_id AS region_id_40 FROM show s0_ INNER JOIN "user" u1_ ON s0_.utilisateur_id = u1_.id LEFT JOIN region r2_ ON s0_.region_id = r2_.id LEFT JOIN show_category s4_ ON s0_.id = s4_.show_id LEFT JOIN category c3_ ON c3_.id = s4_.category_id LEFT JOIN show_sub_category s6_ ON s0_.id = s6_.show_id LEFT JOIN sub_category s5_ ON s5_.id = s6_.sub_category_id LEFT JOIN show_tematic s8_ ON s0_.id = s8_.show_id LEFT JOIN tematic t7_ ON t7_.id = s8_.tematic_id LEFT JOIN transfer_price t9_ ON s0_.price_id = t9_.id WHERE s0_.status = 'Publié' AND u1_.artist_id IS NOT NULL AND r2_.id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26) AND c3_.id IN (1, 2, 3, 4, 5, 6, 7, 8, 9) AND s5_.id IN (39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76) AND (t7_.id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20) OR t7_.id IS NULL) AND t9_.id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);

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
FROM
  festival f0_

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 FROM festival f0_;

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.artist_id AS artist_id_15,
  t16.id AS id_17,
  t16.structure_name AS structure_name_18,
  t16.type AS type_19,
  t16.function AS function_20,
  t16.other_type AS other_type_21,
  t16.utilisateur_id AS utilisateur_id_22,
  t23.id AS id_24,
  t23.street AS street_25,
  t23.street_add AS street_add_26,
  t23.post_code AS post_code_27,
  t23.city AS city_28,
  t23.oldid AS oldid_29,
  t23.utilisateur_id AS utilisateur_id_30,
  t23.coordinate_id AS coordinate_id_31,
  t32.id AS id_33,
  t32.website AS website_34,
  t32.facebook AS facebook_35,
  t32.linkedin AS linkedin_36,
  t32.twitter AS twitter_37,
  t32.youtube AS youtube_38,
  t32.is_see_info_contact AS is_see_info_contact_39,
  t32.instagram AS instagram_40,
  t32.utilisateur_id AS utilisateur_id_41
FROM
  "user" t0
  LEFT JOIN programmer t16 ON t16.utilisateur_id = t0.id
  LEFT JOIN address t23 ON t23.utilisateur_id = t0.id
  LEFT JOIN more_information t32 ON t32.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.artist_id AS artist_id_15, t16.id AS id_17, t16.structure_name AS structure_name_18, t16.type AS type_19, t16.function AS function_20, t16.other_type AS other_type_21, t16.utilisateur_id AS utilisateur_id_22, t23.id AS id_24, t23.street AS street_25, t23.street_add AS street_add_26, t23.post_code AS post_code_27, t23.city AS city_28, t23.oldid AS oldid_29, t23.utilisateur_id AS utilisateur_id_30, t23.coordinate_id AS coordinate_id_31, t32.id AS id_33, t32.website AS website_34, t32.facebook AS facebook_35, t32.linkedin AS linkedin_36, t32.twitter AS twitter_37, t32.youtube AS youtube_38, t32.is_see_info_contact AS is_see_info_contact_39, t32.instagram AS instagram_40, t32.utilisateur_id AS utilisateur_id_41 FROM "user" t0 LEFT JOIN programmer t16 ON t16.utilisateur_id = t0.id LEFT JOIN address t23 ON t23.utilisateur_id = t0.id LEFT JOIN more_information t32 ON t32.utilisateur_id = t0.id WHERE t0.id = 2781;

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.artist_id AS artist_id_20
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.artist_id AS artist_id_20 FROM artist t0 LEFT JOIN "user" t5 ON t5.artist_id = t0.id WHERE t0.id = 726;

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

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

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.is_link AS is_link_4,
  t0.is_active AS is_active_5
FROM
  partners t0
WHERE
  t0.is_active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.is_link AS is_link_4, t0.is_active AS is_active_5 FROM partners t0 WHERE t0.is_active = 1;