Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
110.27 ms
(82.23%)
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
  108208
  404479
  478732
  480889
  481644
  485995
  488510
  489015
  495887
  499486
  507460
  508519
  508539
  509144
  509728
  510139
  510858
  511302
  513921
  518415
  520513
  520830
  521232
  521676
  522719
  523485
  527690
  527929
  528843
  536940
  538527
  538984
  539213
  539252
  539349
  540766
  541537
  543171
  546584
  547381
  547545
  550834
  551783
  552840
  553871
  554295
  555161
  555467
  555725
  557604
  557726
  557774
  557836
  557915
  558837
  564228
  568637
  574151
  574329
  574409
  574937
  575371
  576200
  577271
  577568
  577663
  578256
  578293
  579977
  580398
  582000
  582634
  582931
  584151
  584439
  584564
  585257
  585586
  586309
  588430
  588814
  589814
  591736
  592137
  592553
  595666
  596329
  596343
  598569
  599805
  601794
  602429
  602505
  602712
  602765
  603114
  604720
  604856
  604857
  605656
  606537
  607277
  610615
  612763
  613732
  617732
  620549
  628901
  630955
  638894
  640334
  641004
  652630
  656522
  670180
  671936
  675453
  678691
  686862
  688680
]
14.56 ms
(10.86%)
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
  478732
  522719
  686862
  527690
  518415
  538527
  547381
  555467
  582931
  557604
  577271
  579977
  586309
  592137
  603114
  604857
  508519
  528843
  558837
  527929
  588814
  539349
  509144
  577663
  582000
  546584
  577568
  602765
  610615
  617732
  574409
  580398
  582634
  670180
  585586
  607277
  108208
  485995
  555725
  595666
  602505
  480889
  481644
  574151
  688680
  656522
  564228
  592553
  605656
  628901
  620549
  584564
  584151
  550834
  578293
  499486
  536940
  538984
  547545
  554295
  568637
  574329
  543171
  557774
  576200
  585257
  598569
  602429
  613732
  588430
  606537
  596329
  596343
  638894
  641004
  630955
  540766
  523485
  584439
  678691
  589814
  599805
  675453
  553871
  601794
  612763
  604720
  507460
  539213
  495887
  513921
  541537
  552840
  557726
  557836
  671936
  555161
  578256
  602712
  520513
  508539
  509728
  489015
  510858
  404479
  604856
  574937
  640334
  488510
  591736
  510139
  511302
  520830
  521232
  521676
  539252
  551783
  557915
  575371
  652630
]
2.53 ms
(1.89%)
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
  108208
  404479
  478732
  480889
  481644
  485995
  488510
  489015
  495887
  499486
  507460
  508519
  508539
  509144
  509728
  510139
  510858
  511302
  513921
  518415
  520513
  520830
  521232
  521676
  522719
  523485
  527690
  527929
  528843
  536940
  538527
  538984
  539213
  539252
  539349
  540766
  541537
  543171
  546584
  547381
  547545
  550834
  551783
  552840
  553871
  554295
  555161
  555467
  555725
  557604
  557726
  557774
  557836
  557915
  558837
  564228
  568637
  574151
  574329
  574409
  574937
  575371
  576200
  577271
  577568
  577663
  578256
  578293
  579977
  580398
  582000
  582634
  582931
  584151
  584439
  584564
  585257
  585586
  586309
  588430
  588814
  589814
  591736
  592137
  592553
  595666
  596329
  596343
  598569
  599805
  601794
  602429
  602505
  602712
  602765
  603114
  604720
  604856
  604857
  605656
  606537
  607277
  610615
  612763
  613732
  617732
  620549
  628901
  630955
  638894
  640334
  641004
  652630
  656522
  670180
  671936
  675453
  678691
  686862
  688680
]
1.88 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"кончает в лицо мужчинâ…"
]
1.67 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм в лиц мужчин"
]
1.66 ms
(1.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.