Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.09 ms
(82.10%)
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
  187717
  232940
  383940
  388365
  390610
  391025
  392744
  395705
  398561
  400861
  401006
  401821
  401899
  411690
  421945
  422200
  424248
  426007
  429292
  439574
  440996
  443176
  444104
  454217
  454224
  454558
  454567
  456602
  458714
  460138
  462010
  462183
  463177
  464296
  465892
  466085
  466240
  466272
  470306
  471054
  471061
  471384
  472695
  474029
  474076
  474493
  474635
  475115
  476278
  476285
  477725
  477730
  477983
  478932
  479027
  479080
  479097
  479099
  479108
  480059
  482371
  482490
  484392
  484557
  484580
  484652
  485696
  486341
  486577
  501519
  502749
  502753
  503961
  504837
  506210
  513246
  518851
  520743
  520859
  520897
  529386
  530006
  532051
  549135
  549799
  555180
  557591
  557932
  558002
  561871
  563058
  563152
  565732
  565749
  571713
  584395
  589590
  602623
  619100
  621198
  621456
  649249
  651651
  665233
  668949
  697758
  705058
  710402
  721476
  726533
  728317
  732203
  736044
  738326
  739739
  745252
  748876
  780705
  823456
  827912
]
17.41 ms
(11.43%)
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
  474635
  479027
  479080
  479097
  479099
  479108
  454567
  470306
  474076
  474493
  477983
  401006
  421945
  454224
  454558
  463177
  475115
  476278
  476285
  440996
  466085
  466272
  502749
  503961
  506210
  484580
  484652
  485696
  520897
  484392
  486577
  518851
  520743
  429292
  589590
  422200
  466240
  454217
  477725
  484557
  458714
  460138
  472695
  478932
  726533
  443176
  392744
  474029
  504837
  187717
  391025
  728317
  563058
  558002
  232940
  501519
  549799
  439574
  465892
  477730
  486341
  480059
  827912
  532051
  651651
  705058
  721476
  710402
  602623
  619100
  780705
  748876
  739739
  738326
  732203
  736044
  745252
  395705
  665233
  621456
  621198
  383940
  388365
  390610
  400861
  398561
  401821
  401899
  426007
  444104
  411690
  424248
  823456
  482490
  471061
  471384
  456602
  513246
  520859
  529386
  502753
  530006
  462010
  462183
  464296
  471054
  482371
  561871
  565732
  571713
  549135
  584395
  555180
  557591
  565749
  649249
  668949
  697758
  557932
  563152
]
2.72 ms
(1.78%)
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
  187717
  232940
  383940
  388365
  390610
  391025
  392744
  395705
  398561
  400861
  401006
  401821
  401899
  411690
  421945
  422200
  424248
  426007
  429292
  439574
  440996
  443176
  444104
  454217
  454224
  454558
  454567
  456602
  458714
  460138
  462010
  462183
  463177
  464296
  465892
  466085
  466240
  466272
  470306
  471054
  471061
  471384
  472695
  474029
  474076
  474493
  474635
  475115
  476278
  476285
  477725
  477730
  477983
  478932
  479027
  479080
  479097
  479099
  479108
  480059
  482371
  482490
  484392
  484557
  484580
  484652
  485696
  486341
  486577
  501519
  502749
  502753
  503961
  504837
  506210
  513246
  518851
  520743
  520859
  520897
  529386
  530006
  532051
  549135
  549799
  555180
  557591
  557932
  558002
  561871
  563058
  563152
  565732
  565749
  571713
  584395
  589590
  602623
  619100
  621198
  621456
  649249
  651651
  665233
  668949
  697758
  705058
  710402
  721476
  726533
  728317
  732203
  736044
  738326
  739739
  745252
  748876
  780705
  823456
  827912
]
2.02 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old mature wife"
]
1.87 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old mature жен"
]
1.70 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old mature жен"
]

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.