Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.44 ms
(85.59%)
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
  197
  75936
  338338
  338807
  402369
  422123
  448465
  466825
  486143
  522636
  532337
  532534
  534044
  555408
  558926
  567619
  572671
  600515
  626786
  652734
  680825
  683669
  688245
  693425
  715407
  718111
  720345
  722219
  725436
  725551
  725650
  728143
  730124
  730804
  733079
  734869
  734959
  735439
  736113
  738851
  739201
  739865
  740720
  740827
  742122
  742827
  744529
  744595
  746745
  747041
  748003
  748014
  748115
  752828
  759794
  761682
  762018
  763903
  766094
  767304
  767328
  767331
  767340
  767690
  767993
  768646
  768649
  771468
  771690
  771864
  773382
  773791
  773845
  775244
  777033
  777034
  779783
  779859
  781007
  781120
  781590
  783042
  783130
  785903
  787259
  787584
  787776
  787788
  789362
  789409
  791870
  792577
  793038
  793338
  794426
  796344
  797810
  801176
  801343
  803876
  804839
  808251
  808846
  809659
  809697
  809755
  810318
  810371
  813013
  818143
  819006
  819024
  819210
  819940
  821811
  823728
  824237
  824608
  825761
  827330
]
18.15 ms
(9.80%)
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
  448465
  197
  818143
  819006
  827330
  532337
  466825
  567619
  775244
  779859
  787776
  789362
  725436
  740720
  747041
  771864
  773382
  742827
  773791
  773845
  740827
  767993
  781007
  810371
  422123
  819940
  558926
  600515
  810318
  748014
  733079
  534044
  781590
  752828
  728143
  652734
  626786
  693425
  338338
  819210
  486143
  720345
  813013
  794426
  771468
  785903
  791870
  792577
  793038
  804839
  808251
  739865
  739201
  763903
  801176
  803876
  715407
  680825
  688245
  572671
  777033
  801343
  809659
  809755
  734959
  797810
  338807
  75936
  402369
  821811
  824237
  825761
  823728
  819024
  824608
  522636
  532534
  555408
  722219
  683669
  718111
  779783
  783130
  787788
  796344
  808846
  777034
  781120
  783042
  789409
  793338
  809697
  730804
  734869
  746745
  761682
  767304
  767328
  767331
  767340
  767690
  787259
  787584
  742122
  748115
  759794
  771690
  725650
  730124
  735439
  738851
  768649
  725551
  736113
  744529
  744595
  748003
  762018
  766094
  768646
]
2.39 ms
(1.29%)
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
  197
  75936
  338338
  338807
  402369
  422123
  448465
  466825
  486143
  522636
  532337
  532534
  534044
  555408
  558926
  567619
  572671
  600515
  626786
  652734
  680825
  683669
  688245
  693425
  715407
  718111
  720345
  722219
  725436
  725551
  725650
  728143
  730124
  730804
  733079
  734869
  734959
  735439
  736113
  738851
  739201
  739865
  740720
  740827
  742122
  742827
  744529
  744595
  746745
  747041
  748003
  748014
  748115
  752828
  759794
  761682
  762018
  763903
  766094
  767304
  767328
  767331
  767340
  767690
  767993
  768646
  768649
  771468
  771690
  771864
  773382
  773791
  773845
  775244
  777033
  777034
  779783
  779859
  781007
  781120
  781590
  783042
  783130
  785903
  787259
  787584
  787776
  787788
  789362
  789409
  791870
  792577
  793038
  793338
  794426
  796344
  797810
  801176
  801343
  803876
  804839
  808251
  808846
  809659
  809697
  809755
  810318
  810371
  813013
  818143
  819006
  819024
  819210
  819940
  821811
  823728
  824237
  824608
  825761
  827330
]
1.59 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "creampie amateur homemade"
]
1.58 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "creampie любительск домашн любительск"
]
1.52 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "creampie любительск домашн любительск"
]
1.46 ms
(0.79%)
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.