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.
App\Entity\GoodslangTranslate	No errors.
App\Entity\GoodsTranslate	No errors.
App\Entity\Authors	No errors.
App\Entity\Publishers	No errors.
App\Entity\Goodslang	No errors.
App\Entity\Cover	No errors.
App\Entity\GoodsMedia	No errors.
App\Entity\GoodsStatus	No errors.
App\Entity\GoodsPrice	No errors.
App\Entity\GoodsType	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