Query Metrics

7 Database Queries
6 Different statements
3.54 ms Query time
0 Invalid entities
5 Managed entities

Queries

Group similar statements

# Time Info
1 1.43 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.thumbnail AS thumbnail_4, t0.short_content AS short_content_5, t0.content AS content_6, t0.date_add AS date_add_7, t0.date_upd AS date_upd_8, t0.date_pub AS date_pub_9, t0.post_type AS post_type_10, t0.post_meta AS post_meta_11, t0.event_start AS event_start_12, t0.event_end AS event_end_13, t0.gallery AS gallery_14, t0.user_id AS user_id_15, t0.status_id AS status_id_16, t0.region_id AS region_id_17, t0.parent_id AS parent_id_18 FROM post t0 WHERE t0.post_type = ? ORDER BY t0.date_pub DESC LIMIT 3
Parameters:
[
  "post"
]
2 0.46 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.thumbnail AS thumbnail_3, p0_.short_content AS short_content_4, p0_.content AS content_5, p0_.date_add AS date_add_6, p0_.date_upd AS date_upd_7, p0_.date_pub AS date_pub_8, p0_.post_type AS post_type_9, p0_.post_meta AS post_meta_10, p0_.event_start AS event_start_11, p0_.event_end AS event_end_12, p0_.gallery AS gallery_13, p0_.user_id AS user_id_14, p0_.status_id AS status_id_15, p0_.region_id AS region_id_16, p0_.parent_id AS parent_id_17 FROM post p0_ WHERE p0_.post_type IN (?, ?) AND (p0_.event_start BETWEEN ? AND ?) ORDER BY p0_.id ASC LIMIT 2
Parameters:
[
  "event"
  "club_edition"
  "2025-12-06 00:00:00"
  "2025-12-06 23:59:59"
]
3 0.22 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.thumbnail AS thumbnail_3, p0_.short_content AS short_content_4, p0_.content AS content_5, p0_.date_add AS date_add_6, p0_.date_upd AS date_upd_7, p0_.date_pub AS date_pub_8, p0_.post_type AS post_type_9, p0_.post_meta AS post_meta_10, p0_.event_start AS event_start_11, p0_.event_end AS event_end_12, p0_.gallery AS gallery_13, p0_.user_id AS user_id_14, p0_.status_id AS status_id_15, p0_.region_id AS region_id_16, p0_.parent_id AS parent_id_17 FROM post p0_ WHERE p0_.post_type IN (?, ?) AND (p0_.event_start BETWEEN ? AND ?) ORDER BY p0_.event_start ASC LIMIT 2
Parameters:
[
  "event"
  "club_edition"
  "2025-12-06 00:00:00"
  "2026-01-06 04:35:15"
]
4 0.23 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.thumbnail AS thumbnail_3, p0_.short_content AS short_content_4, p0_.content AS content_5, p0_.date_add AS date_add_6, p0_.date_upd AS date_upd_7, p0_.date_pub AS date_pub_8, p0_.post_type AS post_type_9, p0_.post_meta AS post_meta_10, p0_.event_start AS event_start_11, p0_.event_end AS event_end_12, p0_.gallery AS gallery_13, p0_.user_id AS user_id_14, p0_.status_id AS status_id_15, p0_.region_id AS region_id_16, p0_.parent_id AS parent_id_17 FROM post p0_ WHERE p0_.post_type IN (?, ?) AND p0_.event_start > ? ORDER BY p0_.id ASC LIMIT 2
Parameters:
[
  "event"
  "club_edition"
  "2026-01-06 04:35:15"
]
5 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.postcode AS postcode_4, t0.city AS city_5, t0.phone AS phone_6, t0.email AS email_7, t0.bank_account_number AS bank_account_number_8, t0.nip AS nip_9, t0.vat_payer AS vat_payer_10, t0.logo AS logo_11, t0.description AS description_12, t0.website AS website_13, t0.social_media_fb AS social_media_fb_14, t0.social_media_x AS social_media_x_15, t0.social_media_ig AS social_media_ig_16, t0.social_media_li AS social_media_li_17, t0.social_media_yt AS social_media_yt_18, t0.invoice_text AS invoice_text_19, t0.invoice_generate AS invoice_generate_20, t0.invoice_prefix AS invoice_prefix_21, t0.provision AS provision_22, t0.slug AS slug_23, t0.company_type AS company_type_24, t0.content AS content_25, t0.gallery AS gallery_26, t0.services AS services_27, t0.products AS products_28, t0.opening_hours AS opening_hours_29, t0.date_add AS date_add_30, t0.date_upd AS date_upd_31, t0.map_point AS map_point_32, t0.slogan AS slogan_33, t0.company_meta AS company_meta_34, t0.background_image AS background_image_35, t0.user_id AS user_id_36 FROM company t0 WHERE t0.company_type = ?
Parameters:
[
  "club_member"
]
6 0.60 ms
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.link AS link_2, b0_.image AS image_3, b0_.date_add AS date_add_4, b0_.date_start AS date_start_5, b0_.date_end AS date_end_6, b0_.user_id AS user_id_7 FROM banner b0_ INNER JOIN banner_banner_zone b2_ ON b0_.id = b2_.banner_id INNER JOIN banner_zone b1_ ON b1_.id = b2_.banner_zone_id WHERE b0_.date_end >= ? AND b1_.id = ? ORDER BY b0_.id ASC
Parameters:
[
  "2025-12-06 04:35:15"
  1
]
7 0.26 ms
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.link AS link_2, b0_.image AS image_3, b0_.date_add AS date_add_4, b0_.date_start AS date_start_5, b0_.date_end AS date_end_6, b0_.user_id AS user_id_7 FROM banner b0_ INNER JOIN banner_banner_zone b2_ ON b0_.id = b2_.banner_id INNER JOIN banner_zone b1_ ON b1_.id = b2_.banner_zone_id WHERE b0_.date_end >= ? AND b1_.id = ? ORDER BY b0_.id ASC
Parameters:
[
  "2025-12-06 04:35:15"
  2
]

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\Post 3
App\Entity\User 1
App\Entity\PostStatus 1

Entities Mapping

Class Mapping errors
App\Entity\Post No errors.
App\Entity\User No errors.
App\Entity\PostStatus No errors.
App\Entity\Region No errors.
App\Entity\PostCategory No errors.
App\Entity\EventTicket No errors.
App\Entity\Company No errors.
App\Entity\Banner No errors.
App\Entity\BannerZone No errors.
App\Entity\Role No errors.
App\Entity\Permission No errors.
App\Entity\Contact No errors.