https://test01.nextcaddy.com/provincias/4

Query Metrics

160 Database Queries
5 Different statements
16.59 ms Query time
3 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 7.07 ms
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.nombre_canonical AS nombre_canonical_2, c0_.created_at AS created_at_3, c0_.nombre_corto AS nombre_corto_4, c0_.direccion AS direccion_5, c0_.telefono AS telefono_6, c0_.web AS web_7, c0_.rfeg_id AS rfeg_id_8, c0_.intervalo_facturacion AS intervalo_facturacion_9, c0_.minimo_factura AS minimo_factura_10, c0_.latitud AS latitud_11, c0_.longitud AS longitud_12, c0_.habilitado AS habilitado_13, c0_.graphql_enabled AS graphql_enabled_14, c0_.graphql_key AS graphql_key_15, c0_.graphql_signature AS graphql_signature_16, c0_.visible AS visible_17, c0_.allowTpv AS allowTpv_18, c0_.externalId AS externalId_19, c0_.rfc_seguro AS rfc_seguro_20, c0_.flickr_gallery AS flickr_gallery_21, c0_.livescoring_policy AS livescoring_policy_22, c0_.localidad_id AS localidad_id_23, c0_.User_id AS User_id_24, c0_.Cliente_id AS Cliente_id_25, c0_.timezone_id AS timezone_id_26 FROM Club c0_ INNER JOIN Localidad l1_ ON (c0_.localidad_id = l1_.id) INNER JOIN Provincia p2_ ON (l1_.provincia_id = p2_.id) WHERE c0_.id NOT IN ('AMXX', 'CMXX', 'AM00', 'CM00', 'AMLP', 'JGLF', '7700', 'EQLT', 'MAJC', 'AMX1') AND c0_.habilitado = 1 AND c0_.visible = 1 AND p2_.comunidad_id IN (1, 10, 13, 14, 7, 5) ORDER BY p2_.comunidad_id ASC, p2_.id ASC, c0_.nombre ASC
Parameters:
[]
2 0.15 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  73
]
3 0.10 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  4
]
4 0.08 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  776
]
5 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  77
]
6 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  61
]
7 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  36
]
8 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  38
]
9 0.07 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  101
]
10 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  41
]
11 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  99
]
12 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  136
]
13 0.07 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  11
]
14 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  108
]
15 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  143
]
16 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  117
]
17 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  130
]
18 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  133
]
19 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  111
]
20 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  137
]
21 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  123
]
22 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  131
]
23 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  167
]
24 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  14
]
25 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  200
]
26 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  267
]
27 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  18
]
28 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  290
]
29 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  337
]
30 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  346
]
31 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  391
]
32 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  21
]
33 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  438
]
34 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  394
]
35 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  410
]
36 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  399
]
37 0.08 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  431
]
38 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  522
]
39 0.04 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  23
]
40 0.04 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  573
]
41 0.04 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  29
]
42 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  634
]
43 0.04 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  580
]
44 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  616
]
45 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  659
]
46 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  590
]
47 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  635
]
48 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  606
]
49 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  588
]
50 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  646
]
51 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  632
]
52 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  655
]
53 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  633
]
54 0.04 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  572
]
55 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  649
]
56 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  678
]
57 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  41
]
58 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  717
]
59 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  762
]
60 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  760
]
61 0.07 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  670
]
62 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  4049
]
63 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  35
]
64 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  4056
]
65 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  4060
]
66 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  4040
]
67 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  4052
]
68 0.08 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  4064
]
69 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  779
]
70 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  4066
]
71 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  4106
]
72 0.07 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  38
]
73 0.07 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  4080
]
74 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  4089
]
75 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  4076
]
76 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  4071
]
77 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  4098
]
78 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  4114
]
79 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  965
]
80 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  5
]
81 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  2873
]
82 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  2734
]
83 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  2761
]
84 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  2869
]
85 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  1974
]
86 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  9
]
87 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  2111
]
88 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  2214
]
89 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  2314
]
90 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  2215
]
91 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  2269
]
92 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  2131
]
93 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  1612
]
94 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  24
]
95 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  1761
]
96 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  1611
]
97 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  1640
]
98 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  1734
]
99 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  1862
]
100 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  34
]
101 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  1830
]
102 0.08 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  1552
]
103 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  37
]
104 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  1236
]
105 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  1295
]
106 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  1525
]
107 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  966
]
108 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  40
]
109 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  2625
]
110 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  2663
]
111 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  1556
]
112 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  2539
]
113 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  2602
]
114 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  2547
]
115 0.07 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  2574
]
116 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  2468
]
117 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  42
]
118 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  1557
]
119 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  2462
]
120 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  2436
]
121 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  974
]
122 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  47
]
123 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  988
]
124 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  1146
]
125 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  1123
]
126 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  977
]
127 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  3575
]
128 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  49
]
129 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  3581
]
130 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  3425
]
131 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  4566
]
132 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  3
]
133 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  4035
]
134 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  777
]
135 0.07 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  46
]
136 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  835
]
137 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  28
]
138 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  780
]
139 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  924
]
140 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  892
]
141 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  829
]
142 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  794
]
143 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  803
]
144 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  953
]
145 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  958
]
146 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  787
]
147 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  897
]
148 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  861
]
149 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  786
]
150 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  949
]
151 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  939
]
152 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  928
]
153 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  810
]
154 0.05 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  901
]
155 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  912
]
156 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  909
]
157 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_aemet AS id_aemet_3, t0.provincia_id AS provincia_id_4 FROM Localidad t0 WHERE t0.id = ?
Parameters:
[
  1555
]
158 0.06 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0 WHERE t0.id = ?
Parameters:
[
  30
]
159 0.09 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comunidad_id AS comunidad_id_3 FROM Provincia t0
Parameters:
[]
160 0.56 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.default_logo AS default_logo_3 FROM Comunidad t0
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
encrypt doctrine.dbal.encrypt_connection
nodoql doctrine.dbal.nodoql_connection
copy_to_check doctrine.dbal.copy_to_check_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
encrypt doctrine.orm.encrypt_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Backend\Club No errors.
App\Entity\Backend\Provincia No errors.
App\Entity\Backend\Comunidad No errors.
App\Entity\Backend\Localidad
  • The field App\Entity\Backend\Localidad#clubes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Backend\Club#localidad does not contain the required 'inversedBy="clubes"' attribute.
App\Entity\User\User No errors.
App\Entity\Backend\Cliente No errors.
App\Entity\Backend\Timezone No errors.
App\Entity\Backend\Competicion
  • The mappings App\Entity\Backend\Competicion#competitionSectionHidden and App\Entity\Backend\CompetitionSectionHidden#competition are inconsistent with each other.
App\Entity\Backend\Socio No errors.
App\Entity\Backend\Empleado No errors.
App\Entity\Backend\Federacion No errors.
App\Entity\Backend\Voucher No errors.
App\Entity\Gestion\Ranking
  • The association App\Entity\Gestion\Ranking#ranking_point_position_template refers to the inverse side field App\Entity\Backend\RankingPointPositionTemplate#rankings which does not exist.
App\Entity\Backend\RankingPointPositionTemplate No errors.
App\Entity\Backend\ExternalCompetition No errors.

encrypt entity manager

No loaded entities.