Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
215.42 ms
(58.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк kissing"
]
128.42 ms
(35.10%)
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
  261599
  390346
  418485
  444249
  472908
  473596
  484915
  490050
  490799
  512637
  521860
  527586
  532053
  534175
  535151
  537568
  544782
  569894
  570202
  570232
  570345
  570515
  570565
  570600
  571549
  572149
  572430
  573041
  573099
  573631
  573860
  574899
  575449
  584651
  596582
  621633
  628997
  631099
  652551
  652553
  652554
  653514
  654058
  654178
  654329
  654432
  657437
  659670
  659708
  665256
  665872
  667885
  668845
  670176
  670280
  670814
  671107
  671125
  671127
  671138
  673455
  673548
  673550
  673552
  673985
  675028
  675032
  675033
  675046
  679115
  679131
  681794
  684203
  685915
  692118
  694164
  701492
  705352
  709825
  717109
  719138
  722438
  723522
  723555
  724727
  730621
  730689
  731952
  736003
  737212
  737687
  740252
  740697
  741974
  742213
  743025
  743394
  744327
  746978
  747219
  747588
  748331
  750016
  753300
  753351
  753371
  753382
  753912
  754828
  775208
  782711
  784204
  787543
  795500
  800267
  816777
  817637
  818226
  819355
  819978
]
11.91 ms
(3.26%)
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
  747219
  418485
  472908
  782711
  668845
  571549
  573099
  671107
  670176
  670280
  657437
  673552
  800267
  631099
  473596
  573041
  730689
  753371
  675032
  673550
  723555
  572149
  570345
  652553
  673548
  659708
  775208
  784204
  754828
  816777
  819355
  681794
  675033
  694164
  675046
  787543
  737687
  748331
  484915
  537568
  570600
  701492
  671127
  679115
  685915
  659670
  675028
  665256
  671125
  673455
  679131
  753300
  737212
  740252
  743394
  819978
  512637
  535151
  652551
  654058
  665872
  692118
  652554
  705352
  722438
  628997
  596582
  795500
  736003
  741974
  753351
  753382
  744327
  753912
  709825
  490050
  544782
  574899
  673985
  573860
  570565
  575449
  570232
  570202
  671138
  654432
  654178
  570515
  724727
  743025
  621633
  527586
  490799
  534175
  719138
  670814
  653514
  654329
  747588
  731952
  742213
  730621
  750016
  390346
  569894
  740697
  261599
  723522
  532053
  572430
  584651
  717109
  667885
  684203
  573631
  746978
  444249
  818226
  817637
  521860
]
3.99 ms
(1.09%)
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
  261599
  390346
  418485
  444249
  472908
  473596
  484915
  490050
  490799
  512637
  521860
  527586
  532053
  534175
  535151
  537568
  544782
  569894
  570202
  570232
  570345
  570515
  570565
  570600
  571549
  572149
  572430
  573041
  573099
  573631
  573860
  574899
  575449
  584651
  596582
  621633
  628997
  631099
  652551
  652553
  652554
  653514
  654058
  654178
  654329
  654432
  657437
  659670
  659708
  665256
  665872
  667885
  668845
  670176
  670280
  670814
  671107
  671125
  671127
  671138
  673455
  673548
  673550
  673552
  673985
  675028
  675032
  675033
  675046
  679115
  679131
  681794
  684203
  685915
  692118
  694164
  701492
  705352
  709825
  717109
  719138
  722438
  723522
  723555
  724727
  730621
  730689
  731952
  736003
  737212
  737687
  740252
  740697
  741974
  742213
  743025
  743394
  744327
  746978
  747219
  747588
  748331
  750016
  753300
  753351
  753371
  753382
  753912
  754828
  775208
  782711
  784204
  787543
  795500
  800267
  816777
  817637
  818226
  819355
  819978
]
2.21 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girls kissing"
]
2.21 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк kissing"
]
1.75 ms
(0.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.