| 1 |
2.25 ms |
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_ LEFT JOIN "user" u1_ ON s0_.utilisateur_id = u1_.id LEFT JOIN artist a2_ ON u1_.artist_id = a2_.id WHERE s0_.slug = ? AND a2_.slug = ?
Parameters: [
"TITI"
"IN-PULSE"
]
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_
LEFT JOIN "user" u1_ ON s0_.utilisateur_id = u1_.id
LEFT JOIN artist a2_ ON u1_.artist_id = a2_.id
WHERE
s0_.slug = ?
AND a2_.slug = ?
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_ LEFT JOIN "user" u1_ ON s0_.utilisateur_id = u1_.id LEFT JOIN artist a2_ ON u1_.artist_id = a2_.id WHERE s0_.slug = 'TITI' AND a2_.slug = 'IN-PULSE';
|
| 3 |
0.77 ms |
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;
|
| 4 |
0.31 ms |
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;
|