Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.77 ms
(85.12%)
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
  407415
  414061
  452846
  458647
  469602
  508103
  522703
  531008
  532806
  533811
  533813
  535295
  536085
  536553
  548218
  550813
  556442
  562587
  564520
  568271
  574178
  575041
  584164
  588533
  588854
  590795
  600044
  601153
  602449
  610923
  611498
  612997
  625953
  626196
  627412
  630054
  634067
  642149
  642165
  643671
  645141
  645765
  648395
  648671
  656173
  657527
  657562
  657565
  658785
  658850
  660579
  661495
  664717
  664733
  664747
  667976
  668303
  674491
  680791
  682388
  683270
  686511
  690296
  706133
  717543
  717653
  720101
  735248
  735260
  738515
  738820
  740357
  740384
  740931
  743903
  745087
  745107
  745609
  745715
  746094
  749268
  749680
  750449
  750571
  751040
  751206
  751417
  751438
  752587
  752836
  761646
  765625
  766087
  767416
  770219
  770377
  770400
  774653
  778395
  782443
  782453
  782616
  783702
  784217
  785250
  791386
  791450
  793115
  793281
  793283
  795407
  799759
  799944
  802317
  807341
  808978
  812476
  814350
  817221
  818551
]
15.68 ms
(9.35%)
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
  414061
  407415
  817221
  814350
  818551
  452846
  458647
  469602
  522703
  536553
  532806
  533811
  535295
  508103
  531008
  536085
  533813
  568271
  574178
  556442
  564520
  575041
  584164
  645765
  656173
  657527
  658850
  661495
  668303
  683270
  717653
  648395
  657565
  658785
  660579
  664733
  664747
  667976
  680791
  682388
  690296
  706133
  720101
  645141
  648671
  657562
  664717
  674491
  686511
  717543
  548218
  550813
  562587
  588533
  600044
  602449
  612997
  642149
  626196
  634067
  643671
  588854
  611498
  630054
  642165
  590795
  601153
  625953
  627412
  774653
  782443
  782453
  782616
  783702
  784217
  791386
  791450
  793281
  793283
  799759
  807341
  778395
  785250
  793115
  808978
  812476
  740357
  743903
  751040
  751206
  751438
  752587
  761646
  766087
  795407
  799944
  802317
  738820
  745609
  749680
  750449
  751417
  770377
  740384
  745715
  738515
  740931
  745087
  745107
  746094
  752836
  767416
  770219
  735248
  735260
  749268
  750571
  765625
  770400
  610923
]
2.39 ms
(1.42%)
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
  407415
  414061
  452846
  458647
  469602
  508103
  522703
  531008
  532806
  533811
  533813
  535295
  536085
  536553
  548218
  550813
  556442
  562587
  564520
  568271
  574178
  575041
  584164
  588533
  588854
  590795
  600044
  601153
  602449
  610923
  611498
  612997
  625953
  626196
  627412
  630054
  634067
  642149
  642165
  643671
  645141
  645765
  648395
  648671
  656173
  657527
  657562
  657565
  658785
  658850
  660579
  661495
  664717
  664733
  664747
  667976
  668303
  674491
  680791
  682388
  683270
  686511
  690296
  706133
  717543
  717653
  720101
  735248
  735260
  738515
  738820
  740357
  740384
  740931
  743903
  745087
  745107
  745609
  745715
  746094
  749268
  749680
  750449
  750571
  751040
  751206
  751417
  751438
  752587
  752836
  761646
  765625
  766087
  767416
  770219
  770377
  770400
  774653
  778395
  782443
  782453
  782616
  783702
  784217
  785250
  791386
  791450
  793115
  793281
  793283
  795407
  799759
  799944
  802317
  807341
  808978
  812476
  814350
  817221
  818551
]
2.12 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo teen vagina"
]
1.83 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло teen вагин"
]
1.38 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло teen вагин"
]

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.