https://ginocortelazzonuovo.devlancer.it/esposizioni/personali

Query Metrics

267 Database Queries
74 Different statements
134.17 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

Time Count Info
51.17 ms
(38.14%)
70
SELECT t0.titolo AS titolo_1, t0.anno AS anno_2, t0.numprogressivoanno AS numprogressivoanno_3, t0.materiale AS materiale_4, t0.x AS x_5, t0.y AS y_6, t0.z AS z_7, t0.collezione AS collezione_8, t0.donadello AS donadello_9, t0.querinistampalia AS querinistampalia_10, t0.mat AS mat_11, t0.chiavi AS chiavi_12, t0.tecnica AS tecnica_13, t0.collocazione AS collocazione_14, t0.note AS note_15, t0.datainserimento AS datainserimento_16, t0.visibile AS visibile_17, t0.id AS id_18, t0.suffisso_numprogressivo AS suffisso_numprogressivo_19, t0.link_video AS link_video_20, t0.idtipoopera AS idtipoopera_21, t0.id_container AS id_container_22 FROM opera t0 INNER JOIN operamostra ON t0.id = operamostra.idopera WHERE operamostra.idmostra = ?
Parameters:
[
  1173
]
15.33 ms
(11.43%)
63
SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.mostra AS mostra_3, t0.multimedia AS multimedia_4 FROM mostramultimedia t0 WHERE t0.mostra = ?
Parameters:
[
  1116
]
4.22 ms
(3.14%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1173 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
2.88 ms
(2.14%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1157 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
2.73 ms
(2.04%)
1
SELECT m0_.nome AS nome_0, m0_.curatore AS curatore_1, m0_.presentazione AS presentazione_2, m0_.anno AS anno_3, m0_.luogo AS luogo_4, m0_.personale AS personale_5, m0_.collettiva AS collettiva_6, m0_.oldid AS oldid_7, m0_.numprogressivaanno AS numprogressivaanno_8, m0_.esposizione AS esposizione_9, m0_.tipo AS tipo_10, m0_.id AS id_11 FROM mostra m0_ WHERE m0_.personale = true ORDER BY m0_.numprogressivaanno ASC
Parameters:
[]
1.54 ms
(1.15%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1121 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
1.22 ms
(0.91%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1165 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
1.21 ms
(0.90%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1147 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
1.19 ms
(0.88%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1104 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
1.12 ms
(0.84%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1150 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
1.10 ms
(0.82%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1120 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
1.08 ms
(0.81%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1119 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
1.08 ms
(0.81%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1135 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
1.08 ms
(0.81%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1112 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
1.06 ms
(0.79%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1129 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
1.06 ms
(0.79%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1110 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
1.05 ms
(0.78%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1100 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
1.04 ms
(0.78%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1163 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
1.04 ms
(0.77%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1128 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
1.03 ms
(0.77%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1158 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
1.01 ms
(0.76%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1117 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.99 ms
(0.74%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1170 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.99 ms
(0.73%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1116 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.98 ms
(0.73%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1124 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.98 ms
(0.73%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1114 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.96 ms
(0.72%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1159 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.96 ms
(0.72%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1133 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.96 ms
(0.72%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1171 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.96 ms
(0.71%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1132 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.94 ms
(0.70%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1126 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.90 ms
(0.67%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1139 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.90 ms
(0.67%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1115 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.89 ms
(0.67%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1148 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.89 ms
(0.66%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1153 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.89 ms
(0.66%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1137 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.89 ms
(0.66%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1106 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.87 ms
(0.65%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1142 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.85 ms
(0.63%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1149 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.84 ms
(0.63%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1141 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.84 ms
(0.63%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1162 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.83 ms
(0.62%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1169 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.82 ms
(0.61%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1125 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.81 ms
(0.61%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1172 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.80 ms
(0.60%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1102 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.80 ms
(0.59%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1103 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.78 ms
(0.58%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1164 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.77 ms
(0.57%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1151 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.76 ms
(0.57%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1111 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.76 ms
(0.56%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1168 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.76 ms
(0.56%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1161 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.75 ms
(0.56%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1160 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.75 ms
(0.56%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1118 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.75 ms
(0.56%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1122 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.74 ms
(0.55%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1107 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.74 ms
(0.55%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1167 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.73 ms
(0.54%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1131 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.73 ms
(0.54%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1134 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.72 ms
(0.54%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1152 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.72 ms
(0.54%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1140 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.72 ms
(0.53%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1143 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.71 ms
(0.53%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1127 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.70 ms
(0.52%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1123 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.68 ms
(0.51%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1144 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.68 ms
(0.50%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1166 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.66 ms
(0.49%)
2
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1105 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.62 ms
(0.46%)
1
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1154 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.55 ms
(0.41%)
1
SELECT m0_.nome AS nome_0, m0_.curatore AS curatore_1, m0_.presentazione AS presentazione_2, m0_.anno AS anno_3, m0_.luogo AS luogo_4, m0_.personale AS personale_5, m0_.collettiva AS collettiva_6, m0_.oldid AS oldid_7, m0_.numprogressivaanno AS numprogressivaanno_8, m0_.esposizione AS esposizione_9, m0_.tipo AS tipo_10, m0_.id AS id_11 FROM mostra m0_ WHERE m0_.collettiva = true
Parameters:
[]
0.44 ms
(0.32%)
1
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1130 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.43 ms
(0.32%)
1
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1145 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.41 ms
(0.30%)
1
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1136 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.36 ms
(0.27%)
1
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1155 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.36 ms
(0.27%)
1
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1108 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.32 ms
(0.24%)
1
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1156 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.32 ms
(0.24%)
1
SELECT m0_.fileref AS fileref_0, m0_.estensione AS estensione_1 FROM mostramultimedia m1_ INNER JOIN multimedia m0_ ON m1_.multimedia = m0_.id WHERE m1_.mostra = 1146 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]

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
App\Entity\Mostra
  • The field App\Entity\Mostra#idopera is on the owning side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Opera# does not contain the required 'inversedBy' attribute.
  • The association App\Entity\Mostra#iddocumento refers to the inverse side field App\Entity\Documento#idmostra which does not exist.
  • The field App\Entity\Mostra#idarticolo is on the owning side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Articolo# does not contain the required 'inversedBy' attribute.
  • If association App\Entity\Mostra#idarticolo is many-to-many, then the inversed side App\Entity\Articolo#idmostra has to be many-to-many as well.
App\Entity\MostraMultimedia No errors.
App\Entity\Opera
  • The field App\Entity\Opera#idarticolo is on the owning side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Articolo# does not contain the required 'inversedBy' attribute.
  • The field App\Entity\Opera#idmostra is on the owning side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Mostra# does not contain the required 'inversedBy' attribute.
  • The field App\Entity\Opera#iddocumento is on the owning side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Documento# does not contain the required 'inversedBy' attribute.
App\Entity\Video No errors.
App\Entity\Documento
  • The field App\Entity\Documento#idopera is on the owning side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Opera# does not contain the required 'inversedBy' attribute.
App\Entity\Articolo
  • The field App\Entity\Articolo#idopera is on the owning side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Opera# does not contain the required 'inversedBy' attribute.
App\Entity\Multimedia No errors.
App\Entity\Tipoopera No errors.
App\Entity\OperaContainer No errors.
App\Entity\OperaMultimedia No errors.
App\Entity\Altro No errors.