Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.20 ms
(85.98%)
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
  416007
  418128
  418671
  418730
  449319
  450038
  451106
  463420
  469408
  478101
  500320
  530429
  533099
  533276
  541755
  541757
  550926
  551543
  567514
  572978
  576448
  577023
  581392
  584460
  584577
  584987
  586891
  598220
  605742
  618267
  627472
  629771
  636414
  657197
  666680
  668305
  669945
  672850
  678838
  683062
  686138
  692743
  695470
  705478
  706765
  712286
  714083
  724438
  724987
  725602
  729204
  738460
  739930
  740848
  741220
  741222
  747483
  750653
  751705
  752780
  756713
  762147
  767695
  768508
  770254
  773016
  773056
  773059
  773076
  773183
  774878
  775227
  776065
  776081
  777807
  777926
  777989
  778230
  778808
  780038
  780080
  780239
  780553
  783920
  783937
  784456
  784513
  785073
  785170
  785340
  785670
  785678
  785780
  786088
  786368
  786858
  787124
  787812
  790463
  792025
  793259
  794674
  794931
  796194
  797032
  798287
  798674
  801532
  801628
  801827
  806597
  806991
  807010
  807066
  808262
  808651
  810150
  811343
  820020
  824879
]
14.45 ms
(8.44%)
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
  572978
  478101
  576448
  672850
  714083
  794674
  806597
  775227
  777926
  780038
  740848
  786088
  773056
  773059
  724438
  741220
  773076
  778808
  785073
  807066
  541757
  636414
  605742
  586891
  756713
  792025
  768508
  785678
  584460
  463420
  450038
  706765
  598220
  820020
  577023
  551543
  581392
  776081
  777807
  780239
  794931
  798674
  797032
  767695
  786858
  729204
  773016
  739930
  725602
  773183
  750653
  752780
  618267
  776065
  783937
  785170
  787812
  584577
  780080
  416007
  418730
  469408
  449319
  451106
  686138
  669945
  786368
  784513
  796194
  811343
  741222
  747483
  751705
  770254
  807010
  418128
  584987
  530429
  541755
  801532
  692743
  785670
  774878
  762147
  500320
  533099
  567514
  787124
  793259
  798287
  801827
  785340
  790463
  806991
  783920
  784456
  808651
  810150
  724987
  824879
  533276
  666680
  683062
  705478
  712286
  695470
  629771
  418671
  550926
  657197
  668305
  678838
  627472
  777989
  778230
  780553
  785780
  738460
  801628
  808262
]
2.52 ms
(1.47%)
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
  416007
  418128
  418671
  418730
  449319
  450038
  451106
  463420
  469408
  478101
  500320
  530429
  533099
  533276
  541755
  541757
  550926
  551543
  567514
  572978
  576448
  577023
  581392
  584460
  584577
  584987
  586891
  598220
  605742
  618267
  627472
  629771
  636414
  657197
  666680
  668305
  669945
  672850
  678838
  683062
  686138
  692743
  695470
  705478
  706765
  712286
  714083
  724438
  724987
  725602
  729204
  738460
  739930
  740848
  741220
  741222
  747483
  750653
  751705
  752780
  756713
  762147
  767695
  768508
  770254
  773016
  773056
  773059
  773076
  773183
  774878
  775227
  776065
  776081
  777807
  777926
  777989
  778230
  778808
  780038
  780080
  780239
  780553
  783920
  783937
  784456
  784513
  785073
  785170
  785340
  785670
  785678
  785780
  786088
  786368
  786858
  787124
  787812
  790463
  792025
  793259
  794674
  794931
  796194
  797032
  798287
  798674
  801532
  801628
  801827
  806597
  806991
  807010
  807066
  808262
  808651
  810150
  811343
  820020
  824879
]
2.17 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "женский оргазм домашка"
]
1.77 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "женск оргазм домашн любительск"
]
1.57 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.89%)
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.