Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.58 ms
(82.26%)
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
  7196
  47606
  96341
  130289
  188453
  382355
  383327
  388690
  391537
  396504
  397218
  398244
  400753
  400932
  401032
  401773
  405061
  405535
  406705
  410843
  411768
  411947
  413818
  415074
  416857
  420643
  421025
  421152
  424782
  425992
  430144
  430341
  437839
  443829
  443945
  444464
  444978
  445540
  445679
  447588
  447814
  447947
  448211
  448663
  448887
  452269
  453087
  453178
  453238
  453417
  453548
  453868
  453877
  454200
  454402
  454676
  457166
  458702
  461036
  461130
  467690
  470047
  470443
  470935
  471170
  472206
  473806
  474116
  474433
  474835
  474851
  475104
  476799
  478006
  479077
  479103
  483752
  484657
  485330
  486699
  488118
  488391
  491272
  491736
  494277
  495154
  495396
  495656
  497184
  497473
  497560
  497881
  500420
  507257
  510676
  513540
  514023
  514395
  517478
  518880
  525020
  541767
  554119
  555837
  559109
  565391
  578827
  586654
  590252
  590499
  599524
  601660
  615366
  619529
  647636
  720206
  722050
  730299
  755082
  810663
]
17.95 ms
(11.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
  474835
  470935
  448663
  461130
  479103
  453417
  454402
  730299
  47606
  495154
  420643
  452269
  590499
  396504
  421152
  478006
  510676
  473806
  445540
  461036
  486699
  555837
  722050
  518880
  467690
  755082
  514023
  474851
  479077
  647636
  590252
  488118
  443945
  497473
  96341
  586654
  720206
  447814
  448211
  476799
  513540
  484657
  525020
  454200
  578827
  444978
  453238
  383327
  188453
  397218
  398244
  401773
  474116
  601660
  615366
  810663
  411947
  443829
  421025
  453087
  491736
  454676
  411768
  448887
  559109
  474433
  401032
  430144
  457166
  453548
  388690
  406705
  497184
  437839
  415074
  500420
  458702
  447947
  472206
  453868
  470047
  444464
  488391
  425992
  470443
  497881
  494277
  410843
  495396
  475104
  416857
  453178
  430341
  495656
  405535
  514395
  507257
  445679
  382355
  413818
  497560
  400753
  453877
  554119
  7196
  130289
  400932
  483752
  565391
  391537
  491272
  471170
  517478
  424782
  485330
  405061
  619529
  599524
  447588
  541767
]
2.87 ms
(1.77%)
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
  7196
  47606
  96341
  130289
  188453
  382355
  383327
  388690
  391537
  396504
  397218
  398244
  400753
  400932
  401032
  401773
  405061
  405535
  406705
  410843
  411768
  411947
  413818
  415074
  416857
  420643
  421025
  421152
  424782
  425992
  430144
  430341
  437839
  443829
  443945
  444464
  444978
  445540
  445679
  447588
  447814
  447947
  448211
  448663
  448887
  452269
  453087
  453178
  453238
  453417
  453548
  453868
  453877
  454200
  454402
  454676
  457166
  458702
  461036
  461130
  467690
  470047
  470443
  470935
  471170
  472206
  473806
  474116
  474433
  474835
  474851
  475104
  476799
  478006
  479077
  479103
  483752
  484657
  485330
  486699
  488118
  488391
  491272
  491736
  494277
  495154
  495396
  495656
  497184
  497473
  497560
  497881
  500420
  507257
  510676
  513540
  514023
  514395
  517478
  518880
  525020
  541767
  554119
  555837
  559109
  565391
  578827
  586654
  590252
  590499
  599524
  601660
  615366
  619529
  647636
  720206
  722050
  730299
  755082
  810663
]
2.35 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "большие толстые члены…"
]
2.07 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие толстые член"
]
1.70 ms
(1.05%)
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.