Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.38 ms
(84.80%)
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
  387366
  389098
  394786
  397008
  399966
  400106
  400151
  400498
  401130
  401953
  403312
  403363
  403939
  404455
  405977
  407494
  407597
  409895
  414047
  418958
  428869
  428890
  428898
  429307
  430241
  432154
  432838
  435676
  440707
  448731
  450368
  460190
  461598
  464961
  471396
  479112
  479333
  482315
  482325
  484358
  484369
  484390
  484451
  484590
  484608
  485717
  488959
  489851
  490194
  496863
  496871
  502742
  504897
  505696
  505823
  512873
  513520
  515836
  517048
  522690
  523165
  524376
  534336
  543509
  546113
  552757
  555176
  557572
  561077
  564263
  564265
  565632
  565778
  573741
  574417
  580631
  582624
  582801
  585158
  585721
  586681
  587207
  590872
  603973
  605415
  606455
  609816
  612490
  614680
  619515
  625594
  669202
  669218
  685864
  687586
  690102
  703902
  707370
  707539
  715234
  716307
  718870
  724481
  726472
  726550
  726587
  726708
  734506
  759691
  760619
  764039
  772248
  781914
  788173
  792648
  794651
  794947
  807323
  808570
  808603
]
15.57 ms
(9.14%)
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
  505823
  534336
  505696
  512873
  502742
  464961
  489851
  546113
  565632
  573741
  574417
  543509
  557572
  561077
  564265
  669202
  685864
  718870
  687586
  690102
  716307
  669218
  703902
  715234
  552757
  555176
  564263
  565778
  580631
  582801
  585158
  609816
  612490
  606455
  587207
  603973
  614680
  619515
  605415
  625594
  788173
  794947
  808603
  807323
  760619
  794651
  759691
  764039
  724481
  726472
  726708
  734506
  772248
  726550
  726587
  707370
  707539
  781914
  792648
  808570
  401953
  403312
  428869
  428890
  432154
  432838
  460190
  400498
  440707
  471396
  482315
  482325
  389098
  404455
  479333
  397008
  399966
  409895
  428898
  429307
  461598
  479112
  418958
  430241
  435676
  448731
  450368
  504897
  484369
  484390
  484590
  490194
  496863
  523165
  524376
  484358
  484451
  488959
  496871
  513520
  484608
  485717
  515836
  522690
  517048
  582624
  585721
  590872
  586681
  403939
  407597
  394786
  387366
  400151
  400106
  401130
  405977
  403363
  407494
  414047
]
3.48 ms
(2.05%)
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
  387366
  389098
  394786
  397008
  399966
  400106
  400151
  400498
  401130
  401953
  403312
  403363
  403939
  404455
  405977
  407494
  407597
  409895
  414047
  418958
  428869
  428890
  428898
  429307
  430241
  432154
  432838
  435676
  440707
  448731
  450368
  460190
  461598
  464961
  471396
  479112
  479333
  482315
  482325
  484358
  484369
  484390
  484451
  484590
  484608
  485717
  488959
  489851
  490194
  496863
  496871
  502742
  504897
  505696
  505823
  512873
  513520
  515836
  517048
  522690
  523165
  524376
  534336
  543509
  546113
  552757
  555176
  557572
  561077
  564263
  564265
  565632
  565778
  573741
  574417
  580631
  582624
  582801
  585158
  585721
  586681
  587207
  590872
  603973
  605415
  606455
  609816
  612490
  614680
  619515
  625594
  669202
  669218
  685864
  687586
  690102
  703902
  707370
  707539
  715234
  716307
  718870
  724481
  726472
  726550
  726587
  726708
  734506
  759691
  760619
  764039
  772248
  781914
  788173
  792648
  794651
  794947
  807323
  808570
  808603
]
2.04 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young stepmom"
]
1.72 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young stepmom"
]
1.61 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young stepmom"
]

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.