Query Metrics
13
Database Queries
12
Different statements
1.62 ms
Query time
4
Invalid entities
23
Managed entities
Queries
| #▲ | 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 |
|
| App\Entity\Feedback | No errors. |
| App\Entity\EstablishmentPhoto | No errors. |
| App\Entity\Collaboration | No errors. |
| App\Entity\TypeEstablishment |
|
| App\Entity\TypeEventOrganised |
|
| App\Entity\TypeEquipement | No errors. |
| App\Entity\TypeArtiste | No errors. |
| App\Entity\EstablishmentFinance |
|
| App\Entity\EventImage | No errors. |
| App\Entity\ArtistImage | No errors. |