GET https://preprod.artlink-up.com/api/events/76

Query Metrics

13 Database Queries
12 Different statements
1.62 ms Query time
4 Invalid entities
23 Managed entities

Queries

Group similar statements

# Time Info
1 0.36 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.avatar AS avatar_5, t0.updated_at AS updated_at_6, t0.subscription_started_at AS subscription_started_at_7, t0.subscription_ended_at AS subscription_ended_at_8, t0.type AS type_9, t0.customer_id AS customer_id_10, t0.sub_id AS sub_id_11, t0.subscription_active AS subscription_active_12, t0.subscription_type AS subscription_type_13, t0.created_at AS created_at_14, t0.enabled AS enabled_15, t0.address AS address_16, t0.complement_address AS complement_address_17, t0.zipcode AS zipcode_18, t0.city AS city_19, t0.country AS country_20, t0.first_name AS first_name_21, t0.last_name AS last_name_22, t0.phone AS phone_23, t0.email_validation_code AS email_validation_code_24, t0.email_validation_code_generated_at AS email_validation_code_generated_at_25, t0.reset_token AS reset_token_26, t0.reset_token_expires_at AS reset_token_expires_at_27, t0.credits AS credits_28, t29.id AS id_30, t29.name AS name_31, t29.phone AS phone_32, t29.bio AS bio_33, t29.specialty AS specialty_34, t29.rate AS rate_35, t29.price AS price_36, t29.price_int AS price_int_37, t29.latitude AS latitude_38, t29.longitude AS longitude_39, t29.location_updated_at AS location_updated_at_40, t29.facebook AS facebook_41, t29.instagram AS instagram_42, t29.whatsapp AS whatsapp_43, t29.tiktok AS tiktok_44, t29.user_id AS user_id_45, t46.id AS id_47, t46.phone AS phone_48, t46.name AS name_49, t46.description AS description_50, t46.opening_hours AS opening_hours_51, t46.closed_days AS closed_days_52, t46.latitude AS latitude_53, t46.longitude AS longitude_54, t46.budget AS budget_55, t46.instagram_url AS instagram_url_56, t46.facebook_url AS facebook_url_57, t46.website_url AS website_url_58, t46.rib_url AS rib_url_59, t46.user_id AS user_id_60, t61.id AS id_62, t61.preferred_location AS preferred_location_63, t61.typical_event_budget AS typical_event_budget_64, t61.user_id AS user_id_65 FROM user t0 LEFT JOIN artist t29 ON t29.user_id = t0.id LEFT JOIN establishment t46 ON t46.user_id = t0.id LEFT JOIN user_preferences t61 ON t61.user_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters:
[
  "establishment0@artlink.local"
]
2 0.12 ms
SELECT t0.id AS id_1, t0.balance_due AS balance_due_2, t0.balance_paid AS balance_paid_3, t0.last_balance_calculation AS last_balance_calculation_4, t0.last_payment_date AS last_payment_date_5, t0.notes AS notes_6, t0.establishment_id AS establishment_id_7, t8.id AS id_9, t8.phone AS phone_10, t8.name AS name_11, t8.description AS description_12, t8.opening_hours AS opening_hours_13, t8.closed_days AS closed_days_14, t8.latitude AS latitude_15, t8.longitude AS longitude_16, t8.budget AS budget_17, t8.instagram_url AS instagram_url_18, t8.facebook_url AS facebook_url_19, t8.website_url AS website_url_20, t8.rib_url AS rib_url_21, t8.user_id AS user_id_22 FROM establishment_finance t0 INNER JOIN establishment t8 ON t0.establishment_id = t8.id WHERE t0.establishment_id = ?
Parameters:
[
  21
]
3 0.12 ms
SELECT t0.id AS id_1, t0.max_seats AS max_seats_2, t0.title AS title_3, t0.date AS date_4, t0.is_ticketing_open AS is_ticketing_open_5, t0.is_applications_open AS is_applications_open_6, t0.price AS price_7, t0.end_date AS end_date_8, t0.description AS description_9, t0.ticket_url AS ticket_url_10, t0.criteria AS criteria_11, t0.created_at AS created_at_12, t0.status AS status_13, t0.mode AS mode_14, t0.latitude AS latitude_15, t0.longitude AS longitude_16, t0.filename_template AS filename_template_17, t0.establishment_id AS establishment_id_18 FROM event t0 WHERE t0.id = ?
Parameters:
[
  "76"
]
4 0.13 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.date_end AS date_end_3, t0.title AS title_4, t0.description AS description_5, t0.message AS message_6, t0.review AS review_7, t0.rating AS rating_8, t0.created_at AS created_at_9, t0.status AS status_10, t0.feedback_by_establishment AS feedback_by_establishment_11, t0.artist_id AS artist_id_12, t0.establishment_id AS establishment_id_13, t0.event_id AS event_id_14 FROM collaboration t0 WHERE t0.event_id = ?
Parameters:
[
  76
]
5 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.bio AS bio_4, t0.specialty AS specialty_5, t0.rate AS rate_6, t0.price AS price_7, t0.price_int AS price_int_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.location_updated_at AS location_updated_at_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.whatsapp AS whatsapp_14, t0.tiktok AS tiktok_15, t0.user_id AS user_id_16 FROM artist t0 WHERE t0.id = ?
Parameters:
[
  34
]
6 0.13 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.avatar AS avatar_5, t0.updated_at AS updated_at_6, t0.subscription_started_at AS subscription_started_at_7, t0.subscription_ended_at AS subscription_ended_at_8, t0.type AS type_9, t0.customer_id AS customer_id_10, t0.sub_id AS sub_id_11, t0.subscription_active AS subscription_active_12, t0.subscription_type AS subscription_type_13, t0.created_at AS created_at_14, t0.enabled AS enabled_15, t0.address AS address_16, t0.complement_address AS complement_address_17, t0.zipcode AS zipcode_18, t0.city AS city_19, t0.country AS country_20, t0.first_name AS first_name_21, t0.last_name AS last_name_22, t0.phone AS phone_23, t0.email_validation_code AS email_validation_code_24, t0.email_validation_code_generated_at AS email_validation_code_generated_at_25, t0.reset_token AS reset_token_26, t0.reset_token_expires_at AS reset_token_expires_at_27, t0.credits AS credits_28, t29.id AS id_30, t29.name AS name_31, t29.phone AS phone_32, t29.bio AS bio_33, t29.specialty AS specialty_34, t29.rate AS rate_35, t29.price AS price_36, t29.price_int AS price_int_37, t29.latitude AS latitude_38, t29.longitude AS longitude_39, t29.location_updated_at AS location_updated_at_40, t29.facebook AS facebook_41, t29.instagram AS instagram_42, t29.whatsapp AS whatsapp_43, t29.tiktok AS tiktok_44, t29.user_id AS user_id_45, t46.id AS id_47, t46.phone AS phone_48, t46.name AS name_49, t46.description AS description_50, t46.opening_hours AS opening_hours_51, t46.closed_days AS closed_days_52, t46.latitude AS latitude_53, t46.longitude AS longitude_54, t46.budget AS budget_55, t46.instagram_url AS instagram_url_56, t46.facebook_url AS facebook_url_57, t46.website_url AS website_url_58, t46.rib_url AS rib_url_59, t46.user_id AS user_id_60, t61.id AS id_62, t61.preferred_location AS preferred_location_63, t61.typical_event_budget AS typical_event_budget_64, t61.user_id AS user_id_65 FROM user t0 LEFT JOIN artist t29 ON t29.user_id = t0.id LEFT JOIN establishment t46 ON t46.user_id = t0.id LEFT JOIN user_preferences t61 ON t61.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  81
]
7 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_fr AS name_fr_3, t0.icon AS icon_4, t0.updated_at AS updated_at_5 FROM type_artiste t0 INNER JOIN artist_type_artiste ON t0.id = artist_type_artiste.type_artiste_id WHERE artist_type_artiste.artist_id = ?
Parameters:
[
  34
]
8 0.08 ms
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.name AS name_3, t0.description AS description_4, t0.opening_hours AS opening_hours_5, t0.closed_days AS closed_days_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.budget AS budget_9, t0.instagram_url AS instagram_url_10, t0.facebook_url AS facebook_url_11, t0.website_url AS website_url_12, t0.rib_url AS rib_url_13, t0.user_id AS user_id_14, t15.id AS id_16, t15.balance_due AS balance_due_17, t15.balance_paid AS balance_paid_18, t15.last_balance_calculation AS last_balance_calculation_19, t15.last_payment_date AS last_payment_date_20, t15.notes AS notes_21, t15.establishment_id AS establishment_id_22 FROM establishment t0 LEFT JOIN establishment_finance t15 ON t15.establishment_id = t0.id WHERE t0.id = ?
Parameters:
[
  22
]
9 0.10 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.avatar AS avatar_5, t0.updated_at AS updated_at_6, t0.subscription_started_at AS subscription_started_at_7, t0.subscription_ended_at AS subscription_ended_at_8, t0.type AS type_9, t0.customer_id AS customer_id_10, t0.sub_id AS sub_id_11, t0.subscription_active AS subscription_active_12, t0.subscription_type AS subscription_type_13, t0.created_at AS created_at_14, t0.enabled AS enabled_15, t0.address AS address_16, t0.complement_address AS complement_address_17, t0.zipcode AS zipcode_18, t0.city AS city_19, t0.country AS country_20, t0.first_name AS first_name_21, t0.last_name AS last_name_22, t0.phone AS phone_23, t0.email_validation_code AS email_validation_code_24, t0.email_validation_code_generated_at AS email_validation_code_generated_at_25, t0.reset_token AS reset_token_26, t0.reset_token_expires_at AS reset_token_expires_at_27, t0.credits AS credits_28, t29.id AS id_30, t29.name AS name_31, t29.phone AS phone_32, t29.bio AS bio_33, t29.specialty AS specialty_34, t29.rate AS rate_35, t29.price AS price_36, t29.price_int AS price_int_37, t29.latitude AS latitude_38, t29.longitude AS longitude_39, t29.location_updated_at AS location_updated_at_40, t29.facebook AS facebook_41, t29.instagram AS instagram_42, t29.whatsapp AS whatsapp_43, t29.tiktok AS tiktok_44, t29.user_id AS user_id_45, t46.id AS id_47, t46.phone AS phone_48, t46.name AS name_49, t46.description AS description_50, t46.opening_hours AS opening_hours_51, t46.closed_days AS closed_days_52, t46.latitude AS latitude_53, t46.longitude AS longitude_54, t46.budget AS budget_55, t46.instagram_url AS instagram_url_56, t46.facebook_url AS facebook_url_57, t46.website_url AS website_url_58, t46.rib_url AS rib_url_59, t46.user_id AS user_id_60, t61.id AS id_62, t61.preferred_location AS preferred_location_63, t61.typical_event_budget AS typical_event_budget_64, t61.user_id AS user_id_65 FROM user t0 LEFT JOIN artist t29 ON t29.user_id = t0.id LEFT JOIN establishment t46 ON t46.user_id = t0.id LEFT JOIN user_preferences t61 ON t61.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  109
]
10 0.10 ms
SELECT t0.id AS id_1, t0.reserved_at AS reserved_at_2, t0.uuid AS uuid_3, t0.token_qrcode AS token_qrcode_4, t0.status AS status_5, t0.is_refund_requested AS is_refund_requested_6, t0.refund_status AS refund_status_7, t0.frameo_promotion_code AS frameo_promotion_code_8, t0.frameo_promotion_code_id AS frameo_promotion_code_id_9, t0.frameo_promotion_code_used AS frameo_promotion_code_used_10, t0.visitor_id AS visitor_id_11, t0.event_id AS event_id_12 FROM ticket_reservation t0 WHERE t0.event_id = ?
Parameters:
[
  76
]
11 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_fr AS name_fr_3, t0.icon AS icon_4, t0.updated_at AS updated_at_5 FROM type_event_organised t0 INNER JOIN event_type_event_organised ON t0.id = event_type_event_organised.type_event_organised_id WHERE event_type_event_organised.event_id = ?
Parameters:
[
  76
]
12 0.08 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.updated_at AS updated_at_3, t0.event_id AS event_id_4 FROM event_image t0 WHERE t0.event_id = ?
Parameters:
[
  76
]
13 0.12 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.avatar AS avatar_5, t0.updated_at AS updated_at_6, t0.subscription_started_at AS subscription_started_at_7, t0.subscription_ended_at AS subscription_ended_at_8, t0.type AS type_9, t0.customer_id AS customer_id_10, t0.sub_id AS sub_id_11, t0.subscription_active AS subscription_active_12, t0.subscription_type AS subscription_type_13, t0.created_at AS created_at_14, t0.enabled AS enabled_15, t0.address AS address_16, t0.complement_address AS complement_address_17, t0.zipcode AS zipcode_18, t0.city AS city_19, t0.country AS country_20, t0.first_name AS first_name_21, t0.last_name AS last_name_22, t0.phone AS phone_23, t0.email_validation_code AS email_validation_code_24, t0.email_validation_code_generated_at AS email_validation_code_generated_at_25, t0.reset_token AS reset_token_26, t0.reset_token_expires_at AS reset_token_expires_at_27, t0.credits AS credits_28, t29.id AS id_30, t29.name AS name_31, t29.phone AS phone_32, t29.bio AS bio_33, t29.specialty AS specialty_34, t29.rate AS rate_35, t29.price AS price_36, t29.price_int AS price_int_37, t29.latitude AS latitude_38, t29.longitude AS longitude_39, t29.location_updated_at AS location_updated_at_40, t29.facebook AS facebook_41, t29.instagram AS instagram_42, t29.whatsapp AS whatsapp_43, t29.tiktok AS tiktok_44, t29.user_id AS user_id_45, t46.id AS id_47, t46.phone AS phone_48, t46.name AS name_49, t46.description AS description_50, t46.opening_hours AS opening_hours_51, t46.closed_days AS closed_days_52, t46.latitude AS latitude_53, t46.longitude AS longitude_54, t46.budget AS budget_55, t46.instagram_url AS instagram_url_56, t46.facebook_url AS facebook_url_57, t46.website_url AS website_url_58, t46.rib_url AS rib_url_59, t46.user_id AS user_id_60, t61.id AS id_62, t61.preferred_location AS preferred_location_63, t61.typical_event_budget AS typical_event_budget_64, t61.user_id AS user_id_65 FROM user t0 LEFT JOIN artist t29 ON t29.user_id = t0.id LEFT JOIN establishment t46 ON t46.user_id = t0.id LEFT JOIN user_preferences t61 ON t61.user_id = t0.id INNER JOIN event_user ON t0.id = event_user.user_id WHERE event_user.event_id = ?
Parameters:
[
  76
]

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\EventImage 4
App\Entity\User 3
App\Entity\TypeArtiste 3
App\Entity\Establishment 2
App\Entity\EstablishmentFinance 2
App\Entity\Collaboration 2
App\Entity\Artist 2
App\Entity\UserPreferences 2
App\Entity\TypeEventOrganised 2
App\Entity\Event 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Artist No errors.
App\Entity\Establishment No errors.
App\Entity\UserPreferences No errors.
App\Entity\TicketReservation No errors.
App\Entity\Notification No errors.
App\Entity\Event
  • The field App\Entity\Event#collaborations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Collaboration#event does not contain the required 'inversedBy: "collaborations"' attribute.
App\Entity\Feedback No errors.
App\Entity\EstablishmentPhoto No errors.
App\Entity\Collaboration No errors.
App\Entity\TypeEstablishment
  • The field App\Entity\TypeEstablishment#establishments is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Establishment#typeEstablishments does not contain the required 'mappedBy: "establishments"' attribute.
App\Entity\TypeEventOrganised
  • The field App\Entity\TypeEventOrganised#userPreferences is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserPreferences#preferredEventTypes does not contain the required 'inversedBy: "userPreferences"' attribute.
App\Entity\TypeEquipement No errors.
App\Entity\TypeArtiste No errors.
App\Entity\EstablishmentFinance
  • The field 'App\Entity\EstablishmentFinance#balanceDue' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\EstablishmentFinance#balancePaid' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\EventImage No errors.
App\Entity\ArtistImage No errors.