Query Metrics
6
Database Queries
6
Different statements
26.34 ms
Query time
0
Invalid entities
2
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.11 ms |
SELECT t0.gid AS gid_1, t0.libelle_item AS libelle_item_2, t0.icone AS icone_3, t0.libelle_uri AS libelle_uri_4, t0.cd_ref_gpes AS cd_ref_gpes_5, t0.gpe_sup AS gpe_sup_6, t0.code_machine AS code_machine_7, t0.resume AS resume_8, t0.ordre AS ordre_9, t0.portail_ouvert AS portail_ouvert_10, t0.classes_richesse AS classes_richesse_11, t0.classes_pression_obs AS classes_pression_obs_12, t0.portail_restreint_users AS portail_restreint_users_13, t0.gid AS gid_14 FROM ipn_taxonomie.groupes_usuels t0 WHERE t0.gid = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||||||||
| 2 | 2.10 ms |
SELECT g0_.gid AS gid_0, g1_.gid AS gid_1, g2_.gid AS gid_2, g3_.gid AS gid_3 FROM ipn_taxonomie.groupes_usuels g0_ LEFT JOIN ipn_taxonomie.groupes_usuels g1_ ON (g1_.gpe_sup = g0_.gid) LEFT JOIN ipn_taxonomie.groupes_usuels g2_ ON (g2_.gpe_sup = g1_.gid) LEFT JOIN ipn_taxonomie.groupes_usuels g3_ ON (g3_.gpe_sup = g2_.gid) WHERE g0_.gpe_sup = 2
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 3 | 1.99 ms |
SELECT g0_.gid AS gid_0, g0_.libelle_item AS libelle_item_1, g0_.libelle_uri AS libelle_uri_2, g0_.gpe_sup AS gpe_sup_3, g0_.icone AS icone_4, g1_.nb_especes AS nb_especes_5, g1_.nb_especes_evaluees AS nb_especes_evaluees_6, g1_.nb_proteges AS nb_proteges_7, g1_.nb_menaces AS nb_menaces_8, g1_.nb_exotiques AS nb_exotiques_9 FROM ipn_taxonomie.groupes_usuels g0_ INNER JOIN ipn_descripteurs_occurrence_sinp_valide_v2.groupe_usuel g1_ ON g0_.gid = g1_.groupe_usuel ORDER BY g0_.ordre ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 4 | 12.11 ms |
SELECT v0_.taxons_superieurs AS taxons_superieurs_0 FROM ipn_taxonomie.vm_taxref_last v0_ INNER JOIN ipn_requeteur_v3.referentiel_espece r1_ ON v0_.cd_nom = r1_.cd_ref INNER JOIN ipn_taxonomie.groupes_usuels g2_ ON (g2_.gid = 2 AND (v0_.taxons_superieurs && g2_.cd_ref_gpes) = true) WHERE r1_.est_exotique = true
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 5 | 6.80 ms |
SELECT v0_.cd_nom AS cd_nom_0, v0_.lb_nom AS lb_nom_1, v0_.premier_nom_vern AS premier_nom_vern_2, v0_.rang AS rang_3 FROM ipn_taxonomie.vm_taxref_last v0_ WHERE v0_.cd_nom = v0_.cd_ref AND v0_.cd_nom IN (183716, 183818, 183820, 184348, 184377, 196147, 197799, 184366, 195581, 185694, 185961, 185964, 185967, 845111, 189130, 819821, 199216, 522722, 186027, 196362, 198430, 522786, 186025, 199227, 845110, 191416, 189224, 190037, 198188, 188918, 845109, 195632, 185971, 185979, 188950, 198161, 185977, 191030, 186073, 186076, 198035, 253478, 819790, 196855, 186103, 186144, 192351, 184611, 184612, 184644, 728960, 812731, 193994, 184615, 703510, 730167, 195967, 184672, 728956, 190369, 184685, 726356, 812770, 191607, 729128, 812800, 195940, 184686, 729125, 730473, 197707, 184683, 729172, 812767, 197959, 184443, 184446, 349573, 349751, 184449, 189552, 593843, 523083, 192294, 190017, 184472, 184474, 189528, 184803, 184892, 1011304, 1011307, 190492, 184868, 191899, 185684, 185685, 187693, 187699, 190102, 185518, 185527, 196932, 185214, 185291, 608428, 190645, 186206, 186212, 186214, 195297, 186215, 899299, 194944, 186218, 196666, 524692, 186210, 190552, 191533, 186209, 195602, 186251, 655482, 714926, 714955, 194469, 655502, 699368, 899320, 195442, 186259, 655556, 900891, 197057, 443494, 714970, 194991, 186320, 186338, 186376, 899420, 196236, 525525, 699677, 196617, 187581, 191249, 186378, 186436, 199151, 186399, 823670, 851442, 198373, 192198, 186321, 826847, 186330, 1042999, 191953, 185375, 185399, 535915, 198504, 535913, 536023, 197102, 184787, 184790, 729063, 195975, 184791, 729054, 198100, 185388, 535901, 535986, 192953, 535902, 535990, 192951, 184798, 197088, 185704, 185706, 185707, 188758, 419279, 185760, 825332, 191469, 190332, 905695, 825329, 190755, 906125, 825335, 191332, 193539, 194070, 194072, 200164, 904968, 904973, 196804, 825342, 197167, 185907, 185911, 189039, 185912, 197663, 185892, 185896, 523259, 198445, 523258, 195439, 197344, 185762, 185765, 523277, 192695, 185820, 185830, 189032, 193985, 194751, 185832, 835533, 200262, 186266, 199960, 809717, 194502, 186274, 809715, 198527, 186275, 198300, 186278, 922141, 922154, 618462, 198227, 914450, 185955, 185958, 197788, 185939, 185948, 199068, 190781, 195669, 184450, 196659, 186377, 825174, 885171, 194613, 885169, 192995, 186418, 851162, 192928, 851431, 525842, 851434, 198690, 195589, 851440, 193153, 826885, 186337, 825286, 994780, 197672, 826687, 538766, 699709, 195034, 195644, 199206, 199208, 851425, 199075, 184980, 185099, 729031, 207575, 185119, 208007, 185101, 957403, 957437, 189308, 957444, 957445, 207805, 957434, 957447, 207629, 957404, 207774, 184885, 1011166, 205924, 185126, 437013, 208746, 185158, 827786, 208835, 185188, 641244, 730191, 196083, 730214, 209959, 641245, 815087, 209938, 641243, 815084, 193879, 185290, 608456, 610327, 211197, 185689, 826973, 522266, 212767, 834898, 207930, 184635, 729089, 203586, 184643, 729101, 730327, 203653, 199098, 790554, 203645, 184742, 812352, 190881, 184636, 812370, 812601, 191640, 184704, 823074, 812673, 194211, 184676, 728882, 203959, 185607, 185629, 185634, 212533, 185008, 207006, 184381, 973348, 1037402, 202524, 184388, 197923, 185587, 185600, 185601, 212420, 185109, 207883, 184649, 774569, 203805, 184661, 812417, 812418, 203855, 184767, 729113, 730430, 190519, 730429, 204942, 184668, 812399, 203909, 184670, 776847, 812672, 203922, 184671, 774702, 197159, 184992, 206765, 206804, 206697, 185133, 729192, 730577, 208163, 729212, 730572, 208165, 185033, 207290, 185028, 729011, 730265, 207191, 729010, 730264, 191632, 185088, 729051, 1012628, 207545, 184697, 728880, 204374, 184660, 729075, 730347, 203849, 197218, 812389, 926288, 192257, 812390, 926287, 203936, 728957, 926290, 203937, 202679, 729181, 730559, 190068, 203725, 184684, 774599, 812761, 204015, 812775, 204153, 956574, 204186, 812778, 204149, 204297, 812780, 204210, 184776, 728756, 729969, 196115, 205413, 728762, 729978, 205392, 205262, 812329, 812512, 205316, 523719, 729984, 195404, 184714, 728987, 790767, 204512, 730215, 204594, 204493, 730199, 204634, 185280, 210766, 185309, 814307, 211457, 185263, 814313, 210718, 210722, 841361, 210735, 185254, 814327, 918792, 210417, 185251, 771051, 918709, 210321, 200672, 728765, 729998, 214740, 185313, 814338, 834404, 211611, 185297, 813606, 813607, 211318, 602182, 648599, 730099, 210780, 185285, 602247, 211076, 208008, 208004, 957438, 957443, 207733, 1011250, 1011313, 197110, 185124, 208038, 186776, 186991, 187000, 828697, 214513, 188023, 728858, 812620, 203560, 203583, 761826, 203636, 184385, 387011, 204940, 206700, 185076, 729052, 730308, 207369, 730561, 203766, 726357, 812750, 204115, 199085, 730472, 204304, 186374, 825178, 212890, 186393, 212965, 211474, 188462, 188468, 188469, 194845, 183751, 183812, 350825, 187896, 198034, 350801, 188083, 354640, 188471, 355418, 351560, 357412, 645135, 812812, 195594, 185194, 786033, 198893, 440300, 440476, 714615, 444424, 185954, 444436, 186286, 196473, 187690, 523231, 530306, 458747, 812665, 193086, 188997, 835795, 192973, 186383, 851363, 851368, 195741, 186406, 851416, 526313, 186296, 187525, 188138, 188174, 191682, 715132, 730470, 437215, 530319, 184457, 195684, 418624, 185393, 536030, 747776, 536031, 187522, 186308, 188122, 191227, 187002, 350805, 188232, 188261, 443466, 184459, 187989, 530182, 530198, 542137, 542138, 349821, 355766, 188465, 188467, 190846, 352715, 898362, 350869, 1043249, 835084, 729974, 188952, 812533, 639144, 200681, 812899, 918135, 645162, 646055, 187773, 187855, 523403, 899507, 351895, 358151, 351890, 358107, 826871, 187856, 913969, 542396, 187980, 647541, 188495, 523738, 647630, 185004, 729048, 730298, 647652, 649842, 208023, 1011305, 206130, 184455, 189636, 184837, 1009137, 1009143, 191966, 188009, 729043, 730294, 194522, 200773, 728901, 958623, 215068, 819791, 714609, 521785, 183759, 183760, 913645, 200815, 190066, 837301, 720068, 185242, 210253, 184486, 202706, 186404, 851459, 191646, 185162, 827768, 827766, 191974, 783805, 728928, 730142, 783807, 185081, 834426, 783841, 184914, 783855, 184390, 784215, 913646, 200816, 812667, 189494, 730543, 204069, 813505, 813506, 211263, 813756, 195201, 815841, 185211, 817048, 817070, 192478, 823076, 823077, 186996, 828733, 192447, 836225, 192285, 187727, 198948, 647649, 762255, 828614, 837521, 536024, 192418, 812773, 204193, 844835, 844836, 815089, 198219, 825173, 971952, 192547, 848625, 826877, 187866, 826953, 853680, 853998, 888197, 184896, 1011211, 1011217, 900200, 928296, 202584, 926772, 933145, 1037376, 437165, 812662, 203853, 825333, 903742, 971538, 983402, 185822, 658325, 1005990, 184890, 968413, 968502, 206103, 836202, 813854, 918150, 1031600, 1040528, 184994, 206877, 184931, 525455, 730157, 820218, 184354, 1043268, 963143)
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 6 | 1.23 ms |
SELECT t0.serial AS serial_1, t0.mail AS mail_2, t0.mail_transitoire AS mail_transitoire_3, t0.validermail_key AS validermail_key_4, t0.poste_occupe AS poste_occupe_5, t0.date_creation AS date_creation_6, t0.derniere_date_edition AS derniere_date_edition_7, t0.newsletter AS newsletter_8, t0.statut AS statut_9, t0.uid AS uid_10, t0.orgid AS orgid_11 FROM ipn_user.corr_utilisateur_organisme t0 WHERE t0.uid IS NULL AND t0.statut = ?
Parameters:
[
1
]
|
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\Taxonomie\GroupeUsuel | 1 |
| App\Entity\Indicateurs\Donnees\OccSINPValide\GroupeUsuel\General | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Taxonomie\GroupeUsuel | No errors. |
| App\Entity\Indicateurs\Donnees\OccSINPValide\GroupeUsuel\General | No errors. |
| App\Entity\Taxonomie\TaxrefLast | No errors. |
| App\Entity\Taxonomie\EspeceDansReferentielEspeceRegional | No errors. |
| App\Entity\OrganismesUser | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Organisme | No errors. |