GET https://pfm.texol.fr/plantrade/1225/priceless

Query Metrics

28 Database Queries
8 Different statements
2.34 ms Query time
0 Invalid entities
125 Managed entities

Queries

Group similar statements

# Time Info
1 0.41 ms
SELECT t0.id AS id_1, t0.annee AS annee_2, t0.groupement AS groupement_3 FROM plan_trade t0 WHERE t0.id = ?
Parameters:
[
  "1225"
]
2 0.10 ms
SELECT t0.id AS id_1, t0.mois AS mois_2, t0.plan_trade_id AS plan_trade_id_3 FROM operation t0 WHERE t0.plan_trade_id IN (?)
Parameters:
[
  1225
]
3 0.13 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 INNER JOIN operation_produit ON t0.id = operation_produit.produit_id WHERE operation_produit.operation_id = ?
Parameters:
[
  26589
]
4 0.10 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 INNER JOIN operation_produit ON t0.id = operation_produit.produit_id WHERE operation_produit.operation_id = ?
Parameters:
[
  26590
]
5 0.08 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 INNER JOIN operation_produit ON t0.id = operation_produit.produit_id WHERE operation_produit.operation_id = ?
Parameters:
[
  26591
]
6 0.07 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 INNER JOIN operation_produit ON t0.id = operation_produit.produit_id WHERE operation_produit.operation_id = ?
Parameters:
[
  26592
]
7 0.06 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 INNER JOIN operation_produit ON t0.id = operation_produit.produit_id WHERE operation_produit.operation_id = ?
Parameters:
[
  26593
]
8 0.06 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 INNER JOIN operation_produit ON t0.id = operation_produit.produit_id WHERE operation_produit.operation_id = ?
Parameters:
[
  26594
]
9 0.09 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 INNER JOIN operation_produit ON t0.id = operation_produit.produit_id WHERE operation_produit.operation_id = ?
Parameters:
[
  26595
]
10 0.07 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 INNER JOIN operation_produit ON t0.id = operation_produit.produit_id WHERE operation_produit.operation_id = ?
Parameters:
[
  26596
]
11 0.05 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 INNER JOIN operation_produit ON t0.id = operation_produit.produit_id WHERE operation_produit.operation_id = ?
Parameters:
[
  26597
]
12 0.05 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 INNER JOIN operation_produit ON t0.id = operation_produit.produit_id WHERE operation_produit.operation_id = ?
Parameters:
[
  26598
]
13 0.05 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 INNER JOIN operation_produit ON t0.id = operation_produit.produit_id WHERE operation_produit.operation_id = ?
Parameters:
[
  26599
]
14 0.06 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 INNER JOIN operation_produit ON t0.id = operation_produit.produit_id WHERE operation_produit.operation_id = ?
Parameters:
[
  26600
]
15 0.05 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 INNER JOIN operation_produit ON t0.id = operation_produit.produit_id WHERE operation_produit.operation_id = ?
Parameters:
[
  26601
]
16 0.07 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 INNER JOIN operation_produit ON t0.id = operation_produit.produit_id WHERE operation_produit.operation_id = ?
Parameters:
[
  26602
]
17 0.08 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 INNER JOIN operation_produit ON t0.id = operation_produit.produit_id WHERE operation_produit.operation_id = ?
Parameters:
[
  26603
]
18 0.05 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.code_ean AS code_ean_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6, t0.couleur_principale AS couleur_principale_7, t0.couleur_secondaire AS couleur_secondaire_8, t0.reduction_prix AS reduction_prix_9, t0.reduction_unite AS reduction_unite_10, t0.hidden AS hidden_11, t0.gamme_id AS gamme_id_12, t0.groupement_id AS groupement_id_13 FROM produit t0 INNER JOIN operation_produit ON t0.id = operation_produit.produit_id WHERE operation_produit.operation_id = ?
Parameters:
[
  26604
]
19 0.08 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.couleur_principale AS couleur_principale_3, t0.couleur_secondaire AS couleur_secondaire_4, t0.couleur_bordure AS couleur_bordure_5 FROM gamme t0 WHERE t0.id = ?
Parameters:
[
  1
]
20 0.08 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3 FROM produit_groupement t0 WHERE t0.id = ?
Parameters:
[
  1
]
21 0.06 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.couleur_principale AS couleur_principale_3, t0.couleur_secondaire AS couleur_secondaire_4, t0.couleur_bordure AS couleur_bordure_5 FROM gamme t0 WHERE t0.id = ?
Parameters:
[
  2
]
22 0.06 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.couleur_principale AS couleur_principale_3, t0.couleur_secondaire AS couleur_secondaire_4, t0.couleur_bordure AS couleur_bordure_5 FROM gamme t0 WHERE t0.id = ?
Parameters:
[
  3
]
23 0.08 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.couleur_principale AS couleur_principale_3, t0.couleur_secondaire AS couleur_secondaire_4, t0.couleur_bordure AS couleur_bordure_5 FROM gamme t0 WHERE t0.id = ?
Parameters:
[
  4
]
24 0.06 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.couleur_principale AS couleur_principale_3, t0.couleur_secondaire AS couleur_secondaire_4, t0.couleur_bordure AS couleur_bordure_5 FROM gamme t0 WHERE t0.id = ?
Parameters:
[
  9
]
25 0.06 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.couleur_principale AS couleur_principale_3, t0.couleur_secondaire AS couleur_secondaire_4, t0.couleur_bordure AS couleur_bordure_5 FROM gamme t0 WHERE t0.id = ?
Parameters:
[
  5
]
26 0.09 ms
SELECT t0.id AS id_1, t0.annee AS annee_2 FROM plan_media t0 WHERE t0.annee = ? LIMIT 1
Parameters:
[
  2026
]
27 0.06 ms
SELECT t0.id AS id_1, t0.prefix AS prefix_2, t0.months AS months_3, t0.plan_media_id AS plan_media_id_4, t0.gamme_id AS gamme_id_5 FROM plan_media_operation t0 WHERE t0.plan_media_id = ?
Parameters:
[
  1
]
28 0.09 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.updated_at AS updated_at_3, t0.correspondances AS correspondances_4 FROM logo t0
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Logo 82
App\Entity\Operation 16
App\Entity\Produit 13
App\Entity\Gamme 6
App\Entity\PlanMediaOperation 5
App\Entity\PlanTrade 1
App\Entity\ProduitGroupement 1
App\Entity\PlanMedia 1

Entities Mapping

Class Mapping errors
App\Entity\PlanTrade No errors.
App\Entity\Operation No errors.
App\Entity\Produit No errors.
App\Entity\Gamme No errors.
App\Entity\ProduitGroupement No errors.
App\Entity\PlanMedia No errors.
App\Entity\PlanMediaOperation No errors.
App\Entity\Logo No errors.