Query Metrics

15 Database Queries
4 Different statements
9.91 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.16 ms
SELECT p0_.id AS id_0, p0_.weight AS weight_1, p0_.price_buy AS price_buy_2, p0_.price_sell AS price_sell_3, p0_.length AS length_4, p0_.width AS width_5, p0_.active AS active_6, p0_.height AS height_7, p0_.discriminator AS discriminator_8, p0_.carrier_id AS carrier_id_9, p0_.country_id AS country_id_10 FROM pm_carrier_price_postman p1_ INNER JOIN pm_carrier_price p0_ ON p1_.id = p0_.id WHERE p0_.active = true ORDER BY p0_.country_id ASC, p0_.weight ASC
Parameters:
[]
2 1.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.nameOrigin AS nameorigin_3, t0.iso3 AS iso3_4, t0.iso AS iso_5, t0.vat AS vat_6, t0.language_id AS language_id_7, t0.currency_id AS currency_id_8 FROM pm_country t0 WHERE t0.id = ?
Parameters:
[
  2
]
3 0.62 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.nameOrigin AS nameorigin_3, t0.iso3 AS iso3_4, t0.iso AS iso_5, t0.vat AS vat_6, t0.language_id AS language_id_7, t0.currency_id AS currency_id_8 FROM pm_country t0 WHERE t0.id = ?
Parameters:
[
  3
]
4 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.nameOrigin AS nameorigin_3, t0.iso3 AS iso3_4, t0.iso AS iso_5, t0.vat AS vat_6, t0.language_id AS language_id_7, t0.currency_id AS currency_id_8 FROM pm_country t0 WHERE t0.id = ?
Parameters:
[
  4
]
5 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.nameOrigin AS nameorigin_3, t0.iso3 AS iso3_4, t0.iso AS iso_5, t0.vat AS vat_6, t0.language_id AS language_id_7, t0.currency_id AS currency_id_8 FROM pm_country t0 WHERE t0.id = ?
Parameters:
[
  5
]
6 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.nameOrigin AS nameorigin_3, t0.iso3 AS iso3_4, t0.iso AS iso_5, t0.vat AS vat_6, t0.language_id AS language_id_7, t0.currency_id AS currency_id_8 FROM pm_country t0 WHERE t0.id = ?
Parameters:
[
  6
]
7 0.75 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.nameOrigin AS nameorigin_3, t0.iso3 AS iso3_4, t0.iso AS iso_5, t0.vat AS vat_6, t0.language_id AS language_id_7, t0.currency_id AS currency_id_8 FROM pm_country t0 WHERE t0.id = ?
Parameters:
[
  7
]
8 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.nameOrigin AS nameorigin_3, t0.iso3 AS iso3_4, t0.iso AS iso_5, t0.vat AS vat_6, t0.language_id AS language_id_7, t0.currency_id AS currency_id_8 FROM pm_country t0 WHERE t0.id = ?
Parameters:
[
  8
]
9 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.nameOrigin AS nameorigin_3, t0.iso3 AS iso3_4, t0.iso AS iso_5, t0.vat AS vat_6, t0.language_id AS language_id_7, t0.currency_id AS currency_id_8 FROM pm_country t0 WHERE t0.id = ?
Parameters:
[
  9
]
10 0.99 ms
SELECT t0.key AS key_1, t0.value AS value_2, t0.modified AS modified_3, t0.description AS description_4 FROM pm_configuration t0 WHERE t0.key = ? LIMIT 1
Parameters:
[
  "support_postman_email"
]
11 0.38 ms
SELECT t0.key AS key_1, t0.value AS value_2, t0.modified AS modified_3, t0.description AS description_4 FROM pm_configuration t0 WHERE t0.key = ?
Parameters:
[
  "support_postman_email"
]
12 0.37 ms
SELECT t0.key AS key_1, t0.value AS value_2, t0.modified AS modified_3, t0.description AS description_4 FROM pm_configuration t0 WHERE t0.key = ? LIMIT 1
Parameters:
[
  "support_postman_phone"
]
13 0.37 ms
SELECT t0.key AS key_1, t0.value AS value_2, t0.modified AS modified_3, t0.description AS description_4 FROM pm_configuration t0 WHERE t0.key = ?
Parameters:
[
  "support_postman_phone"
]
14 0.68 ms
SELECT t0.key AS key_1, t0.value AS value_2, t0.modified AS modified_3, t0.description AS description_4 FROM pm_configuration t0 WHERE t0.key = ? LIMIT 1
Parameters:
[
  "support_postman_email"
]
15 0.44 ms
SELECT t0.key AS key_1, t0.value AS value_2, t0.modified AS modified_3, t0.description AS description_4 FROM pm_configuration t0 WHERE t0.key = ?
Parameters:
[
  "support_postman_email"
]

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
App\Entity\Configuration No errors.
App\Entity\CarrierPrice No errors.
App\Entity\CarrierPricePostman No errors.
App\Entity\Carrier No errors.
App\Entity\Country No errors.
App\Entity\Language No errors.
App\Entity\Currency No errors.