Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.74 ms
(82.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
  96524
  96623
  130468
  182749
  192691
  198857
  324183
  341691
  387544
  390538
  393326
  395646
  396030
  398317
  400940
  404800
  404804
  407290
  409615
  410940
  420562
  436690
  453352
  454984
  456430
  467581
  468622
  470541
  472431
  480452
  489280
  490304
  502489
  530295
  530497
  531256
  533743
  535466
  537206
  537776
  537887
  542877
  544749
  544751
  564554
  565250
  565255
  583507
  604420
  605337
  609906
  612976
  620471
  621066
  632593
  633179
  633602
  634480
  635835
  639254
  644310
  647875
  647898
  650373
  650762
  652850
  654097
  666886
  670997
  674507
  681515
  683564
  683584
  684048
  685775
  686183
  688660
  692096
  692261
  695096
  695923
  699667
  699719
  702164
  702342
  708444
  713113
  714552
  715790
  718159
  722607
  723094
  730329
  733843
  733883
  734412
  738121
  738556
  740269
  744390
  745924
  750719
  766704
  767036
  775883
  775893
  775919
  777876
  782439
  792583
  796430
  796652
  801942
  805228
  811425
  811941
  814888
  817139
  817624
  822304
]
16.55 ms
(10.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
  666886
  605337
  639254
  811425
  801942
  644310
  714552
  715790
  775893
  792583
  404804
  407290
  395646
  398317
  390538
  409615
  198857
  130468
  192691
  817139
  692261
  685775
  612976
  620471
  782439
  796430
  734412
  767036
  738556
  744390
  777876
  490304
  537206
  468622
  565250
  565255
  650762
  702164
  453352
  400940
  410940
  670997
  688660
  683564
  695096
  722607
  683584
  699667
  621066
  730329
  775919
  420562
  502489
  583507
  647898
  609906
  454984
  467581
  489280
  632593
  436690
  531256
  542877
  708444
  647875
  733883
  733843
  393326
  341691
  182749
  817624
  822304
  530295
  544751
  564554
  650373
  654097
  681515
  695923
  713113
  652850
  686183
  692096
  718159
  544749
  633179
  635835
  633602
  775883
  805228
  796652
  766704
  750719
  738121
  740269
  745924
  604420
  634480
  699719
  702342
  723094
  811941
  324183
  96623
  396030
  96524
  387544
  404800
  814888
  456430
  480452
  470541
  530497
  537776
  533743
  537887
  535466
  472431
  674507
  684048
]
3.36 ms
(2.12%)
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
  96524
  96623
  130468
  182749
  192691
  198857
  324183
  341691
  387544
  390538
  393326
  395646
  396030
  398317
  400940
  404800
  404804
  407290
  409615
  410940
  420562
  436690
  453352
  454984
  456430
  467581
  468622
  470541
  472431
  480452
  489280
  490304
  502489
  530295
  530497
  531256
  533743
  535466
  537206
  537776
  537887
  542877
  544749
  544751
  564554
  565250
  565255
  583507
  604420
  605337
  609906
  612976
  620471
  621066
  632593
  633179
  633602
  634480
  635835
  639254
  644310
  647875
  647898
  650373
  650762
  652850
  654097
  666886
  670997
  674507
  681515
  683564
  683584
  684048
  685775
  686183
  688660
  692096
  692261
  695096
  695923
  699667
  699719
  702164
  702342
  708444
  713113
  714552
  715790
  718159
  722607
  723094
  730329
  733843
  733883
  734412
  738121
  738556
  740269
  744390
  745924
  750719
  766704
  767036
  775883
  775893
  775919
  777876
  782439
  792583
  796430
  796652
  801942
  805228
  811425
  811941
  814888
  817139
  817624
  822304
]
2.19 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen double penetration"
]
2.12 ms
(1.34%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen double penetration"
]
1.88 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen double penetration"
]

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.