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

Query Metrics

211 Database Queries
74 Different statements
115.59 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

Time Count Info
50.48 ms
(43.67%)
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
]
3.98 ms
(3.44%)
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:
[]
3.27 ms
(2.83%)
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.93 ms
(1.67%)
7
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:
[
  1172
]
1.38 ms
(1.19%)
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:
[]
1.36 ms
(1.17%)
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:
[]
1.15 ms
(1.00%)
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.15 ms
(0.99%)
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:
[]
1.09 ms
(0.95%)
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:
[]
1.02 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 = 1121 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
1.02 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 = 1132 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.98 ms
(0.85%)
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:
[]
0.98 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 = 1118 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.98 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 = 1165 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.97 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 = 1128 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.92 ms
(0.80%)
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.92 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 = 1142 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.92 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 = 1171 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.91 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 = 1148 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.91 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 = 1116 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.90 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 = 1115 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.90 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 = 1114 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.89 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 = 1125 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.89 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 = 1153 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.89 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 = 1152 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.88 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 = 1159 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.88 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 = 1107 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.88 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 = 1133 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.87 ms
(0.75%)
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.86 ms
(0.75%)
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.86 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 = 1160 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.85 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 = 1120 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.85 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 = 1168 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.84 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 = 1131 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.83 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 = 1127 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.83 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 = 1117 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.82 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 = 1103 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.82 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 = 1149 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.82 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 = 1122 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.82 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 = 1162 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.81 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 = 1163 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.81 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 = 1105 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.81 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 = 1134 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.80 ms
(0.69%)
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.80 ms
(0.69%)
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:
[]
0.80 ms
(0.69%)
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.77 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 = 1137 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.76 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 = 1172 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.76 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 = 1106 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.75 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 = 1100 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.75 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 = 1129 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.74 ms
(0.64%)
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:
[]
0.74 ms
(0.64%)
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.73 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 = 1112 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.72 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 = 1102 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.72 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 = 1140 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.71 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 = 1157 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.70 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 = 1141 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.70 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 = 1147 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.70 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 = 1144 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.69 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 = 1135 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.69 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 = 1110 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.69 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 = 1139 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.68 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 = 1164 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.66 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 = 1123 AND m0_.estensione = 'pdf' ORDER BY m1_.id ASC LIMIT 1
Parameters:
[]
0.47 ms
(0.40%)
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.45 ms
(0.39%)
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.42 ms
(0.37%)
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.41 ms
(0.36%)
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.40 ms
(0.35%)
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:
[]
0.39 ms
(0.33%)
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.38 ms
(0.33%)
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.35 ms
(0.31%)
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.34 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 = 1108 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.