GET https://d.app.woptimizer.com/admin/lead/_latests

Query Metrics

9 Database Queries
2 Different statements
35.56 ms Query time
0 Invalid entities
25 Managed entities

Queries

Group similar statements

# Time Info
1 1.98 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.street AS street_8, t0.postcode AS postcode_9, t0.city AS city_10, t0.referrer AS referrer_11, t0.external_reference AS external_reference_12, t0.is_enabled AS is_enabled_13, t0.import_reference AS import_reference_14, t0.ip AS ip_15, t0.last_activity_at AS last_activity_at_16, t0.birthday AS birthday_17, t0.archived_at AS archived_at_18, t0.session_token AS session_token_19, t0.compliance AS compliance_20, t0.is_valid_email AS is_valid_email_21, t0.deleted_at AS deleted_at_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.uuid AS uuid_25, t0.civility_id AS civility_id_26, t0.avatar_id AS avatar_id_27, t0.company_id AS company_id_28 FROM app_user t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 30.33 ms
SELECT a0_.id AS id_0, a0_.data AS data_1, a0_.tracker AS tracker_2, a0_.is_enabled AS is_enabled_3, a0_.output AS output_4, a0_.external_reference AS external_reference_5, a0_.import_reference AS import_reference_6, a0_.ip AS ip_7, a0_.is_valid AS is_valid_8, a0_.archived_at AS archived_at_9, a0_.source_url AS source_url_10, a0_.external_tracker AS external_tracker_11, a0_.agreed_terms_at AS agreed_terms_at_12, a0_.agreed_terms_url AS agreed_terms_url_13, a0_.user_agent AS user_agent_14, a0_.deleted_at AS deleted_at_15, a0_.created_at AS created_at_16, a0_.updated_at AS updated_at_17, a0_.uuid AS uuid_18, a0_.project_type_id AS project_type_id_19, a0_.user_id AS user_id_20, a0_.tool_id AS tool_id_21 FROM app_lead a0_ LEFT JOIN app_user a1_ ON a0_.user_id = a1_.id LEFT JOIN app_tool a2_ ON a0_.tool_id = a2_.id LEFT JOIN app_campaign a3_ ON a2_.campaign_id = a3_.id WHERE a0_.deleted_at IS NULL AND a0_.archived_at IS NULL ORDER BY a0_.created_at DESC LIMIT 10
Parameters:
[]
3 0.69 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.street AS street_8, t0.postcode AS postcode_9, t0.city AS city_10, t0.referrer AS referrer_11, t0.external_reference AS external_reference_12, t0.is_enabled AS is_enabled_13, t0.import_reference AS import_reference_14, t0.ip AS ip_15, t0.last_activity_at AS last_activity_at_16, t0.birthday AS birthday_17, t0.archived_at AS archived_at_18, t0.session_token AS session_token_19, t0.compliance AS compliance_20, t0.is_valid_email AS is_valid_email_21, t0.deleted_at AS deleted_at_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.uuid AS uuid_25, t0.civility_id AS civility_id_26, t0.avatar_id AS avatar_id_27, t0.company_id AS company_id_28 FROM app_user t0 WHERE t0.id = ?
Parameters:
[
  16101
]
4 0.52 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.street AS street_8, t0.postcode AS postcode_9, t0.city AS city_10, t0.referrer AS referrer_11, t0.external_reference AS external_reference_12, t0.is_enabled AS is_enabled_13, t0.import_reference AS import_reference_14, t0.ip AS ip_15, t0.last_activity_at AS last_activity_at_16, t0.birthday AS birthday_17, t0.archived_at AS archived_at_18, t0.session_token AS session_token_19, t0.compliance AS compliance_20, t0.is_valid_email AS is_valid_email_21, t0.deleted_at AS deleted_at_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.uuid AS uuid_25, t0.civility_id AS civility_id_26, t0.avatar_id AS avatar_id_27, t0.company_id AS company_id_28 FROM app_user t0 WHERE t0.id = ?
Parameters:
[
  4059
]
5 0.45 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.street AS street_8, t0.postcode AS postcode_9, t0.city AS city_10, t0.referrer AS referrer_11, t0.external_reference AS external_reference_12, t0.is_enabled AS is_enabled_13, t0.import_reference AS import_reference_14, t0.ip AS ip_15, t0.last_activity_at AS last_activity_at_16, t0.birthday AS birthday_17, t0.archived_at AS archived_at_18, t0.session_token AS session_token_19, t0.compliance AS compliance_20, t0.is_valid_email AS is_valid_email_21, t0.deleted_at AS deleted_at_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.uuid AS uuid_25, t0.civility_id AS civility_id_26, t0.avatar_id AS avatar_id_27, t0.company_id AS company_id_28 FROM app_user t0 WHERE t0.id = ?
Parameters:
[
  23128
]
6 0.39 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.street AS street_8, t0.postcode AS postcode_9, t0.city AS city_10, t0.referrer AS referrer_11, t0.external_reference AS external_reference_12, t0.is_enabled AS is_enabled_13, t0.import_reference AS import_reference_14, t0.ip AS ip_15, t0.last_activity_at AS last_activity_at_16, t0.birthday AS birthday_17, t0.archived_at AS archived_at_18, t0.session_token AS session_token_19, t0.compliance AS compliance_20, t0.is_valid_email AS is_valid_email_21, t0.deleted_at AS deleted_at_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.uuid AS uuid_25, t0.civility_id AS civility_id_26, t0.avatar_id AS avatar_id_27, t0.company_id AS company_id_28 FROM app_user t0 WHERE t0.id = ?
Parameters:
[
  23127
]
7 0.38 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.street AS street_8, t0.postcode AS postcode_9, t0.city AS city_10, t0.referrer AS referrer_11, t0.external_reference AS external_reference_12, t0.is_enabled AS is_enabled_13, t0.import_reference AS import_reference_14, t0.ip AS ip_15, t0.last_activity_at AS last_activity_at_16, t0.birthday AS birthday_17, t0.archived_at AS archived_at_18, t0.session_token AS session_token_19, t0.compliance AS compliance_20, t0.is_valid_email AS is_valid_email_21, t0.deleted_at AS deleted_at_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.uuid AS uuid_25, t0.civility_id AS civility_id_26, t0.avatar_id AS avatar_id_27, t0.company_id AS company_id_28 FROM app_user t0 WHERE t0.id = ?
Parameters:
[
  23126
]
8 0.40 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.street AS street_8, t0.postcode AS postcode_9, t0.city AS city_10, t0.referrer AS referrer_11, t0.external_reference AS external_reference_12, t0.is_enabled AS is_enabled_13, t0.import_reference AS import_reference_14, t0.ip AS ip_15, t0.last_activity_at AS last_activity_at_16, t0.birthday AS birthday_17, t0.archived_at AS archived_at_18, t0.session_token AS session_token_19, t0.compliance AS compliance_20, t0.is_valid_email AS is_valid_email_21, t0.deleted_at AS deleted_at_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.uuid AS uuid_25, t0.civility_id AS civility_id_26, t0.avatar_id AS avatar_id_27, t0.company_id AS company_id_28 FROM app_user t0 WHERE t0.id = ?
Parameters:
[
  23125
]
9 0.41 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.street AS street_8, t0.postcode AS postcode_9, t0.city AS city_10, t0.referrer AS referrer_11, t0.external_reference AS external_reference_12, t0.is_enabled AS is_enabled_13, t0.import_reference AS import_reference_14, t0.ip AS ip_15, t0.last_activity_at AS last_activity_at_16, t0.birthday AS birthday_17, t0.archived_at AS archived_at_18, t0.session_token AS session_token_19, t0.compliance AS compliance_20, t0.is_valid_email AS is_valid_email_21, t0.deleted_at AS deleted_at_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.uuid AS uuid_25, t0.civility_id AS civility_id_26, t0.avatar_id AS avatar_id_27, t0.company_id AS company_id_28 FROM app_user t0 WHERE t0.id = ?
Parameters:
[
  23124
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Lead 10
App\Entity\User 8
App\Entity\Term 3
App\Entity\Tool 3
App\Entity\Media 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Term No errors.
App\Entity\Media No errors.
App\Entity\Company No errors.
App\Entity\Event No errors.
App\Entity\Lead No errors.
App\Entity\Tool No errors.
App\Entity\Campaign No errors.