Redirect 301 redirect from GET @portailweb_frontend_entiteeconomique_liste (a919e4)

GET https://comorostourism.com/entites-economiques/

Query Metrics

57 Database Queries
10 Different statements
11.15 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.43 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0
Parameters:
[]
2 0.37 ms
SELECT e0_.id AS id_0, e0_.designation AS designation_1, e0_.description AS description_2, e0_.adresse AS adresse_3, e0_.tel AS tel_4, e0_.email AS email_5, e0_.urlsiteweb AS urlsiteweb_6, e0_.is_actif AS is_actif_7, e0_.en_description AS en_description_8 FROM entiteeconomique e0_ WHERE e0_.is_actif = ? ORDER BY e0_.id DESC LIMIT 5
Parameters:
[
  1
]
3 0.74 ms
SELECT count(DISTINCT e0_.id) AS sclr_0 FROM entiteeconomique e0_ LEFT JOIN categorie_entiteeconomique c2_ ON e0_.id = c2_.entiteeconomique_id LEFT JOIN categorie c1_ ON c1_.id = c2_.categorie_id LEFT JOIN entiteeconomique_front_ile e4_ ON e0_.id = e4_.entiteeconomique_id LEFT JOIN front_ile f3_ ON f3_.id = e4_.front_ile_id WHERE e0_.is_actif = ?
Parameters:
[
  1
]
4 0.51 ms
SELECT DISTINCT e0_.id AS id_0, e0_.designation AS designation_1 FROM entiteeconomique e0_ LEFT JOIN categorie_entiteeconomique c2_ ON e0_.id = c2_.entiteeconomique_id LEFT JOIN categorie c1_ ON c1_.id = c2_.categorie_id LEFT JOIN entiteeconomique_front_ile e4_ ON e0_.id = e4_.entiteeconomique_id LEFT JOIN front_ile f3_ ON f3_.id = e4_.front_ile_id WHERE e0_.is_actif = ? ORDER BY e0_.designation ASC LIMIT 12
Parameters:
[
  1
]
5 0.42 ms
SELECT e0_.id AS id_0, e0_.designation AS designation_1, e0_.description AS description_2, e0_.adresse AS adresse_3, e0_.tel AS tel_4, e0_.email AS email_5, e0_.urlsiteweb AS urlsiteweb_6, e0_.is_actif AS is_actif_7, e0_.en_description AS en_description_8 FROM entiteeconomique e0_ LEFT JOIN categorie_entiteeconomique c2_ ON e0_.id = c2_.entiteeconomique_id LEFT JOIN categorie c1_ ON c1_.id = c2_.categorie_id LEFT JOIN entiteeconomique_front_ile e4_ ON e0_.id = e4_.entiteeconomique_id LEFT JOIN front_ile f3_ ON f3_.id = e4_.front_ile_id WHERE e0_.is_actif = ? AND e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY e0_.designation ASC
Parameters:
[
  1
  84
  91
  3
  47
  18
  86
  77
  36
  49
  82
  76
  56
]
6 0.22 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.link AS link_3 FROM front_rubrique t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 0.16 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.link AS link_3 FROM front_rubrique t0 WHERE t0.id = ?
Parameters:
[
  2
]
8 0.16 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.link AS link_3 FROM front_rubrique t0 WHERE t0.id = ?
Parameters:
[
  3
]
9 0.16 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.link AS link_3 FROM front_rubrique t0 WHERE t0.id = ?
Parameters:
[
  4
]
10 0.15 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.link AS link_3 FROM front_rubrique t0 WHERE t0.id = ?
Parameters:
[
  5
]
11 0.22 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.routename AS routename_3, t0.is_inmaintenance AS is_inmaintenance_4, t0.description AS description_5, t0.contenu AS contenu_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.rubrique_id AS rubrique_id_10 FROM front_page t0 WHERE t0.rubrique_id = ?
Parameters:
[
  1
]
12 0.20 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.routename AS routename_3, t0.is_inmaintenance AS is_inmaintenance_4, t0.description AS description_5, t0.contenu AS contenu_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.rubrique_id AS rubrique_id_10 FROM front_page t0 WHERE t0.rubrique_id = ?
Parameters:
[
  2
]
13 0.18 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.routename AS routename_3, t0.is_inmaintenance AS is_inmaintenance_4, t0.description AS description_5, t0.contenu AS contenu_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.rubrique_id AS rubrique_id_10 FROM front_page t0 WHERE t0.rubrique_id = ?
Parameters:
[
  3
]
14 0.17 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.routename AS routename_3, t0.is_inmaintenance AS is_inmaintenance_4, t0.description AS description_5, t0.contenu AS contenu_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.rubrique_id AS rubrique_id_10 FROM front_page t0 WHERE t0.rubrique_id = ?
Parameters:
[
  4
]
15 0.17 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.routename AS routename_3, t0.is_inmaintenance AS is_inmaintenance_4, t0.description AS description_5, t0.contenu AS contenu_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.rubrique_id AS rubrique_id_10 FROM front_page t0 WHERE t0.rubrique_id = ?
Parameters:
[
  5
]
16 0.22 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN categorie_entiteeconomique ON t0.id = categorie_entiteeconomique.categorie_id WHERE categorie_entiteeconomique.entiteeconomique_id = ?
Parameters:
[
  84
]
17 0.18 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN categorie_entiteeconomique ON t0.id = categorie_entiteeconomique.categorie_id WHERE categorie_entiteeconomique.entiteeconomique_id = ?
Parameters:
[
  91
]
18 0.17 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN categorie_entiteeconomique ON t0.id = categorie_entiteeconomique.categorie_id WHERE categorie_entiteeconomique.entiteeconomique_id = ?
Parameters:
[
  3
]
19 0.17 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN categorie_entiteeconomique ON t0.id = categorie_entiteeconomique.categorie_id WHERE categorie_entiteeconomique.entiteeconomique_id = ?
Parameters:
[
  47
]
20 0.17 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN categorie_entiteeconomique ON t0.id = categorie_entiteeconomique.categorie_id WHERE categorie_entiteeconomique.entiteeconomique_id = ?
Parameters:
[
  18
]
21 0.15 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN categorie_entiteeconomique ON t0.id = categorie_entiteeconomique.categorie_id WHERE categorie_entiteeconomique.entiteeconomique_id = ?
Parameters:
[
  86
]
22 0.13 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN categorie_entiteeconomique ON t0.id = categorie_entiteeconomique.categorie_id WHERE categorie_entiteeconomique.entiteeconomique_id = ?
Parameters:
[
  77
]
23 0.14 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN categorie_entiteeconomique ON t0.id = categorie_entiteeconomique.categorie_id WHERE categorie_entiteeconomique.entiteeconomique_id = ?
Parameters:
[
  36
]
24 0.12 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN categorie_entiteeconomique ON t0.id = categorie_entiteeconomique.categorie_id WHERE categorie_entiteeconomique.entiteeconomique_id = ?
Parameters:
[
  49
]
25 0.12 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN categorie_entiteeconomique ON t0.id = categorie_entiteeconomique.categorie_id WHERE categorie_entiteeconomique.entiteeconomique_id = ?
Parameters:
[
  82
]
26 0.14 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN categorie_entiteeconomique ON t0.id = categorie_entiteeconomique.categorie_id WHERE categorie_entiteeconomique.entiteeconomique_id = ?
Parameters:
[
  76
]
27 0.14 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN categorie_entiteeconomique ON t0.id = categorie_entiteeconomique.categorie_id WHERE categorie_entiteeconomique.entiteeconomique_id = ?
Parameters:
[
  56
]
28 0.18 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.updated_at AS updated_at_5 FROM front_ile t0 INNER JOIN entiteeconomique_front_ile ON t0.id = entiteeconomique_front_ile.front_ile_id WHERE entiteeconomique_front_ile.entiteeconomique_id = ?
Parameters:
[
  84
]
29 0.23 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_actif AS is_actif_3, t0.is_thumb AS is_thumb_4, t0.linked_to AS linked_to_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.entiteeconomique_id AS entiteeconomique_id_8 FROM entiteeconomique_image t0 WHERE t0.entiteeconomique_id = ?
Parameters:
[
  99
]
30 0.13 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN categorie_entiteeconomique ON t0.id = categorie_entiteeconomique.categorie_id WHERE categorie_entiteeconomique.entiteeconomique_id = ?
Parameters:
[
  99
]
31 0.12 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_actif AS is_actif_3, t0.is_thumb AS is_thumb_4, t0.linked_to AS linked_to_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.entiteeconomique_id AS entiteeconomique_id_8 FROM entiteeconomique_image t0 WHERE t0.entiteeconomique_id = ?
Parameters:
[
  98
]
32 0.13 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN categorie_entiteeconomique ON t0.id = categorie_entiteeconomique.categorie_id WHERE categorie_entiteeconomique.entiteeconomique_id = ?
Parameters:
[
  98
]
33 0.18 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_actif AS is_actif_3, t0.is_thumb AS is_thumb_4, t0.linked_to AS linked_to_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.entiteeconomique_id AS entiteeconomique_id_8 FROM entiteeconomique_image t0 WHERE t0.entiteeconomique_id = ?
Parameters:
[
  97
]
34 0.32 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN categorie_entiteeconomique ON t0.id = categorie_entiteeconomique.categorie_id WHERE categorie_entiteeconomique.entiteeconomique_id = ?
Parameters:
[
  97
]
35 0.19 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_actif AS is_actif_3, t0.is_thumb AS is_thumb_4, t0.linked_to AS linked_to_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.entiteeconomique_id AS entiteeconomique_id_8 FROM entiteeconomique_image t0 WHERE t0.entiteeconomique_id = ?
Parameters:
[
  84
]
36 0.14 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_actif AS is_actif_3, t0.is_thumb AS is_thumb_4, t0.linked_to AS linked_to_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.entiteeconomique_id AS entiteeconomique_id_8 FROM entiteeconomique_image t0 WHERE t0.entiteeconomique_id = ?
Parameters:
[
  91
]
37 0.17 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_actif AS is_actif_3, t0.is_thumb AS is_thumb_4, t0.linked_to AS linked_to_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.entiteeconomique_id AS entiteeconomique_id_8 FROM entiteeconomique_image t0 WHERE t0.entiteeconomique_id = ?
Parameters:
[
  3
]
38 0.17 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_actif AS is_actif_3, t0.is_thumb AS is_thumb_4, t0.linked_to AS linked_to_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.entiteeconomique_id AS entiteeconomique_id_8 FROM entiteeconomique_image t0 WHERE t0.entiteeconomique_id = ?
Parameters:
[
  47
]
39 0.14 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_actif AS is_actif_3, t0.is_thumb AS is_thumb_4, t0.linked_to AS linked_to_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.entiteeconomique_id AS entiteeconomique_id_8 FROM entiteeconomique_image t0 WHERE t0.entiteeconomique_id = ?
Parameters:
[
  18
]
40 0.16 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_actif AS is_actif_3, t0.is_thumb AS is_thumb_4, t0.linked_to AS linked_to_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.entiteeconomique_id AS entiteeconomique_id_8 FROM entiteeconomique_image t0 WHERE t0.entiteeconomique_id = ?
Parameters:
[
  86
]
41 0.15 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_actif AS is_actif_3, t0.is_thumb AS is_thumb_4, t0.linked_to AS linked_to_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.entiteeconomique_id AS entiteeconomique_id_8 FROM entiteeconomique_image t0 WHERE t0.entiteeconomique_id = ?
Parameters:
[
  77
]
42 0.15 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_actif AS is_actif_3, t0.is_thumb AS is_thumb_4, t0.linked_to AS linked_to_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.entiteeconomique_id AS entiteeconomique_id_8 FROM entiteeconomique_image t0 WHERE t0.entiteeconomique_id = ?
Parameters:
[
  36
]
43 0.15 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_actif AS is_actif_3, t0.is_thumb AS is_thumb_4, t0.linked_to AS linked_to_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.entiteeconomique_id AS entiteeconomique_id_8 FROM entiteeconomique_image t0 WHERE t0.entiteeconomique_id = ?
Parameters:
[
  49
]
44 0.16 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_actif AS is_actif_3, t0.is_thumb AS is_thumb_4, t0.linked_to AS linked_to_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.entiteeconomique_id AS entiteeconomique_id_8 FROM entiteeconomique_image t0 WHERE t0.entiteeconomique_id = ?
Parameters:
[
  82
]
45 0.15 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_actif AS is_actif_3, t0.is_thumb AS is_thumb_4, t0.linked_to AS linked_to_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.entiteeconomique_id AS entiteeconomique_id_8 FROM entiteeconomique_image t0 WHERE t0.entiteeconomique_id = ?
Parameters:
[
  76
]
46 0.14 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_actif AS is_actif_3, t0.is_thumb AS is_thumb_4, t0.linked_to AS linked_to_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.entiteeconomique_id AS entiteeconomique_id_8 FROM entiteeconomique_image t0 WHERE t0.entiteeconomique_id = ?
Parameters:
[
  56
]
47 0.18 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.updated_at AS updated_at_5 FROM front_ile t0 INNER JOIN entiteeconomique_front_ile ON t0.id = entiteeconomique_front_ile.front_ile_id WHERE entiteeconomique_front_ile.entiteeconomique_id = ?
Parameters:
[
  91
]
48 0.16 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.updated_at AS updated_at_5 FROM front_ile t0 INNER JOIN entiteeconomique_front_ile ON t0.id = entiteeconomique_front_ile.front_ile_id WHERE entiteeconomique_front_ile.entiteeconomique_id = ?
Parameters:
[
  3
]
49 0.16 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.updated_at AS updated_at_5 FROM front_ile t0 INNER JOIN entiteeconomique_front_ile ON t0.id = entiteeconomique_front_ile.front_ile_id WHERE entiteeconomique_front_ile.entiteeconomique_id = ?
Parameters:
[
  47
]
50 0.16 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.updated_at AS updated_at_5 FROM front_ile t0 INNER JOIN entiteeconomique_front_ile ON t0.id = entiteeconomique_front_ile.front_ile_id WHERE entiteeconomique_front_ile.entiteeconomique_id = ?
Parameters:
[
  18
]
51 0.16 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.updated_at AS updated_at_5 FROM front_ile t0 INNER JOIN entiteeconomique_front_ile ON t0.id = entiteeconomique_front_ile.front_ile_id WHERE entiteeconomique_front_ile.entiteeconomique_id = ?
Parameters:
[
  86
]
52 0.16 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.updated_at AS updated_at_5 FROM front_ile t0 INNER JOIN entiteeconomique_front_ile ON t0.id = entiteeconomique_front_ile.front_ile_id WHERE entiteeconomique_front_ile.entiteeconomique_id = ?
Parameters:
[
  77
]
53 0.17 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.updated_at AS updated_at_5 FROM front_ile t0 INNER JOIN entiteeconomique_front_ile ON t0.id = entiteeconomique_front_ile.front_ile_id WHERE entiteeconomique_front_ile.entiteeconomique_id = ?
Parameters:
[
  36
]
54 0.17 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.updated_at AS updated_at_5 FROM front_ile t0 INNER JOIN entiteeconomique_front_ile ON t0.id = entiteeconomique_front_ile.front_ile_id WHERE entiteeconomique_front_ile.entiteeconomique_id = ?
Parameters:
[
  49
]
55 0.16 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.updated_at AS updated_at_5 FROM front_ile t0 INNER JOIN entiteeconomique_front_ile ON t0.id = entiteeconomique_front_ile.front_ile_id WHERE entiteeconomique_front_ile.entiteeconomique_id = ?
Parameters:
[
  82
]
56 0.16 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.updated_at AS updated_at_5 FROM front_ile t0 INNER JOIN entiteeconomique_front_ile ON t0.id = entiteeconomique_front_ile.front_ile_id WHERE entiteeconomique_front_ile.entiteeconomique_id = ?
Parameters:
[
  76
]
57 0.17 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.updated_at AS updated_at_5 FROM front_ile t0 INNER JOIN entiteeconomique_front_ile ON t0.id = entiteeconomique_front_ile.front_ile_id WHERE entiteeconomique_front_ile.entiteeconomique_id = ?
Parameters:
[
  56
]

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.