Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.97 ms
(86.24%)
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
  91663
  100685
  130054
  194530
  365868
  382463
  390052
  391089
  395986
  396432
  402596
  403418
  418443
  425069
  454786
  456172
  459106
  468319
  468552
  509082
  514662
  529210
  534864
  536716
  537797
  542444
  543655
  543661
  545358
  549060
  557446
  561920
  569537
  569814
  580356
  588116
  589655
  595469
  595928
  596525
  602153
  605976
  607628
  609045
  616592
  619094
  620219
  621382
  625755
  626796
  635029
  636088
  637383
  640617
  640935
  641064
  646129
  651373
  656879
  661311
  662085
  662545
  667075
  667568
  668485
  669319
  670934
  671247
  671906
  673573
  674279
  675142
  680330
  680354
  685900
  686029
  688129
  692517
  705726
  712550
  713840
  720631
  726767
  732623
  733088
  733091
  734011
  739764
  748744
  749101
  757246
  760241
  768194
  773105
  774855
  779317
  780089
  780504
  780723
  780763
  782349
  785251
  787148
  787639
  788318
  788795
  788833
  790093
  790630
  793869
  797269
  798629
  802434
  808711
  809205
  809805
  810345
  812609
  813576
  814304
]
13.21 ms
(7.97%)
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
  780504
  780723
  785251
  808711
  810345
  395986
  91663
  194530
  595928
  788795
  797269
  733091
  757246
  726767
  733088
  773105
  768194
  402596
  418443
  692517
  588116
  616592
  798629
  793869
  748744
  732623
  396432
  403418
  651373
  609045
  391089
  468552
  130054
  425069
  100685
  365868
  382463
  390052
  813576
  814304
  456172
  459106
  454786
  468319
  536716
  534864
  529210
  537797
  509082
  514662
  549060
  557446
  569814
  542444
  543655
  545358
  569537
  543661
  580356
  662545
  671247
  671906
  673573
  680354
  688129
  712550
  713840
  656879
  661311
  662085
  667075
  668485
  669319
  675142
  646129
  667568
  670934
  674279
  680330
  685900
  686029
  705726
  720631
  561920
  605976
  607628
  625755
  595469
  596525
  620219
  621382
  637383
  589655
  602153
  619094
  635029
  641064
  626796
  636088
  640617
  640935
  779317
  780089
  788318
  790093
  809205
  774855
  780763
  782349
  787639
  788833
  790630
  809805
  812609
  734011
  739764
  760241
  787148
  802434
  749101
]
2.39 ms
(1.44%)
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
  91663
  100685
  130054
  194530
  365868
  382463
  390052
  391089
  395986
  396432
  402596
  403418
  418443
  425069
  454786
  456172
  459106
  468319
  468552
  509082
  514662
  529210
  534864
  536716
  537797
  542444
  543655
  543661
  545358
  549060
  557446
  561920
  569537
  569814
  580356
  588116
  589655
  595469
  595928
  596525
  602153
  605976
  607628
  609045
  616592
  619094
  620219
  621382
  625755
  626796
  635029
  636088
  637383
  640617
  640935
  641064
  646129
  651373
  656879
  661311
  662085
  662545
  667075
  667568
  668485
  669319
  670934
  671247
  671906
  673573
  674279
  675142
  680330
  680354
  685900
  686029
  688129
  692517
  705726
  712550
  713840
  720631
  726767
  732623
  733088
  733091
  734011
  739764
  748744
  749101
  757246
  760241
  768194
  773105
  774855
  779317
  780089
  780504
  780723
  780763
  782349
  785251
  787148
  787639
  788318
  788795
  788833
  790093
  790630
  793869
  797269
  798629
  802434
  808711
  809205
  809805
  810345
  812609
  813576
  814304
]
1.91 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен беловолосая"
]
1.88 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife blonde"
]
1.80 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен беловолосая"
]
1.62 ms
(0.98%)
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.