Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.69 ms
(84.73%)
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
  33917
  78786
  96800
  335642
  348918
  387265
  387693
  389178
  391861
  396048
  401644
  408432
  413283
  415588
  419273
  439439
  447692
  448266
  456863
  459855
  462499
  466882
  471898
  474845
  489796
  491437
  494700
  496973
  499533
  500936
  502343
  502560
  502736
  504038
  505739
  508579
  509355
  512542
  514187
  519343
  521462
  521987
  524204
  532118
  532298
  537192
  539347
  543889
  545288
  545500
  546082
  555855
  557000
  558109
  560241
  562970
  564485
  565114
  569225
  569619
  571766
  571980
  573222
  573983
  579261
  580494
  580847
  581175
  585337
  585680
  595086
  598772
  600937
  601503
  601691
  602490
  603029
  604837
  605073
  606796
  621109
  622452
  622722
  623360
  624008
  624023
  626973
  627252
  628585
  629338
  645364
  648347
  652671
  662399
  671584
  672324
  675587
  683541
  692131
  703626
  710769
  738475
  741879
  742751
  747069
  750430
  756496
  757196
  779653
  781040
  781060
  783353
  787819
  796999
  800875
  801064
  807010
  811653
  817992
]
14.83 ms
(9.12%)
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
  569225
  489796
  595086
  505739
  562970
  543889
  692131
  710769
  703626
  628585
  779653
  781060
  811653
  738475
  756496
  605073
  413283
  448266
  521462
  750430
  408432
  491437
  499533
  580847
  560241
  539347
  683541
  623360
  602490
  581175
  545288
  571980
  648347
  545500
  624008
  389178
  569619
  817992
  514187
  652671
  600937
  621109
  781040
  741879
  474845
  494700
  546082
  502560
  519343
  532298
  565114
  801064
  335642
  419273
  466882
  508579
  573983
  604837
  626973
  787819
  798952
  800875
  796999
  807010
  96800
  502343
  500936
  558109
  573222
  662399
  557000
  585680
  598772
  624023
  783353
  348918
  396048
  509355
  456863
  645364
  742751
  78786
  537192
  524204
  571766
  502736
  391861
  387693
  532118
  627252
  387265
  504038
  671584
  579261
  622722
  622452
  415588
  555855
  580494
  675587
  629338
  757196
  747069
  512542
  33917
  401644
  439439
  447692
  459855
  564485
  521987
  496973
  585337
  672324
  601691
  601503
  462499
  603029
  471898
  606796
]
2.78 ms
(1.71%)
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
  33917
  78786
  96800
  335642
  348918
  387265
  387693
  389178
  391861
  396048
  401644
  408432
  413283
  415588
  419273
  439439
  447692
  448266
  456863
  459855
  462499
  466882
  471898
  474845
  489796
  491437
  494700
  496973
  499533
  500936
  502343
  502560
  502736
  504038
  505739
  508579
  509355
  512542
  514187
  519343
  521462
  521987
  524204
  532118
  532298
  537192
  539347
  543889
  545288
  545500
  546082
  555855
  557000
  558109
  560241
  562970
  564485
  565114
  569225
  569619
  571766
  571980
  573222
  573983
  579261
  580494
  580847
  581175
  585337
  585680
  595086
  598772
  600937
  601503
  601691
  602490
  603029
  604837
  605073
  606796
  621109
  622452
  622722
  623360
  624008
  624023
  626973
  627252
  628585
  629338
  645364
  648347
  652671
  662399
  671584
  672324
  675587
  683541
  692131
  703626
  710769
  738475
  741879
  742751
  747069
  750430
  756496
  757196
  779653
  781040
  781060
  783353
  787819
  796999
  800875
  801064
  807010
  811653
  817992
]
2.02 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "на сиськ"
]
1.90 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на сиськ"
]
1.72 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.