https://resoh.fr/help-faq

Query Metrics

13 Database Queries
7 Different statements
9.10 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 2.38 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.sub_title AS sub_title_3, t0.background AS background_4, t0.video AS video_5, t0.description AS description_6, t0.btn_name AS btn_name_7, t0.btn_link AS btn_link_8, t0.video_image AS video_image_9, t0.video_link AS video_link_10, t0.helpful_title AS helpful_title_11, t0.helpful_subtitle AS helpful_subtitle_12, t0.helpful_title1 AS helpful_title1_13, t0.helpful_subtitle1 AS helpful_subtitle1_14, t0.helpful_icon1 AS helpful_icon1_15, t0.helpful_title2 AS helpful_title2_16, t0.helpful_subtitle2 AS helpful_subtitle2_17, t0.helpful_icon2 AS helpful_icon2_18, t0.helpful_title3 AS helpful_title3_19, t0.helpful_subtitle3 AS helpful_subtitle3_20, t0.helpful_icon3 AS helpful_icon3_21 FROM help t0 ORDER BY t0.id DESC LIMIT 1
Parameters:
[]
2 0.74 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM faq_category t0 ORDER BY t0.id ASC
Parameters:
[]
3 1.04 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.slug AS slug_3, t0.answer AS answer_4, t0.category_id AS category_id_5 FROM faq t0 WHERE t0.category_id = ?
Parameters:
[
  1
]
4 0.57 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.slug AS slug_3, t0.answer AS answer_4, t0.category_id AS category_id_5 FROM faq t0 WHERE t0.category_id = ?
Parameters:
[
  2
]
5 0.46 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.slug AS slug_3, t0.answer AS answer_4, t0.category_id AS category_id_5 FROM faq t0 WHERE t0.category_id = ?
Parameters:
[
  3
]
6 0.46 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.slug AS slug_3, t0.answer AS answer_4, t0.category_id AS category_id_5 FROM faq t0 WHERE t0.category_id = ?
Parameters:
[
  4
]
7 0.58 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.slug AS slug_3, t0.answer AS answer_4, t0.category_id AS category_id_5 FROM faq t0 WHERE t0.category_id = ?
Parameters:
[
  6
]
8 1.16 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:
[]
9 0.41 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:
[]
10 0.45 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
]
11 0.44 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
]
12 0.25 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
]
13 0.19 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\Help No errors.
App\Entity\FaqCategory No errors.
App\Entity\Faq 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\ArticleCategory 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\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\Article 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\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.