Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.01 ms
(82.71%)
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
  410311
  414360
  414368
  427983
  429763
  429804
  443231
  443429
  444820
  451265
  452269
  452606
  454645
  464445
  468490
  469619
  474240
  477074
  478052
  478488
  482780
  496724
  498470
  503406
  524550
  530384
  530488
  530792
  530796
  530850
  530912
  531091
  531097
  531103
  531144
  531196
  531657
  532954
  533018
  533576
  534032
  534151
  534647
  534992
  535505
  536847
  537672
  537773
  537776
  540348
  540508
  543867
  556428
  580122
  587418
  591357
  593167
  596125
  597242
  597264
  597268
  597912
  599893
  600269
  601536
  601593
  601600
  604519
  615832
  620208
  620316
  621675
  623203
  627809
  628116
  629560
  629967
  630544
  630857
  631984
  632562
  633758
  635171
  635834
  636280
  637121
  637501
  640749
  642041
  642043
  645322
  646846
  647626
  647665
  648814
  648850
  649137
  650379
  650827
  651062
  651068
  667760
  668385
  674917
  674945
  676073
  676095
  678128
  679770
  679772
  680202
  704715
  710425
  714612
  716745
  716778
  716887
  720394
  725640
  727751
]
19.37 ms
(11.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
  674945
  597264
  597268
  629560
  587418
  630544
  601536
  469619
  531097
  537773
  414368
  429763
  444820
  530384
  530796
  532954
  537672
  531144
  678128
  627809
  637121
  601600
  642041
  633758
  642043
  716887
  410311
  443231
  414360
  452269
  478488
  454645
  498470
  524550
  530792
  534151
  650827
  714612
  668385
  580122
  604519
  621675
  727751
  635834
  637501
  477074
  496724
  503406
  631984
  623203
  629967
  427983
  429804
  452606
  534032
  531103
  531091
  536847
  647626
  597912
  593167
  530912
  635171
  464445
  628116
  468490
  530850
  531657
  540508
  543867
  556428
  645322
  651062
  676073
  680202
  647665
  649137
  676095
  704715
  716745
  646846
  651068
  716778
  720394
  599893
  640749
  591357
  597242
  620208
  630857
  596125
  615832
  636280
  600269
  601593
  620316
  632562
  725640
  710425
  535505
  443429
  451265
  478052
  482780
  533018
  534647
  534992
  537776
  530488
  531196
  533576
  540348
  474240
  648814
  667760
  674917
  679772
  648850
  650379
  679770
]
2.77 ms
(1.64%)
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
  410311
  414360
  414368
  427983
  429763
  429804
  443231
  443429
  444820
  451265
  452269
  452606
  454645
  464445
  468490
  469619
  474240
  477074
  478052
  478488
  482780
  496724
  498470
  503406
  524550
  530384
  530488
  530792
  530796
  530850
  530912
  531091
  531097
  531103
  531144
  531196
  531657
  532954
  533018
  533576
  534032
  534151
  534647
  534992
  535505
  536847
  537672
  537773
  537776
  540348
  540508
  543867
  556428
  580122
  587418
  591357
  593167
  596125
  597242
  597264
  597268
  597912
  599893
  600269
  601536
  601593
  601600
  604519
  615832
  620208
  620316
  621675
  623203
  627809
  628116
  629560
  629967
  630544
  630857
  631984
  632562
  633758
  635171
  635834
  636280
  637121
  637501
  640749
  642041
  642043
  645322
  646846
  647626
  647665
  648814
  648850
  649137
  650379
  650827
  651062
  651068
  667760
  668385
  674917
  674945
  676073
  676095
  678128
  679770
  679772
  680202
  704715
  710425
  714612
  716745
  716778
  716887
  720394
  725640
  727751
]
1.96 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "interracial anal casting"
]
1.69 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "межрасов анал кастинг"
]
1.56 ms
(0.92%)
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.