Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
224.21 ms
(91.97%)
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
  31422
  414749
  543869
  544781
  545728
  546798
  547984
  548459
  563470
  564794
  569372
  569709
  571960
  581296
  583447
  593524
  596290
  599849
  609246
  614576
  623281
  626174
  626853
  627200
  629218
  631403
  636372
  636783
  642293
  642410
  648221
  648741
  651840
  652841
  652905
  660763
  664450
  668158
  668552
  670463
  670783
  671769
  672029
  677001
  681456
  683269
  683485
  683897
  690769
  693340
  693448
  693878
  695602
  696141
  698233
  701202
  707602
  710463
  710918
  713414
  713498
  715179
  716948
  721082
  726054
  730498
  732611
  734269
  736819
  737547
  737895
  739588
  744015
  744796
  746826
  749074
  751030
  753689
  753969
  754710
  754733
  754805
  758630
  759809
  762068
  766329
  767242
  767908
  768191
  768915
  770931
  775287
  776814
  777085
  777339
  777997
  778439
  780414
  781954
  783537
  784181
  784829
  784868
  785759
  791349
  792019
  793067
  793093
  795405
  798281
  799078
  800391
  803777
  805246
  805394
  805817
  806678
  810958
  811579
  811784
]
10.81 ms
(4.44%)
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
  569372
  569709
  543869
  547984
  548459
  571960
  581296
  583447
  672029
  681456
  690769
  693448
  693878
  710463
  713498
  648221
  651840
  668158
  668552
  670463
  670783
  677001
  695602
  696141
  710918
  715179
  721082
  648741
  652841
  660763
  664450
  671769
  683269
  683485
  683897
  698233
  707602
  544781
  631403
  623281
  626174
  636372
  593524
  596290
  599849
  614576
  636783
  642410
  609246
  629218
  780414
  791349
  800391
  805246
  806678
  811579
  775287
  776814
  778439
  784868
  792019
  795405
  803777
  805394
  810958
  734269
  737895
  744015
  749074
  753689
  754733
  767242
  781954
  793093
  805817
  732611
  736819
  737547
  744796
  754805
  762068
  739588
  758630
  766329
  767908
  770931
  726054
  730498
  751030
  754710
  759809
  746826
  753969
  768191
  768915
  627200
  642293
  701202
  713414
  777085
  777339
  777997
  784829
  785759
  793067
  798281
  799078
  811784
  414749
  31422
  545728
  546798
  563470
  564794
  652905
  693340
  716948
  626853
  783537
  784181
]
2.62 ms
(1.08%)
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
  31422
  414749
  543869
  544781
  545728
  546798
  547984
  548459
  563470
  564794
  569372
  569709
  571960
  581296
  583447
  593524
  596290
  599849
  609246
  614576
  623281
  626174
  626853
  627200
  629218
  631403
  636372
  636783
  642293
  642410
  648221
  648741
  651840
  652841
  652905
  660763
  664450
  668158
  668552
  670463
  670783
  671769
  672029
  677001
  681456
  683269
  683485
  683897
  690769
  693340
  693448
  693878
  695602
  696141
  698233
  701202
  707602
  710463
  710918
  713414
  713498
  715179
  716948
  721082
  726054
  730498
  732611
  734269
  736819
  737547
  737895
  739588
  744015
  744796
  746826
  749074
  751030
  753689
  753969
  754710
  754733
  754805
  758630
  759809
  762068
  766329
  767242
  767908
  768191
  768915
  770931
  775287
  776814
  777085
  777339
  777997
  778439
  780414
  781954
  783537
  784181
  784829
  784868
  785759
  791349
  792019
  793067
  793093
  795405
  798281
  799078
  800391
  803777
  805246
  805394
  805817
  806678
  810958
  811579
  811784
]
1.76 ms
(0.72%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "длинные секс toys"
]
1.74 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "long sex toys"
]
1.34 ms
(0.55%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.30 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "длинные секс toys"
]

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.