Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
180.01 ms
(82.51%)
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
  4131
  44968
  142993
  387848
  389197
  395596
  395682
  395701
  395863
  396646
  397766
  401140
  404953
  405029
  405468
  407324
  407444
  413594
  419873
  419885
  420276
  425886
  433085
  433156
  433166
  433297
  433497
  447105
  447858
  480747
  503044
  505041
  510627
  541252
  541781
  554966
  555782
  562223
  563537
  568423
  569070
  585971
  592307
  596057
  600192
  600320
  604567
  610183
  610668
  615788
  620130
  629969
  632038
  633145
  633147
  637072
  644266
  648206
  652284
  653900
  655861
  679087
  681581
  691820
  692335
  692786
  694374
  694484
  695282
  698457
  699516
  705879
  706593
  706946
  716501
  717798
  717835
  717940
  720188
  720197
  720211
  721194
  721445
  728145
  728235
  732055
  732070
  732071
  735515
  735920
  737153
  739077
  741288
  742933
  743375
  744647
  752935
  766843
  770307
  781447
  789959
  789986
  792552
  797519
  797562
  801484
  805069
  807497
  810770
  811870
  814210
  814568
  815190
  815847
  816259
  816594
  816968
  818387
  818460
  821409
]
26.49 ms
(12.14%)
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
  405468
  395863
  739077
  741288
  728235
  401140
  405029
  814210
  652284
  585971
  737153
  732071
  4131
  818460
  816259
  692335
  694484
  699516
  716501
  691820
  706593
  694374
  554966
  766843
  633145
  610668
  396646
  814568
  562223
  653900
  629969
  728145
  735515
  797519
  142993
  706946
  717940
  698457
  604567
  600192
  592307
  811870
  732055
  717798
  397766
  419873
  404953
  541781
  801484
  395596
  816968
  818387
  815190
  816594
  655861
  679087
  720211
  692786
  600320
  610183
  637072
  805069
  752935
  770307
  732070
  743375
  744647
  633147
  717835
  720188
  781447
  789959
  797562
  407324
  447105
  389197
  44968
  387848
  821409
  815847
  555782
  681581
  695282
  705879
  721445
  644266
  792552
  735920
  720197
  596057
  563537
  505041
  420276
  721194
  541252
  503044
  433297
  742933
  425886
  615788
  447858
  395682
  510627
  568423
  395701
  433497
  648206
  810770
  407444
  419885
  569070
  480747
  632038
  620130
  433156
  433166
  789986
  807497
  433085
  413594
]
3.55 ms
(1.62%)
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
  4131
  44968
  142993
  387848
  389197
  395596
  395682
  395701
  395863
  396646
  397766
  401140
  404953
  405029
  405468
  407324
  407444
  413594
  419873
  419885
  420276
  425886
  433085
  433156
  433166
  433297
  433497
  447105
  447858
  480747
  503044
  505041
  510627
  541252
  541781
  554966
  555782
  562223
  563537
  568423
  569070
  585971
  592307
  596057
  600192
  600320
  604567
  610183
  610668
  615788
  620130
  629969
  632038
  633145
  633147
  637072
  644266
  648206
  652284
  653900
  655861
  679087
  681581
  691820
  692335
  692786
  694374
  694484
  695282
  698457
  699516
  705879
  706593
  706946
  716501
  717798
  717835
  717940
  720188
  720197
  720211
  721194
  721445
  728145
  728235
  732055
  732070
  732071
  735515
  735920
  737153
  739077
  741288
  742933
  743375
  744647
  752935
  766843
  770307
  781447
  789959
  789986
  792552
  797519
  797562
  801484
  805069
  807497
  810770
  811870
  814210
  814568
  815190
  815847
  816259
  816594
  816968
  818387
  818460
  821409
]
2.22 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.06 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal ffm"
]
1.95 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал жмж секс втро"
]
1.89 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.