Query Metrics
9
Database Queries
3.40 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.69 ms |
SELECT t0.title AS title_1, t0.parent AS parent_2, t0.corder AS corder_3, t0.id AS id_4, t0.icon AS icon_5 FROM category t0 WHERE t0.id = ?
Parameters: ['49']
|
| 2 | 0.27 ms |
SELECT t0.title AS title_1, t0.parent AS parent_2, t0.corder AS corder_3, t0.id AS id_4, t0.icon AS icon_5 FROM category t0 WHERE t0.id = ? LIMIT 1
Parameters: [7]
|
| 3 | 0.33 ms |
SELECT t0.title AS title_1, t0.parent AS parent_2, t0.corder AS corder_3, t0.id AS id_4, t0.icon AS icon_5 FROM category t0 WHERE t0.parent = ? ORDER BY t0.corder ASC
Parameters: [49]
|
| 4 | 0.22 ms |
SELECT t0.title AS title_1, t0.parent AS parent_2, t0.corder AS corder_3, t0.id AS id_4, t0.icon AS icon_5 FROM category t0 WHERE t0.parent = ? ORDER BY t0.corder ASC
Parameters: [49]
|
| 5 | 0.31 ms |
SELECT t0.title AS title_1, t0.parent AS parent_2, t0.corder AS corder_3, t0.id AS id_4, t0.icon AS icon_5 FROM category t0 WHERE t0.parent IS NULL ORDER BY t0.corder ASC
Parameters: { }
|
| 6 | 0.22 ms |
SELECT t0.title AS title_1, t0.parent AS parent_2, t0.corder AS corder_3, t0.id AS id_4, t0.icon AS icon_5 FROM category t0 WHERE t0.parent = ? ORDER BY t0.corder ASC
Parameters: [49]
|
| 7 | 0.53 ms |
SELECT a0_.title AS title_0, a0_.content AS content_1, a0_.category AS category_2, a0_.tags AS tags_3, a0_.price AS price_4, a0_.email AS email_5, a0_.first_name AS first_name_6, a0_.last_name AS last_name_7, a0_.tel AS tel_8, a0_.zip AS zip_9, a0_.city AS city_10, a0_.street AS street_11, a0_.created AS created_12, a0_.top AS top_13, a0_.gdpr AS gdpr_14, a0_.gdpr_date AS gdpr_date_15, a0_.extern_url AS extern_url_16, a0_.mobil AS mobil_17, a0_.remote AS remote_18, a0_.extern_source AS extern_source_19, a0_.extern_id AS extern_id_20, a0_.locality AS locality_21, a0_.user AS user_22, a0_.id AS id_23, a0_.views AS views_24 FROM annonce a0_ WHERE a0_.category IN (?) AND a0_.gdpr = 1 ORDER BY a0_.top DESC LIMIT 9 OFFSET 0
Parameters: [[49]]
|
| 8 | 0.24 ms |
SELECT count(a0_.id) AS sclr_0 FROM annonce a0_ WHERE a0_.category IN (?) AND a0_.gdpr = 1
Parameters: [[49]]
|
| 9 | 0.59 ms |
SELECT t0.username AS username_1, t0.password AS password_2, t0.firts_name AS firts_name_3, t0.last_name AS last_name_4, t0.tel AS tel_5, t0.zip AS zip_6, t0.city AS city_7, t0.street AS street_8, t0.email AS email_9, t0.roles AS roles_10, t0.mobil AS mobil_11, t0.id AS id_12 FROM user t0 WHERE t0.username = ? LIMIT 1
Parameters: [anon.]
|
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 |
|---|---|
| AppBundle\Entity\Category | No errors. |
| AppBundle\Entity\Annonce | No errors. |
| AppBundle\Entity\User | No errors. |