Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.07 ms
(86.43%)
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
  72519
  80035
  324579
  346907
  364076
  388423
  418225
  419127
  432430
  434087
  440486
  442604
  443522
  451465
  453266
  456610
  461842
  469402
  478662
  486886
  490732
  509772
  515295
  516220
  527467
  529622
  538060
  538926
  545641
  547033
  555165
  557152
  558430
  561571
  567889
  569768
  577666
  577667
  579808
  584083
  585397
  599682
  599798
  602665
  618749
  639686
  643366
  648872
  684989
  697392
  698111
  702936
  710880
  720532
  727384
  727439
  728456
  728651
  730185
  730469
  730499
  730727
  730743
  730959
  731182
  734103
  734247
  735578
  738029
  739739
  739762
  744693
  745477
  746442
  746580
  746589
  748411
  753494
  754463
  755830
  758138
  759889
  769223
  769226
  769932
  770535
  772513
  773781
  774152
  774163
  774359
  775135
  776798
  789572
  792463
  792538
  794554
  794564
  795929
  799046
  800348
  800482
  801451
  802246
  802595
  803743
  805923
  807885
  811423
  811426
  817489
  819112
  823623
  823939
  824137
  824570
  826732
  827064
  828455
  828677
]
13.22 ms
(7.42%)
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
  817489
  643366
  775135
  754463
  728456
  769932
  773781
  803743
  739762
  618749
  792538
  731182
  789572
  795929
  418225
  776798
  442604
  585397
  639686
  801451
  346907
  547033
  702936
  710880
  577667
  734247
  772513
  811426
  739739
  753494
  728651
  792463
  561571
  759889
  478662
  486886
  577666
  826732
  824137
  828455
  720532
  794554
  802246
  727384
  730743
  730959
  748411
  769223
  770535
  734103
  730469
  730185
  758138
  811423
  324579
  558430
  800348
  490732
  774163
  819112
  648872
  774152
  799046
  828677
  584083
  684989
  698111
  800482
  805923
  794564
  774359
  730499
  469402
  807885
  735578
  388423
  456610
  461842
  419127
  527467
  434087
  538060
  697392
  599798
  515295
  509772
  730727
  567889
  451465
  516220
  432430
  443522
  453266
  529622
  538926
  579808
  599682
  738029
  746442
  802595
  727439
  746580
  746589
  823939
  545641
  440486
  555165
  602665
  769226
  755830
  745477
  744693
  569768
  557152
  72519
  80035
  364076
  827064
  823623
  824570
]
2.91 ms
(1.63%)
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
  72519
  80035
  324579
  346907
  364076
  388423
  418225
  419127
  432430
  434087
  440486
  442604
  443522
  451465
  453266
  456610
  461842
  469402
  478662
  486886
  490732
  509772
  515295
  516220
  527467
  529622
  538060
  538926
  545641
  547033
  555165
  557152
  558430
  561571
  567889
  569768
  577666
  577667
  579808
  584083
  585397
  599682
  599798
  602665
  618749
  639686
  643366
  648872
  684989
  697392
  698111
  702936
  710880
  720532
  727384
  727439
  728456
  728651
  730185
  730469
  730499
  730727
  730743
  730959
  731182
  734103
  734247
  735578
  738029
  739739
  739762
  744693
  745477
  746442
  746580
  746589
  748411
  753494
  754463
  755830
  758138
  759889
  769223
  769226
  769932
  770535
  772513
  773781
  774152
  774163
  774359
  775135
  776798
  789572
  792463
  792538
  794554
  794564
  795929
  799046
  800348
  800482
  801451
  802246
  802595
  803743
  805923
  807885
  811423
  811426
  817489
  819112
  823623
  823939
  824137
  824570
  826732
  827064
  828455
  828677
]
2.34 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hand job milf"
]
2.16 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дрочк член milf"
]
1.66 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дрочк член milf"
]

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.