Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
199.76 ms
(89.04%)
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
  58237
  58336
  389760
  408316
  426218
  427408
  476539
  539544
  545068
  552301
  557001
  557269
  560035
  560090
  564820
  578807
  579558
  586216
  602005
  603625
  606839
  606852
  606991
  607010
  607025
  620513
  622707
  622845
  625026
  627206
  627768
  633556
  633856
  638542
  651040
  651268
  664808
  665865
  665887
  667208
  667562
  672846
  677921
  682525
  692733
  695773
  702978
  704673
  705111
  707456
  714917
  716312
  717036
  718884
  720086
  721156
  721946
  721978
  725087
  726602
  726842
  728650
  730670
  731197
  732154
  733195
  733900
  736863
  742763
  744261
  746107
  748441
  749218
  749756
  752056
  755780
  757094
  757688
  759965
  761506
  763964
  766462
  768472
  774291
  780520
  784223
  785679
  787027
  787052
  788819
  789141
  789266
  789267
  790318
  791196
  793649
  794005
  795536
  796434
  796468
  799886
  800928
  801373
  804854
  807394
  810679
  811121
  811927
  813028
  814104
  817249
  818753
  819952
  820164
  821686
  823269
  824733
  825457
]
14.82 ms
(6.61%)
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
  602005
  622845
  606991
  607025
  789141
  789266
  793649
  804854
  811927
  725087
  728650
  787052
  790318
  794005
  800928
  733900
  731197
  755780
  768472
  730670
  744261
  752056
  757688
  757837
  742763
  627206
  702978
  721946
  427408
  408316
  603625
  761506
  665887
  638542
  780520
  825457
  667562
  682525
  633556
  620513
  785679
  810679
  733195
  801373
  821686
  819952
  560090
  692733
  667208
  677921
  557001
  811121
  799886
  726842
  749218
  766462
  749756
  757094
  622707
  784223
  785027
  58336
  814104
  823269
  820164
  552301
  545068
  560035
  665865
  695773
  718884
  721978
  672846
  704673
  705111
  717036
  707456
  606852
  607010
  627768
  787027
  788819
  791196
  796468
  796434
  807394
  813028
  759965
  736863
  774291
  726602
  748441
  732154
  746107
  763964
  606839
  625026
  716312
  721156
  789267
  795536
  389760
  58237
  426218
  818753
  817249
  824733
  476539
  539544
  557269
  564820
  651040
  651268
  664808
  714917
  720086
  578807
  579558
  586216
  633856
]
2.87 ms
(1.28%)
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
  58237
  58336
  389760
  408316
  426218
  427408
  476539
  539544
  545068
  552301
  557001
  557269
  560035
  560090
  564820
  578807
  579558
  586216
  602005
  603625
  606839
  606852
  606991
  607010
  607025
  620513
  622707
  622845
  625026
  627206
  627768
  633556
  633856
  638542
  651040
  651268
  664808
  665865
  665887
  667208
  667562
  672846
  677921
  682525
  692733
  695773
  702978
  704673
  705111
  707456
  714917
  716312
  717036
  718884
  720086
  721156
  721946
  721978
  725087
  726602
  726842
  728650
  730670
  731197
  732154
  733195
  733900
  736863
  742763
  744261
  746107
  748441
  749218
  749756
  752056
  755780
  757094
  757688
  759965
  761506
  763964
  766462
  768472
  774291
  780520
  784223
  785679
  787027
  787052
  788819
  789141
  789266
  789267
  790318
  791196
  793649
  794005
  795536
  796434
  796468
  799886
  800928
  801373
  804854
  807394
  810679
  811121
  811927
  813028
  814104
  817249
  818753
  819952
  820164
  821686
  823269
  824733
  825457
]
2.02 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex cheating"
]
1.88 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс cheating"
]
1.41 ms
(0.63%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс cheating"
]

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.