Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 4082
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 8
• Debug
• Messages
• Emails
• Workflow
• Redis
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.ecoclient_user_id AS ecoclient_user_id_3, t0.username AS username_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.salutation AS salutation_7, t0.user_title AS user_title_8, t0.email AS email_9, t0.user_mobile AS user_mobile_10, t0.user_landline AS user_landline_11, t0.image AS image_12, t0.marker_image AS marker_image_13, t0.small_square_image AS small_square_image_14, t0.image_mime_type AS image_mime_type_15, t0.signature AS signature_16, t0.password AS password_17, t0.enable_ldap_authentication AS enable_ldap_authentication_18, t0.is_non_human AS is_non_human_19, t0.odoo_employee_id AS odoo_employee_id_20, t0.odoo_user_id AS odoo_user_id_21, t0.disabled_at AS disabled_at_22, t0.settings AS settings_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.deleted_at AS deleted_at_26 FROM user t0 WHERE t0.username = ? LIMIT 1

[
  "reuter"
]

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.ecoclient_user_id AS ecoclient_user_id_3,
  t0.username AS username_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.salutation AS salutation_7,
  t0.user_title AS user_title_8,
  t0.email AS email_9,
  t0.user_mobile AS user_mobile_10,
  t0.user_landline AS user_landline_11,
  t0.image AS image_12,
  t0.marker_image AS marker_image_13,
  t0.small_square_image AS small_square_image_14,
  t0.image_mime_type AS image_mime_type_15,
  t0.signature AS signature_16,
  t0.password AS password_17,
  t0.enable_ldap_authentication AS enable_ldap_authentication_18,
  t0.is_non_human AS is_non_human_19,
  t0.odoo_employee_id AS odoo_employee_id_20,
  t0.odoo_user_id AS odoo_user_id_21,
  t0.disabled_at AS disabled_at_22,
  t0.settings AS settings_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.deleted_at AS deleted_at_26
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.ecoclient_user_id AS ecoclient_user_id_3, t0.username AS username_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.salutation AS salutation_7, t0.user_title AS user_title_8, t0.email AS email_9, t0.user_mobile AS user_mobile_10, t0.user_landline AS user_landline_11, t0.image AS image_12, t0.marker_image AS marker_image_13, t0.small_square_image AS small_square_image_14, t0.image_mime_type AS image_mime_type_15, t0.signature AS signature_16, t0.password AS password_17, t0.enable_ldap_authentication AS enable_ldap_authentication_18, t0.is_non_human AS is_non_human_19, t0.odoo_employee_id AS odoo_employee_id_20, t0.odoo_user_id AS odoo_user_id_21, t0.disabled_at AS disabled_at_22, t0.settings AS settings_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.deleted_at AS deleted_at_26 FROM user t0 WHERE t0.username = 'reuter' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = ?

[
  7
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  role t0
  INNER JOIN user_role ON t0.id = user_role.role_id
WHERE
  user_role.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = 7;

SELECT t0.id AS id_1, t0.executed_at AS executed_at_2, t0.finished_at AS finished_at_3, t0.inspection_description AS inspection_description_4, t0.inspection_duration AS inspection_duration_5, t0.sent_at AS sent_at_6, t0.position AS position_7, t0.additional_protocol_fields AS additional_protocol_fields_8, t0.odoo_reference AS odoo_reference_9, t0.post_process_duration AS post_process_duration_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.area_id AS area_id_14, t0.inspection_previous_id AS inspection_previous_id_15, t0.inspection_executed_by_id AS inspection_executed_by_id_16, t0.created_by_user_id AS created_by_user_id_17, t0.updated_by_user_id AS updated_by_user_id_18, t0.sent_by_user_id AS sent_by_user_id_19 FROM inspection t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

[
  69694
]

SELECT
  t0.id AS id_1,
  t0.executed_at AS executed_at_2,
  t0.finished_at AS finished_at_3,
  t0.inspection_description AS inspection_description_4,
  t0.inspection_duration AS inspection_duration_5,
  t0.sent_at AS sent_at_6,
  t0.position AS position_7,
  t0.additional_protocol_fields AS additional_protocol_fields_8,
  t0.odoo_reference AS odoo_reference_9,
  t0.post_process_duration AS post_process_duration_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deleted_at AS deleted_at_13,
  t0.area_id AS area_id_14,
  t0.inspection_previous_id AS inspection_previous_id_15,
  t0.inspection_executed_by_id AS inspection_executed_by_id_16,
  t0.created_by_user_id AS created_by_user_id_17,
  t0.updated_by_user_id AS updated_by_user_id_18,
  t0.sent_by_user_id AS sent_by_user_id_19
FROM
  inspection t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.executed_at AS executed_at_2, t0.finished_at AS finished_at_3, t0.inspection_description AS inspection_description_4, t0.inspection_duration AS inspection_duration_5, t0.sent_at AS sent_at_6, t0.position AS position_7, t0.additional_protocol_fields AS additional_protocol_fields_8, t0.odoo_reference AS odoo_reference_9, t0.post_process_duration AS post_process_duration_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.area_id AS area_id_14, t0.inspection_previous_id AS inspection_previous_id_15, t0.inspection_executed_by_id AS inspection_executed_by_id_16, t0.created_by_user_id AS created_by_user_id_17, t0.updated_by_user_id AS updated_by_user_id_18, t0.sent_by_user_id AS sent_by_user_id_19 FROM inspection t0 WHERE t0.id = 69694 AND ((t0.deleted_at IS NULL));

SELECT t0.id AS id_1, t0.type AS type_2, t0.current_place AS current_place_3, t0.payload AS payload_4, t0.progress AS progress_5, t0.target_class AS target_class_6, t0.target_id AS target_id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.area_id AS area_id_10, t0.project_id AS project_id_11 FROM app_process t0 WHERE t0.target_class = ? AND t0.target_id = ? AND t0.type = ? LIMIT 1

[
  "App\Entity\Inspection"
  69694
  "odoo_inspection_sync"
]

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.current_place AS current_place_3,
  t0.payload AS payload_4,
  t0.progress AS progress_5,
  t0.target_class AS target_class_6,
  t0.target_id AS target_id_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.area_id AS area_id_10,
  t0.project_id AS project_id_11
FROM
  app_process t0
WHERE
  t0.target_class = ?
  AND t0.target_id = ?
  AND t0.type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.current_place AS current_place_3, t0.payload AS payload_4, t0.progress AS progress_5, t0.target_class AS target_class_6, t0.target_id AS target_id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.area_id AS area_id_10, t0.project_id AS project_id_11 FROM app_process t0 WHERE t0.target_class = 'App\\Entity\\Inspection' AND t0.target_id = 69694 AND t0.type = 'odoo_inspection_sync' LIMIT 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

UPDATE app_process SET current_place = ?, progress = ? WHERE id = ?

[
  "running"
  0
  2
]

UPDATE
  app_process
SET
  current_place = ?,
  progress = ?
WHERE
  id = ?

UPDATE app_process SET current_place = 'running', progress = 0 WHERE id = 2;

"COMMIT"

[]

"COMMIT"

"COMMIT";