http://sfmg.asb-digital.fr/sitemap.xml

Method
GET
HTTP Status
200
IP
216.73.216.135
Profiled on
Token
2bdfa2

Query Metrics

20 Database Queries
11 Different statements
8.57 ms Query time
15 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
1.93 ms
(22.58%) 		5 
SELECT t0.id AS id_1, t0.accordeon AS accordeon_2, t0.title AS title_3, t0.position AS position_4, t0.about_id AS about_id_5, t0.composition_id AS composition_id_6, t0.full_member_page_id AS full_member_page_id_7, t0.departement_id AS departement_id_8, t0.partenaire_page_id AS partenaire_page_id_9, t0.page_id AS page_id_10, t0.publication_id AS publication_id_11, t0.publication_page_id AS publication_page_id_12, t0.these_id AS these_id_13, t0.these_page_id AS these_page_id_14, t0.definition_page_id AS definition_page_id_15, t0.actuality_id AS actuality_id_16, t0.join_page_id AS join_page_id_17, t0.manuel_page_id AS manuel_page_id_18 FROM section t0 WHERE t0.publication_id IN (?)
Parameters: 
[
  [
    1
    1763
    1764
    1765
    1766
    1768
    1769
    1770
    1771
    1772
    1773
    1774
    1775
    1776
    1777
    1778
    1779
    1780
    1781
    1782
    1783
    1784
    1785
    1786
    1787
    1788
    1789
    1790
    1791
    1792
    1793
    1794
    1795
    1796
    1797
    1798
    1799
    1800
    1801
    1802
    1803
    1804
    1805
    1806
    1807
    1808
    1809
    1810
    1811
    1812
    1813
    1814
    1815
    1816
    1817
    1818
    1819
    1820
    1821
    1822
    1823
    1824
    1825
    1826
    1827
    1828
    1829
    1830
    1831
    1832
    1833
    1834
    1835
    1836
    1837
    1838
    1839
    1840
    1841
    1842
    1843
    1844
    1845
    1846
    1847
    1848
    1849
    1850
    1851
    1852
    1853
    1854
    1855
    1856
    1857
    1858
    1859
    1860
    1861
    1862
  ]
]
View formatted query    View runnable query    Explain query
1.13 ms
(13.15%) 		3 
SELECT t0.id AS id_1, t0.accordeon AS accordeon_2, t0.title AS title_3, t0.position AS position_4, t0.about_id AS about_id_5, t0.composition_id AS composition_id_6, t0.full_member_page_id AS full_member_page_id_7, t0.departement_id AS departement_id_8, t0.partenaire_page_id AS partenaire_page_id_9, t0.page_id AS page_id_10, t0.publication_id AS publication_id_11, t0.publication_page_id AS publication_page_id_12, t0.these_id AS these_id_13, t0.these_page_id AS these_page_id_14, t0.definition_page_id AS definition_page_id_15, t0.actuality_id AS actuality_id_16, t0.join_page_id AS join_page_id_17, t0.manuel_page_id AS manuel_page_id_18 FROM section t0 WHERE t0.actuality_id IN (?)
Parameters: 
[
  [
    1
    2763
    2764
    2765
    2766
    2767
    2768
    2769
    2770
    2771
    2772
    2773
    2774
    2775
    2776
    2777
    2778
    2779
    2780
    2781
    2782
    2783
    2784
    2785
    2786
    2787
    2788
    2789
    2790
    2791
    2792
    2793
    2794
    2795
    2796
    2797
    2798
    2799
    2800
    2801
    2802
    2803
    2804
    2805
    2806
    2807
    2808
    2809
    2810
    2811
    2812
    2813
    2814
    2815
    2816
    2817
    2818
    2819
    2820
    2821
    2822
    2823
    2824
    2825
    2826
    2827
    2828
    2829
    2830
    2831
    2832
    2833
    2834
    2835
    2836
    2837
    2838
    2839
    2840
    2841
    2842
    2843
    2844
    2845
    2846
    2847
    2848
    2849
    2850
    2851
    2852
    2853
    2854
    2855
    2856
    2857
    2858
    2859
    2860
    2861
  ]
]
View formatted query    View runnable query    Explain query
1.12 ms
(13.06%) 		1 
SELECT t0.id AS id_1, t0.title AS title_2, t0.author AS author_3, t0.quote AS quote_4, t0.date AS date_5, t0.activate AS activate_6, t0.about_associate AS about_associate_7, t0.composition_associate AS composition_associate_8, t0.full_member_associate AS full_member_associate_9, t0.departement_associate AS departement_associate_10, t0.partner_associate AS partner_associate_11, t0.publication_associate AS publication_associate_12, t0.these_associate AS these_associate_13, t0.actuality_associate AS actuality_associate_14, t0.definition_associate AS definition_associate_15, t0.manuel_associate AS manuel_associate_16, t0.join_associate AS join_associate_17, t0.old_id AS old_id_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.slug AS slug_21, t0.about_id AS about_id_22, t0.actuality_id AS actuality_id_23, t0.composition_id AS composition_id_24, t0.definition_page_id AS definition_page_id_25, t0.departement_id AS departement_id_26, t0.full_member_page_id AS full_member_page_id_27, t0.join_page_id AS join_page_id_28, t0.page_id AS page_id_29, t0.partenaire_page_id AS partenaire_page_id_30, t0.publication_id AS publication_id_31, t0.publication_page_id AS publication_page_id_32, t0.these_id AS these_id_33, t0.these_page_id AS these_page_id_34, t0.manuel_page_id AS manuel_page_id_35 FROM publication t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.06 ms
(12.34%) 		2 
SELECT t0.id AS id_1, t0.accordeon AS accordeon_2, t0.title AS title_3, t0.position AS position_4, t0.about_id AS about_id_5, t0.composition_id AS composition_id_6, t0.full_member_page_id AS full_member_page_id_7, t0.departement_id AS departement_id_8, t0.partenaire_page_id AS partenaire_page_id_9, t0.page_id AS page_id_10, t0.publication_id AS publication_id_11, t0.publication_page_id AS publication_page_id_12, t0.these_id AS these_id_13, t0.these_page_id AS these_page_id_14, t0.definition_page_id AS definition_page_id_15, t0.actuality_id AS actuality_id_16, t0.join_page_id AS join_page_id_17, t0.manuel_page_id AS manuel_page_id_18 FROM section t0 WHERE t0.these_id IN (?)
Parameters: 
[
  [
    736
    737
    738
    739
    740
    741
    742
    743
    744
    745
    746
    747
    748
    749
    750
    751
    752
    753
    754
    755
    756
    757
    758
    759
    760
    761
    762
    763
    764
    765
    766
    767
    768
    769
    770
    771
    772
    773
    774
    775
    776
    777
    778
    779
    780
    781
    782
    783
    784
    785
    786
    787
    788
    789
    790
    791
    792
    793
    794
    795
    796
    797
    798
    799
    800
    801
    802
    803
    804
    805
    806
    807
    808
    809
    810
    811
    812
    813
    814
    815
    816
    817
    818
    819
    820
    821
    822
    823
    824
    825
    826
    827
    828
    829
    830
    831
    832
    833
    834
    835
  ]
]
View formatted query    View runnable query    Explain query
0.77 ms
(9.03%) 		3 
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.icon_name AS icon_name_4, t0.icon_size AS icon_size_5, t0.icon_updated_at AS icon_updated_at_6, t0.icon_alt AS icon_alt_7, t0.resume AS resume_8, t0.slug AS slug_9, t0.position AS position_10 FROM theme t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.53 ms
(6.21%) 		1 
SELECT t0.id AS id_1, t0.title AS title_2, t0.resume AS resume_3, t0.illustration_name AS illustration_name_4, t0.illustration_size AS illustration_size_5, t0.illustration_updated_at AS illustration_updated_at_6, t0.illustration_alt AS illustration_alt_7, t0.activate AS activate_8, t0.quote AS quote_9, t0.created_at AS created_at_10, t0.about_associate AS about_associate_11, t0.composition_associate AS composition_associate_12, t0.full_member_associate AS full_member_associate_13, t0.departement_associate AS departement_associate_14, t0.partner_associate AS partner_associate_15, t0.publication_associate AS publication_associate_16, t0.these_associate AS these_associate_17, t0.actuality_associate AS actuality_associate_18, t0.definition_associate AS definition_associate_19, t0.manuel_associate AS manuel_associate_20, t0.join_associate AS join_associate_21, t0.old_id AS old_id_22, t0.meta_title AS meta_title_23, t0.meta_description AS meta_description_24, t0.slug AS slug_25, t0.category_id AS category_id_26, t0.actuality_id AS actuality_id_27, t0.about_id AS about_id_28, t0.composition_id AS composition_id_29, t0.definition_page_id AS definition_page_id_30, t0.departement_id AS departement_id_31, t0.full_member_page_id AS full_member_page_id_32, t0.join_page_id AS join_page_id_33, t0.page_id AS page_id_34, t0.partenaire_page_id AS partenaire_page_id_35, t0.publication_id AS publication_id_36, t0.publication_page_id AS publication_page_id_37, t0.these_id AS these_id_38, t0.these_page_id AS these_page_id_39, t0.homepage_large_id AS homepage_large_id_40, t0.homepage_little_id AS homepage_little_id_41, t0.manuel_page_id AS manuel_page_id_42 FROM actuality t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.49 ms
(5.71%) 		1 
SELECT t0.id AS id_1, t0.title AS title_2, t0.author AS author_3, t0.date AS date_4, t0.sub_title AS sub_title_5, t0.activate AS activate_6, t0.quote AS quote_7, t0.about_associate AS about_associate_8, t0.composition_associate AS composition_associate_9, t0.full_member_associate AS full_member_associate_10, t0.departement_associate AS departement_associate_11, t0.partner_associate AS partner_associate_12, t0.publication_associate AS publication_associate_13, t0.these_associate AS these_associate_14, t0.actuality_associate AS actuality_associate_15, t0.definition_associate AS definition_associate_16, t0.manuel_associate AS manuel_associate_17, t0.join_associate AS join_associate_18, t0.old_id AS old_id_19, t0.meta_title AS meta_title_20, t0.meta_description AS meta_description_21, t0.slug AS slug_22, t0.about_id AS about_id_23, t0.actuality_id AS actuality_id_24, t0.composition_id AS composition_id_25, t0.definition_page_id AS definition_page_id_26, t0.departement_id AS departement_id_27, t0.full_member_page_id AS full_member_page_id_28, t0.join_page_id AS join_page_id_29, t0.page_id AS page_id_30, t0.partenaire_page_id AS partenaire_page_id_31, t0.publication_id AS publication_id_32, t0.publication_page_id AS publication_page_id_33, t0.these_id AS these_id_34, t0.these_page_id AS these_page_id_35, t0.manuel_page_id AS manuel_page_id_36 FROM these t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.46 ms
(5.42%) 		1 
SELECT t0.id AS id_1, t0.accordeon AS accordeon_2, t0.title AS title_3, t0.position AS position_4, t0.about_id AS about_id_5, t0.composition_id AS composition_id_6, t0.full_member_page_id AS full_member_page_id_7, t0.departement_id AS departement_id_8, t0.partenaire_page_id AS partenaire_page_id_9, t0.page_id AS page_id_10, t0.publication_id AS publication_id_11, t0.publication_page_id AS publication_page_id_12, t0.these_id AS these_id_13, t0.these_page_id AS these_page_id_14, t0.definition_page_id AS definition_page_id_15, t0.actuality_id AS actuality_id_16, t0.join_page_id AS join_page_id_17, t0.manuel_page_id AS manuel_page_id_18 FROM section t0 WHERE t0.page_id IN (?)
Parameters: 
[
  [
    1
    2
    3
    4
    5
    6
    7
    9
    16
    17
    18
  ]
]
View formatted query    View runnable query    Explain query
0.45 ms
(5.25%) 		1 
SELECT t0.id AS id_1, t0.theme_publication AS theme_publication_2, t0.title AS title_3, t0.icon_name AS icon_name_4, t0.icon_size AS icon_size_5, t0.icon_updated_at AS icon_updated_at_6, t0.icon_alt AS icon_alt_7, t0.quote AS quote_8, t0.about_associate AS about_associate_9, t0.composition_associate AS composition_associate_10, t0.full_member_associate AS full_member_associate_11, t0.departement_associate AS departement_associate_12, t0.partner_associate AS partner_associate_13, t0.publication_associate AS publication_associate_14, t0.these_associate AS these_associate_15, t0.actuality_associate AS actuality_associate_16, t0.definition_associate AS definition_associate_17, t0.manuel_associate AS manuel_associate_18, t0.join_associate AS join_associate_19, t0.activate AS activate_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22, t0.position AS position_23, t0.slug AS slug_24, t0.theme_id AS theme_id_25, t0.about_id AS about_id_26, t0.actuality_id AS actuality_id_27, t0.composition_id AS composition_id_28, t0.definition_page_id AS definition_page_id_29, t0.departement_id AS departement_id_30, t0.full_member_page_id AS full_member_page_id_31, t0.join_page_id AS join_page_id_32, t0.page_id AS page_id_33, t0.partenaire_page_id AS partenaire_page_id_34, t0.publication_id AS publication_id_35, t0.publication_page_id AS publication_page_id_36, t0.these_id AS these_id_37, t0.these_page_id AS these_page_id_38, t0.manuel_page_id AS manuel_page_id_39 FROM page t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.38 ms
(4.42%) 		1 
SELECT t0.route AS route_1, t0.id AS id_2, t0.page_name AS page_name_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.h1_enabled AS h1_enabled_6, t0.h1 AS h1_7 FROM seopage t0 WHERE t0.route = ? LIMIT 1
Parameters: 
[
  "app_sitemap_front"
]
View formatted query    View runnable query    Explain query
0.24 ms
(2.83%) 		1 
SELECT t0.rna AS rna_1, t0.id AS id_2, t0.phone AS phone_3, t0.email AS email_4, t0.address_street AS address_street_5, t0.zipcode AS zipcode_6, t0.city AS city_7, t0.legal_site_name AS legal_site_name_8, t0.legal_siret AS legal_siret_9, t0.legal_siren AS legal_siren_10, t0.legal_rcs AS legal_rcs_11, t0.legal_address AS legal_address_12, t0.legal_zipcode AS legal_zipcode_13, t0.legal_city AS legal_city_14, t0.legal_phone AS legal_phone_15, t0.legal_email AS legal_email_16, t0.legal_publication_owner AS legal_publication_owner_17, t0.legal_site_url AS legal_site_url_18, t0.default_title AS default_title_19, t0.default_meta_desc AS default_meta_desc_20 FROM site_settings t0
Parameters: 
[]
View formatted query    View runnable query    Explain query

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
Cofondateur\SocleTechniqueBundle\Entity\SEOPage No errors.
App\Entity\SEOPage No errors.
Cofondateur\SocleTechniqueBundle\Entity\SiteSettings No errors.
App\Entity\SiteSettings No errors.
App\Entity\Page
  • The mappings App\Entity\Page#contactPositions and App\Entity\ContactPosition#page are inconsistent with each other.
