Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.94 ms Query time

0 Invalid entities

82 Managed entities

29 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

#▲	Time	Info
1	0.94 ms	SELECT s0_.id AS id_0, s0_.enabled AS enabled_1, s0_.name AS name_2, s0_.description AS description_3, s0_.domain AS domain_4, s0_.sorting AS sorting_5, s0_.lastModified AS lastModified_6, s0_.headerFilename AS headerFilename_7, s0_.logo AS logo_8, s0_.icon AS icon_9, s0_.trailerFilename AS trailerFilename_10 FROM Satellite s0_ WHERE s0_.name = ? AND s0_.enabled = ? ORDER BY s0_.id ASC Parameters: [`"adultoriginals" "1"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.enabled AS enabled_1, s0_.name AS name_2, s0_.description AS description_3, s0_.domain AS domain_4, s0_.sorting AS sorting_5, s0_.lastModified AS lastModified_6, s0_.headerFilename AS headerFilename_7, s0_.logo AS logo_8, s0_.icon AS icon_9, s0_.trailerFilename AS trailerFilename_10 FROM Satellite s0_ WHERE s0_.name = ? AND s0_.enabled = ? ORDER BY s0_.id ASC SELECT s0_.id AS id_0, s0_.enabled AS enabled_1, s0_.name AS name_2, s0_.description AS description_3, s0_.domain AS domain_4, s0_.sorting AS sorting_5, s0_.lastModified AS lastModified_6, s0_.headerFilename AS headerFilename_7, s0_.logo AS logo_8, s0_.icon AS icon_9, s0_.trailerFilename AS trailerFilename_10 FROM Satellite s0_ WHERE s0_.name = 'adultoriginals' AND s0_.enabled = '1' ORDER BY s0_.id ASC;

#▲

Time

Info

0.94 ms

SELECT s0_.id AS id_0, s0_.enabled AS enabled_1, s0_.name AS name_2, s0_.description AS description_3, s0_.domain AS domain_4, s0_.sorting AS sorting_5, s0_.lastModified AS lastModified_6, s0_.headerFilename AS headerFilename_7, s0_.logo AS logo_8, s0_.icon AS icon_9, s0_.trailerFilename AS trailerFilename_10 FROM Satellite s0_ WHERE s0_.name = ? AND s0_.enabled = ? ORDER BY s0_.id ASC

Parameters:

[
  "adultoriginals"
  "1"
]

View formatted query View runnable query Explain query

SELECT
  s0_.id AS id_0,
  s0_.enabled AS enabled_1,
  s0_.name AS name_2,
  s0_.description AS description_3,
  s0_.domain AS domain_4,
  s0_.sorting AS sorting_5,
  s0_.lastModified AS lastModified_6,
  s0_.headerFilename AS headerFilename_7,
  s0_.logo AS logo_8,
  s0_.icon AS icon_9,
  s0_.trailerFilename AS trailerFilename_10
FROM
  Satellite s0_
WHERE
  s0_.name = ?
  AND s0_.enabled = ?
ORDER BY
  s0_.id ASC

SELECT s0_.id AS id_0, s0_.enabled AS enabled_1, s0_.name AS name_2, s0_.description AS description_3, s0_.domain AS domain_4, s0_.sorting AS sorting_5, s0_.lastModified AS lastModified_6, s0_.headerFilename AS headerFilename_7, s0_.logo AS logo_8, s0_.icon AS icon_9, s0_.trailerFilename AS trailerFilename_10 FROM Satellite s0_ WHERE s0_.name = 'adultoriginals' AND s0_.enabled = '1' ORDER BY s0_.id ASC;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

29 Hits

0 Misses

0 Puts

Number of cache hits

Region	Hits
cache_shop_video	29

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\SatelliteContent	48
App\Entity\ShopVideo	24
App\Entity\Satellite	6
App\Entity\Series	4

Entities Mapping

Class	Mapping errors
App\Entity\Satellite	No errors.
App\Entity\ShopVideo	No errors.
App\Entity\SatelliteContent	No errors.
App\Entity\Tag	No errors.
App\Entity\PaymentPackage	No errors.
App\Entity\Favorite	No errors.
App\Entity\Performer	No errors.
App\Entity\InternalTag	No errors.
App\Entity\Language	No errors.
App\Entity\ShopVideoBid	No errors.
Netperv\UploadsBundle\Entity\FileEntity	No errors.
App\Entity\ShopVideoFile	No errors.
App\Entity\Series	No errors.