Query Metrics

11 Database Queries
8 Different statements
8.29 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 2.04 ms
SELECT t0.id AS id_1, t0.background AS background_2, t0.title1 AS title1_3, t0.sub_title1 AS sub_title1_4, t0.title3 AS title3_5, t0.sub_title3 AS sub_title3_6, t0.title4 AS title4_7, t0.sub_title4 AS sub_title4_8, t0.title5 AS title5_9, t0.sub_title5 AS sub_title5_10, t0.title6 AS title6_11, t0.sub_title6 AS sub_title6_12, t0.title7 AS title7_13, t0.sub_title7 AS sub_title7_14, t0.title8 AS title8_15, t0.sub_title8 AS sub_title8_16, t0.title9 AS title9_17, t0.sub_title9 AS sub_title9_18, t0.title10 AS title10_19, t0.sub_title10 AS sub_title10_20, t0.keywords AS keywords_21, t0.description AS description_22 FROM homepage t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.64 ms
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_ ORDER BY s0_.id ASC
Parameters:
[]
3 0.43 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
]
4 1.25 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.sub_title AS sub_title_3, t0.title1 AS title1_4, t0.content1 AS content1_5, t0.icon1 AS icon1_6, t0.title2 AS title2_7, t0.content2 AS content2_8, t0.icon2 AS icon2_9, t0.title3 AS title3_10, t0.content3 AS content3_11, t0.icon3 AS icon3_12, t0.title4 AS title4_13, t0.content4 AS content4_14, t0.icon4 AS icon4_15, t0.title5 AS title5_16, t0.content5 AS content5_17, t0.icon5 AS icon5_18, t0.title6 AS title6_19, t0.content6 AS content6_20, t0.icon6 AS icon6_21, t0.title7 AS title7_22, t0.content7 AS content7_23, t0.icon7 AS icon7_24 FROM why_choose_us t0 ORDER BY t0.id DESC LIMIT 1
Parameters:
[]
5 1.08 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.sub_title AS sub_title_4, t0.background AS background_5, t0.title1 AS title1_6, t0.description1 AS description1_7, t0.image1 AS image1_8, t0.video_link1 AS video_link1_9, t0.title2 AS title2_10, t0.sub_title2 AS sub_title2_11, t0.image2 AS image2_12 FROM about_us t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "notre-histoire"
]
6 0.72 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
]
7 0.46 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
]
8 0.38 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
]
9 0.40 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:
[]
10 0.40 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:
[]
11 0.49 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
]

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\Homepage No errors.
App\Entity\Service No errors.
App\Entity\Devis No errors.
App\Entity\Article No errors.
App\Entity\ArticleCategory No errors.
App\Entity\WhyChooseUs No errors.
App\Entity\AboutUs 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\Cin No errors.
App\Entity\Faq No errors.
App\Entity\ControleLimiteurVitesse 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\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.