https://dev.kiwi.web.oxv.fr/forget_password

Query Metrics

30 Database Queries
6 Different statements
23.23 ms Query time
10 Invalid entities

Grouped Statements

Show all queries

Time Count Info
6.55 ms
(28.20%)
9
SELECT t0.id AS id_1, t0.edited_id AS edited_id_2, t0.token AS token_3, t0.update_conformity_at AS update_conformity_at_4, t0.restatement_participation AS restatement_participation_5, t0.financial_status AS financial_status_6, t0.financial_date AS financial_date_7, t0.financial_amount AS financial_amount_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.state_id AS state_id_11, t0.user_id AS user_id_12, t0.company_id AS company_id_13, t0.validation_export_id AS validation_export_id_14, t0.discr, t0.print_url AS print_url_15, t0.emitter_code AS emitter_code_16, t0.channel AS channel_17, t0.status AS status_18, t0.code AS code_19, t0.amount AS amount_20, t0.mail_success AS mail_success_21, t0.amount AS amount_22, t0.iban AS iban_23, t0.bic AS bic_24, t0.code AS code_25, t0.amount AS amount_26, t0.mail_success AS mail_success_27, t0.code AS code_28, t0.amount AS amount_29, t0.date_of_purchase AS date_of_purchase_30, t0.iban AS iban_31, t0.bic AS bic_32, t0.paypal AS paypal_33, t0.id_billy AS id_billy_34, t0.mail_success AS mail_success_35, t0.code AS code_36, t0.print_url AS print_url_37, t0.emitter_code AS emitter_code_38, t0.channel AS channel_39, t0.status AS status_40, t0.amount AS amount_41, t0.iban AS iban_42, t0.bic AS bic_43, t0.paypal AS paypal_44, t0.id_billy AS id_billy_45, t0.mail_success AS mail_success_46 FROM participation t0 WHERE t0.id = ? AND t0.discr IN ('coupon', 'step', 'refund', 'puntos', 'draw', 'odr', 'multi')
Parameters:
[
  "2b771af2-eb1f-490d-b55d-862ef581a31d"
]
5.76 ms
(24.81%)
6
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.optin_brand AS optin_brand_5, t0.optin_customer AS optin_customer_6, t0.optin_process AS optin_process_7, t0.optin_phone AS optin_phone_8, t0.optin_sales AS optin_sales_9, t0.optin_whats_app AS optin_whats_app_10, t0.optin_mobile_carriers AS optin_mobile_carriers_11, t0.optin_whats_app_carriers AS optin_whats_app_carriers_12, t0.extra_data AS extra_data_13, t0.deleted_at AS deleted_at_14, t0.referral_code AS referral_code_15, t0.company_name AS company_name_16, t0.siret AS siret_17, t0.active AS active_18, t0.last_login AS last_login_19, t0.additional_information AS additional_information_20, t0.phone_number AS phone_number_21, t0.other AS other_22, t0.knowledge_responses AS knowledge_responses_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.identity_id AS identity_id_26, t0.company_id AS company_id_27, t0.referent_id AS referent_id_28, t0.strate_id AS strate_id_29, t0.profile_id AS profile_id_30, t0.discr FROM user t0 WHERE t0.id = ? AND t0.discr IN ('user', 'consumer', 'admin')
Parameters:
[
  "9bbfd09f-9ade-45a5-86cf-d4dfd12ef05d"
]
3.79 ms
(16.31%)
1
SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.deleted_at AS deleted_at_3, m0_.file_path AS file_path_4, m0_.discr AS discr_5, m0_.object_id AS object_id_6, m0_.object_id AS object_id_7, m0_.object_id AS object_id_8, m0_.object_id AS object_id_9, m0_.object_id AS object_id_10, m0_.object_id AS object_id_11, m0_.object_id AS object_id_12, m0_.object_id AS object_id_13, m0_.object_id AS object_id_14, m0_.object_id AS object_id_15, m0_.object_id AS object_id_16, m0_.object_id AS object_id_17, m0_.object_id AS object_id_18, m0_.object_id AS object_id_19, m0_.object_id AS object_id_20, m0_.object_id AS object_id_21, m0_.object_id AS object_id_22, m0_.object_id AS object_id_23, m0_.object_id AS object_id_24, m0_.object_id AS object_id_25, m0_.object_id AS object_id_26, m0_.object_id AS object_id_27, m0_.object_id AS object_id_28, m0_.object_id AS object_id_29 FROM media_object m0_ WHERE (m0_.file_path LIKE ?) AND m0_.discr IN ('media_coupon', 'media_participation', 'media_blog', 'media_thumbnail_blog', 'media_product', 'media_gift', 'media_thumbnail_gift', 'media_code_gift', 'media_thumbnail_draw', 'media_desktop_draw', 'media_mobile_draw', 'media_pdf_draw', 'media_code_draw', 'media_code_odr', 'media_promotion', 'media_image', 'media_pdf', 'media_game', 'media_mobile_game', 'media_slider', 'media_mobile_slider', 'media_game_params', 'media_thumbnail_odr', 'media_desktop_odr', 'media_mobile_odr', 'media_pdf_odr', 'media_multi_offer', 'media_recipe', 'media_pdf_documentation', 'media_knowledge_response')
Parameters:
[
  "%%"
]
3.30 ms
(14.19%)
6
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.participation_id AS participation_id_5, t0.discr FROM details_participation t0 WHERE t0.participation_id = ? AND t0.discr IN ('details_step')
Parameters:
[
  "2b771af2-eb1f-490d-b55d-862ef581a31d"
]
2.42 ms
(10.40%)
5
SELECT t0.id AS id_1, t0.text AS text_2, t0.position AS position_3, t0.image_id AS image_id_4, t0.knowledge_id AS knowledge_id_5 FROM knowledge_response t0 WHERE t0.image_id = ?
Parameters:
[
  "02651ed6-dae5-4415-bea7-caa2dc949605"
]
1.41 ms
(6.08%)
3
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.participation_id AS participation_id_5, t0.discr FROM details_participation t0 WHERE t0.participation_id = ? AND t0.discr IN ('details_multi_odr')
Parameters:
[
  "c697ec7a-de6d-48fa-b533-ab479bbc8fd3"
]

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\MediaObject\MediaObject No errors.
App\Entity\Menu No errors.
App\Entity\MediaObject\MediaCoupon No errors.
App\Entity\MediaObject\MediaParticipation No errors.
App\Entity\MediaObject\MediaBlog No errors.
App\Entity\MediaObject\MediaThumbnailBlog No errors.
App\Entity\MediaObject\MediaProduct No errors.
App\Entity\MediaObject\MediaGift No errors.
App\Entity\MediaObject\MediaThumbnailGift No errors.
App\Entity\MediaObject\MediaCodeGift No errors.
App\Entity\MediaObject\MediaThumbnailDraw No errors.
App\Entity\MediaObject\MediaDesktopDraw No errors.
App\Entity\MediaObject\MediaMobileDraw No errors.
App\Entity\MediaObject\MediaPdfDraw No errors.
App\Entity\MediaObject\MediaCodeDraw No errors.
App\Entity\MediaObject\MediaCodeOdr No errors.
App\Entity\MediaObject\MediaPromotion No errors.
App\Entity\MediaObject\MediaImage No errors.
App\Entity\MediaObject\MediaPdf No errors.
App\Entity\MediaObject\MediaGame No errors.
App\Entity\MediaObject\MediaMobileGame No errors.
App\Entity\MediaObject\MediaSlider No errors.
App\Entity\MediaObject\MediaMobileSlider No errors.
App\Entity\MediaObject\MediaGameParams No errors.
App\Entity\MediaObject\MediaThumbnailOdr No errors.
App\Entity\MediaObject\MediaDesktopOdr No errors.
App\Entity\MediaObject\MediaMobileOdr No errors.
App\Entity\MediaObject\MediaPdfOdr No errors.
App\Entity\MediaObject\MediaMultiOffer No errors.
App\Entity\MediaObject\MediaRecipe No errors.
App\Entity\MediaObject\MediaPdfDocumentation No errors.
App\Entity\MediaObject\MediaKnowledgeResponse No errors.
App\Entity\Details\Operation\DetailsCoupon No errors.
App\Entity\Participation\Participation No errors.
App\Entity\Blog No errors.
App\Entity\Participation\Puntos
  • The field App\Entity\Participation\Puntos#details is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Details\Participation\DetailsParticipationPuntos#participation does not contain the required 'inversedBy="details"' attribute.
