Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.95 ms
(84.74%)
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
  306045
  382926
  396507
  401969
  405061
  405718
  429189
  437618
  438759
  447812
  457401
  458781
  459022
  461448
  463470
  474621
  488823
  491227
  491656
  491662
  491669
  491686
  494561
  500498
  500530
  501830
  502537
  507136
  517395
  517588
  525202
  527632
  540095
  541593
  542319
  545086
  545359
  547141
  558980
  563634
  566817
  567340
  567345
  569535
  572246
  574562
  574796
  574863
  575075
  575451
  575483
  575789
  587689
  594860
  599533
  604539
  604698
  604977
  605624
  605643
  607319
  607448
  610076
  610689
  611820
  615426
  625086
  630893
  636550
  636567
  646012
  648917
  650983
  654534
  655320
  663446
  663981
  682291
  687989
  691717
  691724
  691729
  692845
  701472
  709337
  713055
  720223
  724723
  725089
  725948
  726157
  727721
  727799
  731058
  731727
  732633
  732644
  734388
  737847
  742145
  742153
  742261
  745518
  747760
  748441
  749743
  757897
  758406
  760534
  769379
  773960
  773971
  795150
  795955
  797138
  808064
  809879
  813438
  814083
  828379
]
15.62 ms
(9.32%)
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
  501830
  517395
  654534
  655320
  630893
  502537
  611820
  405061
  599533
  563634
  474621
  488823
  463470
  542319
  545086
  541593
  725089
  575075
  691717
  709337
  574562
  569535
  701472
  574796
  742145
  458781
  691724
  760534
  745518
  725948
  813438
  494561
  605624
  636567
  615426
  795955
  795150
  461448
  540095
  575789
  749743
  605643
  757897
  575483
  437618
  491686
  396507
  650983
  769379
  732633
  491669
  663981
  713055
  773960
  747760
  828379
  727799
  382926
  517588
  567345
  742261
  731727
  459022
  491656
  527632
  687989
  604539
  438759
  491662
  732644
  401969
  547141
  691729
  682291
  773971
  636550
  500530
  447812
  604698
  405718
  692845
  724723
  604977
  797138
  507136
  607319
  607448
  727721
  742153
  758406
  809879
  731058
  306045
  500498
  491227
  575451
  648917
  587689
  625086
  429189
  457401
  814083
  566817
  567340
  545359
  646012
  720223
  594860
  734388
  748441
  610076
  558980
  572246
  574863
  610689
  737847
  663446
  525202
  726157
  808064
]
3.05 ms
(1.82%)
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
  306045
  382926
  396507
  401969
  405061
  405718
  429189
  437618
  438759
  447812
  457401
  458781
  459022
  461448
  463470
  474621
  488823
  491227
  491656
  491662
  491669
  491686
  494561
  500498
  500530
  501830
  502537
  507136
  517395
  517588
  525202
  527632
  540095
  541593
  542319
  545086
  545359
  547141
  558980
  563634
  566817
  567340
  567345
  569535
  572246
  574562
  574796
  574863
  575075
  575451
  575483
  575789
  587689
  594860
  599533
  604539
  604698
  604977
  605624
  605643
  607319
  607448
  610076
  610689
  611820
  615426
  625086
  630893
  636550
  636567
  646012
  648917
  650983
  654534
  655320
  663446
  663981
  682291
  687989
  691717
  691724
  691729
  692845
  701472
  709337
  713055
  720223
  724723
  725089
  725948
  726157
  727721
  727799
  731058
  731727
  732633
  732644
  734388
  737847
  742145
  742153
  742261
  745518
  747760
  748441
  749743
  757897
  758406
  760534
  769379
  773960
  773971
  795150
  795955
  797138
  808064
  809879
  813438
  814083
  828379
]
1.87 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex cuckold"
]
1.84 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс куколд"
]
1.43 ms
(0.85%)
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.