Query Metrics
17
Database Queries
4.71 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.35 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: ['14']
|
| 2 | 0.32 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: [14]
|
| 3 | 0.25 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: [14]
|
| 4 | 0.26 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: [14]
|
| 5 | 0.23 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: [85]
|
| 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: [86]
|
| 7 | 0.25 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: [87]
|
| 8 | 0.26 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: [88]
|
| 9 | 0.23 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: [89]
|
| 10 | 0.30 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: [90]
|
| 11 | 0.23 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: [91]
|
| 12 | 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: [92]
|
| 13 | 0.28 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: { }
|
| 14 | 0.25 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: [14]
|
| 15 | 0.46 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: [['85', '86', '87', '88', '89', '90', '91', '92']]
|
| 16 | 0.25 ms |
SELECT count(a0_.id) AS sclr_0 FROM annonce a0_ WHERE a0_.category IN (?) AND a0_.gdpr = 1
Parameters: [['85', '86', '87', '88', '89', '90', '91', '92']]
|
| 17 | 0.35 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. |