Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.32 ms
(87.63%)
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
  17180
  81585
  201531
  305328
  382202
  398446
  399944
  403592
  409180
  445426
  806220
  815151
  815168
  815191
  815195
  815238
  815254
  815256
  815283
  815309
  815311
  815323
  815339
  815363
  815371
  815389
  815391
  815392
  815397
  815399
  815409
  815418
  815419
  815425
  815444
  815448
  815450
  815459
  815462
  815481
  815494
  815496
  815509
  815518
  815519
  815531
  815539
  815573
  815626
  815639
  815671
  815676
  815677
  815683
  815710
  815721
  815729
  815742
  815768
  815774
  815779
  815785
  815793
  815797
  815804
  815805
  815814
  815849
  815876
  815892
  815899
  815904
  815905
  815911
  815912
  815932
  815941
  815943
  815952
  815958
  815962
  815965
  815973
  815977
  815978
  815979
  815980
  815991
  815995
  816001
  816025
  816030
  816035
  816040
  816052
  816055
  816060
  816069
  816082
  816214
  816241
  816258
  816419
  816451
  816462
  816497
  816508
  816510
  816529
  816544
  816549
  816583
  816876
  816879
  816887
  816893
  816921
  816970
  816990
  817396
]
14.41 ms
(7.08%)
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
  816030
  815254
  815496
  815539
  815677
  815962
  816419
  816583
  815804
  816510
  816462
  305328
  815409
  816082
  815768
  816970
  815729
  815151
  403592
  815399
  815462
  815671
  816214
  816035
  816497
  815397
  815419
  815518
  815573
  815973
  815195
  815494
  815721
  815932
  17180
  815774
  815911
  815238
  815519
  815311
  815371
  815481
  815814
  815991
  816055
  816069
  815459
  815531
  815797
  816001
  816879
  815309
  815676
  815905
  815912
  816508
  816544
  816876
  815168
  815779
  815793
  815849
  815965
  815978
  81585
  815363
  815683
  815785
  815191
  815509
  815899
  815979
  816258
  816549
  816893
  815941
  815958
  815980
  806220
  815805
  815339
  815639
  815876
  815952
  816052
  816060
  201531
  815391
  815626
  816241
  816529
  815256
  815943
  815995
  816887
  399944
  398446
  445426
  815323
  815392
  815448
  815742
  816990
  815904
  816921
  817396
  815418
  815425
  815444
  815710
  815977
  382202
  409180
  815389
  815283
  815450
  815892
  816025
  816040
  816451
]
3.51 ms
(1.72%)
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
  17180
  81585
  201531
  305328
  382202
  398446
  399944
  403592
  409180
  445426
  806220
  815151
  815168
  815191
  815195
  815238
  815254
  815256
  815283
  815309
  815311
  815323
  815339
  815363
  815371
  815389
  815391
  815392
  815397
  815399
  815409
  815418
  815419
  815425
  815444
  815448
  815450
  815459
  815462
  815481
  815494
  815496
  815509
  815518
  815519
  815531
  815539
  815573
  815626
  815639
  815671
  815676
  815677
  815683
  815710
  815721
  815729
  815742
  815768
  815774
  815779
  815785
  815793
  815797
  815804
  815805
  815814
  815849
  815876
  815892
  815899
  815904
  815905
  815911
  815912
  815932
  815941
  815943
  815952
  815958
  815962
  815965
  815973
  815977
  815978
  815979
  815980
  815991
  815995
  816001
  816025
  816030
  816035
  816040
  816052
  816055
  816060
  816069
  816082
  816214
  816241
  816258
  816419
  816451
  816462
  816497
  816508
  816510
  816529
  816544
  816549
  816583
  816876
  816879
  816887
  816893
  816921
  816970
  816990
  817396
]
2.02 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex brazzers"
]
1.97 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс brazzers"
]
1.64 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс brazzers"
]
1.63 ms
(0.80%)
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.