Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.56 ms
(84.02%)
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
  33401
  40835
  96342
  170942
  385373
  385884
  386545
  389198
  396578
  397648
  401379
  402518
  415872
  446340
  465474
  468368
  485164
  495871
  521118
  526453
  528875
  532512
  532674
  536718
  536725
  539570
  551016
  558440
  563463
  585807
  592766
  595975
  605022
  611530
  613079
  615716
  617800
  619393
  628332
  632663
  635202
  637092
  642412
  643331
  644575
  648906
  649166
  650012
  663526
  665004
  665204
  666728
  667484
  674116
  675008
  687192
  694476
  697466
  715551
  717651
  719783
  720464
  721054
  721407
  721564
  724536
  726154
  726193
  729918
  732476
  733577
  735732
  737171
  742364
  747605
  753281
  755318
  768944
  770464
  770904
  777004
  777008
  780625
  781781
  784347
  785673
  786759
  787641
  790815
  790963
  795711
  795719
  797383
  797385
  801279
  801757
  801829
  802184
  802375
  804647
  806103
  810252
  810551
  810709
  812078
  812385
  812759
  817365
  817854
  818419
  821241
  821506
  821699
  822878
  822988
  823305
  823421
  825899
  826232
  828869
]
13.76 ms
(9.36%)
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
  825899
  665204
  666728
  667484
  781781
  715551
  801757
  558440
  737171
  615716
  637092
  632663
  780625
  822988
  823305
  823421
  821241
  563463
  649166
  663526
  717651
  729918
  753281
  770464
  585807
  605022
  777004
  812759
  810252
  784347
  821699
  721054
  539570
  385373
  810551
  732476
  721407
  790815
  755318
  768944
  526453
  495871
  536718
  536725
  817854
  786759
  801829
  170942
  40835
  822878
  465474
  735732
  33401
  675008
  396578
  821506
  648906
  650012
  665004
  687192
  642412
  797383
  726193
  628332
  551016
  635202
  644575
  611530
  806103
  532674
  810709
  817365
  795719
  389198
  386545
  733577
  826232
  724536
  770904
  592766
  643331
  804647
  385884
  521118
  532512
  468368
  721564
  674116
  697466
  619393
  595975
  801279
  795711
  747605
  720464
  802184
  828869
  797385
  790963
  787641
  812385
  726154
  742364
  777008
  397648
  401379
  402518
  818419
  528875
  485164
  694476
  719783
  785673
  812078
  96342
  446340
  415872
  613079
  617800
  802375
]
2.80 ms
(1.90%)
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
  33401
  40835
  96342
  170942
  385373
  385884
  386545
  389198
  396578
  397648
  401379
  402518
  415872
  446340
  465474
  468368
  485164
  495871
  521118
  526453
  528875
  532512
  532674
  536718
  536725
  539570
  551016
  558440
  563463
  585807
  592766
  595975
  605022
  611530
  613079
  615716
  617800
  619393
  628332
  632663
  635202
  637092
  642412
  643331
  644575
  648906
  649166
  650012
  663526
  665004
  665204
  666728
  667484
  674116
  675008
  687192
  694476
  697466
  715551
  717651
  719783
  720464
  721054
  721407
  721564
  724536
  726154
  726193
  729918
  732476
  733577
  735732
  737171
  742364
  747605
  753281
  755318
  768944
  770464
  770904
  777004
  777008
  780625
  781781
  784347
  785673
  786759
  787641
  790815
  790963
  795711
  795719
  797383
  797385
  801279
  801757
  801829
  802184
  802375
  804647
  806103
  810252
  810551
  810709
  812078
  812385
  812759
  817365
  817854
  818419
  821241
  821506
  821699
  822878
  822988
  823305
  823421
  825899
  826232
  828869
]
2.41 ms
(1.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big black tits"
]
1.59 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие black сиськ"
]
1.54 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие black сиськ"
]

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.