https://dev.zinvaziv.seyes.dev/

Query Metrics

3 Database Queries
3 Different statements
0.84 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.31 ms
(36.81%)
1
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.content AS content_2, n0_.slug AS slug_3, n0_.external_link AS external_link_4, n0_.is_published AS is_published_5, n0_.created_at AS created_at_6, n0_.updated_at AS updated_at_7, n0_.user_id AS user_id_8 FROM news n0_ WHERE n0_.is_published = ? ORDER BY n0_.created_at DESC LIMIT 3
Parameters:
[
  1
]
0.30 ms
(35.84%)
1
SELECT d0_.id AS id_0, d0_.status AS status_1, d0_.description AS description_2, d0_.step AS step_3, d0_.latitude AS latitude_4, d0_.longitude AS longitude_5, d0_.comment AS comment_6, d0_.company_rating AS company_rating_7, d0_.tree_category AS tree_category_8, d0_.number_tree AS number_tree_9, d0_.is_comment_published AS is_comment_published_10, d0_.created_at AS created_at_11, d0_.updated_at AS updated_at_12, d0_.user_id AS user_id_13, d0_.demand_information_id AS demand_information_id_14, d0_.tree_id AS tree_id_15 FROM demand d0_ LEFT JOIN demand_status d1_ ON d0_.id = d1_.demand_id WHERE d0_.comment IS NOT NULL AND d0_.is_comment_published = ? AND d1_.status = ? ORDER BY d1_.created_at DESC LIMIT 6
Parameters:
[
  1
  7
]
0.23 ms
(27.35%)
1
SELECT t0.id AS id_1, t0.status AS status_2, t0.description AS description_3, t0.step AS step_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.comment AS comment_7, t0.company_rating AS company_rating_8, t0.tree_category AS tree_category_9, t0.number_tree AS number_tree_10, t0.is_comment_published AS is_comment_published_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.user_id AS user_id_14, t0.demand_information_id AS demand_information_id_15, t0.tree_id AS tree_id_16 FROM demand 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.

Entities Mapping

Class Mapping errors
App\Entity\Article No errors.
App\Entity\News No errors.
App\Entity\Demand No errors.
App\Entity\User No errors.
App\Entity\DemandStatus No errors.
App\Entity\DemandInformation No errors.
App\Entity\Tree No errors.
App\Entity\DemandComment No errors.
App\Entity\DemandFile No errors.
App\Entity\CompanyDemand No errors.
App\Entity\DemandTree No errors.