Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.07 ms
(84.12%)
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
  51911
  110884
  117905
  117958
  248347
  346188
  346209
  387996
  388057
  388364
  392843
  397675
  397882
  399083
  401768
  408692
  409035
  413398
  413418
  414050
  414342
  415877
  415988
  416020
  418886
  419454
  423663
  428178
  440087
  440708
  441032
  445975
  446002
  446942
  448199
  449406
  452889
  453213
  453822
  459201
  460070
  462384
  463855
  470470
  471660
  471669
  473448
  477760
  479542
  482293
  483705
  486772
  493763
  493840
  496345
  497905
  506149
  513846
  513992
  514849
  515490
  519699
  519816
  521540
  531249
  531869
  531888
  536377
  537861
  541392
  545379
  545465
  546202
  547469
  547480
  550900
  558715
  571726
  572654
  576951
  580069
  583713
  586914
  595145
  603362
  606576
  606597
  628106
  628110
  628404
  632302
  633474
  641985
  647891
  650187
  656932
  660047
  662194
  664192
  671018
  671049
  673035
  680143
  680248
  686130
  686347
  695559
  713508
  728540
  740922
  745448
  751727
  752605
  752620
  765260
  765789
  770219
  782791
  796905
  825237
]
15.92 ms
(9.77%)
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
  423663
  448199
  462384
  449406
  493840
  446942
  470470
  497905
  513992
  413398
  482293
  428178
  452889
  453213
  479542
  445975
  506149
  110884
  117905
  473448
  414342
  419454
  346209
  117958
  397882
  471660
  408692
  765789
  571726
  413418
  416020
  415877
  545379
  656932
  647891
  633474
  399083
  446002
  513846
  531249
  628110
  752620
  519699
  418886
  409035
  441032
  463855
  545465
  673035
  680248
  650187
  606576
  401768
  477760
  460070
  459201
  580069
  414050
  471669
  514849
  388364
  671049
  680143
  440087
  825237
  493763
  453822
  496345
  531888
  537861
  536377
  531869
  541392
  583713
  660047
  695559
  713508
  546202
  641985
  595145
  740922
  728540
  751727
  752605
  628106
  632302
  796905
  51911
  388057
  397675
  248347
  415988
  387996
  346188
  486772
  521540
  558715
  550900
  572654
  662194
  686347
  547469
  606597
  745448
  770219
  782791
  440708
  483705
  515490
  519816
  603362
  392843
  547480
  686130
  664192
  671018
  586914
  765260
  576951
  628404
]
2.87 ms
(1.76%)
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
  51911
  110884
  117905
  117958
  248347
  346188
  346209
  387996
  388057
  388364
  392843
  397675
  397882
  399083
  401768
  408692
  409035
  413398
  413418
  414050
  414342
  415877
  415988
  416020
  418886
  419454
  423663
  428178
  440087
  440708
  441032
  445975
  446002
  446942
  448199
  449406
  452889
  453213
  453822
  459201
  460070
  462384
  463855
  470470
  471660
  471669
  473448
  477760
  479542
  482293
  483705
  486772
  493763
  493840
  496345
  497905
  506149
  513846
  513992
  514849
  515490
  519699
  519816
  521540
  531249
  531869
  531888
  536377
  537861
  541392
  545379
  545465
  546202
  547469
  547480
  550900
  558715
  571726
  572654
  576951
  580069
  583713
  586914
  595145
  603362
  606576
  606597
  628106
  628110
  628404
  632302
  633474
  641985
  647891
  650187
  656932
  660047
  662194
  664192
  671018
  671049
  673035
  680143
  680248
  686130
  686347
  695559
  713508
  728540
  740922
  745448
  751727
  752605
  752620
  765260
  765789
  770219
  782791
  796905
  825237
]
2.02 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "extreme gape anal"
]
1.75 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор большая большие дырк анал"
]
1.71 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "хардкор большая большие дырк анал"
]
1.61 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.