https://resoh.fr/professional/register

Query Metrics

9 Database Queries
7 Different statements
7.89 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 2.23 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.modules_associes AS modules_associes_2 FROM professional_type p0_
Parameters:
[]
2 2.13 ms
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.slug AS slug_2, d0_.status AS status_3, d0_.country_id AS country_id_4 FROM department d0_ WHERE d0_.status = ?
Parameters:
[
  1
]
3 0.98 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.slug AS slug_2, c0_.flag AS flag_3, c0_.flag_image AS flag_image_4, c0_.status AS status_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7 FROM country c0_ WHERE c0_.status = ?
Parameters:
[
  1
]
4 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.src AS src_5, t0.link AS link_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM partner t0 ORDER BY t0.id ASC
Parameters:
[]
5 0.53 ms
SELECT t0.id AS id_1, t0.address AS address_2, t0.longitude AS longitude_3, t0.latitude AS latitude_4, t0.phone AS phone_5, t0.mail AS mail_6, t0.website AS website_7, t0.facebook AS facebook_8, t0.twitter AS twitter_9, t0.linkedin AS linkedin_10, t0.youtube AS youtube_11, t0.instagram AS instagram_12, t0.office AS office_13, t0.description AS description_14, t0.working_hours AS working_hours_15, t0.days_open AS days_open_16, t0.hours_open AS hours_open_17, t0.days_close AS days_close_18, t0.hours_close AS hours_close_19, t0.building AS building_20 FROM contact_page t0 ORDER BY t0.id DESC LIMIT 1
Parameters:
[]
6 0.51 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.status AS status_5, t0.image AS image_6, t0.keywords AS keywords_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.category_id AS category_id_10 FROM article t0 WHERE t0.status = ? ORDER BY t0.id DESC LIMIT 3
Parameters:
[
  1
]
7 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM article_category t0 WHERE t0.id = ?
Parameters:
[
  13
]
8 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM article_category t0 WHERE t0.id = ?
Parameters:
[
  1
]
9 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM article_category t0 WHERE t0.id = ?
Parameters:
[
  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\ProfessionalType No errors.
App\Entity\Department No errors.
App\Entity\Country
  • The association App\Entity\Country#parks refers to the owning side field App\Entity\Park#country which is not defined as association, but as field.
  • The association App\Entity\Country#parks refers to the owning side field App\Entity\Park#country which does not exist.
App\Entity\Transporteur No errors.
App\Entity\City No errors.
App\Entity\Park No errors.
App\Entity\Partner No errors.
App\Entity\User
  • The association App\Entity\User#invoices refers to the owning side field App\Entity\Invoice#user which does not exist.
App\Entity\Collaborateur No errors.
App\Entity\PieceJustificative No errors.
App\Entity\Brand No errors.
App\Entity\VehicleType No errors.
App\Entity\VehicleGroup No errors.
App\Entity\Vehicle No errors.
App\Entity\Acquisition No errors.
App\Entity\Assurance No errors.
App\Entity\ControleTechnique No errors.
App\Entity\ControleTachygraphe No errors.
App\Entity\ControleLimiteurVitesse No errors.
App\Entity\DocumentDriver No errors.
App\Entity\Carburant No errors.
App\Entity\Client No errors.
App\Entity\Devis No errors.
App\Entity\CreditTransaction No errors.
App\Entity\Invoice No errors.
App\Entity\Fonction No errors.
App\Entity\Cin No errors.
App\Entity\Justification No errors.
App\Entity\Attachment No errors.
App\Entity\LegalNotice No errors.
App\Entity\Homepage No errors.
App\Entity\DevisAttachment No errors.
App\Entity\AboutUs No errors.
App\Entity\ArticleCategory No errors.
App\Entity\Faq No errors.
App\Entity\WhyChooseUs No errors.
App\Entity\Contact No errors.
App\Entity\Team No errors.
App\Entity\Admin No errors.
App\Entity\Subscriber No errors.
App\Entity\Newsletter No errors.
App\Entity\DevisEquipment No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\FaqCategory No errors.
App\Entity\PrivacyPolicy No errors.
App\Entity\SubscriberGroup No errors.
App\Entity\DevisVehicleDetails No errors.
App\Entity\Module No errors.
App\Entity\Article No errors.
App\Entity\DevisLuggage No errors.
App\Entity\ContactPage No errors.
App\Entity\Help No errors.
App\Entity\TermsConditions No errors.
App\Entity\Service No errors.
App\Entity\DevisBudget No errors.
App\Entity\DevisTravelReason No errors.
Vich\UploaderBundle\Entity\File No errors.