Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.21 ms
(85.97%)
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
  130506
  194033
  383290
  383482
  389011
  395560
  395601
  395662
  395741
  407605
  413795
  415541
  416848
  416850
  416855
  418972
  426522
  428872
  433446
  433671
  433769
  434219
  438430
  439576
  442197
  443760
  446135
  446274
  446306
  446625
  448064
  450700
  451485
  451501
  451503
  452205
  453013
  453461
  456536
  460145
  460157
  460172
  460671
  460730
  470271
  470281
  471332
  472165
  473489
  476335
  477964
  478987
  481467
  481915
  485922
  492137
  497497
  503444
  505960
  509434
  510093
  510389
  519136
  519970
  526151
  530893
  532001
  534299
  535012
  535252
  539628
  547601
  552309
  557484
  563004
  563038
  563153
  563164
  565730
  568707
  590421
  593037
  605708
  606503
  610209
  611264
  613358
  613644
  613855
  619636
  625924
  625940
  627307
  646167
  663466
  668949
  684265
  687144
  692806
  697892
  705800
  726486
  730735
  731204
  739089
  739909
  745918
  751409
  761291
  772817
  784306
  784948
  787556
  796202
  804072
  804558
  809073
  814912
  815723
  825811
]
13.76 ms
(8.56%)
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
  395560
  485922
  383482
  389011
  433769
  453461
  446306
  530893
  532001
  534299
  557484
  687144
  627307
  730735
  395662
  505960
  442197
  438430
  815723
  446625
  568707
  605708
  593037
  731204
  804558
  772817
  625924
  787556
  804072
  470281
  433446
  433671
  428872
  563004
  563153
  619636
  751409
  194033
  825811
  446274
  451503
  456536
  460145
  692806
  606503
  610209
  611264
  625940
  796202
  739909
  470271
  395601
  472165
  481915
  510093
  383290
  453013
  451501
  415541
  460172
  448064
  497497
  646167
  395741
  476335
  481467
  434219
  416855
  452205
  705800
  590421
  784948
  809073
  761291
  739089
  745918
  439576
  526151
  130506
  418972
  426522
  814912
  535012
  547601
  697892
  565730
  613855
  726486
  407605
  413795
  450700
  416848
  416850
  460671
  478987
  492137
  535252
  539628
  460157
  552309
  563038
  563164
  684265
  668949
  613358
  784306
  477964
  443760
  451485
  460730
  510389
  509434
  519970
  473489
  446135
  471332
  503444
  519136
  663466
  613644
]
2.39 ms
(1.49%)
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
  130506
  194033
  383290
  383482
  389011
  395560
  395601
  395662
  395741
  407605
  413795
  415541
  416848
  416850
  416855
  418972
  426522
  428872
  433446
  433671
  433769
  434219
  438430
  439576
  442197
  443760
  446135
  446274
  446306
  446625
  448064
  450700
  451485
  451501
  451503
  452205
  453013
  453461
  456536
  460145
  460157
  460172
  460671
  460730
  470271
  470281
  471332
  472165
  473489
  476335
  477964
  478987
  481467
  481915
  485922
  492137
  497497
  503444
  505960
  509434
  510093
  510389
  519136
  519970
  526151
  530893
  532001
  534299
  535012
  535252
  539628
  547601
  552309
  557484
  563004
  563038
  563153
  563164
  565730
  568707
  590421
  593037
  605708
  606503
  610209
  611264
  613358
  613644
  613855
  619636
  625924
  625940
  627307
  646167
  663466
  668949
  684265
  687144
  692806
  697892
  705800
  726486
  730735
  731204
  739089
  739909
  745918
  751409
  761291
  772817
  784306
  784948
  787556
  796202
  804072
  804558
  809073
  814912
  815723
  825811
]
1.83 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big mommy"
]
1.61 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие mommy"
]
1.45 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие mommy"
]

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.