Query Metrics
4
Database Queries
4
Different statements
41.17 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
30.42 ms (73.90%) |
1 |
SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.phone_number AS phone_number_2, a0_.password AS password_3, a0_.roles AS roles_4, a0_.lastname AS lastname_5, a0_.firstname AS firstname_6, a0_.created_at AS created_at_7, a0_.registration_source AS registration_source_8, a0_.honorific_prefix AS honorific_prefix_9, a0_.reset_token AS reset_token_10, a0_.reset_token_expiration_date AS reset_token_expiration_date_11, a0_.uniq_id AS uniq_id_12, a0_.code_confirmation AS code_confirmation_13, a0_.updated_at AS updated_at_14, a0_.is_active AS is_active_15 FROM app_users a0_ WHERE a0_.email = ? OR a0_.phone_number = ?
Parameters:
[ "tokiarivelo@digidom.pro" "tokiarivelo@digidom.pro" ] |
7.40 ms (17.97%) |
1 |
SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.price_without_tax AS price_without_tax_2, s0_.trial AS trial_3, s0_.remove_after_trial AS remove_after_trial_4, s0_.trial_period_length AS trial_period_length_5, s0_.created_at AS created_at_6, p1_.id AS id_7, p1_.name AS name_8, p1_.alternate_name AS alternate_name_9, p1_.price_without_tax AS price_without_tax_10, p1_.description AS description_11, p1_.active AS active_12, p1_.meta_description AS meta_description_13, p1_.meta_title AS meta_title_14, p1_.url AS url_15, p1_.created_at AS created_at_16, p1_.subscription_type AS subscription_type_17, p1_.unique_key AS unique_key_18, p1_.is_displayed AS is_displayed_19, p1_.is_archived AS is_archived_20, p1_.is_subscription_component AS is_subscription_component_21, s0_.product_id AS product_id_22, s0_.subscription_id AS subscription_id_23, s0_.subscription_model_id AS subscription_model_id_24, p1_.category_id AS category_id_25, p1_.category_for_billing_report_id AS category_for_billing_report_id_26 FROM service s0_ INNER JOIN product p1_ ON s0_.product_id = p1_.id WHERE s0_.subscription_id = ? ORDER BY s0_.id ASC LIMIT 30
Parameters:
[
36182
]
|
1.81 ms (4.40%) |
1 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.price AS price_3, t0.type AS type_4, t0.subscription_deposit AS subscription_deposit_5, t0.created_at AS created_at_6, t0.discount_without_tax AS discount_without_tax_7, t0.payment_dates AS payment_dates_8, t0.price_without_tax AS price_without_tax_9, t0.stored_total_price_without_tax AS stored_total_price_without_tax_10, t0.is_updated_price AS is_updated_price_11, t0.next_payment AS next_payment_12, t0.pack_history AS pack_history_13, t0.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_14, t0.invoice_generation_date AS invoice_generation_date_15, t0.month_number AS month_number_16, t0.authorized_reccurency AS authorized_reccurency_17, t0.is_cancel_using_offer AS is_cancel_using_offer_18, t0.is_digipack_offer AS is_digipack_offer_19, t0.deadline_offered AS deadline_offered_20, t0.prepaid_months AS prepaid_months_21, t0.has_blocked_service AS has_blocked_service_22, t0.document_recovery_delay AS document_recovery_delay_23, t0.updated_at AS updated_at_24, t0.organization_id AS organization_id_25, t26.id AS id_27, t26.name AS name_28, t26.price AS price_29, t26.focus AS focus_30, t26.price_without_tax AS price_without_tax_31, t26.vat_rate AS vat_rate_32, t26.discount AS discount_33, t26.unique_key AS unique_key_34, t26.automation AS automation_35, t26.is_published AS is_published_36, t26.is_subscription AS is_subscription_37, t26.published_name AS published_name_38, t26.is_published_pack AS is_published_pack_39, t26.type AS type_40, t26.legal_status AS legal_status_41, t26.created_at AS created_at_42, t26.association_pack_id AS association_pack_id_43, t26.category_id AS category_id_44, t26.recurring_invoice_id AS recurring_invoice_id_45, t26.initial_invoice_id AS initial_invoice_id_46, t26.subscription_id AS subscription_id_47 FROM subscription t0 LEFT JOIN pack t26 ON t26.subscription_id = t0.id WHERE t0.id IN (?)
Parameters:
[
[
36182
]
]
|
1.54 ms (3.74%) |
1 |
SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM service s0_ INNER JOIN product p1_ ON s0_.product_id = p1_.id WHERE s0_.subscription_id = ?
Parameters:
[
36182
]
|
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 |
---|---|
Evo\Infrastructure\MappingORM\Product | No errors. |
Evo\Infrastructure\MappingORM\Invoice | No errors. |
Evo\Infrastructure\MappingORM\Subscription | No errors. |
Evo\Infrastructure\MappingORM\SubscriptionModel | No errors. |
Evo\Infrastructure\MappingORM\User | No errors. |
Evo\Infrastructure\MappingORM\PappersActivityLogWrapper | No errors. |
Evo\Infrastructure\MappingORM\CreditNote | No errors. |
Evo\Infrastructure\MappingORM\Quote | No errors. |
Evo\Infrastructure\MappingORM\Organization | No errors. |
Evo\Infrastructure\MappingORM\Store | No errors. |
Evo\Infrastructure\MappingORM\UserUTM | No errors. |
Evo\Infrastructure\MappingORM\Lead | No errors. |
Evo\Infrastructure\MappingORM\ActivityLog | No errors. |
Evo\Infrastructure\MappingORM\CommercialGesture | No errors. |
Evo\Infrastructure\MappingORM\Service | No errors. |
Evo\Infrastructure\MappingORM\Category | No errors. |
Evo\Infrastructure\MappingORM\ProductHistory | No errors. |
Evo\Infrastructure\MappingORM\DiscountCode | No errors. |
Evo\Infrastructure\MappingORM\DiscountConfiguration | No errors. |
Evo\Infrastructure\MappingORM\Pack | No errors. |
Evo\Infrastructure\MappingORM\Item | No errors. |