App\Entity\Theme No errors.
App\Entity\About
  • The mappings App\Entity\About#contactPositions and App\Entity\ContactPosition#about are inconsistent with each other.
App\Entity\Actuality
  • The mappings App\Entity\Actuality#contactPositions and App\Entity\ContactPosition#actuality are inconsistent with each other.
  • The mappings App\Entity\Actuality#homepageLarge and App\Entity\Homepage#actualitiesSliderLarge are inconsistent with each other.
  • The mappings App\Entity\Actuality#homepageLittle and App\Entity\Homepage#actualitiesSliderLittle are inconsistent with each other.
App\Entity\Composition
  • The mappings App\Entity\Composition#contactPositions and App\Entity\ContactPosition#composition are inconsistent with each other.
App\Entity\DefinitionPage
  • The mappings App\Entity\DefinitionPage#contactPositions and App\Entity\ContactPosition#definitionPage are inconsistent with each other.
App\Entity\Departement
  • The mappings App\Entity\Departement#contactPositions and App\Entity\ContactPosition#departement are inconsistent with each other.
App\Entity\FullMemberPage
  • The mappings App\Entity\FullMemberPage#contactPositions and App\Entity\ContactPosition#fullMemberPage are inconsistent with each other.
App\Entity\Join
  • The mappings App\Entity\Join#contactPositions and App\Entity\ContactPosition#joinPage are inconsistent with each other.
