Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.76 ms
(74.72%)
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
  57971
  233618
  274758
  382021
  395434
  396931
  397977
  401391
  425587
  426233
  487528
  533954
  536211
  536508
  550771
  555010
  569809
  590154
  591516
  593056
  625032
  625231
  626382
  627126
  630379
  633174
  638757
  644757
  654599
  689180
  693683
  698920
  702936
  703255
  703485
  710208
  711918
  712648
  713073
  714392
  715442
  716602
  717103
  717806
  723196
  724806
  724829
  725646
  728983
  729252
  731646
  733429
  734264
  734412
  734607
  737259
  738543
  738864
  738887
  740666
  742509
  742562
  744771
  746286
  747273
  748107
  751780
  753778
  757686
  758310
  758604
  760677
  761918
  762253
  763412
  763524
  763767
  763844
  764262
  765978
  766370
  766934
  767908
  768634
  768721
  768853
  769046
  770098
  770729
  771424
  772570
  773809
  774299
  777873
  778478
  779819
  782067
  783178
  783210
  787677
  789282
  794735
  795606
  796316
  797309
  797357
  800053
  800939
  801448
  801932
  801997
  802401
  803161
  803194
  804043
  804131
  804233
  804546
  824825
  827711
]
32.43 ms
(19.12%)
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
  761918
  762253
  765978
  766370
  768634
  769046
  724829
  728983
  731646
  747273
  751780
  753778
  757686
  758604
  767908
  738543
  760677
  763412
  763524
  763844
  766934
  768721
  770098
  724806
  740666
  742509
  742562
  748107
  763767
  764262
  770729
  773809
  625032
  625231
  626382
  627126
  644757
  703255
  703485
  711918
  713073
  714392
  715442
  716602
  717103
  717806
  723196
  777873
  778478
  779819
  782067
  783178
  789282
  794735
  797309
  797357
  800939
  801997
  803161
  804131
  233618
  382021
  397977
  738864
  396931
  487528
  533954
  536211
  536508
  710208
  693683
  698920
  702936
  555010
  590154
  593056
  638757
  800053
  801932
  803194
  801448
  804233
  725646
  744771
  746286
  758310
  771424
  783210
  787677
  796316
  729252
  734264
  734412
  734607
  738887
  774299
  768853
  733429
  630379
  804043
  426233
  425587
  654599
  712648
  689180
  591516
  795606
  802401
  804546
  57971
  274758
  569809
  550771
  633174
  737259
  772570
  395434
  401391
  827711
  824825
]
2.36 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife hot"
]
2.29 ms
(1.35%)
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
  57971
  233618
  274758
  382021
  395434
  396931
  397977
  401391
  425587
  426233
  487528
  533954
  536211
  536508
  550771
  555010
  569809
  590154
  591516
  593056
  625032
  625231
  626382
  627126
  630379
  633174
  638757
  644757
  654599
  689180
  693683
  698920
  702936
  703255
  703485
  710208
  711918
  712648
  713073
  714392
  715442
  716602
  717103
  717806
  723196
  724806
  724829
  725646
  728983
  729252
  731646
  733429
  734264
  734412
  734607
  737259
  738543
  738864
  738887
  740666
  742509
  742562
  744771
  746286
  747273
  748107
  751780
  753778
  757686
  758310
  758604
  760677
  761918
  762253
  763412
  763524
  763767
  763844
  764262
  765978
  766370
  766934
  767908
  768634
  768721
  768853
  769046
  770098
  770729
  771424
  772570
  773809
  774299
  777873
  778478
  779819
  782067
  783178
  783210
  787677
  789282
  794735
  795606
  796316
  797309
  797357
  800053
  800939
  801448
  801932
  801997
  802401
  803161
  803194
  804043
  804131
  804233
  804546
  824825
  827711
]
2.14 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.99 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен hot"
]
1.68 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен hot"
]

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.