Query Metrics

13 Database Queries
10 Different statements
5.92 ms Query time
3 Invalid entities
38 Managed entities

Queries

Group similar statements

# Time Info
1 0.61 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.body AS body_4, t0.is_outstanding AS is_outstanding_5, t0.in_carousel AS in_carousel_6, t0.published_date AS published_date_7, t0.enabled AS enabled_8, t0.carousel_priority AS carousel_priority_9, t0.image AS image_10, t0.updated_at AS updated_at_11, t0.image_carrousel AS image_carrousel_12, t0.image_carrousel_mobile AS image_carrousel_mobile_13 FROM news t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "81"
]
2 0.51 ms
SELECT t0.id AS id_1, t0.vote AS vote_2, t0.text AS text_3, t0.rut AS rut_4, t0.news_id AS news_id_5, t6.id AS id_7, t6.title AS title_8, t6.subtitle AS subtitle_9, t6.body AS body_10, t6.is_outstanding AS is_outstanding_11, t6.in_carousel AS in_carousel_12, t6.published_date AS published_date_13, t6.enabled AS enabled_14, t6.carousel_priority AS carousel_priority_15, t6.image AS image_16, t6.updated_at AS updated_at_17, t6.image_carrousel AS image_carrousel_18, t6.image_carrousel_mobile AS image_carrousel_mobile_19 FROM news_vote t0 LEFT JOIN news t6 ON t0.news_id = t6.id WHERE t0.news_id IN (?)
Parameters:
[
  81
]
3 0.62 ms
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.subtitle AS subtitle_2, n0_.body AS body_3, n0_.is_outstanding AS is_outstanding_4, n0_.in_carousel AS in_carousel_5, n0_.published_date AS published_date_6, n0_.enabled AS enabled_7, n0_.carousel_priority AS carousel_priority_8, n0_.image AS image_9, n0_.updated_at AS updated_at_10, n0_.image_carrousel AS image_carrousel_11, n0_.image_carrousel_mobile AS image_carrousel_mobile_12 FROM news n0_ WHERE n0_.id < ? AND n0_.enabled = 1 LIMIT 1
Parameters:
[
  "81"
]
4 0.48 ms
SELECT t0.id AS id_1, t0.vote AS vote_2, t0.text AS text_3, t0.rut AS rut_4, t0.news_id AS news_id_5, t6.id AS id_7, t6.title AS title_8, t6.subtitle AS subtitle_9, t6.body AS body_10, t6.is_outstanding AS is_outstanding_11, t6.in_carousel AS in_carousel_12, t6.published_date AS published_date_13, t6.enabled AS enabled_14, t6.carousel_priority AS carousel_priority_15, t6.image AS image_16, t6.updated_at AS updated_at_17, t6.image_carrousel AS image_carrousel_18, t6.image_carrousel_mobile AS image_carrousel_mobile_19 FROM news_vote t0 LEFT JOIN news t6 ON t0.news_id = t6.id WHERE t0.news_id IN (?)
Parameters:
[
  7
]
5 0.43 ms
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.subtitle AS subtitle_2, n0_.body AS body_3, n0_.is_outstanding AS is_outstanding_4, n0_.in_carousel AS in_carousel_5, n0_.published_date AS published_date_6, n0_.enabled AS enabled_7, n0_.carousel_priority AS carousel_priority_8, n0_.image AS image_9, n0_.updated_at AS updated_at_10, n0_.image_carrousel AS image_carrousel_11, n0_.image_carrousel_mobile AS image_carrousel_mobile_12 FROM news n0_ WHERE n0_.id > ? AND n0_.enabled = 1 LIMIT 1
Parameters:
[
  "81"
]
6 0.61 ms
SELECT t0.id AS id_1, t0.vote AS vote_2, t0.text AS text_3, t0.rut AS rut_4, t0.news_id AS news_id_5, t6.id AS id_7, t6.title AS title_8, t6.subtitle AS subtitle_9, t6.body AS body_10, t6.is_outstanding AS is_outstanding_11, t6.in_carousel AS in_carousel_12, t6.published_date AS published_date_13, t6.enabled AS enabled_14, t6.carousel_priority AS carousel_priority_15, t6.image AS image_16, t6.updated_at AS updated_at_17, t6.image_carrousel AS image_carrousel_18, t6.image_carrousel_mobile AS image_carrousel_mobile_19 FROM news_vote t0 LEFT JOIN news t6 ON t0.news_id = t6.id WHERE t0.news_id IN (?)
Parameters:
[
  82
]
7 0.41 ms
SELECT t0.id AS id_1, t0.vote AS vote_2, t0.text AS text_3, t0.rut AS rut_4, t0.news_id AS news_id_5, t6.id AS id_7, t6.title AS title_8, t6.subtitle AS subtitle_9, t6.body AS body_10, t6.is_outstanding AS is_outstanding_11, t6.in_carousel AS in_carousel_12, t6.published_date AS published_date_13, t6.enabled AS enabled_14, t6.carousel_priority AS carousel_priority_15, t6.image AS image_16, t6.updated_at AS updated_at_17, t6.image_carrousel AS image_carrousel_18, t6.image_carrousel_mobile AS image_carrousel_mobile_19 FROM news_vote t0 LEFT JOIN news t6 ON t0.news_id = t6.id WHERE t0.news_id = ? AND t0.rut IS NULL LIMIT 1
Parameters:
[
  81
]
8 0.36 ms
SELECT t0.id AS id_1, t0.vote AS vote_2, t0.text AS text_3, t0.rut AS rut_4, t0.news_id AS news_id_5, t6.id AS id_7, t6.title AS title_8, t6.subtitle AS subtitle_9, t6.body AS body_10, t6.is_outstanding AS is_outstanding_11, t6.in_carousel AS in_carousel_12, t6.published_date AS published_date_13, t6.enabled AS enabled_14, t6.carousel_priority AS carousel_priority_15, t6.image AS image_16, t6.updated_at AS updated_at_17, t6.image_carrousel AS image_carrousel_18, t6.image_carrousel_mobile AS image_carrousel_mobile_19 FROM news_vote t0 LEFT JOIN news t6 ON t0.news_id = t6.id WHERE t0.news_id = ? AND t0.vote = ?
Parameters:
[
  81
  1
]
9 0.32 ms
SELECT t0.id AS id_1, t0.vote AS vote_2, t0.text AS text_3, t0.rut AS rut_4, t0.news_id AS news_id_5, t6.id AS id_7, t6.title AS title_8, t6.subtitle AS subtitle_9, t6.body AS body_10, t6.is_outstanding AS is_outstanding_11, t6.in_carousel AS in_carousel_12, t6.published_date AS published_date_13, t6.enabled AS enabled_14, t6.carousel_priority AS carousel_priority_15, t6.image AS image_16, t6.updated_at AS updated_at_17, t6.image_carrousel AS image_carrousel_18, t6.image_carrousel_mobile AS image_carrousel_mobile_19 FROM news_vote t0 LEFT JOIN news t6 ON t0.news_id = t6.id WHERE t0.news_id = ? AND t0.vote = ?
Parameters:
[
  81
  2
]
10 0.55 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.enabled AS enabled_4, t0.image AS image_5, t0.image_main AS image_main_6, t0.updated_at AS updated_at_7, t0.no_burden_enabled AS no_burden_enabled_8, t0.is_fam_partner AS is_fam_partner_9 FROM special_benefits t0 WHERE t0.enabled = ?
Parameters:
[
  1
]
11 0.36 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image_bg AS image_bg_3, t0.updated_at AS updated_at_4, t0.url AS url_5, t0.is_fam_partner AS is_fam_partner_6 FROM services t0
Parameters:
[]
12 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.is_fam_partner AS is_fam_partner_4 FROM mandated_benefit_type t0
Parameters:
[]
13 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3 FROM agreement_type 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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Benefit 11
App\Entity\NewsVote 10
App\Entity\AgreementType 7
App\Entity\Services 4
App\Entity\News 3
App\Entity\MandatedBenefitType 3

Entities Mapping

Class Mapping errors
App\Entity\News No errors.
App\Entity\Banner No errors.
App\Entity\NewsVote No errors.
App\Entity\Benefit No errors.
App\Entity\Services
  • The mappings App\Entity\Services#servicesContents and App\Entity\ServicesContent#service are inconsistent with each other.
App\Entity\ServicesContent
  • The association App\Entity\ServicesContent#service refers to the inverse side field App\Entity\Services#serviceContents which does not exist.
App\Entity\MandatedBenefitType No errors.
App\Entity\MandatedBenefit
  • The field App\Entity\MandatedBenefit#mandatedBenefitFiles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\MandatedBenefitFile#mandatedBenefit does not contain the required 'inversedBy="mandatedBenefitFiles"' attribute.
App\Entity\AgreementType No errors.
App\Entity\Agreement No errors.