Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.39 ms
(82.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
  397490
  416876
  416878
  417846
  424388
  426939
  429321
  431709
  433965
  434623
  443482
  444009
  446918
  449743
  449853
  453197
  461838
  464866
  483233
  489096
  490757
  494323
  506423
  508298
  509377
  512148
  515772
  516114
  518231
  523485
  524280
  524335
  525557
  527764
  529629
  532049
  542908
  546127
  554112
  555628
  556991
  558222
  563083
  563680
  563721
  571805
  572965
  575189
  575542
  578008
  581793
  585168
  592856
  599606
  601955
  605403
  610983
  618700
  625340
  626281
  672902
  674068
  677906
  683126
  683978
  685736
  697650
  698285
  699194
  699267
  702279
  703289
  705080
  716796
  720656
  723087
  725704
  726453
  729198
  753693
  756724
  763445
  763749
  763964
  764668
  764715
  771742
  772536
  777260
  777937
  779102
  779256
  779909
  779939
  780188
  780833
  781530
  785211
  789008
  789291
  790470
  791818
  792406
  795498
  795717
  797950
  800935
  801503
  802274
  805283
  805361
  807284
  807296
  807488
  809433
  812703
  818081
  818094
  823949
]
14.32 ms
(9.84%)
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
  771742
  779909
  791818
  801503
  397490
  444009
  446918
  449743
  506423
  489096
  542908
  578008
  555628
  575189
  581793
  556991
  416878
  508298
  509377
  417846
  818081
  818094
  823949
  525557
  527764
  674068
  683978
  699267
  672902
  716796
  585168
  599606
  618700
  625340
  805361
  766558
  756724
  601955
  720656
  779256
  785211
  790470
  529629
  698285
  490757
  512148
  809433
  431709
  494323
  429321
  524335
  523485
  554112
  563721
  683126
  685736
  697650
  702279
  563680
  592856
  626281
  777937
  780833
  789291
  805283
  779939
  797950
  800935
  807284
  792406
  807296
  807488
  763749
  726453
  729198
  763445
  764668
  772536
  763964
  779102
  812703
  434623
  433965
  516114
  563083
  723087
  753693
  464866
  558222
  424388
  443482
  518231
  575542
  449853
  453197
  515772
  532049
  546127
  572965
  571805
  699194
  705080
  677906
  605403
  610983
  780188
  795498
  777260
  795717
  725704
  781530
  764715
  703289
  789008
  802274
  416876
  426939
  461838
  483233
  524280
]
2.73 ms
(1.87%)
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
  397490
  416876
  416878
  417846
  424388
  426939
  429321
  431709
  433965
  434623
  443482
  444009
  446918
  449743
  449853
  453197
  461838
  464866
  483233
  489096
  490757
  494323
  506423
  508298
  509377
  512148
  515772
  516114
  518231
  523485
  524280
  524335
  525557
  527764
  529629
  532049
  542908
  546127
  554112
  555628
  556991
  558222
  563083
  563680
  563721
  571805
  572965
  575189
  575542
  578008
  581793
  585168
  592856
  599606
  601955
  605403
  610983
  618700
  625340
  626281
  672902
  674068
  677906
  683126
  683978
  685736
  697650
  698285
  699194
  699267
  702279
  703289
  705080
  716796
  720656
  723087
  725704
  726453
  729198
  753693
  756724
  763445
  763749
  763964
  764668
  764715
  771742
  772536
  777260
  777937
  779102
  779256
  779909
  779939
  780188
  780833
  781530
  785211
  789008
  789291
  790470
  791818
  792406
  795498
  795717
  797950
  800935
  801503
  802274
  805283
  805361
  807284
  807296
  807488
  809433
  812703
  818081
  818094
  823949
]
2.25 ms
(1.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov sleeping"
]
2.19 ms
(1.50%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов спящ"
]
1.81 ms
(1.25%)
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.