Symfony Profiler

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

Query Metrics

SELECT id, name, description, image, on_sale, available_for_purchase_online, price_current_incl_vat FROM shop.products WHERE slug = ? LIMIT 1

[
  "cistiaren-odpadovych-vod-aquamax-2-5-pe"
]

SELECT
  id,
  name,
  description,
  image,
  on_sale,
  available_for_purchase_online,
  price_current_incl_vat
FROM
  shop.products
WHERE
  slug = ?
LIMIT
  1

SELECT id, name, description, image, on_sale, available_for_purchase_online, price_current_incl_vat FROM shop.products WHERE slug = 'cistiaren-odpadovych-vod-aquamax-2-5-pe' LIMIT 1;

SELECT t0.count AS count_1, t0.id AS id_2, t0.total_price_amount AS total_price_amount_3, t0.total_price_currency AS total_price_currency_4 FROM domain.carts t0 WHERE t0.id = ?

[
  "cc3b4603-cf03-485c-90d9-5b277cf03cd3"
]

SELECT
  t0.count AS count_1,
  t0.id AS id_2,
  t0.total_price_amount AS total_price_amount_3,
  t0.total_price_currency AS total_price_currency_4
FROM
  domain.carts t0
WHERE
  t0.id = ?

SELECT t0.count AS count_1, t0.id AS id_2, t0.total_price_amount AS total_price_amount_3, t0.total_price_currency AS total_price_currency_4 FROM domain.carts t0 WHERE t0.id = 'cc3b4603-cf03-485c-90d9-5b277cf03cd3';

SELECT t0.count AS count_1, t0.id AS id_2, t0.total_price_amount AS total_price_amount_3, t0.total_price_currency AS total_price_currency_4 FROM domain.carts t0 WHERE t0.id = ?

[
  "cc3b4603-cf03-485c-90d9-5b277cf03cd3"
]

SELECT
  t0.count AS count_1,
  t0.id AS id_2,
  t0.total_price_amount AS total_price_amount_3,
  t0.total_price_currency AS total_price_currency_4
FROM
  domain.carts t0
WHERE
  t0.id = ?

SELECT t0.count AS count_1, t0.id AS id_2, t0.total_price_amount AS total_price_amount_3, t0.total_price_currency AS total_price_currency_4 FROM domain.carts t0 WHERE t0.id = 'cc3b4603-cf03-485c-90d9-5b277cf03cd3';

SELECT * FROM public.cart_items WHERE cart_id = ? ORDER BY product_id ASC LIMIT 999

[
  Termyn\Uuid\Symfony\SymfonyUuid {#439
    __toString(): "cc3b4603-cf03-485c-90d9-5b277cf03cd3"
  }
]

SELECT
  *
FROM
  public.cart_items
WHERE
  cart_id = ?
ORDER BY
  product_id ASC
LIMIT
  999

SELECT * FROM public.cart_items WHERE cart_id = 'cc3b4603-cf03-485c-90d9-5b277cf03cd3' ORDER BY product_id ASC LIMIT 999;

SELECT slug, name FROM shop.available_catalogs

[]

SELECT
  slug,
  name
FROM
  shop.available_catalogs

SELECT slug, name FROM shop.available_catalogs;

SELECT t0.count AS count_1, t0.id AS id_2, t0.total_price_amount AS total_price_amount_3, t0.total_price_currency AS total_price_currency_4 FROM domain.carts t0 WHERE t0.id = ?

[
  "cc3b4603-cf03-485c-90d9-5b277cf03cd3"
]

SELECT
  t0.count AS count_1,
  t0.id AS id_2,
  t0.total_price_amount AS total_price_amount_3,
  t0.total_price_currency AS total_price_currency_4
FROM
  domain.carts t0
WHERE
  t0.id = ?

SELECT t0.count AS count_1, t0.id AS id_2, t0.total_price_amount AS total_price_amount_3, t0.total_price_currency AS total_price_currency_4 FROM domain.carts t0 WHERE t0.id = 'cc3b4603-cf03-485c-90d9-5b277cf03cd3';

SELECT t0.count AS count_1, t0.id AS id_2, t0.total_price_amount AS total_price_amount_3, t0.total_price_currency AS total_price_currency_4 FROM domain.carts t0 WHERE t0.id = ?

[
  "cc3b4603-cf03-485c-90d9-5b277cf03cd3"
]

SELECT
  t0.count AS count_1,
  t0.id AS id_2,
  t0.total_price_amount AS total_price_amount_3,
  t0.total_price_currency AS total_price_currency_4
FROM
  domain.carts t0
WHERE
  t0.id = ?

