https://jobingwada.fr/offer-notification/0

Query Metrics

3 Database Queries
3 Different statements
1.19 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.46 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.price AS price_2, t0.content AS content_3, t0.delay AS delay_4, t0.accepted AS accepted_5, t0.view AS view_6, t0.created_at AS created_at_7, t0.offer_id AS offer_id_8, t0.account_form_id AS account_form_id_9, t10.id AS id_11, t10.items AS items_12, t10.active AS active_13, t10.time AS time_14, t10.total AS total_15, t10.day_number AS day_number_16, t10.week_number AS week_number_17, t10.month_number AS month_number_18, t10.year_number AS year_number_19, t10.status AS status_20, t10.payment_intent_id AS payment_intent_id_21, t10.customer_id AS customer_id_22, t10.account_form_id AS account_form_id_23, t10.user_id AS user_id_24, t10.proposal_id AS proposal_id_25 FROM proposal t0 LEFT JOIN Orders t10 ON t10.proposal_id = t0.id WHERE t0.account_form_id = ? AND t0.accepted = ?
Parameters:
[
  1
  0
]
0.40 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.is_verified AS is_verified_5, t0.verification_token AS verification_token_6, t0.roles AS roles_7, t0.password AS password_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.image_profil_fb AS image_profil_fb_11, t0.users_loyalty AS users_loyalty_12, t0.user_mangopay_id_natural AS user_mangopay_id_natural_13, t0.phone AS phone_14, t0.customer_stripe_id AS customer_stripe_id_15, t0.user_account_id AS user_account_id_16, t0.accountform_id AS accountform_id_17, t0.image_profil_id AS image_profil_id_18 FROM user t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.33 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.url_image AS url_image_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4 FROM image_profil t0 WHERE t0.id = ?
Parameters:
[
  4
]

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
  • The association App\Entity\User#orders refers to the owning side field App\Entity\Orders#User which does not exist.
App\Entity\UserAccount No errors.
App\Entity\AccountForm
  • The mappings App\Entity\AccountForm#customLoyalty and App\Entity\CustomersLoyalty#accountForm are inconsistent with each other.
  • The mappings App\Entity\AccountForm#orders and App\Entity\Orders#accountForm are inconsistent with each other.
App\Entity\ImageProfil No errors.
App\Entity\Reviews No errors.
App\Entity\Message No errors.
App\Entity\Orders
  • The association App\Entity\Orders#accountForm refers to the inverse side field App\Entity\AccountForm#Orders which does not exist.
  • The mappings App\Entity\Orders#user and App\Entity\User#orders are inconsistent with each other.
App\Entity\Offers No errors.
App\Entity\Proposal No errors.