Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.73 ms
(57.02%)
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
  326158
  383020
  391945
  397766
  413058
  414103
  414135
  415050
  417243
  418112
  418148
  419319
  419599
  420774
  421579
  423485
  423663
  424197
  426532
  429553
  449412
  449692
  452298
  452302
  452659
  452696
  452767
  454004
  455408
  455900
  456208
  456229
  456236
  460619
  460813
  463792
  464210
  464811
  467949
  468388
  472299
  473529
  474273
  474597
  489319
  492136
  493300
  493304
  498239
  504482
  505382
  509257
  509566
  510855
  513158
  513380
  513839
  514999
  516922
  517431
  518368
  522020
  528327
  534494
  536426
  539293
  544976
  545515
  545631
  550241
  552837
  554956
  555091
  555094
  555128
  559756
  561441
  564363
  565630
  571726
  573206
  589071
  596208
  601749
  604406
  620266
  624953
  627316
  632502
  633937
  640837
  656932
  667986
  671465
  672806
  675375
  715089
  715289
  716986
  720747
  724720
  724816
  727799
  742281
  751435
  758486
  765860
  767183
  768386
  781187
  782091
  786525
  790504
  795460
  796180
  810303
  825762
  825764
  825838
  826130
]
134.78 ms
(36.64%)
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
  326158
  383020
  391945
  397766
  413058
  414103
  414135
  415050
  417243
  418112
  418148
  419319
  419599
  420774
  421579
  423485
  423663
  424197
  426532
  429553
  449412
  449692
  452298
  452302
  452659
  452696
  452767
  454004
  455408
  455900
  456208
  456229
  456236
  460619
  460813
  463792
  464210
  464811
  467949
  468388
  472299
  473529
  474273
  474597
  489319
  492136
  493300
  493304
  498239
  504482
  505382
  509257
  509566
  510855
  513158
  513380
  513839
  514999
  516922
  517431
  518368
  522020
  528327
  534494
  536426
  539293
  544976
  545515
  545631
  550241
  552837
  554956
  555091
  555094
  555128
  559756
  561441
  564363
  565630
  571726
  573206
  589071
  596208
  601749
  604406
  620266
  624953
  627316
  632502
  633937
  640837
  656932
  667986
  671465
  672806
  675375
  715089
  715289
  716986
  720747
  724720
  724816
  727799
  742281
  751435
  758486
  765860
  767183
  768386
  781187
  782091
  786525
  790504
  795460
  796180
  810303
  825762
  825764
  825838
  826130
]
16.56 ms
(4.50%)
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
  456229
  463792
  424197
  493300
  489319
  504482
  493304
  420774
  419599
  423485
  455900
  452696
  536426
  539293
  545515
  544976
  545631
  672806
  675375
  589071
  768386
  727799
  452767
  474597
  554956
  559756
  565630
  571726
  449412
  452302
  517431
  573206
  472299
  414135
  413058
  552837
  418112
  667986
  534494
  555128
  656932
  715289
  671465
  601749
  633937
  786525
  751435
  468388
  391945
  421579
  455408
  456236
  456208
  449692
  509566
  513380
  498239
  452298
  513839
  596208
  473529
  564363
  825838
  825764
  716986
  795460
  724816
  758486
  528327
  724720
  467949
  415050
  383020
  426532
  604406
  326158
  414103
  417243
  826130
  454004
  474273
  555094
  555091
  561441
  627316
  810303
  765860
  742281
  767183
  632502
  790504
  397766
  460813
  464811
  509257
  796180
  781187
  715089
  419319
  452659
  505382
  513158
  460619
  550241
  640837
  624953
  782091
  620266
  418148
  464210
  514999
  518368
  522020
  510855
  516922
  492136
  720747
  429553
  423663
  825762
]
1.97 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hard wife anal"
]
1.80 ms
(0.49%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hard жен анал"
]
1.40 ms
(0.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hard жен анал"
]

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.