App\Entity\Catalog\Gift No errors.
App\Entity\Operation\Operation No errors.
App\Entity\Operation\Draw No errors.
App\Entity\Operation\Odr No errors.
App\Entity\Sogec\Promotion No errors.
App\Entity\Operation\Game No errors.
App\Entity\Slider No errors.
App\Entity\WebsiteParams\WebsiteParams No errors.
App\Entity\WebsiteParams\GameParams No errors.
App\Entity\State No errors.
App\Entity\User\User
  • The mappings App\Entity\User\User#addressesOrder and App\Entity\Catalog\Order#user are inconsistent with each other.
  • The field App\Entity\User\User#operationCarts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Cart\OperationCart#user does not contain the required 'inversedBy="operationCarts"' attribute.
  • The field App\Entity\User\User#giftCarts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Cart\GiftCart#user does not contain the required 'inversedBy="giftCarts"' attribute.
  • The field App\Entity\User\User#tas is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Tas\TasDraw#user does not contain the required 'inversedBy="tas"' attribute.
App\Entity\Company\Company No errors.
App\Entity\Participation\ValidationExport No errors.
App\Entity\Participation\Coupon No errors.
App\Entity\Participation\Step
  • The field App\Entity\Participation\Step#details is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Details\Participation\DetailsParticipationStep#participation does not contain the required 'inversedBy="details"' attribute.
