Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.75 ms
(52.55%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
163.61 ms
(41.38%)
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
  3671
  124144
  159305
  235010
  381946
  384144
  387524
  389431
  390568
  391147
  400474
  400832
  409196
  411036
  411368
  411813
  413731
  417333
  423929
  424410
  424448
  432625
  432700
  432759
  440076
  440963
  441921
  442121
  444502
  446536
  452145
  452308
  452637
  452963
  452968
  453471
  454163
  455080
  455407
  458829
  458930
  459643
  460016
  463260
  464550
  465217
  467712
  467974
  470835
  471012
  473426
  473454
  473464
  473501
  475676
  477522
  479074
  480470
  480676
  482515
  483327
  485431
  486342
  489317
  489987
  490138
  493225
  493676
  493761
  493775
  495011
  495813
  504509
  512100
  513641
  513654
  513671
  513992
  515588
  516120
  517633
  518564
  519047
  519359
  519368
  520910
  523564
  532791
  537064
  538012
  538480
  538970
  544153
  545989
  547622
  547890
  552812
  555100
  555113
  555116
  555119
  555415
  556341
  556680
  562420
  563939
  568976
  569050
  574465
  577284
  584712
  603238
  604280
  605015
  607230
  617152
  660403
  667986
  678794
  721166
]
16.77 ms
(4.24%)
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
  417333
  667986
  452145
  452637
  452968
  453471
  455080
  458930
  460016
  467712
  467974
  473464
  480470
  489317
  459643
  465217
  473426
  471012
  495813
  516120
  523564
  515588
  513992
  473501
  475676
  482515
  483327
  552812
  562420
  569050
  574465
  555100
  555113
  555116
  556341
  563939
  547622
  547890
  555119
  678794
  545989
  556680
  605015
  603238
  617152
  124144
  400832
  423929
  424410
  452963
  381946
  384144
  390568
  446536
  400474
  411368
  444502
  455407
  480676
  159305
  411036
  424448
  452308
  458829
  464550
  470835
  463260
  519368
  538970
  513671
  519047
  520910
  489987
  493225
  504509
  512100
  513641
  513654
  486342
  490138
  518564
  519359
  538012
  391147
  532791
  584712
  604280
  607230
  235010
  3671
  389431
  387524
  411813
  440076
  441921
  413731
  432700
  432759
  409196
  432625
  440963
  442121
  493676
  493761
  473454
  454163
  477522
  485431
  493775
  517633
  538480
  495011
  537064
  479074
  568976
  577284
  555415
  544153
  721166
  660403
]
2.45 ms
(0.62%)
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
  3671
  124144
  159305
  235010
  381946
  384144
  387524
  389431
  390568
  391147
  400474
  400832
  409196
  411036
  411368
  411813
  413731
  417333
  423929
  424410
  424448
  432625
  432700
  432759
  440076
  440963
  441921
  442121
  444502
  446536
  452145
  452308
  452637
  452963
  452968
  453471
  454163
  455080
  455407
  458829
  458930
  459643
  460016
  463260
  464550
  465217
  467712
  467974
  470835
  471012
  473426
  473454
  473464
  473501
  475676
  477522
  479074
  480470
  480676
  482515
  483327
  485431
  486342
  489317
  489987
  490138
  493225
  493676
  493761
  493775
  495011
  495813
  504509
  512100
  513641
  513654
  513671
  513992
  515588
  516120
  517633
  518564
  519047
  519359
  519368
  520910
  523564
  532791
  537064
  538012
  538480
  538970
  544153
  545989
  547622
  547890
  552812
  555100
  555113
  555116
  555119
  555415
  556341
  556680
  562420
  563939
  568976
  569050
  574465
  577284
  584712
  603238
  604280
  605015
  607230
  617152
  660403
  667986
  678794
  721166
]
1.79 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature анус"
]
1.54 ms
(0.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature anus"
]
1.42 ms
(0.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature анус"
]

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.