Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.61 ms
(52.93%)
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
  61051
  290847
  315244
  384108
  386798
  388722
  388803
  391992
  392023
  398114
  402626
  403319
  408885
  408928
  410346
  410690
  411211
  413389
  415294
  415303
  415877
  415961
  416522
  416536
  416561
  416580
  416616
  416624
  416634
  416639
  416670
  416678
  416696
  416703
  416722
  416742
  418989
  430350
  441021
  441042
  449173
  449406
  451121
  459198
  467097
  467952
  468148
  468665
  468949
  471764
  473426
  476059
  476164
  483730
  483742
  485546
  486773
  487418
  490741
  493696
  494493
  497692
  498294
  498319
  500313
  506149
  509820
  513220
  513963
  515488
  522264
  529034
  531103
  534839
  536378
  536641
  544831
  545379
  545454
  547474
  547482
  548835
  550337
  558261
  561040
  573188
  585251
  587292
  599834
  602024
  605219
  609885
  619286
  619659
  625780
  630081
  635993
  636958
  669038
  669067
  671044
  671052
  695870
  708465
  718785
  720289
  722392
  723618
  730461
  747468
  750121
  752704
  752706
  760319
  761432
  770405
  796646
  798243
  798291
  811690
]
158.55 ms
(40.23%)
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
  61051
  290847
  315244
  384108
  386798
  388722
  388803
  391992
  392023
  398114
  402626
  403319
  408885
  408928
  410346
  410690
  411211
  413389
  415294
  415303
  415877
  415961
  416522
  416536
  416561
  416580
  416616
  416624
  416634
  416639
  416670
  416678
  416696
  416703
  416722
  416742
  418989
  430350
  441021
  441042
  449173
  449406
  451121
  459198
  467097
  467952
  468148
  468665
  468949
  471764
  473426
  476059
  476164
  483730
  483742
  485546
  486773
  487418
  490741
  493696
  494493
  497692
  498294
  498319
  500313
  506149
  509820
  513220
  513963
  515488
  522264
  529034
  531103
  534839
  536378
  536641
  544831
  545379
  545454
  547474
  547482
  548835
  550337
  558261
  561040
  573188
  585251
  587292
  599834
  602024
  605219
  609885
  619286
  619659
  625780
  630081
  635993
  636958
  669038
  669067
  671044
  671052
  695870
  708465
  718785
  720289
  722392
  723618
  730461
  747468
  750121
  752704
  752706
  760319
  761432
  770405
  796646
  798243
  798291
  811690
]
19.90 ms
(5.05%)
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
  386798
  408885
  416522
  416639
  416670
  473426
  486773
  471764
  573188
  811690
  416616
  441021
  506149
  315244
  416696
  515488
  384108
  413389
  391992
  459198
  587292
  545379
  544831
  547474
  669038
  671044
  695870
  561040
  605219
  752706
  416722
  402626
  416624
  513963
  599834
  550337
  669067
  415294
  467952
  671052
  415877
  761432
  290847
  410690
  494493
  534839
  392023
  485546
  513220
  730461
  798243
  760319
  398114
  416580
  416634
  449406
  451121
  468949
  547482
  796646
  61051
  467097
  441042
  408928
  500313
  483742
  619659
  493696
  487418
  619286
  750121
  498319
  388803
  483730
  585251
  416678
  410346
  403319
  416536
  411211
  536378
  718785
  602024
  798291
  635993
  476164
  636958
  415961
  416561
  416703
  558261
  509820
  609885
  723618
  708465
  722392
  388722
  430350
  770405
  415303
  468665
  449173
  630081
  490741
  625780
  720289
  418989
  531103
  498294
  545454
  747468
  522264
  416742
  468148
  476059
  536641
  548835
  752704
  497692
  529034
]
2.26 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo anal fuck"
]
1.68 ms
(0.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дилд анал секс"
]
1.53 ms
(0.39%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.