Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.49 ms Query time

14 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.
App\Entity\Purchase	No errors.
App\Entity\Shop	No errors.
App\Entity\Product	No errors.
App\Entity\OperationAdditionalData	No errors.
App\Entity\User	No errors.
App\Entity\Fund	No errors.
App\Entity\Mecanique	No errors.
App\Entity\Bilan	No errors.
App\Entity\Transfer	No errors.
App\Entity\Siret	No errors.
App\Entity\Participation	No errors.
App\Entity\TypeStatus	No errors.
App\Entity\ProductPurchase	No errors.
App\Entity\Doublon	The association App\Entity\Doublon#type refers to the inverse side field App\Entity\DoublonType#doublons which does not exist.
App\Entity\DeclineSubject	The association App\Entity\DeclineSubject#productPurchase refers to the owning side field App\Entity\ProductPurchase#declineSubject which does not exist.
App\Entity\CheckPayment	No errors.
App\Entity\Optin	No errors.
App\Entity\Godfather	No errors.
App\Entity\Installer	No errors.
App\Entity\Answer	No errors.
App\Entity\GenderType	No errors.
App\Entity\UserPreference	No errors.
App\Entity\TypeLink	No errors.
App\Entity\Point	The association App\Entity\Point#author refers to the inverse side field App\Entity\User#points which does not exist.
App\Entity\DoublonPurchase	The mappings App\Entity\DoublonPurchase#purchase and App\Entity\Purchase#doublonPurchases are inconsistent with each other. If association App\Entity\DoublonPurchase#purchase is many-to-many, then the inversed side App\Entity\Purchase#doublonPurchases has to be many-to-many as well.
App\Entity\Contact	The association App\Entity\Contact#author refers to the inverse side field App\Entity\User#contacts which does not exist.
App\Entity\DoublonType	No errors.
App\Entity\Migration	No errors.
App\Entity\Configuration	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\TypeContainer	No errors.
App\Entity\PageEnd	No errors.
App\Entity\PageHome	No errors.
App\Entity\TypeMenu	No errors.
App\Entity\ProductCustom	The association App\Entity\ProductCustom#productPurchases refers to the owning side field App\Entity\ProductPurchase#productCustom which does not exist.
App\Entity\TypeProcess	The association App\Entity\TypeProcess#operations refers to the owning side field App\Entity\Operation#TypeProcess which does not exist.

Symfony Profiler

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

Configuration Settings

Theme