GET https://sady.shop/produkt/sada-na-opravu-atb-kompresoru

Query Metrics

21 Database Queries
14 Different statements
29.22 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.40 ms
SELECT id, name, description, image, on_sale, available_for_purchase_online, price_current_incl_vat FROM shop.products WHERE slug = ? LIMIT 1
Parameters:
[
  "sada-na-opravu-atb-kompresoru"
]
2 1.49 ms
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 = ?
Parameters:
[
  "4a9a4683-87a7-4958-b7ac-aa0695191d9a"
]
3 1.20 ms
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 = ?
Parameters:
[
  "4a9a4683-87a7-4958-b7ac-aa0695191d9a"
]
4 1.82 ms
SELECT * FROM public.cart_items WHERE cart_id = ? ORDER BY product_id ASC LIMIT 999
Parameters:
[
  Termyn\Uuid\Symfony\SymfonyUuid {#439
    __toString(): "4a9a4683-87a7-4958-b7ac-aa0695191d9a"
  }
]
5 1.45 ms
SELECT slug, name FROM shop.available_catalogs
Parameters:
[]
6 1.16 ms
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 = ?
Parameters:
[
  "4a9a4683-87a7-4958-b7ac-aa0695191d9a"
]
7 1.09 ms
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 = ?
Parameters:
[
  "4a9a4683-87a7-4958-b7ac-aa0695191d9a"
]
8 1.21 ms
SELECT * FROM public.cart_items WHERE cart_id = ? ORDER BY product_id ASC LIMIT 999
Parameters:
[
  Termyn\Uuid\Symfony\SymfonyUuid {#439
    __toString(): "4a9a4683-87a7-4958-b7ac-aa0695191d9a"
  }
]
9 1.54 ms
SELECT name, category_id FROM shop.products WHERE id = ?
Parameters:
[
  Termyn\Uuid\Symfony\SymfonyUuid {#982
    __toString(): "cf7a5391-b1e3-4c6c-98e1-3a0c8ecf6aca"
  }
]
10 1.26 ms
SELECT abbreviation, slug, parent_id FROM shop.catalog_categories WHERE id = ?
Parameters:
[
  Termyn\Uuid\Symfony\SymfonyUuid {#1145
    __toString(): "3fb7f0fa-7a28-40a2-9fe8-72bb8745c7ab"
  }
]
11 1.23 ms
SELECT abbreviation, slug, parent_id FROM shop.catalog_categories WHERE parent_id = ? and id <> ? ORDER BY position ASC LIMIT 20
Parameters:
[
  Termyn\Uuid\Symfony\SymfonyUuid {#1149
    __toString(): "beb2cc87-36e9-4016-b1eb-c9b512481562"
  }
  Termyn\Uuid\Symfony\SymfonyUuid {#1145
    __toString(): "3fb7f0fa-7a28-40a2-9fe8-72bb8745c7ab"
  }
]
12 1.15 ms
SELECT abbreviation, slug, parent_id FROM shop.catalog_categories WHERE id = ?
Parameters:
[
  Termyn\Uuid\Symfony\SymfonyUuid {#1149
    __toString(): "beb2cc87-36e9-4016-b1eb-c9b512481562"
  }
]
13 1.20 ms
SELECT abbreviation, slug, parent_id FROM shop.catalog_categories WHERE parent_id = ? and id <> ? ORDER BY position ASC LIMIT 20
Parameters:
[
  Termyn\Uuid\Symfony\SymfonyUuid {#1161
    __toString(): "0bfc16f3-0547-409d-bfc7-d2c5f2ef6d35"
  }
  Termyn\Uuid\Symfony\SymfonyUuid {#1149
    __toString(): "beb2cc87-36e9-4016-b1eb-c9b512481562"
  }
]
14 1.07 ms
SELECT abbreviation, slug, parent_id FROM shop.catalog_categories WHERE id = ?
Parameters:
[
  Termyn\Uuid\Symfony\SymfonyUuid {#1161
    __toString(): "0bfc16f3-0547-409d-bfc7-d2c5f2ef6d35"
  }
]
15 1.08 ms
SELECT name, slug FROM shop.catalogs WHERE id = ?
Parameters:
[
  Termyn\Uuid\Symfony\SymfonyUuid {#1161
    __toString(): "0bfc16f3-0547-409d-bfc7-d2c5f2ef6d35"
  }
]
16 1.08 ms
SELECT name, slug FROM shop.catalogs WHERE id <> ? ORDER BY position ASC LIMIT 20
Parameters:
[
  Termyn\Uuid\Symfony\SymfonyUuid {#1161
    __toString(): "0bfc16f3-0547-409d-bfc7-d2c5f2ef6d35"
  }
]
17 1.76 ms
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
Parameters:
[
  Termyn\Uuid\Symfony\SymfonyUuid {#982
    __toString(): "cf7a5391-b1e3-4c6c-98e1-3a0c8ecf6aca"
  }
]
18 1.34 ms
SELECT extended_description FROM shop.product_specifications WHERE id = ?
Parameters:
[
  Termyn\Uuid\Symfony\SymfonyUuid {#982
    __toString(): "cf7a5391-b1e3-4c6c-98e1-3a0c8ecf6aca"
  }
]
19 1.15 ms
SELECT suitable_for FROM shop.product_specifications WHERE id = ?
Parameters:
[
  Termyn\Uuid\Symfony\SymfonyUuid {#982
    __toString(): "cf7a5391-b1e3-4c6c-98e1-3a0c8ecf6aca"
  }
]
20 2.32 ms
SELECT key_features FROM shop.product_specifications WHERE id = ?
Parameters:
[
  Termyn\Uuid\Symfony\SymfonyUuid {#982
    __toString(): "cf7a5391-b1e3-4c6c-98e1-3a0c8ecf6aca"
  }
]
21 1.21 ms
SELECT name, value FROM shop.product_attributes WHERE id = ?
Parameters:
[
  Termyn\Uuid\Symfony\SymfonyUuid {#982
    __toString(): "cf7a5391-b1e3-4c6c-98e1-3a0c8ecf6aca"
  }
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
Sady\Shopping\Cart\Model\Price No errors.
Sady\Shopping\Cart\Model\Cart No errors.