10.24 ms (43.60%)
|
1 |
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 = ?
Parameters: [
"Publié"
"Archivé"
"active"
]
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';
|
3.48 ms (14.80%)
|
8 |
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;
|
2.18 ms (9.29%)
|
8 |
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;
|