Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.25 ms
(55.99%)
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
  39030
  263299
  295523
  389631
  392775
  393460
  395572
  396560
  396778
  399300
  399352
  399945
  401479
  401559
  404317
  415862
  415983
  417274
  418049
  418332
  421072
  422924
  425117
  429097
  429105
  430289
  431776
  432800
  446328
  447257
  447675
  448697
  451725
  451726
  456638
  456686
  456802
  458560
  458601
  462959
  463118
  463262
  463265
  465099
  467173
  467854
  470732
  471348
  471520
  472436
  472551
  474208
  474295
  475919
  475979
  476951
  479219
  479321
  480808
  486568
  489394
  492154
  504669
  508096
  515116
  515750
  518285
  518874
  521989
  523274
  545999
  547641
  548654
  550332
  553608
  555909
  564449
  566224
  566972
  567170
  570291
  570638
  573550
  575728
  576020
  576027
  576038
  576071
  580770
  581668
  581696
  581965
  586802
  591687
  592459
  594223
  595520
  595874
  597195
  597223
  598804
  601877
  605315
  614717
  617405
  617756
  620291
  644490
  644686
  660860
  679457
  682419
  706946
  712631
  712822
  747583
  747966
  755699
  810981
  821026
]
134.17 ms
(36.07%)
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
  39030
  263299
  295523
  389631
  392775
  393460
  395572
  396560
  396778
  399300
  399352
  399945
  401479
  401559
  404317
  415862
  415983
  417274
  418049
  418332
  421072
  422924
  425117
  429097
  429105
  430289
  431776
  432800
  446328
  447257
  447675
  448697
  451725
  451726
  456638
  456686
  456802
  458560
  458601
  462959
  463118
  463262
  463265
  465099
  467173
  467854
  470732
  471348
  471520
  472436
  472551
  474208
  474295
  475919
  475979
  476951
  479219
  479321
  480808
  486568
  489394
  492154
  504669
  508096
  515116
  515750
  518285
  518874
  521989
  523274
  545999
  547641
  548654
  550332
  553608
  555909
  564449
  566224
  566972
  567170
  570291
  570638
  573550
  575728
  576020
  576027
  576038
  576071
  580770
  581668
  581696
  581965
  586802
  591687
  592459
  594223
  595520
  595874
  597195
  597223
  598804
  601877
  605315
  614717
  617405
  617756
  620291
  644490
  644686
  660860
  679457
  682419
  706946
  712631
  712822
  747583
  747966
  755699
  810981
  821026
]
22.87 ms
(6.15%)
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
  475919
  518874
  523274
  396560
  418049
  418332
  421072
  429097
  429105
  508096
  467854
  581696
  660860
  548654
  462959
  463262
  404317
  456638
  472436
  515116
  489394
  399300
  614717
  479219
  480808
  521989
  263299
  39030
  396778
  399352
  401479
  430289
  431776
  415862
  417274
  422924
  821026
  447257
  451725
  451726
  458601
  463118
  465099
  470732
  475979
  486568
  448697
  456802
  476951
  479321
  446328
  458560
  472551
  492154
  518285
  504669
  515750
  463265
  474295
  550332
  581965
  566224
  566972
  573550
  576020
  576027
  576038
  576071
  564449
  570291
  570638
  575728
  581668
  706946
  712631
  712822
  679457
  682419
  545999
  547641
  553608
  555909
  567170
  580770
  586802
  592459
  595874
  597223
  620291
  644686
  591687
  605315
  595520
  601877
  644490
  594223
  597195
  598804
  617405
  755699
  810981
  747966
  747583
  617756
  389631
  395572
  432800
  447675
  471520
  392775
  399945
  415983
  425117
  456686
  467173
  471348
  474208
  295523
  393460
  401559
]
2.08 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cock old man"
]
1.69 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cock old мужчин"
]
1.52 ms
(0.41%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(0.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cock old мужчин"
]

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.