Query Metrics

7 Database Queries
7 Different statements
378.18 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
210.23 ms
(55.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "кроват"
]
148.48 ms
(39.26%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  3726
  7058
  7166
  10209
  12880
  16870
  29148
  33602
  36852
  48159
  66264
  68464
  74181
  78760
  85250
  104551
  107348
  142528
  160352
  191059
  260350
  281927
  323899
  338731
  345780
  365992
  368131
  377287
  381820
  382480
  383079
  384106
  384568
  385279
  385438
  387623
  388410
  389451
  390116
  390987
  391468
  391638
  392493
  392552
  393151
  393423
  394064
  394218
  394818
  395393
  396388
  397186
  398078
  398562
  398690
  399586
  400467
  401466
  402929
  403292
  405922
  408446
  408581
  411943
  416959
  420334
  430560
  447188
  452464
  459884
  470542
  480979
  484729
  490787
  493154
  504828
  507395
  509749
  511330
  516479
  516803
  525175
  526482
  529083
  530363
  532058
  532073
  540516
  544362
  546175
  549351
  553550
  559467
  566841
  568032
  570229
  570466
  584964
  624150
  645509
  646286
  648421
  651205
  651236
  651393
  654518
  658363
  662917
  664442
  670987
  673530
  677630
  685394
  685415
  687105
  707079
  716311
  716439
  722142
  778106
]
11.38 ms
(3.01%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  716311
  778106
  36852
  104551
  391638
  395393
  411943
  85250
  48159
  323899
  403292
  66264
  397186
  401466
  68464
  160352
  191059
  365992
  377287
  388410
  408581
  420334
  493154
  516803
  526482
  654518
  624150
  416959
  525175
  385438
  383079
  74181
  384106
  384568
  385279
  142528
  107348
  393423
  394064
  394218
  394818
  393151
  392552
  392493
  281927
  338731
  260350
  368131
  382480
  381820
  345780
  33602
  29148
  10209
  12880
  3726
  7166
  16870
  7058
  78760
  389451
  387623
  390116
  390987
  391468
  396388
  398078
  400467
  398562
  398690
  399586
  402929
  405922
  430560
  408446
  447188
  452464
  459884
  470542
  480979
  490787
  530363
  504828
  511330
  529083
  532073
  509749
  540516
  507395
  516479
  532058
  484729
  559467
  570229
  544362
  546175
  549351
  566841
  570466
  553550
  568032
  584964
  645509
  648421
  651236
  651393
  677630
  687105
  646286
  670987
  673530
  685394
  685415
  722142
  651205
  658363
  662917
  664442
  707079
  716439
]
2.47 ms
(0.65%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  3726
  7058
  7166
  10209
  12880
  16870
  29148
  33602
  36852
  48159
  66264
  68464
  74181
  78760
  85250
  104551
  107348
  142528
  160352
  191059
  260350
  281927
  323899
  338731
  345780
  365992
  368131
  377287
  381820
  382480
  383079
  384106
  384568
  385279
  385438
  387623
  388410
  389451
  390116
  390987
  391468
  391638
  392493
  392552
  393151
  393423
  394064
  394218
  394818
  395393
  396388
  397186
  398078
  398562
  398690
  399586
  400467
  401466
  402929
  403292
  405922
  408446
  408581
  411943
  416959
  420334
  430560
  447188
  452464
  459884
  470542
  480979
  484729
  490787
  493154
  504828
  507395
  509749
  511330
  516479
  516803
  525175
  526482
  529083
  530363
  532058
  532073
  540516
  544362
  546175
  549351
  553550
  559467
  566841
  568032
  570229
  570466
  584964
  624150
  645509
  646286
  648421
  651205
  651236
  651393
  654518
  658363
  662917
  664442
  670987
  673530
  677630
  685394
  685415
  687105
  707079
  716311
  716439
  722142
  778106
]
2.07 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "с кроватью"
]
1.81 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кроват"
]
1.75 ms
(0.46%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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

No loaded entities.