Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.60 ms
(82.96%)
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
  62175
  118164
  384117
  387334
  390573
  400942
  401841
  413958
  435593
  441129
  471663
  478038
  488724
  491368
  495726
  510822
  512352
  516064
  517928
  530272
  530384
  530791
  530796
  530941
  531089
  531202
  531235
  531419
  532343
  532913
  533063
  533382
  535054
  541846
  543249
  565161
  566563
  574656
  580290
  582323
  590377
  590411
  599875
  599890
  599899
  600185
  601600
  604513
  606101
  639258
  639719
  639752
  639784
  640435
  641678
  642002
  642016
  642018
  642660
  643079
  644918
  644941
  644986
  644998
  646029
  646786
  647939
  648795
  648839
  648868
  651607
  656916
  662423
  666853
  668526
  669000
  676623
  678063
  678128
  678493
  680484
  683261
  688617
  705277
  707315
  708441
  720138
  721141
  721184
  722428
  728215
  730074
  731916
  733981
  738476
  738487
  750549
  758325
  761176
  770058
  775859
  777057
  777577
  779610
  779682
  781615
  783425
  786454
  787047
  787101
  787427
  788790
  800334
  801880
  801957
  809104
  809412
  811491
  812639
  813770
]
17.43 ms
(10.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
  62175
  491368
  730074
  471663
  390573
  512352
  384117
  118164
  387334
  400942
  413958
  441129
  495726
  510822
  574656
  656916
  722428
  783425
  738487
  738476
  728215
  761176
  720138
  435593
  401841
  516064
  733981
  721184
  775859
  813770
  809412
  812639
  787101
  731916
  770058
  721141
  478038
  644986
  639258
  642660
  639719
  642016
  644998
  533063
  643079
  543249
  644941
  566563
  705277
  669000
  707315
  606101
  777057
  777577
  779682
  800334
  809104
  779610
  787047
  788790
  801957
  750549
  786454
  811491
  758325
  640435
  781615
  787427
  801880
  644918
  488724
  530272
  530384
  530796
  533382
  531202
  532343
  532913
  535054
  517928
  530791
  530941
  531089
  531235
  531419
  580290
  582323
  541846
  565161
  651607
  662423
  678493
  688617
  648795
  648839
  666853
  668526
  678063
  683261
  646029
  646786
  647939
  648868
  676623
  678128
  680484
  708441
  599890
  600185
  604513
  639784
  641678
  642002
  642018
  590411
  601600
  639752
  590377
  599875
  599899
]
2.76 ms
(1.71%)
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
  62175
  118164
  384117
  387334
  390573
  400942
  401841
  413958
  435593
  441129
  471663
  478038
  488724
  491368
  495726
  510822
  512352
  516064
  517928
  530272
  530384
  530791
  530796
  530941
  531089
  531202
  531235
  531419
  532343
  532913
  533063
  533382
  535054
  541846
  543249
  565161
  566563
  574656
  580290
  582323
  590377
  590411
  599875
  599890
  599899
  600185
  601600
  604513
  606101
  639258
  639719
  639752
  639784
  640435
  641678
  642002
  642016
  642018
  642660
  643079
  644918
  644941
  644986
  644998
  646029
  646786
  647939
  648795
  648839
  648868
  651607
  656916
  662423
  666853
  668526
  669000
  676623
  678063
  678128
  678493
  680484
  683261
  688617
  705277
  707315
  708441
  720138
  721141
  721184
  722428
  728215
  730074
  731916
  733981
  738476
  738487
  750549
  758325
  761176
  770058
  775859
  777057
  777577
  779610
  779682
  781615
  783425
  786454
  787047
  787101
  787427
  788790
  800334
  801880
  801957
  809104
  809412
  811491
  812639
  813770
]
2.08 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жесткое порно с милфами"
]
2.01 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор порн милф"
]
1.53 ms
(0.95%)
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.