Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
114.28 ms
(80.75%)
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
  12811
  13202
  80510
  86510
  86826
  123257
  150899
  195888
  271329
  390058
  391349
  396150
  396347
  398314
  398746
  398779
  400882
  407482
  424263
  442968
  444316
  454107
  512812
  515644
  517237
  523825
  524926
  530819
  533984
  539633
  542668
  554509
  557108
  558586
  558966
  565598
  573269
  574067
  588007
  597920
  598421
  601556
  625950
  626753
  627697
  631143
  639757
  649573
  653306
  653313
  674523
  681734
  684301
  692069
  700885
  701281
  701794
  712879
  717212
  717226
  719472
  723095
  727870
  728922
  731199
  733401
  737809
  737968
  744664
  751701
  763695
  763889
  765088
  767553
  768403
  776944
  778226
  778908
  779442
  779574
  780209
  782976
  788442
  793384
  793389
  793465
  794586
  798259
  798391
  803653
  805628
  806308
  810617
  815482
  816385
  816523
  817137
  817357
  817760
  818131
  818155
  818250
  818664
  819772
  820622
  823340
  824114
  824918
  825177
  825222
  825379
  825745
  826559
  827164
  827671
  827727
  828264
  828509
]
17.12 ms
(12.10%)
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
  597920
  793384
  818155
  827671
  539633
  542668
  558586
  442968
  515644
  565598
  424263
  639757
  444316
  517237
  523825
  818664
  817137
  828264
  524926
  391349
  573269
  625950
  13202
  825222
  737968
  123257
  712879
  398314
  825379
  819772
  815482
  825745
  601556
  776944
  798259
  805628
  825177
  86826
  788442
  396150
  817760
  827727
  701794
  390058
  400882
  826559
  817357
  816385
  828509
  533984
  684301
  764590
  717212
  195888
  737809
  626753
  150899
  271329
  398779
  824918
  701281
  692069
  588007
  793465
  780209
  751701
  763695
  727870
  12811
  398746
  763889
  454107
  731199
  818250
  86510
  396347
  818131
  820622
  827164
  823340
  816523
  822579
  824114
  512812
  554509
  558966
  653313
  717226
  723095
  674523
  700885
  803653
  782976
  728922
  744664
  631143
  765088
  653306
  719472
  627697
  778908
  778226
  810617
  733401
  767553
  768403
  574067
  557108
  598421
  779574
  798391
  793389
  806308
  779442
  794586
  80510
  407482
  530819
  681734
  649573
]
2.70 ms
(1.91%)
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
  12811
  13202
  80510
  86510
  86826
  123257
  150899
  195888
  271329
  390058
  391349
  396150
  396347
  398314
  398746
  398779
  400882
  407482
  424263
  442968
  444316
  454107
  512812
  515644
  517237
  523825
  524926
  530819
  533984
  539633
  542668
  554509
  557108
  558586
  558966
  565598
  573269
  574067
  588007
  597920
  598421
  601556
  625950
  626753
  627697
  631143
  639757
  649573
  653306
  653313
  674523
  681734
  684301
  692069
  700885
  701281
  701794
  712879
  717212
  717226
  719472
  723095
  727870
  728922
  731199
  733401
  737809
  737968
  744664
  751701
  763695
  763889
  765088
  767553
  768403
  776944
  778226
  778908
  779442
  779574
  780209
  782976
  788442
  793384
  793389
  793465
  794586
  798259
  798391
  803653
  805628
  806308
  810617
  815482
  816385
  816523
  817137
  817357
  817760
  818131
  818155
  818250
  818664
  819772
  820622
  823340
  824114
  824918
  825177
  825222
  825379
  825745
  826559
  827164
  827671
  827727
  828264
  828509
]
2.23 ms
(1.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blowjob deepthroat"
]
1.91 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс глубокийминет минет оральн секс"
]
1.58 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "минет оральн секс глубокийминет минет оральн секс"
]

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.