Query Metrics

44 Database Queries
20 Different statements
205.16 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.06 ms
SELECT t0.id AS id_1, t0.engine_capacity AS engine_capacity_2, t0.horsepower AS horsepower_3, t0.torque AS torque_4, t0.price_guide AS price_guide_5, t0.sunroof AS sunroof_6, t0.features AS features_7, t0.dimensions AS dimensions_8, t0.zero_to_hundred_time AS zero_to_hundred_time_9, t0.yom AS yom_10, t0.image AS image_11, t0.description AS description_12, t0.video_url AS video_url_13, t0.listing_position AS listing_position_14, t0.title AS title_15, t0.transparent_bg_image AS transparent_bg_image_16, t0.slug AS slug_17, t0.meta_description AS meta_description_18, t0.share_token AS share_token_19, t0.used AS used_20, t0.is_sold AS is_sold_21, t0.car_make_id AS car_make_id_22, t0.drive_type_id AS drive_type_id_23, t0.fuel_type_id AS fuel_type_id_24, t0.transmission_id AS transmission_id_25, t0.car_model_id AS car_model_id_26 FROM car t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "Peugeot-2008-GT-Line"
]
2 4.06 ms
SELECT t0.id AS id_1, t0.engine_capacity AS engine_capacity_2, t0.horsepower AS horsepower_3, t0.torque AS torque_4, t0.price_guide AS price_guide_5, t0.sunroof AS sunroof_6, t0.features AS features_7, t0.dimensions AS dimensions_8, t0.zero_to_hundred_time AS zero_to_hundred_time_9, t0.yom AS yom_10, t0.image AS image_11, t0.description AS description_12, t0.video_url AS video_url_13, t0.listing_position AS listing_position_14, t0.title AS title_15, t0.transparent_bg_image AS transparent_bg_image_16, t0.slug AS slug_17, t0.meta_description AS meta_description_18, t0.share_token AS share_token_19, t0.used AS used_20, t0.is_sold AS is_sold_21, t0.car_make_id AS car_make_id_22, t0.drive_type_id AS drive_type_id_23, t0.fuel_type_id AS fuel_type_id_24, t0.transmission_id AS transmission_id_25, t0.car_model_id AS car_model_id_26 FROM car t0 ORDER BY t0.id DESC LIMIT 4
Parameters:
[]
3 1.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.keywords AS keywords_6, t0.image AS image_7, t0.slug AS slug_8 FROM car_make t0 WHERE t0.id = ?
Parameters:
[
  3
]
4 0.89 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.car_make_id AS car_make_id_3 FROM car_model t0 WHERE t0.id = ?
Parameters:
[
  2
]
5 2.26 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM fuel_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 1.29 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content_text AS content_text_4, t0.screenshot AS screenshot_5 FROM content t0
Parameters:
[]
7 1.18 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.src AS src_4 FROM image t0
Parameters:
[]
8 1.14 ms
SELECT t0.id AS id_1, t0.heading AS heading_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.url AS url_5, t0.featured_image AS featured_image_6, t0.page_content AS page_content_7, t0.content_first AS content_first_8, t0.is_service AS is_service_9, t0.whatsapp_number AS whatsapp_number_10 FROM page t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "car-page"
]
9 0.69 ms
SELECT t0.id AS id_1, t0.heading AS heading_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.logo_path AS logo_path_5, t0.keywords AS keywords_6 FROM seo t0 ORDER BY t0.id ASC LIMIT 1
Parameters:
[]
10 0.97 ms
SELECT t0.id AS id_1, t0.heading AS heading_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.logo_path AS logo_path_5, t0.keywords AS keywords_6 FROM seo t0
Parameters:
[]
11 4.77 ms
SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.phone_number AS phone_number_3, t0.work_hours AS work_hours_4, t0.instagram_link AS instagram_link_5, t0.facebook_link AS facebook_link_6, t0.youtube_link AS youtube_link_7, t0.tiktok_link AS tiktok_link_8, t0.business_location AS business_location_9, t0.twitter_link AS twitter_link_10, t0.linkedin_link AS linkedin_link_11, t0.google_map_embed AS google_map_embed_12, t0.email_address AS email_address_13 FROM setting t0
Parameters:
[]
12 5.25 ms
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.content AS content_2, b0_.publication_date AS publication_date_3, b0_.is_published AS is_published_4, b0_.slug AS slug_5, b0_.featured_image AS featured_image_6, b0_.meta_title AS meta_title_7, b0_.meta_description AS meta_description_8, b0_.video_url AS video_url_9, b0_.whatsapp_number AS whatsapp_number_10, b0_.author_id AS author_id_11 FROM blog b0_ WHERE b0_.is_published = ? ORDER BY b0_.id DESC LIMIT 3
Parameters:
[
  1
]
13 3.80 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.keywords AS keywords_6, t0.image AS image_7, t0.slug AS slug_8 FROM car_make t0
Parameters:
[]
14 7.04 ms
SELECT p0_.id AS id_0, p0_.heading AS heading_1, p0_.meta_title AS meta_title_2, p0_.meta_description AS meta_description_3, p0_.url AS url_4, p0_.featured_image AS featured_image_5, p0_.page_content AS page_content_6, p0_.content_first AS content_first_7, p0_.is_service AS is_service_8, p0_.whatsapp_number AS whatsapp_number_9 FROM page p0_ WHERE p0_.is_service = ?
Parameters:
[
  1
]
15 4.98 ms
SELECT t0.id AS id_1, t0.heading AS heading_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.logo_path AS logo_path_5, t0.keywords AS keywords_6 FROM seo t0
Parameters:
[]
16 12.40 ms
SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.phone_number AS phone_number_3, t0.work_hours AS work_hours_4, t0.instagram_link AS instagram_link_5, t0.facebook_link AS facebook_link_6, t0.youtube_link AS youtube_link_7, t0.tiktok_link AS tiktok_link_8, t0.business_location AS business_location_9, t0.twitter_link AS twitter_link_10, t0.linkedin_link AS linkedin_link_11, t0.google_map_embed AS google_map_embed_12, t0.email_address AS email_address_13 FROM setting t0
Parameters:
[]
17 3.37 ms
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.content AS content_2, b0_.publication_date AS publication_date_3, b0_.is_published AS is_published_4, b0_.slug AS slug_5, b0_.featured_image AS featured_image_6, b0_.meta_title AS meta_title_7, b0_.meta_description AS meta_description_8, b0_.video_url AS video_url_9, b0_.whatsapp_number AS whatsapp_number_10, b0_.author_id AS author_id_11 FROM blog b0_ WHERE b0_.is_published = ? ORDER BY b0_.id DESC LIMIT 3
Parameters:
[
  1
]
18 14.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.keywords AS keywords_6, t0.image AS image_7, t0.slug AS slug_8 FROM car_make t0
Parameters:
[]
19 5.70 ms
SELECT p0_.id AS id_0, p0_.heading AS heading_1, p0_.meta_title AS meta_title_2, p0_.meta_description AS meta_description_3, p0_.url AS url_4, p0_.featured_image AS featured_image_5, p0_.page_content AS page_content_6, p0_.content_first AS content_first_7, p0_.is_service AS is_service_8, p0_.whatsapp_number AS whatsapp_number_9 FROM page p0_ WHERE p0_.is_service = ?
Parameters:
[
  1
]
20 0.46 ms
SELECT t0.id AS id_1, t0.heading AS heading_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.logo_path AS logo_path_5, t0.keywords AS keywords_6 FROM seo t0
Parameters:
[]
21 1.41 ms
SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.phone_number AS phone_number_3, t0.work_hours AS work_hours_4, t0.instagram_link AS instagram_link_5, t0.facebook_link AS facebook_link_6, t0.youtube_link AS youtube_link_7, t0.tiktok_link AS tiktok_link_8, t0.business_location AS business_location_9, t0.twitter_link AS twitter_link_10, t0.linkedin_link AS linkedin_link_11, t0.google_map_embed AS google_map_embed_12, t0.email_address AS email_address_13 FROM setting t0
Parameters:
[]
22 2.95 ms
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.content AS content_2, b0_.publication_date AS publication_date_3, b0_.is_published AS is_published_4, b0_.slug AS slug_5, b0_.featured_image AS featured_image_6, b0_.meta_title AS meta_title_7, b0_.meta_description AS meta_description_8, b0_.video_url AS video_url_9, b0_.whatsapp_number AS whatsapp_number_10, b0_.author_id AS author_id_11 FROM blog b0_ WHERE b0_.is_published = ? ORDER BY b0_.id DESC LIMIT 3
Parameters:
[
  1
]
23 1.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.keywords AS keywords_6, t0.image AS image_7, t0.slug AS slug_8 FROM car_make t0
Parameters:
[]
24 3.83 ms
SELECT p0_.id AS id_0, p0_.heading AS heading_1, p0_.meta_title AS meta_title_2, p0_.meta_description AS meta_description_3, p0_.url AS url_4, p0_.featured_image AS featured_image_5, p0_.page_content AS page_content_6, p0_.content_first AS content_first_7, p0_.is_service AS is_service_8, p0_.whatsapp_number AS whatsapp_number_9 FROM page p0_ WHERE p0_.is_service = ?
Parameters:
[
  1
]
25 4.00 ms
SELECT t0.id AS id_1, t0.heading AS heading_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.logo_path AS logo_path_5, t0.keywords AS keywords_6 FROM seo t0
Parameters:
[]
26 2.79 ms
SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.phone_number AS phone_number_3, t0.work_hours AS work_hours_4, t0.instagram_link AS instagram_link_5, t0.facebook_link AS facebook_link_6, t0.youtube_link AS youtube_link_7, t0.tiktok_link AS tiktok_link_8, t0.business_location AS business_location_9, t0.twitter_link AS twitter_link_10, t0.linkedin_link AS linkedin_link_11, t0.google_map_embed AS google_map_embed_12, t0.email_address AS email_address_13 FROM setting t0
Parameters:
[]
27 3.83 ms
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.content AS content_2, b0_.publication_date AS publication_date_3, b0_.is_published AS is_published_4, b0_.slug AS slug_5, b0_.featured_image AS featured_image_6, b0_.meta_title AS meta_title_7, b0_.meta_description AS meta_description_8, b0_.video_url AS video_url_9, b0_.whatsapp_number AS whatsapp_number_10, b0_.author_id AS author_id_11 FROM blog b0_ WHERE b0_.is_published = ? ORDER BY b0_.id DESC LIMIT 3
Parameters:
[
  1
]
28 1.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.keywords AS keywords_6, t0.image AS image_7, t0.slug AS slug_8 FROM car_make t0
Parameters:
[]
29 5.87 ms
SELECT p0_.id AS id_0, p0_.heading AS heading_1, p0_.meta_title AS meta_title_2, p0_.meta_description AS meta_description_3, p0_.url AS url_4, p0_.featured_image AS featured_image_5, p0_.page_content AS page_content_6, p0_.content_first AS content_first_7, p0_.is_service AS is_service_8, p0_.whatsapp_number AS whatsapp_number_9 FROM page p0_ WHERE p0_.is_service = ?
Parameters:
[
  1
]
30 4.19 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content_text AS content_text_4, t0.screenshot AS screenshot_5 FROM content t0 WHERE t0.description = ? LIMIT 1
Parameters:
[
  "header-cta"
]
31 3.72 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content_text AS content_text_4, t0.screenshot AS screenshot_5 FROM content t0 WHERE t0.description = ? LIMIT 1
Parameters:
[
  "side-bar-heading"
]
32 4.74 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content_text AS content_text_4, t0.screenshot AS screenshot_5 FROM content t0 WHERE t0.description = ? LIMIT 1
Parameters:
[
  "side-bar-content"
]
33 3.36 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content_text AS content_text_4, t0.screenshot AS screenshot_5 FROM content t0 WHERE t0.description = ? LIMIT 1
Parameters:
[
  "sidebar-cta"
]
34 2.31 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.template_path AS template_path_3, t0.priority AS priority_4 FROM section t0 INNER JOIN page_section ON t0.id = page_section.section_id WHERE page_section.page_id = ?
Parameters:
[
  5
]
35 3.53 ms
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.image_description AS image_description_3, t0.img_position AS img_position_4, t0.uploaded_at AS uploaded_at_5, t0.car_id AS car_id_6 FROM car_images t0 WHERE t0.car_id = ?
Parameters:
[
  49
]
36 3.70 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content_text AS content_text_4, t0.screenshot AS screenshot_5 FROM content t0 WHERE t0.description = ? LIMIT 1
Parameters:
[
  "car-info-state"
]
37 2.78 ms
SELECT t0.id AS id_1, t0.reservation_number AS reservation_number_2, t0.customer_name AS customer_name_3, t0.customer_email AS customer_email_4, t0.customer_phone AS customer_phone_5, t0.status AS status_6, t0.reservation_amount AS reservation_amount_7, t0.mpesa_transaction_code AS mpesa_transaction_code_8, t0.terms_accepted AS terms_accepted_9, t0.created_at AS created_at_10, t0.expires_at AS expires_at_11, t0.payment_completed_at AS payment_completed_at_12, t0.approved_at AS approved_at_13, t0.admin_notes AS admin_notes_14, t0.rejection_reason AS rejection_reason_15, t0.car_id AS car_id_16 FROM car_reservation t0 WHERE t0.car_id = ?
Parameters:
[
  49
]
38 7.55 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM transmission t0 WHERE t0.id = ?
Parameters:
[
  2
]
39 5.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM drive_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
40 12.39 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content_text AS content_text_4, t0.screenshot AS screenshot_5 FROM content t0 WHERE t0.description = ? LIMIT 1
Parameters:
[
  "customer-care-person"
]
41 13.40 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content_text AS content_text_4, t0.screenshot AS screenshot_5 FROM content t0 WHERE t0.description = ? LIMIT 1
Parameters:
[
  "customer-care-title"
]
42 9.39 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content_text AS content_text_4, t0.screenshot AS screenshot_5 FROM content t0 WHERE t0.description = ? LIMIT 1
Parameters:
[
  "call-now"
]
43 7.51 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content_text AS content_text_4, t0.screenshot AS screenshot_5 FROM content t0 WHERE t0.description = ? LIMIT 1
Parameters:
[
  "whatsapp-now"
]
44 16.43 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content_text AS content_text_4, t0.screenshot AS screenshot_5 FROM content t0 WHERE t0.description = ? LIMIT 1
Parameters:
[
  "car-detail-contact-form-title"
]

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\Car
  • The field App\Entity\Car#reservations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CarReservation#car does not contain the required 'inversedBy="reservations"' attribute.
App\Entity\CarMake No errors.
App\Entity\DriveType No errors.
App\Entity\FuelType No errors.
App\Entity\Transmission No errors.
App\Entity\CarModel No errors.
App\Entity\CarImages No errors.
App\Entity\CarCategory No errors.
App\Entity\CarReservation No errors.
App\Entity\Content No errors.
App\Entity\Image No errors.
App\Entity\Page No errors.
App\Entity\Section No errors.
App\Entity\SEO No errors.
App\Entity\Setting No errors.
App\Entity\Blog No errors.
App\Entity\User No errors.
App\Entity\BlogCategory No errors.