Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.82 ms
(86.85%)
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
  358453
  397076
  400614
  493424
  493561
  506371
  529810
  530305
  535311
  549550
  563947
  579872
  587908
  598360
  617778
  620431
  639089
  639355
  640617
  646307
  648679
  654359
  656107
  656530
  660455
  660701
  662839
  668905
  675041
  675746
  686091
  693492
  695093
  695467
  699415
  701541
  707608
  707819
  715004
  717726
  717812
  720231
  720793
  721830
  721959
  722001
  723934
  724921
  726989
  728412
  730069
  730333
  731327
  731349
  731354
  731860
  732903
  740726
  741909
  742951
  744746
  745451
  745808
  745912
  747749
  750139
  750278
  750358
  753479
  756094
  756847
  757180
  758087
  758871
  759796
  760971
  761009
  761765
  762253
  764130
  765412
  765679
  765735
  767054
  767193
  768392
  768730
  769046
  769073
  774678
  775715
  777337
  778084
  778962
  780061
  780503
  780968
  784622
  789450
  790538
  791411
  791412
  792720
  794732
  794889
  795528
  795680
  796532
  797521
  799868
  800509
  801309
  803699
  805545
  807038
  809339
  810307
  812829
  814502
]
13.00 ms
(7.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
  721830
  780968
  675746
  764130
  639355
  732903
  686091
  814502
  620431
  778084
  800509
  794889
  795680
  758871
  769073
  758087
  535311
  654359
  731349
  765412
  656107
  724921
  784622
  715004
  397076
  790538
  794732
  731860
  810307
  695093
  695467
  549550
  587908
  598360
  803699
  796532
  740726
  759796
  726989
  731327
  699415
  493561
  717726
  812829
  797521
  723934
  741909
  775715
  358453
  662839
  701541
  720793
  707819
  579872
  805545
  795528
  801309
  809339
  791411
  728412
  753479
  768730
  750139
  767054
  765735
  750278
  761765
  765679
  617778
  720231
  791412
  675041
  563947
  639089
  807038
  780061
  750358
  742951
  762253
  769046
  757180
  646307
  756847
  656530
  780503
  789450
  745808
  747749
  730333
  400614
  493424
  529810
  506371
  648679
  660701
  693492
  707608
  717812
  722001
  640617
  777337
  778962
  756094
  730069
  731354
  761009
  744746
  745451
  745912
  767193
  768392
  760971
  721959
  769740
  530305
  660455
  668905
  774678
  792720
  799868
]
2.30 ms
(1.31%)
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
  358453
  397076
  400614
  493424
  493561
  506371
  529810
  530305
  535311
  549550
  563947
  579872
  587908
  598360
  617778
  620431
  639089
  639355
  640617
  646307
  648679
  654359
  656107
  656530
  660455
  660701
  662839
  668905
  675041
  675746
  686091
  693492
  695093
  695467
  699415
  701541
  707608
  707819
  715004
  717726
  717812
  720231
  720793
  721830
  721959
  722001
  723934
  724921
  726989
  728412
  730069
  730333
  731327
  731349
  731354
  731860
  732903
  740726
  741909
  742951
  744746
  745451
  745808
  745912
  747749
  750139
  750278
  750358
  753479
  756094
  756847
  757180
  758087
  758871
  759796
  760971
  761009
  761765
  762253
  764130
  765412
  765679
  765735
  767054
  767193
  768392
  768730
  769046
  769073
  774678
  775715
  777337
  778084
  778962
  780061
  780503
  780968
  784622
  789450
  790538
  791411
  791412
  792720
  794732
  794889
  795528
  795680
  796532
  797521
  799868
  800509
  801309
  803699
  805545
  807038
  809339
  810307
  812829
  814502
]
2.07 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "горячий анальный секс…"
]
2.02 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "горяч анал"
]
1.84 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.01%)
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.