GET https://intg.admin.musicdb.cnm.fr/contacts/recherche-avancee?filters%5Bgender%5D=&filters%5Bname%5D=&filters%5Bfirst_name%5D=&filters%5Bemail_perso%5D=&filters%…

Response
200 OK
Browse referrer URL
IP
212.106.109.70
Profiled on
Token
cc906a

Query Metrics

16 Database Queries
7 Different statements
71.24 ms Query time
0 Invalid entities
1793 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.36 ms 
SELECT t0.id AS id_1, t0.irmawork_id AS irmawork_id_2, t0.username AS username_3, t0.slug AS slug_4, t0.last_name AS last_name_5, t0.first_name AS first_name_6, t0.email AS email_7, t0.password AS password_8, t0.avatar AS avatar_9, t0.reset_password AS reset_password_10, t0.salt AS salt_11, t0.roles AS roles_12, t0.is_enabled AS is_enabled_13, t0.token AS token_14, t0.date_updated AS date_updated_15 FROM app_administrator t0 WHERE t0.id = ?
Parameters: 
[
  55
]
View formatted query    View runnable query    Explain query
2 0.21 ms 
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.service AS service_4, t0.url AS url_5, t0.last_update AS last_update_6 FROM app_api t0 WHERE t0.name = ? LIMIT 1
Parameters: 
[
  "Pays"
]
View formatted query    View runnable query    Explain query
3 0.37 ms 
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.service AS service_4, t0.url AS url_5, t0.last_update AS last_update_6 FROM app_api t0 WHERE t0.name = ? LIMIT 1
Parameters: 
[
  "Départements"
]
View formatted query    View runnable query    Explain query
4 0.26 ms 
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.service AS service_4, t0.url AS url_5, t0.last_update AS last_update_6 FROM app_api t0 WHERE t0.name = ? LIMIT 1
Parameters: 
[
  "Régions"
]
View formatted query    View runnable query    Explain query
5 11.63 ms 
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.name AS name_2, a0_.type AS type_3, a0_.has_auto_positions AS has_auto_positions_4, a0_.has_last_level AS has_last_level_5, a1_.id AS id_6, a1_.id_cnm AS id_cnm_7, a1_.reference4d AS reference4d_8, a1_.external_code AS external_code_9, a1_.slug AS slug_10, a1_.name AS name_11, a1_.name_en AS name_en_12, a1_.name_feminine AS name_feminine_13, a1_.name_reversed AS name_reversed_14, a1_.description AS description_15, a1_.criteria AS criteria_16, a1_.organization AS organization_17, a1_.position AS position_18, a1_.published AS published_19, a2_.id AS id_20, a2_.id_cnm AS id_cnm_21, a2_.reference4d AS reference4d_22, a2_.external_code AS external_code_23, a2_.slug AS slug_24, a2_.name AS name_25, a2_.name_en AS name_en_26, a2_.name_feminine AS name_feminine_27, a2_.name_reversed AS name_reversed_28, a2_.description AS description_29, a2_.criteria AS criteria_30, a2_.organization AS organization_31, a2_.position AS position_32, a2_.published AS published_33, a1_.thesaurus_id AS thesaurus_id_34, a1_.parent AS parent_35, a2_.thesaurus_id AS thesaurus_id_36, a2_.parent AS parent_37 FROM app_thesaurus a0_ LEFT JOIN app_tag a1_ ON a0_.id = a1_.thesaurus_id LEFT JOIN app_tag a2_ ON a1_.parent = a2_.id WHERE a0_.id = ? ORDER BY a1_.name ASC, a1_.position ASC
Parameters: 
[
  104
]
View formatted query    View runnable query    Explain query
6 35.37 ms 
SELECT a0_.id AS id_0, a0_.id_cnm AS id_cnm_1, a0_.reference4d AS reference4d_2, a0_.external_code AS external_code_3, a0_.slug AS slug_4, a0_.name AS name_5, a0_.name_en AS name_en_6, a0_.name_feminine AS name_feminine_7, a0_.name_reversed AS name_reversed_8, a0_.description AS description_9, a0_.criteria AS criteria_10, a0_.organization AS organization_11, a0_.position AS position_12, a0_.published AS published_13, a1_.id AS id_14, a1_.id_cnm AS id_cnm_15, a1_.reference4d AS reference4d_16, a1_.external_code AS external_code_17, a1_.slug AS slug_18, a1_.name AS name_19, a1_.name_en AS name_en_20, a1_.name_feminine AS name_feminine_21, a1_.name_reversed AS name_reversed_22, a1_.description AS description_23, a1_.criteria AS criteria_24, a1_.organization AS organization_25, a1_.position AS position_26, a1_.published AS published_27, a2_.id AS id_28, a2_.id_cnm AS id_cnm_29, a2_.reference4d AS reference4d_30, a2_.external_code AS external_code_31, a2_.slug AS slug_32, a2_.name AS name_33, a2_.name_en AS name_en_34, a2_.name_feminine AS name_feminine_35, a2_.name_reversed AS name_reversed_36, a2_.description AS description_37, a2_.criteria AS criteria_38, a2_.organization AS organization_39, a2_.position AS position_40, a2_.published AS published_41, a0_.thesaurus_id AS thesaurus_id_42, a0_.parent AS parent_43, a1_.thesaurus_id AS thesaurus_id_44, a1_.parent AS parent_45, a2_.thesaurus_id AS thesaurus_id_46, a2_.parent AS parent_47 FROM app_tag a0_ LEFT JOIN app_tag a1_ ON a0_.parent = a1_.id LEFT JOIN app_tag a2_ ON a0_.id = a2_.parent WHERE a0_.thesaurus_id = ? ORDER BY a2_.position ASC
Parameters: 
[
  104
]
View formatted query    View runnable query    Explain query
7 1.65 ms 
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.name AS name_2, a0_.type AS type_3, a0_.has_auto_positions AS has_auto_positions_4, a0_.has_last_level AS has_last_level_5, a1_.id AS id_6, a1_.id_cnm AS id_cnm_7, a1_.reference4d AS reference4d_8, a1_.external_code AS external_code_9, a1_.slug AS slug_10, a1_.name AS name_11, a1_.name_en AS name_en_12, a1_.name_feminine AS name_feminine_13, a1_.name_reversed AS name_reversed_14, a1_.description AS description_15, a1_.criteria AS criteria_16, a1_.organization AS organization_17, a1_.position AS position_18, a1_.published AS published_19, a2_.id AS id_20, a2_.id_cnm AS id_cnm_21, a2_.reference4d AS reference4d_22, a2_.external_code AS external_code_23, a2_.slug AS slug_24, a2_.name AS name_25, a2_.name_en AS name_en_26, a2_.name_feminine AS name_feminine_27, a2_.name_reversed AS name_reversed_28, a2_.description AS description_29, a2_.criteria AS criteria_30, a2_.organization AS organization_31, a2_.position AS position_32, a2_.published AS published_33, a1_.thesaurus_id AS thesaurus_id_34, a1_.parent AS parent_35, a2_.thesaurus_id AS thesaurus_id_36, a2_.parent AS parent_37 FROM app_thesaurus a0_ LEFT JOIN app_tag a1_ ON a0_.id = a1_.thesaurus_id LEFT JOIN app_tag a2_ ON a1_.parent = a2_.id WHERE a0_.id = ? ORDER BY a1_.name ASC, a1_.position ASC
Parameters: 
[
  105
]
View formatted query    View runnable query    Explain query
8 2.29 ms 
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.name AS name_2, a0_.type AS type_3, a0_.has_auto_positions AS has_auto_positions_4, a0_.has_last_level AS has_last_level_5, a1_.id AS id_6, a1_.id_cnm AS id_cnm_7, a1_.reference4d AS reference4d_8, a1_.external_code AS external_code_9, a1_.slug AS slug_10, a1_.name AS name_11, a1_.name_en AS name_en_12, a1_.name_feminine AS name_feminine_13, a1_.name_reversed AS name_reversed_14, a1_.description AS description_15, a1_.criteria AS criteria_16, a1_.organization AS organization_17, a1_.position AS position_18, a1_.published AS published_19, a2_.id AS id_20, a2_.id_cnm AS id_cnm_21, a2_.reference4d AS reference4d_22, a2_.external_code AS external_code_23, a2_.slug AS slug_24, a2_.name AS name_25, a2_.name_en AS name_en_26, a2_.name_feminine AS name_feminine_27, a2_.name_reversed AS name_reversed_28, a2_.description AS description_29, a2_.criteria AS criteria_30, a2_.organization AS organization_31, a2_.position AS position_32, a2_.published AS published_33, a1_.thesaurus_id AS thesaurus_id_34, a1_.parent AS parent_35, a2_.thesaurus_id AS thesaurus_id_36, a2_.parent AS parent_37 FROM app_thesaurus a0_ LEFT JOIN app_tag a1_ ON a0_.id = a1_.thesaurus_id LEFT JOIN app_tag a2_ ON a1_.parent = a2_.id WHERE a0_.id = ? ORDER BY a1_.name ASC, a1_.position ASC
Parameters: 
[
  139
]
View formatted query    View runnable query    Explain query
9 3.60 ms 
SELECT a0_.id AS id_0, a0_.id_cnm AS id_cnm_1, a0_.reference4d AS reference4d_2, a0_.external_code AS external_code_3, a0_.slug AS slug_4, a0_.name AS name_5, a0_.name_en AS name_en_6, a0_.name_feminine AS name_feminine_7, a0_.name_reversed AS name_reversed_8, a0_.description AS description_9, a0_.criteria AS criteria_10, a0_.organization AS organization_11, a0_.position AS position_12, a0_.published AS published_13, a1_.id AS id_14, a1_.id_cnm AS id_cnm_15, a1_.reference4d AS reference4d_16, a1_.external_code AS external_code_17, a1_.slug AS slug_18, a1_.name AS name_19, a1_.name_en AS name_en_20, a1_.name_feminine AS name_feminine_21, a1_.name_reversed AS name_reversed_22, a1_.description AS description_23, a1_.criteria AS criteria_24, a1_.organization AS organization_25, a1_.position AS position_26, a1_.published AS published_27, a2_.id AS id_28, a2_.id_cnm AS id_cnm_29, a2_.reference4d AS reference4d_30, a2_.external_code AS external_code_31, a2_.slug AS slug_32, a2_.name AS name_33, a2_.name_en AS name_en_34, a2_.name_feminine AS name_feminine_35, a2_.name_reversed AS name_reversed_36, a2_.description AS description_37, a2_.criteria AS criteria_38, a2_.organization AS organization_39, a2_.position AS position_40, a2_.published AS published_41, a0_.thesaurus_id AS thesaurus_id_42, a0_.parent AS parent_43, a1_.thesaurus_id AS thesaurus_id_44, a1_.parent AS parent_45, a2_.thesaurus_id AS thesaurus_id_46, a2_.parent AS parent_47 FROM app_tag a0_ LEFT JOIN app_tag a1_ ON a0_.parent = a1_.id LEFT JOIN app_tag a2_ ON a0_.id = a2_.parent WHERE a0_.thesaurus_id = ? ORDER BY a2_.position ASC
Parameters: 
[
  139
]
View formatted query    View runnable query    Explain query
10 0.19 ms 
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.name AS name_2, a0_.type AS type_3, a0_.has_auto_positions AS has_auto_positions_4, a0_.has_last_level AS has_last_level_5, a1_.id AS id_6, a1_.id_cnm AS id_cnm_7, a1_.reference4d AS reference4d_8, a1_.external_code AS external_code_9, a1_.slug AS slug_10, a1_.name AS name_11, a1_.name_en AS name_en_12, a1_.name_feminine AS name_feminine_13, a1_.name_reversed AS name_reversed_14, a1_.description AS description_15, a1_.criteria AS criteria_16, a1_.organization AS organization_17, a1_.position AS position_18, a1_.published AS published_19, a2_.id AS id_20, a2_.id_cnm AS id_cnm_21, a2_.reference4d AS reference4d_22, a2_.external_code AS external_code_23, a2_.slug AS slug_24, a2_.name AS name_25, a2_.name_en AS name_en_26, a2_.name_feminine AS name_feminine_27, a2_.name_reversed AS name_reversed_28, a2_.description AS description_29, a2_.criteria AS criteria_30, a2_.organization AS organization_31, a2_.position AS position_32, a2_.published AS published_33, a1_.thesaurus_id AS thesaurus_id_34, a1_.parent AS parent_35, a2_.thesaurus_id AS thesaurus_id_36, a2_.parent AS parent_37 FROM app_thesaurus a0_ LEFT JOIN app_tag a1_ ON a0_.id = a1_.thesaurus_id LEFT JOIN app_tag a2_ ON a1_.parent = a2_.id WHERE a0_.id = ? ORDER BY a1_.name ASC, a1_.position ASC
Parameters: 
[
  139
]
View formatted query    View runnable query    Explain query
11 0.17 ms 
SELECT a0_.id AS id_0, a0_.id_cnm AS id_cnm_1, a0_.reference4d AS reference4d_2, a0_.external_code AS external_code_3, a0_.slug AS slug_4, a0_.name AS name_5, a0_.name_en AS name_en_6, a0_.name_feminine AS name_feminine_7, a0_.name_reversed AS name_reversed_8, a0_.description AS description_9, a0_.criteria AS criteria_10, a0_.organization AS organization_11, a0_.position AS position_12, a0_.published AS published_13, a1_.id AS id_14, a1_.id_cnm AS id_cnm_15, a1_.reference4d AS reference4d_16, a1_.external_code AS external_code_17, a1_.slug AS slug_18, a1_.name AS name_19, a1_.name_en AS name_en_20, a1_.name_feminine AS name_feminine_21, a1_.name_reversed AS name_reversed_22, a1_.description AS description_23, a1_.criteria AS criteria_24, a1_.organization AS organization_25, a1_.position AS position_26, a1_.published AS published_27, a2_.id AS id_28, a2_.id_cnm AS id_cnm_29, a2_.reference4d AS reference4d_30, a2_.external_code AS external_code_31, a2_.slug AS slug_32, a2_.name AS name_33, a2_.name_en AS name_en_34, a2_.name_feminine AS name_feminine_35, a2_.name_reversed AS name_reversed_36, a2_.description AS description_37, a2_.criteria AS criteria_38, a2_.organization AS organization_39, a2_.position AS position_40, a2_.published AS published_41, a0_.thesaurus_id AS thesaurus_id_42, a0_.parent AS parent_43, a1_.thesaurus_id AS thesaurus_id_44, a1_.parent AS parent_45, a2_.thesaurus_id AS thesaurus_id_46, a2_.parent AS parent_47 FROM app_tag a0_ LEFT JOIN app_tag a1_ ON a0_.parent = a1_.id LEFT JOIN app_tag a2_ ON a0_.id = a2_.parent WHERE a0_.thesaurus_id = ? ORDER BY a2_.position ASC
Parameters: 
[
  139
]
View formatted query    View runnable query    Explain query
12 0.79 ms 
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.name AS name_2, a0_.type AS type_3, a0_.has_auto_positions AS has_auto_positions_4, a0_.has_last_level AS has_last_level_5, a1_.id AS id_6, a1_.id_cnm AS id_cnm_7, a1_.reference4d AS reference4d_8, a1_.external_code AS external_code_9, a1_.slug AS slug_10, a1_.name AS name_11, a1_.name_en AS name_en_12, a1_.name_feminine AS name_feminine_13, a1_.name_reversed AS name_reversed_14, a1_.description AS description_15, a1_.criteria AS criteria_16, a1_.organization AS organization_17, a1_.position AS position_18, a1_.published AS published_19, a2_.id AS id_20, a2_.id_cnm AS id_cnm_21, a2_.reference4d AS reference4d_22, a2_.external_code AS external_code_23, a2_.slug AS slug_24, a2_.name AS name_25, a2_.name_en AS name_en_26, a2_.name_feminine AS name_feminine_27, a2_.name_reversed AS name_reversed_28, a2_.description AS description_29, a2_.criteria AS criteria_30, a2_.organization AS organization_31, a2_.position AS position_32, a2_.published AS published_33, a1_.thesaurus_id AS thesaurus_id_34, a1_.parent AS parent_35, a2_.thesaurus_id AS thesaurus_id_36, a2_.parent AS parent_37 FROM app_thesaurus a0_ LEFT JOIN app_tag a1_ ON a0_.id = a1_.thesaurus_id LEFT JOIN app_tag a2_ ON a1_.parent = a2_.id WHERE a0_.id = ? ORDER BY a1_.name ASC, a1_.position ASC
Parameters: 
[
  131
]
View formatted query    View runnable query    Explain query
13 0.83 ms 
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.name AS name_2, a0_.type AS type_3, a0_.has_auto_positions AS has_auto_positions_4, a0_.has_last_level AS has_last_level_5, a1_.id AS id_6, a1_.id_cnm AS id_cnm_7, a1_.reference4d AS reference4d_8, a1_.external_code AS external_code_9, a1_.slug AS slug_10, a1_.name AS name_11, a1_.name_en AS name_en_12, a1_.name_feminine AS name_feminine_13, a1_.name_reversed AS name_reversed_14, a1_.description AS description_15, a1_.criteria AS criteria_16, a1_.organization AS organization_17, a1_.position AS position_18, a1_.published AS published_19, a2_.id AS id_20, a2_.id_cnm AS id_cnm_21, a2_.reference4d AS reference4d_22, a2_.external_code AS external_code_23, a2_.slug AS slug_24, a2_.name AS name_25, a2_.name_en AS name_en_26, a2_.name_feminine AS name_feminine_27, a2_.name_reversed AS name_reversed_28, a2_.description AS description_29, a2_.criteria AS criteria_30, a2_.organization AS organization_31, a2_.position AS position_32, a2_.published AS published_33, a1_.thesaurus_id AS thesaurus_id_34, a1_.parent AS parent_35, a2_.thesaurus_id AS thesaurus_id_36, a2_.parent AS parent_37 FROM app_thesaurus a0_ LEFT JOIN app_tag a1_ ON a0_.id = a1_.thesaurus_id LEFT JOIN app_tag a2_ ON a1_.parent = a2_.id WHERE a0_.id = ? ORDER BY a1_.name ASC, a1_.position ASC
Parameters: 
[
  132
]
View formatted query    View runnable query    Explain query
14 12.89 ms 
SELECT COUNT(*) FROM app_task t0 WHERE t0.status IN (?, ?)
Parameters: 
[
  "new"
  "running"
]
View formatted query    View runnable query    Explain query
15 0.23 ms 
SELECT COUNT(*) FROM app_suggestion t0 WHERE t0.status IN (?)
Parameters: 
[
  "new"
]
View formatted query    View runnable query    Explain query
16 0.41 ms 
SELECT COUNT(*) FROM app_api_update t0
Parameters: 
[]
View formatted query    View runnable query    Explain query

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Tag 1784
App\Entity\Thesaurus 5
App\Entity\Api 3
App\Entity\Administrator 1

