Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.97 ms
(86.81%)
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
  34391
  247538
  277079
  383388
  384046
  386824
  388135
  389935
  395769
  398376
  411861
  420333
  423703
  423943
  425505
  443248
  446936
  451661
  454290
  464064
  464270
  465489
  465583
  465918
  465990
  470081
  471168
  474323
  477429
  481927
  492630
  499836
  504348
  509936
  517534
  528370
  531730
  532444
  535294
  536514
  539976
  545491
  553166
  555808
  558402
  559580
  566627
  569558
  569637
  576761
  579622
  580313
  584020
  585849
  586218
  588125
  592482
  598248
  599500
  599653
  599829
  599998
  604815
  607444
  618619
  624128
  627344
  640143
  663286
  671560
  686474
  688922
  689042
  701666
  703650
  704613
  707425
  710471
  712212
  714348
  723839
  736006
  738564
  740442
  743248
  745054
  746122
  750514
  751383
  751390
  752500
  753578
  753715
  754480
  754790
  759138
  762215
  764409
  768431
  769438
  772683
  781255
  783357
  784513
  790447
  791332
  794718
  797175
  799720
  800143
  802196
  803239
  804456
  804829
  806359
  808585
  810092
  812267
  812281
  813818
]
14.84 ms
(7.58%)
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
  791332
  812281
  723839
  736006
  753715
  783357
  794718
  799720
  800143
  804456
  806359
  759138
  772683
  753578
  764409
  745054
  768431
  740442
  751383
  751390
  762215
  607444
  701666
  707425
  781255
  790447
  812267
  34391
  386824
  383388
  384046
  420333
  813818
  477429
  464064
  454290
  481927
  517534
  509936
  569637
  553166
  558402
  555808
  688922
  703650
  704613
  569558
  576761
  584020
  588125
  599829
  585849
  599998
  624128
  797175
  804829
  802196
  784513
  750514
  712212
  810092
  423703
  464270
  474323
  398376
  465489
  465583
  470081
  465918
  504348
  743248
  754790
  388135
  277079
  769438
  465990
  539976
  532444
  559580
  586218
  604815
  618619
  451661
  499836
  395769
  389935
  471168
  492630
  535294
  536514
  528370
  531730
  566627
  579622
  580313
  545491
  671560
  686474
  689042
  714348
  663286
  640143
  592482
  599653
  598248
  599500
  627344
  803239
  808585
  746122
  752500
  738564
  754480
  710471
  247538
  411861
  425505
  443248
  446936
  423943
]
3.48 ms
(1.78%)
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
  34391
  247538
  277079
  383388
  384046
  386824
  388135
  389935
  395769
  398376
  411861
  420333
  423703
  423943
  425505
  443248
  446936
  451661
  454290
  464064
  464270
  465489
  465583
  465918
  465990
  470081
  471168
  474323
  477429
  481927
  492630
  499836
  504348
  509936
  517534
  528370
  531730
  532444
  535294
  536514
  539976
  545491
  553166
  555808
  558402
  559580
  566627
  569558
  569637
  576761
  579622
  580313
  584020
  585849
  586218
  588125
  592482
  598248
  599500
  599653
  599829
  599998
  604815
  607444
  618619
  624128
  627344
  640143
  663286
  671560
  686474
  688922
  689042
  701666
  703650
  704613
  707425
  710471
  712212
  714348
  723839
  736006
  738564
  740442
  743248
  745054
  746122
  750514
  751383
  751390
  752500
  753578
  753715
  754480
  754790
  759138
  762215
  764409
  768431
  769438
  772683
  781255
  783357
  784513
  790447
  791332
  794718
  797175
  799720
  800143
  802196
  803239
  804456
  804829
  806359
  808585
  810092
  812267
  812281
  813818
]
1.99 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo in bathroom"
]
1.88 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло ван"
]
1.77 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.