http://dev.api.digidom.pro/v1/categories?active=true&q=%2Fv1%2Fcategories&title=

Query Metrics

25 Database Queries
5 Different statements
63.69 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
31.72 ms
(49.81%)
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:
[
  "stanislas@digidom.pro"
  "stanislas@digidom.pro"
]
16.89 ms
(26.52%)
11
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
]
12.49 ms
(19.62%)
11
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
]
1.55 ms
(2.43%)
1
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:
[
  ""
]
1.03 ms
(1.63%)
1
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.