Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.13 ms
(82.95%)
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
  96259
  398004
  415273
  416262
  422062
  423225
  433836
  443396
  444546
  447542
  447543
  447567
  448303
  448859
  449357
  454118
  454939
  459898
  462222
  462470
  464315
  467807
  468695
  470132
  470471
  471681
  473182
  475720
  477815
  483126
  489118
  490089
  493263
  500271
  506112
  508191
  509952
  510474
  510610
  511047
  518287
  520736
  522811
  523086
  523373
  526775
  529068
  545221
  547242
  548170
  549041
  554506
  554777
  558061
  558075
  560065
  561677
  563360
  564462
  565949
  566219
  567071
  568460
  569163
  569193
  576069
  576271
  576279
  576287
  576730
  578361
  578449
  587929
  591140
  592418
  597028
  597062
  597977
  598041
  598462
  598677
  598759
  598796
  600146
  603216
  606798
  619485
  639601
  649159
  652605
  652955
  653543
  654346
  654402
  669763
  673456
  677147
  680200
  681369
  683405
  683877
  684220
  684701
  696160
  714572
  719376
  720379
  722649
  725151
  730346
  741017
  741529
  742144
  742942
  746157
  747113
  753360
  775939
  805961
  811634
]
14.93 ms
(9.98%)
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
  454939
  447542
  447567
  467807
  470132
  416262
  444546
  447543
  448303
  449357
  468695
  423225
  462222
  522811
  489118
  506112
  493263
  523086
  741017
  652605
  673456
  683877
  598796
  639601
  775939
  746157
  811634
  725151
  742144
  747113
  753360
  462470
  547242
  680200
  597028
  606798
  415273
  473182
  483126
  520736
  526775
  653543
  529068
  652955
  696160
  719376
  654346
  722649
  600146
  805961
  741529
  730346
  742942
  96259
  714572
  398004
  443396
  433836
  422062
  454118
  477815
  448859
  475720
  459898
  464315
  470471
  490089
  510474
  510610
  523373
  509952
  511047
  500271
  508191
  518287
  471681
  554506
  554777
  563360
  564462
  576271
  545221
  548170
  567071
  568460
  576069
  561677
  566219
  569163
  569193
  576287
  654402
  669763
  684220
  684701
  677147
  681369
  649159
  683405
  720379
  549041
  558061
  558075
  560065
  565949
  576279
  576730
  578361
  578449
  587929
  598041
  598677
  592418
  597062
  597977
  598462
  598759
  591140
  603216
  619485
]
2.96 ms
(1.98%)
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
  96259
  398004
  415273
  416262
  422062
  423225
  433836
  443396
  444546
  447542
  447543
  447567
  448303
  448859
  449357
  454118
  454939
  459898
  462222
  462470
  464315
  467807
  468695
  470132
  470471
  471681
  473182
  475720
  477815
  483126
  489118
  490089
  493263
  500271
  506112
  508191
  509952
  510474
  510610
  511047
  518287
  520736
  522811
  523086
  523373
  526775
  529068
  545221
  547242
  548170
  549041
  554506
  554777
  558061
  558075
  560065
  561677
  563360
  564462
  565949
  566219
  567071
  568460
  569163
  569193
  576069
  576271
  576279
  576287
  576730
  578361
  578449
  587929
  591140
  592418
  597028
  597062
  597977
  598041
  598462
  598677
  598759
  598796
  600146
  603216
  606798
  619485
  639601
  649159
  652605
  652955
  653543
  654346
  654402
  669763
  673456
  677147
  680200
  681369
  683405
  683877
  684220
  684701
  696160
  714572
  719376
  720379
  722649
  725151
  730346
  741017
  741529
  742144
  742942
  746157
  747113
  753360
  775939
  805961
  811634
]
2.06 ms
(1.38%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.05 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen pigtails"
]
1.87 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen косичк"
]
1.64 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen косичк"
]

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.