Query Metrics
3
Database Queries
3
Different statements
1.25 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.44 ms |
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
]
|
| 2 | 0.45 ms |
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 ] |
| 3 | 0.36 ms |
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. |