GET http://better.test/fr/shop/sponsors/beobank.be/46eeb748-d1f1-447c-ab87-8c631d8fa6d3

Query Metrics

7 Database Queries
7 Different statements
5.07 ms Query time
5 Invalid entities
11 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.81 ms
(16.03%)
1
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.company_name AS company_name_3, t0.official_name AS official_name_4, t0.company_number AS company_number_5, t0.address_line1 AS address_line1_6, t0.address_line2 AS address_line2_7, t0.address_zip AS address_zip_8, t0.address_city AS address_city_9, t0.address_country AS address_country_10, t0.contact_first_name AS contact_first_name_11, t0.contact_last_name AS contact_last_name_12, t0.contact_email AS contact_email_13, t0.contact_phone AS contact_phone_14, t0.hr_email AS hr_email_15, t0.monthly_fee AS monthly_fee_16, t0.monthly_donation AS monthly_donation_17, t0.is_contract_signed AS is_contract_signed_18, t0.contract_file_location AS contract_file_location_19, t0.contract_signature_date AS contract_signature_date_20, t0.contract_end_date AS contract_end_date_21, t0.employee_commitment AS employee_commitment_22, t0.periodicity_invoicing AS periodicity_invoicing_23, t0.is_subscription_active AS is_subscription_active_24, t0.is_public_homepage_published AS is_public_homepage_published_25, t0.logo AS logo_26, t0.partner_reference AS partner_reference_27, t0.custom_public_css_snippet AS custom_public_css_snippet_28, t0.theme_primary_color AS theme_primary_color_29, t0.theme_secondary_color AS theme_secondary_color_30, t0.theme_tertiary_color AS theme_tertiary_color_31, t0.theme_dark_color AS theme_dark_color_32, t0.shop_domain AS shop_domain_33, t0.shop_brand_data AS shop_brand_data_34, t0.shop_brand_logo_url AS shop_brand_logo_url_35, t0.shop_brand_refreshed_at AS shop_brand_refreshed_at_36, t0.allowed_email_domains AS allowed_email_domains_37, t0.email_restriction_message AS email_restriction_message_38, t0.partner_id AS partner_id_39 FROM company t0 WHERE t0.shop_domain = ? LIMIT 1
Parameters:
[
  "beobank.be"
]
0.78 ms
(15.31%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.company_id AS company_id_4, t0.module_id AS module_id_5 FROM company_module t0 WHERE t0.company_id = ? AND t0.module_id = ? LIMIT 1
Parameters:
[
  20
  7
]
0.77 ms
(15.15%)
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.id = ?
Parameters:
[
  3
]
0.76 ms
(14.96%)
1
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.module_key AS module_key_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM module t0 WHERE t0.module_key = ? LIMIT 1
Parameters:
[
  "shop"
]
0.73 ms
(14.31%)
1
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.label AS label_3, t0.shine_form_id AS shine_form_id_4, t0.shine_payment_form_id AS shine_payment_form_id_5, t0.is_selectable AS is_selectable_6, t0.shop_active AS shop_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM organization t0 WHERE t0.uuid = ? LIMIT 1
Parameters:
[
  "46eeb748-d1f1-447c-ab87-8c631d8fa6d3"
]
0.66 ms
(12.93%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.money_allocation AS money_allocation_4, t0.impact AS impact_5, t0.website AS website_6, t0.image AS image_7, t0.video AS video_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM organization_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  3
]
0.57 ms
(11.31%)
1
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.impact_unit AS impact_unit_4, t0.unit_price_cents AS unit_price_cents_5, t0.vat_rate_bps AS vat_rate_bps_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM shop_product t0 WHERE t0.impact_unit = ? AND t0.is_active = ? LIMIT 1
Parameters:
[
  "meal"
  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\OrganizationTranslation 3
App\Entity\User 1
App\Entity\Invitation 1
App\Entity\Plan 1
App\Entity\Organization 1
App\Entity\Company 1
App\Entity\Module 1
App\Entity\CompanyModuleAssignment 1
App\Entity\Shop\Product 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.
App\Entity\Topic No errors.
App\Entity\OrganizationGoalRatio No errors.
App\Entity\Vote No errors.
App\Entity\Allocation
  • The field 'App\Entity\Allocation#amount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Allocation#netAmount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Allocation#frbCommission' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Allocation#betterCommission' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\OrganizationImpact No errors.
App\Entity\OrganizationSdg No errors.
App\Entity\OrganizationTranslation No errors.
App\Entity\Partner No errors.
App\Entity\Invoice No errors.
App\Entity\Campaign No errors.
App\Entity\CompanyReports No errors.
App\Entity\PartnerOrder No errors.
App\Entity\CompanyModuleAssignment No errors.
App\Entity\SaleProduct No errors.
App\Entity\SaleOrder No errors.
App\Entity\Module No errors.
App\Entity\Shop\Product No errors.