http://staging.api.digidom.pro/v1/stores?q=%2Fv1%2Fstores

Query Metrics

32 Database Queries
5 Different statements
32.29 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
16.51 ms
(51.12%)
12
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_.name LIKE ? AND p0_.active = 0
Parameters:
[
  "%75008%"
]
9.00 ms
(27.86%)
12
SELECT t0.id AS id_1, t0.address_country AS address_country_2, t0.address_locality AS address_locality_3, t0.address_region AS address_region_4, t0.postal_code AS postal_code_5, t0.street_address AS street_address_6, t0.standardized_address AS standardized_address_7 FROM postal_address t0 WHERE t0.id = ?
Parameters:
[
  63735
]
3.99 ms
(12.37%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.url_image AS url_image_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM sector t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.66 ms
(5.15%)
1
SELECT COUNT(s0_.id) AS sclr_0 FROM store s0_
Parameters:
[]
1.13 ms
(3.51%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.opening_hours AS opening_hours_2, s0_.currencies_accepted AS currencies_accepted_3, s0_.payment_accepted_type AS payment_accepted_type_4, s0_.price_range AS price_range_5, s0_.aggregate_rating AS aggregate_rating_6, s0_.created_at AS created_at_7, s0_.prefectoral_approval_number AS prefectoral_approval_number_8, s0_.status AS status_9, s0_.cedex AS cedex_10, s0_.is_exportable_ibml AS is_exportable_ibml_11, s0_.postal_address_id AS postal_address_id_12, s0_.sector_id AS sector_id_13 FROM store s0_ ORDER BY s0_.id ASC LIMIT 30
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\Store No errors.
Evo\Infrastructure\MappingORM\PostalAddress No errors.
Evo\Infrastructure\MappingORM\Sector No errors.
Evo\Infrastructure\MappingORM\ActivityDomain No errors.
Evo\Infrastructure\MappingORM\ActivityLog No errors.
Evo\Infrastructure\MappingORM\ActivitySubdomain No errors.
Evo\Infrastructure\MappingORM\Organization No errors.
Evo\Infrastructure\MappingORM\ProfessionDetail No errors.
Evo\Infrastructure\MappingORM\ProfessionType No errors.
Evo\Infrastructure\MappingORM\User No errors.
Evo\Infrastructure\MappingORM\CreditNote No errors.
Evo\Infrastructure\MappingORM\Payment No errors.
Evo\Infrastructure\MappingORM\Item No errors.
Evo\Infrastructure\MappingORM\Category No errors.
Evo\Infrastructure\MappingORM\Pack No errors.
Evo\Infrastructure\MappingORM\Service No errors.
Evo\Infrastructure\MappingORM\PappersActivityLogWrapper No errors.
Evo\Infrastructure\MappingORM\Quote No errors.
Evo\Infrastructure\MappingORM\DiscountCode No errors.
Evo\Infrastructure\MappingORM\BAL No errors.
Evo\Infrastructure\MappingORM\ProductHistory No errors.
Evo\Infrastructure\MappingORM\DiscountConfiguration No errors.