GET https://bienestar-web-desarrollo.kuantum.cl/news/124

Query Metrics

13 Database Queries
10 Different statements
8.74 ms Query time
6 Invalid entities
35 Managed entities

Queries

Group similar statements

# Time Info
1 0.88 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:
[
  "124"
]
2 0.74 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:
[
  124
]
3 0.90 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:
[
  "124"
]
4 0.63 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.67 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:
[
  "124"
]
6 0.58 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:
[
  125
]
7 0.50 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:
[
  124
]
8 0.57 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:
[
  124
  1
]
9 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 = ? AND t0.vote = ?
Parameters:
[
  124
  2
]
10 0.90 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.76 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.60 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.50 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 7
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.
App\Entity\MandatedBenefitFile No errors.
App\Entity\Commission No errors.
App\Entity\Tutorial
  • The field App\Entity\Tutorial#tutorialFiles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TutorialFile#tutorial does not contain the required 'inversedBy="tutorialFiles"' attribute.
App\Entity\Ticket No errors.
App\Entity\AnsweredPoll
  • The association App\Entity\AnsweredPoll#poll refers to the inverse side field App\Entity\Poll#answered_polls which does not exist.
App\Entity\Family No errors.
App\Entity\Poll
  • The mappings App\Entity\Poll#answeredPolls and App\Entity\AnsweredPoll#poll are inconsistent with each other.
App\Entity\SectionText No errors.
App\Entity\Answer No errors.
App\Entity\Directorate No errors.
App\Entity\ConfigurationNoFamPartner No errors.
App\Entity\TutorialFile No errors.
App\Entity\Configuration No errors.
App\Entity\WebContent No errors.
App\Entity\PossibleAnswer No errors.
App\Entity\Guide No errors.
App\Entity\NoBurdenTopic No errors.
App\Entity\Group No errors.
App\Entity\WebContentRefund No errors.
App\Entity\Question No errors.
App\Entity\ApiToken No errors.
App\Entity\AppFormMenu No errors.
App\Entity\QuestionGroup No errors.
App\Entity\DentalAgreement No errors.
App\Entity\Forms No errors.
App\Entity\AppMenuButton No errors.
Sonata\UserBundle\Entity\BaseUser No errors.
App\Entity\User No errors.
App\Entity\WorkTeam No errors.
Sonata\UserBundle\Entity\BaseUser3 No errors.
Vich\UploaderBundle\Entity\File No errors.