https://localbeez.ri7.fr/api/public/clubs/1/posts

Query Metrics

24 Database Queries
6 Different statements
55.89 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
29.89 ms
(53.48%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.type AS type_4, t0.event_date AS event_date_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.club_id AS club_id_9, t0.author_id AS author_id_10 FROM post t0 WHERE t0.club_id = ? AND t0.status = ? ORDER BY t0.created_at DESC LIMIT 10
Parameters:
[
  1
  "online"
]
8.68 ms
(15.54%)
10
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.main AS main_4, t0.visible AS visible_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.image_large_id AS image_large_id_8, t0.image_medium_id AS image_medium_id_9, t0.image_small_id AS image_small_id_10, t0.user_id AS user_id_11, t0.company_id AS company_id_12, t0.club_id AS club_id_13, t0.post_id AS post_id_14, t0.ad_id AS ad_id_15, t0.deal_id AS deal_id_16, t0.widget_id AS widget_id_17, t0.alert_id AS alert_id_18, t0.club_presentation_id AS club_presentation_id_19 FROM photo t0 WHERE t0.post_id = ?
Parameters:
[
  55
]
8.25 ms
(14.76%)
10
SELECT t0.id AS id_1, t0.filepath AS filepath_2, t0.image_type AS image_type_3, t0.filename AS filename_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM document t0 WHERE t0.id = ?
Parameters:
[
  277
]
4.92 ms
(8.80%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.description AS description_7, t0.city AS city_8, t0.country AS country_9, t0.postal_code AS postal_code_10, t0.birth_date AS birth_date_11, t0.phone AS phone_12, t0.gender AS gender_13, t0.admin_public_profile AS admin_public_profile_14, t0.stripe_id AS stripe_id_15, t0.fti AS fti_16, t0.title AS title_17, t0.notification_token AS notification_token_18, t0.accept_notification AS accept_notification_19, t0.google_id AS google_id_20, t0.google_name AS google_name_21, t0.delete_request_date AS delete_request_date_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24 FROM user t0 WHERE t0.id = ?
Parameters:
[
  8
]
2.75 ms
(4.91%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.theme AS theme_2, c0_.home_message AS home_message_3, c0_.website AS website_4, c0_.phone AS phone_5, c0_.email AS email_6, c0_.address_id AS address_id_7 FROM club c0_ WHERE c0_.id = ?
Parameters:
[
  1
]
1.41 ms
(2.52%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.main AS main_4, t0.visible AS visible_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.image_large_id AS image_large_id_8, t0.image_medium_id AS image_medium_id_9, t0.image_small_id AS image_small_id_10, t0.user_id AS user_id_11, t0.company_id AS company_id_12, t0.club_id AS club_id_13, t0.post_id AS post_id_14, t0.ad_id AS ad_id_15, t0.deal_id AS deal_id_16, t0.widget_id AS widget_id_17, t0.alert_id AS alert_id_18, t0.club_presentation_id AS club_presentation_id_19 FROM photo t0 WHERE t0.user_id = ?
Parameters:
[
  8
]

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\Club No errors.
App\Entity\Address No errors.
App\Entity\Post No errors.
App\Entity\Membership No errors.
App\Entity\Photo No errors.
App\Entity\Ad No errors.
App\Entity\UserClub No errors.
App\Entity\Widget No errors.
App\Entity\Deal No errors.
App\Entity\ClubManager No errors.
App\Entity\Alert No errors.
App\Entity\ClubPresentation No errors.
App\Entity\User No errors.
App\Entity\Collaborator No errors.
App\Entity\Company No errors.
App\Entity\ClaimingRequest No errors.
App\Entity\Document No errors.