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, slug, name, description FROM shop.available_catalogs WHERE slug = ? LIMIT 1

[
  "voda"
]

SELECT
  id,
  slug,
  name,
  description
FROM
  shop.available_catalogs
WHERE
  slug = ?
LIMIT
  1

SELECT id, slug, name, description FROM shop.available_catalogs WHERE slug = 'voda' LIMIT 1;

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 = ?

[
  "66112386-c56a-4f21-9224-30bd2f65001a"
]

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 = '66112386-c56a-4f21-9224-30bd2f65001a';

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 = ?

[
  "66112386-c56a-4f21-9224-30bd2f65001a"
]

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 = '66112386-c56a-4f21-9224-30bd2f65001a';

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

[
  Termyn\Uuid\Symfony\SymfonyUuid {#439
    __toString(): "66112386-c56a-4f21-9224-30bd2f65001a"
  }
]

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

SELECT * FROM public.cart_items WHERE cart_id = '66112386-c56a-4f21-9224-30bd2f65001a' ORDER BY product_id ASC LIMIT 999;

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

[
  Termyn\Uuid\Symfony\SymfonyUuid {#976
    __toString(): "3aedb44d-c917-4b99-a8cb-abbdee1c82a4"
  }
]

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

SELECT name, category_id FROM shop.products WHERE id = '3aedb44d-c917-4b99-a8cb-abbdee1c82a4';

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

[
  Termyn\Uuid\Symfony\SymfonyUuid {#976
    __toString(): "3aedb44d-c917-4b99-a8cb-abbdee1c82a4"
  }
]

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

SELECT abbreviation, slug, parent_id FROM shop.catalog_categories WHERE id = '3aedb44d-c917-4b99-a8cb-abbdee1c82a4';

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

[
  Termyn\Uuid\Symfony\SymfonyUuid {#976
    __toString(): "3aedb44d-c917-4b99-a8cb-abbdee1c82a4"
  }
]

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

SELECT name, slug FROM shop.catalogs WHERE id = '3aedb44d-c917-4b99-a8cb-abbdee1c82a4';

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

[
  Termyn\Uuid\Symfony\SymfonyUuid {#976
    __toString(): "3aedb44d-c917-4b99-a8cb-abbdee1c82a4"
  }
]

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

SELECT name, slug FROM shop.catalogs WHERE id <> '3aedb44d-c917-4b99-a8cb-abbdee1c82a4' ORDER BY position ASC LIMIT 20;

SELECT slug, abbreviation, number_of_items FROM shop.visible_catalog_categories WHERE parent_id = ? ORDER BY position ASC

[
  Termyn\Uuid\Symfony\SymfonyUuid {#976
    __toString(): "3aedb44d-c917-4b99-a8cb-abbdee1c82a4"
  }
]

SELECT
  slug,
  abbreviation,
  number_of_items
FROM
  shop.visible_catalog_categories
WHERE
  parent_id = ?
ORDER BY
  position ASC

SELECT slug, abbreviation, number_of_items FROM shop.visible_catalog_categories WHERE parent_id = '3aedb44d-c917-4b99-a8cb-abbdee1c82a4' ORDER BY position ASC;

SELECT slug, name, image, price_original_incl_vat, price_current_incl_vat, at_discount FROM shop.best_sellers WHERE category_id = ? LIMIT 3

[
  Termyn\Uuid\Symfony\SymfonyUuid {#976
    __toString(): "3aedb44d-c917-4b99-a8cb-abbdee1c82a4"
  }
]

SELECT
  slug,
  name,
  image,
  price_original_incl_vat,
  price_current_incl_vat,
  at_discount
FROM
  shop.best_sellers
WHERE
  category_id = ?
LIMIT
  3

SELECT slug, name, image, price_original_incl_vat, price_current_incl_vat, at_discount FROM shop.best_sellers WHERE category_id = '3aedb44d-c917-4b99-a8cb-abbdee1c82a4' LIMIT 3;

