Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 53
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Mercure
• VichUploader
• Configuration

Query Metrics

SELECT ht.id, ht.name, ht.slug,
                    (SELECT COUNT(h.id) FROM hosting h
                     INNER JOIN rental r ON h.rental_id = r.id
                     WHERE h.hosting_type_id = ht.id
                       AND h.deleted_at IS NULL
                       AND r.is_renting_active = 1
                       AND r.system_is_renting_allowed = 1) AS count
                FROM hosting_type ht
                ORDER BY ht.name ASC

[]

SELECT
  ht.id,
  ht.name,
  ht.slug,
  (
    SELECT
      COUNT(h.id)
    FROM
      hosting h
      INNER JOIN rental r ON h.rental_id = r.id
    WHERE
      h.hosting_type_id = ht.id
      AND h.deleted_at IS NULL
      AND r.is_renting_active = 1
      AND r.system_is_renting_allowed = 1
  ) AS count
FROM
  hosting_type ht
ORDER BY
  ht.name ASC

SELECT ht.id, ht.name, ht.slug,
                    (SELECT COUNT(h.id) FROM hosting h
                     INNER JOIN rental r ON h.rental_id = r.id
                     WHERE h.hosting_type_id = ht.id
                       AND h.deleted_at IS NULL
                       AND r.is_renting_active = 1
                       AND r.system_is_renting_allowed = 1) AS count
                FROM hosting_type ht
                ORDER BY ht.name ASC;

SELECT ho.id, ho.name
                FROM hosting_options ho
                WHERE ho.cat = ? AND ho.research = '1'
                ORDER BY ho.priority ASC, ho.name ASC

[
  "special"
]

SELECT
  ho.id,
  ho.name
FROM
  hosting_options ho
WHERE
  ho.cat = ?
  AND ho.research = '1'
ORDER BY
  ho.priority ASC,
  ho.name ASC

SELECT ho.id, ho.name
                FROM hosting_options ho
                WHERE ho.cat = 'special' AND ho.research = '1'
                ORDER BY ho.priority ASC, ho.name ASC;

SELECT id, name, distance, ordre FROM hosting_distance ORDER BY ordre ASC

[]

SELECT
  id,
  name,
  distance,
  ordre
FROM
  hosting_distance
ORDER BY
  ordre ASC

SELECT id, name, distance, ordre FROM hosting_distance ORDER BY ordre ASC;

SELECT ho.id, ho.name
                    FROM hosting_options ho
                    WHERE ho.research = '1'
                    ORDER BY ho.priority ASC, ho.name ASC

[]

SELECT
  ho.id,
  ho.name
FROM
  hosting_options ho
WHERE
  ho.research = '1'
ORDER BY
  ho.priority ASC,
  ho.name ASC

SELECT ho.id, ho.name
                    FROM hosting_options ho
                    WHERE ho.research = '1'
                    ORDER BY ho.priority ASC, ho.name ASC;

SELECT id, classification, level FROM hosting_class ORDER BY level DESC

[]

SELECT
  id,
  classification,
  level
FROM
  hosting_class
ORDER BY
  level DESC

SELECT id, classification, level FROM hosting_class ORDER BY level DESC;