Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.97 ms
(81.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
  4324
  187818
  270104
  388847
  394738
  396345
  398964
  399422
  401062
  401167
  401202
  407856
  407903
  411044
  411351
  411884
  411986
  413097
  415548
  417232
  418880
  418996
  419622
  420293
  420534
  421048
  421838
  422158
  424871
  425979
  426701
  427237
  428697
  428709
  430707
  433965
  434885
  437333
  437352
  439661
  439731
  439824
  440598
  443142
  444139
  444620
  446522
  447956
  451221
  451787
  452362
  453091
  453548
  454421
  454429
  454444
  454471
  454968
  455749
  456383
  458728
  459403
  459956
  461136
  462095
  462876
  463978
  464136
  464336
  464858
  465383
  465453
  467106
  468366
  468941
  475039
  483375
  483385
  489288
  490455
  491781
  494282
  495264
  500013
  503400
  506274
  507090
  509941
  510839
  518141
  518780
  519133
  519342
  519579
  526737
  526966
  550234
  550641
  554451
  561082
  574430
  575272
  597134
  631615
  651102
  664800
  664820
  665204
  665292
  666095
  667286
  680824
  705781
  712672
  781764
  781853
  781869
  781998
  793591
  814294
]
19.20 ms
(12.02%)
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
  456383
  464858
  407903
  519133
  401167
  463978
  454429
  489288
  550234
  453091
  509941
  464336
  597134
  439824
  411986
  413097
  417232
  443142
  418996
  475039
  465383
  462095
  461136
  462876
  4324
  427237
  428697
  490455
  398964
  451221
  465453
  187818
  464136
  665204
  433965
  574430
  394738
  399422
  554451
  651102
  781764
  781869
  793591
  500013
  454444
  455749
  468941
  451787
  680824
  415548
  411044
  667286
  705781
  712672
  561082
  458728
  510839
  503400
  575272
  440598
  526966
  388847
  420293
  447956
  781998
  444620
  665292
  426701
  550641
  428709
  437352
  468366
  781853
  434885
  452362
  454471
  446522
  444139
  270104
  420534
  437333
  526737
  483385
  518780
  439661
  439731
  491781
  459403
  467106
  424871
  422158
  421838
  407856
  421048
  483375
  430707
  425979
  453548
  495264
  459956
  506274
  519342
  418880
  454968
  666095
  454421
  396345
  814294
  664820
  664800
  631615
  401062
  519579
  507090
  494282
  419622
  518141
  401202
  411351
  411884
]
2.75 ms
(1.72%)
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
  4324
  187818
  270104
  388847
  394738
  396345
  398964
  399422
  401062
  401167
  401202
  407856
  407903
  411044
  411351
  411884
  411986
  413097
  415548
  417232
  418880
  418996
  419622
  420293
  420534
  421048
  421838
  422158
  424871
  425979
  426701
  427237
  428697
  428709
  430707
  433965
  434885
  437333
  437352
  439661
  439731
  439824
  440598
  443142
  444139
  444620
  446522
  447956
  451221
  451787
  452362
  453091
  453548
  454421
  454429
  454444
  454471
  454968
  455749
  456383
  458728
  459403
  459956
  461136
  462095
  462876
  463978
  464136
  464336
  464858
  465383
  465453
  467106
  468366
  468941
  475039
  483375
  483385
  489288
  490455
  491781
  494282
  495264
  500013
  503400
  506274
  507090
  509941
  510839
  518141
  518780
  519133
  519342
  519579
  526737
  526966
  550234
  550641
  554451
  561082
  574430
  575272
  597134
  631615
  651102
  664800
  664820
  665204
  665292
  666095
  667286
  680824
  705781
  712672
  781764
  781853
  781869
  781998
  793591
  814294
]
2.25 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ебут в полненькую жоп…"
]
1.87 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс в полная жоп"
]
1.82 ms
(1.14%)
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.