Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.86 ms
(83.39%)
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
  395463
  396522
  400723
  400864
  401778
  417429
  424074
  444414
  453530
  462288
  463093
  464283
  466187
  469844
  470703
  470737
  503901
  504770
  512041
  522246
  529152
  530347
  530578
  541250
  548401
  548670
  557422
  558320
  558469
  567215
  569675
  571150
  571210
  580276
  583210
  584666
  589268
  595864
  595925
  598583
  610174
  617121
  617848
  618050
  618528
  621593
  623932
  625815
  626330
  626752
  631762
  633665
  644708
  653300
  658224
  658225
  665381
  670394
  692337
  694260
  701508
  702852
  708101
  714477
  714822
  714851
  715077
  716396
  720818
  723931
  729890
  733181
  733295
  736980
  737910
  738623
  738970
  741114
  748392
  753993
  754967
  760214
  760218
  761076
  761170
  764606
  771874
  774927
  776396
  776915
  780141
  783562
  787616
  787950
  788649
  789877
  794829
  795092
  798992
  799791
  800365
  801305
  802210
  804959
  805059
  805727
  807663
  810533
  813549
  818828
  821829
  821834
  821855
  823630
  823682
  825499
  825500
  825563
  825693
  825781
]
16.60 ms
(10.12%)
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
  825693
  821829
  821855
  470703
  557422
  714477
  626330
  633665
  644708
  810533
  789877
  738623
  400723
  825499
  522246
  462288
  512041
  610174
  617121
  618050
  617848
  733181
  569675
  571210
  818828
  529152
  670394
  761076
  530578
  424074
  567215
  626752
  794829
  780141
  800365
  805059
  802210
  764606
  748392
  823682
  720818
  589268
  729890
  776396
  776915
  558469
  665381
  801305
  787616
  631762
  400864
  825500
  825781
  825563
  821834
  453530
  530347
  548401
  558320
  658224
  714851
  658225
  548670
  595925
  595864
  799791
  774927
  736980
  737910
  754967
  738970
  771874
  741114
  753993
  618528
  804959
  805727
  469844
  541250
  708101
  788649
  813549
  823630
  504770
  694260
  702852
  783562
  795092
  723931
  760214
  798992
  760218
  761170
  395463
  417429
  653300
  571150
  621593
  625815
  716396
  598583
  580276
  692337
  733295
  463093
  464283
  583210
  584666
  714822
  787950
  715077
  807663
  466187
  396522
  444414
  401778
  623932
  503901
  701508
  470737
]
3.48 ms
(2.12%)
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
  395463
  396522
  400723
  400864
  401778
  417429
  424074
  444414
  453530
  462288
  463093
  464283
  466187
  469844
  470703
  470737
  503901
  504770
  512041
  522246
  529152
  530347
  530578
  541250
  548401
  548670
  557422
  558320
  558469
  567215
  569675
  571150
  571210
  580276
  583210
  584666
  589268
  595864
  595925
  598583
  610174
  617121
  617848
  618050
  618528
  621593
  623932
  625815
  626330
  626752
  631762
  633665
  644708
  653300
  658224
  658225
  665381
  670394
  692337
  694260
  701508
  702852
  708101
  714477
  714822
  714851
  715077
  716396
  720818
  723931
  729890
  733181
  733295
  736980
  737910
  738623
  738970
  741114
  748392
  753993
  754967
  760214
  760218
  761076
  761170
  764606
  771874
  774927
  776396
  776915
  780141
  783562
  787616
  787950
  788649
  789877
  794829
  795092
  798992
  799791
  800365
  801305
  802210
  804959
  805059
  805727
  807663
  810533
  813549
  818828
  821829
  821834
  821855
  823630
  823682
  825499
  825500
  825563
  825693
  825781
]
1.90 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young amateur girl"
]
1.80 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young любительск девушк"
]
1.67 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young любительск девушк"
]

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.