Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.14 ms
(86.82%)
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
  382499
  390050
  417276
  419126
  419967
  427037
  428721
  429095
  435701
  436257
  436628
  437551
  446860
  452212
  454044
  455007
  457767
  459760
  460707
  465687
  467011
  469820
  469825
  471305
  477168
  484289
  488558
  489225
  489244
  490212
  493852
  496720
  498869
  506944
  514568
  515879
  528540
  535733
  538345
  539750
  541092
  544430
  550425
  551319
  551397
  551405
  558383
  569828
  577161
  577496
  577775
  577818
  584389
  588852
  593481
  593762
  602857
  605384
  608346
  610142
  610185
  615004
  617743
  618319
  618658
  618659
  623958
  628758
  636836
  637037
  641711
  643405
  643520
  644486
  644518
  644666
  651922
  658706
  663540
  665645
  668765
  681802
  682268
  683288
  695292
  697178
  701390
  708023
  710305
  712726
  714404
  722098
  724937
  732922
  736852
  744460
  744470
  744481
  744730
  747363
  749528
  749551
  749623
  750208
  756460
  773182
  781022
  793001
  795548
  796200
  803595
  804686
  812522
  813188
  816818
  818317
  818362
  818388
  824788
]
13.63 ms
(7.83%)
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
  435701
  539750
  437551
  515879
  419126
  436257
  460707
  506944
  714404
  651922
  551405
  605384
  744460
  644666
  427037
  818317
  724937
  484289
  701390
  390050
  816818
  452212
  489225
  551397
  577818
  588852
  593481
  644518
  803595
  744470
  781022
  417276
  455007
  467011
  493852
  535733
  514568
  577775
  610142
  623958
  818362
  577161
  577496
  643520
  602857
  636836
  644486
  749551
  738923
  749528
  747363
  490212
  544430
  708023
  610185
  429095
  538345
  428721
  722098
  618658
  643405
  593762
  773182
  813188
  489244
  824788
  818388
  663540
  454044
  558383
  608346
  446860
  496720
  469820
  550425
  695292
  668765
  756460
  382499
  528540
  641711
  796200
  457767
  628758
  615004
  436628
  459760
  477168
  469825
  471305
  498869
  584389
  682268
  697178
  551319
  749623
  712726
  637037
  744730
  736852
  683288
  618319
  812522
  795548
  804686
  793001
  744481
  732922
  569828
  541092
  617743
  419967
  465687
  488558
  710305
  658706
  665645
  681802
  618659
  750208
]
3.01 ms
(1.73%)
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
  382499
  390050
  417276
  419126
  419967
  427037
  428721
  429095
  435701
  436257
  436628
  437551
  446860
  452212
  454044
  455007
  457767
  459760
  460707
  465687
  467011
  469820
  469825
  471305
  477168
  484289
  488558
  489225
  489244
  490212
  493852
  496720
  498869
  506944
  514568
  515879
  528540
  535733
  538345
  539750
  541092
  544430
  550425
  551319
  551397
  551405
  558383
  569828
  577161
  577496
  577775
  577818
  584389
  588852
  593481
  593762
  602857
  605384
  608346
  610142
  610185
  615004
  617743
  618319
  618658
  618659
  623958
  628758
  636836
  637037
  641711
  643405
  643520
  644486
  644518
  644666
  651922
  658706
  663540
  665645
  668765
  681802
  682268
  683288
  695292
  697178
  701390
  708023
  710305
  712726
  714404
  722098
  724937
  732922
  736852
  744460
  744470
  744481
  744730
  747363
  749528
  749551
  749623
  750208
  756460
  773182
  781022
  793001
  795548
  796200
  803595
  804686
  812522
  813188
  816818
  818317
  818362
  818388
  824788
]
2.00 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "erotic massage"
]
1.66 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "эротик массаж"
]
1.43 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.22 ms
(0.70%)
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.