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

Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
4.89 ms
(70.38%)
7
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"
]
1.25 ms
(17.92%)
1
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
]
0.81 ms
(11.71%)
1
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"
]

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.