SELECT id, name, slug FROM shop.exposed_catalog_categories WHERE parent_id = ? LIMIT 3

[
  Termyn\Uuid\Symfony\SymfonyUuid {#976
    __toString(): "3aedb44d-c917-4b99-a8cb-abbdee1c82a4"
  }
]

SELECT
  id,
  name,
  slug
FROM
  shop.exposed_catalog_categories
WHERE
  parent_id = ?
LIMIT
  3

SELECT id, name, slug FROM shop.exposed_catalog_categories WHERE parent_id = '3aedb44d-c917-4b99-a8cb-abbdee1c82a4' LIMIT 3;

SELECT id, name, slug, image, price_current_incl_vat, price_original_incl_vat, price_currency, stock_status, at_discount, available_for_purchase_online FROM shop.visible_catalog_items WHERE category_id = ? ORDER BY sold DESC LIMIT 4

[
  Termyn\Uuid\Symfony\SymfonyUuid {#1358
    __toString(): "7cab6425-76d2-4176-b0ff-f405d0adb287"
  }
]

SELECT
  id,
  name,
  slug,
  image,
  price_current_incl_vat,
  price_original_incl_vat,
  price_currency,
  stock_status,
  at_discount,
  available_for_purchase_online
FROM
  shop.visible_catalog_items
WHERE
  category_id = ?
ORDER BY
  sold DESC
LIMIT
  4

SELECT id, name, slug, image, price_current_incl_vat, price_original_incl_vat, price_currency, stock_status, at_discount, available_for_purchase_online FROM shop.visible_catalog_items WHERE category_id = '7cab6425-76d2-4176-b0ff-f405d0adb287' ORDER BY sold DESC LIMIT 4;

SELECT id, name, slug, image, price_current_incl_vat, price_original_incl_vat, price_currency, stock_status, at_discount, available_for_purchase_online FROM shop.visible_catalog_items WHERE category_id = ? ORDER BY sold DESC LIMIT 4

[
  Termyn\Uuid\Symfony\SymfonyUuid {#1345
    __toString(): "8c688f43-4cb4-47e5-b004-b864a1aba972"
  }
]

SELECT
  id,
  name,
  slug,
  image,
  price_current_incl_vat,
  price_original_incl_vat,
  price_currency,
  stock_status,
  at_discount,
  available_for_purchase_online
FROM
  shop.visible_catalog_items
WHERE
  category_id = ?
ORDER BY
  sold DESC
LIMIT
  4

SELECT id, name, slug, image, price_current_incl_vat, price_original_incl_vat, price_currency, stock_status, at_discount, available_for_purchase_online FROM shop.visible_catalog_items WHERE category_id = '8c688f43-4cb4-47e5-b004-b864a1aba972' ORDER BY sold DESC LIMIT 4;

SELECT id, name, slug, image, price_current_incl_vat, price_original_incl_vat, price_currency, stock_status, at_discount, available_for_purchase_online FROM shop.visible_catalog_items WHERE category_id = ? ORDER BY sold DESC LIMIT 4

[
  Termyn\Uuid\Symfony\SymfonyUuid {#1349
    __toString(): "3fe8e7d7-f7a9-4c50-a6ba-9ea79ac969fd"
  }
]

SELECT
  id,
  name,
  slug,
  image,
  price_current_incl_vat,
  price_original_incl_vat,
  price_currency,
  stock_status,
  at_discount,
  available_for_purchase_online
FROM
  shop.visible_catalog_items
WHERE
  category_id = ?
ORDER BY
  sold DESC
LIMIT
  4

SELECT id, name, slug, image, price_current_incl_vat, price_original_incl_vat, price_currency, stock_status, at_discount, available_for_purchase_online FROM shop.visible_catalog_items WHERE category_id = '3fe8e7d7-f7a9-4c50-a6ba-9ea79ac969fd' ORDER BY sold DESC LIMIT 4;