Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
198.18 ms
(87.92%)
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
  3311
  146006
  186592
  396796
  398522
  423972
  462977
  463976
  474087
  476230
  486024
  487928
  491765
  504855
  505236
  505696
  506772
  517683
  518297
  522166
  529804
  530569
  533843
  536521
  536531
  537641
  539751
  547004
  551111
  551891
  570883
  574440
  575980
  582444
  591917
  595116
  602667
  607444
  610031
  614236
  614333
  615920
  617805
  619899
  624791
  624856
  628826
  629528
  639578
  653087
  663911
  664528
  667762
  681184
  697227
  700837
  702615
  710483
  713432
  715419
  717379
  718155
  724457
  725518
  726646
  726795
  733110
  733318
  733504
  735882
  753037
  755065
  761254
  761854
  770194
  770259
  774400
  781790
  781858
  781926
  781940
  781989
  789545
  795046
  795321
  797241
  803875
  804586
  808012
  812284
  815358
  816832
  819273
  819324
  819336
  819799
  819962
  823758
  823778
  823848
  823868
  823983
  825056
  825136
  825148
  825320
  825361
  825433
  826173
  826582
  826598
  826811
  826927
  826980
  827181
  827392
  827498
  827517
  827594
  827712
]
14.18 ms
(6.29%)
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
  825136
  537641
  570883
  574440
  663911
  713432
  681184
  697227
  717379
  551891
  602667
  614236
  591917
  624791
  804586
  795046
  795321
  733318
  803875
  812284
  724457
  770194
  726646
  733110
  753037
  733504
  755065
  735882
  624856
  718155
  761854
  491765
  615920
  146006
  3311
  396796
  819336
  819273
  823778
  536521
  536531
  530569
  533843
  522166
  529804
  539751
  547004
  575980
  653087
  664528
  710483
  702615
  667762
  628826
  629528
  595116
  614333
  619899
  639578
  781858
  781926
  781940
  789545
  808012
  726795
  770259
  725518
  761254
  607444
  700837
  715419
  781790
  781989
  398522
  423972
  617805
  462977
  504855
  506772
  474087
  476230
  582444
  551111
  797241
  486024
  487928
  517683
  505696
  610031
  463976
  518297
  505236
  186592
  816832
  823758
  823983
  825056
  825361
  826173
  774400
  823848
  815358
  819799
  825148
  825320
  825433
  826582
  826598
  823868
  826811
  826927
  826980
  827181
  827594
  827392
  827498
  827517
  827712
  819324
  819962
]
5.42 ms
(2.40%)
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
  3311
  146006
  186592
  396796
  398522
  423972
  462977
  463976
  474087
  476230
  486024
  487928
  491765
  504855
  505236
  505696
  506772
  517683
  518297
  522166
  529804
  530569
  533843
  536521
  536531
  537641
  539751
  547004
  551111
  551891
  570883
  574440
  575980
  582444
  591917
  595116
  602667
  607444
  610031
  614236
  614333
  615920
  617805
  619899
  624791
  624856
  628826
  629528
  639578
  653087
  663911
  664528
  667762
  681184
  697227
  700837
  702615
  710483
  713432
  715419
  717379
  718155
  724457
  725518
  726646
  726795
  733110
  733318
  733504
  735882
  753037
  755065
  761254
  761854
  770194
  770259
  774400
  781790
  781858
  781926
  781940
  781989
  789545
  795046
  795321
  797241
  803875
  804586
  808012
  812284
  815358
  816832
  819273
  819324
  819336
  819799
  819962
  823758
  823778
  823848
  823868
  823983
  825056
  825136
  825148
  825320
  825361
  825433
  826173
  826582
  826598
  826811
  826927
  826980
  827181
  827392
  827498
  827517
  827594
  827712
]
2.14 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "saggy сиськ chubby"
]
1.85 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "saggy tits chubby"
]
1.83 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "saggy сиськ chubby"
]
1.82 ms
(0.81%)
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.