35 duplicated queries found.
| Time | Duration | Type | Duplicated | Query |
|---|---|---|---|---|
| 17:12:08.706 | 0.9 ms | SELECT | 1 | SELECT * FROM `cwh_config_contents` WHERE `cwh_config_contents`.`deleted_at` IS NULL |
| 17:12:08.710 | 2.2 ms | SELECT | 1 | SELECT `data` FROM `session` WHERE `expire`>1775229128 AND `id`='c4oo94vjbdvk8po9jolcjfm3fh' |
| 17:12:08.717 | 0.9 ms | SELECT | 1 | SELECT COUNT(*) FROM `translation_conf` WHERE (`translation_conf`.`deleted_at` IS NULL) AND (`model_generated`=0) |
| 17:12:08.724 | 1.0 ms | SELECT | 1 | SELECT * FROM `sim_comprensorio` WHERE (`sim_comprensorio`.`deleted_at` IS NULL) AND (`id`='3') |
| 17:12:08.729 | 1.1 ms | SELECT | 1 | SELECT * FROM `sim_stazione` WHERE `comprensorio_id`='3' |
| 17:12:08.730 | 4.6 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `sim_stazione` |
| 17:12:08.735 | 0.9 ms | SHOW | 1 | SHOW CREATE TABLE `sim_stazione` |
| 17:12:08.736 | 5.2 ms | SELECT | 1 | SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'sim_stazione' AND `kcu`.`TABLE_NAME` = 'sim_stazione' |
| 17:12:08.742 | 2.7 ms | SELECT | 1 | SELECT `sim_piste_anagrafica`.`id` FROM `sim_piste_anagrafica` LEFT JOIN `sim_piste_punti` ON sim_piste_anagrafica.id = sim_piste_punti.id_pista WHERE (`sim_piste_anagrafica`.`stazione_id` IN (5, 6)) AND (`sim_piste_punti`.`id_pista` IS NULL) |
| 17:12:08.745 | 2.4 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `sim_piste_anagrafica` |
| 17:12:08.748 | 0.9 ms | SHOW | 1 | SHOW CREATE TABLE `sim_piste_anagrafica` |
| 17:12:08.749 | 4.4 ms | SELECT | 1 | SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'sim_piste_anagrafica' AND `kcu`.`TABLE_NAME` = 'sim_piste_anagrafica' |
| 17:12:08.755 | 1.7 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `sim_stazione_multimedia` |
| 17:12:08.756 | 1.0 ms | SHOW | 1 | SHOW CREATE TABLE `sim_stazione_multimedia` |
| 17:12:08.757 | 2.9 ms | SELECT | 1 | SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'sim_stazione_multimedia' AND `kcu`.`TABLE_NAME` = 'sim_stazione_multimedia' |
| 17:12:08.762 | 0.8 ms | SELECT | 1 | SELECT * FROM `sim_stazione_multimedia` WHERE (`sim_stazione_multimedia`.`deleted_at` IS NULL) AND (`stazione_id` IN (5, 6)) |
| 17:12:08.764 | 1.7 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `sim_stazione_video` |
| 17:12:08.766 | 0.9 ms | SHOW | 1 | SHOW CREATE TABLE `sim_stazione_video` |
| 17:12:08.767 | 2.5 ms | SELECT | 1 | SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'sim_stazione_video' AND `kcu`.`TABLE_NAME` = 'sim_stazione_video' |
| 17:12:08.769 | 6.2 ms | SELECT | 1 | SELECT * FROM `sim_stazione_video` WHERE (`sim_stazione_video`.`deleted_at` IS NULL) AND (`stazione_id` IN (5, 6)) |
| 17:12:08.779 | 0.8 ms | SELECT | 1 | SELECT * FROM `sim_stazione_webcam` WHERE (`sim_stazione_webcam`.`deleted_at` IS NULL) AND (`stazione_id` IN (5, 6)) |
| 17:12:08.782 | 0.9 ms | SELECT | 1 | SELECT * FROM `sim_stazione_noleggio` WHERE (`sim_stazione_noleggio`.`deleted_at` IS NULL) AND (`stazione_id` IN (5, 6)) |
| 17:12:08.786 | 2.0 ms | SHOW | 1 | SHOW FULL COLUMNS FROM `sim_impianti_risalita_anagrafica` |
| 17:12:08.788 | 1.0 ms | SHOW | 1 | SHOW CREATE TABLE `sim_impianti_risalita_anagrafica` |
| 17:12:08.789 | 2.5 ms | SELECT | 1 | SELECT
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
`kcu`.`COLUMN_NAME` AS `column_name`,
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
(
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
) AND
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
AND `rc`.`TABLE_NAME` = 'sim_impianti_risalita_anagrafica' AND `kcu`.`TABLE_NAME` = 'sim_impianti_risalita_anagrafica' |
| 17:12:08.792 | 2.1 ms | SELECT | 1 | SELECT COUNT(*) FROM `sim_impianti_risalita_anagrafica` WHERE (`sim_impianti_risalita_anagrafica`.`deleted_at` IS NULL) AND (`stazione_id` IN (5, 6)) |
| 17:12:08.794 | 1.0 ms | SELECT | 1 | SELECT * FROM `sim_impianti_risalita_anagrafica` WHERE (`sim_impianti_risalita_anagrafica`.`deleted_at` IS NULL) AND (`stazione_id` IN (5, 6)) |
| 17:12:09.705 | 0.8 ms | SELECT | 1 | SELECT * FROM `sim_comprensorio` WHERE (`sim_comprensorio`.`deleted_at` IS NULL) AND (`id`=3) |
| 17:12:09.708 | 0.8 ms | SELECT | 1 | SELECT * FROM `sim_stazione` WHERE (`comprensorio_id`=3) AND (`sim_stazione`.`deleted_at` IS NULL) |
| 17:12:09.709 | 0.9 ms | SELECT | 1 | SELECT * FROM `sim_piste_anagrafica` WHERE (`sim_piste_anagrafica`.`deleted_at` IS NULL) AND (`pista_chiusa_anno_corrente`=0) AND (`stazione_id`=5) AND (`sim_piste_anagrafica`.`deleted_at` IS NULL) |
| 17:12:09.755 | 2.6 ms | SELECT | 1 | SELECT * FROM `sim_piste_anagrafica` WHERE (`sim_piste_anagrafica`.`deleted_at` IS NULL) AND (`pista_chiusa_anno_corrente`=0) AND (`stazione_id`=6) AND (`sim_piste_anagrafica`.`deleted_at` IS NULL) |
| 17:12:09.935 | 2.3 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=480) ORDER BY `ordine_punti` |
| 17:12:09.937 | 2.0 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=481) ORDER BY `ordine_punti` |
| 17:12:09.939 | 2.2 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=482) ORDER BY `ordine_punti` |
| 17:12:09.942 | 1.0 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=483) ORDER BY `ordine_punti` |
| 17:12:09.943 | 0.9 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=484) ORDER BY `ordine_punti` |
| 17:12:09.944 | 0.8 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=485) ORDER BY `ordine_punti` |
| 17:12:09.945 | 0.9 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=486) ORDER BY `ordine_punti` |
| 17:12:09.946 | 2.2 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=487) ORDER BY `ordine_punti` |
| 17:12:09.948 | 0.8 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=495) ORDER BY `ordine_punti` |
| 17:12:09.949 | 0.8 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=496) ORDER BY `ordine_punti` |
| 17:12:09.950 | 0.8 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=497) ORDER BY `ordine_punti` |
| 17:12:09.951 | 2.2 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=498) ORDER BY `ordine_punti` |
| 17:12:09.953 | 1.8 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=499) ORDER BY `ordine_punti` |
| 17:12:09.955 | 0.9 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=500) ORDER BY `ordine_punti` |
| 17:12:09.956 | 0.8 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=501) ORDER BY `ordine_punti` |
| 17:12:09.957 | 0.9 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=502) ORDER BY `ordine_punti` |
| 17:12:09.958 | 2.5 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=503) ORDER BY `ordine_punti` |
| 17:12:09.960 | 2.3 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=504) ORDER BY `ordine_punti` |
| 17:12:09.963 | 0.9 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=505) ORDER BY `ordine_punti` |
| 17:12:09.964 | 1.0 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=506) ORDER BY `ordine_punti` |
| 17:12:09.965 | 0.9 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=507) ORDER BY `ordine_punti` |
| 17:12:09.966 | 0.9 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=508) ORDER BY `ordine_punti` |
| 17:12:09.967 | 2.2 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=509) ORDER BY `ordine_punti` |
| 17:12:09.969 | 0.9 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=510) ORDER BY `ordine_punti` |
| 17:12:09.970 | 2.1 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=511) ORDER BY `ordine_punti` |
| 17:12:09.973 | 0.8 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=512) ORDER BY `ordine_punti` |
| 17:12:09.973 | 0.8 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=513) ORDER BY `ordine_punti` |
| 17:12:09.974 | 0.8 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=514) ORDER BY `ordine_punti` |
| 17:12:09.975 | 0.8 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=515) ORDER BY `ordine_punti` |
| 17:12:09.976 | 1.0 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=516) ORDER BY `ordine_punti` |
| 17:12:09.977 | 1.1 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=517) ORDER BY `ordine_punti` |
| 17:12:09.978 | 2.4 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=518) ORDER BY `ordine_punti` |
| 17:12:09.981 | 0.9 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=519) ORDER BY `ordine_punti` |
| 17:12:09.982 | 0.8 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=520) ORDER BY `ordine_punti` |
| 17:12:09.983 | 0.9 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=521) ORDER BY `ordine_punti` |
| 17:12:09.984 | 0.8 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=522) ORDER BY `ordine_punti` |
| 17:12:09.985 | 0.8 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=524) ORDER BY `ordine_punti` |
| 17:12:09.986 | 0.8 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=525) ORDER BY `ordine_punti` |
| 17:12:09.987 | 0.9 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=526) ORDER BY `ordine_punti` |
| 17:12:09.987 | 0.8 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=527) ORDER BY `ordine_punti` |
| 17:12:09.988 | 0.8 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=528) ORDER BY `ordine_punti` |
| 17:12:09.989 | 0.8 ms | SELECT | 1 | SELECT * FROM `sim_piste_punti` WHERE (`sim_piste_punti`.`deleted_at` IS NULL) AND (`id_pista`=529) ORDER BY `ordine_punti` |
| 17:12:09.990 | 0.8 ms | SELECT | 1 | SELECT * FROM `sim_impianti_risalita_anagrafica` WHERE (`sim_impianti_risalita_anagrafica`.`deleted_at` IS NULL) AND (`stazione_id`=5) |
| 17:12:09.996 | 0.9 ms | SELECT | 1 | SELECT * FROM `sim_impianti_risalita_anagrafica` WHERE (`sim_impianti_risalita_anagrafica`.`deleted_at` IS NULL) AND (`stazione_id`=6) |
| 17:12:10.075 | 1.3 ms | SELECT | 1 | SELECT * FROM `sim_impianti_risalita_punti` WHERE (`sim_impianti_risalita_punti`.`deleted_at` IS NULL) AND (`id_impianto`=203) ORDER BY `ordine_punti` |
| 17:12:10.076 | 1.1 ms | SELECT | 1 | SELECT * FROM `sim_impianti_risalita_punti` WHERE (`sim_impianti_risalita_punti`.`deleted_at` IS NULL) AND (`id_impianto`=205) ORDER BY `ordine_punti` |
| 17:12:10.078 | 1.1 ms | SELECT | 1 | SELECT * FROM `sim_impianti_risalita_punti` WHERE (`sim_impianti_risalita_punti`.`deleted_at` IS NULL) AND (`id_impianto`=206) ORDER BY `ordine_punti` |
| 17:12:10.079 | 1.1 ms | SELECT | 1 | SELECT * FROM `sim_impianti_risalita_punti` WHERE (`sim_impianti_risalita_punti`.`deleted_at` IS NULL) AND (`id_impianto`=207) ORDER BY `ordine_punti` |
| 17:12:10.080 | 1.1 ms | SELECT | 1 | SELECT * FROM `sim_impianti_risalita_punti` WHERE (`sim_impianti_risalita_punti`.`deleted_at` IS NULL) AND (`id_impianto`=208) ORDER BY `ordine_punti` |
| 17:12:10.081 | 1.1 ms | SELECT | 1 | SELECT * FROM `sim_impianti_risalita_punti` WHERE (`sim_impianti_risalita_punti`.`deleted_at` IS NULL) AND (`id_impianto`=209) ORDER BY `ordine_punti` |
| 17:12:10.082 | 1.1 ms | SELECT | 1 | SELECT * FROM `sim_impianti_risalita_punti` WHERE (`sim_impianti_risalita_punti`.`deleted_at` IS NULL) AND (`id_impianto`=210) ORDER BY `ordine_punti` |
| 17:12:10.084 | 1.1 ms | SELECT | 1 | SELECT * FROM `sim_impianti_risalita_punti` WHERE (`sim_impianti_risalita_punti`.`deleted_at` IS NULL) AND (`id_impianto`=211) ORDER BY `ordine_punti` |
| 17:12:10.085 | 1.1 ms | SELECT | 1 | SELECT * FROM `sim_impianti_risalita_punti` WHERE (`sim_impianti_risalita_punti`.`deleted_at` IS NULL) AND (`id_impianto`=212) ORDER BY `ordine_punti` |
| 17:12:10.086 | 1.1 ms | SELECT | 1 | SELECT * FROM `sim_impianti_risalita_punti` WHERE (`sim_impianti_risalita_punti`.`deleted_at` IS NULL) AND (`id_impianto`=213) ORDER BY `ordine_punti` |
| 17:12:10.087 | 1.1 ms | SELECT | 1 | SELECT * FROM `sim_impianti_risalita_punti` WHERE (`sim_impianti_risalita_punti`.`deleted_at` IS NULL) AND (`id_impianto`=214) ORDER BY `ordine_punti` |
| 17:12:10.088 | 1.1 ms | SELECT | 1 | SELECT * FROM `sim_impianti_risalita_punti` WHERE (`sim_impianti_risalita_punti`.`deleted_at` IS NULL) AND (`id_impianto`=215) ORDER BY `ordine_punti` |
| 17:12:10.090 | 1.1 ms | SELECT | 1 | SELECT * FROM `sim_impianti_risalita_punti` WHERE (`sim_impianti_risalita_punti`.`deleted_at` IS NULL) AND (`id_impianto`=216) ORDER BY `ordine_punti` |
| 17:12:10.091 | 1.1 ms | SELECT | 1 | SELECT * FROM `sim_impianti_risalita_punti` WHERE (`sim_impianti_risalita_punti`.`deleted_at` IS NULL) AND (`id_impianto`=217) ORDER BY `ordine_punti` |
| 17:12:10.092 | 1.1 ms | SELECT | 1 | SELECT * FROM `sim_impianti_risalita_punti` WHERE (`sim_impianti_risalita_punti`.`deleted_at` IS NULL) AND (`id_impianto`=218) ORDER BY `ordine_punti` |
| 17:12:10.093 | 1.1 ms | SELECT | 1 | SELECT * FROM `sim_impianti_risalita_punti` WHERE (`sim_impianti_risalita_punti`.`deleted_at` IS NULL) AND (`id_impianto`=219) ORDER BY `ordine_punti` |
| 17:12:10.095 | 0.9 ms | SELECT | 1 | SELECT * FROM `sim_scuola_scii` WHERE (`sim_scuola_scii`.`deleted_at` IS NULL) AND (`stazione_id`=5) |
| 17:12:10.096 | 1.8 ms | SELECT | 1 | SELECT * FROM `sim_scuola_scii` WHERE (`sim_scuola_scii`.`deleted_at` IS NULL) AND (`stazione_id`=6) |
| 17:12:10.101 | 1.0 ms | SELECT | 1 | SELECT COUNT(*) FROM `sim_piste_anagrafica` INNER JOIN `sim_stazione` ON sim_stazione.id = sim_piste_anagrafica.stazione_id AND sim_stazione.deleted_at IS NULL INNER JOIN `sim_comprensorio` ON sim_comprensorio.id = sim_stazione.comprensorio_id and sim_comprensorio.deleted_at IS NULL WHERE (`sim_piste_anagrafica`.`deleted_at` IS NULL) AND (`pista_chiusa_anno_corrente`=0) AND (`sim_comprensorio`.`id`='3') |
| 17:12:10.102 | 1.1 ms | SELECT | 1 | SELECT `sim_piste_anagrafica`.* FROM `sim_piste_anagrafica` INNER JOIN `sim_stazione` ON sim_stazione.id = sim_piste_anagrafica.stazione_id AND sim_stazione.deleted_at IS NULL INNER JOIN `sim_comprensorio` ON sim_comprensorio.id = sim_stazione.comprensorio_id and sim_comprensorio.deleted_at IS NULL WHERE (`sim_piste_anagrafica`.`deleted_at` IS NULL) AND (`pista_chiusa_anno_corrente`=0) AND (`sim_comprensorio`.`id`='3') LIMIT 18 |
| 17:12:10.197 | 0.8 ms | SELECT | 8 | SELECT * FROM `sim_stazione` WHERE `id`=5 |
| 17:12:10.200 | 0.8 ms | SELECT | 8 | SELECT * FROM `sim_stazione` WHERE `id`=5 |
| 17:12:10.202 | 0.8 ms | SELECT | 8 | SELECT * FROM `sim_stazione` WHERE `id`=5 |
| 17:12:10.204 | 0.8 ms | SELECT | 8 | SELECT * FROM `sim_stazione` WHERE `id`=5 |
| 17:12:10.206 | 0.7 ms | SELECT | 8 | SELECT * FROM `sim_stazione` WHERE `id`=5 |
| 17:12:10.208 | 0.8 ms | SELECT | 8 | SELECT * FROM `sim_stazione` WHERE `id`=5 |
| 17:12:10.210 | 0.8 ms | SELECT | 8 | SELECT * FROM `sim_stazione` WHERE `id`=5 |
| 17:12:10.212 | 0.8 ms | SELECT | 8 | SELECT * FROM `sim_stazione` WHERE `id`=5 |
| 17:12:10.215 | 0.8 ms | SELECT | 19 | SELECT * FROM `sim_stazione` WHERE `id`=6 |
| 17:12:10.217 | 0.8 ms | SELECT | 19 | SELECT * FROM `sim_stazione` WHERE `id`=6 |
| 17:12:10.219 | 0.8 ms | SELECT | 19 | SELECT * FROM `sim_stazione` WHERE `id`=6 |
| 17:12:10.221 | 0.8 ms | SELECT | 19 | SELECT * FROM `sim_stazione` WHERE `id`=6 |
| 17:12:10.224 | 0.8 ms | SELECT | 19 | SELECT * FROM `sim_stazione` WHERE `id`=6 |
| 17:12:10.226 | 0.8 ms | SELECT | 19 | SELECT * FROM `sim_stazione` WHERE `id`=6 |
| 17:12:10.228 | 0.9 ms | SELECT | 19 | SELECT * FROM `sim_stazione` WHERE `id`=6 |
| 17:12:10.230 | 0.8 ms | SELECT | 19 | SELECT * FROM `sim_stazione` WHERE `id`=6 |
| 17:12:10.232 | 0.8 ms | SELECT | 19 | SELECT * FROM `sim_stazione` WHERE `id`=6 |
| 17:12:10.235 | 0.8 ms | SELECT | 19 | SELECT * FROM `sim_stazione` WHERE `id`=6 |
| 17:12:10.237 | 0.8 ms | SELECT | 19 | SELECT * FROM `sim_stazione` WHERE `id`=6 |
| 17:12:10.238 | 0.7 ms | SELECT | 19 | SELECT * FROM `sim_stazione` WHERE `id`=6 |
| 17:12:10.239 | 0.8 ms | SELECT | 19 | SELECT * FROM `sim_stazione` WHERE `id`=6 |
| 17:12:10.240 | 0.8 ms | SELECT | 19 | SELECT * FROM `sim_stazione` WHERE `id`=6 |
| 17:12:10.241 | 0.7 ms | SELECT | 19 | SELECT * FROM `sim_stazione` WHERE `id`=6 |
| 17:12:10.242 | 0.7 ms | SELECT | 19 | SELECT * FROM `sim_stazione` WHERE `id`=6 |
| 17:12:10.242 | 0.8 ms | SELECT | 19 | SELECT * FROM `sim_stazione` WHERE `id`=6 |
| 17:12:10.243 | 0.8 ms | SELECT | 19 | SELECT * FROM `sim_stazione` WHERE `id`=6 |
| 17:12:10.244 | 0.8 ms | SELECT | 19 | SELECT * FROM `sim_stazione` WHERE `id`=6 |
| 17:12:10.247 | 0.9 ms | SELECT | 4 | SELECT id FROM admin_lang where is_default=1 |
| 17:12:10.248 | 4.0 ms | SELECT | 1 | SELECT `i`.`id` AS `id0`, `i1`.`id` AS `id1`, `i2`.`id` AS `id2`, `i3`.`id` AS `id3`, `i4`.`id` AS `id4`, `i5`.`id` AS `id5`, `i`.`alias` AS `alias0`, `i1`.`alias` AS `alias1`, `i2`.`alias` AS `alias2`, `i3`.`alias` AS `alias3`, `i4`.`alias` AS `alias4`, `i5`.`alias` AS `alias5`, `i`.`title` AS `title0`, `i1`.`title` AS `title1`, `i2`.`title` AS `title2`, `i3`.`title` AS `title3`, `i4`.`title` AS `title4`, `i5`.`title` AS `title5`, `red`.`value` AS `link0`, `red1`.`value` AS `link1`, `red2`.`value` AS `link2`, `red3`.`value` AS `link3`, `red4`.`value` AS `link4`, `red5`.`value` AS `link5`, `red`.`target` AS `target0`, `red1`.`target` AS `target1`, `red2`.`target` AS `target2`, `red3`.`target` AS `target3`, `red4`.`target` AS `target4`, `red5`.`target` AS `target5`, `p`.`value` AS `permission0`, `p1`.`value` AS `permission1`, `p2`.`value` AS `permission2`, `p3`.`value` AS `permission3`, `p4`.`value` AS `permission4`, `p5`.`value` AS `permission5`, `pp`.`value` AS `isProtected0`, `pp1`.`value` AS `isProtected1`, `pp2`.`value` AS `isProtected2`, `pp3`.`value` AS `isProtected3`, `pp4`.`value` AS `isProtected4`, `pp5`.`value` AS `isProtected5`, `b`.`value` AS `bullet0`, `b1`.`value` AS `bullet1`, `b2`.`value` AS `bullet2`, `b3`.`value` AS `bullet3`, `b4`.`value` AS `bullet4`, `b5`.`value` AS `bullet5`, `r`.`value` AS `readOnly0`, `r1`.`value` AS `readOnly1`, `r2`.`value` AS `readOnly2`, `r3`.`value` AS `readOnly3`, `r4`.`value` AS `readOnly4`, `r5`.`value` AS `readOnly5` FROM `cms_nav_container` `c` LEFT JOIN `cms_nav` `n` ON n.nav_container_id = c.id and n.parent_nav_id = 0 and n.is_deleted = 0 and n.is_hidden = 0 and n.is_offline = 0 and n.is_draft = 0 LEFT JOIN `cms_nav` `n1` ON n1.parent_nav_id = n.id and n1.is_deleted = 0 and n1.is_hidden = 0 and n1.is_offline = 0 and n1.is_draft = 0 LEFT JOIN `cms_nav` `n2` ON n2.parent_nav_id = n1.id and n2.is_deleted = 0 and n2.is_hidden = 0 and n2.is_offline = 0 and n2.is_draft = 0 LEFT JOIN `cms_nav` `n3` ON n3.parent_nav_id = n2.id and n3.is_deleted = 0 and n3.is_hidden = 0 and n3.is_offline = 0 and n3.is_draft = 0 LEFT JOIN `cms_nav` `n4` ON n4.parent_nav_id = n3.id and n4.is_deleted = 0 and n4.is_hidden = 0 and n4.is_offline = 0 and n4.is_draft = 0 LEFT JOIN `cms_nav` `n5` ON n5.parent_nav_id = n4.id and n5.is_deleted = 0 and n5.is_hidden = 0 and n5.is_offline = 0 and n5.is_draft = 0 LEFT JOIN `cms_nav_item` `i` ON i.nav_id = n.id and i.lang_id = 1 LEFT JOIN `cms_nav_item` `i1` ON i1.nav_id = n1.id and i1.lang_id = 1 LEFT JOIN `cms_nav_item` `i2` ON i2.nav_id = n2.id and i2.lang_id = 1 LEFT JOIN `cms_nav_item` `i3` ON i3.nav_id = n3.id and i3.lang_id = 1 LEFT JOIN `cms_nav_item` `i4` ON i4.nav_id = n4.id and i4.lang_id = 1 LEFT JOIN `cms_nav_item` `i5` ON i5.nav_id = n5.id and i5.lang_id = 1 LEFT JOIN `cms_nav_property` `p` ON p.nav_id = n.id and p.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p1` ON p1.nav_id = n1.id and p1.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p2` ON p2.nav_id = n2.id and p2.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p3` ON p3.nav_id = n3.id and p3.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p4` ON p4.nav_id = n4.id and p4.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p5` ON p5.nav_id = n5.id and p5.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `pp` ON pp.nav_id = n.id and pp.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp1` ON pp1.nav_id = n1.id and pp1.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp2` ON pp2.nav_id = n2.id and pp2.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp3` ON pp3.nav_id = n3.id and pp3.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp4` ON pp4.nav_id = n4.id and pp4.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp5` ON pp5.nav_id = n5.id and pp5.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `b` ON b.nav_id = n.id and b.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b1` ON b1.nav_id = n1.id and b1.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b2` ON b2.nav_id = n2.id and b2.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b3` ON b3.nav_id = n3.id and b3.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b4` ON b4.nav_id = n4.id and b4.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b5` ON b5.nav_id = n5.id and b5.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `r` ON r.nav_id = n.id and r.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r1` ON r1.nav_id = n1.id and r1.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r2` ON r2.nav_id = n2.id and r2.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r3` ON r3.nav_id = n3.id and r3.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r4` ON r4.nav_id = n4.id and r4.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r5` ON r5.nav_id = n5.id and r5.admin_prop_id = 8 LEFT JOIN `cms_nav_item_redirect` `red` ON red.id = i.nav_item_type_id AND i.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red1` ON red1.id = i1.nav_item_type_id AND i1.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red2` ON red2.id = i2.nav_item_type_id AND i2.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red3` ON red3.id = i3.nav_item_type_id AND i3.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red4` ON red4.id = i4.nav_item_type_id AND i4.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red5` ON red5.id = i5.nav_item_type_id AND i5.nav_item_type = 3 WHERE (`c`.`alias`='myopen') AND (`c`.`is_deleted`=0) ORDER BY `n`.`sort_index`, `n1`.`sort_index`, `n2`.`sort_index`, `n3`.`sort_index`, `n4`.`sort_index`, `n5`.`sort_index` |
| 17:12:10.252 | 0.9 ms | SELECT | 1 | SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='USERPROFILE_UPDATE') |
| 17:12:10.253 | 0.8 ms | SELECT | 1 | SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='AMMINISTRATORE_NEWS') |
| 17:12:10.254 | 0.8 ms | SELECT | 1 | SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='ATTACH_DATABANK_FILE_ADMINISTRATOR') |
| 17:12:10.255 | 3.7 ms | SELECT | 1 | SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='ATTACH_GALLERY_ADMINISTRATOR') |
| 17:12:10.259 | 0.8 ms | SELECT | 1 | SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='BASIC_USER') |
| 17:12:10.260 | 0.8 ms | SELECT | 1 | SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='CAPOREDATTORECMS') |
| 17:12:10.261 | 0.8 ms | SELECT | 1 | SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='CMS_PAGE_EDITOR') |
| 17:12:10.261 | 0.8 ms | SELECT | 1 | SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='PRODOTTIDESTINATARI_ADMIN') |
| 17:12:10.262 | 0.8 ms | SELECT | 1 | SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='PRODOTTIFINALITA_ADMIN') |
| 17:12:10.263 | 2.6 ms | SELECT | 1 | SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='PRODOTTISERVIZI_ADMIN') |
| 17:12:10.266 | 0.8 ms | SELECT | 1 | SELECT `item_id` FROM `user_profile_classes_auth_mm` WHERE (`user_profile_classes_auth_mm`.`deleted_at` IS NULL) AND (`user_profile_classes_id`='PRODOTTISOLUZIONI_ADMIN') |
| 17:12:10.267 | 0.7 ms | SELECT | 4 | SELECT id FROM admin_lang where is_default=1 |
| 17:12:10.268 | 2.5 ms | SELECT | 2 | SELECT `i`.`id` AS `id0`, `i1`.`id` AS `id1`, `i2`.`id` AS `id2`, `i3`.`id` AS `id3`, `i4`.`id` AS `id4`, `i5`.`id` AS `id5`, `i`.`alias` AS `alias0`, `i1`.`alias` AS `alias1`, `i2`.`alias` AS `alias2`, `i3`.`alias` AS `alias3`, `i4`.`alias` AS `alias4`, `i5`.`alias` AS `alias5`, `i`.`title` AS `title0`, `i1`.`title` AS `title1`, `i2`.`title` AS `title2`, `i3`.`title` AS `title3`, `i4`.`title` AS `title4`, `i5`.`title` AS `title5`, `red`.`value` AS `link0`, `red1`.`value` AS `link1`, `red2`.`value` AS `link2`, `red3`.`value` AS `link3`, `red4`.`value` AS `link4`, `red5`.`value` AS `link5`, `red`.`target` AS `target0`, `red1`.`target` AS `target1`, `red2`.`target` AS `target2`, `red3`.`target` AS `target3`, `red4`.`target` AS `target4`, `red5`.`target` AS `target5`, `p`.`value` AS `permission0`, `p1`.`value` AS `permission1`, `p2`.`value` AS `permission2`, `p3`.`value` AS `permission3`, `p4`.`value` AS `permission4`, `p5`.`value` AS `permission5`, `pp`.`value` AS `isProtected0`, `pp1`.`value` AS `isProtected1`, `pp2`.`value` AS `isProtected2`, `pp3`.`value` AS `isProtected3`, `pp4`.`value` AS `isProtected4`, `pp5`.`value` AS `isProtected5`, `b`.`value` AS `bullet0`, `b1`.`value` AS `bullet1`, `b2`.`value` AS `bullet2`, `b3`.`value` AS `bullet3`, `b4`.`value` AS `bullet4`, `b5`.`value` AS `bullet5`, `r`.`value` AS `readOnly0`, `r1`.`value` AS `readOnly1`, `r2`.`value` AS `readOnly2`, `r3`.`value` AS `readOnly3`, `r4`.`value` AS `readOnly4`, `r5`.`value` AS `readOnly5` FROM `cms_nav_container` `c` LEFT JOIN `cms_nav` `n` ON n.nav_container_id = c.id and n.parent_nav_id = 0 and n.is_deleted = 0 and n.is_hidden = 0 and n.is_offline = 0 and n.is_draft = 0 LEFT JOIN `cms_nav` `n1` ON n1.parent_nav_id = n.id and n1.is_deleted = 0 and n1.is_hidden = 0 and n1.is_offline = 0 and n1.is_draft = 0 LEFT JOIN `cms_nav` `n2` ON n2.parent_nav_id = n1.id and n2.is_deleted = 0 and n2.is_hidden = 0 and n2.is_offline = 0 and n2.is_draft = 0 LEFT JOIN `cms_nav` `n3` ON n3.parent_nav_id = n2.id and n3.is_deleted = 0 and n3.is_hidden = 0 and n3.is_offline = 0 and n3.is_draft = 0 LEFT JOIN `cms_nav` `n4` ON n4.parent_nav_id = n3.id and n4.is_deleted = 0 and n4.is_hidden = 0 and n4.is_offline = 0 and n4.is_draft = 0 LEFT JOIN `cms_nav` `n5` ON n5.parent_nav_id = n4.id and n5.is_deleted = 0 and n5.is_hidden = 0 and n5.is_offline = 0 and n5.is_draft = 0 LEFT JOIN `cms_nav_item` `i` ON i.nav_id = n.id and i.lang_id = 1 LEFT JOIN `cms_nav_item` `i1` ON i1.nav_id = n1.id and i1.lang_id = 1 LEFT JOIN `cms_nav_item` `i2` ON i2.nav_id = n2.id and i2.lang_id = 1 LEFT JOIN `cms_nav_item` `i3` ON i3.nav_id = n3.id and i3.lang_id = 1 LEFT JOIN `cms_nav_item` `i4` ON i4.nav_id = n4.id and i4.lang_id = 1 LEFT JOIN `cms_nav_item` `i5` ON i5.nav_id = n5.id and i5.lang_id = 1 LEFT JOIN `cms_nav_property` `p` ON p.nav_id = n.id and p.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p1` ON p1.nav_id = n1.id and p1.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p2` ON p2.nav_id = n2.id and p2.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p3` ON p3.nav_id = n3.id and p3.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p4` ON p4.nav_id = n4.id and p4.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p5` ON p5.nav_id = n5.id and p5.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `pp` ON pp.nav_id = n.id and pp.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp1` ON pp1.nav_id = n1.id and pp1.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp2` ON pp2.nav_id = n2.id and pp2.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp3` ON pp3.nav_id = n3.id and pp3.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp4` ON pp4.nav_id = n4.id and pp4.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp5` ON pp5.nav_id = n5.id and pp5.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `b` ON b.nav_id = n.id and b.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b1` ON b1.nav_id = n1.id and b1.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b2` ON b2.nav_id = n2.id and b2.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b3` ON b3.nav_id = n3.id and b3.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b4` ON b4.nav_id = n4.id and b4.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b5` ON b5.nav_id = n5.id and b5.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `r` ON r.nav_id = n.id and r.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r1` ON r1.nav_id = n1.id and r1.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r2` ON r2.nav_id = n2.id and r2.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r3` ON r3.nav_id = n3.id and r3.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r4` ON r4.nav_id = n4.id and r4.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r5` ON r5.nav_id = n5.id and r5.admin_prop_id = 8 LEFT JOIN `cms_nav_item_redirect` `red` ON red.id = i.nav_item_type_id AND i.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red1` ON red1.id = i1.nav_item_type_id AND i1.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red2` ON red2.id = i2.nav_item_type_id AND i2.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red3` ON red3.id = i3.nav_item_type_id AND i3.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red4` ON red4.id = i4.nav_item_type_id AND i4.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red5` ON red5.id = i5.nav_item_type_id AND i5.nav_item_type = 3 WHERE (`c`.`alias`='default') AND (`c`.`is_deleted`=0) ORDER BY `n`.`sort_index`, `n1`.`sort_index`, `n2`.`sort_index`, `n3`.`sort_index`, `n4`.`sort_index`, `n5`.`sort_index` |
| 17:12:10.271 | 0.8 ms | SELECT | 2 | SELECT * FROM `admin_lang` WHERE (`admin_lang`.`is_deleted`=FALSE) AND (`short_code`='it') |
| 17:12:10.273 | 0.9 ms | SELECT | 1 | SELECT * FROM `slideshow_route` WHERE (`slideshow_route`.`deleted_at` IS NULL) AND (`route`='/mountain_sports/sim-comprensorio/view') AND (`role`='TUTTI') |
| 17:12:10.279 | 0.8 ms | SELECT | 4 | SELECT id FROM admin_lang where is_default=1 |
| 17:12:10.280 | 2.3 ms | SELECT | 2 | SELECT `i`.`id` AS `id0`, `i1`.`id` AS `id1`, `i2`.`id` AS `id2`, `i3`.`id` AS `id3`, `i4`.`id` AS `id4`, `i5`.`id` AS `id5`, `i`.`alias` AS `alias0`, `i1`.`alias` AS `alias1`, `i2`.`alias` AS `alias2`, `i3`.`alias` AS `alias3`, `i4`.`alias` AS `alias4`, `i5`.`alias` AS `alias5`, `i`.`title` AS `title0`, `i1`.`title` AS `title1`, `i2`.`title` AS `title2`, `i3`.`title` AS `title3`, `i4`.`title` AS `title4`, `i5`.`title` AS `title5`, `red`.`value` AS `link0`, `red1`.`value` AS `link1`, `red2`.`value` AS `link2`, `red3`.`value` AS `link3`, `red4`.`value` AS `link4`, `red5`.`value` AS `link5`, `red`.`target` AS `target0`, `red1`.`target` AS `target1`, `red2`.`target` AS `target2`, `red3`.`target` AS `target3`, `red4`.`target` AS `target4`, `red5`.`target` AS `target5`, `p`.`value` AS `permission0`, `p1`.`value` AS `permission1`, `p2`.`value` AS `permission2`, `p3`.`value` AS `permission3`, `p4`.`value` AS `permission4`, `p5`.`value` AS `permission5`, `pp`.`value` AS `isProtected0`, `pp1`.`value` AS `isProtected1`, `pp2`.`value` AS `isProtected2`, `pp3`.`value` AS `isProtected3`, `pp4`.`value` AS `isProtected4`, `pp5`.`value` AS `isProtected5`, `b`.`value` AS `bullet0`, `b1`.`value` AS `bullet1`, `b2`.`value` AS `bullet2`, `b3`.`value` AS `bullet3`, `b4`.`value` AS `bullet4`, `b5`.`value` AS `bullet5`, `r`.`value` AS `readOnly0`, `r1`.`value` AS `readOnly1`, `r2`.`value` AS `readOnly2`, `r3`.`value` AS `readOnly3`, `r4`.`value` AS `readOnly4`, `r5`.`value` AS `readOnly5` FROM `cms_nav_container` `c` LEFT JOIN `cms_nav` `n` ON n.nav_container_id = c.id and n.parent_nav_id = 0 and n.is_deleted = 0 and n.is_hidden = 0 and n.is_offline = 0 and n.is_draft = 0 LEFT JOIN `cms_nav` `n1` ON n1.parent_nav_id = n.id and n1.is_deleted = 0 and n1.is_hidden = 0 and n1.is_offline = 0 and n1.is_draft = 0 LEFT JOIN `cms_nav` `n2` ON n2.parent_nav_id = n1.id and n2.is_deleted = 0 and n2.is_hidden = 0 and n2.is_offline = 0 and n2.is_draft = 0 LEFT JOIN `cms_nav` `n3` ON n3.parent_nav_id = n2.id and n3.is_deleted = 0 and n3.is_hidden = 0 and n3.is_offline = 0 and n3.is_draft = 0 LEFT JOIN `cms_nav` `n4` ON n4.parent_nav_id = n3.id and n4.is_deleted = 0 and n4.is_hidden = 0 and n4.is_offline = 0 and n4.is_draft = 0 LEFT JOIN `cms_nav` `n5` ON n5.parent_nav_id = n4.id and n5.is_deleted = 0 and n5.is_hidden = 0 and n5.is_offline = 0 and n5.is_draft = 0 LEFT JOIN `cms_nav_item` `i` ON i.nav_id = n.id and i.lang_id = 1 LEFT JOIN `cms_nav_item` `i1` ON i1.nav_id = n1.id and i1.lang_id = 1 LEFT JOIN `cms_nav_item` `i2` ON i2.nav_id = n2.id and i2.lang_id = 1 LEFT JOIN `cms_nav_item` `i3` ON i3.nav_id = n3.id and i3.lang_id = 1 LEFT JOIN `cms_nav_item` `i4` ON i4.nav_id = n4.id and i4.lang_id = 1 LEFT JOIN `cms_nav_item` `i5` ON i5.nav_id = n5.id and i5.lang_id = 1 LEFT JOIN `cms_nav_property` `p` ON p.nav_id = n.id and p.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p1` ON p1.nav_id = n1.id and p1.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p2` ON p2.nav_id = n2.id and p2.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p3` ON p3.nav_id = n3.id and p3.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p4` ON p4.nav_id = n4.id and p4.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p5` ON p5.nav_id = n5.id and p5.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `pp` ON pp.nav_id = n.id and pp.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp1` ON pp1.nav_id = n1.id and pp1.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp2` ON pp2.nav_id = n2.id and pp2.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp3` ON pp3.nav_id = n3.id and pp3.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp4` ON pp4.nav_id = n4.id and pp4.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp5` ON pp5.nav_id = n5.id and pp5.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `b` ON b.nav_id = n.id and b.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b1` ON b1.nav_id = n1.id and b1.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b2` ON b2.nav_id = n2.id and b2.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b3` ON b3.nav_id = n3.id and b3.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b4` ON b4.nav_id = n4.id and b4.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b5` ON b5.nav_id = n5.id and b5.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `r` ON r.nav_id = n.id and r.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r1` ON r1.nav_id = n1.id and r1.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r2` ON r2.nav_id = n2.id and r2.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r3` ON r3.nav_id = n3.id and r3.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r4` ON r4.nav_id = n4.id and r4.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r5` ON r5.nav_id = n5.id and r5.admin_prop_id = 8 LEFT JOIN `cms_nav_item_redirect` `red` ON red.id = i.nav_item_type_id AND i.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red1` ON red1.id = i1.nav_item_type_id AND i1.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red2` ON red2.id = i2.nav_item_type_id AND i2.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red3` ON red3.id = i3.nav_item_type_id AND i3.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red4` ON red4.id = i4.nav_item_type_id AND i4.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red5` ON red5.id = i5.nav_item_type_id AND i5.nav_item_type = 3 WHERE (`c`.`alias`='default') AND (`c`.`is_deleted`=0) ORDER BY `n`.`sort_index`, `n1`.`sort_index`, `n2`.`sort_index`, `n3`.`sort_index`, `n4`.`sort_index`, `n5`.`sort_index` |
| 17:12:10.282 | 0.8 ms | SELECT | 4 | SELECT id FROM admin_lang where is_default=1 |
| 17:12:10.283 | 2.2 ms | SELECT | 1 | SELECT `i`.`id` AS `id0`, `i1`.`id` AS `id1`, `i2`.`id` AS `id2`, `i3`.`id` AS `id3`, `i4`.`id` AS `id4`, `i5`.`id` AS `id5`, `i`.`alias` AS `alias0`, `i1`.`alias` AS `alias1`, `i2`.`alias` AS `alias2`, `i3`.`alias` AS `alias3`, `i4`.`alias` AS `alias4`, `i5`.`alias` AS `alias5`, `i`.`title` AS `title0`, `i1`.`title` AS `title1`, `i2`.`title` AS `title2`, `i3`.`title` AS `title3`, `i4`.`title` AS `title4`, `i5`.`title` AS `title5`, `red`.`value` AS `link0`, `red1`.`value` AS `link1`, `red2`.`value` AS `link2`, `red3`.`value` AS `link3`, `red4`.`value` AS `link4`, `red5`.`value` AS `link5`, `red`.`target` AS `target0`, `red1`.`target` AS `target1`, `red2`.`target` AS `target2`, `red3`.`target` AS `target3`, `red4`.`target` AS `target4`, `red5`.`target` AS `target5`, `p`.`value` AS `permission0`, `p1`.`value` AS `permission1`, `p2`.`value` AS `permission2`, `p3`.`value` AS `permission3`, `p4`.`value` AS `permission4`, `p5`.`value` AS `permission5`, `pp`.`value` AS `isProtected0`, `pp1`.`value` AS `isProtected1`, `pp2`.`value` AS `isProtected2`, `pp3`.`value` AS `isProtected3`, `pp4`.`value` AS `isProtected4`, `pp5`.`value` AS `isProtected5`, `b`.`value` AS `bullet0`, `b1`.`value` AS `bullet1`, `b2`.`value` AS `bullet2`, `b3`.`value` AS `bullet3`, `b4`.`value` AS `bullet4`, `b5`.`value` AS `bullet5`, `r`.`value` AS `readOnly0`, `r1`.`value` AS `readOnly1`, `r2`.`value` AS `readOnly2`, `r3`.`value` AS `readOnly3`, `r4`.`value` AS `readOnly4`, `r5`.`value` AS `readOnly5` FROM `cms_nav_container` `c` LEFT JOIN `cms_nav` `n` ON n.nav_container_id = c.id and n.parent_nav_id = 0 and n.is_deleted = 0 and n.is_hidden = 0 and n.is_offline = 0 and n.is_draft = 0 LEFT JOIN `cms_nav` `n1` ON n1.parent_nav_id = n.id and n1.is_deleted = 0 and n1.is_hidden = 0 and n1.is_offline = 0 and n1.is_draft = 0 LEFT JOIN `cms_nav` `n2` ON n2.parent_nav_id = n1.id and n2.is_deleted = 0 and n2.is_hidden = 0 and n2.is_offline = 0 and n2.is_draft = 0 LEFT JOIN `cms_nav` `n3` ON n3.parent_nav_id = n2.id and n3.is_deleted = 0 and n3.is_hidden = 0 and n3.is_offline = 0 and n3.is_draft = 0 LEFT JOIN `cms_nav` `n4` ON n4.parent_nav_id = n3.id and n4.is_deleted = 0 and n4.is_hidden = 0 and n4.is_offline = 0 and n4.is_draft = 0 LEFT JOIN `cms_nav` `n5` ON n5.parent_nav_id = n4.id and n5.is_deleted = 0 and n5.is_hidden = 0 and n5.is_offline = 0 and n5.is_draft = 0 LEFT JOIN `cms_nav_item` `i` ON i.nav_id = n.id and i.lang_id = 1 LEFT JOIN `cms_nav_item` `i1` ON i1.nav_id = n1.id and i1.lang_id = 1 LEFT JOIN `cms_nav_item` `i2` ON i2.nav_id = n2.id and i2.lang_id = 1 LEFT JOIN `cms_nav_item` `i3` ON i3.nav_id = n3.id and i3.lang_id = 1 LEFT JOIN `cms_nav_item` `i4` ON i4.nav_id = n4.id and i4.lang_id = 1 LEFT JOIN `cms_nav_item` `i5` ON i5.nav_id = n5.id and i5.lang_id = 1 LEFT JOIN `cms_nav_property` `p` ON p.nav_id = n.id and p.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p1` ON p1.nav_id = n1.id and p1.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p2` ON p2.nav_id = n2.id and p2.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p3` ON p3.nav_id = n3.id and p3.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p4` ON p4.nav_id = n4.id and p4.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `p5` ON p5.nav_id = n5.id and p5.admin_prop_id = 9 LEFT JOIN `cms_nav_property` `pp` ON pp.nav_id = n.id and pp.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp1` ON pp1.nav_id = n1.id and pp1.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp2` ON pp2.nav_id = n2.id and pp2.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp3` ON pp3.nav_id = n3.id and pp3.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp4` ON pp4.nav_id = n4.id and pp4.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `pp5` ON pp5.nav_id = n5.id and pp5.admin_prop_id = 10 LEFT JOIN `cms_nav_property` `b` ON b.nav_id = n.id and b.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b1` ON b1.nav_id = n1.id and b1.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b2` ON b2.nav_id = n2.id and b2.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b3` ON b3.nav_id = n3.id and b3.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b4` ON b4.nav_id = n4.id and b4.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `b5` ON b5.nav_id = n5.id and b5.admin_prop_id = 7 LEFT JOIN `cms_nav_property` `r` ON r.nav_id = n.id and r.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r1` ON r1.nav_id = n1.id and r1.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r2` ON r2.nav_id = n2.id and r2.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r3` ON r3.nav_id = n3.id and r3.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r4` ON r4.nav_id = n4.id and r4.admin_prop_id = 8 LEFT JOIN `cms_nav_property` `r5` ON r5.nav_id = n5.id and r5.admin_prop_id = 8 LEFT JOIN `cms_nav_item_redirect` `red` ON red.id = i.nav_item_type_id AND i.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red1` ON red1.id = i1.nav_item_type_id AND i1.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red2` ON red2.id = i2.nav_item_type_id AND i2.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red3` ON red3.id = i3.nav_item_type_id AND i3.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red4` ON red4.id = i4.nav_item_type_id AND i4.nav_item_type = 3 LEFT JOIN `cms_nav_item_redirect` `red5` ON red5.id = i5.nav_item_type_id AND i5.nav_item_type = 3 WHERE (`c`.`alias`='footer') AND (`c`.`is_deleted`=0) ORDER BY `n`.`sort_index`, `n1`.`sort_index`, `n2`.`sort_index`, `n3`.`sort_index`, `n4`.`sort_index`, `n5`.`sort_index` |
| 17:12:10.286 | 0.8 ms | SELECT | 2 | SELECT * FROM `admin_lang` WHERE (`admin_lang`.`is_deleted`=FALSE) AND (`short_code`='it') |
| 17:12:10.287 | 0.8 ms | SELECT | 1 | SELECT * FROM `cms_nav_container` WHERE (`cms_nav_container`.`is_deleted`=FALSE) AND (`alias`='footercms') |
| 17:12:10.291 | 9.1 ms | INSERT | 1 | INSERT INTO `session` (`data`, `id`, `expire`) VALUES ('__flash|a:0:{}isMobile|b:1;krajeeTreeConfigSalt|s:32:\"�{�^4�N��W{x�q�Xh��B�N�hC��l�\";', 'c4oo94vjbdvk8po9jolcjfm3fh', 1775232730) ON DUPLICATE KEY UPDATE `data`=VALUES(`data`), `expire`=VALUES(`expire`) |
| Caller | No. of Calls | Total Duration | Queries | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 146 | 197.1 ms |
|