Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.63 ms
(85.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
  161969
  233292
  346210
  390218
  393102
  395891
  395910
  397894
  397921
  398951
  400481
  400493
  400507
  400509
  421810
  421823
  421826
  421828
  421854
  421882
  421887
  421889
  421895
  421897
  421914
  422154
  422181
  422194
  422198
  422205
  422209
  424120
  424125
  425450
  427117
  429567
  432596
  433249
  433359
  433376
  439655
  439705
  439717
  439720
  439727
  439738
  439789
  444699
  444870
  445201
  448961
  454187
  460555
  473954
  477067
  500806
  505807
  512455
  516485
  523836
  532825
  537985
  542957
  546921
  549851
  559052
  561990
  563452
  578348
  612574
  671862
  687940
  709372
  715417
  725493
  725497
  725502
  725511
  726627
  726802
  727036
  731022
  731269
  732171
  732989
  735901
  736977
  739935
  741044
  742539
  742561
  744184
  744809
  746089
  746091
  746207
  746603
  746646
  749766
  751490
  758166
  759088
  761607
  777196
  779534
  780469
  780795
  786216
  787636
  791883
  793282
  793930
  795040
  795361
  796208
  796212
  803565
  809307
  809800
  818135
]
12.18 ms
(7.95%)
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
  421826
  421823
  421897
  421895
  433376
  715417
  421914
  439705
  422194
  422154
  433359
  421889
  421887
  421810
  439789
  444699
  505807
  791883
  421854
  537985
  422181
  780469
  444870
  759088
  422209
  400509
  559052
  429567
  448961
  427117
  422198
  422205
  395910
  578348
  761607
  758166
  439720
  795361
  751490
  732989
  739935
  445201
  424125
  397921
  732171
  421882
  512455
  421828
  561990
  346210
  687940
  612574
  749766
  793282
  424120
  726627
  398951
  818135
  460555
  725497
  726802
  746646
  735901
  742539
  671862
  549851
  433249
  780795
  736977
  161969
  542957
  473954
  742561
  439655
  563452
  725502
  731022
  727036
  796212
  809800
  397894
  400481
  439727
  439717
  439738
  787636
  477067
  786216
  793930
  400507
  454187
  779534
  546921
  233292
  744184
  532825
  741044
  393102
  390218
  395891
  796208
  809307
  744809
  725493
  731269
  746207
  746091
  725511
  746089
  746603
  709372
  795040
  803565
  777196
  425450
  500806
  400493
  516485
  523836
  432596
]
3.17 ms
(2.07%)
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
  161969
  233292
  346210
  390218
  393102
  395891
  395910
  397894
  397921
  398951
  400481
  400493
  400507
  400509
  421810
  421823
  421826
  421828
  421854
  421882
  421887
  421889
  421895
  421897
  421914
  422154
  422181
  422194
  422198
  422205
  422209
  424120
  424125
  425450
  427117
  429567
  432596
  433249
  433359
  433376
  439655
  439705
  439717
  439720
  439727
  439738
  439789
  444699
  444870
  445201
  448961
  454187
  460555
  473954
  477067
  500806
  505807
  512455
  516485
  523836
  532825
  537985
  542957
  546921
  549851
  559052
  561990
  563452
  578348
  612574
  671862
  687940
  709372
  715417
  725493
  725497
  725502
  725511
  726627
  726802
  727036
  731022
  731269
  732171
  732989
  735901
  736977
  739935
  741044
  742539
  742561
  744184
  744809
  746089
  746091
  746207
  746603
  746646
  749766
  751490
  758166
  759088
  761607
  777196
  779534
  780469
  780795
  786216
  787636
  791883
  793282
  793930
  795040
  795361
  796208
  796212
  803565
  809307
  809800
  818135
]
2.19 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother son russian"
]
1.72 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин son русск"
]
1.67 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин son русск"
]

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.