Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 33
• Events
• Routing
• Cache
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Serializer
• Configuration

Query Metrics

SELECT p0_.id AS id_0, p0_.variant_code AS variant_code_1, p0_.smaregi_product_id AS smaregi_product_id_2, p0_.name AS name_3, p0_.price AS price_4, p0_.stock AS stock_5, p0_.deleted_at AS deleted_at_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.product_id AS product_id_9 FROM product_variants p0_ INNER JOIN products p1_ ON p0_.product_id = p1_.id WHERE p0_.deleted_at IS NULL AND p0_.smaregi_product_id IS NOT NULL AND p1_.deleted_at IS NULL ORDER BY p1_.name ASC, p0_.variant_code ASC

[]

SELECT
  p0_.id AS id_0,
  p0_.variant_code AS variant_code_1,
  p0_.smaregi_product_id AS smaregi_product_id_2,
  p0_.name AS name_3,
  p0_.price AS price_4,
  p0_.stock AS stock_5,
  p0_.deleted_at AS deleted_at_6,
  p0_.created_at AS created_at_7,
  p0_.updated_at AS updated_at_8,
  p0_.product_id AS product_id_9
FROM
  product_variants p0_
  INNER JOIN products p1_ ON p0_.product_id = p1_.id
WHERE
  p0_.deleted_at IS NULL
  AND p0_.smaregi_product_id IS NOT NULL
  AND p1_.deleted_at IS NULL
ORDER BY
  p1_.name ASC,
  p0_.variant_code ASC

SELECT p0_.id AS id_0, p0_.variant_code AS variant_code_1, p0_.smaregi_product_id AS smaregi_product_id_2, p0_.name AS name_3, p0_.price AS price_4, p0_.stock AS stock_5, p0_.deleted_at AS deleted_at_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.product_id AS product_id_9 FROM product_variants p0_ INNER JOIN products p1_ ON p0_.product_id = p1_.id WHERE p0_.deleted_at IS NULL AND p0_.smaregi_product_id IS NOT NULL AND p1_.deleted_at IS NULL ORDER BY p1_.name ASC, p0_.variant_code ASC;

SELECT t0.id AS id_1, t0.smaregi_product_id AS smaregi_product_id_2, t0.product_code AS product_code_3, t0.name AS name_4, t0.stock AS stock_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.category_id AS category_id_9 FROM products t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.smaregi_product_id AS smaregi_product_id_2,
  t0.product_code AS product_code_3,
  t0.name AS name_4,
  t0.stock AS stock_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.category_id AS category_id_9
FROM
  products t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.smaregi_product_id AS smaregi_product_id_2, t0.product_code AS product_code_3, t0.name AS name_4, t0.stock AS stock_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.category_id AS category_id_9 FROM products t0 WHERE t0.id = 1;