http://www.immybeauty.fr/admin/recette/send Return to referer URL

Query Metrics

18 Database Queries
6 Different statements
28.80 ms Query time
5 Invalid entities

Grouped Statements

Show all queries

Time Count Info
12.06 ms
(41.86%)
1
SELECT r0_.id AS id_0, r0_.date AS date_1, r0_.nom_client AS nom_client_2, r0_.acompte AS acompte_3, r0_.total AS total_4, p1_.id AS id_5, p1_.somme_payee AS somme_payee_6, p1_.recette_id AS recette_id_7, p1_.type_paiement_id AS type_paiement_id_8 FROM recette r0_ LEFT JOIN paiement_recette p1_ ON r0_.id = p1_.recette_id WHERE r0_.date >= ? AND r0_.date < ?
Parameters:
[
  "2025-05-02 00:00:00"
  "2025-05-02 23:59:59"
]
5.67 ms
(19.68%)
12
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prix AS prix_3, t0.deleted AS deleted_4, t0.categorie_id AS categorie_id_5 FROM prestation t0 INNER JOIN recette_prestation ON t0.id = recette_prestation.prestation_id WHERE recette_prestation.recette_id = ?
Parameters:
[
  1387
]
4.88 ms
(16.93%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.roles AS roles_4, t0.password AS password_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.slug AS slug_8, t0.birthdate AS birthdate_9, t10.id AS id_11, t10.qr_code_image AS qr_code_image_12, t10.points AS points_13, t10.apple_wallet_token AS apple_wallet_token_14, t10.apple_wallet_push_token AS apple_wallet_push_token_15, t10.device_library_identifier AS device_library_identifier_16, t10.updated_at AS updated_at_17, t10.last_notification AS last_notification_18, t10.user_id AS user_id_19 FROM user t0 LEFT JOIN card t10 ON t10.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  2
]
2.96 ms
(10.29%)
2
SELECT SUM(p0_.somme_payee) AS sclr_0 FROM paiement_recette p0_ INNER JOIN recette r1_ ON p0_.recette_id = r1_.id WHERE r1_.date >= ? AND r1_.date < ? AND p0_.type_paiement_id = ?
Parameters:
[
  "2025-05-02 00:00:00"
  "2025-05-02 23:59:59"
  1
]
2.52 ms
(8.74%)
1
SELECT SUM(r0_.acompte) AS sclr_0 FROM recette r0_ WHERE r0_.date >= ? AND r0_.date < ?
Parameters:
[
  "2025-05-02 00:00:00"
  "2025-05-02 23:59:59"
]
0.72 ms
(2.49%)
1
SELECT t0.id AS id_1, t0.is_winning AS is_winning_2, t0.is_scratched AS is_scratched_3, t0.created_at AS created_at_4, t0.scratched_at AS scratched_at_5, t0.slug AS slug_6, t0.qr_code_path AS qr_code_path_7, t0.active AS active_8, t0.date_used AS date_used_9, t0.user_id AS user_id_10, t0.offre_id AS offre_id_11 FROM ticket_gratter t0 WHERE t0.user_id = ? AND t0.is_scratched = ? LIMIT 1
Parameters:
[
  2
  0
]

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\User No errors.
App\Entity\Card
  • The mappings App\Entity\Card#transactions and App\Entity\CardTransaction#card are inconsistent with each other.
App\Entity\CouponUser No errors.
App\Entity\TicketGratter No errors.
App\Entity\CardTransaction No errors.
App\Entity\Offre No errors.
App\Entity\Recette
  • The field 'App\Entity\Recette#acompte' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Recette#total' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\PaiementRecette
  • The field 'App\Entity\PaiementRecette#sommePayee' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\TypePaiement No errors.
App\Entity\Prestation
  • The field 'App\Entity\Prestation#prix' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Categorie
  • The field App\Entity\Categorie#prestations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Prestation#categorie does not contain the required 'inversedBy="prestations"' attribute.