Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
351.67 ms
(91.24%)
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
  402722
  403939
  406324
  419546
  419627
  421520
  423375
  424469
  425168
  425490
  428103
  443425
  443831
  445543
  446505
  446894
  448445
  451957
  454984
  459830
  460733
  462321
  462751
  465525
  466090
  466112
  466928
  469534
  470074
  472777
  473739
  475796
  476709
  477020
  481147
  481149
  487339
  488308
  491776
  493192
  495022
  506056
  511009
  513710
  515131
  515717
  515896
  518473
  518744
  520840
  521001
  522616
  524628
  527902
  528397
  530637
  534003
  536248
  536665
  537198
  537210
  537888
  539203
  540511
  541643
  541650
  541769
  541924
  543607
  544455
  544840
  545611
  545755
  549176
  555948
  558130
  559120
  562906
  563441
  563546
  564407
  565172
  567338
  567909
  569682
  574244
  577356
  581096
  583507
  583622
  586628
  586886
  590256
  591272
  603167
  603622
  605122
  605450
  607527
  609906
  611616
  612399
  615718
  623199
  623380
  628087
  628117
  630537
  631902
  632701
  639258
  647343
  647837
  664583
  666875
  678779
  704235
  713176
  801907
  814901
]
24.12 ms
(6.26%)
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
  515717
  421520
  814901
  487339
  448445
  528397
  465525
  475796
  555948
  544455
  647343
  704235
  664583
  549176
  567338
  612399
  615718
  603622
  628117
  445543
  470074
  515896
  423375
  446505
  472777
  473739
  477020
  481147
  583622
  581096
  678779
  565172
  443831
  466112
  476709
  493192
  559120
  666875
  590256
  631902
  481149
  443425
  466090
  506056
  462321
  647837
  623380
  611616
  419627
  527902
  446894
  459830
  454984
  513710
  406324
  545755
  544840
  564407
  609906
  425168
  518744
  577356
  491776
  536248
  536665
  558130
  607527
  424469
  488308
  534003
  419546
  583507
  628087
  586886
  541643
  403939
  495022
  567909
  515131
  801907
  639258
  541769
  428103
  425490
  466928
  539203
  524628
  462751
  562906
  402722
  563546
  451957
  540511
  603167
  632701
  460733
  537888
  520840
  537210
  518473
  543607
  713176
  630537
  574244
  605450
  545611
  522616
  591272
  469534
  623199
  530637
  541924
  605122
  563441
  541650
  511009
  586628
  521001
  537198
  569682
]
2.98 ms
(0.77%)
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
  402722
  403939
  406324
  419546
  419627
  421520
  423375
  424469
  425168
  425490
  428103
  443425
  443831
  445543
  446505
  446894
  448445
  451957
  454984
  459830
  460733
  462321
  462751
  465525
  466090
  466112
  466928
  469534
  470074
  472777
  473739
  475796
  476709
  477020
  481147
  481149
  487339
  488308
  491776
  493192
  495022
  506056
  511009
  513710
  515131
  515717
  515896
  518473
  518744
  520840
  521001
  522616
  524628
  527902
  528397
  530637
  534003
  536248
  536665
  537198
  537210
  537888
  539203
  540511
  541643
  541650
  541769
  541924
  543607
  544455
  544840
  545611
  545755
  549176
  555948
  558130
  559120
  562906
  563441
  563546
  564407
  565172
  567338
  567909
  569682
  574244
  577356
  581096
  583507
  583622
  586628
  586886
  590256
  591272
  603167
  603622
  605122
  605450
  607527
  609906
  611616
  612399
  615718
  623199
  623380
  628087
  628117
  630537
  631902
  632701
  639258
  647343
  647837
  664583
  666875
  678779
  704235
  713176
  801907
  814901
]
1.97 ms
(0.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "молодые старые мжм секс втро"
]
1.83 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð╝ð¥ð╗ð¥ð┤ÐïðÁ Ðü ÐüÐéð░ÐÇÐïð╝ð© ð╝ðÂð╝ÔÔǪ"
]
1.46 ms
(0.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "молодые старые мжм секс втро"
]
1.41 ms
(0.37%)
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.