Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.24 ms
(83.18%)
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
  145053
  181096
  185332
  190876
  212138
  229566
  366448
  382104
  382755
  383341
  386147
  389877
  395504
  395603
  397046
  397255
  401303
  403384
  404422
  405125
  405485
  408694
  413544
  415372
  416129
  416382
  418465
  425195
  429471
  430247
  433635
  444735
  445846
  446690
  450764
  455329
  455928
  457102
  457594
  457739
  459472
  460936
  465157
  465595
  467216
  469897
  475677
  478072
  479722
  481997
  486008
  487268
  487871
  489403
  494895
  500700
  509540
  510904
  512904
  513921
  521150
  523442
  524218
  524257
  537583
  537740
  544967
  551290
  557921
  559708
  559968
  561064
  565066
  581498
  581664
  583674
  587962
  593085
  597044
  598274
  600311
  605963
  610365
  614789
  614790
  621682
  625881
  629874
  642259
  650204
  673746
  674374
  684150
  693293
  698580
  734806
  735991
  738148
  743185
  743254
  754974
  757526
  767560
  769999
  790675
  795159
  801243
  805516
  810655
  810712
  811949
  815356
  815822
  816054
  817134
  819118
  819988
  820994
  821077
  824948
]
14.45 ms
(10.08%)
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
  457102
  459472
  509540
  383341
  185332
  145053
  430247
  487268
  487871
  494895
  465157
  557921
  559708
  460936
  181096
  408694
  489403
  212138
  395603
  444735
  429471
  559968
  551290
  587962
  642259
  600311
  610365
  593085
  605963
  614789
  614790
  810712
  397255
  415372
  395504
  405125
  446690
  229566
  418465
  512904
  386147
  815822
  819988
  824948
  820994
  524218
  537740
  544967
  811949
  754974
  382755
  366448
  405485
  413544
  455329
  475677
  565066
  581664
  416382
  521150
  523442
  524257
  397046
  445846
  478072
  450764
  465595
  621682
  597044
  455928
  467216
  481997
  190876
  403384
  401303
  416129
  425195
  469897
  510904
  500700
  382104
  389877
  816054
  817134
  821077
  815356
  819118
  537583
  581498
  583674
  561064
  684150
  698580
  650204
  674374
  693293
  673746
  598274
  625881
  801243
  735991
  743185
  790675
  795159
  734806
  769999
  738148
  743254
  757526
  767560
  629874
  805516
  810655
  404422
  433635
  457594
  486008
  457739
  479722
  513921
]
2.87 ms
(2.00%)
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
  145053
  181096
  185332
  190876
  212138
  229566
  366448
  382104
  382755
  383341
  386147
  389877
  395504
  395603
  397046
  397255
  401303
  403384
  404422
  405125
  405485
  408694
  413544
  415372
  416129
  416382
  418465
  425195
  429471
  430247
  433635
  444735
  445846
  446690
  450764
  455329
  455928
  457102
  457594
  457739
  459472
  460936
  465157
  465595
  467216
  469897
  475677
  478072
  479722
  481997
  486008
  487268
  487871
  489403
  494895
  500700
  509540
  510904
  512904
  513921
  521150
  523442
  524218
  524257
  537583
  537740
  544967
  551290
  557921
  559708
  559968
  561064
  565066
  581498
  581664
  583674
  587962
  593085
  597044
  598274
  600311
  605963
  610365
  614789
  614790
  621682
  625881
  629874
  642259
  650204
  673746
  674374
  684150
  693293
  698580
  734806
  735991
  738148
  743185
  743254
  754974
  757526
  767560
  769999
  790675
  795159
  801243
  805516
  810655
  810712
  811949
  815356
  815822
  816054
  817134
  819118
  819988
  820994
  821077
  824948
]
1.91 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy beautiful"
]
1.85 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая красивая"
]
1.43 ms
(1.00%)
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.