Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.88 ms
(85.41%)
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
  54378
  282099
  373798
  373981
  384325
  385710
  388007
  388175
  389315
  393331
  396528
  397072
  399888
  401814
  408489
  410374
  411937
  415048
  416303
  420118
  429898
  432366
  432536
  433304
  434863
  443582
  444956
  447209
  447888
  452539
  455783
  458272
  458583
  459382
  466572
  466599
  466612
  472712
  475317
  476157
  476957
  478593
  481216
  484110
  486055
  486316
  492392
  494384
  495153
  505441
  511481
  514386
  515226
  518566
  520790
  525043
  525102
  526564
  528459
  540175
  544535
  545189
  548280
  566786
  567947
  569511
  574244
  576307
  577362
  581677
  595384
  604560
  611616
  613471
  620399
  621686
  622068
  623209
  626752
  627730
  632051
  634561
  636277
  659637
  678799
  686061
  687928
  696977
  705521
  713037
  719244
  722557
  729873
  730464
  737390
  741113
  744006
  744852
  753448
  753890
  759543
  761576
  775993
  776015
  779704
  786004
  799948
  799980
  812115
  814138
  817057
  819519
  821091
  821667
  822142
  823479
  826800
]
16.73 ms
(9.41%)
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
  634561
  447888
  416303
  447209
  466572
  466599
  472712
  476957
  429898
  444956
  459382
  514386
  525102
  486316
  492392
  518566
  526564
  528459
  515226
  525043
  604560
  384325
  393331
  373981
  7170
  389315
  388007
  396528
  397072
  399888
  814138
  821091
  822142
  823479
  817057
  819519
  821667
  826800
  466612
  478593
  458583
  458272
  475317
  494384
  569511
  678799
  686061
  659637
  696977
  722557
  687928
  705521
  718662
  576307
  581677
  613471
  620399
  621686
  622068
  626752
  632051
  636277
  595384
  775993
  799980
  812115
  786004
  729873
  744852
  753890
  761576
  759543
  769740
  730464
  737390
  744006
  753448
  741113
  623209
  713037
  719244
  776015
  779704
  799948
  432366
  432536
  282099
  373798
  411937
  54378
  408489
  484110
  495153
  577362
  566786
  574244
  611616
  627730
  486055
  385710
  388175
  401814
  420118
  410374
  415048
  434863
  443582
  433304
  455783
  476157
  481216
  452539
  520790
  505441
  540175
  511481
  544535
  548280
  567947
  545189
]
2.74 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
  54378
  282099
  373798
  373981
  384325
  385710
  388007
  388175
  389315
  393331
  396528
  397072
  399888
  401814
  408489
  410374
  411937
  415048
  416303
  420118
  429898
  432366
  432536
  433304
  434863
  443582
  444956
  447209
  447888
  452539
  455783
  458272
  458583
  459382
  466572
  466599
  466612
  472712
  475317
  476157
  476957
  478593
  481216
  484110
  486055
  486316
  492392
  494384
  495153
  505441
  511481
  514386
  515226
  518566
  520790
  525043
  525102
  526564
  528459
  540175
  544535
  545189
  548280
  566786
  567947
  569511
  574244
  576307
  577362
  581677
  595384
  604560
  611616
  613471
  620399
  621686
  622068
  623209
  626752
  627730
  632051
  634561
  636277
  659637
  678799
  686061
  687928
  696977
  705521
  713037
  719244
  722557
  729873
  730464
  737390
  741113
  744006
  744852
  753448
  753890
  759543
  761576
  775993
  776015
  779704
  786004
  799948
  799980
  812115
  814138
  817057
  819519
  821091
  821667
  822142
  823479
  826800
]
1.96 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen man sperm"
]
1.58 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen мужчин сперм"
]
1.55 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.78%)
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.