Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.94 ms
(82.38%)
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
  7065
  197736
  399922
  404276
  404693
  405107
  416172
  419518
  420207
  421890
  422543
  423020
  432122
  439574
  439607
  439715
  443811
  446740
  448507
  451595
  451749
  452828
  453624
  461466
  463809
  463962
  466242
  467034
  469852
  470196
  473766
  482575
  486275
  491286
  499103
  506052
  510964
  523544
  529129
  530757
  536789
  539424
  539938
  543863
  545755
  550207
  556017
  556334
  568058
  574897
  576021
  576417
  576673
  584539
  587858
  597246
  598042
  603077
  603584
  604142
  604968
  605324
  609147
  614867
  616025
  617408
  618916
  619592
  621543
  624273
  626231
  626735
  627803
  628391
  628419
  632974
  633732
  636998
  640772
  640773
  644291
  644636
  649190
  671626
  672584
  677053
  677142
  677955
  678803
  680186
  683831
  685655
  687262
  689634
  696969
  708424
  714183
  714500
  717832
  720462
  720698
  720836
  721846
  724181
  724559
  729920
  745161
  748349
  750675
  789733
  795683
  807918
  807985
  811826
  814364
  818235
  818444
  819506
  825001
  827328
]
20.43 ms
(12.47%)
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
  677955
  687262
  568058
  587858
  603584
  621543
  597246
  617408
  604142
  640773
  644636
  795683
  807985
  729920
  632974
  714500
  473766
  419518
  404276
  443811
  448507
  486275
  499103
  451595
  584539
  818235
  819506
  671626
  678803
  748349
  724181
  627803
  463962
  422543
  721846
  556017
  598042
  461466
  399922
  405107
  7065
  683831
  619592
  467034
  439574
  439607
  404693
  420207
  469852
  510964
  539938
  539424
  529129
  574897
  543863
  689634
  636998
  603077
  463809
  491286
  523544
  439715
  825001
  482575
  720836
  750675
  470196
  576417
  680186
  717832
  685655
  609147
  633732
  724559
  745161
  466242
  550207
  677053
  452828
  530757
  536789
  677142
  614867
  628391
  628419
  640772
  616025
  818444
  827328
  708424
  696969
  649190
  720462
  604968
  644291
  618916
  624273
  626735
  789733
  807918
  453624
  423020
  720698
  605324
  714183
  626231
  545755
  421890
  197736
  446740
  506052
  576673
  811826
  416172
  432122
  814364
  451749
  576021
  556334
  672584
]
2.57 ms
(1.57%)
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
  7065
  197736
  399922
  404276
  404693
  405107
  416172
  419518
  420207
  421890
  422543
  423020
  432122
  439574
  439607
  439715
  443811
  446740
  448507
  451595
  451749
  452828
  453624
  461466
  463809
  463962
  466242
  467034
  469852
  470196
  473766
  482575
  486275
  491286
  499103
  506052
  510964
  523544
  529129
  530757
  536789
  539424
  539938
  543863
  545755
  550207
  556017
  556334
  568058
  574897
  576021
  576417
  576673
  584539
  587858
  597246
  598042
  603077
  603584
  604142
  604968
  605324
  609147
  614867
  616025
  617408
  618916
  619592
  621543
  624273
  626231
  626735
  627803
  628391
  628419
  632974
  633732
  636998
  640772
  640773
  644291
  644636
  649190
  671626
  672584
  677053
  677142
  677955
  678803
  680186
  683831
  685655
  687262
  689634
  696969
  708424
  714183
  714500
  717832
  720462
  720698
  720836
  721846
  724181
  724559
  729920
  745161
  748349
  750675
  789733
  795683
  807918
  807985
  811826
  814364
  818235
  818444
  819506
  825001
  827328
]
1.67 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal young tits"
]
1.56 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал young сиськ"
]
1.21 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал young сиськ"
]

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.