https://resoh.fr/blog/optimisation-des-flottes/utiliser-lanalyse-de-donnees-pour-une-meilleure-gestion-des-flottes

Query Metrics

18 Database Queries
8 Different statements
6.52 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.63 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.slug = ? LIMIT 1
Parameters:
[
  "utiliser-lanalyse-de-donnees-pour-une-meilleure-gestion-des-flottes"
]
2 0.32 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
]
3 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM article_category t0 ORDER BY t0.id DESC
Parameters:
[]
4 0.75 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.status AS status_4, a0_.image AS image_5, a0_.keywords AS keywords_6, a0_.created_at AS created_at_7, a0_.updated_at AS updated_at_8, a0_.category_id AS category_id_9 FROM article a0_ WHERE a0_.status = 1 AND a0_.id <> ? AND a0_.category_id = ? ORDER BY a0_.id DESC LIMIT 10
Parameters:
[
  21
  1
]
5 0.38 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.category_id = ?
Parameters:
[
  13
]
6 0.29 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.category_id = ?
Parameters:
[
  12
]
7 0.20 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.category_id = ?
Parameters:
[
  11
]
8 0.21 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.category_id = ?
Parameters:
[
  9
]
9 0.21 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.category_id = ?
Parameters:
[
  8
]
10 0.20 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.category_id = ?
Parameters:
[
  7
]
11 0.18 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.category_id = ?
Parameters:
[
  6
]
12 0.19 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.category_id = ?
Parameters:
[
  5
]
13 0.21 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.category_id = ?
Parameters:
[
  4
]
14 0.20 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.category_id = ?
Parameters:
[
  3
]
15 0.20 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.category_id = ?
Parameters:
[
  2
]
16 0.31 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:
[]
17 0.34 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:
[]
18 0.37 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\Article No errors.
App\Entity\ArticleCategory No errors.
App\Entity\Partner No errors.
App\Entity\Vehicle No errors.
App\Entity\LegalNotice No errors.
App\Entity\Homepage No errors.
App\Entity\DevisAttachment No errors.
App\Entity\Devis No errors.
App\Entity\Cin No errors.
App\Entity\AboutUs No errors.
App\Entity\Faq No errors.
App\Entity\Client 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\Invoice 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\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\DevisEquipment No errors.
App\Entity\Collaborateur 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\DevisVehicleDetails No errors.
App\Entity\CreditTransaction No errors.
App\Entity\DocumentDriver No errors.
App\Entity\Attachment No errors.
App\Entity\Transporteur No errors.
App\Entity\Module No errors.
App\Entity\City No errors.
App\Entity\ProfessionalType No errors.
App\Entity\Assurance No errors.
App\Entity\DevisLuggage No errors.
App\Entity\Department No errors.
App\Entity\ContactPage No errors.
App\Entity\Help No errors.
App\Entity\TermsConditions No errors.
App\Entity\Service No errors.
App\Entity\VehicleType No errors.
App\Entity\DevisBudget No errors.
App\Entity\Acquisition No errors.
App\Entity\DevisTravelReason No errors.
Vich\UploaderBundle\Entity\File No errors.