Query Metrics
97
Database Queries
11
Different statements
12.74 ms
Query time
0
Invalid entities
75
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.24 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"Data"
]
|
| 2 | 0.31 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "110" "en" "App\Entity\Product\Category" ] |
| 3 | 1.51 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.summary AS summary_3, p0_.price_gross_amount AS price_gross_amount_4, p0_.price_gross_currency AS price_gross_currency_5, p0_.price_with_discount_amount AS price_with_discount_amount_6, p0_.price_with_discount_currency AS price_with_discount_currency_7, p0_.mfr_code AS mfr_code_8, p0_.blk_code AS blk_code_9, p1_.id AS id_10, p1_.name AS name_11, a2_.name AS name_12, a2_.path AS path_13, p3_.id AS id_14, p3_.name AS name_15, p3_.slug AS slug_16, a4_.name AS name_17, a4_.path AS path_18, p5_.slug AS slug_19, p6_.slug AS slug_20 FROM products p0_ INNER JOIN products_categories p7_ ON p0_.id = p7_.product_id INNER JOIN product_manufacturer p3_ ON (p0_.manufacturer_id = p3_.id) INNER JOIN app_file a4_ ON (p3_.logo_id = a4_.id) AND a4_.discr IN ('manufacturer_logo') INNER JOIN products_categories p8_ ON (p0_.id = p8_.product_id) INNER JOIN product_category p5_ ON (p8_.category_id = p5_.id) INNER JOIN products_categories p9_ ON (p0_.id = p9_.product_id AND p9_.main = 1) INNER JOIN product_category p6_ ON (p9_.category_id = p6_.id) INNER JOIN product_type p1_ ON (p0_.type_id = p1_.id) LEFT JOIN app_file a2_ ON (p0_.main_image_id = a2_.id) AND a2_.discr IN ('product_image', 'product_category_banner', 'manufacturer_logo', 'product_reference_pdf', 'product_reference_image') WHERE (p7_.category_id = ? AND p0_.published = ? AND p0_.status NOT IN (?, ?)) AND p0_.discr IN ('product', 'product_kit') GROUP BY p0_.id ORDER BY p0_.name ASC
Parameters:
[ 110 1 "view" "no_view" ] |
| 4 | 0.63 ms |
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM cart t0 WHERE t0.session_id = ? LIMIT 1
Parameters:
[
"cart_6988f730dd4de0.68495863"
]
|
| 5 | 0.34 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.lvl = ?
Parameters:
[
1
]
|
| 6 | 0.24 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "4" "en" "App\Entity\Product\Category" ] |
| 7 | 0.19 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "5" "en" "App\Entity\Product\Category" ] |
| 8 | 0.18 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "6" "en" "App\Entity\Product\Category" ] |
| 9 | 0.18 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "7" "en" "App\Entity\Product\Category" ] |
| 10 | 0.19 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "8" "en" "App\Entity\Product\Category" ] |
| 11 | 0.18 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "9" "en" "App\Entity\Product\Category" ] |
| 12 | 0.18 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "10" "en" "App\Entity\Product\Category" ] |
| 13 | 0.09 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "11" "en" "App\Entity\Product\Category" ] |
| 14 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "14" "en" "App\Entity\Product\Category" ] |
| 15 | 0.10 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.tree_root = ? LIMIT 1
Parameters:
[
true
]
|
| 16 | 0.09 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "1" "en" "App\Entity\Product\Category" ] |
| 17 | 0.61 ms |
SELECT p0_.id AS id_0, p0_.migration_id AS migration_id_1, p0_.softone_id AS softone_id_2, p0_.name AS name_3, p0_.slug AS slug_4, p0_.description AS description_5, p0_.lft AS lft_6, p0_.lvl AS lvl_7, p0_.rgt AS rgt_8, p0_.published AS published_9, p0_.sort_index AS sort_index_10 FROM product_category p0_ WHERE p0_.rgt < 924 AND p0_.lft > 1 AND p0_.tree_root = ? ORDER BY p0_.tree_root ASC, p0_.lft ASC
Parameters:
[
1
]
|
| 18 | 0.15 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.wishlist AS wishlist_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.price_amount AS price_amount_6, t0.price_currency AS price_currency_7, t0.cart_id AS cart_id_8, t0.product_id AS product_id_9 FROM cart_item t0 WHERE t0.cart_id = ?
Parameters:
[
b"\x1F\x10RýÝÝo`œGé\x1Ai¹Ù3"
]
|
| 19 | 0.10 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.id = ?
Parameters:
[
49
]
|
| 20 | 0.14 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "49" "en" "App\Entity\Product\Category" ] |
| 21 | 0.20 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
4
]
|
| 22 | 0.15 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "15" "en" "App\Entity\Product\Category" ] |
| 23 | 0.09 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "17" "en" "App\Entity\Product\Category" ] |
| 24 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "19" "en" "App\Entity\Product\Category" ] |
| 25 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "20" "en" "App\Entity\Product\Category" ] |
| 26 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "22" "en" "App\Entity\Product\Category" ] |
| 27 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "24" "en" "App\Entity\Product\Category" ] |
| 28 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "25" "en" "App\Entity\Product\Category" ] |
| 29 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "27" "en" "App\Entity\Product\Category" ] |
| 30 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "28" "en" "App\Entity\Product\Category" ] |
| 31 | 0.07 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "30" "en" "App\Entity\Product\Category" ] |
| 32 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "32" "en" "App\Entity\Product\Category" ] |
| 33 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "33" "en" "App\Entity\Product\Category" ] |
| 34 | 0.07 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "36" "en" "App\Entity\Product\Category" ] |
| 35 | 0.07 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "37" "en" "App\Entity\Product\Category" ] |
| 36 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "38" "en" "App\Entity\Product\Category" ] |
| 37 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "39" "en" "App\Entity\Product\Category" ] |
| 38 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "40" "en" "App\Entity\Product\Category" ] |
| 39 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "41" "en" "App\Entity\Product\Category" ] |
| 40 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "42" "en" "App\Entity\Product\Category" ] |
| 41 | 0.07 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "43" "en" "App\Entity\Product\Category" ] |
| 42 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "44" "en" "App\Entity\Product\Category" ] |
| 43 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "45" "en" "App\Entity\Product\Category" ] |
| 44 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "46" "en" "App\Entity\Product\Category" ] |
| 45 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "47" "en" "App\Entity\Product\Category" ] |
| 46 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "48" "en" "App\Entity\Product\Category" ] |
| 47 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "50" "en" "App\Entity\Product\Category" ] |
| 48 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "51" "en" "App\Entity\Product\Category" ] |
| 49 | 0.14 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
5
]
|
| 50 | 0.13 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "18" "en" "App\Entity\Product\Category" ] |
| 51 | 0.09 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "23" "en" "App\Entity\Product\Category" ] |
| 52 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "26" "en" "App\Entity\Product\Category" ] |
| 53 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "31" "en" "App\Entity\Product\Category" ] |
| 54 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "35" "en" "App\Entity\Product\Category" ] |
| 55 | 0.11 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
6
]
|
| 56 | 0.16 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "52" "en" "App\Entity\Product\Category" ] |
| 57 | 0.09 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "55" "en" "App\Entity\Product\Category" ] |
| 58 | 0.09 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "58" "en" "App\Entity\Product\Category" ] |
| 59 | 0.09 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "61" "en" "App\Entity\Product\Category" ] |
| 60 | 0.09 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "65" "en" "App\Entity\Product\Category" ] |
| 61 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "67" "en" "App\Entity\Product\Category" ] |
| 62 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "70" "en" "App\Entity\Product\Category" ] |
| 63 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "74" "en" "App\Entity\Product\Category" ] |
| 64 | 0.11 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
7
]
|
| 65 | 0.13 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "53" "en" "App\Entity\Product\Category" ] |
| 66 | 0.11 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "57" "en" "App\Entity\Product\Category" ] |
| 67 | 0.09 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "59" "en" "App\Entity\Product\Category" ] |
| 68 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "62" "en" "App\Entity\Product\Category" ] |
| 69 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "64" "en" "App\Entity\Product\Category" ] |
| 70 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "68" "en" "App\Entity\Product\Category" ] |
| 71 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "71" "en" "App\Entity\Product\Category" ] |
| 72 | 0.09 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "72" "en" "App\Entity\Product\Category" ] |
| 73 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "75" "en" "App\Entity\Product\Category" ] |
| 74 | 0.11 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
8
]
|
| 75 | 0.11 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "16" "en" "App\Entity\Product\Category" ] |
| 76 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "21" "en" "App\Entity\Product\Category" ] |
| 77 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "29" "en" "App\Entity\Product\Category" ] |
| 78 | 0.07 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "34" "en" "App\Entity\Product\Category" ] |
| 79 | 0.10 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
9
]
|
| 80 | 0.13 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "54" "en" "App\Entity\Product\Category" ] |
| 81 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "56" "en" "App\Entity\Product\Category" ] |
| 82 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "60" "en" "App\Entity\Product\Category" ] |
| 83 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "63" "en" "App\Entity\Product\Category" ] |
| 84 | 0.09 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "66" "en" "App\Entity\Product\Category" ] |
| 85 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "69" "en" "App\Entity\Product\Category" ] |
| 86 | 0.08 ms |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "73" "en" "App\Entity\Product\Category" ] |
| 87 | 0.09 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
10
]
|
| 88 | 0.08 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
11
]
|
| 89 | 0.09 ms |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
14
]
|
| 90 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rate AS rate_3, t0.code AS code_4, t0.symbol AS symbol_5, t0.published AS published_6, t0.default_currency AS default_currency_7 FROM currency t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"USD"
]
|
| 91 | 0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rate AS rate_3, t0.code AS code_4, t0.symbol AS symbol_5, t0.published AS published_6, t0.default_currency AS default_currency_7 FROM currency t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"USD"
]
|
| 92 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rate AS rate_3, t0.code AS code_4, t0.symbol AS symbol_5, t0.published AS published_6, t0.default_currency AS default_currency_7 FROM currency t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"USD"
]
|
| 93 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rate AS rate_3, t0.code AS code_4, t0.symbol AS symbol_5, t0.published AS published_6, t0.default_currency AS default_currency_7 FROM currency t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"USD"
]
|
| 94 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rate AS rate_3, t0.code AS code_4, t0.symbol AS symbol_5, t0.published AS published_6, t0.default_currency AS default_currency_7 FROM currency t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"GBP"
]
|
| 95 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rate AS rate_3, t0.code AS code_4, t0.symbol AS symbol_5, t0.published AS published_6, t0.default_currency AS default_currency_7 FROM currency t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"GBP"
]
|
| 96 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rate AS rate_3, t0.code AS code_4, t0.symbol AS symbol_5, t0.published AS published_6, t0.default_currency AS default_currency_7 FROM currency t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"GBP"
]
|
| 97 | 0.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rate AS rate_3, t0.code AS code_4, t0.symbol AS symbol_5, t0.published AS published_6, t0.default_currency AS default_currency_7 FROM currency t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"GBP"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| blk | doctrine.dbal.blk_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Product\Category | 72 |
| App\Entity\Common\Currency | 2 |
| App\Entity\Cart\Cart | 1 |