https://asus-merchandising.dtv-projects.com/login

Query Metrics

9 Database Queries
3 Different statements
7.76 ms Query time
1 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4, t0.field_type AS field_type_5, t0.title AS title_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "PORTAL_CHILDREN"
]
2 0.98 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4, t0.field_type AS field_type_5, t0.title AS title_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "FRONT_SECURITY_LOGIN_SETTING"
]
3 0.62 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4, t0.field_type AS field_type_5, t0.title AS title_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "FRONT_SECURITY_WRAPPER_HEADER_CONTENT_SETTING"
]
4 1.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4, t0.field_type AS field_type_5, t0.title AS title_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "FRONT_SECURITY_THEME_SETTING"
]
5 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4, t0.field_type AS field_type_5, t0.title AS title_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "FRONT_SECURITY_HEADER_SETTING"
]
6 0.75 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4, t0.field_type AS field_type_5, t0.title AS title_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "SSO_SETTINGS"
]
7 0.82 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4, t0.field_type AS field_type_5, t0.title AS title_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "FRONT_SECURITY_FOOTER_SETTING"
]
8 0.77 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.display_job AS display_job_4, t0.display_role AS display_role_5 FROM parameter_hook t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "footer"
]
9 1.03 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.title AS title_4, t0.file_name AS file_name_5, t0.original_name AS original_name_6, t0.extern_link AS extern_link_7, t0.no_footer AS no_footer_8, t0.display_role AS display_role_9, t0.display_job AS display_job_10, t0.thumbnail AS thumbnail_11, t0.display_universes AS display_universes_12, t0.public AS public_13, t0.display AS display_14, t0.language AS language_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.parameter_hook_id AS parameter_hook_id_18, t0.user_related_id AS user_related_id_19 FROM parameter t0 WHERE t0.parameter_hook_id = ?
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection
user_logs doctrine.dbal.user_logs_connection
dtv_blacklisted_emails doctrine.dbal.dtv_blacklisted_emails_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\Newsletter No errors.
App\Entity\ContactList
  • The field App\Entity\ContactList#smsSpotHitCampaigns is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SmsSpotHitCampaign#contactList does not contain the required 'inversedBy="smsSpotHitCampaigns"' attribute.
App\Entity\Setting No errors.
App\Entity\ParameterHook No errors.
App\Entity\Parameter No errors.
App\Entity\User No errors.