App\Entity\Participation\Refund No errors.
App\Entity\Participation\Draw No errors.
App\Entity\Participation\Odr
  • The field App\Entity\Participation\Odr#details is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Details\Participation\DetailsParticipationOdr#participation does not contain the required 'inversedBy="details"' attribute.
App\Entity\Participation\Multi
  • The field App\Entity\Participation\Multi#details is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Details\Participation\DetailsParticipationMultiOdr#participation does not contain the required 'inversedBy="details"' attribute.
App\Entity\User\Identity No errors.
App\Entity\User\Referent No errors.
App\Entity\User\Strate No errors.
App\Entity\Security\Profile No errors.
App\Entity\User\Consumer
  • The mappings App\Entity\User\Consumer#addressesOrder and App\Entity\Catalog\Order#user are inconsistent with each other.
  • The field App\Entity\User\Consumer#operationCarts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Cart\OperationCart#user does not contain the required 'inversedBy="operationCarts"' attribute.
  • The field App\Entity\User\Consumer#giftCarts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Cart\GiftCart#user does not contain the required 'inversedBy="giftCarts"' attribute.
  • The field App\Entity\User\Consumer#tas is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Tas\TasDraw#user does not contain the required 'inversedBy="tas"' attribute.
App\Entity\User\Admin
  • The mappings App\Entity\User\Admin#addressesOrder and App\Entity\Catalog\Order#user are inconsistent with each other.
  • The field App\Entity\User\Admin#operationCarts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Cart\OperationCart#user does not contain the required 'inversedBy="operationCarts"' attribute.
  • The field App\Entity\User\Admin#giftCarts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Cart\GiftCart#user does not contain the required 'inversedBy="giftCarts"' attribute.
  • The field App\Entity\User\Admin#tas is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Tas\TasDraw#user does not contain the required 'inversedBy="tas"' attribute.
App\Entity\User\Address\Address No errors.
App\Entity\User\Address\Home No errors.
App\Entity\User\Address\Delivery No errors.
App\Entity\Catalog\Order No errors.
App\Entity\Token No errors.
App\Entity\Newsletter No errors.
App\Entity\User\Payment\Iban No errors.
App\Entity\Sponsorship\SponsorshipRequest No errors.
App\Entity\User\Carrier No errors.
App\Entity\Cart\Cart No errors.
App\Entity\Cart\OperationCart No errors.
App\Entity\Cart\GiftCart No errors.
App\Entity\Purse\Purse No errors.
App\Entity\Tas\Tas No errors.
App\Entity\Tas\TasDraw No errors.
App\Entity\Ean\Participation\EanParticipation
  • The association App\Entity\Ean\Participation\EanParticipation#participation refers to the inverse side field App\Entity\Participation\Participation#eanParticipations which does not exist.
App\Entity\Ean\Participation\EanStep
  • The association App\Entity\Ean\Participation\EanStep#participation refers to the inverse side field App\Entity\Participation\Participation#eanParticipations which does not exist.
App\Entity\Details\Participation\DetailsParticipation No errors.
App\Entity\Details\Participation\DetailsParticipationStep No errors.
App\Entity\Knowledge\KnowledgeResponse No errors.
App\Entity\Knowledge\Knowledge No errors.
App\Entity\Ean\Participation\EanOdr
  • The association App\Entity\Ean\Participation\EanOdr#participation refers to the inverse side field App\Entity\Participation\Participation#eanParticipations which does not exist.
App\Entity\Details\Participation\DetailsParticipationMultiOdr No errors.