Symfony Profiler

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

Query Metrics

SELECT DISTINCT p0_.id AS id_0, p0_.sku AS sku_1, p0_.name AS name_2, p0_.description AS description_3, p0_.stock AS stock_4, p0_.minimum_stock AS minimum_stock_5, p0_.price AS price_6, p0_.discount_type AS discount_type_7, p0_.discount_value AS discount_value_8, p0_.active AS active_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.category_id AS category_id_12, p0_.business_id AS business_id_13 FROM product p0_ LEFT JOIN product_option_value p2_ ON p0_.id = p2_.product_id LEFT JOIN option_value o1_ ON o1_.id = p2_.option_value_id LEFT JOIN product_option_value p4_ ON p0_.id = p4_.product_id LEFT JOIN option_value o3_ ON o3_.id = p4_.option_value_id LEFT JOIN product_option_value p6_ ON p0_.id = p6_.product_id LEFT JOIN option_value o5_ ON o5_.id = p6_.option_value_id LEFT JOIN product_option_value p8_ ON p0_.id = p8_.product_id LEFT JOIN option_value o7_ ON o7_.id = p8_.option_value_id WHERE p0_.active = 1 AND p0_.business_id = ? AND p0_.stock > 0 AND o1_.slug IN (?, ?) AND o3_.slug IN (?) AND o5_.slug IN (?) AND o7_.slug IN (?) ORDER BY p0_.id ASC LIMIT 20

[
  1
  "amarillo"
  "rosa"
  "mediano"
  "amor-y-romance"
  "tulipanes"
]

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.sku AS sku_1,
  p0_.name AS name_2,
  p0_.description AS description_3,
  p0_.stock AS stock_4,
  p0_.minimum_stock AS minimum_stock_5,
  p0_.price AS price_6,
  p0_.discount_type AS discount_type_7,
  p0_.discount_value AS discount_value_8,
  p0_.active AS active_9,
  p0_.created_at AS created_at_10,
  p0_.updated_at AS updated_at_11,
  p0_.category_id AS category_id_12,
  p0_.business_id AS business_id_13
FROM
  product p0_
  LEFT JOIN product_option_value p2_ ON p0_.id = p2_.product_id
  LEFT JOIN option_value o1_ ON o1_.id = p2_.option_value_id
  LEFT JOIN product_option_value p4_ ON p0_.id = p4_.product_id
  LEFT JOIN option_value o3_ ON o3_.id = p4_.option_value_id
  LEFT JOIN product_option_value p6_ ON p0_.id = p6_.product_id
  LEFT JOIN option_value o5_ ON o5_.id = p6_.option_value_id
  LEFT JOIN product_option_value p8_ ON p0_.id = p8_.product_id
  LEFT JOIN option_value o7_ ON o7_.id = p8_.option_value_id
WHERE
  p0_.active = 1
  AND p0_.business_id = ?
  AND p0_.stock > 0
  AND o1_.slug IN (?, ?)
  AND o3_.slug IN (?)
  AND o5_.slug IN (?)
  AND o7_.slug IN (?)
ORDER BY
  p0_.id ASC
LIMIT
  20

SELECT DISTINCT p0_.id AS id_0, p0_.sku AS sku_1, p0_.name AS name_2, p0_.description AS description_3, p0_.stock AS stock_4, p0_.minimum_stock AS minimum_stock_5, p0_.price AS price_6, p0_.discount_type AS discount_type_7, p0_.discount_value AS discount_value_8, p0_.active AS active_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.category_id AS category_id_12, p0_.business_id AS business_id_13 FROM product p0_ LEFT JOIN product_option_value p2_ ON p0_.id = p2_.product_id LEFT JOIN option_value o1_ ON o1_.id = p2_.option_value_id LEFT JOIN product_option_value p4_ ON p0_.id = p4_.product_id LEFT JOIN option_value o3_ ON o3_.id = p4_.option_value_id LEFT JOIN product_option_value p6_ ON p0_.id = p6_.product_id LEFT JOIN option_value o5_ ON o5_.id = p6_.option_value_id LEFT JOIN product_option_value p8_ ON p0_.id = p8_.product_id LEFT JOIN option_value o7_ ON o7_.id = p8_.option_value_id WHERE p0_.active = 1 AND p0_.business_id = 1 AND p0_.stock > 0 AND o1_.slug IN ('amarillo', 'rosa') AND o3_.slug IN ('mediano') AND o5_.slug IN ('amor-y-romance') AND o7_.slug IN ('tulipanes') ORDER BY p0_.id ASC LIMIT 20;

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN product_option_value p2_ ON p0_.id = p2_.product_id LEFT JOIN option_value o1_ ON o1_.id = p2_.option_value_id LEFT JOIN product_option_value p4_ ON p0_.id = p4_.product_id LEFT JOIN option_value o3_ ON o3_.id = p4_.option_value_id LEFT JOIN product_option_value p6_ ON p0_.id = p6_.product_id LEFT JOIN option_value o5_ ON o5_.id = p6_.option_value_id LEFT JOIN product_option_value p8_ ON p0_.id = p8_.product_id LEFT JOIN option_value o7_ ON o7_.id = p8_.option_value_id WHERE p0_.active = 1 AND p0_.business_id = ? AND p0_.stock > 0 AND o1_.slug IN (?, ?) AND o3_.slug IN (?) AND o5_.slug IN (?) AND o7_.slug IN (?)

[
  1
  "amarillo"
  "rosa"
  "mediano"
  "amor-y-romance"
  "tulipanes"
]

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  LEFT JOIN product_option_value p2_ ON p0_.id = p2_.product_id
  LEFT JOIN option_value o1_ ON o1_.id = p2_.option_value_id
  LEFT JOIN product_option_value p4_ ON p0_.id = p4_.product_id
  LEFT JOIN option_value o3_ ON o3_.id = p4_.option_value_id
  LEFT JOIN product_option_value p6_ ON p0_.id = p6_.product_id
  LEFT JOIN option_value o5_ ON o5_.id = p6_.option_value_id
  LEFT JOIN product_option_value p8_ ON p0_.id = p8_.product_id
  LEFT JOIN option_value o7_ ON o7_.id = p8_.option_value_id
WHERE
  p0_.active = 1
  AND p0_.business_id = ?
  AND p0_.stock > 0
  AND o1_.slug IN (?, ?)
  AND o3_.slug IN (?)
  AND o5_.slug IN (?)
  AND o7_.slug IN (?)

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN product_option_value p2_ ON p0_.id = p2_.product_id LEFT JOIN option_value o1_ ON o1_.id = p2_.option_value_id LEFT JOIN product_option_value p4_ ON p0_.id = p4_.product_id LEFT JOIN option_value o3_ ON o3_.id = p4_.option_value_id LEFT JOIN product_option_value p6_ ON p0_.id = p6_.product_id LEFT JOIN option_value o5_ ON o5_.id = p6_.option_value_id LEFT JOIN product_option_value p8_ ON p0_.id = p8_.product_id LEFT JOIN option_value o7_ ON o7_.id = p8_.option_value_id WHERE p0_.active = 1 AND p0_.business_id = 1 AND p0_.stock > 0 AND o1_.slug IN ('amarillo', 'rosa') AND o3_.slug IN ('mediano') AND o5_.slug IN ('amor-y-romance') AND o7_.slug IN ('tulipanes');