GET https://admin.smartimmo-app.com/admin/entreprise/details/703b8a1f4d4fac508457b0418ef4c729

Query Metrics

7 Database Queries
7 Different statements
7.86 ms Query time
8 Invalid entities

Queries

Group similar statements

# Time Info
1 1.40 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.name AS name_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.code AS code_7, t0.phone AS phone_8, t0.sexe AS sexe_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.role_id AS role_id_13, t0.admin_id AS admin_id_14 FROM admin t0 WHERE t0.id = ?
Parameters:
[
  4
]
2 1.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.role AS role_3 FROM roles t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 1.51 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.adress AS adress_4, t0.email AS email_5, t0.phone AS phone_6, t0.pseudo AS pseudo_7, t0.description AS description_8, t0.rccm AS rccm_9, t0.icon AS icon_10, t0.status AS status_11, t0.smsservice AS smsservice_12, t0.invoiceservice AS invoiceservice_13, t0.idnat AS idnat_14, t0.numeroimpot AS numeroimpot_15, t0.city AS city_16, t0.province AS province_17, t0.nbrebiensimmobiliers AS nbrebiensimmobiliers_18, t0.free_trail AS free_trail_19, t0.period AS period_20, t0.recallpaymentnotification AS recallpaymentnotification_21, t0.smart_paykey AS smart_paykey_22, t0.make_journal AS make_journal_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.admin_id AS admin_id_26, t0.country_id AS country_id_27, t0.package_id AS package_id_28, t0.owner_id AS owner_id_29 FROM entreprise t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "703b8a1f4d4fac508457b0418ef4c729"
]
4 1.13 ms
SELECT t0.id AS id_1, t0.order_number AS order_number_2, t0.amount AS amount_3, t0.currency AS currency_4, t0.billing_cycle AS billing_cycle_5, t0.months_count AS months_count_6, t0.status AS status_7, t0.paid AS paid_8, t0.gateway_reference AS gateway_reference_9, t0.checkout_url AS checkout_url_10, t0.gateway_payload AS gateway_payload_11, t0.paid_at AS paid_at_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.subscription_id AS subscription_id_15, t0.entreprise_id AS entreprise_id_16, t0.package_id AS package_id_17 FROM subscription_payment t0 WHERE t0.entreprise_id = ? ORDER BY t0.id DESC
Parameters:
[
  56
]
5 0.90 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.description AS description_3, t0.publish AS publish_4, t0.name AS name_5, t0.price AS price_6, t0.priceannuel AS priceannuel_7, t0.max_units AS max_units_8, t0.trial_months AS trial_months_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM package t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.82 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.country_code AS country_code_3, t0.name AS name_4, t0.iso_code AS iso_code_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by_id AS created_by_id_9 FROM country t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 1.04 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.name AS name_4, t0.lastname AS lastname_5, t0.code AS code_6, t0.status AS status_7, t0.reset AS reset_8, t0.sexe AS sexe_9, t0.phone AS phone_10, t0.picture AS picture_11, t0.notif AS notif_12, t0.email AS email_13, t0.profil AS profil_14, t0.level AS level_15, t0.adress AS adress_16, t0.city AS city_17, t0.province AS province_18, t0.mode AS mode_19, t0.last_action AS last_action_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.role_id AS role_id_23, t0.entreprise_id AS entreprise_id_24, t0.created_by_id AS created_by_id_25, t0.country_id AS country_id_26 FROM User t0 WHERE t0.id = ?
Parameters:
[
  66
]

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\Admin
  • The association App\Entity\Admin#role refers to the inverse side field App\Entity\Roles#admins which does not exist.
App\Entity\Roles
  • The mappings App\Entity\Roles#users and App\Entity\Admin#role are inconsistent with each other.
App\Entity\Entreprise
  • The association App\Entity\Entreprise#admin refers to the inverse side field App\Entity\Admin#entreprises which does not exist.
App\Entity\Country No errors.
App\Entity\Package No errors.
App\Entity\User No errors.
App\Entity\Role No errors.
App\Entity\CategoryResidence
  • The association App\Entity\CategoryResidence#createdBy refers to the inverse side field App\Entity\User#categoryResidences which does not exist.
App\Entity\ResidenceImmeuble No errors.
App\Entity\PaymentGenerator No errors.
App\Entity\Prestataire No errors.
App\Entity\Incident No errors.
App\Entity\Template No errors.
App\Entity\PaymentGaranty
  • The association App\Entity\PaymentGaranty#modePayment refers to the inverse side field App\Entity\PaymentMode#paymentGaranties which does not exist.
  • The association App\Entity\PaymentGaranty#createdBy refers to the inverse side field App\Entity\User#paymentGaranties which does not exist.
App\Entity\IncidentUpdate No errors.
App\Entity\Service No errors.
App\Entity\Subscription No errors.
App\Entity\Announcement No errors.
App\Entity\CashJournal No errors.
App\Entity\CashJournalEntry No errors.
App\Entity\Charge No errors.
App\Entity\ChargeAllocation No errors.
App\Entity\Log No errors.
App\Entity\Reservation
  • The association App\Entity\Reservation#habitat refers to the inverse side field App\Entity\Habitat#reservations which does not exist.
App\Entity\UserEntreprise No errors.
App\Entity\SubscriptionPayment No errors.
App\Entity\Province No errors.
App\Entity\Residence
  • The association App\Entity\Residence#createdBy refers to the inverse side field App\Entity\User#residences which does not exist.
  • The association App\Entity\Residence#marchand refers to the inverse side field App\Entity\Entreprise#residences which does not exist.
App\Entity\Location
  • The association App\Entity\Location#marchand refers to the inverse side field App\Entity\Entreprise#locations which does not exist.