Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.87 ms
(84.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
  382138
  417955
  423953
  435454
  456524
  457338
  458814
  463197
  470087
  479010
  479225
  484023
  487068
  487217
  488773
  491365
  491686
  499179
  499368
  501991
  504428
  506810
  507626
  508872
  508881
  508966
  508989
  509560
  510822
  512922
  513124
  514147
  515391
  515980
  518760
  522163
  524717
  526000
  526536
  528199
  529883
  530358
  530362
  530670
  535562
  538804
  539101
  545959
  546006
  551018
  551256
  551984
  556970
  559198
  561008
  565825
  565842
  567223
  567725
  569761
  569762
  569779
  570927
  573867
  574810
  575093
  575103
  575469
  575482
  575483
  575496
  575520
  576063
  576348
  576361
  578785
  580262
  581330
  590481
  590713
  591730
  594553
  595536
  597113
  600402
  603071
  623842
  631044
  642212
  644648
  646934
  649291
  706457
  716756
  717990
  735727
  739868
  740336
  747236
  763281
  764484
  766687
  769970
  773606
  784286
  784775
  785484
  795385
  802947
  804191
  808997
  810596
  811508
  811773
  812573
  816994
  817117
  817186
  827551
  827840
]
15.69 ms
(9.43%)
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
  569779
  570927
  575520
  576348
  576361
  545959
  546006
  575483
  590713
  591730
  456524
  518760
  512922
  508872
  508881
  491686
  817117
  501991
  507626
  649291
  594553
  784286
  802947
  785484
  811508
  479010
  423953
  487217
  513124
  551018
  644648
  769970
  773606
  530670
  509560
  526536
  827551
  538804
  716756
  740336
  735727
  551256
  766687
  539101
  484023
  646934
  526000
  717990
  567725
  556970
  565825
  590481
  747236
  488773
  580262
  470087
  514147
  575482
  569761
  559198
  565842
  491365
  522163
  528199
  510822
  569762
  595536
  795385
  784775
  811773
  763281
  739868
  804191
  810596
  515980
  458814
  508966
  499368
  499179
  479225
  574810
  706457
  561008
  631044
  812573
  764484
  463197
  457338
  435454
  504428
  487068
  515391
  817186
  530358
  530362
  382138
  827840
  529883
  535562
  506810
  573867
  642212
  603071
  551984
  567223
  576063
  575093
  575469
  575496
  578785
  575103
  597113
  600402
  623842
  808997
  417955
  524717
  508989
  816994
  581330
]
2.96 ms
(1.78%)
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
  382138
  417955
  423953
  435454
  456524
  457338
  458814
  463197
  470087
  479010
  479225
  484023
  487068
  487217
  488773
  491365
  491686
  499179
  499368
  501991
  504428
  506810
  507626
  508872
  508881
  508966
  508989
  509560
  510822
  512922
  513124
  514147
  515391
  515980
  518760
  522163
  524717
  526000
  526536
  528199
  529883
  530358
  530362
  530670
  535562
  538804
  539101
  545959
  546006
  551018
  551256
  551984
  556970
  559198
  561008
  565825
  565842
  567223
  567725
  569761
  569762
  569779
  570927
  573867
  574810
  575093
  575103
  575469
  575482
  575483
  575496
  575520
  576063
  576348
  576361
  578785
  580262
  581330
  590481
  590713
  591730
  594553
  595536
  597113
  600402
  603071
  623842
  631044
  642212
  644648
  646934
  649291
  706457
  716756
  717990
  735727
  739868
  740336
  747236
  763281
  764484
  766687
  769970
  773606
  784286
  784775
  785484
  795385
  802947
  804191
  808997
  810596
  811508
  811773
  812573
  816994
  817117
  817186
  827551
  827840
]
2.27 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bdsm girl"
]
1.97 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бдсм девушк"
]
1.96 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.96%)
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.