POST https://b2c-leobro.url.org.ua/delivery/api/np-pickup-cities?q=%D0%BB%D1%83%D1%86

Query Metrics

2 Database Queries
2 Different statements
12.01 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 8.04 ms
SELECT n0_.id AS id_0, n0_.ref AS ref_1, n0_.settlement_ref AS settlement_ref_2, n0_.type AS type_3, n0_.name AS name_4, n0_.region AS region_5, n0_.district AS district_6, n0_.updated AS updated_7, n0_.active AS active_8, n0_.longitude AS longitude_9, n0_.latitude AS latitude_10, n0_.region_ref AS region_ref_11 FROM np_cities n0_ WHERE n0_.name LIKE ? LIMIT 10
Parameters:
[
  "луц%"
]
2 3.97 ms
SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM np_cities n0_ WHERE n0_.name LIKE ? ORDER BY n0_.id ASC
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
SoftUa\NovaPoshtaDeliveryBundle\Entity\City No errors.