Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.80 ms
(83.39%)
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
  69821
  117905
  361679
  387680
  390956
  396130
  396300
  396371
  398744
  401404
  402596
  403160
  414269
  417348
  428253
  441841
  441849
  442132
  443317
  444306
  445351
  453007
  456048
  457483
  460084
  460280
  471663
  479067
  493730
  497686
  505387
  506115
  509422
  512352
  512941
  514863
  517724
  520767
  529741
  531821
  531824
  531871
  534537
  534540
  536202
  547808
  547853
  547855
  548455
  548459
  548464
  550900
  550904
  551987
  568265
  574134
  574372
  576438
  580414
  581477
  604351
  605219
  609887
  619272
  619281
  626399
  631461
  642022
  642076
  648679
  656944
  658785
  660399
  663306
  692421
  701445
  710194
  713189
  713502
  715750
  717542
  717553
  722376
  735260
  735974
  737019
  739151
  740894
  745107
  745112
  745113
  745123
  752617
  752638
  752659
  752706
  765897
  769066
  782808
  785075
  792242
  792582
  792693
  793978
  794310
  795052
  796270
  796763
  797279
  799891
  800014
  800031
  801313
  801639
  817019
  827830
  827850
  827926
  827928
  827977
]
15.18 ms
(10.14%)
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
  529741
  531824
  710194
  631461
  792693
  752638
  785075
  795052
  745113
  740894
  745112
  444306
  69821
  390956
  428253
  457483
  619281
  441849
  512352
  509422
  792242
  398744
  715750
  717542
  609887
  752617
  548459
  605219
  752706
  387680
  396130
  403160
  547855
  574134
  568265
  656944
  701445
  717553
  713502
  619272
  800014
  801313
  737019
  794310
  739151
  745123
  752659
  765897
  722376
  417348
  460280
  396371
  453007
  551987
  604351
  402596
  517724
  514863
  660399
  642022
  479067
  793978
  792582
  534540
  414269
  443317
  460084
  497686
  505387
  548464
  581477
  800031
  471663
  445351
  493730
  441841
  531821
  547853
  642076
  735974
  512941
  361679
  648679
  713189
  401404
  817019
  827928
  827850
  827830
  520767
  534537
  663306
  692421
  799891
  626399
  548455
  456048
  506115
  574372
  576438
  547808
  801639
  442132
  580414
  117905
  396300
  827977
  827926
  536202
  531871
  550904
  550900
  658785
  782808
  796763
  769066
  745107
  735260
  796270
  797279
]
2.99 ms
(1.99%)
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
  69821
  117905
  361679
  387680
  390956
  396130
  396300
  396371
  398744
  401404
  402596
  403160
  414269
  417348
  428253
  441841
  441849
  442132
  443317
  444306
  445351
  453007
  456048
  457483
  460084
  460280
  471663
  479067
  493730
  497686
  505387
  506115
  509422
  512352
  512941
  514863
  517724
  520767
  529741
  531821
  531824
  531871
  534537
  534540
  536202
  547808
  547853
  547855
  548455
  548459
  548464
  550900
  550904
  551987
  568265
  574134
  574372
  576438
  580414
  581477
  604351
  605219
  609887
  619272
  619281
  626399
  631461
  642022
  642076
  648679
  656944
  658785
  660399
  663306
  692421
  701445
  710194
  713189
  713502
  715750
  717542
  717553
  722376
  735260
  735974
  737019
  739151
  740894
  745107
  745112
  745113
  745123
  752617
  752638
  752659
  752706
  765897
  769066
  782808
  785075
  792242
  792582
  792693
  793978
  794310
  795052
  796270
  796763
  797279
  799891
  800014
  800031
  801313
  801639
  817019
  827830
  827850
  827926
  827928
  827977
]
1.96 ms
(1.31%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "соседку трахнули жестко"
]
1.62 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен секс хардкор"
]
1.40 ms
(0.93%)
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.