Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

1.03 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	1.03 ms	SELECT p0_.id AS id_0, p0_.netapayer AS netapayer_1, p0_.bareme AS bareme_2, p0_.profil AS profil_3 FROM pbareme p0_ INNER JOIN lnaturecontrat_bareme l1_ ON p0_.id = l1_.bareme_id WHERE l1_.naturecontrat_id = ? AND p0_.active = 1 AND (p0_.classe = ? OR p0_.classe IS NULL) Parameters: [`"4" "Classe 1"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.netapayer AS netapayer_1, p0_.bareme AS bareme_2, p0_.profil AS profil_3 FROM pbareme p0_ INNER JOIN lnaturecontrat_bareme l1_ ON p0_.id = l1_.bareme_id WHERE l1_.naturecontrat_id = ? AND p0_.active = 1 AND ( p0_.classe = ? OR p0_.classe IS NULL ) SELECT p0_.id AS id_0, p0_.netapayer AS netapayer_1, p0_.bareme AS bareme_2, p0_.profil AS profil_3 FROM pbareme p0_ INNER JOIN lnaturecontrat_bareme l1_ ON p0_.id = l1_.bareme_id WHERE l1_.naturecontrat_id = '4' AND p0_.active = 1 AND (p0_.classe = 'Classe 1' OR p0_.classe IS NULL);

#▲

Time

Info

1.03 ms

SELECT p0_.id AS id_0, p0_.netapayer AS netapayer_1, p0_.bareme AS bareme_2, p0_.profil AS profil_3 FROM pbareme p0_ INNER JOIN lnaturecontrat_bareme l1_ ON p0_.id = l1_.bareme_id WHERE l1_.naturecontrat_id = ? AND p0_.active = 1 AND (p0_.classe = ? OR p0_.classe IS NULL)

Parameters:

[
  "4"
  "Classe 1"
]

View formatted query View runnable query Explain query

SELECT
  p0_.id AS id_0,
  p0_.netapayer AS netapayer_1,
  p0_.bareme AS bareme_2,
  p0_.profil AS profil_3
FROM
  pbareme p0_
  INNER JOIN lnaturecontrat_bareme l1_ ON p0_.id = l1_.bareme_id
WHERE
  l1_.naturecontrat_id = ?
  AND p0_.active = 1
  AND (
    p0_.classe = ?
    OR p0_.classe IS NULL
  )

SELECT p0_.id AS id_0, p0_.netapayer AS netapayer_1, p0_.bareme AS bareme_2, p0_.profil AS profil_3 FROM pbareme p0_ INNER JOIN lnaturecontrat_bareme l1_ ON p0_.id = l1_.bareme_id WHERE l1_.naturecontrat_id = '4' AND p0_.active = 1 AND (p0_.classe = 'Classe 1' OR p0_.classe IS NULL);

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\Pbareme	The association App\Entity\Pbareme#nature_cab_id refers to the owning side field App\Entity\PNaturesalarieCab#pbareme which does not exist.
App\Entity\LnaturecontratBareme	No errors.

Symfony Profiler

http://drh-fcz.ma/api/api_getbareme_contract/4

Configuration Settings

Theme