Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.84 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
0.53 ms (63.49%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.slogan AS slogan_3, t0.text_main AS text_main_4, t0.text_secondary AS text_secondary_5, t0.contact_email AS contact_email_6, t0.contact_messenger AS contact_messenger_7, t0.contact_linkedin AS contact_linkedin_8, t0.contact_phone AS contact_phone_9, t0.contact_whatsapp AS contact_whatsapp_10, t0.contact_facebook AS contact_facebook_11, t0.address AS address_12, t0.website AS website_13, t0.is_fictive AS is_fictive_14, t0.created_at AS created_at_15, t0.slug AS slug_16, t0.theme AS theme_17, t0.text_style AS text_style_18, t0.slug_tech AS slug_tech_19, t0.published AS published_20, t0.main_background AS main_background_21, t0.slug_updated_at AS slug_updated_at_22, t0.id_user AS id_user_23, t0.id_picture_main AS id_picture_main_24, t0.id_picture_secondary AS id_picture_secondary_25, t0.id_media AS id_media_26, t0.id_media_cover AS id_media_cover_27, t0.id_media_advertisement AS id_media_advertisement_28, t0.id_vitrine_config AS id_vitrine_config_29 FROM vitrine t0 WHERE t0.slug = ? LIMIT 1 Parameters: [`"aws-config.js"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slogan AS slogan_3, t0.text_main AS text_main_4, t0.text_secondary AS text_secondary_5, t0.contact_email AS contact_email_6, t0.contact_messenger AS contact_messenger_7, t0.contact_linkedin AS contact_linkedin_8, t0.contact_phone AS contact_phone_9, t0.contact_whatsapp AS contact_whatsapp_10, t0.contact_facebook AS contact_facebook_11, t0.address AS address_12, t0.website AS website_13, t0.is_fictive AS is_fictive_14, t0.created_at AS created_at_15, t0.slug AS slug_16, t0.theme AS theme_17, t0.text_style AS text_style_18, t0.slug_tech AS slug_tech_19, t0.published AS published_20, t0.main_background AS main_background_21, t0.slug_updated_at AS slug_updated_at_22, t0.id_user AS id_user_23, t0.id_picture_main AS id_picture_main_24, t0.id_picture_secondary AS id_picture_secondary_25, t0.id_media AS id_media_26, t0.id_media_cover AS id_media_cover_27, t0.id_media_advertisement AS id_media_advertisement_28, t0.id_vitrine_config AS id_vitrine_config_29 FROM vitrine t0 WHERE t0.slug = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.slogan AS slogan_3, t0.text_main AS text_main_4, t0.text_secondary AS text_secondary_5, t0.contact_email AS contact_email_6, t0.contact_messenger AS contact_messenger_7, t0.contact_linkedin AS contact_linkedin_8, t0.contact_phone AS contact_phone_9, t0.contact_whatsapp AS contact_whatsapp_10, t0.contact_facebook AS contact_facebook_11, t0.address AS address_12, t0.website AS website_13, t0.is_fictive AS is_fictive_14, t0.created_at AS created_at_15, t0.slug AS slug_16, t0.theme AS theme_17, t0.text_style AS text_style_18, t0.slug_tech AS slug_tech_19, t0.published AS published_20, t0.main_background AS main_background_21, t0.slug_updated_at AS slug_updated_at_22, t0.id_user AS id_user_23, t0.id_picture_main AS id_picture_main_24, t0.id_picture_secondary AS id_picture_secondary_25, t0.id_media AS id_media_26, t0.id_media_cover AS id_media_cover_27, t0.id_media_advertisement AS id_media_advertisement_28, t0.id_vitrine_config AS id_vitrine_config_29 FROM vitrine t0 WHERE t0.slug = 'aws-config.js' LIMIT 1;
0.31 ms (36.51%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.slogan AS slogan_3, t0.text_main AS text_main_4, t0.text_secondary AS text_secondary_5, t0.contact_email AS contact_email_6, t0.contact_messenger AS contact_messenger_7, t0.contact_linkedin AS contact_linkedin_8, t0.contact_phone AS contact_phone_9, t0.contact_whatsapp AS contact_whatsapp_10, t0.contact_facebook AS contact_facebook_11, t0.address AS address_12, t0.website AS website_13, t0.is_fictive AS is_fictive_14, t0.created_at AS created_at_15, t0.slug AS slug_16, t0.theme AS theme_17, t0.text_style AS text_style_18, t0.slug_tech AS slug_tech_19, t0.published AS published_20, t0.main_background AS main_background_21, t0.slug_updated_at AS slug_updated_at_22, t0.id_user AS id_user_23, t0.id_picture_main AS id_picture_main_24, t0.id_picture_secondary AS id_picture_secondary_25, t0.id_media AS id_media_26, t0.id_media_cover AS id_media_cover_27, t0.id_media_advertisement AS id_media_advertisement_28, t0.id_vitrine_config AS id_vitrine_config_29 FROM vitrine t0 WHERE t0.slug_tech = ? LIMIT 1 Parameters: [`"aws-config.js"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slogan AS slogan_3, t0.text_main AS text_main_4, t0.text_secondary AS text_secondary_5, t0.contact_email AS contact_email_6, t0.contact_messenger AS contact_messenger_7, t0.contact_linkedin AS contact_linkedin_8, t0.contact_phone AS contact_phone_9, t0.contact_whatsapp AS contact_whatsapp_10, t0.contact_facebook AS contact_facebook_11, t0.address AS address_12, t0.website AS website_13, t0.is_fictive AS is_fictive_14, t0.created_at AS created_at_15, t0.slug AS slug_16, t0.theme AS theme_17, t0.text_style AS text_style_18, t0.slug_tech AS slug_tech_19, t0.published AS published_20, t0.main_background AS main_background_21, t0.slug_updated_at AS slug_updated_at_22, t0.id_user AS id_user_23, t0.id_picture_main AS id_picture_main_24, t0.id_picture_secondary AS id_picture_secondary_25, t0.id_media AS id_media_26, t0.id_media_cover AS id_media_cover_27, t0.id_media_advertisement AS id_media_advertisement_28, t0.id_vitrine_config AS id_vitrine_config_29 FROM vitrine t0 WHERE t0.slug_tech = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.slogan AS slogan_3, t0.text_main AS text_main_4, t0.text_secondary AS text_secondary_5, t0.contact_email AS contact_email_6, t0.contact_messenger AS contact_messenger_7, t0.contact_linkedin AS contact_linkedin_8, t0.contact_phone AS contact_phone_9, t0.contact_whatsapp AS contact_whatsapp_10, t0.contact_facebook AS contact_facebook_11, t0.address AS address_12, t0.website AS website_13, t0.is_fictive AS is_fictive_14, t0.created_at AS created_at_15, t0.slug AS slug_16, t0.theme AS theme_17, t0.text_style AS text_style_18, t0.slug_tech AS slug_tech_19, t0.published AS published_20, t0.main_background AS main_background_21, t0.slug_updated_at AS slug_updated_at_22, t0.id_user AS id_user_23, t0.id_picture_main AS id_picture_main_24, t0.id_picture_secondary AS id_picture_secondary_25, t0.id_media AS id_media_26, t0.id_media_cover AS id_media_cover_27, t0.id_media_advertisement AS id_media_advertisement_28, t0.id_vitrine_config AS id_vitrine_config_29 FROM vitrine t0 WHERE t0.slug_tech = 'aws-config.js' LIMIT 1;

Time▼

Count

Info

0.53 ms
(63.49%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slogan AS slogan_3, t0.text_main AS text_main_4, t0.text_secondary AS text_secondary_5, t0.contact_email AS contact_email_6, t0.contact_messenger AS contact_messenger_7, t0.contact_linkedin AS contact_linkedin_8, t0.contact_phone AS contact_phone_9, t0.contact_whatsapp AS contact_whatsapp_10, t0.contact_facebook AS contact_facebook_11, t0.address AS address_12, t0.website AS website_13, t0.is_fictive AS is_fictive_14, t0.created_at AS created_at_15, t0.slug AS slug_16, t0.theme AS theme_17, t0.text_style AS text_style_18, t0.slug_tech AS slug_tech_19, t0.published AS published_20, t0.main_background AS main_background_21, t0.slug_updated_at AS slug_updated_at_22, t0.id_user AS id_user_23, t0.id_picture_main AS id_picture_main_24, t0.id_picture_secondary AS id_picture_secondary_25, t0.id_media AS id_media_26, t0.id_media_cover AS id_media_cover_27, t0.id_media_advertisement AS id_media_advertisement_28, t0.id_vitrine_config AS id_vitrine_config_29 FROM vitrine t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "aws-config.js"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slogan AS slogan_3,
  t0.text_main AS text_main_4,
  t0.text_secondary AS text_secondary_5,
  t0.contact_email AS contact_email_6,
  t0.contact_messenger AS contact_messenger_7,
  t0.contact_linkedin AS contact_linkedin_8,
  t0.contact_phone AS contact_phone_9,
  t0.contact_whatsapp AS contact_whatsapp_10,
  t0.contact_facebook AS contact_facebook_11,
  t0.address AS address_12,
  t0.website AS website_13,
  t0.is_fictive AS is_fictive_14,
  t0.created_at AS created_at_15,
  t0.slug AS slug_16,
  t0.theme AS theme_17,
  t0.text_style AS text_style_18,
  t0.slug_tech AS slug_tech_19,
  t0.published AS published_20,
  t0.main_background AS main_background_21,
  t0.slug_updated_at AS slug_updated_at_22,
  t0.id_user AS id_user_23,
  t0.id_picture_main AS id_picture_main_24,
  t0.id_picture_secondary AS id_picture_secondary_25,
  t0.id_media AS id_media_26,
  t0.id_media_cover AS id_media_cover_27,
  t0.id_media_advertisement AS id_media_advertisement_28,
  t0.id_vitrine_config AS id_vitrine_config_29
FROM
  vitrine t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slogan AS slogan_3, t0.text_main AS text_main_4, t0.text_secondary AS text_secondary_5, t0.contact_email AS contact_email_6, t0.contact_messenger AS contact_messenger_7, t0.contact_linkedin AS contact_linkedin_8, t0.contact_phone AS contact_phone_9, t0.contact_whatsapp AS contact_whatsapp_10, t0.contact_facebook AS contact_facebook_11, t0.address AS address_12, t0.website AS website_13, t0.is_fictive AS is_fictive_14, t0.created_at AS created_at_15, t0.slug AS slug_16, t0.theme AS theme_17, t0.text_style AS text_style_18, t0.slug_tech AS slug_tech_19, t0.published AS published_20, t0.main_background AS main_background_21, t0.slug_updated_at AS slug_updated_at_22, t0.id_user AS id_user_23, t0.id_picture_main AS id_picture_main_24, t0.id_picture_secondary AS id_picture_secondary_25, t0.id_media AS id_media_26, t0.id_media_cover AS id_media_cover_27, t0.id_media_advertisement AS id_media_advertisement_28, t0.id_vitrine_config AS id_vitrine_config_29 FROM vitrine t0 WHERE t0.slug = 'aws-config.js' LIMIT 1;

0.31 ms
(36.51%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slogan AS slogan_3, t0.text_main AS text_main_4, t0.text_secondary AS text_secondary_5, t0.contact_email AS contact_email_6, t0.contact_messenger AS contact_messenger_7, t0.contact_linkedin AS contact_linkedin_8, t0.contact_phone AS contact_phone_9, t0.contact_whatsapp AS contact_whatsapp_10, t0.contact_facebook AS contact_facebook_11, t0.address AS address_12, t0.website AS website_13, t0.is_fictive AS is_fictive_14, t0.created_at AS created_at_15, t0.slug AS slug_16, t0.theme AS theme_17, t0.text_style AS text_style_18, t0.slug_tech AS slug_tech_19, t0.published AS published_20, t0.main_background AS main_background_21, t0.slug_updated_at AS slug_updated_at_22, t0.id_user AS id_user_23, t0.id_picture_main AS id_picture_main_24, t0.id_picture_secondary AS id_picture_secondary_25, t0.id_media AS id_media_26, t0.id_media_cover AS id_media_cover_27, t0.id_media_advertisement AS id_media_advertisement_28, t0.id_vitrine_config AS id_vitrine_config_29 FROM vitrine t0 WHERE t0.slug_tech = ? LIMIT 1

Parameters:

[
  "aws-config.js"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slogan AS slogan_3,
  t0.text_main AS text_main_4,
  t0.text_secondary AS text_secondary_5,
  t0.contact_email AS contact_email_6,
  t0.contact_messenger AS contact_messenger_7,
  t0.contact_linkedin AS contact_linkedin_8,
  t0.contact_phone AS contact_phone_9,
  t0.contact_whatsapp AS contact_whatsapp_10,
  t0.contact_facebook AS contact_facebook_11,
  t0.address AS address_12,
  t0.website AS website_13,
  t0.is_fictive AS is_fictive_14,
  t0.created_at AS created_at_15,
  t0.slug AS slug_16,
  t0.theme AS theme_17,
  t0.text_style AS text_style_18,
  t0.slug_tech AS slug_tech_19,
  t0.published AS published_20,
  t0.main_background AS main_background_21,
  t0.slug_updated_at AS slug_updated_at_22,
  t0.id_user AS id_user_23,
  t0.id_picture_main AS id_picture_main_24,
  t0.id_picture_secondary AS id_picture_secondary_25,
  t0.id_media AS id_media_26,
  t0.id_media_cover AS id_media_cover_27,
  t0.id_media_advertisement AS id_media_advertisement_28,
  t0.id_vitrine_config AS id_vitrine_config_29
FROM
  vitrine t0
WHERE
  t0.slug_tech = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slogan AS slogan_3, t0.text_main AS text_main_4, t0.text_secondary AS text_secondary_5, t0.contact_email AS contact_email_6, t0.contact_messenger AS contact_messenger_7, t0.contact_linkedin AS contact_linkedin_8, t0.contact_phone AS contact_phone_9, t0.contact_whatsapp AS contact_whatsapp_10, t0.contact_facebook AS contact_facebook_11, t0.address AS address_12, t0.website AS website_13, t0.is_fictive AS is_fictive_14, t0.created_at AS created_at_15, t0.slug AS slug_16, t0.theme AS theme_17, t0.text_style AS text_style_18, t0.slug_tech AS slug_tech_19, t0.published AS published_20, t0.main_background AS main_background_21, t0.slug_updated_at AS slug_updated_at_22, t0.id_user AS id_user_23, t0.id_picture_main AS id_picture_main_24, t0.id_picture_secondary AS id_picture_secondary_25, t0.id_media AS id_media_26, t0.id_media_cover AS id_media_cover_27, t0.id_media_advertisement AS id_media_advertisement_28, t0.id_vitrine_config AS id_vitrine_config_29 FROM vitrine t0 WHERE t0.slug_tech = 'aws-config.js' LIMIT 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\Vitrine	No errors.
App\Entity\User	The field App\Entity\User#contacts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Contact#createdBy does not contain the required 'inversedBy="contacts"' attribute. The association App\Entity\User#mailingHistories refers to the owning side field App\Entity\MailingHistory#user which does not exist. The field App\Entity\User#jobProfile is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\JobProfile#user does not contain the required 'inversedBy="jobProfile"' attribute.
App\Entity\Media	No errors.
App\Entity\VitrineConfig	No errors.

Symfony Profiler

GET https://test-tinady.developa.net/aws-config.js

Configuration Settings

Theme