Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.90 ms
(84.83%)
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
  70476
  386944
  387648
  397502
  397761
  425751
  428286
  469048
  508523
  511004
  512642
  529600
  531572
  539204
  556143
  568852
  576810
  580283
  583545
  588441
  591231
  600924
  608380
  616634
  618660
  629193
  633695
  634585
  649160
  653693
  666683
  669957
  675450
  675715
  682652
  685521
  695890
  711686
  713167
  716960
  722834
  724753
  727553
  727715
  732646
  737287
  738118
  740259
  740836
  742539
  744874
  745175
  747005
  756152
  756269
  757567
  757671
  760939
  764560
  765636
  766491
  767223
  767327
  770713
  772108
  772290
  772357
  772368
  772979
  776994
  777915
  778717
  779659
  779891
  780025
  780082
  780316
  780378
  781308
  781920
  783232
  783652
  783941
  783966
  785011
  785747
  787703
  787975
  788203
  788463
  788498
  789149
  791753
  793880
  794122
  794171
  799771
  799825
  800171
  802686
  802736
  803325
  805996
  806192
  807263
  810246
  810507
  810913
  811682
  815372
  816159
  818220
  825074
  825207
  825689
  826799
]
12.40 ms
(8.29%)
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
  649160
  783232
  811682
  740259
  740836
  764560
  608380
  633695
  776994
  780025
  469048
  387648
  397502
  825074
  825207
  826799
  815372
  816159
  828272
  531572
  529600
  580283
  583545
  576810
  556143
  675450
  682652
  653693
  666683
  675715
  634585
  588441
  591231
  616634
  778717
  779891
  780378
  781920
  788203
  791753
  793880
  794171
  780082
  787975
  789149
  800171
  727715
  738118
  770713
  772368
  773517
  787703
  794122
  802686
  802736
  803325
  806192
  744874
  762013
  747005
  760939
  727553
  732646
  742539
  745175
  772108
  772290
  772357
  757671
  618660
  629193
  711686
  716960
  777915
  780316
  783652
  785747
  70476
  397761
  508523
  386944
  428286
  818220
  825689
  511004
  539204
  568852
  685521
  695890
  713167
  600924
  623097
  785011
  788463
  799771
  799825
  805996
  810246
  779659
  807263
  810507
  767223
  767327
  772979
  781308
  810913
  724753
  756269
  737287
  757567
  766491
  765636
  722834
  783941
  783966
  788498
  425751
  512642
  669957
  756152
]
3.12 ms
(2.08%)
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
  70476
  386944
  387648
  397502
  397761
  425751
  428286
  469048
  508523
  511004
  512642
  529600
  531572
  539204
  556143
  568852
  576810
  580283
  583545
  588441
  591231
  600924
  608380
  616634
  618660
  629193
  633695
  634585
  649160
  653693
  666683
  669957
  675450
  675715
  682652
  685521
  695890
  711686
  713167
  716960
  722834
  724753
  727553
  727715
  732646
  737287
  738118
  740259
  740836
  742539
  744874
  745175
  747005
  756152
  756269
  757567
  757671
  760939
  764560
  765636
  766491
  767223
  767327
  770713
  772108
  772290
  772357
  772368
  772979
  776994
  777915
  778717
  779659
  779891
  780025
  780082
  780316
  780378
  781308
  781920
  783232
  783652
  783941
  783966
  785011
  785747
  787703
  787975
  788203
  788463
  788498
  789149
  791753
  793880
  794122
  794171
  799771
  799825
  800171
  802686
  802736
  803325
  805996
  806192
  807263
  810246
  810507
  810913
  811682
  815372
  816159
  818220
  825074
  825207
  825689
  826799
]
1.93 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "all девушк"
]
1.87 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "all girl"
]
1.73 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "all девушк"
]
1.65 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.