Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.44 ms
(89.03%)
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
  88373
  123010
  187567
  365885
  381878
  388100
  396910
  402735
  407374
  411332
  411360
  413475
  418833
  446501
  448040
  448052
  454027
  457338
  458057
  464464
  464544
  465731
  467035
  468147
  473947
  480242
  482292
  485086
  485749
  490919
  494260
  503314
  503561
  503569
  505132
  509702
  510225
  519208
  536489
  538957
  542148
  544824
  546594
  556847
  565846
  567909
  573216
  574990
  592451
  598811
  606496
  610847
  615391
  629009
  640531
  644669
  645959
  653567
  671746
  672138
  675923
  675971
  675986
  675995
  676402
  676508
  679120
  684551
  698972
  710096
  710407
  712466
  716177
  717669
  725359
  725399
  728191
  728194
  732799
  734345
  735418
  741780
  742579
  750809
  752161
  757206
  770105
  770836
  772959
  779175
  781759
  782760
  786254
  788811
  788818
  789521
  789844
  793877
  794795
  795483
  795497
  797195
  797264
  799793
  800073
  802109
  802121
  804004
  807401
  808679
  811486
  814245
  814488
  816068
  816562
  817320
  818403
  818848
  820871
  821228
]
16.59 ms
(6.98%)
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
  418833
  482292
  503561
  505132
  123010
  407374
  413475
  814488
  821228
  816562
  816068
  817320
  818403
  818848
  458057
  448040
  464544
  538957
  573216
  684551
  698972
  710096
  712466
  672138
  675986
  675995
  710407
  645959
  675923
  675971
  676402
  679120
  556847
  565846
  574990
  598811
  610847
  606496
  592451
  615391
  779175
  781759
  793877
  795483
  795497
  799793
  807401
  808679
  797195
  725359
  725399
  732799
  734345
  741780
  770836
  786254
  788811
  789844
  800073
  811486
  750809
  728191
  752161
  757206
  735418
  770105
  772959
  742579
  629009
  716177
  717669
  782760
  788818
  789521
  794795
  797264
  804004
  187567
  381878
  402735
  465731
  480242
  365885
  411360
  457338
  473947
  396910
  490919
  388100
  446501
  503314
  485086
  510225
  671746
  411332
  88373
  820871
  814245
  454027
  503569
  536489
  494260
  467035
  544824
  546594
  802109
  802121
  728194
  640531
  644669
  464464
  468147
  519208
  509702
  485749
  676508
  448052
  567909
  542148
  653567
]
2.52 ms
(1.06%)
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
  88373
  123010
  187567
  365885
  381878
  388100
  396910
  402735
  407374
  411332
  411360
  413475
  418833
  446501
  448040
  448052
  454027
  457338
  458057
  464464
  464544
  465731
  467035
  468147
  473947
  480242
  482292
  485086
  485749
  490919
  494260
  503314
  503561
  503569
  505132
  509702
  510225
  519208
  536489
  538957
  542148
  544824
  546594
  556847
  565846
  567909
  573216
  574990
  592451
  598811
  606496
  610847
  615391
  629009
  640531
  644669
  645959
  653567
  671746
  672138
  675923
  675971
  675986
  675995
  676402
  676508
  679120
  684551
  698972
  710096
  710407
  712466
  716177
  717669
  725359
  725399
  728191
  728194
  732799
  734345
  735418
  741780
  742579
  750809
  752161
  757206
  770105
  770836
  772959
  779175
  781759
  782760
  786254
  788811
  788818
  789521
  789844
  793877
  794795
  795483
  795497
  797195
  797264
  799793
  800073
  802109
  802121
  804004
  807401
  808679
  811486
  814245
  814488
  816068
  816562
  817320
  818403
  818848
  820871
  821228
]
1.88 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "facesitting stockings"
]
1.88 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.69%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фейсситтинг чулк нижн бел"
]
1.55 ms
(0.65%)
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.