Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.25 ms
(81.70%)
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
  29677
  384368
  397203
  400958
  401326
  407783
  411702
  411924
  413460
  413534
  420306
  422360
  428174
  430134
  432348
  443105
  443177
  450786
  452620
  453992
  454179
  454223
  454567
  459255
  460732
  463177
  464326
  468232
  471178
  478075
  482303
  485720
  485745
  486613
  487758
  488377
  488991
  489102
  489299
  491765
  496550
  496553
  502033
  517527
  518842
  518856
  525468
  526963
  536637
  537521
  537826
  546471
  549247
  552061
  554106
  559279
  561082
  561293
  565931
  569315
  570942
  574398
  578198
  578783
  580944
  583352
  583417
  585319
  587301
  591265
  591572
  592901
  592999
  594561
  609057
  613977
  614717
  617380
  617563
  618494
  638398
  644030
  667294
  667522
  697688
  699753
  714510
  718809
  719917
  725239
  725439
  725487
  731050
  746329
  753039
  759755
  768881
  769506
  770022
  775164
  782022
  782481
  785136
  795221
  795939
  796811
  798759
  803404
  807884
  808016
  809545
  809745
  810130
  824530
  824733
  824967
  825405
  826499
  826789
  827185
]
24.90 ms
(12.39%)
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
  422360
  443105
  525468
  413460
  428174
  491765
  468232
  496550
  526963
  496553
  536637
  613977
  460732
  400958
  454567
  454179
  463177
  454223
  518842
  489299
  487758
  488991
  552061
  464326
  29677
  824967
  826499
  826789
  827185
  824530
  824733
  825405
  489102
  478075
  471178
  537521
  537826
  517527
  580944
  546471
  554106
  561293
  570942
  578783
  583352
  667294
  697688
  719917
  667522
  699753
  718809
  583417
  585319
  587301
  591265
  592901
  592999
  617563
  591572
  594561
  617380
  618494
  809545
  810130
  775164
  782022
  798759
  803404
  809745
  725439
  731050
  753039
  770022
  782481
  795221
  795939
  796811
  725239
  725487
  746329
  759755
  768881
  769506
  638398
  644030
  714510
  785136
  807884
  808016
  411924
  397203
  401326
  413534
  450786
  502033
  574398
  549247
  578198
  565931
  569315
  609057
  561082
  614717
  559279
  384368
  407783
  420306
  432348
  430134
  411702
  443177
  482303
  485720
  452620
  453992
  485745
  486613
  459255
  488377
  518856
]
3.96 ms
(1.97%)
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
  29677
  384368
  397203
  400958
  401326
  407783
  411702
  411924
  413460
  413534
  420306
  422360
  428174
  430134
  432348
  443105
  443177
  450786
  452620
  453992
  454179
  454223
  454567
  459255
  460732
  463177
  464326
  468232
  471178
  478075
  482303
  485720
  485745
  486613
  487758
  488377
  488991
  489102
  489299
  491765
  496550
  496553
  502033
  517527
  518842
  518856
  525468
  526963
  536637
  537521
  537826
  546471
  549247
  552061
  554106
  559279
  561082
  561293
  565931
  569315
  570942
  574398
  578198
  578783
  580944
  583352
  583417
  585319
  587301
  591265
  591572
  592901
  592999
  594561
  609057
  613977
  614717
  617380
  617563
  618494
  638398
  644030
  667294
  667522
  697688
  699753
  714510
  718809
  719917
  725239
  725439
  725487
  731050
  746329
  753039
  759755
  768881
  769506
  770022
  775164
  782022
  782481
  785136
  795221
  795939
  796811
  798759
  803404
  807884
  808016
  809545
  809745
  810130
  824530
  824733
  824967
  825405
  826499
  826789
  827185
]
2.43 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая полная"
]
1.93 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая полная"
]
1.82 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "волосатая толстушка с…"
]
1.75 ms
(0.87%)
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.