POST https://ayda.cz/activities

Query Metrics

10 Database Queries
6 Different statements
5.68 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.27 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.image AS image_7, t0.active AS active_8, t0.degree AS degree_9, t0.description AS description_10, t0.monthly_hours AS monthly_hours_11, t0.holiday_hours AS holiday_hours_12, t0.hourly_wage AS hourly_wage_13, t0.lang AS lang_14, t0.birth_date AS birth_date_15, t0.work_since AS work_since_16, t0.app_design AS app_design_17, t0.app_sidebar_type AS app_sidebar_type_18, t0.app_sidebar_spread AS app_sidebar_spread_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.currency_id AS currency_id_22, t0.team_id AS team_id_23, t24.id AS id_25, t24.city AS city_26, t24.phone AS phone_27, t24.street_name AS street_name_28, t24.street_number AS street_number_29, t24.zip AS zip_30, t24.ident_number AS ident_number_31, t24.vat_number AS vat_number_32, t24.created_at AS created_at_33, t24.updated_at AS updated_at_34, t24.user_id AS user_id_35, t24.country_id AS country_id_36, t37.id AS id_38, t37.first_name AS first_name_39, t37.last_name AS last_name_40, t37.number AS number_41, t37.code AS code_42, t37.iban AS iban_43, t37.created_at AS created_at_44, t37.updated_at AS updated_at_45, t37.user_id AS user_id_46 FROM user t0 LEFT JOIN address t24 ON t24.user_id = t0.id LEFT JOIN bank_account t37 ON t37.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  779
]
2 0.87 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM activity a0_ LEFT JOIN user u1_ ON a0_.user_id = u1_.id
Parameters:
[]
3 0.22 ms
SELECT COUNT(a0_.id) AS sclr_0 FROM activity a0_ LEFT JOIN user u1_ ON a0_.user_id = u1_.id
Parameters:
[]
4 0.21 ms
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.content AS content_2, a0_.estimation AS estimation_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, u1_.id AS id_6, u1_.email AS email_7, u1_.roles AS roles_8, u1_.password AS password_9, u1_.first_name AS first_name_10, u1_.last_name AS last_name_11, u1_.image AS image_12, u1_.active AS active_13, u1_.degree AS degree_14, u1_.description AS description_15, u1_.monthly_hours AS monthly_hours_16, u1_.holiday_hours AS holiday_hours_17, u1_.hourly_wage AS hourly_wage_18, u1_.lang AS lang_19, u1_.birth_date AS birth_date_20, u1_.work_since AS work_since_21, u1_.app_design AS app_design_22, u1_.app_sidebar_type AS app_sidebar_type_23, u1_.app_sidebar_spread AS app_sidebar_spread_24, u1_.created_at AS created_at_25, u1_.updated_at AS updated_at_26, a0_.user_id AS user_id_27, u1_.currency_id AS currency_id_28, u1_.team_id AS team_id_29 FROM activity a0_ LEFT JOIN user u1_ ON a0_.user_id = u1_.id LIMIT 12 OFFSET 12
Parameters:
[]
5 1.68 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.begin AS begin_3, t0.end AS end_4, t0.duration AS duration_5, t0.price AS price_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.activity_id AS activity_id_9, t0.user_id AS user_id_10, t0.time_record_category_id AS time_record_category_id_11 FROM time_record t0 WHERE t0.activity_id = ?
Parameters:
[
  15
]
6 0.16 ms
SELECT t0.id AS id_1, t0.city AS city_2, t0.phone AS phone_3, t0.street_name AS street_name_4, t0.street_number AS street_number_5, t0.zip AS zip_6, t0.ident_number AS ident_number_7, t0.vat_number AS vat_number_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11, t0.country_id AS country_id_12 FROM address t0 WHERE t0.user_id = ?
Parameters:
[
  793
]
7 0.40 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.number AS number_4, t0.code AS code_5, t0.iban AS iban_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM bank_account t0 WHERE t0.user_id = ?
Parameters:
[
  793
]
8 0.37 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.begin AS begin_3, t0.end AS end_4, t0.duration AS duration_5, t0.price AS price_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.activity_id AS activity_id_9, t0.user_id AS user_id_10, t0.time_record_category_id AS time_record_category_id_11 FROM time_record t0 WHERE t0.activity_id = ?
Parameters:
[
  16
]
9 0.28 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.begin AS begin_3, t0.end AS end_4, t0.duration AS duration_5, t0.price AS price_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.activity_id AS activity_id_9, t0.user_id AS user_id_10, t0.time_record_category_id AS time_record_category_id_11 FROM time_record t0 WHERE t0.activity_id = ?
Parameters:
[
  17
]
10 0.22 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.begin AS begin_3, t0.end AS end_4, t0.duration AS duration_5, t0.price AS price_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.activity_id AS activity_id_9, t0.user_id AS user_id_10, t0.time_record_category_id AS time_record_category_id_11 FROM time_record t0 WHERE t0.activity_id = ?
Parameters:
[
  18
]

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\User No errors.
App\Entity\Currency No errors.
App\Entity\Team No errors.
App\Entity\Address No errors.
App\Entity\Country No errors.
App\Entity\BankAccount No errors.
App\Entity\Article
  • The mappings App\Entity\Article#comments and App\Entity\Comment#article are inconsistent with each other.
App\Entity\Comment
  • The association App\Entity\Comment#article refers to the inverse side field App\Entity\Article#comment which does not exist.
App\Entity\Like No errors.
App\Entity\Permission No errors.
App\Entity\Activity No errors.
App\Entity\TimeRecord No errors.
App\Entity\TimeRecordCategory No errors.