https://resoh.fr/service/autocar

Query Metrics

8 Database Queries
6 Different statements
6.62 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.90 ms
(28.70%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.service_type AS service_type_5, t0.image AS image_6, t0.icone AS icone_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM service t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "autocar"
]
1.51 ms
(22.83%)
3
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
]
0.97 ms
(14.69%)
1
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.description AS description_3, s0_.service_type AS service_type_4, s0_.image AS image_5, s0_.icone AS icone_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8 FROM service s0_ WHERE s0_.id <> ? ORDER BY s0_.id ASC
Parameters:
[
  1
]
0.87 ms
(13.21%)
1
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:
[]
0.80 ms
(12.07%)
1
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
]
0.56 ms
(8.50%)
1
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:
[]

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\Service No errors.
App\Entity\Devis No errors.
App\Entity\Partner No errors.
App\Entity\DevisLuggage No errors.
App\Entity\DevisTravelReason No errors.
App\Entity\DevisBudget No errors.
App\Entity\DevisEquipment No errors.
App\Entity\DevisVehicleDetails No errors.
App\Entity\DevisAttachment 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\Client No errors.
App\Entity\Transporteur No errors.
App\Entity\Collaborateur No errors.
App\Entity\CreditTransaction No errors.
App\Entity\Invoice No errors.
App\Entity\Vehicle No errors.
App\Entity\LegalNotice No errors.
App\Entity\Homepage No errors.
App\Entity\Cin No errors.
App\Entity\AboutUs No errors.
App\Entity\ArticleCategory No errors.
App\Entity\Faq No errors.
App\Entity\ControleLimiteurVitesse No errors.
App\Entity\WhyChooseUs No errors.
App\Entity\Carburant No errors.
App\Entity\Contact No errors.
App\Entity\Team No errors.
App\Entity\Admin No errors.
App\Entity\Brand No errors.
App\Entity\Subscriber 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\VehicleGroup No errors.
App\Entity\Park No errors.
App\Entity\Newsletter No errors.
App\Entity\ControleTachygraphe No errors.
App\Entity\ControleTechnique No errors.
App\Entity\PieceJustificative No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\Fonction No errors.
App\Entity\FaqCategory No errors.
App\Entity\PrivacyPolicy No errors.
App\Entity\SubscriberGroup No errors.
App\Entity\Justification No errors.
App\Entity\DocumentDriver No errors.
App\Entity\Attachment No errors.
App\Entity\Module No errors.
App\Entity\Article No errors.
App\Entity\City No errors.
App\Entity\ProfessionalType No errors.
App\Entity\Assurance No errors.
App\Entity\Department No errors.
App\Entity\ContactPage No errors.
App\Entity\Help No errors.
App\Entity\TermsConditions No errors.
App\Entity\VehicleType No errors.
App\Entity\Acquisition No errors.
Vich\UploaderBundle\Entity\File No errors.