Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.55 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
  325660
  382895
  393848
  404126
  415028
  415863
  418441
  419312
  419468
  420774
  420793
  428317
  429245
  433898
  433925
  434900
  435882
  435924
  436465
  436582
  440641
  440819
  440897
  441353
  441406
  442051
  442100
  447049
  450262
  450272
  450277
  450278
  450279
  451275
  451276
  452219
  452316
  453376
  454471
  454678
  457992
  458004
  459356
  460080
  460814
  464149
  464234
  465109
  467049
  467064
  467107
  468255
  469519
  472509
  473481
  475309
  475730
  476051
  478148
  482714
  482731
  487796
  489222
  489953
  498419
  498426
  502384
  509631
  513202
  517475
  517509
  519192
  521853
  525839
  528526
  537359
  537449
  541541
  541965
  547659
  548842
  548869
  552614
  562427
  576915
  577313
  581264
  583222
  583904
  584425
  591513
  591992
  592596
  592597
  592672
  594463
  595581
  595969
  598341
  600849
  602072
  617197
  638997
  640282
  655832
  728741
  733246
  734687
  739119
  755022
  755689
  756990
  777765
  787624
  796647
  796696
  796703
  811450
  813122
]
22.13 ms
(12.25%)
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
  591992
  734687
  528526
  502384
  537359
  513202
  382895
  404126
  440819
  441353
  442100
  450278
  450279
  451275
  459356
  489953
  517509
  464234
  584425
  548869
  552614
  541965
  547659
  655832
  598341
  617197
  638997
  595969
  640282
  777765
  733246
  739119
  762336
  755022
  755689
  728741
  756990
  433925
  434900
  435882
  460080
  478148
  325660
  441406
  442051
  415028
  419312
  452219
  464149
  467107
  475730
  450262
  450277
  451276
  457992
  467049
  482731
  498419
  509631
  460814
  581264
  541541
  562427
  577313
  576915
  583222
  595581
  591513
  602072
  796696
  796703
  813122
  796647
  811450
  436582
  458004
  467064
  468255
  419468
  440641
  473481
  476051
  436465
  393848
  428317
  454471
  472509
  420793
  435924
  447049
  489222
  517475
  519192
  482714
  453376
  452316
  525839
  498426
  537449
  594463
  429245
  548842
  592596
  592672
  600849
  592597
  787624
  433898
  583904
  420774
  415863
  418441
  440897
  450272
  454678
  469519
  465109
  475309
  487796
  521853
]
3.06 ms
(1.69%)
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
  325660
  382895
  393848
  404126
  415028
  415863
  418441
  419312
  419468
  420774
  420793
  428317
  429245
  433898
  433925
  434900
  435882
  435924
  436465
  436582
  440641
  440819
  440897
  441353
  441406
  442051
  442100
  447049
  450262
  450272
  450277
  450278
  450279
  451275
  451276
  452219
  452316
  453376
  454471
  454678
  457992
  458004
  459356
  460080
  460814
  464149
  464234
  465109
  467049
  467064
  467107
  468255
  469519
  472509
  473481
  475309
  475730
  476051
  478148
  482714
  482731
  487796
  489222
  489953
  498419
  498426
  502384
  509631
  513202
  517475
  517509
  519192
  521853
  525839
  528526
  537359
  537449
  541541
  541965
  547659
  548842
  548869
  552614
  562427
  576915
  577313
  581264
  583222
  583904
  584425
  591513
  591992
  592596
  592597
  592672
  594463
  595581
  595969
  598341
  600849
  602072
  617197
  638997
  640282
  655832
  728741
  733246
  734687
  739119
  755022
  755689
  756990
  777765
  787624
  796647
  796696
  796703
  811450
  813122
]
2.01 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.92 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pawg homemade"
]
1.68 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pawg домашн любительск"
]
1.31 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pawg домашн любительск"
]

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.