Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.39 ms
(84.64%)
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
  232953
  233321
  390923
  391475
  391581
  391968
  393701
  397279
  397410
  398957
  401124
  402340
  417276
  426725
  443156
  443673
  443686
  443706
  444001
  444142
  444258
  462579
  463166
  466187
  467214
  469844
  469898
  470785
  470926
  473252
  477958
  477980
  479765
  494362
  494382
  496965
  501845
  503870
  504744
  520300
  526111
  542934
  542942
  543694
  543738
  546627
  552859
  556849
  557326
  563207
  565107
  569684
  570056
  580241
  580640
  595363
  595863
  596650
  597585
  598443
  600042
  612022
  622111
  627748
  655718
  655752
  656728
  657025
  657030
  657643
  660513
  668648
  676472
  676473
  692859
  701501
  704010
  710957
  714447
  714455
  715425
  716835
  717699
  720824
  720825
  721552
  722443
  725914
  728351
  735594
  740494
  741029
  741047
  744508
  745760
  747476
  749896
  749940
  753815
  758033
  766043
  766536
  769766
  779523
  781687
  781701
  782217
  789202
  789401
  789829
  789885
  817660
  818083
  819047
  820079
  820225
  820298
  823910
  825682
  827978
]
15.57 ms
(9.32%)
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
  467214
  565107
  542934
  692859
  714447
  720825
  569684
  570056
  596650
  595863
  704010
  470926
  463166
  390923
  443156
  479765
  503870
  494362
  496965
  546627
  820225
  781687
  393701
  556849
  563207
  401124
  417276
  426725
  402340
  391581
  398957
  676472
  818083
  819047
  817660
  820079
  823910
  825682
  827978
  580241
  657030
  657025
  657643
  660513
  710957
  721552
  655718
  655752
  656728
  668648
  717699
  720824
  722443
  557326
  600042
  597585
  612022
  789885
  789202
  789401
  741029
  749940
  725914
  728351
  740494
  744508
  745760
  753815
  758033
  769766
  735594
  766043
  747476
  749896
  779523
  789829
  714455
  676473
  701501
  622111
  397279
  232953
  542942
  716835
  552859
  598443
  627748
  595363
  766536
  443686
  443706
  466187
  470785
  477958
  477980
  444142
  444258
  462579
  469844
  469898
  473252
  443673
  444001
  501845
  494382
  526111
  520300
  580640
  820298
  782217
  391968
  233321
  543694
  543738
  391475
  397410
  781701
  741047
  715425
  504744
]
2.42 ms
(1.45%)
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
  232953
  233321
  390923
  391475
  391581
  391968
  393701
  397279
  397410
  398957
  401124
  402340
  417276
  426725
  443156
  443673
  443686
  443706
  444001
  444142
  444258
  462579
  463166
  466187
  467214
  469844
  469898
  470785
  470926
  473252
  477958
  477980
  479765
  494362
  494382
  496965
  501845
  503870
  504744
  520300
  526111
  542934
  542942
  543694
  543738
  546627
  552859
  556849
  557326
  563207
  565107
  569684
  570056
  580241
  580640
  595363
  595863
  596650
  597585
  598443
  600042
  612022
  622111
  627748
  655718
  655752
  656728
  657025
  657030
  657643
  660513
  668648
  676472
  676473
  692859
  701501
  704010
  710957
  714447
  714455
  715425
  716835
  717699
  720824
  720825
  721552
  722443
  725914
  728351
  735594
  740494
  741029
  741047
  744508
  745760
  747476
  749896
  749940
  753815
  758033
  766043
  766536
  769766
  779523
  781687
  781701
  782217
  789202
  789401
  789829
  789885
  817660
  818083
  819047
  820079
  820225
  820298
  823910
  825682
  827978
]
2.29 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian old young"
]
2.21 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск old young"
]
1.50 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск old young"
]

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.