GET https://intelligent-lamport.51-178-178-144.plesk.page/un-spectacle/TITI/IN-PULSE

Query Metrics

15 Database Queries
13 Different statements
8.09 ms Query time
0 Invalid entities
49 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.25 ms
(27.85%)
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_.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"
]
1.14 ms
(14.13%)
3
SELECT t0.id AS id_1, t0.name AS name_2 FROM adaptation t0 WHERE t0.id = ?
Parameters:
[
  26569
]
0.77 ms
(9.51%)
1
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 = ?
Parameters:
[
  2781
]
0.60 ms
(7.39%)
1
SELECT t0.id AS id_1, t0.word AS word_2, t0.show_id AS show_id_3 FROM keyword t0 WHERE t0.show_id = ?
Parameters:
[
  4743
]
0.59 ms
(7.24%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.role AS role_3, t0.show_id AS show_id_4 FROM actor t0 WHERE t0.show_id = ?
Parameters:
[
  4743
]
0.46 ms
(5.62%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.show_id AS show_id_3 FROM photo t0 WHERE t0.id = ?
Parameters:
[
  49741
]
0.41 ms
(5.01%)
1
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 = ?
Parameters:
[
  4743
]
0.40 ms
(4.94%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.old_id AS old_id_3 FROM tematic t0 INNER JOIN show_tematic ON t0.id = show_tematic.tematic_id WHERE show_tematic.show_id = ?
Parameters:
[
  4743
]
0.39 ms
(4.87%)
1
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 = ?
Parameters:
[
  4743
]
0.31 ms
(3.87%)
1
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 = ?
Parameters:
[
  726
]
0.27 ms
(3.35%)
1
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 = ?
Parameters:
[
  1
]
0.25 ms
(3.11%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.old_name AS old_name_3 FROM transfer_price t0 WHERE t0.id = ?
Parameters:
[
  3
]
0.25 ms
(3.10%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.old_name AS old_name_3 FROM region t0 WHERE t0.id = ?
Parameters:
[
  6
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Partners 15
App\Entity\Photo 6
App\Entity\Tematic 5
App\Entity\Category 4
App\Entity\Adaptation 3
App\Entity\SubCategory 3
App\Entity\Video 2
App\Entity\Keyword 2
App\Entity\Show 1
App\Entity\User 1
App\Entity\Audio 1
App\Entity\TransferPrice 1
App\Entity\Region 1
App\Entity\Artist 1
App\Entity\Address 1
App\Entity\Coordinate 1
App\Entity\Actor 1

Entities Mapping