Query Metrics
6
Database Queries
6
Different statements
1.42 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.22 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.lastname AS lastname_4, t0.firstname AS firstname_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.role_id AS role_id_8 FROM user t0 WHERE t0.id = ?
Parameters:
[
415
]
|
| 2 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.role AS role_3 FROM role t0 WHERE t0.id = ?
Parameters:
[
10
]
|
| 3 | 0.20 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.fname AS fname_3, t0.lname AS lname_4, t0.email AS email_5, t0.valid_email AS valid_email_6, t0.position AS position_7, t0.division AS division_8, t0.phone1 AS phone1_9, t0.phone2 AS phone2_10, t0.corp_phone AS corp_phone_11, t0.linkedin_url AS linkedin_url_12, t0.city AS city_13, t0.comment AS comment_14, t0.lock_date AS lock_date_15, t0.updated_at AS updated_at_16, t0.missing_data AS missing_data_17, t0.last_import AS last_import_18, t0.trash AS trash_19, t0.last_delete AS last_delete_20, t0.country_id AS country_id_21, t0.source_id AS source_id_22, t0.csp_id AS csp_id_23, t0.csptype_id AS csptype_id_24, t0.lock_user AS lock_user_25 FROM contact t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"48431"
]
|
| 4 | 0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.final_report AS final_report_5, t0.objective AS objective_6, t0.duration AS duration_7, t0.is_finished AS is_finished_8, t0.campaign_type_id AS campaign_type_id_9, t0.client_id AS client_id_10, t0.user_id AS user_id_11 FROM campaign t0 WHERE t0.id IS NULL LIMIT 1
Parameters:
[] |
| 5 | 0.40 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1 FROM conference c0_ WHERE c0_.id NOT IN (SELECT c1_.id FROM conference c1_ INNER JOIN contact_conference c2_ ON (c2_.conference_id = c1_.id) WHERE c2_.contact_id = ?) GROUP BY c0_.name
Parameters:
[
48431
]
|
| 6 | 0.18 ms |
SELECT c0_.id AS id_0, c1_.name AS name_1, c0_.topic AS topic_2 FROM contact_conference c0_ INNER JOIN conference c1_ ON c0_.conference_id = c1_.id WHERE c0_.contact_id = ? ORDER BY c0_.id ASC
Parameters:
[
48431
]
|
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 | No errors. |
| App\Entity\Role | No errors. |
| App\Entity\Campaign | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\Country |
|
| App\Entity\Source | No errors. |
| App\Entity\Csp | No errors. |
| App\Entity\Csptype | No errors. |
| App\Entity\RelatedContact | No errors. |
| App\Entity\ContactCompanyType | No errors. |
| App\Entity\CampaignType | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\Conference | No errors. |
| App\Entity\ContactConference | No errors. |