SELECT t0.count AS count_1, t0.id AS id_2, t0.total_price_amount AS total_price_amount_3, t0.total_price_currency AS total_price_currency_4 FROM domain.carts t0 WHERE t0.id = 'cc3b4603-cf03-485c-90d9-5b277cf03cd3';

SELECT * FROM public.cart_items WHERE cart_id = ? ORDER BY product_id ASC LIMIT 999

[
  Termyn\Uuid\Symfony\SymfonyUuid {#439
    __toString(): "cc3b4603-cf03-485c-90d9-5b277cf03cd3"
  }
]

SELECT
  *
FROM
  public.cart_items
WHERE
  cart_id = ?
ORDER BY
  product_id ASC
LIMIT
  999

SELECT * FROM public.cart_items WHERE cart_id = 'cc3b4603-cf03-485c-90d9-5b277cf03cd3' ORDER BY product_id ASC LIMIT 999;

SELECT name, category_id FROM shop.products WHERE id = ?

[
  Termyn\Uuid\Symfony\SymfonyUuid {#982
    __toString(): "da1e2b8a-b5c8-4c77-994d-051e6bcdc781"
  }
]

SELECT
  name,
  category_id
FROM
  shop.products
WHERE
  id = ?

SELECT name, category_id FROM shop.products WHERE id = 'da1e2b8a-b5c8-4c77-994d-051e6bcdc781';

SELECT abbreviation, slug, parent_id FROM shop.catalog_categories WHERE id = ?

[
  Termyn\Uuid\Symfony\SymfonyUuid {#1145
    __toString(): "111d4028-dd3a-4ad4-8bb2-fc297851eba8"
  }
]

SELECT
  abbreviation,
  slug,
  parent_id
FROM
  shop.catalog_categories
WHERE
  id = ?

SELECT abbreviation, slug, parent_id FROM shop.catalog_categories WHERE id = '111d4028-dd3a-4ad4-8bb2-fc297851eba8';

SELECT abbreviation, slug, parent_id FROM shop.catalog_categories WHERE parent_id = ? and id <> ? ORDER BY position ASC LIMIT 20

[
  Termyn\Uuid\Symfony\SymfonyUuid {#1149
    __toString(): "beb2cc87-36e9-4016-b1eb-c9b512481562"
  }
  Termyn\Uuid\Symfony\SymfonyUuid {#1145
    __toString(): "111d4028-dd3a-4ad4-8bb2-fc297851eba8"
  }
]

SELECT
  abbreviation,
  slug,
  parent_id
FROM
  shop.catalog_categories
WHERE
  parent_id = ?
  and id <> ?
ORDER BY
  position ASC
LIMIT
  20

SELECT abbreviation, slug, parent_id FROM shop.catalog_categories WHERE parent_id = 'beb2cc87-36e9-4016-b1eb-c9b512481562' and id <> '111d4028-dd3a-4ad4-8bb2-fc297851eba8' ORDER BY position ASC LIMIT 20;

SELECT abbreviation, slug, parent_id FROM shop.catalog_categories WHERE id = ?

[
  Termyn\Uuid\Symfony\SymfonyUuid {#1149
    __toString(): "beb2cc87-36e9-4016-b1eb-c9b512481562"
  }
]

SELECT
  abbreviation,
  slug,
  parent_id
FROM
  shop.catalog_categories
WHERE
  id = ?

SELECT abbreviation, slug, parent_id FROM shop.catalog_categories WHERE id = 'beb2cc87-36e9-4016-b1eb-c9b512481562';

SELECT abbreviation, slug, parent_id FROM shop.catalog_categories WHERE parent_id = ? and id <> ? ORDER BY position ASC LIMIT 20

[
  Termyn\Uuid\Symfony\SymfonyUuid {#1161
    __toString(): "0bfc16f3-0547-409d-bfc7-d2c5f2ef6d35"
  }
  Termyn\Uuid\Symfony\SymfonyUuid {#1149
    __toString(): "beb2cc87-36e9-4016-b1eb-c9b512481562"
  }
]

SELECT
  abbreviation,
  slug,
  parent_id
FROM
  shop.catalog_categories
WHERE
  parent_id = ?
  and id <> ?
ORDER BY
  position ASC
LIMIT
  20

SELECT abbreviation, slug, parent_id FROM shop.catalog_categories WHERE parent_id = '0bfc16f3-0547-409d-bfc7-d2c5f2ef6d35' and id <> 'beb2cc87-36e9-4016-b1eb-c9b512481562' ORDER BY position ASC LIMIT 20;

SELECT abbreviation, slug, parent_id FROM shop.catalog_categories WHERE id = ?

