Query Metrics
20
Database Queries
19
Different statements
13.00 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.22 ms |
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters: []
|
| 2 | 0.82 ms |
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]
|
| 3 | 0.96 ms |
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]
|
| 4 | 0.62 ms |
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]
|
| 5 | 0.41 ms |
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]
|
| 6 | 0.34 ms |
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]
|
| 7 | 0.68 ms |
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]
|
| 8 | 0.95 ms |
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]
|
| 9 | 1.14 ms |
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 => je-veux-devenir-chasseur, 1 => 1]
|
| 10 | 0.39 ms |
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 => 19]
|
| 11 | 0.38 ms |
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 => 19]
|
| 12 | 0.43 ms |
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 => 107]
|
| 13 | 0.67 ms |
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 => 205]
|
| 14 | 0.34 ms |
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]
|
| 15 | 0.40 ms |
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 => 331]
|
| 16 | 0.69 ms |
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 => 1456]
|
| 17 | 0.38 ms |
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, f0_.site_id AS site_id_6 FROM fxc_domain f0_ WHERE f0_.domain_name = ? AND f0_.site_id = ?
Parameters: [0 => www.chasseurs74.fr, 1 => 1]
|
| 18 | 0.41 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.created AS created_3, t0.updated AS updated_4, t0.menu_name AS menu_name_5, t0.menu_code AS menu_code_6, t0.menu_is_default AS menu_is_default_7, t0.site_id AS site_id_8 FROM fxc_menus t0 WHERE t0.menu_is_default = ? AND t0.site_id = ? LIMIT 1
Parameters: [0 => 1, 1 => 1]
|
| 19 | 1.34 ms |
SELECT f0_.id AS id_0, f0_.position AS position_1, f0_.created AS created_2, f0_.updated AS updated_3, f0_.link_name AS link_name_4, f0_.link_url AS link_url_5, f0_.link_level AS link_level_6, f0_.link_target AS link_target_7, f1_.id AS id_8, f1_.position AS position_9, f1_.created AS created_10, f1_.updated AS updated_11, f1_.page_name AS page_name_12, f1_.page_name_back AS page_name_back_13, f1_.page_code AS page_code_14, f1_.page_is_default AS page_is_default_15, f1_.page_level AS page_level_16, f1_.online AS online_17, f1_.page_plan AS page_plan_18, f1_.page_arbo AS page_arbo_19, f2_.id AS id_20, f2_.media_index AS media_index_21, f2_.media_description AS media_description_22, f2_.position AS position_23, f2_.media_zoom AS media_zoom_24, f2_.media_display_legend AS media_display_legend_25, f3_.id AS id_26, f3_.position AS position_27, f3_.created AS created_28, f3_.updated AS updated_29, f3_.meta_title AS meta_title_30, f3_.meta_description AS meta_description_31, f3_.meta_canonical AS meta_canonical_32, f3_.meta_index AS meta_index_33, f3_.meta_follow AS meta_follow_34, f3_.meta_og_title AS meta_og_title_35, f3_.meta_og_description AS meta_og_description_36, f4_.id AS id_37, f4_.media_index AS media_index_38, f4_.media_description AS media_description_39, f4_.position AS position_40, f4_.media_zoom AS media_zoom_41, f4_.media_display_legend AS media_display_legend_42, f0_.page_id AS page_id_43, f0_.parent_id AS parent_id_44, f0_.menu_id AS menu_id_45, f1_.layout_id AS layout_id_46, f1_.site_id AS site_id_47, f1_.template_id AS template_id_48, f1_.parent_id AS parent_id_49, f2_.media_id AS media_id_50, f2_.block_id AS block_id_51, f2_.news_id AS news_id_52, f2_.page_id AS page_id_53, f2_.gallery_id AS gallery_id_54, f2_.slide_id AS slide_id_55, f2_.grouping_id AS grouping_id_56, f2_.banner_id AS banner_id_57, f2_.seo_id AS seo_id_58, f2_.analytic_id AS analytic_id_59, f3_.page_id AS page_id_60, f4_.media_id AS media_id_61, f4_.block_id AS block_id_62, f4_.news_id AS news_id_63, f4_.page_id AS page_id_64, f4_.gallery_id AS gallery_id_65, f4_.slide_id AS slide_id_66, f4_.grouping_id AS grouping_id_67, f4_.banner_id AS banner_id_68, f4_.seo_id AS seo_id_69, f4_.analytic_id AS analytic_id_70 FROM fxc_menus_links f0_ LEFT JOIN fxc_pages f1_ ON f0_.page_id = f1_.id LEFT JOIN fxc_medias_relations f2_ ON f1_.id = f2_.page_id LEFT JOIN fxc_seo f3_ ON f1_.id = f3_.page_id LEFT JOIN fxc_medias_relations f4_ ON f3_.id = f4_.seo_id WHERE f0_.menu_id = ? ORDER BY f0_.position ASC
Parameters: [0 => 1]
|
| 20 | 0.43 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.created AS created_3, t0.updated AS updated_4, t0.link_name AS link_name_5, t0.link_url AS link_url_6, t0.link_level AS link_level_7, t0.link_target AS link_target_8, t0.page_id AS page_id_9, t0.parent_id AS parent_id_10, t0.menu_id AS menu_id_11 FROM fxc_menus_links t0 WHERE t0.menu_id = ? AND t0.page_id = ? LIMIT 1
Parameters: [0 => 1, 1 => 19]
|
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\MediaBundle\Entity\Folder | No errors. |