http://staging.api.digidom.pro/v1/products?q=%2Fv1%2Fproducts&uniqueKey=SCAN_ENVELOPPE

Query Metrics

8 Database Queries
6 Different statements
139.83 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 51.15 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:
[
  "stanislas@digidom.pro"
  "stanislas@digidom.pro"
]
2 37.40 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:
[
  "25745@digidom.pro"
  "25745@digidom.pro"
]
3 42.11 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:
[
  "_2a433848cdb6ce51923c226a79d374f1"
  "_2a433848cdb6ce51923c226a79d374f1"
]
4 1.54 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.alternate_name AS alternate_name_2, p0_.price_without_tax AS price_without_tax_3, p0_.description AS description_4, p0_.active AS active_5, p0_.meta_description AS meta_description_6, p0_.meta_title AS meta_title_7, p0_.url AS url_8, p0_.created_at AS created_at_9, p0_.subscription_type AS subscription_type_10, p0_.unique_key AS unique_key_11, p0_.is_displayed AS is_displayed_12, p0_.is_archived AS is_archived_13, p0_.is_subscription_component AS is_subscription_component_14, p0_.category_id AS category_id_15, p0_.category_for_billing_report_id AS category_for_billing_report_id_16 FROM product p0_ WHERE p0_.unique_key = ? ORDER BY p0_.id ASC LIMIT 30
Parameters:
[
  "SCAN_ENVELOPPE"
]
5 1.20 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.description AS description_4, t0.meta_description AS meta_description_5, t0.meta_title AS meta_title_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.type AS type_9 FROM category t0 WHERE t0.id = ?
Parameters:
[
  2
]
6 3.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.opening_hours AS opening_hours_3, t0.currencies_accepted AS currencies_accepted_4, t0.payment_accepted_type AS payment_accepted_type_5, t0.price_range AS price_range_6, t0.aggregate_rating AS aggregate_rating_7, t0.created_at AS created_at_8, t0.prefectoral_approval_number AS prefectoral_approval_number_9, t0.status AS status_10, t0.cedex AS cedex_11, t0.is_exportable_ibml AS is_exportable_ibml_12, t0.postal_address_id AS postal_address_id_13, t0.sector_id AS sector_id_14 FROM store t0 INNER JOIN product_store ON t0.id = product_store.store_id WHERE product_store.product_id = ?
Parameters:
[
  5
]
7 2.01 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price AS price_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.subscription_type AS subscription_type_10, t0.created_at AS created_at_11, t0.product_id AS product_id_12 FROM product_history t0 WHERE t0.product_id = ?
Parameters:
[
  5
]
8 1.18 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.unique_key = ?
Parameters:
[
  "SCAN_ENVELOPPE"
]

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\Pack No errors.
Evo\Infrastructure\MappingORM\PostalAddress No errors.
Evo\Infrastructure\MappingORM\DiscountCode 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\Order No errors.
Evo\Infrastructure\MappingORM\Service No errors.
Evo\Infrastructure\MappingORM\ProductHistory No errors.
Evo\Infrastructure\MappingORM\DiscountConfiguration No errors.
Evo\Infrastructure\MappingORM\Sector No errors.