Query Metrics
25
Database Queries
5
Different statements
93.62 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 27.64 ms |
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:
[ "florian@digidom.pro" "florian@digidom.pro" ] |
2 | 3.92 ms |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.url AS url_2, c0_.description AS description_3, c0_.meta_description AS meta_description_4, c0_.meta_title AS meta_title_5, c0_.active AS active_6, c0_.created_at AS created_at_7, c0_.type AS type_8 FROM category c0_ WHERE c0_.title LIKE CONCAT('%', ?, '%') ORDER BY c0_.id ASC LIMIT 30
Parameters:
[ "" ] |
3 | 10.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
1
]
|
4 | 2.61 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.focus AS focus_4, t0.price_without_tax AS price_without_tax_5, t0.vat_rate AS vat_rate_6, t0.discount AS discount_7, t0.unique_key AS unique_key_8, t0.automation AS automation_9, t0.is_published AS is_published_10, t0.is_subscription AS is_subscription_11, t0.published_name AS published_name_12, t0.is_published_pack AS is_published_pack_13, t0.type AS type_14, t0.legal_status AS legal_status_15, t0.created_at AS created_at_16, t0.association_pack_id AS association_pack_id_17, t0.category_id AS category_id_18, t0.recurring_invoice_id AS recurring_invoice_id_19, t0.initial_invoice_id AS initial_invoice_id_20, t0.subscription_id AS subscription_id_21 FROM pack t0 WHERE t0.category_id = ?
Parameters:
[
1
]
|
5 | 15.00 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
2
]
|
6 | 1.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.focus AS focus_4, t0.price_without_tax AS price_without_tax_5, t0.vat_rate AS vat_rate_6, t0.discount AS discount_7, t0.unique_key AS unique_key_8, t0.automation AS automation_9, t0.is_published AS is_published_10, t0.is_subscription AS is_subscription_11, t0.published_name AS published_name_12, t0.is_published_pack AS is_published_pack_13, t0.type AS type_14, t0.legal_status AS legal_status_15, t0.created_at AS created_at_16, t0.association_pack_id AS association_pack_id_17, t0.category_id AS category_id_18, t0.recurring_invoice_id AS recurring_invoice_id_19, t0.initial_invoice_id AS initial_invoice_id_20, t0.subscription_id AS subscription_id_21 FROM pack t0 WHERE t0.category_id = ?
Parameters:
[
2
]
|
7 | 1.41 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
3
]
|
8 | 1.95 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.focus AS focus_4, t0.price_without_tax AS price_without_tax_5, t0.vat_rate AS vat_rate_6, t0.discount AS discount_7, t0.unique_key AS unique_key_8, t0.automation AS automation_9, t0.is_published AS is_published_10, t0.is_subscription AS is_subscription_11, t0.published_name AS published_name_12, t0.is_published_pack AS is_published_pack_13, t0.type AS type_14, t0.legal_status AS legal_status_15, t0.created_at AS created_at_16, t0.association_pack_id AS association_pack_id_17, t0.category_id AS category_id_18, t0.recurring_invoice_id AS recurring_invoice_id_19, t0.initial_invoice_id AS initial_invoice_id_20, t0.subscription_id AS subscription_id_21 FROM pack t0 WHERE t0.category_id = ?
Parameters:
[
3
]
|
9 | 6.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
4
]
|
10 | 2.03 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.focus AS focus_4, t0.price_without_tax AS price_without_tax_5, t0.vat_rate AS vat_rate_6, t0.discount AS discount_7, t0.unique_key AS unique_key_8, t0.automation AS automation_9, t0.is_published AS is_published_10, t0.is_subscription AS is_subscription_11, t0.published_name AS published_name_12, t0.is_published_pack AS is_published_pack_13, t0.type AS type_14, t0.legal_status AS legal_status_15, t0.created_at AS created_at_16, t0.association_pack_id AS association_pack_id_17, t0.category_id AS category_id_18, t0.recurring_invoice_id AS recurring_invoice_id_19, t0.initial_invoice_id AS initial_invoice_id_20, t0.subscription_id AS subscription_id_21 FROM pack t0 WHERE t0.category_id = ?
Parameters:
[
4
]
|
11 | 1.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
5
]
|
12 | 4.70 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.focus AS focus_4, t0.price_without_tax AS price_without_tax_5, t0.vat_rate AS vat_rate_6, t0.discount AS discount_7, t0.unique_key AS unique_key_8, t0.automation AS automation_9, t0.is_published AS is_published_10, t0.is_subscription AS is_subscription_11, t0.published_name AS published_name_12, t0.is_published_pack AS is_published_pack_13, t0.type AS type_14, t0.legal_status AS legal_status_15, t0.created_at AS created_at_16, t0.association_pack_id AS association_pack_id_17, t0.category_id AS category_id_18, t0.recurring_invoice_id AS recurring_invoice_id_19, t0.initial_invoice_id AS initial_invoice_id_20, t0.subscription_id AS subscription_id_21 FROM pack t0 WHERE t0.category_id = ?
Parameters:
[
5
]
|
13 | 1.42 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
6
]
|
14 | 1.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.focus AS focus_4, t0.price_without_tax AS price_without_tax_5, t0.vat_rate AS vat_rate_6, t0.discount AS discount_7, t0.unique_key AS unique_key_8, t0.automation AS automation_9, t0.is_published AS is_published_10, t0.is_subscription AS is_subscription_11, t0.published_name AS published_name_12, t0.is_published_pack AS is_published_pack_13, t0.type AS type_14, t0.legal_status AS legal_status_15, t0.created_at AS created_at_16, t0.association_pack_id AS association_pack_id_17, t0.category_id AS category_id_18, t0.recurring_invoice_id AS recurring_invoice_id_19, t0.initial_invoice_id AS initial_invoice_id_20, t0.subscription_id AS subscription_id_21 FROM pack t0 WHERE t0.category_id = ?
Parameters:
[
6
]
|
15 | 1.10 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
7
]
|
16 | 1.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.focus AS focus_4, t0.price_without_tax AS price_without_tax_5, t0.vat_rate AS vat_rate_6, t0.discount AS discount_7, t0.unique_key AS unique_key_8, t0.automation AS automation_9, t0.is_published AS is_published_10, t0.is_subscription AS is_subscription_11, t0.published_name AS published_name_12, t0.is_published_pack AS is_published_pack_13, t0.type AS type_14, t0.legal_status AS legal_status_15, t0.created_at AS created_at_16, t0.association_pack_id AS association_pack_id_17, t0.category_id AS category_id_18, t0.recurring_invoice_id AS recurring_invoice_id_19, t0.initial_invoice_id AS initial_invoice_id_20, t0.subscription_id AS subscription_id_21 FROM pack t0 WHERE t0.category_id = ?
Parameters:
[
7
]
|
17 | 1.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
8
]
|
18 | 1.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.focus AS focus_4, t0.price_without_tax AS price_without_tax_5, t0.vat_rate AS vat_rate_6, t0.discount AS discount_7, t0.unique_key AS unique_key_8, t0.automation AS automation_9, t0.is_published AS is_published_10, t0.is_subscription AS is_subscription_11, t0.published_name AS published_name_12, t0.is_published_pack AS is_published_pack_13, t0.type AS type_14, t0.legal_status AS legal_status_15, t0.created_at AS created_at_16, t0.association_pack_id AS association_pack_id_17, t0.category_id AS category_id_18, t0.recurring_invoice_id AS recurring_invoice_id_19, t0.initial_invoice_id AS initial_invoice_id_20, t0.subscription_id AS subscription_id_21 FROM pack t0 WHERE t0.category_id = ?
Parameters:
[
8
]
|
19 | 1.02 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
9
]
|
20 | 1.47 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.focus AS focus_4, t0.price_without_tax AS price_without_tax_5, t0.vat_rate AS vat_rate_6, t0.discount AS discount_7, t0.unique_key AS unique_key_8, t0.automation AS automation_9, t0.is_published AS is_published_10, t0.is_subscription AS is_subscription_11, t0.published_name AS published_name_12, t0.is_published_pack AS is_published_pack_13, t0.type AS type_14, t0.legal_status AS legal_status_15, t0.created_at AS created_at_16, t0.association_pack_id AS association_pack_id_17, t0.category_id AS category_id_18, t0.recurring_invoice_id AS recurring_invoice_id_19, t0.initial_invoice_id AS initial_invoice_id_20, t0.subscription_id AS subscription_id_21 FROM pack t0 WHERE t0.category_id = ?
Parameters:
[
9
]
|
21 | 1.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
10
]
|
22 | 1.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.focus AS focus_4, t0.price_without_tax AS price_without_tax_5, t0.vat_rate AS vat_rate_6, t0.discount AS discount_7, t0.unique_key AS unique_key_8, t0.automation AS automation_9, t0.is_published AS is_published_10, t0.is_subscription AS is_subscription_11, t0.published_name AS published_name_12, t0.is_published_pack AS is_published_pack_13, t0.type AS type_14, t0.legal_status AS legal_status_15, t0.created_at AS created_at_16, t0.association_pack_id AS association_pack_id_17, t0.category_id AS category_id_18, t0.recurring_invoice_id AS recurring_invoice_id_19, t0.initial_invoice_id AS initial_invoice_id_20, t0.subscription_id AS subscription_id_21 FROM pack t0 WHERE t0.category_id = ?
Parameters:
[
10
]
|
23 | 1.02 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
11
]
|
24 | 1.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.focus AS focus_4, t0.price_without_tax AS price_without_tax_5, t0.vat_rate AS vat_rate_6, t0.discount AS discount_7, t0.unique_key AS unique_key_8, t0.automation AS automation_9, t0.is_published AS is_published_10, t0.is_subscription AS is_subscription_11, t0.published_name AS published_name_12, t0.is_published_pack AS is_published_pack_13, t0.type AS type_14, t0.legal_status AS legal_status_15, t0.created_at AS created_at_16, t0.association_pack_id AS association_pack_id_17, t0.category_id AS category_id_18, t0.recurring_invoice_id AS recurring_invoice_id_19, t0.initial_invoice_id AS initial_invoice_id_20, t0.subscription_id AS subscription_id_21 FROM pack t0 WHERE t0.category_id = ?
Parameters:
[
11
]
|
25 | 1.12 ms |
SELECT COUNT(c0_.id) AS sclr_0 FROM category c0_ WHERE c0_.title LIKE CONCAT('%', ?, '%')
Parameters:
[ "" ] |
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\Category | 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\ActivityDomain | No errors. |
Evo\Infrastructure\MappingORM\ActivitySubdomain | No errors. |
Evo\Infrastructure\MappingORM\ProfessionDetail | No errors. |
Evo\Infrastructure\MappingORM\ProfessionType | No errors. |
Evo\Infrastructure\MappingORM\PostalAddress | No errors. |
Evo\Infrastructure\MappingORM\Payment | No errors. |
Evo\Infrastructure\MappingORM\Item | No errors. |
Evo\Infrastructure\MappingORM\PotentialCase | No errors. |
Evo\Infrastructure\MappingORM\Document | No errors. |
Evo\Infrastructure\MappingORM\DocumentRejectionMessage | No errors. |
Evo\Infrastructure\MappingORM\Person | No errors. |
Evo\Infrastructure\MappingORM\LegalRepresentative | No errors. |
Evo\Infrastructure\MappingORM\Associate | No errors. |
Evo\Infrastructure\MappingORM\ProcessYousign | No errors. |
Evo\Infrastructure\MappingORM\Signature | No errors. |
Evo\Infrastructure\MappingORM\DiscountCode | No errors. |
Evo\Infrastructure\MappingORM\Pack | No errors. |
Evo\Infrastructure\MappingORM\Service | No errors. |
Evo\Infrastructure\MappingORM\ProductHistory | No errors. |
Evo\Infrastructure\MappingORM\DiscountConfiguration | No errors. |