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

Query Metrics

13 Database Queries
12 Different statements
8.23 ms Query time
5 Invalid entities

Queries

Group similar statements

# Time Info
1 1.52 ms
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 0.41 ms
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
]
3 0.32 ms
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 WHERE t0.id = ?
Parameters:
[
  "319"
]
4 0.31 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM type_paiement t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
5 0.25 ms
"START TRANSACTION"
Parameters:
[]
6 0.83 ms
INSERT INTO recette (date, nom_client, acompte, total) VALUES (?, ?, ?, ?)
Parameters:
[
  "2025-05-02 17:49:41"
  "celia derradji"
  25.0
  25.0
]
7 0.52 ms
INSERT INTO paiement_recette (somme_payee, recette_id, type_paiement_id) VALUES (?, ?, ?)
Parameters:
[
  0.0
  1400
  2
]
8 0.31 ms
UPDATE prestation SET prix = ? WHERE id = ?
Parameters:
[
  25.0
  319
]
9 0.32 ms
INSERT INTO recette_prestation (recette_id, prestation_id) VALUES (?, ?)
Parameters:
[
  1400
  319
]
10 1.34 ms
"COMMIT"
Parameters:
[]
11 0.78 ms
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"
]
12 0.67 ms
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
]
13 0.64 ms
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"
  2
]

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\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.
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\TypePaiement No errors.
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.