https://www.basiliek.devel.ticketing.nu/favicon.ico

Query Metrics

5 Database Queries
5 Different statements
118.91 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
68.09 ms
(57.26%)
1
SELECT t0.Id AS Id_1, t0.url AS url_2, t0.EventsId AS EventsId_3 FROM short_url t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "favicon.ico"
]
43.26 ms
(36.38%)
1
SELECT t0.Id AS Id_1, t0.slug AS slug_2, t0.slot AS slot_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.SitesId AS SitesId_6 FROM pages t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "favicon.ico"
]
5.94 ms
(4.99%)
1
SELECT e0_.Id AS Id_0, e0_.slug AS slug_1, e0_.icon AS icon_2, e0_.social_link AS social_link_3, e0_.artist_name AS artist_name_4, e0_.age_group AS age_group_5, e0_.tier AS tier_6, e0_.advertising AS advertising_7, e0_.max_sales AS max_sales_8, e0_.current_sales AS current_sales_9, e0_.created_at AS created_at_10, e0_.updated_at AS updated_at_11, e0_.project AS project_12, e0_.conference AS conference_13, e0_.multi_day AS multi_day_14, e0_.private_event AS private_event_15, e1_.Id AS Id_16, e1_.date_start AS date_start_17, e1_.date_end AS date_end_18, e1_.hidden AS hidden_19, e1_.hidden_calendar AS hidden_calendar_20, e1_.soldout AS soldout_21, e1_.places_active AS places_active_22, e1_.type AS type_23, e1_.project_type AS project_type_24, e1_.max_sales AS max_sales_25, e2_.Id AS Id_26, e2_.title AS title_27, e2_.short_description AS short_description_28, e2_.description AS description_29, e2_.special_title AS special_title_30, s3_.Id AS Id_31, s3_.position AS position_32, e1_.EventId AS EventId_33, e1_.LocationId AS LocationId_34, e2_.LanguageId AS LanguageId_35, e2_.EventsId AS EventsId_36, s3_.EventsId AS EventsId_37, s3_.SitesId AS SitesId_38 FROM events e0_ LEFT JOIN event_dates e1_ ON e0_.Id = e1_.EventId LEFT JOIN event_description e2_ ON e0_.Id = e2_.EventsId LEFT JOIN sites_to_events s3_ ON e0_.Id = s3_.EventsId WHERE (e1_.date_start >= ? AND s3_.SitesId = ?) AND ((e1_.date_start >= ? AND s3_.SitesId = ? AND e1_.LocationId = ?)) AND (e0_.project = 1) ORDER BY e1_.date_start DESC, e2_.title ASC
Parameters:
[
  "2024-11-16 00:00:00"
  3
  "2024-11-16 00:00:00"
  3
  8
]
0.81 ms
(0.69%)
1
SELECT t0.Id AS Id_1, t0.name AS name_2, t0.address AS address_3, t0.postal_code AS postal_code_4, t0.city AS city_5, t0.streetnr AS streetnr_6, t0.date_created AS date_created_7, t0.date_updated AS date_updated_8 FROM locations t0 WHERE t0.Id = ?
Parameters:
[
  8
]
0.81 ms
(0.68%)
1
SELECT s0_.Id AS Id_0, s0_.name AS name_1, s0_.mollie_live AS mollie_live_2, s0_.mollie_test AS mollie_test_3, s0_.url AS url_4, s0_.aliases AS aliases_5, s0_.template_folder AS template_folder_6, s0_.email AS email_7, s0_.email_bcc AS email_bcc_8, s0_.filter_by_venue AS filter_by_venue_9, s0_.master_site AS master_site_10, s0_.sendy_brand AS sendy_brand_11, s0_.advertising_brand AS advertising_brand_12, s0_.date_created AS date_created_13, s0_.date_updated AS date_updated_14, s0_.LocationId AS LocationId_15, s0_.ListId AS ListId_16 FROM sites s0_ WHERE s0_.url = ?
Parameters:
[
  "basiliek.devel.ticketing.nu"
]

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\ShortUrl No errors.
App\Entity\Events No errors.
App\Entity\Pages No errors.
App\Entity\Sites
  • The association App\Entity\Sites#user refers to the inverse side field App\Application\Sonata\UserBundle\Entity\User#sites which does not exist.
App\Entity\Locations No errors.
App\Entity\NewsletterLists No errors.
App\Entity\Orders No errors.
App\Entity\SitesToEvents No errors.
App\Entity\Newsletter No errors.
FOS\UserBundle\Model\User No errors.
Sonata\UserBundle\Entity\BaseUser No errors.
App\Application\Sonata\UserBundle\Entity\User No errors.
App\Entity\Coupons No errors.
App\Entity\StatsUsers No errors.
App\Entity\EventDates No errors.
App\Entity\EventDescription No errors.
App\Entity\Language No errors.