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

Grouped Statements

Show all queries

Time Count Info
2.59 ms
(19.62%)
8
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
]
2.47 ms
(18.72%)
8
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
]
2.44 ms
(18.47%)
8
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
]
1.29 ms
(9.78%)
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:
[
  13
]
0.85 ms
(6.43%)
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.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
]
0.75 ms
(5.68%)
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.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
]
0.72 ms
(5.42%)
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.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
]
0.54 ms
(4.07%)
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:
[
  91
]
0.53 ms
(4.03%)
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:
[
  115
]
0.43 ms
(3.26%)
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:
[
  13
]
0.32 ms
(2.45%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM user_positions t0 WHERE t0.id = ?
Parameters:
[
  17
]
0.27 ms
(2.07%)
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:
[
  13
]

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.