Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.82 ms
(82.91%)
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
  446298
  448843
  453620
  454195
  454220
  455051
  458118
  460159
  460679
  462082
  462104
  467054
  474111
  474123
  474794
  476337
  484654
  485763
  507427
  517265
  518868
  523219
  524835
  530328
  537849
  541068
  543594
  544859
  549138
  549251
  550223
  550646
  554524
  554897
  561378
  561740
  563478
  565646
  565703
  565731
  567412
  569957
  572715
  577388
  578814
  582333
  599327
  605686
  645925
  650422
  651887
  659366
  659383
  663898
  664321
  664322
  664832
  664861
  665218
  665229
  665273
  665311
  665384
  665395
  665444
  665455
  665465
  665468
  665871
  666093
  666741
  666791
  666796
  666849
  667193
  667199
  667281
  667284
  667514
  667536
  667614
  667649
  667659
  667661
  667679
  667842
  667900
  668181
  668190
  668192
  668809
  668875
  668898
  669768
  669771
  670482
  675524
  678798
  687430
  696283
  696985
  697009
  697011
  697180
  710595
  711679
  712827
  714053
  714222
  721382
  721459
  814070
  817398
  824162
  824244
  824371
  824427
  824935
  826246
  826592
]
18.45 ms
(10.35%)
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
  826592
  814070
  824935
  817398
  824244
  826246
  824162
  824427
  824371
  458118
  460679
  462082
  474794
  484654
  453620
  454220
  467054
  485763
  446298
  448843
  454195
  455051
  474111
  474123
  476337
  518868
  523219
  530328
  517265
  537849
  507427
  524835
  460159
  462104
  541068
  544859
  549138
  554524
  582333
  550646
  554897
  565646
  565703
  569957
  543594
  549251
  550223
  561378
  561740
  563478
  565731
  577388
  645925
  663898
  664321
  665229
  665273
  665395
  665455
  665871
  666741
  666791
  666796
  667284
  667900
  669768
  669771
  675524
  711679
  714222
  721382
  651887
  664322
  665384
  665465
  666093
  666849
  667199
  667281
  667614
  667659
  667679
  668192
  668809
  697009
  697011
  697180
  714053
  721459
  650422
  659366
  659383
  664832
  664861
  665218
  665311
  665444
  665468
  667193
  667514
  667536
  667649
  667661
  667842
  668181
  668190
  668875
  668898
  670482
  678798
  687430
  696283
  696985
  710595
  712827
  567412
  572715
  578814
  599327
  605686
]
4.02 ms
(2.26%)
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
  446298
  448843
  453620
  454195
  454220
  455051
  458118
  460159
  460679
  462082
  462104
  467054
  474111
  474123
  474794
  476337
  484654
  485763
  507427
  517265
  518868
  523219
  524835
  530328
  537849
  541068
  543594
  544859
  549138
  549251
  550223
  550646
  554524
  554897
  561378
  561740
  563478
  565646
  565703
  565731
  567412
  569957
  572715
  577388
  578814
  582333
  599327
  605686
  645925
  650422
  651887
  659366
  659383
  663898
  664321
  664322
  664832
  664861
  665218
  665229
  665273
  665311
  665384
  665395
  665444
  665455
  665465
  665468
  665871
  666093
  666741
  666791
  666796
  666849
  667193
  667199
  667281
  667284
  667514
  667536
  667614
  667649
  667659
  667661
  667679
  667842
  667900
  668181
  668190
  668192
  668809
  668875
  668898
  669768
  669771
  670482
  675524
  678798
  687430
  696283
  696985
  697009
  697011
  697180
  710595
  711679
  712827
  714053
  714222
  721382
  721459
  814070
  817398
  824162
  824244
  824371
  824427
  824935
  826246
  826592
]
2.30 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young chubby"
]
2.10 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young chubby"
]
1.96 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young chubby"
]

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.