Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.60 ms
(86.52%)
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
  415814
  420330
  423775
  424240
  424265
  438031
  451526
  470022
  488887
  492758
  497919
  502729
  508300
  512560
  513501
  514888
  519456
  521192
  523528
  529604
  539138
  542346
  542444
  542741
  542784
  542926
  542979
  544931
  547741
  547743
  556471
  558683
  560008
  560021
  560866
  562192
  562743
  569394
  569398
  576239
  579189
  580363
  581135
  582479
  590227
  590238
  598541
  599535
  602806
  603767
  609422
  659984
  663249
  667774
  669893
  686177
  702235
  707373
  709540
  713384
  714324
  716738
  721603
  726593
  745462
  750699
  751536
  751567
  751603
  751803
  753507
  755132
  757568
  758171
  758804
  760881
  763079
  765837
  765859
  766385
  767697
  768290
  768553
  771375
  772763
  777739
  777759
  777861
  778741
  778748
  778749
  779347
  779902
  780088
  783335
  784237
  784776
  788467
  788829
  789276
  791248
  792006
  793955
  795521
  796852
  800934
  802033
  803562
  805145
  806762
  808894
  811233
  811294
  811329
  811887
  812440
  812461
  814028
  820107
  825590
]
13.51 ms
(7.87%)
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
  796852
  812461
  415814
  686177
  751603
  763079
  659984
  590227
  590238
  609422
  451526
  542784
  560021
  784776
  423775
  420330
  544931
  438031
  529604
  768290
  542444
  792006
  802033
  811329
  811887
  812440
  791248
  783335
  808894
  811233
  811294
  767697
  726593
  778741
  779347
  788829
  424240
  542346
  576239
  702235
  492758
  556471
  751567
  750699
  502729
  825590
  772763
  721603
  542926
  581135
  542741
  569394
  582479
  669893
  579189
  820107
  814028
  547743
  716738
  667774
  562743
  805145
  806762
  777759
  778749
  780088
  803562
  755132
  766385
  795521
  760881
  765837
  771375
  758804
  745462
  751803
  768553
  751536
  753507
  757568
  758171
  602806
  777739
  777861
  778748
  779902
  800934
  560008
  558683
  519456
  547741
  789276
  765859
  569398
  470022
  508300
  512560
  514888
  497919
  784237
  793955
  580363
  521192
  539138
  560866
  562192
  713384
  714324
  598541
  599535
  603767
  709540
  707373
  663249
  424265
  523528
  513501
  788467
  488887
  542979
]
2.41 ms
(1.40%)
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
  415814
  420330
  423775
  424240
  424265
  438031
  451526
  470022
  488887
  492758
  497919
  502729
  508300
  512560
  513501
  514888
  519456
  521192
  523528
  529604
  539138
  542346
  542444
  542741
  542784
  542926
  542979
  544931
  547741
  547743
  556471
  558683
  560008
  560021
  560866
  562192
  562743
  569394
  569398
  576239
  579189
  580363
  581135
  582479
  590227
  590238
  598541
  599535
  602806
  603767
  609422
  659984
  663249
  667774
  669893
  686177
  702235
  707373
  709540
  713384
  714324
  716738
  721603
  726593
  745462
  750699
  751536
  751567
  751603
  751803
  753507
  755132
  757568
  758171
  758804
  760881
  763079
  765837
  765859
  766385
  767697
  768290
  768553
  771375
  772763
  777739
  777759
  777861
  778741
  778748
  778749
  779347
  779902
  780088
  783335
  784237
  784776
  788467
  788829
  789276
  791248
  792006
  793955
  795521
  796852
  800934
  802033
  803562
  805145
  806762
  808894
  811233
  811294
  811329
  811887
  812440
  812461
  814028
  820107
  825590
]
2.02 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "домашнее милфа русски…"
]
1.94 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск милф русск"
]
1.60 ms
(0.93%)
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.