Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.38 ms
(85.74%)
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
  282649
  395101
  408470
  416832
  423178
  426803
  428388
  429460
  433067
  434801
  438710
  443489
  445977
  447867
  455594
  457326
  458856
  459389
  461472
  462168
  468959
  470731
  472323
  474999
  475376
  475615
  479401
  485483
  493248
  494991
  495324
  499441
  509077
  517027
  517028
  517167
  521425
  523242
  523965
  524624
  525360
  526129
  527250
  527341
  529217
  533705
  547884
  548732
  551164
  551167
  551565
  551575
  552546
  553677
  558363
  558736
  559006
  561201
  564082
  565368
  568113
  569121
  574442
  576505
  576849
  578840
  582036
  585537
  589331
  590689
  592125
  594820
  594979
  595567
  598784
  610748
  617486
  617543
  622077
  629594
  638187
  646676
  649356
  649860
  649885
  650928
  658881
  661654
  662097
  664450
  670263
  683914
  686133
  695667
  701520
  709660
  716121
  716600
  721875
  727367
  732084
  735429
  749432
  758674
  761228
  764879
  770578
  772483
  786467
  787916
  789799
  792790
  792832
  793443
  795504
  802243
  807301
  813139
  814258
  818937
]
17.62 ms
(8.87%)
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
  818937
  638187
  646676
  649356
  786467
  792790
  552546
  553677
  662097
  622077
  629594
  727367
  795504
  434801
  523242
  569121
  564082
  590689
  594979
  658881
  664450
  585537
  592125
  792832
  521425
  764879
  457326
  670263
  433067
  661654
  561201
  495324
  576849
  595567
  429460
  428388
  468959
  526129
  525360
  551565
  617543
  789799
  455594
  479401
  610748
  787916
  582036
  578840
  695667
  716600
  749432
  735429
  686133
  527250
  443489
  617486
  472323
  509077
  558363
  565368
  548732
  438710
  568113
  807301
  551575
  802243
  709660
  282649
  716121
  721875
  458856
  485483
  533705
  576505
  408470
  732084
  683914
  589331
  793443
  761228
  770578
  529217
  474999
  423178
  459389
  523965
  517027
  517028
  517167
  524624
  649860
  445977
  594820
  494991
  558736
  701520
  547884
  574442
  598784
  493248
  527341
  447867
  758674
  475376
  426803
  475615
  650928
  649885
  813139
  772483
  461472
  462168
  551167
  470731
  499441
  416832
  551164
  559006
  395101
  814258
]
3.33 ms
(1.68%)
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
  282649
  395101
  408470
  416832
  423178
  426803
  428388
  429460
  433067
  434801
  438710
  443489
  445977
  447867
  455594
  457326
  458856
  459389
  461472
  462168
  468959
  470731
  472323
  474999
  475376
  475615
  479401
  485483
  493248
  494991
  495324
  499441
  509077
  517027
  517028
  517167
  521425
  523242
  523965
  524624
  525360
  526129
  527250
  527341
  529217
  533705
  547884
  548732
  551164
  551167
  551565
  551575
  552546
  553677
  558363
  558736
  559006
  561201
  564082
  565368
  568113
  569121
  574442
  576505
  576849
  578840
  582036
  585537
  589331
  590689
  592125
  594820
  594979
  595567
  598784
  610748
  617486
  617543
  622077
  629594
  638187
  646676
  649356
  649860
  649885
  650928
  658881
  661654
  662097
  664450
  670263
  683914
  686133
  695667
  701520
  709660
  716121
  716600
  721875
  727367
  732084
  735429
  749432
  758674
  761228
  764879
  770578
  772483
  786467
  787916
  789799
  792790
  792832
  793443
  795504
  802243
  807301
  813139
  814258
  818937
]
2.38 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в туалете молоденькая…"
]
1.80 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "туалет молодая девушк"
]
1.71 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.75%)
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.