Symfony Profiler

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

Query Metrics

SELECT COUNT(s0_.id) AS sclr_0 FROM stock_change_histories s0_ LEFT JOIN product_variants p1_ ON s0_.product_variant_id = p1_.id LEFT JOIN products p2_ ON p1_.product_id = p2_.id ORDER BY s0_.created_at DESC, s0_.id DESC

[]

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  stock_change_histories s0_
  LEFT JOIN product_variants p1_ ON s0_.product_variant_id = p1_.id
  LEFT JOIN products p2_ ON p1_.product_id = p2_.id
ORDER BY
  s0_.created_at DESC,
  s0_.id DESC

SELECT COUNT(s0_.id) AS sclr_0 FROM stock_change_histories s0_ LEFT JOIN product_variants p1_ ON s0_.product_variant_id = p1_.id LEFT JOIN products p2_ ON p1_.product_id = p2_.id ORDER BY s0_.created_at DESC, s0_.id DESC;

SELECT s0_.id AS id_0, s0_.source AS source_1, s0_.change_amount AS change_amount_2, s0_.stock_before AS stock_before_3, s0_.stock_after AS stock_after_4, s0_.store_id AS store_id_5, s0_.stock_change_id AS stock_change_id_6, s0_.event AS event_7, s0_.action AS action_8, s0_.memo AS memo_9, s0_.created_at AS created_at_10, p1_.id AS id_11, p1_.variant_code AS variant_code_12, p1_.smaregi_product_id AS smaregi_product_id_13, p1_.name AS name_14, p1_.price AS price_15, p1_.stock AS stock_16, p1_.deleted_at AS deleted_at_17, p1_.created_at AS created_at_18, p1_.updated_at AS updated_at_19, p2_.id AS id_20, p2_.smaregi_product_id AS smaregi_product_id_21, p2_.product_code AS product_code_22, p2_.name AS name_23, p2_.stock AS stock_24, p2_.created_at AS created_at_25, p2_.updated_at AS updated_at_26, p2_.deleted_at AS deleted_at_27, s0_.product_variant_id AS product_variant_id_28, p1_.product_id AS product_id_29, p2_.category_id AS category_id_30 FROM stock_change_histories s0_ LEFT JOIN product_variants p1_ ON s0_.product_variant_id = p1_.id LEFT JOIN products p2_ ON p1_.product_id = p2_.id ORDER BY s0_.created_at DESC, s0_.id DESC LIMIT 50

[]

SELECT
  s0_.id AS id_0,
  s0_.source AS source_1,
  s0_.change_amount AS change_amount_2,
  s0_.stock_before AS stock_before_3,
  s0_.stock_after AS stock_after_4,
  s0_.store_id AS store_id_5,
  s0_.stock_change_id AS stock_change_id_6,
  s0_.event AS event_7,
  s0_.action AS action_8,
  s0_.memo AS memo_9,
  s0_.created_at AS created_at_10,
  p1_.id AS id_11,
  p1_.variant_code AS variant_code_12,
  p1_.smaregi_product_id AS smaregi_product_id_13,
  p1_.name AS name_14,
  p1_.price AS price_15,
  p1_.stock AS stock_16,
  p1_.deleted_at AS deleted_at_17,
  p1_.created_at AS created_at_18,
  p1_.updated_at AS updated_at_19,
  p2_.id AS id_20,
  p2_.smaregi_product_id AS smaregi_product_id_21,
  p2_.product_code AS product_code_22,
  p2_.name AS name_23,
  p2_.stock AS stock_24,
  p2_.created_at AS created_at_25,
  p2_.updated_at AS updated_at_26,
  p2_.deleted_at AS deleted_at_27,
  s0_.product_variant_id AS product_variant_id_28,
  p1_.product_id AS product_id_29,
  p2_.category_id AS category_id_30
FROM
  stock_change_histories s0_
  LEFT JOIN product_variants p1_ ON s0_.product_variant_id = p1_.id
  LEFT JOIN products p2_ ON p1_.product_id = p2_.id
ORDER BY
  s0_.created_at DESC,
  s0_.id DESC
LIMIT
  50

SELECT s0_.id AS id_0, s0_.source AS source_1, s0_.change_amount AS change_amount_2, s0_.stock_before AS stock_before_3, s0_.stock_after AS stock_after_4, s0_.store_id AS store_id_5, s0_.stock_change_id AS stock_change_id_6, s0_.event AS event_7, s0_.action AS action_8, s0_.memo AS memo_9, s0_.created_at AS created_at_10, p1_.id AS id_11, p1_.variant_code AS variant_code_12, p1_.smaregi_product_id AS smaregi_product_id_13, p1_.name AS name_14, p1_.price AS price_15, p1_.stock AS stock_16, p1_.deleted_at AS deleted_at_17, p1_.created_at AS created_at_18, p1_.updated_at AS updated_at_19, p2_.id AS id_20, p2_.smaregi_product_id AS smaregi_product_id_21, p2_.product_code AS product_code_22, p2_.name AS name_23, p2_.stock AS stock_24, p2_.created_at AS created_at_25, p2_.updated_at AS updated_at_26, p2_.deleted_at AS deleted_at_27, s0_.product_variant_id AS product_variant_id_28, p1_.product_id AS product_id_29, p2_.category_id AS category_id_30 FROM stock_change_histories s0_ LEFT JOIN product_variants p1_ ON s0_.product_variant_id = p1_.id LEFT JOIN products p2_ ON p1_.product_id = p2_.id ORDER BY s0_.created_at DESC, s0_.id DESC LIMIT 50;

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, p1_.id AS id_9, p1_.smaregi_product_id AS smaregi_product_id_10, p1_.product_code AS product_code_11, p1_.name AS name_12, p1_.stock AS stock_13, p1_.created_at AS created_at_14, p1_.updated_at AS updated_at_15, p1_.deleted_at AS deleted_at_16, p0_.product_id AS product_id_17, p1_.category_id AS category_id_18 FROM product_variants p0_ LEFT JOIN products p1_ ON p0_.product_id = p1_.id WHERE p0_.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,
  p1_.id AS id_9,
  p1_.smaregi_product_id AS smaregi_product_id_10,
  p1_.product_code AS product_code_11,
  p1_.name AS name_12,
  p1_.stock AS stock_13,
  p1_.created_at AS created_at_14,
  p1_.updated_at AS updated_at_15,
  p1_.deleted_at AS deleted_at_16,
  p0_.product_id AS product_id_17,
  p1_.category_id AS category_id_18
FROM
  product_variants p0_
  LEFT JOIN products p1_ ON p0_.product_id = p1_.id
WHERE
  p0_.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, p1_.id AS id_9, p1_.smaregi_product_id AS smaregi_product_id_10, p1_.product_code AS product_code_11, p1_.name AS name_12, p1_.stock AS stock_13, p1_.created_at AS created_at_14, p1_.updated_at AS updated_at_15, p1_.deleted_at AS deleted_at_16, p0_.product_id AS product_id_17, p1_.category_id AS category_id_18 FROM product_variants p0_ LEFT JOIN products p1_ ON p0_.product_id = p1_.id WHERE p0_.deleted_at IS NULL ORDER BY p1_.name ASC, p0_.variant_code ASC;