Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.41 ms
(85.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
  13035
  14105
  21642
  80529
  143396
  169272
  213017
  302173
  388949
  391395
  393347
  398212
  403765
  408770
  427946
  444414
  444430
  446755
  457661
  479275
  484063
  487775
  489994
  517795
  527919
  530994
  533630
  534014
  553298
  567116
  584120
  586552
  589971
  591569
  595434
  596041
  596797
  599247
  603557
  605707
  614585
  615377
  618747
  619907
  620147
  626280
  634448
  634863
  641138
  641847
  642666
  644255
  644288
  664535
  667649
  673782
  680570
  687144
  693137
  693717
  700855
  705738
  708504
  710228
  713476
  716797
  733535
  741291
  745422
  749362
  750483
  752221
  754436
  755214
  755398
  758280
  759712
  759856
  760608
  760831
  773206
  776421
  779464
  786457
  788904
  789509
  789693
  792310
  793844
  795052
  795422
  797637
  798271
  798967
  800004
  801383
  801475
  802818
  803055
  806181
  807387
  807991
  808061
  808068
  809372
  811114
  811557
  812534
  812555
  812798
  815770
  817358
  818394
  818507
  826604
  827583
  828502
  828643
]
12.63 ms
(8.53%)
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
  664535
  667649
  680570
  687144
  693137
  700855
  710228
  716797
  553298
  567116
  620147
  641847
  644288
  586552
  595434
  599247
  589971
  591569
  605707
  634448
  776421
  793844
  797637
  800004
  802818
  807387
  788904
  789693
  798967
  801475
  809372
  745422
  750483
  758280
  792310
  806181
  808068
  759712
  755214
  760831
  773206
  741291
  754436
  760608
  603557
  614585
  626280
  634863
  641138
  705738
  779464
  807991
  812798
  391395
  446755
  398212
  444430
  388949
  408770
  457661
  479275
  444414
  527919
  489994
  487775
  517795
  169272
  393347
  80529
  403765
  826604
  815770
  827583
  818394
  534014
  642666
  713476
  143396
  818507
  828643
  828502
  533630
  708504
  618747
  803055
  811114
  759856
  213017
  427946
  584120
  13035
  596041
  795052
  798271
  808061
  811557
  14105
  801383
  772851
  302173
  21642
  817358
  530994
  484063
  673782
  693717
  615377
  596797
  644255
  619907
  786457
  789509
  795422
  752221
  812534
  812555
  749362
  768810
  733535
  755398
]
2.70 ms
(1.82%)
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
  13035
  14105
  21642
  80529
  143396
  169272
  213017
  302173
  388949
  391395
  393347
  398212
  403765
  408770
  427946
  444414
  444430
  446755
  457661
  479275
  484063
  487775
  489994
  517795
  527919
  530994
  533630
  534014
  553298
  567116
  584120
  586552
  589971
  591569
  595434
  596041
  596797
  599247
  603557
  605707
  614585
  615377
  618747
  619907
  620147
  626280
  634448
  634863
  641138
  641847
  642666
  644255
  644288
  664535
  667649
  673782
  680570
  687144
  693137
  693717
  700855
  705738
  708504
  710228
  713476
  716797
  733535
  741291
  745422
  749362
  750483
  752221
  754436
  755214
  755398
  758280
  759712
  759856
  760608
  760831
  773206
  776421
  779464
  786457
  788904
  789509
  789693
  792310
  793844
  795052
  795422
  797637
  798271
  798967
  800004
  801383
  801475
  802818
  803055
  806181
  807387
  807991
  808061
  808068
  809372
  811114
  811557
  812534
  812555
  812798
  815770
  817358
  818394
  818507
  826604
  827583
  828502
  828643
]
2.16 ms
(1.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "boobs ass"
]
1.46 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "boobs жоп"
]
1.27 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "boobs жоп"
]

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.