Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.06 ms
(83.52%)
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
  6741
  319863
  391945
  392023
  395826
  396670
  400493
  400498
  400816
  400832
  401009
  401305
  411386
  411643
  414646
  416523
  416634
  420774
  421443
  421849
  421939
  422472
  423767
  426940
  427246
  427455
  428609
  433375
  434286
  437518
  440469
  440707
  440906
  440979
  444542
  444859
  446673
  446902
  447642
  447749
  448532
  450368
  451529
  452760
  452767
  453162
  454726
  455156
  457310
  457966
  459366
  463802
  464791
  466218
  466278
  470521
  470956
  471411
  476409
  479759
  479767
  480803
  481124
  484681
  488698
  488959
  493951
  495467
  498641
  500904
  505135
  507695
  513499
  514800
  516023
  516509
  518264
  518332
  518566
  519350
  520670
  523508
  538750
  540894
  542757
  543734
  546654
  547622
  558119
  564385
  571834
  576417
  583665
  589424
  590398
  609633
  609639
  612962
  623413
  626726
  627338
  628073
  659964
  662080
  663247
  668693
  678205
  719600
  720186
  720197
  726839
  730947
  744966
  744968
  776248
  793587
  814212
  814399
  825585
  826246
]
18.22 ms
(11.10%)
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
  626726
  543734
  514800
  547622
  814212
  825585
  538750
  540894
  662080
  776248
  744966
  730947
  627338
  444859
  401305
  319863
  659964
  420774
  437518
  459366
  583665
  744968
  447749
  488698
  571834
  433375
  451529
  480803
  513499
  421939
  546654
  678205
  428609
  826246
  720186
  457966
  411643
  457310
  471411
  609639
  726839
  400832
  447642
  400498
  440979
  400816
  401009
  414646
  488959
  663247
  421443
  507695
  516509
  520670
  612962
  452767
  479759
  426940
  498641
  519350
  720197
  623413
  609633
  484681
  440469
  440906
  427246
  576417
  516023
  421849
  463802
  542757
  392023
  464791
  481124
  391945
  479767
  395826
  6741
  518566
  628073
  416634
  590398
  453162
  558119
  444542
  476409
  466278
  396670
  793587
  523508
  454726
  518264
  814399
  446673
  719600
  589424
  400493
  411386
  416523
  448532
  495467
  500904
  455156
  470521
  518332
  505135
  668693
  446902
  470956
  440707
  452760
  434286
  450368
  423767
  422472
  564385
  427455
  466218
  493951
]
2.63 ms
(1.60%)
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
  6741
  319863
  391945
  392023
  395826
  396670
  400493
  400498
  400816
  400832
  401009
  401305
  411386
  411643
  414646
  416523
  416634
  420774
  421443
  421849
  421939
  422472
  423767
  426940
  427246
  427455
  428609
  433375
  434286
  437518
  440469
  440707
  440906
  440979
  444542
  444859
  446673
  446902
  447642
  447749
  448532
  450368
  451529
  452760
  452767
  453162
  454726
  455156
  457310
  457966
  459366
  463802
  464791
  466218
  466278
  470521
  470956
  471411
  476409
  479759
  479767
  480803
  481124
  484681
  488698
  488959
  493951
  495467
  498641
  500904
  505135
  507695
  513499
  514800
  516023
  516509
  518264
  518332
  518566
  519350
  520670
  523508
  538750
  540894
  542757
  543734
  546654
  547622
  558119
  564385
  571834
  576417
  583665
  589424
  590398
  609633
  609639
  612962
  623413
  626726
  627338
  628073
  659964
  662080
  663247
  668693
  678205
  719600
  720186
  720197
  726839
  730947
  744966
  744968
  776248
  793587
  814212
  814399
  825585
  826246
]
1.75 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade young anal"
]
1.42 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск young анал"
]
1.30 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск young анал"
]

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.