Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

6.51 ms Query time

0 Invalid entities

0 Cache hits

1 Cache misses

2 Cache puts

Queries

Group similar statements

#▲	Time	Info
1	3.52 ms	SELECT c0_.id AS id_0, c0_.code1c AS code1c_1, c0_.active AS active_2, c0_.weight AS weight_3, c1_.id AS id_4, c2_.title AS title_5, c2_.description AS description_6, c2_.slug AS slug_7, c2_.seo_title AS seo_title_8, c2_.seo_description AS seo_description_9 FROM category c0_ LEFT JOIN category c1_ ON (c0_.parent_id = c1_.id) LEFT JOIN category_translate c2_ ON (c0_.id = c2_.category_id) WHERE c2_.lang_id = ? AND c0_.active = 1 ORDER BY c0_.weight ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.code1c AS code1c_1, c0_.active AS active_2, c0_.weight AS weight_3, c1_.id AS id_4, c2_.title AS title_5, c2_.description AS description_6, c2_.slug AS slug_7, c2_.seo_title AS seo_title_8, c2_.seo_description AS seo_description_9 FROM category c0_ LEFT JOIN category c1_ ON (c0_.parent_id = c1_.id) LEFT JOIN category_translate c2_ ON (c0_.id = c2_.category_id) WHERE c2_.lang_id = ? AND c0_.active = 1 ORDER BY c0_.weight ASC SELECT c0_.id AS id_0, c0_.code1c AS code1c_1, c0_.active AS active_2, c0_.weight AS weight_3, c1_.id AS id_4, c2_.title AS title_5, c2_.description AS description_6, c2_.slug AS slug_7, c2_.seo_title AS seo_title_8, c2_.seo_description AS seo_description_9 FROM category c0_ LEFT JOIN category c1_ ON (c0_.parent_id = c1_.id) LEFT JOIN category_translate c2_ ON (c0_.id = c2_.category_id) WHERE c2_.lang_id = 1 AND c0_.active = 1 ORDER BY c0_.weight ASC;
2	1.04 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.slug AS slug_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.fulltitle AS fulltitle_9, t0.lang_id AS lang_id_10, t0.category_id AS category_id_11 FROM category_translate t0 WHERE t0.lang_id = ? AND t0.slug = ? LIMIT 1 Parameters: [`1 "books"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.slug AS slug_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.fulltitle AS fulltitle_9, t0.lang_id AS lang_id_10, t0.category_id AS category_id_11 FROM category_translate t0 WHERE t0.lang_id = ? AND t0.slug = ? LIMIT 1 SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.slug AS slug_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.fulltitle AS fulltitle_9, t0.lang_id AS lang_id_10, t0.category_id AS category_id_11 FROM category_translate t0 WHERE t0.lang_id = 1 AND t0.slug = 'books' LIMIT 1;
3	1.95 ms	SELECT g0_.id AS id_0 FROM goods g0_ LEFT JOIN goods_category g2_ ON g0_.id = g2_.goods_id LEFT JOIN category c1_ ON c1_.id = g2_.category_id WHERE g0_.active = 1 AND c1_.id IN (2, 105, 114, 106, 107, 108, 109, 111, 112, 113, 115, 110, 24, 25, 26, 27, 28, 29, 30, 31, 32, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 147, 148) GROUP BY g0_.id ORDER BY g0_.id DESC Parameters: [] View formatted query View runnable query Explain query SELECT g0_.id AS id_0 FROM goods g0_ LEFT JOIN goods_category g2_ ON g0_.id = g2_.goods_id LEFT JOIN category c1_ ON c1_.id = g2_.category_id WHERE g0_.active = 1 AND c1_.id IN ( 2, 105, 114, 106, 107, 108, 109, 111, 112, 113, 115, 110, 24, 25, 26, 27, 28, 29, 30, 31, 32, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 147, 148 ) GROUP BY g0_.id ORDER BY g0_.id DESC SELECT g0_.id AS id_0 FROM goods g0_ LEFT JOIN goods_category g2_ ON g0_.id = g2_.goods_id LEFT JOIN category c1_ ON c1_.id = g2_.category_id WHERE g0_.active = 1 AND c1_.id IN (2, 105, 114, 106, 107, 108, 109, 111, 112, 113, 115, 110, 24, 25, 26, 27, 28, 29, 30, 31, 32, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 147, 148) GROUP BY g0_.id ORDER BY g0_.id DESC;

#▲

Time

Info

3.52 ms

SELECT c0_.id AS id_0, c0_.code1c AS code1c_1, c0_.active AS active_2, c0_.weight AS weight_3, c1_.id AS id_4, c2_.title AS title_5, c2_.description AS description_6, c2_.slug AS slug_7, c2_.seo_title AS seo_title_8, c2_.seo_description AS seo_description_9 FROM category c0_ LEFT JOIN category c1_ ON (c0_.parent_id = c1_.id) LEFT JOIN category_translate c2_ ON (c0_.id = c2_.category_id) WHERE c2_.lang_id = ? AND c0_.active = 1 ORDER BY c0_.weight ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query

SELECT
  c0_.id AS id_0,
  c0_.code1c AS code1c_1,
  c0_.active AS active_2,
  c0_.weight AS weight_3,
  c1_.id AS id_4,
  c2_.title AS title_5,
  c2_.description AS description_6,
  c2_.slug AS slug_7,
  c2_.seo_title AS seo_title_8,
  c2_.seo_description AS seo_description_9
FROM
  category c0_
  LEFT JOIN category c1_ ON (c0_.parent_id = c1_.id)
  LEFT JOIN category_translate c2_ ON (c0_.id = c2_.category_id)
WHERE
  c2_.lang_id = ?
  AND c0_.active = 1
ORDER BY
  c0_.weight ASC

SELECT c0_.id AS id_0, c0_.code1c AS code1c_1, c0_.active AS active_2, c0_.weight AS weight_3, c1_.id AS id_4, c2_.title AS title_5, c2_.description AS description_6, c2_.slug AS slug_7, c2_.seo_title AS seo_title_8, c2_.seo_description AS seo_description_9 FROM category c0_ LEFT JOIN category c1_ ON (c0_.parent_id = c1_.id) LEFT JOIN category_translate c2_ ON (c0_.id = c2_.category_id) WHERE c2_.lang_id = 1 AND c0_.active = 1 ORDER BY c0_.weight ASC;

1.04 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.slug AS slug_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.fulltitle AS fulltitle_9, t0.lang_id AS lang_id_10, t0.category_id AS category_id_11 FROM category_translate t0 WHERE t0.lang_id = ? AND t0.slug = ? LIMIT 1

Parameters:

[
  1
  "books"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.slug AS slug_4,
  t0.seo_title AS seo_title_5,
  t0.seo_description AS seo_description_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.fulltitle AS fulltitle_9,
  t0.lang_id AS lang_id_10,
  t0.category_id AS category_id_11
FROM
  category_translate t0
WHERE
  t0.lang_id = ?
  AND t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.slug AS slug_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.fulltitle AS fulltitle_9, t0.lang_id AS lang_id_10, t0.category_id AS category_id_11 FROM category_translate t0 WHERE t0.lang_id = 1 AND t0.slug = 'books' LIMIT 1;

1.95 ms

SELECT g0_.id AS id_0 FROM goods g0_ LEFT JOIN goods_category g2_ ON g0_.id = g2_.goods_id LEFT JOIN category c1_ ON c1_.id = g2_.category_id WHERE g0_.active = 1 AND c1_.id IN (2, 105, 114, 106, 107, 108, 109, 111, 112, 113, 115, 110, 24, 25, 26, 27, 28, 29, 30, 31, 32, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 147, 148) GROUP BY g0_.id ORDER BY g0_.id DESC

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  g0_.id AS id_0
FROM
  goods g0_
  LEFT JOIN goods_category g2_ ON g0_.id = g2_.goods_id
  LEFT JOIN category c1_ ON c1_.id = g2_.category_id
WHERE
  g0_.active = 1
  AND c1_.id IN (
    2,
    105,
    114,
    106,
    107,
    108,
    109,
    111,
    112,
    113,
    115,
    110,
    24,
    25,
    26,
    27,
    28,
    29,
    30,
    31,
    32,
    3,
    4,
    5,
    6,
    7,
    8,
    9,
    10,
    11,
    12,
    13,
    14,
    15,
    16,
    17,
    18,
    19,
    20,
    21,
    22,
    23,
    33,
    34,
    35,
    36,
    37,
    38,
    39,
    40,
    41,
    42,
    43,
    44,
    45,
    46,
    47,
    48,
    49,
    50,
    51,
    52,
    53,
    54,
    55,
    56,
    57,
    58,
    59,
    60,
    61,
    62,
    63,
    64,
    65,
    66,
    67,
    68,
    69,
    70,
    71,
    72,
    73,
    74,
    75,
    76,
    77,
    78,
    79,
    80,
    81,
    82,
    83,
    84,
    85,
    86,
    87,
    88,
    89,
    90,
    91,
    92,
    93,
    94,
    95,
    96,
    97,
    98,
    99,
    100,
    101,
    102,
    103,
    104,
    116,
    117,
    118,
    119,
    120,
    121,
    122,
    123,
    124,
    125,
    126,
    127,
    128,
    129,
    130,
    131,
    132,
    133,
    134,
    135,
    136,
    137,
    138,
    139,
    140,
    141,
    142,
    143,
    144,
    147,
    148
  )
GROUP BY
  g0_.id
ORDER BY
  g0_.id DESC

SELECT g0_.id AS id_0 FROM goods g0_ LEFT JOIN goods_category g2_ ON g0_.id = g2_.goods_id LEFT JOIN category c1_ ON c1_.id = g2_.category_id WHERE g0_.active = 1 AND c1_.id IN (2, 105, 114, 106, 107, 108, 109, 111, 112, 113, 115, 110, 24, 25, 26, 27, 28, 29, 30, 31, 32, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 147, 148) GROUP BY g0_.id ORDER BY g0_.id DESC;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

0 Hits

1 Misses

2 Puts

Number of cache misses

Region	Misses
app_entity_categorytranslate	1

Number of cache puts

Region	Puts
app_entity_categorytranslate	2

Entities Mapping

Class	Mapping errors
App\Entity\Category	No errors.
App\Entity\CategoryTranslate	No errors.
App\Entity\Lang	No errors.
App\Entity\Goods	No errors.

Symfony Profiler

GET https://books.kin.dp.ua/ua/category/books

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Number of cache misses

Number of cache puts

Entities Mapping