Query Metrics
7
Database Queries
7
Different statements
5.07 ms
Query time
5
Invalid entities
11
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.77 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.id = ?
Parameters:
[
3
]
|
| 2 | 0.73 ms |
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"
]
|
| 3 | 0.81 ms |
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"
]
|
| 4 | 0.76 ms |
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"
]
|
| 5 | 0.78 ms |
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 ] |
| 6 | 0.57 ms |
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 ] |
| 7 | 0.66 ms |
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
]
|
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 |
|
| App\Entity\Company |
|
| App\Entity\Organization | No errors. |
| App\Entity\UserOrganizationAssignment |
|
| App\Entity\UserFavoriteTopics | No errors. |
| App\Entity\Transaction | No errors. |
| App\Entity\Voucher |
|
| 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 |
|
| 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. |