Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.17 ms
(85.69%)
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
  6710
  27593
  30454
  39030
  75979
  263299
  305626
  352045
  362588
  382777
  383737
  384033
  384880
  385347
  386060
  386846
  389496
  389728
  397679
  400423
  400435
  400443
  400471
  403210
  404117
  404415
  409901
  413208
  415862
  416870
  418641
  418647
  421249
  422227
  424984
  429216
  429592
  435727
  446456
  448697
  450485
  453668
  454045
  454750
  456280
  456398
  456802
  456858
  457803
  457806
  457828
  458601
  460173
  460459
  460856
  462363
  463298
  464315
  464317
  467296
  468475
  470732
  470855
  476266
  476951
  482080
  485457
  487621
  500689
  502062
  509396
  515120
  515215
  516891
  518285
  519270
  526775
  536894
  545519
  547959
  549765
  557272
  561725
  563169
  563216
  564086
  565863
  567605
  568327
  576020
  584244
  592501
  596915
  599586
  606277
  612751
  617435
  621418
  623209
  635228
  641439
  665180
  682510
  684574
  697296
  730261
  732486
  741980
  742035
  745012
  751245
  770980
  785003
  790966
  800070
  806045
  811814
  812137
  821026
  827975
]
15.35 ms
(8.94%)
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
  545519
  563216
  567605
  612751
  596915
  463298
  482080
  435727
  526775
  389728
  409901
  429216
  827975
  460173
  454045
  468475
  561725
  564086
  684574
  665180
  682510
  697296
  606277
  635228
  592501
  621418
  785003
  800070
  742035
  806045
  811814
  730261
  741980
  770980
  745012
  732486
  617435
  623209
  790966
  812137
  389496
  422227
  404117
  456280
  460856
  457803
  457806
  476266
  397679
  450485
  457828
  500689
  487621
  568327
  599586
  75979
  385347
  27593
  641439
  751245
  386846
  386060
  383737
  384033
  382777
  384880
  263299
  305626
  352045
  362588
  30454
  39030
  6710
  400435
  400443
  400471
  400423
  403210
  404415
  418647
  421249
  418641
  429592
  415862
  416870
  424984
  413208
  821026
  446456
  453668
  456858
  458601
  470732
  448697
  454750
  456398
  456802
  462363
  476951
  464315
  464317
  467296
  470855
  509396
  515215
  518285
  519270
  502062
  515120
  536894
  516891
  460459
  485457
  547959
  549765
  557272
  565863
  584244
  576020
  563169
]
2.55 ms
(1.49%)
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
  6710
  27593
  30454
  39030
  75979
  263299
  305626
  352045
  362588
  382777
  383737
  384033
  384880
  385347
  386060
  386846
  389496
  389728
  397679
  400423
  400435
  400443
  400471
  403210
  404117
  404415
  409901
  413208
  415862
  416870
  418641
  418647
  421249
  422227
  424984
  429216
  429592
  435727
  446456
  448697
  450485
  453668
  454045
  454750
  456280
  456398
  456802
  456858
  457803
  457806
  457828
  458601
  460173
  460459
  460856
  462363
  463298
  464315
  464317
  467296
  468475
  470732
  470855
  476266
  476951
  482080
  485457
  487621
  500689
  502062
  509396
  515120
  515215
  516891
  518285
  519270
  526775
  536894
  545519
  547959
  549765
  557272
  561725
  563169
  563216
  564086
  565863
  567605
  568327
  576020
  584244
  592501
  596915
  599586
  606277
  612751
  617435
  621418
  623209
  635228
  641439
  665180
  682510
  684574
  697296
  730261
  732486
  741980
  742035
  745012
  751245
  770980
  785003
  790966
  800070
  806045
  811814
  812137
  821026
  827975
]
2.14 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "man with pussy"
]
1.68 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мужчин pussy"
]
1.54 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.31 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мужчин pussy"
]

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.