Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
196.92 ms
(86.38%)
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
  420762
  435746
  443080
  445390
  445739
  447036
  450470
  454947
  458182
  459151
  464376
  467844
  469586
  475232
  476022
  478995
  479378
  479835
  501912
  502540
  502541
  502549
  502554
  507787
  511194
  514265
  516634
  516780
  516823
  517372
  517465
  517602
  517609
  523054
  525635
  527031
  528661
  528865
  535071
  537155
  543425
  545009
  551572
  554649
  558303
  560368
  561120
  561879
  564902
  571308
  576248
  576966
  578793
  579541
  579843
  579853
  582785
  585753
  593865
  593894
  599292
  599690
  603218
  603605
  603618
  603640
  603678
  604050
  604710
  607018
  608177
  613953
  619292
  622978
  623221
  623813
  626885
  627749
  632435
  641473
  641564
  644102
  648907
  653823
  659391
  662474
  664521
  699678
  700819
  700864
  705511
  708134
  712648
  712651
  720163
  720241
  726248
  726695
  727767
  729112
  730406
  730496
  731233
  732592
  732623
  732717
  732888
  749465
  759696
  768758
  786474
  788881
  796797
  796811
  797878
  809545
  810310
  813050
  819767
  824541
]
21.12 ms
(9.26%)
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
  705511
  523054
  729112
  759696
  516780
  561879
  564902
  558303
  599292
  593894
  813050
  475232
  445390
  623813
  768758
  603218
  450470
  525635
  712648
  810310
  730496
  732717
  732888
  579843
  578793
  576966
  527031
  511194
  551572
  593865
  603678
  467844
  435746
  537155
  648907
  653823
  459151
  514265
  507787
  517609
  528865
  554649
  664521
  571308
  585753
  603618
  599690
  608177
  796811
  732592
  478995
  464376
  458182
  727767
  824541
  619292
  809545
  469586
  517602
  528661
  443080
  445739
  502549
  535071
  700819
  632435
  641473
  644102
  700864
  708134
  788881
  720241
  501912
  502541
  560368
  613953
  502554
  797878
  732623
  582785
  627749
  420762
  479835
  517372
  579853
  516634
  579541
  604710
  712651
  730406
  731233
  749465
  516823
  699678
  819767
  517465
  545009
  622978
  603605
  662474
  479378
  720163
  476022
  454947
  607018
  726695
  796797
  604050
  626885
  561120
  641564
  786474
  726248
  623221
  576248
  502540
  543425
  659391
  603640
  447036
]
2.70 ms
(1.18%)
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
  420762
  435746
  443080
  445390
  445739
  447036
  450470
  454947
  458182
  459151
  464376
  467844
  469586
  475232
  476022
  478995
  479378
  479835
  501912
  502540
  502541
  502549
  502554
  507787
  511194
  514265
  516634
  516780
  516823
  517372
  517465
  517602
  517609
  523054
  525635
  527031
  528661
  528865
  535071
  537155
  543425
  545009
  551572
  554649
  558303
  560368
  561120
  561879
  564902
  571308
  576248
  576966
  578793
  579541
  579843
  579853
  582785
  585753
  593865
  593894
  599292
  599690
  603218
  603605
  603618
  603640
  603678
  604050
  604710
  607018
  608177
  613953
  619292
  622978
  623221
  623813
  626885
  627749
  632435
  641473
  641564
  644102
  648907
  653823
  659391
  662474
  664521
  699678
  700819
  700864
  705511
  708134
  712648
  712651
  720163
  720241
  726248
  726695
  727767
  729112
  730406
  730496
  731233
  732592
  732623
  732717
  732888
  749465
  759696
  768758
  786474
  788881
  796797
  796811
  797878
  809545
  810310
  813050
  819767
  824541
]
2.25 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cuckold wife husband"
]
1.68 ms
(0.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "куколд жен husband"
]
1.65 ms
(0.73%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куколд жен husband"
]

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.