Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.34 ms
(53.31%)
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
  13118
  382117
  384423
  387742
  390303
  390761
  396656
  396759
  401617
  403690
  404192
  405485
  407570
  410687
  410955
  411199
  418084
  421058
  422167
  422725
  424379
  424407
  426816
  429609
  432663
  433302
  434350
  437983
  440753
  442144
  445736
  445930
  447740
  448874
  449713
  450297
  454350
  462019
  464180
  464798
  465858
  466499
  467614
  468637
  468750
  472525
  472592
  475258
  475489
  478408
  482981
  483147
  484876
  487368
  491837
  493221
  493679
  493754
  496340
  497879
  502713
  504668
  506069
  512137
  515511
  518582
  519465
  519949
  524257
  532746
  534990
  535533
  544292
  545718
  550035
  550363
  550366
  555992
  557522
  560917
  569149
  583449
  598370
  598387
  601792
  605144
  605337
  619199
  619645
  626293
  642346
  646279
  649108
  655295
  656266
  666196
  666869
  705277
  708468
  712940
  717677
  718945
  721715
  756383
  756509
  757350
  757393
  761590
  765517
  775473
  775858
  777017
  778195
  779744
  806060
  806327
  816158
  820068
  820070
  825831
]
153.49 ms
(39.47%)
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
  13118
  382117
  384423
  387742
  390303
  390761
  396656
  396759
  401617
  403690
  404192
  405485
  407570
  410687
  410955
  411199
  418084
  421058
  422167
  422725
  424379
  424407
  426816
  429609
  432663
  433302
  434350
  437983
  440753
  442144
  445736
  445930
  447740
  448874
  449713
  450297
  454350
  462019
  464180
  464798
  465858
  466499
  467614
  468637
  468750
  472525
  472592
  475258
  475489
  478408
  482981
  483147
  484876
  487368
  491837
  493221
  493679
  493754
  496340
  497879
  502713
  504668
  506069
  512137
  515511
  518582
  519465
  519949
  524257
  532746
  534990
  535533
  544292
  545718
  550035
  550363
  550366
  555992
  557522
  560917
  569149
  583449
  598370
  598387
  601792
  605144
  605337
  619199
  619645
  626293
  642346
  646279
  649108
  655295
  656266
  666196
  666869
  705277
  708468
  712940
  717677
  718945
  721715
  756383
  756509
  757350
  757393
  761590
  765517
  775473
  775858
  777017
  778195
  779744
  806060
  806327
  816158
  820068
  820070
  825831
]
20.35 ms
(5.23%)
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
  410687
  429609
  820068
  820070
  825831
  816158
  445930
  466499
  493679
  445736
  464180
  493754
  502713
  506069
  544292
  550366
  583449
  666196
  717677
  718945
  598387
  626293
  605144
  779744
  761590
  756383
  756509
  765517
  757350
  757393
  721715
  777017
  390761
  418084
  449713
  382117
  424407
  454350
  384423
  390303
  396759
  401617
  410955
  437983
  13118
  403690
  404192
  442144
  411199
  422167
  462019
  487368
  491837
  497879
  496340
  555992
  405485
  468637
  545718
  550035
  619199
  601792
  421058
  475258
  422725
  519949
  524257
  512137
  518582
  655295
  467614
  483147
  433302
  493221
  387742
  396656
  407570
  440753
  424379
  432663
  434350
  426816
  468750
  478408
  450297
  464798
  482981
  484876
  447740
  448874
  472525
  475489
  532746
  535533
  515511
  504668
  519465
  534990
  465858
  472592
  550363
  557522
  569149
  646279
  649108
  666869
  705277
  712940
  656266
  708468
  560917
  598370
  619645
  605337
  642346
  806060
  775473
  775858
  778195
  806327
]
2.28 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful milf anal"
]
1.86 ms
(0.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая milf анал"
]
1.78 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "красивая milf анал"
]

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.