Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.12 ms
(83.50%)
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
  95557
  118109
  148176
  177385
  188266
  197389
  385752
  393872
  395805
  396657
  396711
  397013
  397307
  401591
  407313
  407683
  409930
  432596
  443491
  457972
  484205
  496346
  497703
  501754
  506254
  509192
  510794
  522949
  527457
  533045
  538760
  545505
  554463
  556643
  590839
  598344
  604140
  604287
  605320
  610806
  611930
  616457
  626292
  633508
  641160
  660340
  670765
  671748
  672184
  673459
  681304
  696989
  697774
  702142
  703038
  703534
  704255
  714567
  717947
  720087
  720362
  720798
  721004
  721312
  721338
  721428
  721429
  722701
  722719
  724203
  727643
  727770
  727825
  727895
  735462
  735866
  740637
  740893
  742928
  744976
  747153
  747154
  747498
  748965
  750554
  753473
  753481
  758721
  759533
  761086
  761326
  761555
  765270
  766523
  766596
  766735
  766811
  766817
  769802
  770129
  770256
  774176
  777124
  779589
  782629
  784493
  784569
  786330
  788847
  799413
  803679
  803919
  804014
  805848
  806104
  807539
  809910
  811629
  814386
]
14.78 ms
(9.87%)
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
  633508
  782629
  806104
  799413
  807539
  761086
  766596
  747153
  774176
  770129
  770256
  626292
  641160
  803679
  407313
  401591
  432596
  496346
  509192
  197389
  484205
  443491
  522949
  396711
  758721
  727895
  727825
  118109
  95557
  397013
  396657
  409930
  814386
  533045
  721428
  696989
  702142
  703038
  803919
  775033
  809910
  750554
  759533
  766523
  724203
  765270
  761326
  766735
  510794
  497703
  590839
  538760
  670765
  673459
  720087
  720362
  720798
  721338
  721429
  660340
  671748
  672184
  721004
  722701
  722719
  703534
  717947
  616457
  604287
  604140
  605320
  786330
  811629
  788847
  740893
  742928
  769802
  804014
  805848
  735866
  753473
  727643
  735462
  744976
  747154
  727770
  740637
  748965
  761555
  766811
  766817
  747498
  753481
  611930
  697774
  714567
  721312
  777124
  395805
  556643
  681304
  784493
  506254
  554463
  545505
  610806
  188266
  704255
  407683
  527457
  784569
  385752
  779589
  397307
  457972
  598344
  501754
  148176
  177385
  393872
]
3.09 ms
(2.06%)
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
  95557
  118109
  148176
  177385
  188266
  197389
  385752
  393872
  395805
  396657
  396711
  397013
  397307
  401591
  407313
  407683
  409930
  432596
  443491
  457972
  484205
  496346
  497703
  501754
  506254
  509192
  510794
  522949
  527457
  533045
  538760
  545505
  554463
  556643
  590839
  598344
  604140
  604287
  605320
  610806
  611930
  616457
  626292
  633508
  641160
  660340
  670765
  671748
  672184
  673459
  681304
  696989
  697774
  702142
  703038
  703534
  704255
  714567
  717947
  720087
  720362
  720798
  721004
  721312
  721338
  721428
  721429
  722701
  722719
  724203
  727643
  727770
  727825
  727895
  735462
  735866
  740637
  740893
  742928
  744976
  747153
  747154
  747498
  748965
  750554
  753473
  753481
  758721
  759533
  761086
  761326
  761555
  765270
  766523
  766596
  766735
  766811
  766817
  769802
  770129
  770256
  774176
  777124
  779589
  782629
  784493
  784569
  786330
  788847
  799413
  803679
  803919
  804014
  805848
  806104
  807539
  809910
  811629
  814386
]
2.09 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big pussy anal"
]
1.71 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие pussy анал"
]
1.53 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие pussy анал"
]
1.52 ms
(1.02%)
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.