Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.88 ms
(84.16%)
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
  232085
  459918
  472812
  476564
  512424
  522772
  530415
  530658
  535601
  536066
  536068
  540054
  541565
  547120
  547126
  553610
  553932
  554705
  554734
  557461
  562936
  564941
  567575
  570931
  577032
  580998
  581180
  592159
  599763
  606052
  610023
  615616
  624527
  627655
  635357
  638962
  644886
  652563
  655542
  659956
  661332
  661576
  664655
  666991
  669930
  676760
  677916
  680741
  692683
  692713
  692721
  692763
  696432
  698802
  700177
  706642
  707562
  712660
  713951
  714040
  715963
  716137
  717600
  720729
  726886
  731002
  734030
  736961
  738427
  738950
  740747
  742668
  742767
  745656
  746098
  746840
  749604
  760932
  765796
  767495
  768048
  768063
  768456
  768591
  768598
  769508
  778228
  778934
  779605
  779722
  779767
  779797
  779829
  780172
  780827
  783525
  785416
  786200
  787021
  787145
  787485
  788988
  789047
  790433
  791308
  791309
  791317
  795427
  797920
  798709
  804471
  805072
  808304
  808710
  813298
  819314
  823775
  823841
  824888
  827557
]
14.92 ms
(9.52%)
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
  652563
  715963
  808304
  779605
  547126
  779829
  547120
  827557
  554734
  742668
  580998
  644886
  535601
  530658
  577032
  661332
  720729
  624527
  638962
  795427
  778228
  790433
  768063
  745656
  736961
  749604
  780172
  785416
  789047
  696432
  692713
  731002
  680741
  714040
  768591
  562936
  767495
  530415
  554705
  564941
  698802
  692683
  635357
  791308
  786200
  791309
  740747
  768048
  700177
  768598
  706642
  476564
  459918
  615616
  819314
  823841
  522772
  557461
  659956
  661576
  676760
  779722
  768456
  813298
  783525
  791317
  734030
  581180
  787145
  797920
  512424
  655542
  692763
  712660
  692721
  666991
  669930
  707562
  716137
  592159
  779767
  805072
  808710
  738427
  769508
  742767
  787021
  788988
  232085
  824888
  536068
  540054
  627655
  606052
  746098
  567575
  553932
  570931
  677916
  599763
  610023
  778934
  780827
  760932
  779797
  798709
  536066
  553610
  746840
  823775
  541565
  664655
  713951
  787485
  738950
  765796
  717600
  472812
  804471
  726886
]
2.85 ms
(1.82%)
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
  232085
  459918
  472812
  476564
  512424
  522772
  530415
  530658
  535601
  536066
  536068
  540054
  541565
  547120
  547126
  553610
  553932
  554705
  554734
  557461
  562936
  564941
  567575
  570931
  577032
  580998
  581180
  592159
  599763
  606052
  610023
  615616
  624527
  627655
  635357
  638962
  644886
  652563
  655542
  659956
  661332
  661576
  664655
  666991
  669930
  676760
  677916
  680741
  692683
  692713
  692721
  692763
  696432
  698802
  700177
  706642
  707562
  712660
  713951
  714040
  715963
  716137
  717600
  720729
  726886
  731002
  734030
  736961
  738427
  738950
  740747
  742668
  742767
  745656
  746098
  746840
  749604
  760932
  765796
  767495
  768048
  768063
  768456
  768591
  768598
  769508
  778228
  778934
  779605
  779722
  779767
  779797
  779829
  780172
  780827
  783525
  785416
  786200
  787021
  787145
  787485
  788988
  789047
  790433
  791308
  791309
  791317
  795427
  797920
  798709
  804471
  805072
  808304
  808710
  813298
  819314
  823775
  823841
  824888
  827557
]
2.02 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife public"
]
1.84 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен на улиц"
]
1.42 ms
(0.91%)
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.