[
  Termyn\Uuid\Symfony\SymfonyUuid {#1161
    __toString(): "0bfc16f3-0547-409d-bfc7-d2c5f2ef6d35"
  }
]

SELECT
  abbreviation,
  slug,
  parent_id
FROM
  shop.catalog_categories
WHERE
  id = ?

SELECT abbreviation, slug, parent_id FROM shop.catalog_categories WHERE id = '0bfc16f3-0547-409d-bfc7-d2c5f2ef6d35';

SELECT name, slug FROM shop.catalogs WHERE id = ?

[
  Termyn\Uuid\Symfony\SymfonyUuid {#1161
    __toString(): "0bfc16f3-0547-409d-bfc7-d2c5f2ef6d35"
  }
]

SELECT
  name,
  slug
FROM
  shop.catalogs
WHERE
  id = ?

SELECT name, slug FROM shop.catalogs WHERE id = '0bfc16f3-0547-409d-bfc7-d2c5f2ef6d35';

SELECT name, slug FROM shop.catalogs WHERE id <> ? ORDER BY position ASC LIMIT 20

[
  Termyn\Uuid\Symfony\SymfonyUuid {#1161
    __toString(): "0bfc16f3-0547-409d-bfc7-d2c5f2ef6d35"
  }
]

SELECT
  name,
  slug
FROM
  shop.catalogs
WHERE
  id <> ?
ORDER BY
  position ASC
LIMIT
  20

SELECT name, slug FROM shop.catalogs WHERE id <> '0bfc16f3-0547-409d-bfc7-d2c5f2ef6d35' ORDER BY position ASC LIMIT 20;

SELECT name, slug, image, price_original_incl_vat, price_current_incl_vat, price_currency, stock_status, at_discount, available_for_purchase_online FROM shop.related_products WHERE related_id = (?) ORDER BY price_current_incl_vat

[
  Termyn\Uuid\Symfony\SymfonyUuid {#982
    __toString(): "da1e2b8a-b5c8-4c77-994d-051e6bcdc781"
  }
]

SELECT
  name,
  slug,
  image,
  price_original_incl_vat,
  price_current_incl_vat,
  price_currency,
  stock_status,
  at_discount,
  available_for_purchase_online
FROM
  shop.related_products
WHERE
  related_id = (?)
ORDER BY
  price_current_incl_vat

SELECT name, slug, image, price_original_incl_vat, price_current_incl_vat, price_currency, stock_status, at_discount, available_for_purchase_online FROM shop.related_products WHERE related_id = ('da1e2b8a-b5c8-4c77-994d-051e6bcdc781') ORDER BY price_current_incl_vat;

SELECT extended_description FROM shop.product_specifications WHERE id = ?

[
  Termyn\Uuid\Symfony\SymfonyUuid {#982
    __toString(): "da1e2b8a-b5c8-4c77-994d-051e6bcdc781"
  }
]

SELECT
  extended_description
FROM
  shop.product_specifications
WHERE
  id = ?

SELECT extended_description FROM shop.product_specifications WHERE id = 'da1e2b8a-b5c8-4c77-994d-051e6bcdc781';

SELECT suitable_for FROM shop.product_specifications WHERE id = ?

[
  Termyn\Uuid\Symfony\SymfonyUuid {#982
    __toString(): "da1e2b8a-b5c8-4c77-994d-051e6bcdc781"
  }
]

SELECT
  suitable_for
FROM
  shop.product_specifications
WHERE
  id = ?

SELECT suitable_for FROM shop.product_specifications WHERE id = 'da1e2b8a-b5c8-4c77-994d-051e6bcdc781';

SELECT key_features FROM shop.product_specifications WHERE id = ?

[
  Termyn\Uuid\Symfony\SymfonyUuid {#982
    __toString(): "da1e2b8a-b5c8-4c77-994d-051e6bcdc781"
  }
]

SELECT
  key_features
FROM
  shop.product_specifications
WHERE
  id = ?

SELECT key_features FROM shop.product_specifications WHERE id = 'da1e2b8a-b5c8-4c77-994d-051e6bcdc781';

SELECT name, value FROM shop.product_attributes WHERE id = ?

[
  Termyn\Uuid\Symfony\SymfonyUuid {#982
    __toString(): "da1e2b8a-b5c8-4c77-994d-051e6bcdc781"
  }
]

SELECT
  name,
  value
FROM
  shop.product_attributes
WHERE
  id = ?

SELECT name, value FROM shop.product_attributes WHERE id = 'da1e2b8a-b5c8-4c77-994d-051e6bcdc781';