Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.72 ms
(82.56%)
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
  340567
  357499
  387218
  398089
  400928
  401274
  414103
  414119
  415319
  419891
  423663
  433132
  435539
  441107
  441841
  442157
  443095
  446964
  448002
  449406
  451758
  455087
  457476
  459170
  459306
  460209
  461081
  461606
  461870
  464951
  465522
  465550
  467712
  468175
  468338
  468377
  469096
  469457
  470453
  470470
  471685
  471764
  473368
  473450
  473486
  475647
  476166
  476168
  478413
  482193
  490849
  493575
  493658
  493758
  493840
  495811
  498153
  500789
  500929
  508906
  510807
  511431
  511867
  513842
  513992
  514254
  518454
  521008
  524849
  534552
  534566
  539741
  542093
  542411
  545250
  547471
  555337
  559139
  562225
  564029
  566770
  576503
  579582
  600340
  605033
  639736
  644453
  670356
  672944
  693194
  726942
  726986
  731328
  733149
  736249
  738821
  740702
  744618
  748979
  751773
  760814
  760912
  761087
  765804
  770900
  786876
  787564
  790409
  790974
  791803
  794355
  796527
  800334
  800495
  800592
  805721
  809104
  809122
  809504
  809747
]
15.39 ms
(10.35%)
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
  790974
  805721
  800495
  800592
  809122
  740702
  760912
  794355
  796527
  736249
  748979
  760814
  770900
  733149
  765804
  738821
  761087
  605033
  639736
  644453
  433132
  446964
  398089
  441107
  415319
  441841
  443095
  448002
  457476
  473450
  493658
  478413
  493758
  518454
  539741
  500929
  521008
  511867
  534552
  511431
  464951
  465522
  476166
  482193
  542411
  559139
  576503
  545250
  555337
  562225
  564029
  542093
  566770
  672944
  670356
  547471
  809747
  726942
  751773
  731328
  468338
  473486
  357499
  461081
  465550
  471685
  493575
  495811
  510807
  791803
  726986
  579582
  600340
  400928
  414103
  414119
  435539
  442157
  461606
  468377
  451758
  455087
  514254
  500789
  508906
  524849
  534566
  469096
  469457
  473368
  693194
  800334
  809104
  787564
  790409
  744618
  786876
  809504
  340567
  468175
  459170
  470453
  498153
  513842
  490849
  387218
  401274
  423663
  419891
  459306
  461870
  467712
  449406
  476168
  493840
  470470
  471764
  513992
  460209
  475647
]
3.03 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
  340567
  357499
  387218
  398089
  400928
  401274
  414103
  414119
  415319
  419891
  423663
  433132
  435539
  441107
  441841
  442157
  443095
  446964
  448002
  449406
  451758
  455087
  457476
  459170
  459306
  460209
  461081
  461606
  461870
  464951
  465522
  465550
  467712
  468175
  468338
  468377
  469096
  469457
  470453
  470470
  471685
  471764
  473368
  473450
  473486
  475647
  476166
  476168
  478413
  482193
  490849
  493575
  493658
  493758
  493840
  495811
  498153
  500789
  500929
  508906
  510807
  511431
  511867
  513842
  513992
  514254
  518454
  521008
  524849
  534552
  534566
  539741
  542093
  542411
  545250
  547471
  555337
  559139
  562225
  564029
  566770
  576503
  579582
  600340
  605033
  639736
  644453
  670356
  672944
  693194
  726942
  726986
  731328
  733149
  736249
  738821
  740702
  744618
  748979
  751773
  760814
  760912
  761087
  765804
  770900
  786876
  787564
  790409
  790974
  791803
  794355
  796527
  800334
  800495
  800592
  805721
  809104
  809122
  809504
  809747
]
2.17 ms
(1.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal hole milf"
]
1.92 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал дырк milf"
]
1.71 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал дырк milf"
]

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.