Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.12 ms
(83.33%)
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
  382498
  420509
  438659
  465724
  532344
  538518
  541810
  542671
  547234
  547380
  548049
  555029
  556592
  564652
  572234
  575619
  586181
  589577
  599623
  603473
  609510
  621776
  626572
  631446
  632147
  649598
  657825
  665346
  665456
  666130
  668798
  673853
  674294
  674625
  686248
  693665
  696892
  699136
  711531
  713120
  720087
  723294
  723770
  724819
  725063
  725116
  728326
  731679
  732072
  736685
  738677
  739451
  739833
  746914
  750233
  752240
  752383
  752388
  752787
  755151
  760396
  761009
  763996
  765007
  765799
  767630
  767932
  769643
  769855
  771909
  772846
  772944
  773019
  777421
  777832
  778204
  778397
  778420
  781500
  781619
  781950
  783610
  783963
  785173
  785225
  785338
  786202
  787418
  787792
  787936
  788391
  788737
  789484
  791736
  793255
  793778
  795521
  796604
  797210
  797851
  801938
  802015
  802395
  802577
  804444
  806699
  809597
  810199
  810748
  810925
  812681
  813329
  813477
  813669
  817395
  818062
  818247
  819751
  823440
  824360
]
16.51 ms
(10.34%)
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
  632147
  586181
  631446
  609510
  621776
  781619
  783963
  793778
  802015
  802395
  788737
  789484
  793255
  809597
  812681
  739833
  752240
  752388
  755151
  765007
  781500
  797851
  813477
  761009
  773019
  736685
  738677
  739451
  752787
  763996
  769643
  769855
  728326
  732072
  752383
  765799
  767932
  746914
  750233
  771909
  603473
  696892
  777832
  778204
  781950
  787418
  787936
  796604
  810748
  813329
  420509
  438659
  382498
  819751
  824360
  813669
  818062
  823440
  817395
  818247
  532344
  538518
  465724
  547234
  555029
  572234
  575619
  547380
  541810
  542671
  548049
  556592
  699136
  713120
  720087
  657825
  666130
  668798
  673853
  674625
  723294
  649598
  665346
  665456
  674294
  686248
  693665
  711531
  564652
  599623
  589577
  626572
  778397
  778420
  785173
  785225
  786202
  787792
  801938
  802577
  804444
  810925
  777421
  783610
  788391
  725116
  760396
  772846
  772944
  785338
  791736
  795521
  797210
  806699
  810199
  724819
  725063
  731679
  767630
  723770
]
2.93 ms
(1.83%)
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
  382498
  420509
  438659
  465724
  532344
  538518
  541810
  542671
  547234
  547380
  548049
  555029
  556592
  564652
  572234
  575619
  586181
  589577
  599623
  603473
  609510
  621776
  626572
  631446
  632147
  649598
  657825
  665346
  665456
  666130
  668798
  673853
  674294
  674625
  686248
  693665
  696892
  699136
  711531
  713120
  720087
  723294
  723770
  724819
  725063
  725116
  728326
  731679
  732072
  736685
  738677
  739451
  739833
  746914
  750233
  752240
  752383
  752388
  752787
  755151
  760396
  761009
  763996
  765007
  765799
  767630
  767932
  769643
  769855
  771909
  772846
  772944
  773019
  777421
  777832
  778204
  778397
  778420
  781500
  781619
  781950
  783610
  783963
  785173
  785225
  785338
  786202
  787418
  787792
  787936
  788391
  788737
  789484
  791736
  793255
  793778
  795521
  796604
  797210
  797851
  801938
  802015
  802395
  802577
  804444
  806699
  809597
  810199
  810748
  810925
  812681
  813329
  813477
  813669
  817395
  818062
  818247
  819751
  823440
  824360
]
2.01 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "very hair"
]
1.86 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "very hair"
]
1.46 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "very hair"
]

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.