Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
340.89 ms
(94.27%)
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
  404731
  416125
  419467
  426256
  440485
  448429
  484729
  485426
  486002
  489848
  493561
  508602
  509203
  518160
  521789
  525423
  530522
  535739
  537012
  537112
  537964
  539383
  545251
  557486
  560686
  562181
  563090
  563097
  564286
  574996
  581759
  584828
  592126
  624374
  640405
  648996
  660023
  662525
  666433
  672816
  676389
  681764
  693984
  697216
  697710
  708626
  716313
  716727
  718608
  718823
  718841
  721083
  726110
  726309
  729789
  734077
  734129
  734311
  741093
  742565
  748451
  756354
  758267
  759701
  761051
  763042
  763310
  763508
  764456
  767095
  768151
  779173
  784115
  785633
  787430
  789076
  791548
  793729
  793793
  794710
  795296
  795724
  795818
  795869
  796001
  796679
  797120
  797208
  797367
  798241
  799660
  799751
  800095
  800455
  800726
  800968
  801043
  801124
  801302
  801369
  801480
  801937
  803475
  803779
  803887
  804026
  805319
  806139
  807214
  809181
  809231
  813307
  816641
  818279
  818907
  819350
  823852
  824070
  825597
  827236
]
11.52 ms
(3.18%)
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
  818907
  816641
  818279
  819350
  825597
  493561
  485426
  489848
  521789
  509203
  508602
  484729
  545251
  574996
  721083
  779173
  785633
  793793
  795818
  797367
  800095
  800455
  800968
  801124
  801369
  803475
  803887
  805319
  809181
  793729
  795296
  795724
  798241
  800726
  801302
  803779
  734129
  734311
  741093
  742565
  761051
  791548
  794710
  795869
  796001
  796679
  797208
  799660
  758267
  763042
  764456
  763508
  767095
  726110
  748451
  756354
  763310
  768151
  716727
  718841
  784115
  787430
  797120
  799751
  801480
  801937
  804026
  806139
  807214
  809231
  813307
  448429
  827236
  535739
  718608
  419467
  416125
  537112
  486002
  562181
  564286
  672816
  697216
  708626
  718823
  592126
  624374
  640405
  729789
  801043
  726309
  759701
  734077
  537964
  525423
  404731
  426256
  440485
  563090
  557486
  824070
  537012
  539383
  697710
  662525
  693984
  716313
  681764
  789076
  823852
  518160
  530522
  581759
  560686
  563097
  584828
  648996
  660023
  676389
  666433
]
2.44 ms
(0.67%)
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
  404731
  416125
  419467
  426256
  440485
  448429
  484729
  485426
  486002
  489848
  493561
  508602
  509203
  518160
  521789
  525423
  530522
  535739
  537012
  537112
  537964
  539383
  545251
  557486
  560686
  562181
  563090
  563097
  564286
  574996
  581759
  584828
  592126
  624374
  640405
  648996
  660023
  662525
  666433
  672816
  676389
  681764
  693984
  697216
  697710
  708626
  716313
  716727
  718608
  718823
  718841
  721083
  726110
  726309
  729789
  734077
  734129
  734311
  741093
  742565
  748451
  756354
  758267
  759701
  761051
  763042
  763310
  763508
  764456
  767095
  768151
  779173
  784115
  785633
  787430
  789076
  791548
  793729
  793793
  794710
  795296
  795724
  795818
  795869
  796001
  796679
  797120
  797208
  797367
  798241
  799660
  799751
  800095
  800455
  800726
  800968
  801043
  801124
  801302
  801369
  801480
  801937
  803475
  803779
  803887
  804026
  805319
  806139
  807214
  809181
  809231
  813307
  816641
  818279
  818907
  819350
  823852
  824070
  825597
  827236
]
1.93 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf homemade"
]
1.64 ms
(0.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf домашн любительск"
]
1.58 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf домашн любительск"
]

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.