GET https://store.7ap.tech/fr/product/9/test?p=fr%2Fproduct%2F9%2Ftest

Query Metrics

14 Database Queries
11 Different statements
30.35 ms Query time
2 Invalid entities
15 Managed entities

Queries

Group similar statements

# Time Info
1 1.83 ms
SELECT t0.id AS id_1, t0.data AS data_2, t0.is_deleted AS is_deleted_3, t0.created_by_id AS created_by_id_4 FROM general_params t0
Parameters:
[]
2 1.18 ms
SELECT t0.id AS id_1, t0.data AS data_2, t0.is_deleted AS is_deleted_3, t0.created_by_id AS created_by_id_4, t0.general_params_id AS general_params_id_5 FROM top_menu t0 WHERE t0.general_params_id = ?
Parameters:
[
  4
]
3 1.10 ms
SELECT t0.id AS id_1, t0.data AS data_2, t0.is_deleted AS is_deleted_3, t0.created_by_id AS created_by_id_4, t0.general_params_id AS general_params_id_5 FROM top_rs t0 WHERE t0.general_params_id = ?
Parameters:
[
  4
]
4 1.09 ms
SELECT t0.id AS id_1, t0.data AS data_2, t0.is_deleted AS is_deleted_3, t0.created_by_id AS created_by_id_4 FROM categorie t0 WHERE t0.is_deleted IS NULL
Parameters:
[]
5 0.30 ms
SELECT t0.id AS id_1, t0.data AS data_2, t0.is_deleted AS is_deleted_3, t0.created_by_id AS created_by_id_4 FROM categorie t0 WHERE t0.is_deleted IS NULL
Parameters:
[]
6 1.97 ms
SELECT t0.id AS id_1, t0.data AS data_2, t0.is_deleted AS is_deleted_3, t0.created_by_id AS created_by_id_4, t0.general_params_id AS general_params_id_5 FROM top_product t0 WHERE t0.general_params_id = ?
Parameters:
[
  4
]
7 1.21 ms
SELECT t0.id AS id_1, t0.data AS data_2, t0.is_deleted AS is_deleted_3, t0.created_by_id AS created_by_id_4 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  "9"
]
8 0.69 ms
SELECT t0.id AS id_1, t0.data AS data_2, t0.is_deleted AS is_deleted_3, t0.created_by_id AS created_by_id_4, t0.produit_id AS produit_id_5 FROM produit_image t0 WHERE t0.produit_id = ?
Parameters:
[
  9
]
9 0.26 ms
SELECT t0.id AS id_1, t0.data AS data_2, t0.is_deleted AS is_deleted_3, t0.created_by_id AS created_by_id_4 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  "10"
]
10 0.35 ms
SELECT t0.id AS id_1, t0.data AS data_2, t0.is_deleted AS is_deleted_3, t0.created_by_id AS created_by_id_4 FROM categorie t0 WHERE t0.is_deleted IS NULL
Parameters:
[]
11 0.63 ms
SELECT t0.id AS id_1, t0.data AS data_2, t0.is_deleted AS is_deleted_3, t0.created_by_id AS created_by_id_4 FROM produit t0 WHERE t0.id = ? AND t0.is_deleted IS NULL LIMIT 1
Parameters:
[
  "9"
]
12 6.80 ms
SELECT t0.id AS id_1, t0.data AS data_2, t0.is_deleted AS is_deleted_3, t0.created_by_id AS created_by_id_4, t0.produit_id AS produit_id_5 FROM produit_info t0 WHERE t0.produit_id = ?
Parameters:
[
  9
]
13 3.19 ms
SELECT t0.id AS id_1, t0.data AS data_2, t0.is_deleted AS is_deleted_3, t0.created_by_id AS created_by_id_4, t0.produit_id AS produit_id_5, t0.user_id AS user_id_6 FROM produit_review t0 WHERE t0.produit_id = ?
Parameters:
[
  9
]
14 9.73 ms
SELECT t0.id AS id_1, t0.data AS data_2, t0.is_deleted AS is_deleted_3, t0.created_by_id AS created_by_id_4 FROM produit t0 INNER JOIN produit_produit ON t0.id = produit_produit.produit_target WHERE produit_produit.produit_source = ?
Parameters:
[
  9
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\TopMenu 3
App\Entity\Categorie 3
App\Entity\TopRs 2
App\Entity\Produit 2
App\Entity\GeneralParams 1
App\Entity\User 1
App\Entity\TopProduct 1
App\Entity\ProduitImage 1
App\Entity\ProduitInfo 1

Entities Mapping

Class Mapping errors
App\Entity\GeneralParams No errors.
App\Entity\User
  • The association App\Entity\User#produitReviews refers to the owning side field App\Entity\ProduitReview#commented_by which does not exist.
App\Entity\TopMenu No errors.
App\Entity\TopRs No errors.
App\Entity\TopProduct No errors.
App\Entity\Categorie No errors.
App\Entity\Produit No errors.
App\Entity\ProduitImage No errors.
App\Entity\ProduitInfo No errors.
App\Entity\ProduitReview
  • The mappings App\Entity\ProduitReview#user and App\Entity\User#produitReviews are inconsistent with each other.
App\Entity\Commande No errors.