Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.65 ms
(82.23%)
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
  53992
  90718
  118282
  145424
  163429
  399520
  403421
  411729
  411742
  418646
  422862
  424023
  431452
  435735
  445057
  445363
  447105
  447462
  449019
  461568
  464283
  468593
  469898
  471505
  472251
  473037
  473322
  476749
  477980
  479689
  485673
  491193
  492414
  498025
  498064
  508109
  508894
  513070
  515215
  516402
  521225
  528146
  530959
  531595
  531760
  534732
  540864
  545167
  547373
  548533
  548654
  551947
  556379
  559892
  562513
  562804
  566047
  566170
  569155
  571657
  573062
  573622
  573684
  573714
  574247
  577794
  578472
  581659
  581687
  581964
  583594
  584126
  584666
  587527
  590436
  595363
  595451
  596785
  598871
  607437
  617968
  624831
  629954
  631044
  638623
  649267
  660761
  665381
  676927
  676944
  678218
  684304
  716468
  722157
  724903
  727921
  730579
  735773
  735785
  737825
  744037
  744083
  744095
  748121
  749533
  753153
  764758
  764810
  775313
  787955
  792198
  793518
  796362
  797234
  800619
  809429
  809724
  813905
  817364
  818994
]
15.90 ms
(10.75%)
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
  559892
  479689
  447462
  530959
  722157
  547373
  792198
  737825
  676927
  163429
  548533
  508894
  531595
  649267
  660761
  678218
  793518
  735773
  744037
  744083
  118282
  607437
  473037
  545167
  631044
  468593
  411742
  540864
  485673
  583594
  753153
  764758
  724903
  403421
  727921
  676944
  573684
  566047
  584126
  498025
  629954
  515215
  581659
  574247
  590436
  573062
  581964
  477980
  431452
  447105
  775313
  748121
  796362
  797234
  735785
  764810
  749533
  809724
  562513
  491193
  813905
  473322
  521225
  551947
  584666
  556379
  624831
  638623
  595451
  595363
  809429
  744095
  53992
  418646
  476749
  469898
  800619
  435735
  449019
  492414
  472251
  516402
  471505
  569155
  562804
  577794
  581687
  665381
  548654
  578472
  596785
  587527
  598871
  422862
  399520
  445363
  513070
  498064
  531760
  534732
  617968
  571657
  818994
  817364
  716468
  787955
  730579
  528146
  145424
  411729
  445057
  464283
  508109
  566170
  573622
  573714
  684304
  424023
  90718
  461568
]
2.64 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
  53992
  90718
  118282
  145424
  163429
  399520
  403421
  411729
  411742
  418646
  422862
  424023
  431452
  435735
  445057
  445363
  447105
  447462
  449019
  461568
  464283
  468593
  469898
  471505
  472251
  473037
  473322
  476749
  477980
  479689
  485673
  491193
  492414
  498025
  498064
  508109
  508894
  513070
  515215
  516402
  521225
  528146
  530959
  531595
  531760
  534732
  540864
  545167
  547373
  548533
  548654
  551947
  556379
  559892
  562513
  562804
  566047
  566170
  569155
  571657
  573062
  573622
  573684
  573714
  574247
  577794
  578472
  581659
  581687
  581964
  583594
  584126
  584666
  587527
  590436
  595363
  595451
  596785
  598871
  607437
  617968
  624831
  629954
  631044
  638623
  649267
  660761
  665381
  676927
  676944
  678218
  684304
  716468
  722157
  724903
  727921
  730579
  735773
  735785
  737825
  744037
  744083
  744095
  748121
  749533
  753153
  764758
  764810
  775313
  787955
  792198
  793518
  796362
  797234
  800619
  809429
  809724
  813905
  817364
  818994
]
2.22 ms
(1.50%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.14 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "18- молодые киски"
]
1.82 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "18 молодые вагин"
]
1.57 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "18 молодые вагин"
]

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.