Symfony Profiler

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

Query Metrics

SELECT
		td.id,
		c.id inspectionId,
		c.comments,
		td.hasBooleanResponse, 
		IFNULL(c.booleanResponse, 0) booleanResponse,
		td.desiredResponse,
		td.multipleChoiceResponses,
		'form' inspectionType,
		t.name name,
		td.description description,
		c.passed,
		IFNULL(td.sort_order, 1) sort_order
	FROM templatedetail td
	JOIN template t ON t.id = td.template_id
	JOIN inspection mi ON mi.templateId = t.id            
	LEFT JOIN category cat ON cat.id = td.categoryId    
	LEFT JOIN inspection c ON c.masterInspectionId = mi.id and c.templateDetailId = td.id
	WHERE td.deleted = 0
	AND t.deleted = 0
	AND mi.id = :id
	ORDER BY IFNULL(td.sort_order, 0) ASC

[
  "id" => 62441
]

SELECT
  td.id,
  c.id inspectionId,
  c.comments,
  td.hasBooleanResponse,
  IFNULL(c.booleanResponse, 0) booleanResponse,
  td.desiredResponse,
  td.multipleChoiceResponses,
  'form' inspectionType,
  t.name name,
  td.description description,
  c.passed,
  IFNULL(td.sort_order, 1) sort_order
FROM
  templatedetail td
  JOIN template t ON t.id = td.template_id
  JOIN inspection mi ON mi.templateId = t.id
  LEFT JOIN category cat ON cat.id = td.categoryId
  LEFT JOIN inspection c ON c.masterInspectionId = mi.id
  and c.templateDetailId = td.id
WHERE
  td.deleted = 0
  AND t.deleted = 0
  AND mi.id = :id
ORDER BY
  IFNULL(td.sort_order, 0) ASC

SELECT
		td.id,
		c.id inspectionId,
		c.comments,
		td.hasBooleanResponse, 
		IFNULL(c.booleanResponse, 0) booleanResponse,
		td.desiredResponse,
		td.multipleChoiceResponses,
		'form' inspectionType,
		t.name name,
		td.description description,
		c.passed,
		IFNULL(td.sort_order, 1) sort_order
	FROM templatedetail td
	JOIN template t ON t.id = td.template_id
	JOIN inspection mi ON mi.templateId = t.id            
	LEFT JOIN category cat ON cat.id = td.categoryId    
	LEFT JOIN inspection c ON c.masterInspectionId = mi.id and c.templateDetailId = td.id
	WHERE td.deleted = 0
	AND t.deleted = 0
	AND mi.id = 62441
	ORDER BY IFNULL(td.sort_order, 0) ASC
;