Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.54 ms
(82.94%)
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
  419474
  423832
  427493
  432785
  437403
  447581
  449643
  450135
  450140
  452766
  453049
  453693
  453905
  453982
  456405
  456529
  457820
  458217
  458266
  458497
  459349
  459521
  460284
  461594
  461748
  462957
  463376
  463466
  463593
  464901
  466169
  466555
  467652
  473074
  473134
  474819
  474913
  475882
  476142
  477007
  477364
  477897
  479506
  479538
  479691
  479784
  480165
  481174
  481757
  483209
  483829
  483970
  484520
  486036
  486925
  489084
  489724
  489744
  490181
  492631
  493679
  495239
  495588
  497518
  498231
  499476
  499486
  500377
  500959
  501133
  502337
  502869
  503717
  504950
  506493
  506670
  507006
  509217
  509263
  509360
  510064
  511186
  512626
  512636
  513836
  514053
  514865
  515623
  517693
  517812
  518173
  519106
  520069
  520939
  520967
  521007
  521070
  522491
  522719
  524352
  524812
  525146
  527305
  529359
  530724
  531100
  531913
  532312
  535263
  535745
  536207
  536828
  537952
  542657
  587338
  595683
  598947
  636574
  735752
  811414
]
17.19 ms
(10.60%)
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
  476142
  479691
  450140
  453905
  459349
  463376
  474913
  477897
  479784
  483970
  493679
  447581
  456529
  458266
  459521
  460284
  463593
  474819
  477364
  479538
  484520
  492631
  499486
  507006
  509263
  511186
  517693
  517812
  524352
  532312
  498231
  504950
  515623
  530724
  531913
  537952
  500959
  514053
  519106
  520939
  522719
  525146
  531100
  535263
  495588
  499476
  502869
  510064
  513836
  514865
  535745
  536828
  473074
  473134
  480165
  489724
  542657
  595683
  636574
  587338
  598947
  735752
  811414
  419474
  432785
  453693
  463466
  466555
  437403
  452766
  453049
  461748
  467652
  477007
  481174
  423832
  456405
  458217
  479506
  427493
  449643
  453982
  457820
  462957
  458497
  466169
  475882
  481757
  502337
  509217
  512636
  518173
  520069
  483209
  483829
  486925
  489084
  489744
  503717
  512626
  522491
  495239
  497518
  501133
  509360
  521070
  524812
  527305
  529359
  486036
  490181
  500377
  520967
  521007
  450135
  461594
  464901
  506670
  536207
  506493
]
2.93 ms
(1.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
  419474
  423832
  427493
  432785
  437403
  447581
  449643
  450135
  450140
  452766
  453049
  453693
  453905
  453982
  456405
  456529
  457820
  458217
  458266
  458497
  459349
  459521
  460284
  461594
  461748
  462957
  463376
  463466
  463593
  464901
  466169
  466555
  467652
  473074
  473134
  474819
  474913
  475882
  476142
  477007
  477364
  477897
  479506
  479538
  479691
  479784
  480165
  481174
  481757
  483209
  483829
  483970
  484520
  486036
  486925
  489084
  489724
  489744
  490181
  492631
  493679
  495239
  495588
  497518
  498231
  499476
  499486
  500377
  500959
  501133
  502337
  502869
  503717
  504950
  506493
  506670
  507006
  509217
  509263
  509360
  510064
  511186
  512626
  512636
  513836
  514053
  514865
  515623
  517693
  517812
  518173
  519106
  520069
  520939
  520967
  521007
  521070
  522491
  522719
  524352
  524812
  525146
  527305
  529359
  530724
  531100
  531913
  532312
  535263
  535745
  536207
  536828
  537952
  542657
  587338
  595683
  598947
  636574
  735752
  811414
]
2.06 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot white wife"
]
2.05 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot white жен"
]
1.66 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot white жен"
]

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.