Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.68 ms
(54.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife husband sex"
]
157.01 ms
(40.34%)
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
  156877
  385467
  420326
  420556
  479224
  501616
  510934
  516090
  519601
  522976
  534345
  534661
  541071
  543359
  544131
  544593
  547105
  571110
  574399
  580396
  595306
  603458
  613484
  613678
  619472
  621786
  632500
  636400
  640231
  641339
  647097
  653347
  653359
  653368
  654006
  656852
  668887
  671454
  682413
  689889
  693852
  698106
  702995
  704169
  705784
  718025
  718142
  724078
  725237
  725614
  725643
  726124
  726973
  730154
  730188
  730924
  732816
  734124
  734703
  740789
  745373
  745553
  746226
  748855
  749394
  756249
  757486
  765921
  766395
  768096
  768755
  773402
  775026
  776504
  779048
  780058
  780096
  781444
  782310
  783055
  783536
  790325
  791668
  792444
  792673
  792780
  794357
  794584
  795066
  795150
  795901
  796335
  796610
  798781
  798909
  799829
  800182
  800618
  800892
  801170
  802027
  803637
  803696
  805603
  807844
  811533
  812101
  814060
  816095
  819422
  819747
  820114
  821635
  823353
  824593
  824849
  825418
  825799
  827263
  827479
]
11.38 ms
(2.92%)
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
  827479
  812101
  653347
  807844
  668887
  816095
  820114
  823353
  574399
  781444
  730924
  647097
  791668
  725643
  790325
  510934
  613678
  792780
  749394
  543359
  156877
  671454
  420556
  827263
  534661
  613484
  636400
  800892
  800182
  792673
  766395
  745553
  773402
  782310
  798781
  726973
  745373
  725237
  632500
  796610
  819747
  825799
  824849
  819422
  824593
  825418
  544593
  693852
  780058
  795150
  534345
  519601
  580396
  783536
  801170
  732816
  805603
  726124
  765921
  776504
  516090
  653368
  705784
  704169
  654006
  656852
  689889
  595306
  603458
  621786
  730188
  740789
  768096
  718142
  385467
  641339
  798909
  780096
  779048
  802027
  501616
  746226
  522976
  702995
  420326
  619472
  479224
  544131
  682413
  698106
  718025
  571110
  640231
  792444
  795901
  799829
  811533
  796335
  795066
  800618
  803696
  724078
  768755
  757486
  725614
  783055
  794584
  775026
  821635
  814060
  541071
  653359
  547105
  794357
  734124
  756249
  803637
  730154
  748855
  734703
]
2.95 ms
(0.76%)
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
  156877
  385467
  420326
  420556
  479224
  501616
  510934
  516090
  519601
  522976
  534345
  534661
  541071
  543359
  544131
  544593
  547105
  571110
  574399
  580396
  595306
  603458
  613484
  613678
  619472
  621786
  632500
  636400
  640231
  641339
  647097
  653347
  653359
  653368
  654006
  656852
  668887
  671454
  682413
  689889
  693852
  698106
  702995
  704169
  705784
  718025
  718142
  724078
  725237
  725614
  725643
  726124
  726973
  730154
  730188
  730924
  732816
  734124
  734703
  740789
  745373
  745553
  746226
  748855
  749394
  756249
  757486
  765921
  766395
  768096
  768755
  773402
  775026
  776504
  779048
  780058
  780096
  781444
  782310
  783055
  783536
  790325
  791668
  792444
  792673
  792780
  794357
  794584
  795066
  795150
  795901
  796335
  796610
  798781
  798909
  799829
  800182
  800618
  800892
  801170
  802027
  803637
  803696
  805603
  807844
  811533
  812101
  814060
  816095
  819422
  819747
  820114
  821635
  823353
  824593
  824849
  825418
  825799
  827263
  827479
]
1.83 ms
(0.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен husband секс"
]
1.57 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен husband секс"
]

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.