Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.95 ms
(86.63%)
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
  6739
  382579
  392508
  392906
  397529
  408723
  462406
  478642
  494760
  512649
  536972
  550242
  552196
  567840
  569416
  587689
  590261
  590328
  593300
  594286
  594419
  600110
  600916
  602068
  619244
  628912
  631103
  631390
  643879
  645662
  645836
  648524
  650304
  651253
  652803
  661652
  678489
  683042
  690528
  697192
  697458
  702288
  702491
  705178
  705752
  706544
  707166
  708365
  709709
  712270
  715396
  715405
  715701
  717102
  718071
  718650
  719524
  720102
  720588
  720635
  721141
  724704
  726578
  728759
  730676
  731821
  731916
  733160
  734783
  736639
  737260
  738942
  739180
  740697
  748434
  750034
  750920
  757957
  760481
  761967
  766776
  767058
  767991
  768862
  770159
  770645
  772447
  774079
  775396
  776970
  778099
  779613
  781067
  783548
  784881
  787909
  788565
  789140
  790855
  791015
  794859
  794934
  796020
  796157
  798477
  799996
  800101
  802152
  805914
  811655
  811818
  811946
  813770
  815844
  816781
  819932
  820060
  820760
  824488
]
14.58 ms
(7.90%)
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
  760481
  766776
  602068
  715405
  715701
  718650
  776970
  779613
  791015
  798477
  802152
  805914
  512649
  631103
  600916
  392906
  392508
  397529
  408723
  813770
  815844
  819932
  820760
  824488
  816781
  820060
  478642
  536972
  494760
  462406
  552196
  567840
  550242
  569416
  645836
  652803
  661652
  702288
  707166
  709709
  712270
  719524
  648524
  650304
  683042
  705178
  705752
  720102
  645662
  651253
  678489
  690528
  697192
  697458
  708365
  718071
  720588
  587689
  590261
  590328
  593300
  619244
  594286
  594419
  628912
  600110
  631390
  781067
  784881
  794859
  794934
  811655
  775396
  778099
  783548
  789140
  796020
  730676
  733160
  737260
  770159
  772447
  788565
  796157
  799996
  800101
  811818
  811946
  731821
  734783
  734834
  726578
  736639
  739180
  748434
  750920
  770645
  731916
  757957
  767058
  724704
  728759
  738942
  740697
  750034
  761967
  768862
  774079
  643879
  702491
  706544
  715396
  717102
  720635
  721141
  787909
  790855
  6739
  382579
  767991
]
3.69 ms
(2.00%)
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
  6739
  382579
  392508
  392906
  397529
  408723
  462406
  478642
  494760
  512649
  536972
  550242
  552196
  567840
  569416
  587689
  590261
  590328
  593300
  594286
  594419
  600110
  600916
  602068
  619244
  628912
  631103
  631390
  643879
  645662
  645836
  648524
  650304
  651253
  652803
  661652
  678489
  683042
  690528
  697192
  697458
  702288
  702491
  705178
  705752
  706544
  707166
  708365
  709709
  712270
  715396
  715405
  715701
  717102
  718071
  718650
  719524
  720102
  720588
  720635
  721141
  724704
  726578
  728759
  730676
  731821
  731916
  733160
  734783
  736639
  737260
  738942
  739180
  740697
  748434
  750034
  750920
  757957
  760481
  761967
  766776
  767058
  767991
  768862
  770159
  770645
  772447
  774079
  775396
  776970
  778099
  779613
  781067
  783548
  784881
  787909
  788565
  789140
  790855
  791015
  794859
  794934
  796020
  796157
  798477
  799996
  800101
  802152
  805914
  811655
  811818
  811946
  813770
  815844
  816781
  819932
  820060
  820760
  824488
]
1.96 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fucked hard"
]
1.44 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fucked hard"
]
1.22 ms
(0.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fucked hard"
]

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.