Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation 1
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.catconfiguration_id AS catconfiguration_id_4 FROM configuration t0 WHERE t0.name = ? LIMIT 1

[
  "default currency"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.catconfiguration_id AS catconfiguration_id_4
FROM
  configuration t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.catconfiguration_id AS catconfiguration_id_4 FROM configuration t0 WHERE t0.name = 'default currency' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.longitude AS longitude_4, t0.largitude AS largitude_5, t0.address AS address_6, t0.zipcode AS zipcode_7, t0.city AS city_8, t0.state AS state_9, t0.country AS country_10, t0.is_default AS is_default_11, t0.phone AS phone_12, t0.email AS email_13, t0.work_schedule AS work_schedule_14, t0.created AS created_15, t0.updated AS updated_16, t0.user_add AS user_add_17, t0.user_update AS user_update_18 FROM locations t0

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.longitude AS longitude_4,
  t0.largitude AS largitude_5,
  t0.address AS address_6,
  t0.zipcode AS zipcode_7,
  t0.city AS city_8,
  t0.state AS state_9,
  t0.country AS country_10,
  t0.is_default AS is_default_11,
  t0.phone AS phone_12,
  t0.email AS email_13,
  t0.work_schedule AS work_schedule_14,
  t0.created AS created_15,
  t0.updated AS updated_16,
  t0.user_add AS user_add_17,
  t0.user_update AS user_update_18
FROM
  locations t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.longitude AS longitude_4, t0.largitude AS largitude_5, t0.address AS address_6, t0.zipcode AS zipcode_7, t0.city AS city_8, t0.state AS state_9, t0.country AS country_10, t0.is_default AS is_default_11, t0.phone AS phone_12, t0.email AS email_13, t0.work_schedule AS work_schedule_14, t0.created AS created_15, t0.updated AS updated_16, t0.user_add AS user_add_17, t0.user_update AS user_update_18 FROM locations t0;

SELECT t0.id AS id_1, t0.name AS name_2, t0.number_vehicles AS number_vehicles_3, t0.free_distance AS free_distance_4, t0.min_rental AS min_rental_5, t0.number_place AS number_place_6, t0.nbr_doors AS nbr_doors_7, t0.luggage AS luggage_8, t0.body AS body_9, t0.created AS created_10, t0.updated AS updated_11, t0.user_add AS user_add_12, t0.user_update AS user_update_13, t0.category_id AS category_id_14, t0.manufacter_id AS manufacter_id_15 FROM cars t0 WHERE t0.id = ?

[
  "12"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.number_vehicles AS number_vehicles_3,
  t0.free_distance AS free_distance_4,
  t0.min_rental AS min_rental_5,
  t0.number_place AS number_place_6,
  t0.nbr_doors AS nbr_doors_7,
  t0.luggage AS luggage_8,
  t0.body AS body_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.user_add AS user_add_12,
  t0.user_update AS user_update_13,
  t0.category_id AS category_id_14,
  t0.manufacter_id AS manufacter_id_15
FROM
  cars t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.number_vehicles AS number_vehicles_3, t0.free_distance AS free_distance_4, t0.min_rental AS min_rental_5, t0.number_place AS number_place_6, t0.nbr_doors AS nbr_doors_7, t0.luggage AS luggage_8, t0.body AS body_9, t0.created AS created_10, t0.updated AS updated_11, t0.user_add AS user_add_12, t0.user_update AS user_update_13, t0.category_id AS category_id_14, t0.manufacter_id AS manufacter_id_15 FROM cars t0 WHERE t0.id = '12';

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.prefix AS prefix_4, t0.suffix AS suffix_5, t0.enabled AS enabled_6, t0.created AS created_7, t0.updated AS updated_8, t0.user_add AS user_add_9, t0.user_update AS user_update_10 FROM currencies t0 WHERE t0.code = ? LIMIT 1

[
  "USD"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.prefix AS prefix_4,
  t0.suffix AS suffix_5,
  t0.enabled AS enabled_6,
  t0.created AS created_7,
  t0.updated AS updated_8,
  t0.user_add AS user_add_9,
  t0.user_update AS user_update_10
FROM
  currencies t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.prefix AS prefix_4, t0.suffix AS suffix_5, t0.enabled AS enabled_6, t0.created AS created_7, t0.updated AS updated_8, t0.user_add AS user_add_9, t0.user_update AS user_update_10 FROM currencies t0 WHERE t0.code = 'USD' LIMIT 1;

SELECT c0_.id AS id_0, r1_.id AS id_1, r1_.price AS price_2, p2_.type AS type_3, p3_.no_from AS no_from_4, p3_.no_to AS no_to_5, r4_.fromDate AS fromDate_6, r4_.toDate AS toDate_7, p2_.active_days AS active_days_8 FROM cars c0_ INNER JOIN rangepricing r4_ ON c0_.id = r4_.car_id INNER JOIN pricing p2_ ON r4_.pricing_id = p2_.id INNER JOIN pricingrange p3_ ON p2_.id = p3_.pricing_id INNER JOIN rangeprincingcurrency r1_ ON p3_.id = r1_.pricing_range_id WHERE c0_.id = ? AND r1_.currency_id = ?

[
  "12"
  2
]

SELECT
  c0_.id AS id_0,
  r1_.id AS id_1,
  r1_.price AS price_2,
  p2_.type AS type_3,
  p3_.no_from AS no_from_4,
  p3_.no_to AS no_to_5,
  r4_.fromDate AS fromDate_6,
  r4_.toDate AS toDate_7,
  p2_.active_days AS active_days_8
FROM
  cars c0_
  INNER JOIN rangepricing r4_ ON c0_.id = r4_.car_id
  INNER JOIN pricing p2_ ON r4_.pricing_id = p2_.id
  INNER JOIN pricingrange p3_ ON p2_.id = p3_.pricing_id
  INNER JOIN rangeprincingcurrency r1_ ON p3_.id = r1_.pricing_range_id
WHERE
  c0_.id = ?
  AND r1_.currency_id = ?

SELECT c0_.id AS id_0, r1_.id AS id_1, r1_.price AS price_2, p2_.type AS type_3, p3_.no_from AS no_from_4, p3_.no_to AS no_to_5, r4_.fromDate AS fromDate_6, r4_.toDate AS toDate_7, p2_.active_days AS active_days_8 FROM cars c0_ INNER JOIN rangepricing r4_ ON c0_.id = r4_.car_id INNER JOIN pricing p2_ ON r4_.pricing_id = p2_.id INNER JOIN pricingrange p3_ ON p2_.id = p3_.pricing_id INNER JOIN rangeprincingcurrency r1_ ON p3_.id = r1_.pricing_range_id WHERE c0_.id = '12' AND r1_.currency_id = 2;

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.comment AS comment_2, r0_.status AS status_3, r0_.created_at AS created_at_4, r0_.updated_at AS updated_at_5, r0_.car_id AS car_id_6, r0_.user_id AS user_id_7, r0_.booking_id AS booking_id_8 FROM review r0_ WHERE r0_.car_id = ? AND r0_.status = ? ORDER BY r0_.created_at DESC

[
  "12"
  "approved"
]

SELECT
  r0_.id AS id_0,
  r0_.rating AS rating_1,
  r0_.comment AS comment_2,
  r0_.status AS status_3,
  r0_.created_at AS created_at_4,
  r0_.updated_at AS updated_at_5,
  r0_.car_id AS car_id_6,
  r0_.user_id AS user_id_7,
  r0_.booking_id AS booking_id_8
FROM
  review r0_
WHERE
  r0_.car_id = ?
  AND r0_.status = ?
ORDER BY
  r0_.created_at DESC

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.comment AS comment_2, r0_.status AS status_3, r0_.created_at AS created_at_4, r0_.updated_at AS updated_at_5, r0_.car_id AS car_id_6, r0_.user_id AS user_id_7, r0_.booking_id AS booking_id_8 FROM review r0_ WHERE r0_.car_id = '12' AND r0_.status = 'approved' ORDER BY r0_.created_at DESC;

SELECT COUNT(r0_.id) AS sclr_0, AVG(r0_.rating) AS sclr_1 FROM review r0_ WHERE r0_.car_id = ? AND r0_.status = ?

[
  "12"
  "approved"
]

SELECT
  COUNT(r0_.id) AS sclr_0,
  AVG(r0_.rating) AS sclr_1
FROM
  review r0_
WHERE
  r0_.car_id = ?
  AND r0_.status = ?

SELECT COUNT(r0_.id) AS sclr_0, AVG(r0_.rating) AS sclr_1 FROM review r0_ WHERE r0_.car_id = '12' AND r0_.status = 'approved';