Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

14.33 ms Query time

4 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲	Time	Info
1	8.15 ms	SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.gender AS gender_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.phone AS phone_7, t0.address_line1 AS address_line1_8, t0.address_line2 AS address_line2_9, t0.address_zip AS address_zip_10, t0.address_city AS address_city_11, t0.address_country AS address_country_12, t0.company_name AS company_name_13, t0.company_number AS company_number_14, t0.picture AS picture_15, t0.locale AS locale_16, t0.invite_token AS invite_token_17, t0.shine_payer_uuid AS shine_payer_uuid_18, t0.shine_subscription_uuid AS shine_subscription_uuid_19, t0.roles AS roles_20, t0.type_of_user AS type_of_user_21, t0.password AS password_22, t0.is_subscription_active AS is_subscription_active_23, t0.stripe_status AS stripe_status_24, t0.has_delayed_payment AS has_delayed_payment_25, t0.major_emergency AS major_emergency_26, t0.is_voucher_upgrade_notified AS is_voucher_upgrade_notified_27, t0.user_b2b_status AS user_b2b_status_28, t0.partner_reference AS partner_reference_29, t0.fiscal_code AS fiscal_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.invitation_id AS invitation_id_33, t0.origin_id AS origin_id_34, t0.plan_id AS plan_id_35, t0.company_id AS company_id_36, t0.sticky_organization_id AS sticky_organization_id_37 FROM user t0 WHERE t0.invite_token = ? LIMIT 1 Parameters: [`"z1o43g89"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.gender AS gender_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.phone AS phone_7, t0.address_line1 AS address_line1_8, t0.address_line2 AS address_line2_9, t0.address_zip AS address_zip_10, t0.address_city AS address_city_11, t0.address_country AS address_country_12, t0.company_name AS company_name_13, t0.company_number AS company_number_14, t0.picture AS picture_15, t0.locale AS locale_16, t0.invite_token AS invite_token_17, t0.shine_payer_uuid AS shine_payer_uuid_18, t0.shine_subscription_uuid AS shine_subscription_uuid_19, t0.roles AS roles_20, t0.type_of_user AS type_of_user_21, t0.password AS password_22, t0.is_subscription_active AS is_subscription_active_23, t0.stripe_status AS stripe_status_24, t0.has_delayed_payment AS has_delayed_payment_25, t0.major_emergency AS major_emergency_26, t0.is_voucher_upgrade_notified AS is_voucher_upgrade_notified_27, t0.user_b2b_status AS user_b2b_status_28, t0.partner_reference AS partner_reference_29, t0.fiscal_code AS fiscal_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.invitation_id AS invitation_id_33, t0.origin_id AS origin_id_34, t0.plan_id AS plan_id_35, t0.company_id AS company_id_36, t0.sticky_organization_id AS sticky_organization_id_37 FROM user t0 WHERE t0.invite_token = ? LIMIT 1 SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.gender AS gender_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.phone AS phone_7, t0.address_line1 AS address_line1_8, t0.address_line2 AS address_line2_9, t0.address_zip AS address_zip_10, t0.address_city AS address_city_11, t0.address_country AS address_country_12, t0.company_name AS company_name_13, t0.company_number AS company_number_14, t0.picture AS picture_15, t0.locale AS locale_16, t0.invite_token AS invite_token_17, t0.shine_payer_uuid AS shine_payer_uuid_18, t0.shine_subscription_uuid AS shine_subscription_uuid_19, t0.roles AS roles_20, t0.type_of_user AS type_of_user_21, t0.password AS password_22, t0.is_subscription_active AS is_subscription_active_23, t0.stripe_status AS stripe_status_24, t0.has_delayed_payment AS has_delayed_payment_25, t0.major_emergency AS major_emergency_26, t0.is_voucher_upgrade_notified AS is_voucher_upgrade_notified_27, t0.user_b2b_status AS user_b2b_status_28, t0.partner_reference AS partner_reference_29, t0.fiscal_code AS fiscal_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.invitation_id AS invitation_id_33, t0.origin_id AS origin_id_34, t0.plan_id AS plan_id_35, t0.company_id AS company_id_36, t0.sticky_organization_id AS sticky_organization_id_37 FROM user t0 WHERE t0.invite_token = 'z1o43g89' LIMIT 1;
2	6.18 ms	SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.code AS code_3, t0.duration AS duration_4, t0.amount AS amount_5, t0.is_paid AS is_paid_6, t0.is_redeemed AS is_redeemed_7, t0.is_physical AS is_physical_8, t0.is_consumed AS is_consumed_9, t0.redeemed_at AS redeemed_at_10, t0.pdf_file AS pdf_file_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.user_id AS user_id_14, t0.beneficiary_id AS beneficiary_id_15, t0.transaction_id AS transaction_id_16 FROM voucher t0 WHERE t0.code IS NULL AND t0.is_paid = ? AND t0.is_redeemed = ? LIMIT 1 Parameters: [`1 0`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.code AS code_3, t0.duration AS duration_4, t0.amount AS amount_5, t0.is_paid AS is_paid_6, t0.is_redeemed AS is_redeemed_7, t0.is_physical AS is_physical_8, t0.is_consumed AS is_consumed_9, t0.redeemed_at AS redeemed_at_10, t0.pdf_file AS pdf_file_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.user_id AS user_id_14, t0.beneficiary_id AS beneficiary_id_15, t0.transaction_id AS transaction_id_16 FROM voucher t0 WHERE t0.code IS NULL AND t0.is_paid = ? AND t0.is_redeemed = ? LIMIT 1 SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.code AS code_3, t0.duration AS duration_4, t0.amount AS amount_5, t0.is_paid AS is_paid_6, t0.is_redeemed AS is_redeemed_7, t0.is_physical AS is_physical_8, t0.is_consumed AS is_consumed_9, t0.redeemed_at AS redeemed_at_10, t0.pdf_file AS pdf_file_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.user_id AS user_id_14, t0.beneficiary_id AS beneficiary_id_15, t0.transaction_id AS transaction_id_16 FROM voucher t0 WHERE t0.code IS NULL AND t0.is_paid = 1 AND t0.is_redeemed = 0 LIMIT 1;

#▲

Time

Info

8.15 ms

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.gender AS gender_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.phone AS phone_7, t0.address_line1 AS address_line1_8, t0.address_line2 AS address_line2_9, t0.address_zip AS address_zip_10, t0.address_city AS address_city_11, t0.address_country AS address_country_12, t0.company_name AS company_name_13, t0.company_number AS company_number_14, t0.picture AS picture_15, t0.locale AS locale_16, t0.invite_token AS invite_token_17, t0.shine_payer_uuid AS shine_payer_uuid_18, t0.shine_subscription_uuid AS shine_subscription_uuid_19, t0.roles AS roles_20, t0.type_of_user AS type_of_user_21, t0.password AS password_22, t0.is_subscription_active AS is_subscription_active_23, t0.stripe_status AS stripe_status_24, t0.has_delayed_payment AS has_delayed_payment_25, t0.major_emergency AS major_emergency_26, t0.is_voucher_upgrade_notified AS is_voucher_upgrade_notified_27, t0.user_b2b_status AS user_b2b_status_28, t0.partner_reference AS partner_reference_29, t0.fiscal_code AS fiscal_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.invitation_id AS invitation_id_33, t0.origin_id AS origin_id_34, t0.plan_id AS plan_id_35, t0.company_id AS company_id_36, t0.sticky_organization_id AS sticky_organization_id_37 FROM user t0 WHERE t0.invite_token = ? LIMIT 1

Parameters:

[
  "z1o43g89"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.gender AS gender_3,
  t0.firstname AS firstname_4,
  t0.lastname AS lastname_5,
  t0.email AS email_6,
  t0.phone AS phone_7,
  t0.address_line1 AS address_line1_8,
  t0.address_line2 AS address_line2_9,
  t0.address_zip AS address_zip_10,
  t0.address_city AS address_city_11,
  t0.address_country AS address_country_12,
  t0.company_name AS company_name_13,
  t0.company_number AS company_number_14,
  t0.picture AS picture_15,
  t0.locale AS locale_16,
  t0.invite_token AS invite_token_17,
  t0.shine_payer_uuid AS shine_payer_uuid_18,
  t0.shine_subscription_uuid AS shine_subscription_uuid_19,
  t0.roles AS roles_20,
  t0.type_of_user AS type_of_user_21,
  t0.password AS password_22,
  t0.is_subscription_active AS is_subscription_active_23,
  t0.stripe_status AS stripe_status_24,
  t0.has_delayed_payment AS has_delayed_payment_25,
  t0.major_emergency AS major_emergency_26,
  t0.is_voucher_upgrade_notified AS is_voucher_upgrade_notified_27,
  t0.user_b2b_status AS user_b2b_status_28,
  t0.partner_reference AS partner_reference_29,
  t0.fiscal_code AS fiscal_code_30,
  t0.created_at AS created_at_31,
  t0.updated_at AS updated_at_32,
  t0.invitation_id AS invitation_id_33,
  t0.origin_id AS origin_id_34,
  t0.plan_id AS plan_id_35,
  t0.company_id AS company_id_36,
  t0.sticky_organization_id AS sticky_organization_id_37
FROM
  user t0
WHERE
  t0.invite_token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.gender AS gender_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.phone AS phone_7, t0.address_line1 AS address_line1_8, t0.address_line2 AS address_line2_9, t0.address_zip AS address_zip_10, t0.address_city AS address_city_11, t0.address_country AS address_country_12, t0.company_name AS company_name_13, t0.company_number AS company_number_14, t0.picture AS picture_15, t0.locale AS locale_16, t0.invite_token AS invite_token_17, t0.shine_payer_uuid AS shine_payer_uuid_18, t0.shine_subscription_uuid AS shine_subscription_uuid_19, t0.roles AS roles_20, t0.type_of_user AS type_of_user_21, t0.password AS password_22, t0.is_subscription_active AS is_subscription_active_23, t0.stripe_status AS stripe_status_24, t0.has_delayed_payment AS has_delayed_payment_25, t0.major_emergency AS major_emergency_26, t0.is_voucher_upgrade_notified AS is_voucher_upgrade_notified_27, t0.user_b2b_status AS user_b2b_status_28, t0.partner_reference AS partner_reference_29, t0.fiscal_code AS fiscal_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.invitation_id AS invitation_id_33, t0.origin_id AS origin_id_34, t0.plan_id AS plan_id_35, t0.company_id AS company_id_36, t0.sticky_organization_id AS sticky_organization_id_37 FROM user t0 WHERE t0.invite_token = 'z1o43g89' LIMIT 1;

6.18 ms

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.code AS code_3, t0.duration AS duration_4, t0.amount AS amount_5, t0.is_paid AS is_paid_6, t0.is_redeemed AS is_redeemed_7, t0.is_physical AS is_physical_8, t0.is_consumed AS is_consumed_9, t0.redeemed_at AS redeemed_at_10, t0.pdf_file AS pdf_file_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.user_id AS user_id_14, t0.beneficiary_id AS beneficiary_id_15, t0.transaction_id AS transaction_id_16 FROM voucher t0 WHERE t0.code IS NULL AND t0.is_paid = ? AND t0.is_redeemed = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.code AS code_3,
  t0.duration AS duration_4,
  t0.amount AS amount_5,
  t0.is_paid AS is_paid_6,
  t0.is_redeemed AS is_redeemed_7,
  t0.is_physical AS is_physical_8,
  t0.is_consumed AS is_consumed_9,
  t0.redeemed_at AS redeemed_at_10,
  t0.pdf_file AS pdf_file_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.user_id AS user_id_14,
  t0.beneficiary_id AS beneficiary_id_15,
  t0.transaction_id AS transaction_id_16
FROM
  voucher t0
WHERE
  t0.code IS NULL
  AND t0.is_paid = ?
  AND t0.is_redeemed = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.code AS code_3, t0.duration AS duration_4, t0.amount AS amount_5, t0.is_paid AS is_paid_6, t0.is_redeemed AS is_redeemed_7, t0.is_physical AS is_physical_8, t0.is_consumed AS is_consumed_9, t0.redeemed_at AS redeemed_at_10, t0.pdf_file AS pdf_file_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.user_id AS user_id_14, t0.beneficiary_id AS beneficiary_id_15, t0.transaction_id AS transaction_id_16 FROM voucher t0 WHERE t0.code IS NULL AND t0.is_paid = 1 AND t0.is_redeemed = 0 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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\User	2
App\Entity\Invitation	1
App\Entity\Plan	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Invitation	No errors.
App\Entity\Plan	The field 'App\Entity\Plan#monthlyPrice' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Plan#monthlyPriceAfterDeduction' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Company	The field App\Entity\Company#companyModules is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CompanyModuleAssignment#company does not contain the required 'inversedBy="companyModules"' attribute.
App\Entity\Organization	No errors.
App\Entity\UserOrganizationAssignment	The association App\Entity\UserOrganizationAssignment#userOrganizationAssignmentHistories refers to the owning side field App\Entity\UserOrganizationAssignmentHistory#OriginalAssignment which does not exist.
App\Entity\UserFavoriteTopics	No errors.
App\Entity\Transaction	No errors.
App\Entity\Voucher	The field 'App\Entity\Voucher#amount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Webhook	No errors.
App\Entity\UserLog	No errors.
App\Entity\Tag	No errors.
App\Entity\UserOrganizationAssignmentHistory	No errors.
App\Entity\Issuance	No errors.

Symfony Profiler

GET https://thomass-mac-mini-1.coyote-lizard.ts.net/fr/join

Configuration Settings

Theme

Page Width