Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.16 ms
(83.58%)
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
  213273
  382950
  383681
  385590
  396283
  397099
  398016
  419157
  420050
  421056
  422557
  422618
  422769
  422959
  423141
  423202
  423211
  423252
  423264
  424063
  429698
  429936
  430273
  444974
  452532
  454704
  457272
  457812
  462573
  472952
  473111
  473752
  473754
  473756
  484363
  506139
  510584
  512202
  515734
  525762
  528889
  538868
  539119
  540175
  540601
  541016
  545147
  545484
  546862
  547663
  550589
  550727
  551005
  552037
  552052
  552935
  554140
  554151
  557494
  557814
  558379
  559868
  560056
  562900
  565998
  566016
  567835
  569804
  585388
  586643
  590934
  591720
  595018
  600560
  600605
  601658
  605380
  614597
  622652
  623396
  623449
  623606
  630736
  636923
  638357
  642816
  670526
  672258
  680891
  686997
  687595
  688579
  688606
  692389
  713556
  714104
  722543
  739475
  744652
  747987
  750940
  757339
  760946
  768123
  771792
  771823
  771928
  775112
  776008
  785024
  785629
  789017
  790071
  792722
  809737
  810242
  812154
  815548
  818299
  818335
]
15.61 ms
(9.87%)
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
  550727
  429698
  429936
  552935
  586643
  760946
  750940
  454704
  552037
  600560
  739475
  382950
  768123
  785629
  538868
  539119
  790071
  775112
  457272
  383681
  552052
  554140
  422618
  462573
  540175
  688579
  688606
  692389
  591720
  785024
  812154
  815548
  559868
  600605
  515734
  424063
  562900
  557494
  565998
  789017
  792722
  420050
  421056
  419157
  642816
  423202
  457812
  545147
  622652
  528889
  569804
  614597
  776008
  484363
  554151
  385590
  422557
  506139
  541016
  546862
  545484
  595018
  630736
  623449
  623606
  525762
  550589
  623396
  398016
  818299
  213273
  423211
  444974
  567835
  547663
  557814
  585388
  771823
  397099
  423252
  473752
  422769
  510584
  558379
  757339
  818335
  512202
  771928
  747987
  771792
  423264
  430273
  452532
  472952
  473754
  473756
  670526
  590934
  638357
  601658
  810242
  744652
  809737
  540601
  396283
  551005
  605380
  423141
  422959
  473111
  680891
  636923
  560056
  566016
  687595
  714104
  722543
  672258
  686997
  713556
]
2.80 ms
(1.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
  213273
  382950
  383681
  385590
  396283
  397099
  398016
  419157
  420050
  421056
  422557
  422618
  422769
  422959
  423141
  423202
  423211
  423252
  423264
  424063
  429698
  429936
  430273
  444974
  452532
  454704
  457272
  457812
  462573
  472952
  473111
  473752
  473754
  473756
  484363
  506139
  510584
  512202
  515734
  525762
  528889
  538868
  539119
  540175
  540601
  541016
  545147
  545484
  546862
  547663
  550589
  550727
  551005
  552037
  552052
  552935
  554140
  554151
  557494
  557814
  558379
  559868
  560056
  562900
  565998
  566016
  567835
  569804
  585388
  586643
  590934
  591720
  595018
  600560
  600605
  601658
  605380
  614597
  622652
  623396
  623449
  623606
  630736
  636923
  638357
  642816
  670526
  672258
  680891
  686997
  687595
  688579
  688606
  692389
  713556
  714104
  722543
  739475
  744652
  747987
  750940
  757339
  760946
  768123
  771792
  771823
  771928
  775112
  776008
  785024
  785629
  789017
  790071
  792722
  809737
  810242
  812154
  815548
  818299
  818335
]
2.30 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blowjob asian"
]
1.83 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс азиатк"
]
1.82 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(1.02%)
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.