Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.03 ms
(82.20%)
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
  263900
  358757
  387227
  390931
  397708
  398830
  407616
  411731
  421830
  421891
  422292
  428484
  428835
  448751
  449662
  451494
  451502
  473819
  474471
  476421
  486751
  501601
  517064
  531994
  539788
  542859
  547539
  556011
  571095
  574328
  581989
  601986
  606685
  608356
  613286
  615640
  618807
  618910
  619116
  623390
  625268
  641082
  643362
  661913
  662147
  669675
  682336
  683126
  691437
  694105
  696558
  698364
  700649
  710119
  712176
  712328
  714901
  716172
  717114
  726574
  726576
  730970
  735836
  735996
  737372
  738313
  738340
  742687
  744426
  745422
  747284
  747421
  754133
  754361
  756614
  756859
  757213
  758031
  758314
  760679
  768443
  768887
  769494
  771490
  776178
  777743
  777963
  778034
  780930
  781795
  786244
  793818
  795754
  797360
  799966
  800569
  801368
  802119
  803430
  803904
  804965
  805711
  808217
  810317
  810564
  811145
  811246
  811454
  812802
  813922
  817957
  818186
  819819
  820188
  820199
  820333
  822721
  824102
  824250
  827143
]
13.55 ms
(9.28%)
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
  407616
  451494
  451502
  263900
  397708
  411731
  827143
  820188
  822721
  574328
  662147
  712176
  716172
  571095
  615640
  735836
  747284
  757213
  758314
  786244
  800569
  808217
  810564
  730970
  747421
  771490
  735996
  742687
  758031
  601986
  778034
  811145
  811246
  398830
  501601
  547539
  556011
  448751
  745422
  817957
  820333
  517064
  608356
  643362
  805711
  726576
  756614
  726574
  714901
  542859
  581989
  428484
  358757
  387227
  421891
  486751
  802119
  811454
  422292
  824250
  819819
  820199
  824102
  813922
  818186
  474471
  531994
  539788
  669675
  683126
  700649
  691437
  694105
  696558
  710119
  712328
  661913
  606685
  618807
  619116
  618910
  641082
  777963
  803904
  781795
  803430
  810317
  756859
  793818
  795754
  797360
  801368
  744426
  754133
  737372
  754361
  769494
  738313
  768443
  738340
  760679
  768887
  623390
  625268
  698364
  717114
  776178
  777743
  780930
  799966
  428835
  449662
  682336
  473819
  421830
  613286
  390931
  476421
  804965
  812802
]
3.95 ms
(2.70%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс stepmom"
]
3.06 ms
(2.10%)
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
  263900
  358757
  387227
  390931
  397708
  398830
  407616
  411731
  421830
  421891
  422292
  428484
  428835
  448751
  449662
  451494
  451502
  473819
  474471
  476421
  486751
  501601
  517064
  531994
  539788
  542859
  547539
  556011
  571095
  574328
  581989
  601986
  606685
  608356
  613286
  615640
  618807
  618910
  619116
  623390
  625268
  641082
  643362
  661913
  662147
  669675
  682336
  683126
  691437
  694105
  696558
  698364
  700649
  710119
  712176
  712328
  714901
  716172
  717114
  726574
  726576
  730970
  735836
  735996
  737372
  738313
  738340
  742687
  744426
  745422
  747284
  747421
  754133
  754361
  756614
  756859
  757213
  758031
  758314
  760679
  768443
  768887
  769494
  771490
  776178
  777743
  777963
  778034
  780930
  781795
  786244
  793818
  795754
  797360
  799966
  800569
  801368
  802119
  803430
  803904
  804965
  805711
  808217
  810317
  810564
  811145
  811246
  811454
  812802
  813922
  817957
  818186
  819819
  820188
  820199
  820333
  822721
  824102
  824250
  827143
]
2.04 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blowjob stepmom"
]
1.91 ms
(1.31%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "минет оральн секс stepmom"
]

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.