Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.92 ms
(80.58%)
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
  4073
  45357
  74811
  79742
  81810
  88274
  96623
  102892
  142253
  145053
  249009
  314894
  365939
  384779
  386636
  387696
  392480
  395276
  401630
  401849
  401969
  404237
  406489
  413007
  413968
  415737
  416420
  418839
  421168
  421672
  422019
  422487
  422809
  424020
  424026
  424172
  427797
  430607
  431161
  433917
  433983
  436608
  437528
  437963
  442344
  443245
  445581
  446497
  447139
  447515
  447738
  449586
  450047
  452274
  452600
  452842
  453031
  455547
  456621
  457412
  457503
  457639
  457671
  458368
  458932
  460087
  460179
  460936
  461085
  461522
  463530
  463793
  464106
  464490
  466576
  470665
  471766
  472399
  472622
  475467
  476589
  480238
  482612
  485067
  491516
  497714
  499006
  508625
  510646
  513161
  515795
  521706
  522006
  523304
  523853
  529382
  529662
  532493
  565564
  571793
  572563
  572566
  585118
  595754
  603253
  603525
  608034
  620837
  628623
  629117
  640952
  669914
  670578
  691303
  696148
  754447
  779953
  798611
  805150
  806551
]
19.87 ms
(12.72%)
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
  424026
  88274
  96623
  422809
  314894
  365939
  384779
  401849
  452842
  457503
  457412
  406489
  460087
  466576
  523853
  510646
  499006
  508625
  565564
  571793
  603253
  445581
  447515
  460179
  395276
  437963
  595754
  74811
  81810
  102892
  145053
  392480
  387696
  401969
  401630
  427797
  437528
  442344
  421168
  413007
  431161
  450047
  463793
  447139
  456621
  457639
  458932
  482612
  457671
  529382
  529662
  515795
  461522
  691303
  669914
  670578
  696148
  572563
  572566
  628623
  640952
  608034
  779953
  798611
  754447
  805150
  806551
  603525
  620837
  629117
  45357
  386636
  404237
  452600
  4073
  460936
  79742
  422487
  424020
  424172
  455547
  461085
  464490
  476589
  142253
  249009
  433983
  470665
  430607
  433917
  532493
  497714
  522006
  485067
  513161
  523304
  413968
  416420
  443245
  421672
  418839
  422019
  415737
  436608
  585118
  446497
  453031
  472622
  447738
  449586
  452274
  458368
  463530
  472399
  464106
  471766
  480238
  521706
  475467
  491516
]
3.63 ms
(2.32%)
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
  4073
  45357
  74811
  79742
  81810
  88274
  96623
  102892
  142253
  145053
  249009
  314894
  365939
  384779
  386636
  387696
  392480
  395276
  401630
  401849
  401969
  404237
  406489
  413007
  413968
  415737
  416420
  418839
  421168
  421672
  422019
  422487
  422809
  424020
  424026
  424172
  427797
  430607
  431161
  433917
  433983
  436608
  437528
  437963
  442344
  443245
  445581
  446497
  447139
  447515
  447738
  449586
  450047
  452274
  452600
  452842
  453031
  455547
  456621
  457412
  457503
  457639
  457671
  458368
  458932
  460087
  460179
  460936
  461085
  461522
  463530
  463793
  464106
  464490
  466576
  470665
  471766
  472399
  472622
  475467
  476589
  480238
  482612
  485067
  491516
  497714
  499006
  508625
  510646
  513161
  515795
  521706
  522006
  523304
  523853
  529382
  529662
  532493
  565564
  571793
  572563
  572566
  585118
  595754
  603253
  603525
  608034
  620837
  628623
  629117
  640952
  669914
  670578
  691303
  696148
  754447
  779953
  798611
  805150
  806551
]
1.88 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "голые красотки"
]
1.74 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "голые красивая"
]
1.51 ms
(0.97%)
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.