Query Metrics
5
Database Queries
5
Different statements
1.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.35 ms (27.09%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.general AS general_3 FROM Sidebar t0 WHERE t0.general = ?
Parameters:
[
1
]
|
|
0.32 ms (24.98%) |
1 |
SELECT t0.gen_id AS gen_id_1, t0.gen_masella_cm AS gen_masella_cm_2, t0.gen_masella_estat_ca AS gen_masella_estat_ca_3, t0.gen_masella_estat_es AS gen_masella_estat_es_4, t0.gen_masella_estat_en AS gen_masella_estat_en_5, t0.gen_masella_estat_fr AS gen_masella_estat_fr_6, t0.gen_masella_estat_pt AS gen_masella_estat_pt_7, t0.gen_masella_estat2_ca AS gen_masella_estat2_ca_8, t0.gen_masella_estat2_es AS gen_masella_estat2_es_9, t0.gen_masella_estat2_en AS gen_masella_estat2_en_10, t0.gen_masella_estat2_fr AS gen_masella_estat2_fr_11, t0.gen_masella_estat2_pt AS gen_masella_estat2_pt_12, t0.gen_coma_oriola_cm AS gen_coma_oriola_cm_13, t0.gen_coma_oriola_estat_ca AS gen_coma_oriola_estat_ca_14, t0.gen_coma_oriola_estat_es AS gen_coma_oriola_estat_es_15, t0.gen_coma_oriola_estat_en AS gen_coma_oriola_estat_en_16, t0.gen_coma_oriola_estat_fr AS gen_coma_oriola_estat_fr_17, t0.gen_coma_oriola_estat_pt AS gen_coma_oriola_estat_pt_18, t0.gen_coma_oriola_estat2_ca AS gen_coma_oriola_estat2_ca_19, t0.gen_coma_oriola_estat2_es AS gen_coma_oriola_estat2_es_20, t0.gen_coma_oriola_estat2_en AS gen_coma_oriola_estat2_en_21, t0.gen_coma_oriola_estat2_fr AS gen_coma_oriola_estat2_fr_22, t0.gen_coma_oriola_estat2_pt AS gen_coma_oriola_estat2_pt_23, t0.gen_bosc_cm AS gen_bosc_cm_24, t0.gen_bosc_estat_ca AS gen_bosc_estat_ca_25, t0.gen_bosc_estat_es AS gen_bosc_estat_es_26, t0.gen_bosc_estat_en AS gen_bosc_estat_en_27, t0.gen_bosc_estat_fr AS gen_bosc_estat_fr_28, t0.gen_bosc_estat_pt AS gen_bosc_estat_pt_29, t0.gen_bosc_estat2_ca AS gen_bosc_estat2_ca_30, t0.gen_bosc_estat2_es AS gen_bosc_estat2_es_31, t0.gen_bosc_estat2_en AS gen_bosc_estat2_en_32, t0.gen_bosc_estat2_fr AS gen_bosc_estat2_fr_33, t0.gen_bosc_estat2_pt AS gen_bosc_estat2_pt_34, t0.gen_la_pleta_cm AS gen_la_pleta_cm_35, t0.gen_la_pleta_estat_ca AS gen_la_pleta_estat_ca_36, t0.gen_la_pleta_estat_es AS gen_la_pleta_estat_es_37, t0.gen_la_pleta_estat_en AS gen_la_pleta_estat_en_38, t0.gen_la_pleta_estat_fr AS gen_la_pleta_estat_fr_39, t0.gen_la_pleta_estat_pt AS gen_la_pleta_estat_pt_40, t0.gen_la_pleta_estat2_ca AS gen_la_pleta_estat2_ca_41, t0.gen_la_pleta_estat2_es AS gen_la_pleta_estat2_es_42, t0.gen_la_pleta_estat2_en AS gen_la_pleta_estat2_en_43, t0.gen_la_pleta_estat2_fr AS gen_la_pleta_estat2_fr_44, t0.gen_la_pleta_estat2_pt AS gen_la_pleta_estat2_pt_45, t0.gen_tosa_cm AS gen_tosa_cm_46, t0.gen_tosa_estat_ca AS gen_tosa_estat_ca_47, t0.gen_tosa_estat_es AS gen_tosa_estat_es_48, t0.gen_tosa_estat_en AS gen_tosa_estat_en_49, t0.gen_tosa_estat_fr AS gen_tosa_estat_fr_50, t0.gen_tosa_estat_pt AS gen_tosa_estat_pt_51, t0.gen_tosa_estat2_ca AS gen_tosa_estat2_ca_52, t0.gen_tosa_estat2_es AS gen_tosa_estat2_es_53, t0.gen_tosa_estat2_en AS gen_tosa_estat2_en_54, t0.gen_tosa_estat2_fr AS gen_tosa_estat2_fr_55, t0.gen_tosa_estat2_pt AS gen_tosa_estat2_pt_56, t0.gen_data_fi_oferta AS gen_data_fi_oferta_57, t0.gen_data_fi_oferta_backoffice AS gen_data_fi_oferta_backoffice_58, t0.gen_text_moviment_ca AS gen_text_moviment_ca_59, t0.gen_text_moviment_es AS gen_text_moviment_es_60, t0.gen_text_moviment_en AS gen_text_moviment_en_61, t0.gen_text_moviment_fr AS gen_text_moviment_fr_62, t0.gen_text_moviment_pt AS gen_text_moviment_pt_63, t0.gen_text_estatic_ca AS gen_text_estatic_ca_64, t0.gen_text_estatic_es AS gen_text_estatic_es_65, t0.gen_text_estatic_en AS gen_text_estatic_en_66, t0.gen_text_estatic_fr AS gen_text_estatic_fr_67, t0.gen_text_estatic_pt AS gen_text_estatic_pt_68, t0.gen_titol_imatge_dia_ca AS gen_titol_imatge_dia_ca_69, t0.gen_titol_imatge_dia_es AS gen_titol_imatge_dia_es_70, t0.gen_titol_imatge_dia_en AS gen_titol_imatge_dia_en_71, t0.gen_titol_imatge_dia_fr AS gen_titol_imatge_dia_fr_72, t0.gen_titol_imatge_dia_pt AS gen_titol_imatge_dia_pt_73, t0.gen_imatge_dia_visible AS gen_imatge_dia_visible_74, t0.gen_logo_ca AS gen_logo_ca_75, t0.gen_logo_es AS gen_logo_es_76, t0.gen_logo_en AS gen_logo_en_77, t0.gen_logo_fr AS gen_logo_fr_78, t0.gen_logo_pt AS gen_logo_pt_79, t0.gen_idioma_ca_visible AS gen_idioma_ca_visible_80, t0.gen_idioma_es_visible AS gen_idioma_es_visible_81, t0.gen_idioma_en_visible AS gen_idioma_en_visible_82, t0.gen_idioma_fr_visible AS gen_idioma_fr_visible_83, t0.gen_idioma_pt_visible AS gen_idioma_pt_visible_84, t0.gen_webcam_visible AS gen_webcam_visible_85, t0.gen_webcam_360_cap_bosc_visible AS gen_webcam_360_cap_bosc_visible_86, t0.gen_temperatura_tosa_visible AS gen_temperatura_tosa_visible_87, t0.gen_prediccio_visible AS gen_prediccio_visible_88, t0.gen_meteo_visible AS gen_meteo_visible_89, t0.gen_pistes_visible AS gen_pistes_visible_90, t0.gen_remuntadors_visible AS gen_remuntadors_visible_91, t0.gen_desnivell_visible AS gen_desnivell_visible_92, t0.gen_gruix_visible AS gen_gruix_visible_93, t0.gen_qualitat_visible AS gen_qualitat_visible_94, t0.gen_km_esquiables AS gen_km_esquiables_95, t0.gen_meteo_plamasella_visible AS gen_meteo_plamasella_visible_96, t0.gen_meteo_tosa_visible AS gen_meteo_tosa_visible_97, t0.gen_meteo_capbosc_visible AS gen_meteo_capbosc_visible_98, t0.gen_facebook_visible AS gen_facebook_visible_99, t0.gen_twitter_visible AS gen_twitter_visible_100, t0.gen_youtube_visible AS gen_youtube_visible_101, t0.gen_instagram_visible AS gen_instagram_visible_102, t0.gen_app_visible AS gen_app_visible_103, t0.gen_blog_visible AS gen_blog_visible_104, t0.gen_area_privada_visible AS gen_area_privada_visible_105, t0.gen_comprar_visible AS gen_comprar_visible_106, t0.gen_contacte_visible AS gen_contacte_visible_107, t0.gen_masella_informa_ca AS gen_masella_informa_ca_108, t0.gen_masella_informa_es AS gen_masella_informa_es_109, t0.gen_masella_informa_en AS gen_masella_informa_en_110, t0.gen_masella_informa_fr AS gen_masella_informa_fr_111, t0.gen_masella_informa_pt AS gen_masella_informa_pt_112, t0.gen_instagram_informa_ca AS gen_instagram_informa_ca_113, t0.gen_instagram_informa_es AS gen_instagram_informa_es_114, t0.gen_instagram_informa_en AS gen_instagram_informa_en_115, t0.gen_instagram_informa_fr AS gen_instagram_informa_fr_116, t0.gen_instagram_informa_pt AS gen_instagram_informa_pt_117, t0.gen_infonit_informa_ca AS gen_infonit_informa_ca_118, t0.gen_infonit_informa_es AS gen_infonit_informa_es_119, t0.gen_infonit_informa_en AS gen_infonit_informa_en_120, t0.gen_infonit_informa_fr AS gen_infonit_informa_fr_121, t0.gen_infonit_informa_pt AS gen_infonit_informa_pt_122, t0.gen_instagram_infonit_informa_ca AS gen_instagram_infonit_informa_ca_123, t0.gen_instagram_infonit_informa_es AS gen_instagram_infonit_informa_es_124, t0.gen_instagram_infonit_informa_en AS gen_instagram_infonit_informa_en_125, t0.gen_instagram_infonit_informa_fr AS gen_instagram_infonit_informa_fr_126, t0.gen_instagram_infonit_informa_pt AS gen_instagram_infonit_informa_pt_127, t0.gen_instagram_infonit_temperatura AS gen_instagram_infonit_temperatura_128, t0.gen_snowpark_dia AS gen_snowpark_dia_129, t0.gen_snowpark_nit AS gen_snowpark_nit_130, t0.gen_alp2500 AS gen_alp2500_131, t0.gen_kmesquiables_dia AS gen_kmesquiables_dia_132, t0.gen_kmesquiables_nit AS gen_kmesquiables_nit_133, t0.gen_imatge_infoneu AS gen_imatge_infoneu_134, t0.gen_imatge_infonit AS gen_imatge_infonit_135, t0.gen_previsio_nit_ca AS gen_previsio_nit_ca_136, t0.gen_previsio_nit_es AS gen_previsio_nit_es_137, t0.gen_previsio_nit_en AS gen_previsio_nit_en_138, t0.gen_previsio_nit_fr AS gen_previsio_nit_fr_139, t0.gen_previsio_nit_pt AS gen_previsio_nit_pt_140, t0.gen_infoneu_visible AS gen_infoneu_visible_141, t0.gen_infonit_visible AS gen_infonit_visible_142, t0.gen_titol_video_central_ca AS gen_titol_video_central_ca_143, t0.gen_titol_video_central_es AS gen_titol_video_central_es_144, t0.gen_titol_video_central_en AS gen_titol_video_central_en_145, t0.gen_titol_video_central_fr AS gen_titol_video_central_fr_146, t0.gen_titol_video_central_pt AS gen_titol_video_central_pt_147, t0.gen_video_central_visible AS gen_video_central_visible_148, t0.gen_numero_video_home AS gen_numero_video_home_149, t0.gen_rebut_guardaesquis_ca AS gen_rebut_guardaesquis_ca_150, t0.gen_rebut_guardaesquis_es AS gen_rebut_guardaesquis_es_151, t0.gen_rebut_guardaesquis_en AS gen_rebut_guardaesquis_en_152, t0.gen_rebut_guardaesquis_fr AS gen_rebut_guardaesquis_fr_153, t0.gen_rebut_guardaesquis_pt AS gen_rebut_guardaesquis_pt_154, t0.gen_ultim_com_id_exportat AS gen_ultim_com_id_exportat_155, t0.gen_codi_descompte AS gen_codi_descompte_156, t0.gen_masella_tv AS gen_masella_tv_157, t0.gen_promocio_visible AS gen_promocio_visible_158, t0.gen_horaris_ca AS gen_horaris_ca_159, t0.gen_horaris_es AS gen_horaris_es_160, t0.gen_horaris_en AS gen_horaris_en_161, t0.gen_horaris_fr AS gen_horaris_fr_162, t0.gen_horaris_pt AS gen_horaris_pt_163, t0.gen_horaris_festiu_ca AS gen_horaris_festiu_ca_164, t0.gen_horaris_festiu_es AS gen_horaris_festiu_es_165, t0.gen_horaris_festiu_en AS gen_horaris_festiu_en_166, t0.gen_horaris_festiu_fr AS gen_horaris_festiu_fr_167, t0.gen_horaris_festiu_pt AS gen_horaris_festiu_pt_168, t0.gen_botiga_abonament AS gen_botiga_abonament_169, t0.gen_botiga_forfets AS gen_botiga_forfets_170, t0.gen_botiga_promocions AS gen_botiga_promocions_171, t0.gen_botiga_recarrega AS gen_botiga_recarrega_172, t0.gen_botiga_classes AS gen_botiga_classes_173, t0.gen_botiga_lloguer AS gen_botiga_lloguer_174, t0.gen_video_slider_home AS gen_video_slider_home_175, t0.gen_des_id AS gen_des_id_176 FROM General t0
Parameters:
[] |
|
0.29 ms (22.33%) |
1 |
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.titol_ca AS titol_ca_2, p0_.titol_es AS titol_es_3, p0_.titol_en AS titol_en_4, p0_.titol_fr AS titol_fr_5, p0_.titol_pt AS titol_pt_6, p0_.slug_ca AS slug_ca_7, p0_.slug_es AS slug_es_8, p0_.slug_en AS slug_en_9, p0_.slug_fr AS slug_fr_10, p0_.slug_pt AS slug_pt_11, p0_.title_ca AS title_ca_12, p0_.title_es AS title_es_13, p0_.title_en AS title_en_14, p0_.title_fr AS title_fr_15, p0_.title_pt AS title_pt_16, p0_.description_ca AS description_ca_17, p0_.description_es AS description_es_18, p0_.description_en AS description_en_19, p0_.description_fr AS description_fr_20, p0_.description_pt AS description_pt_21, p0_.keywords_ca AS keywords_ca_22, p0_.keywords_es AS keywords_es_23, p0_.keywords_en AS keywords_en_24, p0_.keywords_fr AS keywords_fr_25, p0_.keywords_pt AS keywords_pt_26, p0_.visible AS visible_27, p0_.visible_menu AS visible_menu_28, p0_.ordre AS ordre_29, p0_.sidebar_id AS sidebar_id_30, p0_.tema_id AS tema_id_31, p0_.galeries_id AS galeries_id_32 FROM Pagina p0_ WHERE p0_.visible = 1 AND p0_.slug_ca = ? ORDER BY p0_.ordre ASC
Parameters:
[
"allotjament-a-peu-de-pista"
]
|
|
0.20 ms (15.42%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.titol_ca AS titol_ca_3, t0.titol_es AS titol_es_4, t0.titol_en AS titol_en_5, t0.titol_fr AS titol_fr_6, t0.titol_pt AS titol_pt_7, t0.slug_ca AS slug_ca_8, t0.slug_es AS slug_es_9, t0.slug_en AS slug_en_10, t0.slug_fr AS slug_fr_11, t0.slug_pt AS slug_pt_12, t0.title_ca AS title_ca_13, t0.title_es AS title_es_14, t0.title_en AS title_en_15, t0.title_fr AS title_fr_16, t0.title_pt AS title_pt_17, t0.description_ca AS description_ca_18, t0.description_es AS description_es_19, t0.description_en AS description_en_20, t0.description_fr AS description_fr_21, t0.description_pt AS description_pt_22, t0.keywords_ca AS keywords_ca_23, t0.keywords_es AS keywords_es_24, t0.keywords_en AS keywords_en_25, t0.keywords_fr AS keywords_fr_26, t0.keywords_pt AS keywords_pt_27, t0.visible AS visible_28, t0.visible_menu AS visible_menu_29, t0.ordre AS ordre_30, t0.sidebar_id AS sidebar_id_31, t0.tema_id AS tema_id_32, t0.galeries_id AS galeries_id_33 FROM Pagina t0 WHERE t0.slug_ca = ? LIMIT 1
Parameters:
[
"allotjament-a-peu-de-pista"
]
|
|
0.13 ms (10.19%) |
1 |
SELECT t0.spo_id AS spo_id_1, t0.spo_nom_es AS spo_nom_es_2, t0.spo_nom_en AS spo_nom_en_3, t0.spo_nom_ca AS spo_nom_ca_4, t0.spo_nom_fr AS spo_nom_fr_5, t0.spo_nom_pt AS spo_nom_pt_6, t0.spo_slug_es AS spo_slug_es_7, t0.spo_slug_en AS spo_slug_en_8, t0.spo_slug_ca AS spo_slug_ca_9, t0.spo_slug_fr AS spo_slug_fr_10, t0.spo_slug_pt AS spo_slug_pt_11, t0.spo_url AS spo_url_12, t0.spo_imatge AS spo_imatge_13, t0.spo_ordre AS spo_ordre_14, t0.spo_visible AS spo_visible_15 FROM Sponsors t0 WHERE t0.spo_visible = ? ORDER BY t0.spo_ordre ASC
Parameters:
[
1
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Sidebar | No errors. |
| App\Entity\Bloc | No errors. |
| App\Entity\General | No errors. |
| App\Entity\Desnivell | No errors. |
| App\Entity\Sponsors | No errors. |
| App\Entity\Pagina | No errors. |
| App\Entity\Tema | No errors. |
| App\Entity\Galeries | No errors. |
| App\Entity\MenuOpcio | No errors. |