Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.92 ms
(60.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mmf threesome"
]
118.68 ms
(34.27%)
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
  21594
  53553
  96118
  97290
  153602
  221091
  233686
  269876
  350861
  368131
  382654
  382756
  382929
  390116
  391933
  396903
  397893
  402667
  488576
  530287
  531915
  538112
  543232
  543685
  545067
  546675
  546679
  546839
  547991
  549416
  558423
  566442
  566447
  579959
  582772
  602684
  605624
  606551
  612245
  622822
  635853
  635855
  635874
  636567
  639726
  645064
  645825
  645894
  648943
  648952
  649626
  650835
  651262
  653174
  653366
  653631
  654184
  654268
  654282
  654287
  654471
  654491
  654505
  654680
  656638
  657293
  663551
  665450
  666826
  667686
  668416
  669441
  670496
  671931
  675752
  680871
  681719
  701638
  703229
  703558
  706602
  707287
  709421
  713474
  719718
  720867
  721847
  732213
  732721
  735492
  739062
  740797
  742911
  743644
  744867
  755121
  759443
  775026
  780688
  781762
  782031
  782036
  784323
  788105
  790996
  793460
  798695
  799674
  799929
  804110
  805376
  805403
  805781
  807602
  825501
  826217
  827419
  828175
  828756
]
12.12 ms
(3.50%)
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
  703558
  720867
  671931
  391933
  21594
  543232
  827419
  547991
  566447
  645825
  680871
  707287
  709421
  645064
  656638
  549416
  635874
  606551
  793460
  782036
  784323
  759443
  740797
  719718
  805403
  826217
  654268
  654471
  650835
  654505
  668416
  546679
  780688
  743644
  713474
  368131
  654287
  782031
  153602
  667686
  602684
  781762
  805376
  402667
  97290
  582772
  653631
  639726
  382929
  96118
  221091
  799929
  799674
  739062
  350861
  53553
  396903
  566442
  543685
  790996
  732721
  233686
  397893
  382756
  269876
  382654
  825501
  822402
  828175
  828756
  538112
  488576
  545067
  645894
  648943
  654491
  657293
  665450
  666826
  721847
  648952
  653174
  669441
  706602
  654680
  670496
  675752
  701638
  605624
  622822
  612245
  635855
  635853
  805781
  775026
  742911
  744867
  788105
  798695
  807602
  735492
  755121
  703229
  804110
  530287
  654184
  663551
  636567
  732213
  390116
  531915
  558423
  546839
  546675
  579959
  649626
  654282
  681719
  653366
  651262
]
2.81 ms
(0.81%)
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
  21594
  53553
  96118
  97290
  153602
  221091
  233686
  269876
  350861
  368131
  382654
  382756
  382929
  390116
  391933
  396903
  397893
  402667
  488576
  530287
  531915
  538112
  543232
  543685
  545067
  546675
  546679
  546839
  547991
  549416
  558423
  566442
  566447
  579959
  582772
  602684
  605624
  606551
  612245
  622822
  635853
  635855
  635874
  636567
  639726
  645064
  645825
  645894
  648943
  648952
  649626
  650835
  651262
  653174
  653366
  653631
  654184
  654268
  654282
  654287
  654471
  654491
  654505
  654680
  656638
  657293
  663551
  665450
  666826
  667686
  668416
  669441
  670496
  671931
  675752
  680871
  681719
  701638
  703229
  703558
  706602
  707287
  709421
  713474
  719718
  720867
  721847
  732213
  732721
  735492
  739062
  740797
  742911
  743644
  744867
  755121
  759443
  775026
  780688
  781762
  782031
  782036
  784323
  788105
  790996
  793460
  798695
  799674
  799929
  804110
  805376
  805403
  805781
  807602
  825501
  826217
  827419
  828175
  828756
]
1.74 ms
(0.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мжм секс втро секс втро"
]
1.65 ms
(0.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.41%)
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.