http://romon-erp.com/api/v3/profiler/authenticated Return to referer URL

Query Metrics

34 Database Queries
12 Different statements
13.22 ms Query time
20 Invalid entities

Queries

Group similar statements

# Time Info
1 0.85 ms
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.email_signature AS email_signature_14, t15.id AS id_16, t15.name AS name_17, t15.surname AS surname_18, t15.entry_at AS entry_at_19, t15.exit_at AS exit_at_20, t15.birthday_at AS birthday_at_21, t15.slug AS slug_22, t15.daily_work_time AS daily_work_time_23, t15.cost_per_hour AS cost_per_hour_24, t15.personal_id AS personal_id_25, t15.created_at AS created_at_26, t15.phone_number AS phone_number_27, t15.uiid AS uiid_28, t15.profile_image AS profile_image_29, t15.email AS email_30, t15.user_id AS user_id_31, t0.user_position_id AS user_position_id_32 FROM user t0 LEFT JOIN worker t15 ON t15.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  13
]
2 0.67 ms
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:
[
  13
]
3 0.62 ms
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:
[
  13
]
4 0.43 ms
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:
[
  13
]
5 0.54 ms
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:
[
  1
]
6 0.49 ms
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:
[
  1
]
7 0.34 ms
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:
[
  68
]
8 0.30 ms
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
]
9 0.35 ms
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
]
10 0.40 ms
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:
[
  44
]
11 0.31 ms
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:
[
  3
]
12 0.33 ms
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:
[
  3
]
13 0.32 ms
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:
[
  45
]
14 0.31 ms
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:
[
  4
]
15 0.27 ms
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:
[
  4
]
16 0.31 ms
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:
[
  46
]
17 0.26 ms
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:
[
  7
]
18 0.27 ms
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:
[
  7
]
19 0.25 ms
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:
[
  32
]
20 0.25 ms
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:
[
  9
]
21 0.31 ms
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:
[
  9
]
22 0.30 ms
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:
[
  101
]
23 0.25 ms
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:
[
  10
]
24 0.28 ms
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:
[
  10
]
25 0.28 ms
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:
[
  61
]
26 0.25 ms
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:
[
  104
]
27 0.29 ms
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:
[
  104
]
28 0.24 ms
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:
[
  122
]
29 0.27 ms
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:
[
  13
]
30 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM user_positions t0 WHERE t0.id = ?
Parameters:
[
  17
]
31 0.72 ms
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.uiid AS uiid_13, t0.profile_image AS profile_image_14, t0.email AS email_15, t0.user_id AS user_id_16 FROM worker t0 WHERE t0.id = ?
Parameters:
[
  115
]
32 0.53 ms
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:
[
  115
]
33 0.75 ms
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.company_name AS company_name_11, t9.paired_partner_id AS paired_partner_id_12 FROM partner t0 LEFT JOIN administrative t9 ON t9.paired_partner_id = t0.id WHERE t0.id = ?
Parameters:
[
  12
]
34 0.54 ms
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:
[
  91
]

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
  • The association App\Entity\User#inventories refers to the owning side field App\Entity\Inventory#involved_by which does not exist.
App\Entity\Worker
  • The mappings App\Entity\Worker#worker_certificates and App\Entity\WorkerCertificates#worker are inconsistent with each other.
  • The association App\Entity\Worker#projectOrders refers to the owning side field App\Entity\ProjectOrders#order_lead which does not exist.
App\Entity\UserPositions No errors.
App\Entity\ProjectAddendumCosts
  • The association App\Entity\ProjectAddendumCosts#project refers to the inverse side field App\Entity\Projects#projectAddendumCosts which does not exist.
App\Entity\AccessRoles No errors.
App\Entity\WorkerTimesheetPayments
  • The association App\Entity\WorkerTimesheetPayments#project refers to the inverse side field App\Entity\Projects#workerTimesheetPayments which does not exist.
App\Entity\ProjectOrderFeedback
  • The association App\Entity\ProjectOrderFeedback#project_order refers to the inverse side field App\Entity\ProjectOrders#projectOrderFeedback which does not exist.
App\Entity\ProjectOrders
  • The mappings App\Entity\ProjectOrders#project_order_feedback and App\Entity\ProjectOrderFeedback#project_order are inconsistent with each other.
  • The mappings App\Entity\ProjectOrders#project_order_invoices and App\Entity\ProjectOrderInvoices#project_order are inconsistent with each other.
  • The association App\Entity\ProjectOrders#contact_person refers to the inverse side field App\Entity\ProjectOwnerContactPersons#projectOrders which does not exist.
  • The mappings App\Entity\ProjectOrders#project_order_extra_costs and App\Entity\ProjectOrderExtraCosts#project_order are inconsistent with each other.
  • The mappings App\Entity\ProjectOrders#project_order_expense_positions and App\Entity\ProjectOrderExpensePositions#project_order are inconsistent with each other.
  • The association App\Entity\ProjectOrders#order_branch refers to the inverse side field App\Entity\Branches#projectOrders which does not exist.
