Query Metrics
20
Database Queries
17
Different statements
20.47 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
7.81 ms (38.18%) |
1 |
SELECT m0_.id AS id_0, m0_.position AS position_1, m0_.created AS created_2, m0_.updated AS updated_3, m0_.news_name AS news_name_4, m0_.news_code AS news_code_5, m0_.news_video AS news_video_6, m0_.news_media_video AS news_media_video_7, m0_.news_media_video_label AS news_media_video_label_8, m0_.news_media_video_new_tab AS news_media_video_new_tab_9, m0_.news_introduction AS news_introduction_10, m0_.news_description AS news_description_11, m0_.news_is_teasing AS news_is_teasing_12, m0_.news_date_start AS news_date_start_13, m0_.news_date_end AS news_date_end_14, m0_.news_date_actu AS news_date_actu_15, m0_.online AS online_16, m1_.id AS id_17, m1_.position AS position_18, m1_.created AS created_19, m1_.updated AS updated_20, m1_.category_name AS category_name_21, m1_.category_code AS category_code_22, m1_.category_title AS category_title_23, m1_.category_introduction AS category_introduction_24, m1_.category_description AS category_description_25, f2_.id AS id_26, f2_.media_index AS media_index_27, f2_.media_description AS media_description_28, f2_.position AS position_29, f2_.media_zoom AS media_zoom_30, f2_.media_display_legend AS media_display_legend_31, m0_.site_id AS site_id_32, f2_.media_id AS media_id_33, f2_.block_id AS block_id_34, f2_.news_id AS news_id_35, f2_.page_id AS page_id_36, f2_.gallery_id AS gallery_id_37, f2_.slide_id AS slide_id_38, f2_.grouping_id AS grouping_id_39, f2_.banner_id AS banner_id_40, f2_.seo_id AS seo_id_41, f2_.analytic_id AS analytic_id_42 FROM mod_news m0_ LEFT JOIN mod_news_newscategories m3_ ON m0_.id = m3_.news_id LEFT JOIN mod_news_categories m1_ ON m1_.id = m3_.category_id LEFT JOIN fxc_medias_relations f2_ ON m0_.id = f2_.news_id WHERE m0_.news_code = ? AND m0_.site_id = ? AND m0_.online = 1 AND (m0_.news_date_start IS NULL OR m0_.news_date_start < CURRENT_TIMESTAMP) AND (m0_.news_date_end IS NULL OR m0_.news_date_end > CURRENT_TIMESTAMP)
Parameters: [0 => mieux-connaitre-le-lievre-variable, 1 => 1]
|
1.88 ms (9.19%) |
1 |
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters: []
|
1.27 ms (6.21%) |
2 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.created AS created_3, t0.updated AS updated_4, t0.block_name AS block_name_5, t0.block_title AS block_title_6, t0.block_introduction AS block_introduction_7, t0.block_body AS block_body_8, t0.block_link AS block_link_9, t0.block_link_label AS block_link_label_10, t0.block_link_target AS block_link_target_11, t0.action_filter AS action_filter_12, t0.block_height AS block_height_13, t0.col_id AS col_id_14, t0.blocktype_id AS blocktype_id_15, t0.page_target AS page_target_16, t0.action_id AS action_id_17, t18.id AS id_19, t18.media_index AS media_index_20, t18.media_description AS media_description_21, t18.position AS position_22, t18.media_zoom AS media_zoom_23, t18.media_display_legend AS media_display_legend_24, t18.media_id AS media_id_25, t18.block_id AS block_id_26, t18.news_id AS news_id_27, t18.page_id AS page_id_28, t18.gallery_id AS gallery_id_29, t18.slide_id AS slide_id_30, t18.grouping_id AS grouping_id_31, t18.banner_id AS banner_id_32, t18.seo_id AS seo_id_33, t18.analytic_id AS analytic_id_34 FROM fxc_blocks t0 LEFT JOIN fxc_medias_relations t18 ON t18.block_id = t0.id WHERE t0.col_id = ? ORDER BY t0.position ASC
Parameters: [0 => 209]
|
1.10 ms (5.38%) |
1 |
SELECT f0_.id AS id_0, f0_.position AS position_1, f0_.created AS created_2, f0_.updated AS updated_3, f0_.page_name AS page_name_4, f0_.page_name_back AS page_name_back_5, f0_.page_code AS page_code_6, f0_.page_is_default AS page_is_default_7, f0_.page_level AS page_level_8, f0_.online AS online_9, f0_.page_plan AS page_plan_10, f0_.page_arbo AS page_arbo_11, f1_.id AS id_12, f1_.position AS position_13, f1_.created AS created_14, f1_.updated AS updated_15, f1_.layout_name AS layout_name_16, f1_.layout_code AS layout_code_17, f2_.id AS id_18, f2_.position AS position_19, f2_.created AS created_20, f2_.updated AS updated_21, f2_.template_name AS template_name_22, f2_.template_code AS template_code_23, f2_.template_width AS template_width_24, f2_.template_padding AS template_padding_25, f2_.template_is_active AS template_is_active_26, f3_.id AS id_27, f3_.media_index AS media_index_28, f3_.media_description AS media_description_29, f3_.position AS position_30, f3_.media_zoom AS media_zoom_31, f3_.media_display_legend AS media_display_legend_32, f4_.id AS id_33, f4_.position AS position_34, f4_.created AS created_35, f4_.updated AS updated_36, f4_.meta_title AS meta_title_37, f4_.meta_description AS meta_description_38, f4_.meta_canonical AS meta_canonical_39, f4_.meta_index AS meta_index_40, f4_.meta_follow AS meta_follow_41, f4_.meta_og_title AS meta_og_title_42, f4_.meta_og_description AS meta_og_description_43, f5_.id AS id_44, f5_.media_index AS media_index_45, f5_.media_description AS media_description_46, f5_.position AS position_47, f5_.media_zoom AS media_zoom_48, f5_.media_display_legend AS media_display_legend_49, f0_.layout_id AS layout_id_50, f0_.site_id AS site_id_51, f0_.template_id AS template_id_52, f0_.parent_id AS parent_id_53, f3_.media_id AS media_id_54, f3_.block_id AS block_id_55, f3_.news_id AS news_id_56, f3_.page_id AS page_id_57, f3_.gallery_id AS gallery_id_58, f3_.slide_id AS slide_id_59, f3_.grouping_id AS grouping_id_60, f3_.banner_id AS banner_id_61, f3_.seo_id AS seo_id_62, f3_.analytic_id AS analytic_id_63, f4_.page_id AS page_id_64, f5_.media_id AS media_id_65, f5_.block_id AS block_id_66, f5_.news_id AS news_id_67, f5_.page_id AS page_id_68, f5_.gallery_id AS gallery_id_69, f5_.slide_id AS slide_id_70, f5_.grouping_id AS grouping_id_71, f5_.banner_id AS banner_id_72, f5_.seo_id AS seo_id_73, f5_.analytic_id AS analytic_id_74 FROM fxc_pages f0_ LEFT JOIN fxc_layouts f1_ ON f0_.layout_id = f1_.id INNER JOIN fxc_templates f2_ ON f0_.template_id = f2_.id LEFT JOIN fxc_medias_relations f3_ ON f0_.id = f3_.page_id LEFT JOIN fxc_seo f4_ ON f0_.id = f4_.page_id LEFT JOIN fxc_medias_relations f5_ ON f4_.id = f5_.seo_id WHERE f0_.page_code = ? AND f0_.site_id = ?
Parameters: [0 => actualite-locale, 1 => 1]
|
0.97 ms (4.75%) |
1 |
SELECT f0_.id AS id_0, f0_.position AS position_1, f0_.created AS created_2, f0_.updated AS updated_3, f0_.domain_name AS domain_name_4, f0_.domain_is_default AS domain_is_default_5, f1_.id AS id_6, f1_.position AS position_7, f1_.created AS created_8, f1_.updated AS updated_9, f1_.site_name AS site_name_10, f1_.site_code AS site_code_11, f1_.site_is_default AS site_is_default_12, f0_.site_id AS site_id_13, f1_.language_id AS language_id_14, f1_.layout_id AS layout_id_15 FROM fxc_domain f0_ INNER JOIN fxc_sites f1_ ON f0_.site_id = f1_.id WHERE f0_.domain_name = ?
Parameters: [0 => www.chasseurs74.fr]
|
0.87 ms (4.23%) |
2 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.created AS created_3, t0.updated AS updated_4, t0.type_name AS type_name_5, t0.type_code AS type_code_6, t0.type_is_active AS type_is_active_7 FROM fxc_block_types t0 WHERE t0.id = ?
Parameters: [0 => 7]
|
0.85 ms (4.15%) |
2 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.created AS created_3, t0.updated AS updated_4, t0.col_type AS col_type_5, t0.col_class AS col_class_6, t0.zone_id AS zone_id_7 FROM fxc_zones_cols t0 WHERE t0.zone_id = ? ORDER BY t0.position ASC
Parameters: [0 => 111]
|
0.84 ms (4.10%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.created AS created_3, t0.updated AS updated_4, t0.google_analytic AS google_analytic_5, t0.webmaster_tool AS webmaster_tool_6, t0.analytic_meta AS analytic_meta_7, t0.analytic_script AS analytic_script_8, t0.site_id AS site_id_9, t10.id AS id_11, t10.media_index AS media_index_12, t10.media_description AS media_description_13, t10.position AS position_14, t10.media_zoom AS media_zoom_15, t10.media_display_legend AS media_display_legend_16, t10.media_id AS media_id_17, t10.block_id AS block_id_18, t10.news_id AS news_id_19, t10.page_id AS page_id_20, t10.gallery_id AS gallery_id_21, t10.slide_id AS slide_id_22, t10.grouping_id AS grouping_id_23, t10.banner_id AS banner_id_24, t10.seo_id AS seo_id_25, t10.analytic_id AS analytic_id_26 FROM fxc_seo_analytics t0 LEFT JOIN fxc_medias_relations t10 ON t10.analytic_id = t0.id WHERE t0.site_id = ?
Parameters: [0 => 1]
|
0.78 ms (3.80%) |
1 |
SELECT f0_.id AS id_0, f0_.position AS position_1, f0_.created AS created_2, f0_.updated AS updated_3, f0_.page_name AS page_name_4, f0_.page_name_back AS page_name_back_5, f0_.page_code AS page_code_6, f0_.page_is_default AS page_is_default_7, f0_.page_level AS page_level_8, f0_.online AS online_9, f0_.page_plan AS page_plan_10, f0_.page_arbo AS page_arbo_11, f1_.id AS id_12, f1_.position AS position_13, f1_.created AS created_14, f1_.updated AS updated_15, f1_.layout_name AS layout_name_16, f1_.layout_code AS layout_code_17, f2_.id AS id_18, f2_.position AS position_19, f2_.created AS created_20, f2_.updated AS updated_21, f2_.template_name AS template_name_22, f2_.template_code AS template_code_23, f2_.template_width AS template_width_24, f2_.template_padding AS template_padding_25, f2_.template_is_active AS template_is_active_26, f3_.id AS id_27, f3_.media_index AS media_index_28, f3_.media_description AS media_description_29, f3_.position AS position_30, f3_.media_zoom AS media_zoom_31, f3_.media_display_legend AS media_display_legend_32, f4_.id AS id_33, f4_.position AS position_34, f4_.created AS created_35, f4_.updated AS updated_36, f4_.meta_title AS meta_title_37, f4_.meta_description AS meta_description_38, f4_.meta_canonical AS meta_canonical_39, f4_.meta_index AS meta_index_40, f4_.meta_follow AS meta_follow_41, f4_.meta_og_title AS meta_og_title_42, f4_.meta_og_description AS meta_og_description_43, f5_.id AS id_44, f5_.media_index AS media_index_45, f5_.media_description AS media_description_46, f5_.position AS position_47, f5_.media_zoom AS media_zoom_48, f5_.media_display_legend AS media_display_legend_49, f0_.layout_id AS layout_id_50, f0_.site_id AS site_id_51, f0_.template_id AS template_id_52, f0_.parent_id AS parent_id_53, f3_.media_id AS media_id_54, f3_.block_id AS block_id_55, f3_.news_id AS news_id_56, f3_.page_id AS page_id_57, f3_.gallery_id AS gallery_id_58, f3_.slide_id AS slide_id_59, f3_.grouping_id AS grouping_id_60, f3_.banner_id AS banner_id_61, f3_.seo_id AS seo_id_62, f3_.analytic_id AS analytic_id_63, f4_.page_id AS page_id_64, f5_.media_id AS media_id_65, f5_.block_id AS block_id_66, f5_.news_id AS news_id_67, f5_.page_id AS page_id_68, f5_.gallery_id AS gallery_id_69, f5_.slide_id AS slide_id_70, f5_.grouping_id AS grouping_id_71, f5_.banner_id AS banner_id_72, f5_.seo_id AS seo_id_73, f5_.analytic_id AS analytic_id_74 FROM fxc_pages f0_ LEFT JOIN fxc_layouts f1_ ON f0_.layout_id = f1_.id INNER JOIN fxc_templates f2_ ON f0_.template_id = f2_.id LEFT JOIN fxc_medias_relations f3_ ON f0_.id = f3_.page_id LEFT JOIN fxc_seo f4_ ON f0_.id = f4_.page_id LEFT JOIN fxc_medias_relations f5_ ON f4_.id = f5_.seo_id WHERE f0_.page_is_default = ? AND f0_.site_id = ?
Parameters: [0 => 1, 1 => 1]
|
0.67 ms (3.26%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.created AS created_3, t0.updated AS updated_4, t0.action_module AS action_module_5, t0.action_bundle AS action_bundle_6, t0.action_entity AS action_entity_7, t0.action_name AS action_name_8, t0.action_code AS action_code_9, t0.action_filter AS action_filter_10, t0.action_view AS action_view_11, t0.role_id AS role_id_12 FROM fxc_actions t0 WHERE t0.id = ?
Parameters: [0 => 11]
|
0.65 ms (3.17%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.created AS created_3, t0.updated AS updated_4, t0.sociawall_is_active AS sociawall_is_active_5, t0.facebook_id AS facebook_id_6, t0.facebook_app_id AS facebook_app_id_7, t0.facebook_app_secret AS facebook_app_secret_8, t0.facebook_access_token AS facebook_access_token_9, t0.twitter_id AS twitter_id_10, t0.twitter_consumer_key AS twitter_consumer_key_11, t0.twitter_consumer_secret AS twitter_consumer_secret_12, t0.twitter_oauth_access_token AS twitter_oauth_access_token_13, t0.twitter_oauth_access_token_secret AS twitter_oauth_access_token_secret_14, t0.instagram_access_token AS instagram_access_token_15, t0.instagram_client_id AS instagram_client_id_16, t0.instagram_user_feed AS instagram_user_feed_17, t0.google_api_key AS google_api_key_18, t0.youtube_api_key AS youtube_api_key_19, t0.youtube_id AS youtube_id_20, t0.site_id AS site_id_21 FROM fxc_seo_socialwall t0 WHERE t0.site_id = ?
Parameters: [0 => 1]
|
0.65 ms (3.16%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.created AS created_3, t0.updated AS updated_4, t0.media_file AS media_file_5, t0.media_description AS media_description_6, t0.media_type AS media_type_7, t0.folder_id AS folder_id_8 FROM fxc_medias t0 WHERE t0.id = ?
Parameters: [0 => 936]
|
0.60 ms (2.94%) |
1 |
SELECT f0_.id AS id_0, f0_.position AS position_1, f0_.created AS created_2, f0_.updated AS updated_3, f0_.site_name AS site_name_4, f0_.site_code AS site_code_5, f0_.site_is_default AS site_is_default_6, f1_.id AS id_7, f1_.position AS position_8, f1_.created AS created_9, f1_.updated AS updated_10, f1_.language_name AS language_name_11, f1_.language_code AS language_code_12, f1_.language_locale AS language_locale_13, f2_.id AS id_14, f2_.position AS position_15, f2_.created AS created_16, f2_.updated AS updated_17, f2_.google_analytic AS google_analytic_18, f2_.webmaster_tool AS webmaster_tool_19, f2_.analytic_meta AS analytic_meta_20, f2_.analytic_script AS analytic_script_21, f3_.id AS id_22, f3_.media_index AS media_index_23, f3_.media_description AS media_description_24, f3_.position AS position_25, f3_.media_zoom AS media_zoom_26, f3_.media_display_legend AS media_display_legend_27, f0_.language_id AS language_id_28, f0_.layout_id AS layout_id_29, f2_.site_id AS site_id_30, f3_.media_id AS media_id_31, f3_.block_id AS block_id_32, f3_.news_id AS news_id_33, f3_.page_id AS page_id_34, f3_.gallery_id AS gallery_id_35, f3_.slide_id AS slide_id_36, f3_.grouping_id AS grouping_id_37, f3_.banner_id AS banner_id_38, f3_.seo_id AS seo_id_39, f3_.analytic_id AS analytic_id_40 FROM fxc_sites f0_ INNER JOIN fxc_languages f1_ ON f0_.language_id = f1_.id LEFT JOIN fxc_seo_analytics f2_ ON f0_.id = f2_.site_id LEFT JOIN fxc_medias_relations f3_ ON f2_.id = f3_.analytic_id WHERE f0_.id = ?
Parameters: [0 => 1]
|
0.51 ms (2.49%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.created AS created_3, t0.updated AS updated_4, t0.group_name AS group_name_5 FROM fxc_groups t0 INNER JOIN fxc_pages_groups_front ON t0.id = fxc_pages_groups_front.group_id WHERE fxc_pages_groups_front.page_id = ?
Parameters: [0 => 26]
|
0.38 ms (1.85%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.created AS created_3, t0.updated AS updated_4, t0.zone_class AS zone_class_5, t0.zone_width AS zone_width_6, t0.zone_crop AS zone_crop_7, t0.zone_hide_mobile AS zone_hide_mobile_8, t0.page_id AS page_id_9 FROM fxc_zones t0 WHERE t0.page_id = ? ORDER BY t0.position ASC
Parameters: [0 => 26]
|
0.36 ms (1.75%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.created AS created_3, t0.updated AS updated_4, t0.domain_name AS domain_name_5, t0.domain_is_default AS domain_is_default_6, t0.site_id AS site_id_7 FROM fxc_domain t0 WHERE t0.site_id = ? AND t0.domain_is_default = ? LIMIT 1
Parameters: [0 => 1, 1 => 1]
|
0.29 ms (1.39%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.created AS created_3, t0.updated AS updated_4, t0.language_name AS language_name_5, t0.language_code AS language_code_6, t0.language_locale AS language_locale_7 FROM fxc_languages t0 WHERE t0.id = ?
Parameters: [0 => 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 |
---|---|
Felix\CoreBundle\Entity\Entity | No errors. |
Felix\CoreBundle\Entity\Domain | No errors. |
Felix\CoreBundle\Entity\Site | No errors. |
Felix\CoreBundle\Entity\Language | No errors. |
Felix\CoreBundle\Entity\Layout | No errors. |
Felix\CoreBundle\Entity\Template | No errors. |
Felix\CoreBundle\Entity\Page | No errors. |
Felix\MenuBundle\Entity\Menu | No errors. |
Felix\SliderBundle\Entity\Slider | No errors. |
Felix\ContactBundle\Entity\Contact | No errors. |
Felix\ContactBundle\Entity\Receiver | No errors. |
Felix\UserBundle\Entity\Group | No errors. |
Felix\MapsBundle\Entity\Map | No errors. |
Felix\MapsBundle\Entity\Grouping | No errors. |
Felix\SEOBundle\Entity\Analytic | No errors. |
Felix\MediaBundle\Entity\MediaRelation | No errors. |
Felix\MediaBundle\Entity\Media | No errors. |
Felix\CoreBundle\Entity\Block | No errors. |
Felix\NewsBundle\Entity\News | No errors. |
Felix\MediaBundle\Entity\Gallery | No errors. |
Felix\SliderBundle\Entity\Slide | No errors. |
Felix\BannerBundle\Entity\Banner | No errors. |
Felix\SEOBundle\Entity\SEO | No errors. |
Felix\FormBundle\Entity\Form | No errors. |
Felix\SEOBundle\Entity\Redirection | No errors. |
Felix\SEOBundle\Entity\Socialwall | No errors. |
Felix\CoreBundle\Entity\Zone | No errors. |
Felix\MenuBundle\Entity\Link | No errors. |
Felix\MapsBundle\Entity\Point | No errors. |
Felix\CoreBundle\Entity\Col | No errors. |
Felix\CoreBundle\Entity\BlockType | No errors. |
Felix\CoreBundle\Entity\Action | No errors. |
Felix\UserBundle\Entity\Role | No errors. |
Felix\NewsBundle\Entity\Category | No errors. |
Felix\MediaBundle\Entity\Folder | No errors. |