Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.49 ms Query time

7 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.49 ms
(100.00%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.start_at AS start_at_5, t0.end_at AS end_at_6, t0.code AS code_7, t0.open_until AS open_until_8, t0.max_participations AS max_participations_9, t0.contest_description AS contest_description_10, t0.contest_rules_link AS contest_rules_link_11, t0.contest_rules_description AS contest_rules_description_12, t0.privacy_text AS privacy_text_13, t0.presentation AS presentation_14, t0.cgu AS cgu_15, t0.rgpd AS rgpd_16, t0.informations AS informations_17, t0.logo_email AS logo_email_18, t0.is_stop AS is_stop_19, t0.is_active AS is_active_20, t0.big_banner AS big_banner_21, t0.small_banner AS small_banner_22, t0.brand AS brand_23, t0.modality AS modality_24, t0.products_file AS products_file_25, t0.closing_sales AS closing_sales_26, t0.shops_file AS shops_file_27, t0.url AS url_28, t0.cible AS cible_29, t0.justificatifs AS justificatifs_30, t0.is_zip_code AS is_zip_code_31, t0.is_city AS is_city_32, t0.is_list_shop AS is_list_shop_33, t0.number_op AS number_op_34, t0.product_mutliple AS product_mutliple_35, t0.serial_number AS serial_number_36, t0.qr_code AS qr_code_37, t0.is_total_ttc AS is_total_ttc_38, t0.text_serial_number AS text_serial_number_39, t0.legal_notice AS legal_notice_40, t0.purchase_multiple AS purchase_multiple_41, t0.is_cummulable AS is_cummulable_42, t0.is_gift AS is_gift_43, t0.is_odr AS is_odr_44, t0.background AS background_45, t0.is_one_participation_personne AS is_one_participation_personne_46, t0.is_one_participation_product AS is_one_participation_product_47, t0.slug AS slug_48, t0.address_operation AS address_operation_49, t0.original_id AS original_id_50, t0.logo AS logo_51, t0.original_slug AS original_slug_52, t0.hide AS hide_53, t0.sales_points_excel AS sales_points_excel_54, t0.sales_points_pdf AS sales_points_pdf_55, t0.background_color AS background_color_56, t0.user_form_id AS user_form_id_57, t0.purchase_form_id AS purchase_form_id_58, t0.product_form_id AS product_form_id_59, t0.document_form_id AS document_form_id_60, t0.refund_form_id AS refund_form_id_61, t0.optin_form_id AS optin_form_id_62, t0.question_form_id AS question_form_id_63, t0.type_channel_id AS type_channel_id_64, t65.id AS id_66, t65.original_id AS original_id_67, t65.short_url AS short_url_68, t65.qr_code AS qr_code_69, t65.number_scann AS number_scann_70, t65.id_api AS id_api_71, t65.url_qr_created_at AS url_qr_created_at_72, t65.operation_id AS operation_id_73 FROM operation t0 LEFT JOIN stats t65 ON t65.operation_id = t0.id WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "home"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.start_at AS start_at_5,
  t0.end_at AS end_at_6,
  t0.code AS code_7,
  t0.open_until AS open_until_8,
  t0.max_participations AS max_participations_9,
  t0.contest_description AS contest_description_10,
  t0.contest_rules_link AS contest_rules_link_11,
  t0.contest_rules_description AS contest_rules_description_12,
  t0.privacy_text AS privacy_text_13,
  t0.presentation AS presentation_14,
  t0.cgu AS cgu_15,
  t0.rgpd AS rgpd_16,
  t0.informations AS informations_17,
  t0.logo_email AS logo_email_18,
  t0.is_stop AS is_stop_19,
  t0.is_active AS is_active_20,
  t0.big_banner AS big_banner_21,
  t0.small_banner AS small_banner_22,
  t0.brand AS brand_23,
  t0.modality AS modality_24,
  t0.products_file AS products_file_25,
  t0.closing_sales AS closing_sales_26,
  t0.shops_file AS shops_file_27,
  t0.url AS url_28,
  t0.cible AS cible_29,
  t0.justificatifs AS justificatifs_30,
  t0.is_zip_code AS is_zip_code_31,
  t0.is_city AS is_city_32,
  t0.is_list_shop AS is_list_shop_33,
  t0.number_op AS number_op_34,
  t0.product_mutliple AS product_mutliple_35,
  t0.serial_number AS serial_number_36,
  t0.qr_code AS qr_code_37,
  t0.is_total_ttc AS is_total_ttc_38,
  t0.text_serial_number AS text_serial_number_39,
  t0.legal_notice AS legal_notice_40,
  t0.purchase_multiple AS purchase_multiple_41,
  t0.is_cummulable AS is_cummulable_42,
  t0.is_gift AS is_gift_43,
  t0.is_odr AS is_odr_44,
  t0.background AS background_45,
  t0.is_one_participation_personne AS is_one_participation_personne_46,
  t0.is_one_participation_product AS is_one_participation_product_47,
  t0.slug AS slug_48,
  t0.address_operation AS address_operation_49,
  t0.original_id AS original_id_50,
  t0.logo AS logo_51,
  t0.original_slug AS original_slug_52,
  t0.hide AS hide_53,
  t0.sales_points_excel AS sales_points_excel_54,
  t0.sales_points_pdf AS sales_points_pdf_55,
  t0.background_color AS background_color_56,
  t0.user_form_id AS user_form_id_57,
  t0.purchase_form_id AS purchase_form_id_58,
  t0.product_form_id AS product_form_id_59,
  t0.document_form_id AS document_form_id_60,
  t0.refund_form_id AS refund_form_id_61,
  t0.optin_form_id AS optin_form_id_62,
  t0.question_form_id AS question_form_id_63,
  t0.type_channel_id AS type_channel_id_64,
  t65.id AS id_66,
  t65.original_id AS original_id_67,
  t65.short_url AS short_url_68,
  t65.qr_code AS qr_code_69,
  t65.number_scann AS number_scann_70,
  t65.id_api AS id_api_71,
  t65.url_qr_created_at AS url_qr_created_at_72,
  t65.operation_id AS operation_id_73
FROM
  operation t0
  LEFT JOIN stats t65 ON t65.operation_id = t0.id
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.start_at AS start_at_5, t0.end_at AS end_at_6, t0.code AS code_7, t0.open_until AS open_until_8, t0.max_participations AS max_participations_9, t0.contest_description AS contest_description_10, t0.contest_rules_link AS contest_rules_link_11, t0.contest_rules_description AS contest_rules_description_12, t0.privacy_text AS privacy_text_13, t0.presentation AS presentation_14, t0.cgu AS cgu_15, t0.rgpd AS rgpd_16, t0.informations AS informations_17, t0.logo_email AS logo_email_18, t0.is_stop AS is_stop_19, t0.is_active AS is_active_20, t0.big_banner AS big_banner_21, t0.small_banner AS small_banner_22, t0.brand AS brand_23, t0.modality AS modality_24, t0.products_file AS products_file_25, t0.closing_sales AS closing_sales_26, t0.shops_file AS shops_file_27, t0.url AS url_28, t0.cible AS cible_29, t0.justificatifs AS justificatifs_30, t0.is_zip_code AS is_zip_code_31, t0.is_city AS is_city_32, t0.is_list_shop AS is_list_shop_33, t0.number_op AS number_op_34, t0.product_mutliple AS product_mutliple_35, t0.serial_number AS serial_number_36, t0.qr_code AS qr_code_37, t0.is_total_ttc AS is_total_ttc_38, t0.text_serial_number AS text_serial_number_39, t0.legal_notice AS legal_notice_40, t0.purchase_multiple AS purchase_multiple_41, t0.is_cummulable AS is_cummulable_42, t0.is_gift AS is_gift_43, t0.is_odr AS is_odr_44, t0.background AS background_45, t0.is_one_participation_personne AS is_one_participation_personne_46, t0.is_one_participation_product AS is_one_participation_product_47, t0.slug AS slug_48, t0.address_operation AS address_operation_49, t0.original_id AS original_id_50, t0.logo AS logo_51, t0.original_slug AS original_slug_52, t0.hide AS hide_53, t0.sales_points_excel AS sales_points_excel_54, t0.sales_points_pdf AS sales_points_pdf_55, t0.background_color AS background_color_56, t0.user_form_id AS user_form_id_57, t0.purchase_form_id AS purchase_form_id_58, t0.product_form_id AS product_form_id_59, t0.document_form_id AS document_form_id_60, t0.refund_form_id AS refund_form_id_61, t0.optin_form_id AS optin_form_id_62, t0.question_form_id AS question_form_id_63, t0.type_channel_id AS type_channel_id_64, t65.id AS id_66, t65.original_id AS original_id_67, t65.short_url AS short_url_68, t65.qr_code AS qr_code_69, t65.number_scann AS number_scann_70, t65.id_api AS id_api_71, t65.url_qr_created_at AS url_qr_created_at_72, t65.operation_id AS operation_id_73 FROM operation t0 LEFT JOIN stats t65 ON t65.operation_id = t0.id WHERE t0.slug = 'home' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 69)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

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\Operation	The association App\Entity\Operation#purchaseForm refers to the inverse side field App\Entity\FieldFormPurchase#operations which does not exist. The association App\Entity\Operation#documentForm refers to the inverse side field App\Entity\FieldFormDocument#operations which does not exist. The association App\Entity\Operation#questionForm refers to the inverse side field App\Entity\FieldFormQuestion#operations which does not exist. The mappings App\Entity\Operation#typeChannel and App\Entity\TypeChannel#operations are inconsistent with each other.
App\Entity\FieldFormUser	No errors.
App\Entity\FieldFormPurchase	No errors.
App\Entity\FieldFormProduct	The field 'App\Entity\FieldFormProduct#priceTtc' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\FieldFormProduct#priceHt' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\FieldFormProduct#multipleProducts' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\FieldFormProduct#menuChoice' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\FieldFormDocument	The field 'App\Entity\FieldFormDocument#receipt' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\FieldFormDocument#greyCard' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\FieldFormDocument#other' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\FieldFormRefund	The field 'App\Entity\FieldFormRefund#iban' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\FieldFormRefund#rib' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\FieldFormOptin	The field 'App\Entity\FieldFormOptin#rgpd' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\FieldFormOptin#terms' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\FieldFormOptin#newsletter' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\FieldFormQuestion	The field 'App\Entity\FieldFormQuestion#yesNoQuestionOne' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\FieldFormQuestion#yesNoQuestionTwo' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\FieldFormQuestion#yesNoQuestionThree' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\FieldFormQuestion#yesNoQuestionFour' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\FieldFormQuestion#rankingQuestionOne' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\FieldFormQuestion#rankingQuestionTwo' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\FieldFormQuestion#rankingQuestionThree' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\FieldFormQuestion#rankingQuestionFour' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\FieldFormQuestion#multipleQuestionsOne' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\FieldFormQuestion#multipleQuestionsTwo' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\FieldFormQuestion#multipleQuestionsThree' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\FieldFormQuestion#multipleQuestionsFour' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\TypeChannel	The association App\Entity\TypeChannel#operations refers to the owning side field App\Entity\Operation#type_channel which does not exist.
App\Entity\Stats	No errors.

Symfony Profiler

GET https://odr.devilsadvocatepayetontaxi.com/home/mentions-legales

Configuration Settings

Theme