Query Metrics
24
Database Queries
6
Different statements
55.89 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.75 ms |
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
]
|
2 | 29.89 ms |
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" ] |
3 | 4.92 ms |
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
]
|
4 | 1.41 ms |
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
]
|
5 | 0.90 ms |
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
]
|
6 | 1.05 ms |
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
]
|
7 | 0.85 ms |
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:
[
810
]
|
8 | 0.88 ms |
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:
[
808
]
|
9 | 0.89 ms |
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:
[
809
]
|
10 | 0.93 ms |
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:
[
54
]
|
11 | 0.77 ms |
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:
[
804
]
|
12 | 0.79 ms |
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:
[
802
]
|
13 | 0.87 ms |
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:
[
803
]
|
14 | 0.94 ms |
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:
[
53
]
|
15 | 0.68 ms |
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:
[
801
]
|
16 | 0.84 ms |
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:
[
799
]
|
17 | 0.78 ms |
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:
[
800
]
|
18 | 0.88 ms |
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:
[
42
]
|
19 | 0.81 ms |
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:
[
41
]
|
20 | 0.78 ms |
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:
[
34
]
|
21 | 0.84 ms |
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:
[
32
]
|
22 | 0.77 ms |
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:
[
31
]
|
23 | 0.83 ms |
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:
[
30
]
|
24 | 0.85 ms |
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:
[
28
]
|
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. |