App\Entity\PartenairePage
  • The mappings App\Entity\PartenairePage#contactPositions and App\Entity\ContactPosition#partenairePage are inconsistent with each other.
App\Entity\Publication
  • The mappings App\Entity\Publication#contactPositions and App\Entity\ContactPosition#publication are inconsistent with each other.
App\Entity\PublicationPage
  • The mappings App\Entity\PublicationPage#contactPositions and App\Entity\ContactPosition#publicationPage are inconsistent with each other.
App\Entity\These
  • The mappings App\Entity\These#contactPositions and App\Entity\ContactPosition#these are inconsistent with each other.
App\Entity\ThesePage
  • The mappings App\Entity\ThesePage#contactPositions and App\Entity\ContactPosition#thesePage are inconsistent with each other.
App\Entity\ManuelPage
  • The mappings App\Entity\ManuelPage#contactPositions and App\Entity\ContactPosition#manuelPage are inconsistent with each other.
App\Entity\Section No errors.
App\Entity\DocumentAssociate
  • The mappings App\Entity\DocumentAssociate#page and App\Entity\Page#documentAssociates are inconsistent with each other.
  • If association App\Entity\DocumentAssociate#page is many-to-one, then the inversed side App\Entity\Page#documentAssociates has to be one-to-many.
App\Entity\ContactAssociate No errors.
App\Entity\ContactPosition No errors.
App\Entity\Paragraph No errors.
App\Entity\ActualityCategory No errors.
App\Entity\Homepage No errors.
App\Entity\ActualityLabel No errors.
App\Entity\HomepageActuality No errors.