Query Metrics
311
Database Queries
18
Different statements
29.21 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
18.49 ms (63.30%) |
249 |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.id AS id_4, t0.translatable_id AS translatable_id_5 FROM eventic_country_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
198
]
|
2.24 ms (7.69%) |
5 |
SELECT COUNT(e0_.id) AS sclr_0 FROM eventic_event e0_ INNER JOIN eventic_event_translation e1_ ON e0_.id = e1_.translatable_id LEFT JOIN eventic_event_date e2_ ON e0_.id = e2_.event_id LEFT JOIN eventic_venue e3_ ON e2_.venue_id = e3_.id AND (e3_.deleted_at IS NULL) LEFT JOIN eventic_organizer e4_ ON e0_.organizer_id = e4_.id AND (e4_.deleted_at IS NULL) LEFT JOIN eventic_user e5_ ON e4_.user_id = e5_.id AND (e5_.deleted_at IS NULL) WHERE (DATE(e2_.startdate) >= ? AND DATE(e2_.startdate) <= ? AND e0_.published = ? AND e2_.startdate >= CURRENT_TIMESTAMP AND e5_.enabled = ?) AND (e0_.deleted_at IS NULL) ORDER BY e2_.startdate ASC
Parameters:
[ "2024-09-21" "2024-09-22" 1 1 ] |
1.41 ms (4.81%) |
19 |
SELECT t0.label AS label_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.id AS id_4, t0.translatable_id AS translatable_id_5 FROM eventic_menu_element_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
1.19 ms (4.07%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT DISTINCT e0_.id AS id_0, e0_.chatbot_list AS chatbot_list_1, e0_.reference AS reference_2, e0_.views AS views_3, e0_.tickettemplate AS tickettemplate_4, e0_.youtubeurl AS youtubeurl_5, e0_.externallink AS externallink_6, e0_.phonenumber AS phonenumber_7, e0_.email AS email_8, e0_.twitter AS twitter_9, e0_.instagram AS instagram_10, e0_.facebook AS facebook_11, e0_.googleplus AS googleplus_12, e0_.linkedin AS linkedin_13, e0_.artists AS artists_14, e0_.tags AS tags_15, e0_.year AS year_16, e0_.image_name AS image_name_17, e0_.image_size AS image_size_18, e0_.image_mime_type AS image_mime_type_19, e0_.image_original_name AS image_original_name_20, e0_.image_dimensions AS image_dimensions_21, e0_.created_at AS created_at_22, e0_.updated_at AS updated_at_23, e0_.deleted_at AS deleted_at_24, e0_.published AS published_25, e0_.enablereviews AS enablereviews_26, e0_.whatsappnumber AS whatsappnumber_27, e0_.showattendees AS showattendees_28 FROM eventic_event e0_ INNER JOIN eventic_event_translation e1_ ON e0_.id = e1_.translatable_id LEFT JOIN eventic_event_date e2_ ON e0_.id = e2_.event_id LEFT JOIN eventic_venue e3_ ON e2_.venue_id = e3_.id AND (e3_.deleted_at IS NULL) LEFT JOIN eventic_organizer e4_ ON e0_.organizer_id = e4_.id AND (e4_.deleted_at IS NULL) LEFT JOIN eventic_user e5_ ON e4_.user_id = e5_.id AND (e5_.deleted_at IS NULL) WHERE ((e1_.name LIKE ? OR ? LIKE e1_.name OR e1_.description LIKE ? OR ? LIKE e1_.description OR e0_.tags LIKE ? OR ? LIKE e0_.tags OR e0_.artists LIKE ? OR ? LIKE e0_.artists) AND e0_.published = ? AND e2_.startdate >= CURRENT_TIMESTAMP AND e5_.enabled = ?) AND (e0_.deleted_at IS NULL) ORDER BY e2_.startdate ASC) dctrn_result) dctrn_table
Parameters:
[ "%2025%" "%2025%" "%2025%" "%2025%" "%2025%" "%2025%" "%2025%" "%2025%" 1 1 ] |
1.18 ms (4.04%) |
1 |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, startdate_39 FROM (SELECT DISTINCT e0_.id AS id_0, e0_.chatbot_list AS chatbot_list_1, e0_.reference AS reference_2, e0_.views AS views_3, e0_.tickettemplate AS tickettemplate_4, e0_.youtubeurl AS youtubeurl_5, e0_.externallink AS externallink_6, e0_.phonenumber AS phonenumber_7, e0_.email AS email_8, e0_.twitter AS twitter_9, e0_.instagram AS instagram_10, e0_.facebook AS facebook_11, e0_.googleplus AS googleplus_12, e0_.linkedin AS linkedin_13, e0_.artists AS artists_14, e0_.tags AS tags_15, e0_.year AS year_16, e0_.image_name AS image_name_17, e0_.image_size AS image_size_18, e0_.image_mime_type AS image_mime_type_19, e0_.image_original_name AS image_original_name_20, e0_.image_dimensions AS image_dimensions_21, e0_.created_at AS created_at_22, e0_.updated_at AS updated_at_23, e0_.deleted_at AS deleted_at_24, e0_.published AS published_25, e0_.enablereviews AS enablereviews_26, e0_.whatsappnumber AS whatsappnumber_27, e0_.showattendees AS showattendees_28, e1_.name AS name_29, e1_.description AS description_30, e1_.slug AS slug_31, e1_.locale AS locale_32, e1_.id AS id_33, e2_.id AS id_34, e2_.online AS online_35, e2_.meetinglink AS meetinglink_36, e2_.active AS active_37, e2_.reference AS reference_38, e2_.startdate AS startdate_39, e2_.enddate AS enddate_40, e3_.username AS username_41, e3_.username_canonical AS username_canonical_42, e3_.email AS email_43, e3_.email_canonical AS email_canonical_44, e3_.enabled AS enabled_45, e3_.salt AS salt_46, e3_.password AS password_47, e3_.last_login AS last_login_48, e3_.confirmation_token AS confirmation_token_49, e3_.password_requested_at AS password_requested_at_50, e3_.roles AS roles_51, e3_.id AS id_52, e3_.gender AS gender_53, e3_.firstname AS firstname_54, e3_.lastname AS lastname_55, e3_.slug AS slug_56, e3_.street AS street_57, e3_.street2 AS street2_58, e3_.city AS city_59, e3_.state AS state_60, e3_.postalcode AS postalcode_61, e3_.phone AS phone_62, e3_.birthdate AS birthdate_63, e3_.avatar_name AS avatar_name_64, e3_.avatar_size AS avatar_size_65, e3_.avatar_mime_type AS avatar_mime_type_66, e3_.avatar_original_name AS avatar_original_name_67, e3_.avatar_dimensions AS avatar_dimensions_68, e3_.facebook_profile_picture AS facebook_profile_picture_69, e3_.created_at AS created_at_70, e3_.updated_at AS updated_at_71, e3_.deleted_at AS deleted_at_72, e3_.facebook_id AS facebook_id_73, e3_.facebook_access_token AS facebook_access_token_74, e3_.google_id AS google_id_75, e3_.google_access_token AS google_access_token_76, e3_.api_key AS api_key_77 FROM eventic_event e0_ INNER JOIN eventic_event_translation e1_ ON e0_.id = e1_.translatable_id LEFT JOIN eventic_event_date e2_ ON e0_.id = e2_.event_id LEFT JOIN eventic_venue e4_ ON e2_.venue_id = e4_.id AND (e4_.deleted_at IS NULL) LEFT JOIN eventic_organizer e5_ ON e0_.organizer_id = e5_.id AND (e5_.deleted_at IS NULL) LEFT JOIN eventic_user e3_ ON e5_.user_id = e3_.id AND (e3_.deleted_at IS NULL) WHERE ((e1_.name LIKE ? OR ? LIKE e1_.name OR e1_.description LIKE ? OR ? LIKE e1_.description OR e0_.tags LIKE ? OR ? LIKE e0_.tags OR e0_.artists LIKE ? OR ? LIKE e0_.artists) AND e0_.published = ? AND e2_.startdate >= CURRENT_TIMESTAMP AND e3_.enabled = ?) AND (e0_.deleted_at IS NULL) ORDER BY e2_.startdate ASC) dctrn_result_inner ORDER BY startdate_39 ASC) dctrn_result LIMIT 10
Parameters:
[ "%2025%" "%2025%" "%2025%" "%2025%" "%2025%" "%2025%" "%2025%" "%2025%" 1 1 ] |
1.08 ms (3.69%) |
2 |
SELECT COUNT(e0_.id) AS sclr_0 FROM eventic_event e0_ INNER JOIN eventic_event_translation e1_ ON e0_.id = e1_.translatable_id LEFT JOIN eventic_event_date e2_ ON e0_.id = e2_.event_id LEFT JOIN eventic_venue e3_ ON e2_.venue_id = e3_.id AND (e3_.deleted_at IS NULL) LEFT JOIN eventic_organizer e4_ ON e0_.organizer_id = e4_.id AND (e4_.deleted_at IS NULL) LEFT JOIN eventic_user e5_ ON e4_.user_id = e5_.id AND (e5_.deleted_at IS NULL) WHERE (DATE(e2_.startdate) = ? AND e0_.published = ? AND e2_.startdate >= CURRENT_TIMESTAMP AND e5_.enabled = ?) AND (e0_.deleted_at IS NULL) ORDER BY e2_.startdate ASC
Parameters:
[ "2024-09-22" 1 1 ] |
0.94 ms (3.22%) |
1 |
SELECT e0_.id AS id_0, e0_.code AS code_1, e0_.hidden AS hidden_2, e0_.created_at AS created_at_3, e0_.updated_at AS updated_at_4, e0_.deleted_at AS deleted_at_5 FROM eventic_country e0_ INNER JOIN eventic_country_translation e1_ ON e0_.id = e1_.translatable_id WHERE (e0_.hidden = ?) AND (e0_.deleted_at IS NULL) ORDER BY e1_.name ASC
Parameters:
[
0
]
|
0.55 ms (1.89%) |
8 |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.id AS id_4, t0.translatable_id AS translatable_id_5 FROM eventic_category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
19
]
|
0.50 ms (1.72%) |
5 |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.locale AS locale_3, t0.id AS id_4, t0.translatable_id AS translatable_id_5 FROM eventic_audience_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
0.49 ms (1.66%) |
7 |
SELECT e0_.id AS id_0 FROM eventic_menu e0_ INNER JOIN eventic_menu_translation e1_ ON e0_.id = e1_.translatable_id WHERE e1_.slug = ?
Parameters:
[
"header-menu"
]
|
0.32 ms (1.09%) |
4 |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.link AS link_3, t0.custom_link AS custom_link_4, t0.position AS position_5, t0.menu_id AS menu_id_6 FROM eventic_menu_element t0 WHERE t0.menu_id = ? ORDER BY t0.position ASC
Parameters:
[
1
]
|
0.23 ms (0.78%) |
3 |
SELECT t0.name AS name_1, t0.header AS header_2, t0.slug AS slug_3, t0.locale AS locale_4, t0.id AS id_5, t0.translatable_id AS translatable_id_6 FROM eventic_menu_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
2
]
|
0.12 ms (0.41%) |
1 |
SELECT e0_.id AS id_0, e0_.image_name AS image_name_1, e0_.image_size AS image_size_2, e0_.image_mime_type AS image_mime_type_3, e0_.image_original_name AS image_original_name_4, e0_.image_dimensions AS image_dimensions_5, e0_.hidden AS hidden_6, e0_.created_at AS created_at_7, e0_.updated_at AS updated_at_8, e0_.deleted_at AS deleted_at_9 FROM eventic_audience e0_ INNER JOIN eventic_audience_translation e1_ ON e0_.id = e1_.translatable_id WHERE (e0_.hidden = ?) AND (e0_.deleted_at IS NULL) ORDER BY e1_.name ASC
Parameters:
[
0
]
|
0.10 ms (0.34%) |
1 |
SELECT DISTINCT e0_.id AS id_0, e0_.icon AS icon_1, e0_.image_name AS image_name_2, e0_.image_size AS image_size_3, e0_.image_mime_type AS image_mime_type_4, e0_.image_original_name AS image_original_name_5, e0_.image_dimensions AS image_dimensions_6, e0_.hidden AS hidden_7, e0_.featured AS featured_8, e0_.featuredorder AS featuredorder_9, e0_.created_at AS created_at_10, e0_.updated_at AS updated_at_11, e0_.deleted_at AS deleted_at_12 FROM eventic_category e0_ INNER JOIN eventic_category_translation e1_ ON e0_.id = e1_.translatable_id WHERE (e0_.hidden = ? AND e0_.featured = ?) AND (e0_.deleted_at IS NULL) ORDER BY e1_.name ASC LIMIT 9
Parameters:
[ 0 1 ] |
0.10 ms (0.33%) |
1 |
SELECT DISTINCT e0_.id AS id_0, e0_.icon AS icon_1, e0_.image_name AS image_name_2, e0_.image_size AS image_size_3, e0_.image_mime_type AS image_mime_type_4, e0_.image_original_name AS image_original_name_5, e0_.image_dimensions AS image_dimensions_6, e0_.hidden AS hidden_7, e0_.featured AS featured_8, e0_.featuredorder AS featuredorder_9, e0_.created_at AS created_at_10, e0_.updated_at AS updated_at_11, e0_.deleted_at AS deleted_at_12 FROM eventic_category e0_ INNER JOIN eventic_category_translation e1_ ON e0_.id = e1_.translatable_id WHERE (e0_.hidden = ? AND e0_.featured = ?) AND (e0_.deleted_at IS NULL) ORDER BY e1_.name ASC LIMIT 4
Parameters:
[ 0 1 ] |
0.10 ms (0.33%) |
1 |
SELECT t0.id AS id_1, t0.logo_name AS logo_name_2, t0.logo_size AS logo_size_3, t0.logo_mime_type AS logo_mime_type_4, t0.logo_original_name AS logo_original_name_5, t0.logo_dimensions AS logo_dimensions_6, t0.favicon_name AS favicon_name_7, t0.favicon_size AS favicon_size_8, t0.favicon_mime_type AS favicon_mime_type_9, t0.favicon_original_name AS favicon_original_name_10, t0.favicon_dimensions AS favicon_dimensions_11, t0.og_image_name AS og_image_name_12, t0.og_image_size AS og_image_size_13, t0.og_image_mime_type AS og_image_mime_type_14, t0.og_image_original_name AS og_image_original_name_15, t0.og_image_dimensions AS og_image_dimensions_16, t0.updated_at AS updated_at_17 FROM eventic_app_layout_setting t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.09 ms (0.31%) |
1 |
SELECT DISTINCT e0_.id AS id_0, e0_.icon AS icon_1, e0_.image_name AS image_name_2, e0_.image_size AS image_size_3, e0_.image_mime_type AS image_mime_type_4, e0_.image_original_name AS image_original_name_5, e0_.image_dimensions AS image_dimensions_6, e0_.hidden AS hidden_7, e0_.featured AS featured_8, e0_.featuredorder AS featuredorder_9, e0_.created_at AS created_at_10, e0_.updated_at AS updated_at_11, e0_.deleted_at AS deleted_at_12 FROM eventic_category e0_ INNER JOIN eventic_category_translation e1_ ON e0_.id = e1_.translatable_id WHERE (e0_.hidden = ?) AND (e0_.deleted_at IS NULL) ORDER BY e1_.name ASC
Parameters:
[
0
]
|
0.09 ms (0.30%) |
1 |
SELECT e0_.id AS id_0, e0_.code AS code_1, e0_.hidden AS hidden_2, e0_.created_at AS created_at_3, e0_.updated_at AS updated_at_4, e0_.deleted_at AS deleted_at_5 FROM eventic_country e0_ INNER JOIN eventic_country_translation e1_ ON e0_.id = e1_.translatable_id WHERE (e0_.hidden = ? AND e0_.code = ?) AND (e0_.deleted_at IS NULL) ORDER BY e1_.name ASC
Parameters:
[ 0 "US" ] |
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Event | No errors. |
App\Entity\EventTranslation | No errors. |
App\Entity\EventDate | No errors. |
App\Entity\Venue | No errors. |
App\Entity\Organizer | No errors. |
FOS\UserBundle\Model\User | No errors. |
App\Entity\User | No errors. |
App\Entity\AppLayoutSettings | No errors. |
App\Entity\Menu | No errors. |
App\Entity\MenuTranslation | No errors. |
App\Entity\MenuElement | No errors. |
App\Entity\MenuElementTranslation | No errors. |
App\Entity\Category | No errors. |
App\Entity\CategoryTranslation | No errors. |
App\Entity\Country | No errors. |
App\Entity\CountryTranslation | No errors. |
App\Entity\Audience | No errors. |
App\Entity\AudienceTranslation | No errors. |