Query Metrics
32
Database Queries
13
Different statements
13.88 ms
Query time
20
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.49 ms (17.92%) |
7 |
SELECT t0.id AS id_1, t0.module_key AS module_key_2, t0.module_display_name AS module_display_name_3, t0.manageable_actions AS manageable_actions_4, t0.access_module_role AS access_module_role_5 FROM access_modules t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
2.47 ms (17.80%) |
7 |
SELECT t0.id AS id_1, t0.section_key AS section_key_2, t0.section_display_name AS section_display_name_3, t0.manageable_actions AS manageable_actions_4, t0.access_module_id AS access_module_id_5 FROM access_module_sections t0 WHERE t0.access_module_id = ?
Parameters:
[
2
]
|
|
2.22 ms (16.00%) |
7 |
SELECT t0.id AS id_1, t0.r AS r_2, t0.u AS u_3, t0.access_module_section_id AS access_module_section_id_4, t0.user_module_permissions_id AS user_module_permissions_id_5 FROM user_module_section_permissions t0 WHERE t0.user_module_permissions_id = ?
Parameters:
[
33
]
|
|
1.35 ms (9.70%) |
2 |
SELECT t0.id AS id_1, t0.entry_at AS entry_at_2, t0.exit_at AS exit_at_3, t0.created_at AS created_at_4, t0.guest AS guest_5, t0.is_kpi_responsible AS is_kpi_responsible_6, t0.termination_reason AS termination_reason_7, t0.hourly_rate AS hourly_rate_8, t0.daily_working_hours AS daily_working_hours_9, t0.worker_id AS worker_id_10, t0.partner_id AS partner_id_11, t0.user_id AS user_id_12 FROM worker_activities t0 WHERE t0.user_id = ? ORDER BY t0.id ASC
Parameters:
[
18
]
|
|
1.01 ms (7.26%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.surname AS surname_6, t0.login_refused AS login_refused_7, t0.login_refused_message AS login_refused_message_8, t0.invisible_since AS invisible_since_9, t0.is_password_updated_at AS is_password_updated_at_10, t0.news_last_seen_at AS news_last_seen_at_11, t0.idle_timer_timeout AS idle_timer_timeout_12, t0.notification_preferences AS notification_preferences_13, t0.ui_preferences AS ui_preferences_14, t0.email_signature AS email_signature_15, t16.id AS id_17, t16.name AS name_18, t16.surname AS surname_19, t16.entry_at AS entry_at_20, t16.exit_at AS exit_at_21, t16.birthday_at AS birthday_at_22, t16.slug AS slug_23, t16.daily_work_time AS daily_work_time_24, t16.cost_per_hour AS cost_per_hour_25, t16.personal_id AS personal_id_26, t16.created_at AS created_at_27, t16.phone_number AS phone_number_28, t16.social_insurance_number AS social_insurance_number_29, t16.uiid AS uiid_30, t16.profile_image AS profile_image_31, t16.email AS email_32, t16.default_qualification_id AS default_qualification_id_33, t16.user_id AS user_id_34, t0.user_position_id AS user_position_id_35 FROM user t0 LEFT JOIN worker t16 ON t16.user_id = t0.id WHERE t0.id = ?
Parameters:
[
18
]
|
|
0.86 ms (6.18%) |
1 |
SELECT t0.id AS id_1, t0.company AS company_2, t0.slug AS slug_3, t0.tel AS tel_4, t0.company_logo AS company_logo_5, t0.city AS city_6, t0.email AS email_7, t0.country_id AS country_id_8, t9.id AS id_10, t9.name AS name_11, t9.tel AS tel_12, t9.email AS email_13, t9.street AS street_14, t9.house_number AS house_number_15, t9.postcode AS postcode_16, t9.city AS city_17, t9.legal_name AS legal_name_18, t9.tax_no AS tax_no_19, t9.vat_id AS vat_id_20, t9.trade_register AS trade_register_21, t9.register_court AS register_court_22, t9.managing_director AS managing_director_23, t9.bank_name AS bank_name_24, t9.iban AS iban_25, t9.bic AS bic_26, t9.payment_terms_days AS payment_terms_days_27, t9.payment_terms_note AS payment_terms_note_28, t9.about_short AS about_short_29, t9.about_long AS about_long_30, t9.version AS version_31, t9.updated_at AS updated_at_32, t9.updated_by AS updated_by_33, t9.paired_partner_id AS paired_partner_id_34, t9.country_id AS country_id_35 FROM partner t0 LEFT JOIN company_profile t9 ON t9.paired_partner_id = t0.id WHERE t0.id = ?
Parameters:
[
12
]
|
|
0.83 ms (5.99%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.entry_at AS entry_at_4, t0.exit_at AS exit_at_5, t0.birthday_at AS birthday_at_6, t0.slug AS slug_7, t0.daily_work_time AS daily_work_time_8, t0.cost_per_hour AS cost_per_hour_9, t0.personal_id AS personal_id_10, t0.created_at AS created_at_11, t0.phone_number AS phone_number_12, t0.social_insurance_number AS social_insurance_number_13, t0.uiid AS uiid_14, t0.profile_image AS profile_image_15, t0.email AS email_16, t0.default_qualification_id AS default_qualification_id_17, t0.user_id AS user_id_18 FROM worker t0 WHERE t0.id = ?
Parameters:
[
360
]
|
|
0.62 ms (4.49%) |
1 |
SELECT t0.id AS id_1, t0.entry_at AS entry_at_2, t0.exit_at AS exit_at_3, t0.created_at AS created_at_4, t0.guest AS guest_5, t0.is_kpi_responsible AS is_kpi_responsible_6, t0.termination_reason AS termination_reason_7, t0.hourly_rate AS hourly_rate_8, t0.daily_working_hours AS daily_working_hours_9, t0.worker_id AS worker_id_10, t0.partner_id AS partner_id_11, t0.user_id AS user_id_12 FROM worker_activities t0 WHERE (t0.exit_at IS NULL AND t0.worker_id = ?) ORDER BY t0.id DESC LIMIT 1
Parameters:
[
360
]
|
|
0.53 ms (3.83%) |
1 |
SELECT t0.id AS id_1, t0.entry_at AS entry_at_2, t0.exit_at AS exit_at_3, t0.created_at AS created_at_4, t0.guest AS guest_5, t0.is_kpi_responsible AS is_kpi_responsible_6, t0.termination_reason AS termination_reason_7, t0.hourly_rate AS hourly_rate_8, t0.daily_working_hours AS daily_working_hours_9, t0.worker_id AS worker_id_10, t0.partner_id AS partner_id_11, t0.user_id AS user_id_12 FROM worker_activities t0 INNER JOIN worker_activity_substitutions ON t0.id = worker_activity_substitutions.substituted_activity_id WHERE worker_activity_substitutions.main_activity_id = ?
Parameters:
[
291
]
|
|
0.47 ms (3.39%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.service_id AS service_id_4 FROM user_global_password_access t0 WHERE t0.user_id = ?
Parameters:
[
18
]
|
|
0.38 ms (2.76%) |
1 |
SELECT t0.id AS id_1, t0.r AS r_2, t0.c AS c_3, t0.u AS u_4, t0.d AS d_5, t0.access_module_id AS access_module_id_6, t0.user_id AS user_id_7 FROM user_module_permissions t0 WHERE t0.user_id = ?
Parameters:
[
18
]
|
|
0.33 ms (2.35%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM user_positions t0 WHERE t0.id = ?
Parameters:
[
13
]
|
|
0.32 ms (2.33%) |
1 |
SELECT t0.id AS id_1, t0.only_owned AS only_owned_2, t0.user_id AS user_id_3, t0.scoped_item_id AS scoped_item_id_4 FROM user_scoped_item t0 WHERE t0.user_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 |
|
| App\Entity\Worker |
|
| App\Entity\Qualification | No errors. |
| App\Entity\UserPositions | No errors. |
| App\Entity\ProjectAddendumCosts |
|
| App\Entity\AccessRoles | No errors. |
| App\Entity\WorkerTimesheetPayments |
|
| App\Entity\ProjectOrderFeedback |
|
| App\Entity\ProjectOrders |
|
| App\Entity\UserModulePermissions | No errors. |
| App\Entity\Inventory | No errors. |
| App\Entity\SupplierOrders |
|
| App\Entity\UserScopedItem | No errors. |
| App\Entity\UserCalculationPermission | No errors. |
| App\Entity\WorkerActivities | No errors. |
| App\Entity\PurchaseRequest |
|
| App\Entity\PurchaseRequestPositionHistoryRead | No errors. |
| App\Entity\PurchaseRequestHistoryRead | No errors. |
| App\Entity\PurchaseRequestHistories | No errors. |
| App\Entity\PurchaseRequestUserFavorites |
|
| App\Entity\PurchaseRequestPositions | No errors. |
| App\Entity\Warehouses | No errors. |
| App\Entity\StockIssue | No errors. |
| App\Entity\StockIssuePositions | No errors. |
| App\Entity\ProjectAIReports | No errors. |
| App\Entity\Invoices | No errors. |
| App\Entity\ProjectOrderBillings |
|
| App\Entity\UserServiceAccess | No errors. |
| App\Entity\UserGlobalPasswordAccess | No errors. |
| App\Entity\Partner |
|
| App\Entity\WorkerTimesheet |
|
| App\Entity\WorkerInProject |
|
| App\Entity\WorkerActivityLeaveEntitlement | No errors. |
| App\Entity\ProjectOrderTasks |
|
| App\Entity\ProjectOrderTaskFulfillment | No errors. |
| App\Entity\AccessModules | No errors. |
| App\Entity\UserModuleSectionPermissions |
|
| App\Entity\AccessModuleSections |
|
| App\Entity\ScopedItems | No errors. |
| App\Entity\UserPositionsGroup | No errors. |
| App\Entity\WorkerCertificates |
|
| App\Entity\UserAppSettings | No errors. |
| App\Entity\Countries |
|
| App\Entity\CompanyProfile | No errors. |
| App\Entity\ProjectStakeholders |
|
| App\Entity\PartnerCertificates |
|
| App\Entity\Services | No errors. |