Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.24 ms
(84.36%)
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
  7502
  95748
  96944
  117221
  316575
  341608
  351640
  373798
  383238
  386062
  394636
  397348
  398666
  399904
  400944
  403255
  406091
  406982
  412779
  414058
  428786
  445279
  447086
  448651
  452632
  471601
  480920
  488713
  488721
  500910
  505143
  525577
  528315
  531249
  534060
  545453
  545505
  549785
  550563
  551057
  566689
  569072
  583710
  585963
  587407
  589185
  590949
  607107
  620785
  633447
  634159
  640523
  644274
  644275
  649133
  650392
  652966
  654078
  670997
  672130
  673371
  674733
  681804
  683183
  683564
  683584
  686501
  688660
  690749
  693049
  695096
  695930
  696250
  697361
  697785
  697839
  697973
  697987
  698597
  699632
  699667
  699755
  700282
  703037
  703055
  703095
  705520
  705829
  713699
  715176
  717805
  719057
  720202
  721318
  722607
  722655
  723468
  738812
  739012
  741213
  742363
  750154
  752785
  759485
  761150
  767283
  769418
  770298
  770821
  775798
  775931
  784732
  791101
  791772
  801275
  806514
  813275
  817450
  827855
  827872
]
12.72 ms
(8.85%)
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
  775798
  750154
  767283
  769418
  791101
  742363
  752785
  741213
  759485
  738812
  739012
  620785
  640523
  644274
  644275
  697987
  703037
  703095
  705829
  715176
  717805
  775931
  784732
  791772
  373798
  403255
  827872
  607107
  452632
  531249
  569072
  634159
  383238
  394636
  96944
  117221
  400944
  414058
  428786
  817450
  500910
  505143
  528315
  566689
  683183
  650392
  587407
  585963
  589185
  633447
  806514
  813275
  770298
  761150
  713699
  480920
  397348
  406091
  412779
  471601
  351640
  534060
  488721
  827855
  316575
  445279
  448651
  583710
  590949
  770821
  801275
  399904
  95748
  406982
  488713
  525577
  545505
  447086
  386062
  341608
  7502
  398666
  545453
  549785
  551057
  550563
  652966
  654078
  670997
  686501
  688660
  695930
  696250
  697785
  697839
  697973
  700282
  721318
  672130
  683564
  695096
  697361
  698597
  705520
  722607
  722655
  723468
  649133
  673371
  674733
  681804
  683584
  690749
  693049
  699632
  699667
  699755
  703055
  719057
  720202
]
3.03 ms
(2.11%)
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
  7502
  95748
  96944
  117221
  316575
  341608
  351640
  373798
  383238
  386062
  394636
  397348
  398666
  399904
  400944
  403255
  406091
  406982
  412779
  414058
  428786
  445279
  447086
  448651
  452632
  471601
  480920
  488713
  488721
  500910
  505143
  525577
  528315
  531249
  534060
  545453
  545505
  549785
  550563
  551057
  566689
  569072
  583710
  585963
  587407
  589185
  590949
  607107
  620785
  633447
  634159
  640523
  644274
  644275
  649133
  650392
  652966
  654078
  670997
  672130
  673371
  674733
  681804
  683183
  683564
  683584
  686501
  688660
  690749
  693049
  695096
  695930
  696250
  697361
  697785
  697839
  697973
  697987
  698597
  699632
  699667
  699755
  700282
  703037
  703055
  703095
  705520
  705829
  713699
  715176
  717805
  719057
  720202
  721318
  722607
  722655
  723468
  738812
  739012
  741213
  742363
  750154
  752785
  759485
  761150
  767283
  769418
  770298
  770821
  775798
  775931
  784732
  791101
  791772
  801275
  806514
  813275
  817450
  827855
  827872
]
1.80 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "double анал teens"
]
1.71 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "double anal teens"
]
1.66 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "double анал teens"
]
1.55 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.