Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
187.28 ms
(86.02%)
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
  6602
  6997
  169326
  237293
  359134
  382971
  386508
  389122
  389211
  389829
  390929
  392765
  394218
  396374
  401906
  407220
  411698
  413137
  431686
  444414
  452376
  458716
  460332
  460340
  461625
  468931
  472282
  472912
  474863
  475658
  486215
  487920
  487933
  493093
  496552
  502059
  506635
  520730
  529698
  530326
  538834
  543694
  543738
  550651
  552530
  554848
  558072
  562596
  567628
  587975
  598979
  602000
  607335
  619530
  620801
  628325
  629293
  663420
  663514
  665121
  666138
  666808
  667199
  667649
  667898
  668872
  683825
  696317
  702955
  710001
  724225
  726556
  728470
  734489
  734679
  735800
  745422
  746619
  748230
  776865
  781729
  785146
  788292
  788904
  789016
  789693
  795286
  798209
  803271
  804211
  806355
  807387
  807546
  807615
  807630
  807991
  813388
  815791
  816455
  816996
  817308
  817432
  817687
  817701
  818505
  818656
  818811
  819595
  820726
  820732
  823591
  823637
  823688
  825141
  827833
  827844
  827861
  827868
  827908
  828401
]
21.00 ms
(9.64%)
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
  607335
  619530
  735800
  359134
  396374
  386508
  169326
  392765
  6997
  401906
  816996
  817432
  817687
  823688
  825141
  818656
  818811
  820726
  820732
  828401
  827861
  530326
  529698
  538834
  543694
  543738
  552530
  683825
  702955
  696317
  554848
  587975
  628325
  781729
  807615
  776865
  788292
  789016
  795286
  807630
  724225
  734489
  734679
  798209
  803271
  728470
  746619
  726556
  629293
  785146
  804211
  6602
  382971
  411698
  413137
  431686
  666138
  460332
  474863
  475658
  452376
  502059
  496552
  520730
  487920
  550651
  558072
  562596
  663514
  668872
  665121
  663420
  667898
  620801
  598979
  748230
  602000
  389829
  389211
  468931
  390929
  460340
  472282
  472912
  486215
  487933
  493093
  237293
  818505
  816455
  458716
  567628
  666808
  667199
  710001
  667649
  806355
  807387
  788904
  789693
  813388
  745422
  807546
  807991
  389122
  461625
  444414
  506635
  394218
  407220
  817308
  823637
  815791
  817701
  823591
  819595
  827868
  827833
  827908
  827844
]
3.16 ms
(1.45%)
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
  6602
  6997
  169326
  237293
  359134
  382971
  386508
  389122
  389211
  389829
  390929
  392765
  394218
  396374
  401906
  407220
  411698
  413137
  431686
  444414
  452376
  458716
  460332
  460340
  461625
  468931
  472282
  472912
  474863
  475658
  486215
  487920
  487933
  493093
  496552
  502059
  506635
  520730
  529698
  530326
  538834
  543694
  543738
  550651
  552530
  554848
  558072
  562596
  567628
  587975
  598979
  602000
  607335
  619530
  620801
  628325
  629293
  663420
  663514
  665121
  666138
  666808
  667199
  667649
  667898
  668872
  683825
  696317
  702955
  710001
  724225
  726556
  728470
  734489
  734679
  735800
  745422
  746619
  748230
  776865
  781729
  785146
  788292
  788904
  789016
  789693
  795286
  798209
  803271
  804211
  806355
  807387
  807546
  807615
  807630
  807991
  813388
  815791
  816455
  816996
  817308
  817432
  817687
  817701
  818505
  818656
  818811
  819595
  820726
  820732
  823591
  823637
  823688
  825141
  827833
  827844
  827861
  827868
  827908
  828401
]
1.88 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old boobs"
]
1.57 ms
(0.72%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.72%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old boobs"
]
1.28 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old boobs"
]

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.