Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.05 ms
(88.03%)
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
  97156
  219172
  391904
  470593
  473321
  476426
  485485
  490227
  500551
  500617
  510427
  517448
  528665
  532717
  534133
  535585
  536202
  536211
  539533
  540122
  544252
  544661
  544696
  544713
  544749
  544751
  545091
  545096
  545584
  547961
  554876
  557069
  563659
  566394
  568187
  568188
  571121
  579305
  579598
  583715
  592708
  602808
  603578
  603625
  603646
  603690
  605583
  606064
  606471
  616745
  622116
  622125
  622179
  625307
  632251
  632413
  633965
  635787
  635788
  635842
  635863
  635872
  639075
  640909
  642524
  643927
  648996
  650852
  651313
  651318
  651423
  651434
  653437
  653603
  653628
  653634
  653880
  654206
  654256
  654293
  673533
  678306
  679549
  681740
  690012
  692470
  695177
  696167
  697494
  702877
  713445
  715581
  717313
  720916
  728742
  731358
  732704
  735078
  736778
  739606
  749548
  758035
  767857
  767861
  770837
  775896
  781638
  789011
  790060
  793231
  806376
  807844
  809781
  817663
  819180
  824132
  825279
  825628
  827873
  827896
]
14.89 ms
(7.36%)
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
  642524
  605583
  606471
  635787
  536211
  544713
  583715
  728742
  500617
  535585
  606064
  690012
  490227
  568187
  736778
  571121
  476426
  544661
  616745
  625307
  500551
  651434
  713445
  635842
  545584
  470593
  824132
  557069
  715581
  545096
  568188
  825279
  622125
  654256
  579305
  545091
  809781
  807844
  673533
  654206
  819180
  528665
  735078
  653437
  602808
  695177
  678306
  632413
  790060
  391904
  635872
  579598
  563659
  539533
  603578
  219172
  517448
  485485
  717313
  739606
  793231
  806376
  732704
  758035
  635788
  681740
  473321
  510427
  817663
  825628
  544252
  770837
  749548
  767857
  767861
  731358
  789011
  97156
  775896
  544696
  697494
  603625
  640909
  603690
  643927
  702877
  536202
  653634
  650852
  651313
  653628
  653603
  639075
  622116
  633965
  544751
  544749
  781638
  827873
  827896
  532717
  540122
  534133
  566394
  554876
  648996
  651423
  679549
  692470
  651318
  653880
  654293
  696167
  592708
  622179
  632251
  603646
  635863
  720916
  547961
]
2.48 ms
(1.23%)
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
  97156
  219172
  391904
  470593
  473321
  476426
  485485
  490227
  500551
  500617
  510427
  517448
  528665
  532717
  534133
  535585
  536202
  536211
  539533
  540122
  544252
  544661
  544696
  544713
  544749
  544751
  545091
  545096
  545584
  547961
  554876
  557069
  563659
  566394
  568187
  568188
  571121
  579305
  579598
  583715
  592708
  602808
  603578
  603625
  603646
  603690
  605583
  606064
  606471
  616745
  622116
  622125
  622179
  625307
  632251
  632413
  633965
  635787
  635788
  635842
  635863
  635872
  639075
  640909
  642524
  643927
  648996
  650852
  651313
  651318
  651423
  651434
  653437
  653603
  653628
  653634
  653880
  654206
  654256
  654293
  673533
  678306
  679549
  681740
  690012
  692470
  695177
  696167
  697494
  702877
  713445
  715581
  717313
  720916
  728742
  731358
  732704
  735078
  736778
  739606
  749548
  758035
  767857
  767861
  770837
  775896
  781638
  789011
  790060
  793231
  806376
  807844
  809781
  817663
  819180
  824132
  825279
  825628
  827873
  827896
]
1.98 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "домашнее мжм любитель…"
]
1.78 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск мжм секс втро любительск"
]
1.46 ms
(0.72%)
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.