Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

2.55 ms Query time

5 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	1.00 ms	SELECT t0.id AS id_1, t0.username AS username_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.phone AS phone_7, t0.address AS address_8, t0.status AS status_9, t0.email AS email_10, t0.code_user AS code_user_11, t0.code_manager AS code_manager_12, t0.work_schedule AS work_schedule_13, t0.telegram AS telegram_14, t0.viber AS viber_15, t0.is_main_engineer_op AS is_main_engineer_op_16, t0.manager_id AS manager_id_17, t0.location_id AS location_id_18 FROM users t0 WHERE t0.username = ? LIMIT 1 Parameters: [`"bots"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.username AS username_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.phone AS phone_7, t0.address AS address_8, t0.status AS status_9, t0.email AS email_10, t0.code_user AS code_user_11, t0.code_manager AS code_manager_12, t0.work_schedule AS work_schedule_13, t0.telegram AS telegram_14, t0.viber AS viber_15, t0.is_main_engineer_op AS is_main_engineer_op_16, t0.manager_id AS manager_id_17, t0.location_id AS location_id_18 FROM users t0 WHERE t0.username = ? LIMIT 1 SELECT t0.id AS id_1, t0.username AS username_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.phone AS phone_7, t0.address AS address_8, t0.status AS status_9, t0.email AS email_10, t0.code_user AS code_user_11, t0.code_manager AS code_manager_12, t0.work_schedule AS work_schedule_13, t0.telegram AS telegram_14, t0.viber AS viber_15, t0.is_main_engineer_op AS is_main_engineer_op_16, t0.manager_id AS manager_id_17, t0.location_id AS location_id_18 FROM users t0 WHERE t0.username = 'bots' LIMIT 1;
2	1.55 ms	SELECT j0_.id AS id_0, j0_.description AS description_1, j0_.date_job AS date_job_2, j0_.test_status AS test_status_3, j0_.test_date AS test_date_4, j1_.id AS id_5, j1_.name AS name_6, j1_.description AS description_7, j1_.code1c AS code1c_8, j1_.date_entered AS date_entered_9, j1_.date AS date_10, j1_.date_start AS date_start_11, j1_.date_end AS date_end_12, j1_.status AS status_13, j1_.comentar AS comentar_14, j1_.date_start_audit AS date_start_audit_15, j1_.date_audit AS date_audit_16, j1_.date_send_c1 AS date_send_c1_17, j1_.status_main_engineer_op AS status_main_engineer_op_18, j1_.date_main_engineer_op AS date_main_engineer_op_19, w2_.id AS id_20, w2_.full_name AS full_name_21, w2_.date_entered AS date_entered_22, w2_.description AS description_23, w2_.code1c AS code1c_24, w2_.code_ipn AS code_ipn_25, w2_.phone AS phone_26, w2_.email AS email_27, w2_.date_start AS date_start_28, w2_.date_end AS date_end_29, w2_.position AS position_30, w2_.date_of_birth AS date_of_birth_31, w2_.seria_pasport AS seria_pasport_32, w2_.number_pasport AS number_pasport_33, w2_.status AS status_34, j0_.job_id AS job_id_35, j0_.worker_id AS worker_id_36, j1_.account_id AS account_id_37, j1_.commandment_id AS commandment_id_38, j1_.graph_id AS graph_id_39, j1_.protocole_id AS protocole_id_40, j1_.engineer_id AS engineer_id_41, j1_.factory_id AS factory_id_42, j1_.assigned_user_id AS assigned_user_id_43, j1_.main_engineer_op_id AS main_engineer_op_id_44, w2_.photo_id AS photo_id_45, w2_.user_image_id AS user_image_id_46 FROM job_worker j0_ LEFT JOIN jobs j1_ ON j0_.job_id = j1_.id LEFT JOIN workers w2_ ON j0_.worker_id = w2_.id WHERE j0_.id = ? Parameters: [`3127`] View formatted query View runnable query Explain query SELECT j0_.id AS id_0, j0_.description AS description_1, j0_.date_job AS date_job_2, j0_.test_status AS test_status_3, j0_.test_date AS test_date_4, j1_.id AS id_5, j1_.name AS name_6, j1_.description AS description_7, j1_.code1c AS code1c_8, j1_.date_entered AS date_entered_9, j1_.date AS date_10, j1_.date_start AS date_start_11, j1_.date_end AS date_end_12, j1_.status AS status_13, j1_.comentar AS comentar_14, j1_.date_start_audit AS date_start_audit_15, j1_.date_audit AS date_audit_16, j1_.date_send_c1 AS date_send_c1_17, j1_.status_main_engineer_op AS status_main_engineer_op_18, j1_.date_main_engineer_op AS date_main_engineer_op_19, w2_.id AS id_20, w2_.full_name AS full_name_21, w2_.date_entered AS date_entered_22, w2_.description AS description_23, w2_.code1c AS code1c_24, w2_.code_ipn AS code_ipn_25, w2_.phone AS phone_26, w2_.email AS email_27, w2_.date_start AS date_start_28, w2_.date_end AS date_end_29, w2_.position AS position_30, w2_.date_of_birth AS date_of_birth_31, w2_.seria_pasport AS seria_pasport_32, w2_.number_pasport AS number_pasport_33, w2_.status AS status_34, j0_.job_id AS job_id_35, j0_.worker_id AS worker_id_36, j1_.account_id AS account_id_37, j1_.commandment_id AS commandment_id_38, j1_.graph_id AS graph_id_39, j1_.protocole_id AS protocole_id_40, j1_.engineer_id AS engineer_id_41, j1_.factory_id AS factory_id_42, j1_.assigned_user_id AS assigned_user_id_43, j1_.main_engineer_op_id AS main_engineer_op_id_44, w2_.photo_id AS photo_id_45, w2_.user_image_id AS user_image_id_46 FROM job_worker j0_ LEFT JOIN jobs j1_ ON j0_.job_id = j1_.id LEFT JOIN workers w2_ ON j0_.worker_id = w2_.id WHERE j0_.id = ? SELECT j0_.id AS id_0, j0_.description AS description_1, j0_.date_job AS date_job_2, j0_.test_status AS test_status_3, j0_.test_date AS test_date_4, j1_.id AS id_5, j1_.name AS name_6, j1_.description AS description_7, j1_.code1c AS code1c_8, j1_.date_entered AS date_entered_9, j1_.date AS date_10, j1_.date_start AS date_start_11, j1_.date_end AS date_end_12, j1_.status AS status_13, j1_.comentar AS comentar_14, j1_.date_start_audit AS date_start_audit_15, j1_.date_audit AS date_audit_16, j1_.date_send_c1 AS date_send_c1_17, j1_.status_main_engineer_op AS status_main_engineer_op_18, j1_.date_main_engineer_op AS date_main_engineer_op_19, w2_.id AS id_20, w2_.full_name AS full_name_21, w2_.date_entered AS date_entered_22, w2_.description AS description_23, w2_.code1c AS code1c_24, w2_.code_ipn AS code_ipn_25, w2_.phone AS phone_26, w2_.email AS email_27, w2_.date_start AS date_start_28, w2_.date_end AS date_end_29, w2_.position AS position_30, w2_.date_of_birth AS date_of_birth_31, w2_.seria_pasport AS seria_pasport_32, w2_.number_pasport AS number_pasport_33, w2_.status AS status_34, j0_.job_id AS job_id_35, j0_.worker_id AS worker_id_36, j1_.account_id AS account_id_37, j1_.commandment_id AS commandment_id_38, j1_.graph_id AS graph_id_39, j1_.protocole_id AS protocole_id_40, j1_.engineer_id AS engineer_id_41, j1_.factory_id AS factory_id_42, j1_.assigned_user_id AS assigned_user_id_43, j1_.main_engineer_op_id AS main_engineer_op_id_44, w2_.photo_id AS photo_id_45, w2_.user_image_id AS user_image_id_46 FROM job_worker j0_ LEFT JOIN jobs j1_ ON j0_.job_id = j1_.id LEFT JOIN workers w2_ ON j0_.worker_id = w2_.id WHERE j0_.id = 3127;

#▲

Time

Info

1.00 ms

SELECT t0.id AS id_1, t0.username AS username_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.phone AS phone_7, t0.address AS address_8, t0.status AS status_9, t0.email AS email_10, t0.code_user AS code_user_11, t0.code_manager AS code_manager_12, t0.work_schedule AS work_schedule_13, t0.telegram AS telegram_14, t0.viber AS viber_15, t0.is_main_engineer_op AS is_main_engineer_op_16, t0.manager_id AS manager_id_17, t0.location_id AS location_id_18 FROM users t0 WHERE t0.username = ? LIMIT 1

Parameters:

[
  "bots"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.username AS username_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.phone AS phone_7,
  t0.address AS address_8,
  t0.status AS status_9,
  t0.email AS email_10,
  t0.code_user AS code_user_11,
  t0.code_manager AS code_manager_12,
  t0.work_schedule AS work_schedule_13,
  t0.telegram AS telegram_14,
  t0.viber AS viber_15,
  t0.is_main_engineer_op AS is_main_engineer_op_16,
  t0.manager_id AS manager_id_17,
  t0.location_id AS location_id_18
FROM
  users t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_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.phone AS phone_7, t0.address AS address_8, t0.status AS status_9, t0.email AS email_10, t0.code_user AS code_user_11, t0.code_manager AS code_manager_12, t0.work_schedule AS work_schedule_13, t0.telegram AS telegram_14, t0.viber AS viber_15, t0.is_main_engineer_op AS is_main_engineer_op_16, t0.manager_id AS manager_id_17, t0.location_id AS location_id_18 FROM users t0 WHERE t0.username = 'bots' LIMIT 1;

1.55 ms

SELECT j0_.id AS id_0, j0_.description AS description_1, j0_.date_job AS date_job_2, j0_.test_status AS test_status_3, j0_.test_date AS test_date_4, j1_.id AS id_5, j1_.name AS name_6, j1_.description AS description_7, j1_.code1c AS code1c_8, j1_.date_entered AS date_entered_9, j1_.date AS date_10, j1_.date_start AS date_start_11, j1_.date_end AS date_end_12, j1_.status AS status_13, j1_.comentar AS comentar_14, j1_.date_start_audit AS date_start_audit_15, j1_.date_audit AS date_audit_16, j1_.date_send_c1 AS date_send_c1_17, j1_.status_main_engineer_op AS status_main_engineer_op_18, j1_.date_main_engineer_op AS date_main_engineer_op_19, w2_.id AS id_20, w2_.full_name AS full_name_21, w2_.date_entered AS date_entered_22, w2_.description AS description_23, w2_.code1c AS code1c_24, w2_.code_ipn AS code_ipn_25, w2_.phone AS phone_26, w2_.email AS email_27, w2_.date_start AS date_start_28, w2_.date_end AS date_end_29, w2_.position AS position_30, w2_.date_of_birth AS date_of_birth_31, w2_.seria_pasport AS seria_pasport_32, w2_.number_pasport AS number_pasport_33, w2_.status AS status_34, j0_.job_id AS job_id_35, j0_.worker_id AS worker_id_36, j1_.account_id AS account_id_37, j1_.commandment_id AS commandment_id_38, j1_.graph_id AS graph_id_39, j1_.protocole_id AS protocole_id_40, j1_.engineer_id AS engineer_id_41, j1_.factory_id AS factory_id_42, j1_.assigned_user_id AS assigned_user_id_43, j1_.main_engineer_op_id AS main_engineer_op_id_44, w2_.photo_id AS photo_id_45, w2_.user_image_id AS user_image_id_46 FROM job_worker j0_ LEFT JOIN jobs j1_ ON j0_.job_id = j1_.id LEFT JOIN workers w2_ ON j0_.worker_id = w2_.id WHERE j0_.id = ?

Parameters:

[
  3127
]

View formatted query View runnable query Explain query

SELECT
  j0_.id AS id_0,
  j0_.description AS description_1,
  j0_.date_job AS date_job_2,
  j0_.test_status AS test_status_3,
  j0_.test_date AS test_date_4,
  j1_.id AS id_5,
  j1_.name AS name_6,
  j1_.description AS description_7,
  j1_.code1c AS code1c_8,
  j1_.date_entered AS date_entered_9,
  j1_.date AS date_10,
  j1_.date_start AS date_start_11,
  j1_.date_end AS date_end_12,
  j1_.status AS status_13,
  j1_.comentar AS comentar_14,
  j1_.date_start_audit AS date_start_audit_15,
  j1_.date_audit AS date_audit_16,
  j1_.date_send_c1 AS date_send_c1_17,
  j1_.status_main_engineer_op AS status_main_engineer_op_18,
  j1_.date_main_engineer_op AS date_main_engineer_op_19,
  w2_.id AS id_20,
  w2_.full_name AS full_name_21,
  w2_.date_entered AS date_entered_22,
  w2_.description AS description_23,
  w2_.code1c AS code1c_24,
  w2_.code_ipn AS code_ipn_25,
  w2_.phone AS phone_26,
  w2_.email AS email_27,
  w2_.date_start AS date_start_28,
  w2_.date_end AS date_end_29,
  w2_.position AS position_30,
  w2_.date_of_birth AS date_of_birth_31,
  w2_.seria_pasport AS seria_pasport_32,
  w2_.number_pasport AS number_pasport_33,
  w2_.status AS status_34,
  j0_.job_id AS job_id_35,
  j0_.worker_id AS worker_id_36,
  j1_.account_id AS account_id_37,
  j1_.commandment_id AS commandment_id_38,
  j1_.graph_id AS graph_id_39,
  j1_.protocole_id AS protocole_id_40,
  j1_.engineer_id AS engineer_id_41,
  j1_.factory_id AS factory_id_42,
  j1_.assigned_user_id AS assigned_user_id_43,
  j1_.main_engineer_op_id AS main_engineer_op_id_44,
  w2_.photo_id AS photo_id_45,
  w2_.user_image_id AS user_image_id_46
FROM
  job_worker j0_
  LEFT JOIN jobs j1_ ON j0_.job_id = j1_.id
  LEFT JOIN workers w2_ ON j0_.worker_id = w2_.id
WHERE
  j0_.id = ?

SELECT j0_.id AS id_0, j0_.description AS description_1, j0_.date_job AS date_job_2, j0_.test_status AS test_status_3, j0_.test_date AS test_date_4, j1_.id AS id_5, j1_.name AS name_6, j1_.description AS description_7, j1_.code1c AS code1c_8, j1_.date_entered AS date_entered_9, j1_.date AS date_10, j1_.date_start AS date_start_11, j1_.date_end AS date_end_12, j1_.status AS status_13, j1_.comentar AS comentar_14, j1_.date_start_audit AS date_start_audit_15, j1_.date_audit AS date_audit_16, j1_.date_send_c1 AS date_send_c1_17, j1_.status_main_engineer_op AS status_main_engineer_op_18, j1_.date_main_engineer_op AS date_main_engineer_op_19, w2_.id AS id_20, w2_.full_name AS full_name_21, w2_.date_entered AS date_entered_22, w2_.description AS description_23, w2_.code1c AS code1c_24, w2_.code_ipn AS code_ipn_25, w2_.phone AS phone_26, w2_.email AS email_27, w2_.date_start AS date_start_28, w2_.date_end AS date_end_29, w2_.position AS position_30, w2_.date_of_birth AS date_of_birth_31, w2_.seria_pasport AS seria_pasport_32, w2_.number_pasport AS number_pasport_33, w2_.status AS status_34, j0_.job_id AS job_id_35, j0_.worker_id AS worker_id_36, j1_.account_id AS account_id_37, j1_.commandment_id AS commandment_id_38, j1_.graph_id AS graph_id_39, j1_.protocole_id AS protocole_id_40, j1_.engineer_id AS engineer_id_41, j1_.factory_id AS factory_id_42, j1_.assigned_user_id AS assigned_user_id_43, j1_.main_engineer_op_id AS main_engineer_op_id_44, w2_.photo_id AS photo_id_45, w2_.user_image_id AS user_image_id_46 FROM job_worker j0_ LEFT JOIN jobs j1_ ON j0_.job_id = j1_.id LEFT JOIN workers w2_ ON j0_.worker_id = w2_.id WHERE j0_.id = 3127;

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#manager refers to the inverse side field App\Entity\User#firstName which is not defined as association. The association App\Entity\User#manager refers to the inverse side field App\Entity\User#firstName which does not exist. The association App\Entity\User#orders refers to the owning side field App\Entity\Orders#user which does not exist. The association App\Entity\User#assigned_jobs refers to the owning side field App\Entity\Jobs#assigned_user which does not exist.
App\Entity\Location	No errors.
App\Entity\UserLikeList	No errors.
App\Entity\Products	The mappings App\Entity\Products#media and App\Entity\MediaObject#product are inconsistent with each other.
App\Entity\Orders	The mappings App\Entity\Orders#client and App\Entity\User#orders are inconsistent with each other.
App\Entity\Accounts	No errors.
App\Entity\LoadInvoice	No errors.
App\Entity\Accepted	The mappings App\Entity\Accepted#client and App\Entity\User#accepteds are inconsistent with each other.
App\Entity\AcceptedProduct	No errors.
App\Entity\PreOrder	No errors.
App\Entity\MediaObject	No errors.
App\Entity\Coupons	No errors.
App\Entity\UsersDocs	No errors.
App\Entity\ProductBalanceInStorage	No errors.
App\Entity\Jobs	The mappings App\Entity\Jobs#assignedUser and App\Entity\User#assigned_jobs are inconsistent with each other.
App\Entity\JobWorker	No errors.
App\Entity\Workers	No errors.
App\Entity\Engineer	No errors.
App\Entity\Factory	No errors.

Symfony Profiler

https://api-pidriadnyk.diamantsugar.com.ua/api/job_workers/3127

Configuration Settings

Theme