App\Entity\UserModulePermissions No errors.
App\Entity\Inventory No errors.
App\Entity\SupplierOrders
  • The association App\Entity\SupplierOrders#inventories refers to the owning side field App\Entity\Inventory#supplier_order which does not exist.
App\Entity\UserScopedItem No errors.
App\Entity\UserCalculationPermission No errors.
App\Entity\WorkerActivities No errors.
App\Entity\PurchaseRequest
  • The mappings App\Entity\PurchaseRequest#purchase_request_user_favorites and App\Entity\PurchaseRequestUserFavorites#purchase_request are inconsistent with each other.
  • The mappings App\Entity\PurchaseRequest#expenses and App\Entity\ProjectOrderExpenses#purchase_request are inconsistent with each other.
App\Entity\PurchaseRequestPositionHistoryRead No errors.
App\Entity\PurchaseRequestHistoryRead No errors.
App\Entity\PurchaseRequestHistories No errors.
App\Entity\PurchaseRequestUserFavorites
  • The association App\Entity\PurchaseRequestUserFavorites#purchase_request refers to the inverse side field App\Entity\PurchaseRequest#purchaseRequestUserFavorites which does not exist.
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
  • The mappings App\Entity\ProjectOrderBillings#invoice_positions and App\Entity\InvoicePositions#order_billing are inconsistent with each other.
App\Entity\Partner
  • The mappings App\Entity\Partner#partner_certificates and App\Entity\PartnerCertificates#partner are inconsistent with each other.
App\Entity\WorkerTimesheet
  • The association App\Entity\WorkerTimesheet#worker_a refers to the inverse side field App\Entity\Worker#worker_timesheets which does not exist.
App\Entity\WorkerInProject
  • The association App\Entity\WorkerInProject#worker refers to the inverse side field App\Entity\Worker#workerInProjects which does not exist.
  • The association App\Entity\WorkerInProject#project refers to the inverse side field App\Entity\ProjectStakeholders#workerInProjects which does not exist.
App\Entity\ProjectOrderTasks
  • The mappings App\Entity\ProjectOrderTasks#task_jobs and App\Entity\ProjectOrderTaskJobs#order_task are inconsistent with each other.
App\Entity\ProjectOrderTaskFulfillment No errors.
App\Entity\AccessModules No errors.
App\Entity\UserModuleSectionPermissions
  • The mappings App\Entity\UserModuleSectionPermissions#access_module_section and App\Entity\AccessModuleSections#user_module_section_permissions are inconsistent with each other.
App\Entity\AccessModuleSections
  • The association App\Entity\AccessModuleSections#user_module_section_permissions refers to the owning side field App\Entity\UserModuleSectionPermissions#user_module_section which does not exist.
App\Entity\ScopedItems No errors.
App\Entity\UserPositionsGroup No errors.
App\Entity\Qualification No errors.
App\Entity\WorkerCertificates
  • The association App\Entity\WorkerCertificates#worker refers to the inverse side field App\Entity\Worker#workerCertificates which does not exist.
  • The association App\Entity\WorkerCertificates#certificate refers to the inverse side field App\Entity\Certificates#worker_certificates which does not exist.
  • The mappings App\Entity\WorkerCertificates#worker_certificate_histories and App\Entity\WorkerCertificateHistories#worker_certificate are inconsistent with each other.
App\Entity\UserAppSettings No errors.
App\Entity\Countries
  • The mappings App\Entity\Countries#addresses and App\Entity\Addresses#country are inconsistent with each other.
App\Entity\Administrative No errors.
App\Entity\ProjectStakeholders
  • The mappings App\Entity\ProjectStakeholders#worker_in_projects and App\Entity\WorkerInProject#project are inconsistent with each other.
  • The association App\Entity\ProjectStakeholders#workerTimesheetPayments refers to the owning side field App\Entity\WorkerTimesheetPayments#project_stakeholder which does not exist.
App\Entity\PartnerCertificates
  • The association App\Entity\PartnerCertificates#partner refers to the inverse side field App\Entity\Partner#partnerCertificates which does not exist.
  • The mappings App\Entity\PartnerCertificates#partner_certificate_histories and App\Entity\PartnerCertificateHistories#partner_certificate are inconsistent with each other.