Entities Mapping

Class Mapping errors
App\Entity\Administrator No errors.
App\Entity\History No errors.
App\Entity\Task No errors.
App\Entity\SupraSuggestion No errors.
App\Entity\Service No errors.
App\Entity\Api No errors.
App\Entity\Thesaurus No errors.
App\Entity\Tag No errors.
App\Entity\MetaTagSetting No errors.
App\Entity\Meta No errors.
App\Entity\Value No errors.
App\Entity\Item No errors.
App\Entity\MetaTagValue No errors.
App\Entity\RelationLabel No errors.
App\Entity\Info No errors.
App\Entity\Licence No errors.
App\Entity\Relation No errors.
App\Entity\Suggestion No errors.
App\Entity\ApiUpdate No errors.
App\Entity\Organization No errors.
App\Entity\User No errors.
App\Entity\MailSib No errors.
App\Entity\Referent No errors.
App\Entity\Place No errors.
App\Entity\Activity No errors.
App\Entity\Artist No errors.
App\Entity\Event No errors.
App\Entity\Person No errors.
App\Entity\Structure No errors.
App\Entity\Union No errors.
App\Entity\Certification No errors.
App\Entity\Email No errors.
App\Entity\Link No errors.
App\Entity\Address No errors.
App\Entity\Phone No errors.
App\Entity\MailCampaign No errors.
App\Entity\Town No errors.
App\Entity\Department No errors.
App\Entity\Region No errors.
App\Entity\Country No errors.
App\Entity\ParameterMail No errors.
Vich\UploaderBundle\Entity\File No errors.