Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.34 ms
(83.83%)
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
  7456
  14360
  162212
  390811
  397074
  417053
  445740
  468368
  468525
  469287
  501591
  504704
  509805
  524862
  530028
  530564
  530587
  531114
  531126
  531225
  531242
  532852
  533382
  533941
  534995
  542618
  544690
  554921
  558657
  558782
  561443
  562491
  563463
  565557
  576588
  586507
  591695
  592225
  596900
  597197
  609891
  617418
  617428
  617437
  620324
  631247
  632645
  634116
  639027
  641678
  643331
  644961
  645956
  648394
  648906
  649166
  650012
  651607
  653809
  660057
  662849
  663526
  666779
  673910
  674116
  674978
  676623
  678127
  681279
  681563
  681791
  692404
  705718
  710882
  716035
  716878
  717318
  718058
  718741
  719858
  720900
  721564
  723689
  725941
  738400
  738419
  741617
  752255
  755372
  757107
  758700
  764343
  770194
  771622
  773486
  787015
  789917
  792808
  795128
  805986
  812513
  814733
  817078
  819225
  819800
  820453
  821241
  821506
  821524
  821689
  821916
  822280
  822313
  822941
  822988
  823305
  823386
  823421
  823464
  826143
]
16.74 ms
(10.15%)
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
  812513
  792808
  738419
  787015
  758700
  764343
  755372
  718058
  417053
  644961
  814733
  531225
  531242
  524862
  531114
  532852
  509805
  674978
  681563
  596900
  617418
  597197
  639027
  717318
  445740
  591695
  397074
  681279
  7456
  14360
  819225
  817078
  821524
  820453
  822313
  819800
  821916
  822280
  542618
  561443
  648394
  653809
  660057
  710882
  645956
  692404
  720900
  716035
  718741
  592225
  609891
  586507
  620324
  643331
  789917
  795128
  805986
  723689
  741617
  752255
  757107
  770194
  773486
  725941
  738400
  771622
  468525
  533382
  531126
  530028
  534995
  469287
  565557
  562491
  651607
  678127
  716878
  676623
  641678
  617437
  632645
  634116
  617428
  631247
  501591
  162212
  390811
  822941
  826143
  823464
  822988
  823305
  823386
  823421
  821241
  821506
  821689
  533941
  530587
  504704
  530564
  468368
  576588
  558657
  558782
  544690
  554921
  563463
  673910
  705718
  649166
  662849
  663526
  681791
  719858
  721564
  648906
  650012
  666779
  674116
]
2.80 ms
(1.70%)
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
  7456
  14360
  162212
  390811
  397074
  417053
  445740
  468368
  468525
  469287
  501591
  504704
  509805
  524862
  530028
  530564
  530587
  531114
  531126
  531225
  531242
  532852
  533382
  533941
  534995
  542618
  544690
  554921
  558657
  558782
  561443
  562491
  563463
  565557
  576588
  586507
  591695
  592225
  596900
  597197
  609891
  617418
  617428
  617437
  620324
  631247
  632645
  634116
  639027
  641678
  643331
  644961
  645956
  648394
  648906
  649166
  650012
  651607
  653809
  660057
  662849
  663526
  666779
  673910
  674116
  674978
  676623
  678127
  681279
  681563
  681791
  692404
  705718
  710882
  716035
  716878
  717318
  718058
  718741
  719858
  720900
  721564
  723689
  725941
  738400
  738419
  741617
  752255
  755372
  757107
  758700
  764343
  770194
  771622
  773486
  787015
  789917
  792808
  795128
  805986
  812513
  814733
  817078
  819225
  819800
  820453
  821241
  821506
  821524
  821689
  821916
  822280
  822313
  822941
  822988
  823305
  823386
  823421
  823464
  826143
]
2.14 ms
(1.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "black длинные hair"
]
2.00 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "black long hair"
]
1.53 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "black длинные 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.