Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.29 ms
(84.99%)
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
  7170
  96118
  96530
  103696
  192691
  192760
  198857
  236472
  324183
  326081
  341691
  341782
  373803
  382051
  383925
  385077
  386595
  386862
  387445
  387636
  387690
  387910
  388078
  388353
  389409
  391255
  393673
  396709
  402680
  403348
  404042
  420562
  444526
  475894
  517154
  538997
  543127
  544749
  544751
  559212
  587191
  593878
  602808
  605344
  621066
  632593
  633179
  634480
  635835
  637128
  644321
  648546
  649920
  650373
  650392
  652850
  653343
  654184
  661285
  663551
  670096
  671743
  671760
  673526
  674107
  683454
  683564
  683584
  686712
  690012
  690872
  699553
  699630
  699667
  699719
  700282
  703055
  705791
  705875
  707332
  708094
  708413
  709589
  709684
  711896
  716027
  719142
  720372
  720394
  720673
  720880
  721298
  721307
  721318
  722648
  722884
  727850
  727903
  728327
  728424
  736049
  740392
  742197
  746421
  749990
  766568
  770790
  772728
  773467
  775054
  775883
  775893
  775896
  775904
  778372
  787575
  788791
  801978
  814139
  826621
]
12.72 ms
(7.82%)
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
  649920
  721307
  740392
  192691
  387910
  538997
  722884
  673526
  720372
  749990
  559212
  775893
  705875
  721318
  746421
  700282
  663551
  388078
  721298
  391255
  543127
  674107
  644321
  778372
  690872
  96118
  632593
  637128
  653343
  654184
  385077
  386862
  420562
  707332
  711896
  388353
  387690
  727850
  775896
  192760
  699667
  775883
  705791
  683584
  683564
  709589
  650392
  198857
  621066
  403348
  826621
  96530
  373803
  719142
  650373
  801978
  382051
  772728
  709684
  814139
  670096
  690012
  775054
  736049
  236472
  341782
  648546
  683454
  686712
  708413
  773467
  393673
  775904
  720673
  326081
  402680
  324183
  341691
  699553
  652850
  634480
  444526
  708094
  720394
  633179
  544751
  544749
  635835
  699719
  587191
  605344
  602808
  389409
  720880
  671743
  396709
  766568
  787575
  103696
  7170
  386595
  703055
  788791
  770790
  383925
  699630
  742197
  387636
  517154
  671760
  716027
  661285
  722648
  728327
  728424
  727903
  387445
  404042
  475894
  593878
]
4.17 ms
(2.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mmf teen anal"
]
2.50 ms
(1.54%)
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
  7170
  96118
  96530
  103696
  192691
  192760
  198857
  236472
  324183
  326081
  341691
  341782
  373803
  382051
  383925
  385077
  386595
  386862
  387445
  387636
  387690
  387910
  388078
  388353
  389409
  391255
  393673
  396709
  402680
  403348
  404042
  420562
  444526
  475894
  517154
  538997
  543127
  544749
  544751
  559212
  587191
  593878
  602808
  605344
  621066
  632593
  633179
  634480
  635835
  637128
  644321
  648546
  649920
  650373
  650392
  652850
  653343
  654184
  661285
  663551
  670096
  671743
  671760
  673526
  674107
  683454
  683564
  683584
  686712
  690012
  690872
  699553
  699630
  699667
  699719
  700282
  703055
  705791
  705875
  707332
  708094
  708413
  709589
  709684
  711896
  716027
  719142
  720372
  720394
  720673
  720880
  721298
  721307
  721318
  722648
  722884
  727850
  727903
  728327
  728424
  736049
  740392
  742197
  746421
  749990
  766568
  770790
  772728
  773467
  775054
  775883
  775893
  775896
  775904
  778372
  787575
  788791
  801978
  814139
  826621
]
1.71 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мжм секс втро teen анал"
]
1.67 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мжм секс втро teen анал"
]

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.