Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.52 ms
(87.33%)
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
  23884
  39843
  130641
  209941
  253864
  384906
  414710
  415539
  514294
  515311
  521659
  531202
  531205
  531215
  532081
  532658
  532756
  534004
  536249
  539171
  541942
  549417
  554310
  570821
  578345
  586190
  595041
  595595
  597199
  599977
  600022
  600312
  600365
  602603
  603703
  603746
  604960
  606717
  606738
  608772
  612335
  612343
  612381
  621290
  632635
  632646
  633491
  635222
  645236
  645284
  655099
  656055
  656998
  657591
  657652
  675458
  678131
  678243
  680606
  687529
  689048
  693885
  695122
  707726
  719283
  721568
  724493
  724745
  729907
  732336
  735334
  740179
  743824
  748532
  749388
  749946
  754438
  759671
  762299
  762781
  767310
  768079
  771035
  775429
  777486
  780180
  781030
  781318
  782716
  783732
  789622
  793556
  796910
  799576
  800259
  801774
  801945
  803785
  810135
  817003
  817016
  817403
  817693
  818676
  818880
  819792
  821115
  821491
  822475
  823123
  823158
  823379
  824193
  825111
  825810
  826229
  827082
  828074
]
13.77 ms
(7.35%)
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
  602603
  606738
  768079
  824193
  825810
  687529
  600365
  532658
  635222
  612343
  606717
  595595
  414710
  534004
  821115
  532756
  724493
  536249
  531215
  531202
  599977
  597199
  600312
  595041
  657591
  724745
  826056
  828074
  586190
  632646
  675458
  608772
  612335
  541942
  578345
  781318
  754438
  801774
  817693
  539171
  748532
  23884
  678131
  783732
  39843
  645236
  531205
  633491
  600022
  632635
  656998
  680606
  603746
  777486
  743824
  767310
  775429
  780180
  789622
  826229
  827082
  693885
  803785
  719283
  612381
  822475
  532081
  799576
  771167
  209941
  721568
  800259
  729907
  130641
  823123
  823379
  821491
  819792
  825111
  554310
  678243
  689048
  621290
  796910
  801945
  759671
  735334
  810135
  549417
  781030
  782716
  732336
  740179
  749388
  604960
  415539
  603703
  514294
  384906
  817003
  749946
  762299
  793556
  762781
  771035
  253864
  645284
  695122
  817403
  818880
  817016
  818676
  823158
  515311
  521659
  570821
  707726
  656055
  657652
  655099
]
2.63 ms
(1.40%)
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
  23884
  39843
  130641
  209941
  253864
  384906
  414710
  415539
  514294
  515311
  521659
  531202
  531205
  531215
  532081
  532658
  532756
  534004
  536249
  539171
  541942
  549417
  554310
  570821
  578345
  586190
  595041
  595595
  597199
  599977
  600022
  600312
  600365
  602603
  603703
  603746
  604960
  606717
  606738
  608772
  612335
  612343
  612381
  621290
  632635
  632646
  633491
  635222
  645236
  645284
  655099
  656055
  656998
  657591
  657652
  675458
  678131
  678243
  680606
  687529
  689048
  693885
  695122
  707726
  719283
  721568
  724493
  724745
  729907
  732336
  735334
  740179
  743824
  748532
  749388
  749946
  754438
  759671
  762299
  762781
  767310
  768079
  771035
  775429
  777486
  780180
  781030
  781318
  782716
  783732
  789622
  793556
  796910
  799576
  800259
  801774
  801945
  803785
  810135
  817003
  817016
  817403
  817693
  818676
  818880
  819792
  821115
  821491
  822475
  823123
  823158
  823379
  824193
  825111
  825810
  826229
  827082
  828074
]
2.20 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "love секс"
]
1.61 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "love секс"
]
1.61 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "love sex"
]

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.