Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
216.15 ms
(60.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "красивая жен"
]
121.77 ms
(34.01%)
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
  91603
  365945
  382520
  398576
  398660
  402973
  403660
  403938
  412222
  421484
  429471
  434541
  437676
  458133
  458782
  463379
  464046
  466705
  472990
  474911
  487824
  490479
  504538
  508946
  537045
  537486
  540730
  541847
  558268
  558948
  559421
  565227
  570121
  586985
  601398
  621562
  621959
  629124
  644734
  648659
  648754
  653883
  660461
  668062
  669256
  669259
  671484
  673017
  676767
  679512
  681756
  689167
  689458
  693905
  694388
  705009
  707551
  709862
  710333
  718908
  719954
  720265
  724096
  725088
  730699
  730730
  731043
  734130
  735186
  735187
  737252
  739028
  740664
  744027
  744751
  746934
  750134
  752013
  753529
  754651
  754879
  755602
  757040
  757940
  759029
  760285
  761336
  761770
  768522
  770030
  775677
  778086
  778647
  779846
  780225
  781007
  781120
  786136
  787648
  787653
  787657
  787880
  788467
  789263
  790236
  790498
  791622
  792455
  793647
  795293
  797290
  797575
  801096
  802373
  803734
  804075
  806537
  806599
  810362
  811543
]
12.58 ms
(3.51%)
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
  797575
  810362
  91603
  382520
  565227
  779846
  778086
  753529
  775677
  778647
  403938
  421484
  365945
  490479
  434541
  761770
  734130
  754879
  558268
  689167
  676767
  802373
  737252
  739028
  746934
  720265
  789263
  797290
  472990
  761336
  709862
  648754
  601398
  757940
  787648
  787653
  788467
  724096
  740664
  437676
  537045
  570121
  586985
  757040
  768522
  787880
  398660
  466705
  412222
  463379
  487824
  671484
  793647
  801096
  754651
  559421
  673017
  660461
  653883
  669256
  558948
  780225
  787657
  750134
  806537
  811543
  752013
  770030
  730730
  731043
  760285
  735186
  781007
  403660
  707551
  795293
  458133
  398576
  464046
  541847
  790498
  803734
  402973
  474911
  508946
  429471
  458782
  504538
  537486
  540730
  648659
  679512
  693905
  694388
  718908
  668062
  681756
  689458
  705009
  710333
  669259
  719954
  621562
  621959
  629124
  644734
  792455
  804075
  781120
  786136
  790236
  791622
  806599
  725088
  730699
  735187
  744027
  744751
  755602
  759029
]
2.47 ms
(0.69%)
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
  91603
  365945
  382520
  398576
  398660
  402973
  403660
  403938
  412222
  421484
  429471
  434541
  437676
  458133
  458782
  463379
  464046
  466705
  472990
  474911
  487824
  490479
  504538
  508946
  537045
  537486
  540730
  541847
  558268
  558948
  559421
  565227
  570121
  586985
  601398
  621562
  621959
  629124
  644734
  648659
  648754
  653883
  660461
  668062
  669256
  669259
  671484
  673017
  676767
  679512
  681756
  689167
  689458
  693905
  694388
  705009
  707551
  709862
  710333
  718908
  719954
  720265
  724096
  725088
  730699
  730730
  731043
  734130
  735186
  735187
  737252
  739028
  740664
  744027
  744751
  746934
  750134
  752013
  753529
  754651
  754879
  755602
  757040
  757940
  759029
  760285
  761336
  761770
  768522
  770030
  775677
  778086
  778647
  779846
  780225
  781007
  781120
  786136
  787648
  787653
  787657
  787880
  788467
  789263
  790236
  790498
  791622
  792455
  793647
  795293
  797290
  797575
  801096
  802373
  803734
  804075
  806537
  806599
  810362
  811543
]
1.91 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "красотка измена"
]
1.61 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая жен"
]
1.60 ms
(0.45%)
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.