Query Metrics
40
Database Queries
7
Different statements
112.15 ms
Query time
3
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
53.91 ms (48.06%) |
7 |
"COMMIT"
Parameters:
[] |
22.20 ms (19.79%) |
7 |
"START TRANSACTION"
Parameters:
[] |
16.12 ms (14.37%) |
14 |
SELECT t0.id AS id_1, t0.hours AS hours_2, t0.minutes AS minutes_3, t0.days_of_week AS days_of_week_4, t0.days_of_month AS days_of_month_5, t0.months AS months_6, t0.no_holidays AS no_holidays_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM cron_time_entry t0 INNER JOIN job_cron_time_entry ON t0.id = job_cron_time_entry.cron_time_entry_id WHERE job_cron_time_entry.job_id = ?
Parameters:
[
1
]
|
11.19 ms (9.97%) |
7 |
UPDATE job SET hash = ?, updated_at = ? WHERE id = ?
Parameters:
[ "4c8d0cb7b9524a97035763a76abca1e2f1eb36433d3484f411" "2024-11-10 23:14:01" 3 ] |
4.73 ms (4.21%) |
2 |
SELECT t0.id AS id_1, t0.state AS state_2, t0.step_kind AS step_kind_3, t0.description AS description_4, t0.state_message_ftp AS state_message_ftp_5, t0.state_message_fax AS state_message_fax_6, t0.state_message_mail AS state_message_mail_7, t0.state_message_sms AS state_message_sms_8, t0.state_message_api AS state_message_api_9, t0.changing_sending AS changing_sending_10, t0.state_group AS state_group_11, t0.avis_try AS avis_try_12, t0.show_hist AS show_hist_13, t0.bookable AS bookable_14, t0.export_state_id AS export_state_id_15, t0.sgroup_id AS sgroup_id_16 FROM type_sending_state t0
Parameters:
[] |
2.69 ms (2.40%) |
2 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_dev AS is_dev_5, t0.all_depot AS all_depot_6, t0.email AS email_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.title AS title_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.right_level_id AS right_level_id_13, t0.standard_depot_id AS standard_depot_id_14, t0.state_id AS state_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
-1
]
|
1.33 ms (1.18%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.last_run AS last_run_4, t0.last_state AS last_state_5, t0.hash AS hash_6, t0.enabled AS enabled_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM job t0
Parameters:
[] |
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\TypeSendingState | No errors. |
App\Entity\TypeExportState | No errors. |
App\Entity\TypeSendingStateGroup | No errors. |
App\Entity\Message | No errors. |
App\Entity\StatSending |
|
App\Entity\Job | No errors. |
App\Entity\User | No errors. |
App\Entity\CronTimeEntry | No errors. |
App\Entity\JobHistory | No errors. |
App\Entity\TypeRightlevel | No errors. |
App\Entity\Depot | No errors. |
App\Entity\TypeState | No errors. |
App\Entity\UserSetting | No errors. |
App\Entity\Sending | No errors. |
App\Entity\DepotGroup | No errors. |
App\Entity\AssignDepot | No errors. |
App\Entity\StatSc |
|
App\Entity\UserLogin | No errors. |
App\Entity\RulesAutomatic |
|