Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.93 ms
(83.89%)
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
  233733
  418978
  507680
  513025
  522914
  538817
  538895
  538925
  538937
  538949
  541398
  541592
  541599
  541622
  541873
  541884
  541887
  544278
  544306
  544325
  544478
  544502
  544571
  544586
  547430
  548278
  549767
  549771
  549776
  554319
  558172
  559060
  559061
  559324
  560077
  560958
  561026
  561030
  561599
  561993
  562836
  563153
  563155
  563166
  563431
  563533
  563540
  566760
  567396
  567424
  567751
  567988
  571056
  571441
  573763
  574231
  574237
  576626
  576632
  576634
  576643
  576695
  576703
  576711
  576713
  576715
  577357
  580921
  581348
  583079
  583885
  583914
  584004
  587763
  590948
  592388
  592444
  592515
  610047
  614258
  615565
  620156
  620159
  620163
  620172
  621310
  622372
  624468
  629898
  644278
  644285
  644296
  644306
  644643
  670773
  671701
  671739
  681182
  684029
  690803
  690809
  690810
  690831
  692786
  692796
  694563
  695249
  698423
  699578
  699607
  699744
  703080
  708422
  716323
  729821
  750064
  789841
  789844
  801471
  813115
]
15.00 ms
(9.54%)
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
  620159
  620172
  813115
  699744
  563166
  541884
  562836
  538925
  560077
  544325
  561030
  563153
  671701
  690809
  681182
  692796
  699578
  576626
  621310
  789841
  567751
  538817
  576715
  592444
  549771
  541599
  563155
  573763
  581348
  561599
  567396
  544306
  583914
  670773
  699607
  690810
  694563
  695249
  698423
  708422
  622372
  644285
  620156
  592515
  789844
  729821
  629898
  644296
  233733
  544502
  583079
  544478
  559061
  624468
  750064
  513025
  558172
  571056
  576643
  801471
  538895
  538937
  544571
  544586
  560958
  563533
  566760
  574231
  571441
  574237
  671739
  684029
  703080
  692786
  561993
  576703
  610047
  590948
  615565
  592388
  620163
  644278
  644306
  644643
  584004
  541592
  522914
  548278
  576713
  576711
  507680
  567988
  549767
  559060
  567424
  541398
  576634
  583885
  614258
  690803
  418978
  538949
  541887
  549776
  559324
  576695
  541622
  541873
  563540
  544278
  547430
  554319
  563431
  576632
  577357
  580921
  690831
  716323
  561026
  587763
]
2.86 ms
(1.82%)
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
  233733
  418978
  507680
  513025
  522914
  538817
  538895
  538925
  538937
  538949
  541398
  541592
  541599
  541622
  541873
  541884
  541887
  544278
  544306
  544325
  544478
  544502
  544571
  544586
  547430
  548278
  549767
  549771
  549776
  554319
  558172
  559060
  559061
  559324
  560077
  560958
  561026
  561030
  561599
  561993
  562836
  563153
  563155
  563166
  563431
  563533
  563540
  566760
  567396
  567424
  567751
  567988
  571056
  571441
  573763
  574231
  574237
  576626
  576632
  576634
  576643
  576695
  576703
  576711
  576713
  576715
  577357
  580921
  581348
  583079
  583885
  583914
  584004
  587763
  590948
  592388
  592444
  592515
  610047
  614258
  615565
  620156
  620159
  620163
  620172
  621310
  622372
  624468
  629898
  644278
  644285
  644296
  644306
  644643
  670773
  671701
  671739
  681182
  684029
  690803
  690809
  690810
  690831
  692786
  692796
  694563
  695249
  698423
  699578
  699607
  699744
  703080
  708422
  716323
  729821
  750064
  789841
  789844
  801471
  813115
]
2.28 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature retro hairy"
]
1.81 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature ретр волосатая"
]
1.67 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature ретр волосатая"
]

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.