Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.62 ms
(84.66%)
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
  12203
  151564
  187819
  188293
  276780
  373875
  373905
  382439
  383210
  387874
  390849
  391561
  393621
  395659
  397912
  403334
  468112
  468343
  538248
  547853
  564184
  575625
  590586
  590795
  598135
  608233
  629167
  630651
  631521
  633748
  639092
  640375
  645365
  650373
  655260
  660455
  660836
  692528
  695928
  703471
  704619
  704703
  706754
  720087
  721910
  721959
  725032
  726897
  726926
  727773
  728517
  730069
  730333
  731243
  731354
  734934
  737169
  737186
  742942
  744746
  745912
  746915
  747443
  747749
  750118
  750229
  750755
  753550
  756223
  756986
  758806
  759791
  760971
  761009
  761115
  761579
  765229
  765952
  767073
  767095
  767193
  768392
  769018
  769868
  770419
  774678
  775904
  776203
  780503
  782527
  784192
  784816
  785097
  787319
  790245
  791681
  792720
  793838
  794351
  795707
  796149
  799868
  800296
  800564
  800594
  802051
  802142
  802316
  810413
  811555
  813703
  813850
  814134
  817203
  817299
  818911
  824862
  824882
  826728
  828535
]
13.91 ms
(8.43%)
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
  730069
  731354
  761009
  744746
  756223
  758806
  745912
  767073
  767193
  768392
  760971
  721959
  151564
  276780
  391561
  818911
  817203
  828535
  468343
  780503
  747749
  730333
  373905
  188293
  383210
  382439
  12203
  468112
  564184
  655260
  692528
  590795
  629167
  726897
  728517
  747443
  737169
  824882
  826728
  813703
  660455
  774678
  792720
  799868
  761579
  765229
  785097
  787319
  802051
  726926
  767095
  734934
  769018
  776203
  794351
  800594
  810413
  811555
  756986
  765952
  633748
  403334
  814134
  813850
  538248
  547853
  645365
  660836
  704619
  720087
  721910
  608233
  639092
  640375
  590586
  598135
  775904
  784816
  793838
  796149
  800296
  802142
  802316
  782527
  791681
  800564
  725032
  784192
  746915
  750755
  753550
  759791
  769868
  737186
  750118
  742942
  727773
  731243
  750229
  761115
  770419
  631521
  703471
  706754
  790245
  795707
  373875
  187819
  395659
  387874
  393621
  390849
  397912
  824862
  817299
  575625
  650373
  695928
  704703
  630651
]
3.37 ms
(2.04%)
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
  12203
  151564
  187819
  188293
  276780
  373875
  373905
  382439
  383210
  387874
  390849
  391561
  393621
  395659
  397912
  403334
  468112
  468343
  538248
  547853
  564184
  575625
  590586
  590795
  598135
  608233
  629167
  630651
  631521
  633748
  639092
  640375
  645365
  650373
  655260
  660455
  660836
  692528
  695928
  703471
  704619
  704703
  706754
  720087
  721910
  721959
  725032
  726897
  726926
  727773
  728517
  730069
  730333
  731243
  731354
  734934
  737169
  737186
  742942
  744746
  745912
  746915
  747443
  747749
  750118
  750229
  750755
  753550
  756223
  756986
  758806
  759791
  760971
  761009
  761115
  761579
  765229
  765952
  767073
  767095
  767193
  768392
  769018
  769868
  770419
  774678
  775904
  776203
  780503
  782527
  784192
  784816
  785097
  787319
  790245
  791681
  792720
  793838
  794351
  795707
  796149
  799868
  800296
  800564
  800594
  802051
  802142
  802316
  810413
  811555
  813703
  813850
  814134
  817203
  817299
  818911
  824862
  824882
  826728
  828535
]
2.40 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal hot"
]
2.26 ms
(1.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал hot"
]
1.49 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал hot"
]

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.