Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.06 ms
(87.86%)
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
  382696
  384233
  393751
  393793
  400440
  400454
  400482
  401260
  403906
  416965
  418421
  418484
  419386
  424741
  429124
  431969
  432157
  443362
  443372
  452441
  462749
  463168
  463170
  464940
  465823
  466851
  470847
  472912
  475166
  484127
  485902
  488004
  491796
  503935
  508076
  515189
  524012
  526033
  527513
  540677
  540912
  541912
  547276
  549940
  550620
  560439
  564440
  566505
  566521
  566524
  569665
  569672
  569673
  569675
  569689
  569959
  570054
  570075
  571210
  574580
  575151
  581628
  581696
  603304
  609144
  612861
  614386
  617722
  624858
  628300
  641439
  647937
  653523
  655314
  657034
  659608
  663502
  665295
  665502
  665518
  677044
  680156
  683515
  684205
  684943
  689272
  689370
  693852
  700544
  700547
  701297
  712925
  715560
  716391
  718627
  722654
  734715
  736414
  738256
  744298
  755735
  759662
  770026
  770824
  783906
  788649
  789304
  803083
  807497
  811998
  815878
  817678
  818316
  818351
  818656
  819191
  823152
  823688
  823700
  828053
]
13.08 ms
(6.92%)
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
  722654
  689370
  789304
  803083
  759662
  744298
  609144
  419386
  443362
  443372
  416965
  431969
  429124
  491796
  569673
  570054
  569675
  571210
  581696
  677044
  700547
  569665
  570075
  612861
  463170
  400454
  463168
  527513
  524012
  564440
  569959
  736414
  403906
  823700
  828053
  653523
  617722
  515189
  665518
  680156
  569672
  400482
  418484
  560439
  569689
  807497
  770824
  484127
  540912
  393751
  647937
  566524
  663502
  382696
  819191
  701297
  716391
  684943
  718627
  628300
  614386
  734715
  755735
  788649
  770026
  700544
  783906
  424741
  452441
  540677
  526033
  464940
  566505
  566521
  574580
  665295
  689272
  603304
  624858
  811998
  400440
  401260
  466851
  508076
  485902
  488004
  541912
  684205
  641439
  738256
  393793
  818351
  384233
  432157
  462749
  503935
  575151
  465823
  418421
  470847
  475166
  472912
  823152
  823688
  815878
  817678
  818316
  818656
  547276
  550620
  581628
  549940
  655314
  665502
  683515
  693852
  712925
  715560
  657034
  659608
]
2.97 ms
(1.57%)
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
  382696
  384233
  393751
  393793
  400440
  400454
  400482
  401260
  403906
  416965
  418421
  418484
  419386
  424741
  429124
  431969
  432157
  443362
  443372
  452441
  462749
  463168
  463170
  464940
  465823
  466851
  470847
  472912
  475166
  484127
  485902
  488004
  491796
  503935
  508076
  515189
  524012
  526033
  527513
  540677
  540912
  541912
  547276
  549940
  550620
  560439
  564440
  566505
  566521
  566524
  569665
  569672
  569673
  569675
  569689
  569959
  570054
  570075
  571210
  574580
  575151
  581628
  581696
  603304
  609144
  612861
  614386
  617722
  624858
  628300
  641439
  647937
  653523
  655314
  657034
  659608
  663502
  665295
  665502
  665518
  677044
  680156
  683515
  684205
  684943
  689272
  689370
  693852
  700544
  700547
  701297
  712925
  715560
  716391
  718627
  722654
  734715
  736414
  738256
  744298
  755735
  759662
  770026
  770824
  783906
  788649
  789304
  803083
  807497
  811998
  815878
  817678
  818316
  818351
  818656
  819191
  823152
  823688
  823700
  828053
]
2.03 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young sex 2022"
]
1.78 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young секс"
]
1.75 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young секс"
]
1.33 ms
(0.71%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.