Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.85 ms
(56.66%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
140.14 ms
(37.84%)
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
  402892
  523986
  529357
  594413
  606282
  608439
  608609
  630821
  633649
  644022
  683034
  691469
  696291
  701005
  703715
  703729
  705084
  712359
  714421
  714569
  714980
  715001
  718053
  718463
  718583
  718629
  720169
  721691
  723091
  723957
  724735
  724817
  724894
  725054
  725060
  725088
  725545
  726848
  727260
  728513
  728633
  728837
  728949
  729045
  730119
  730185
  730215
  730974
  731277
  733190
  733952
  734102
  734296
  734340
  735428
  735735
  736643
  737807
  738328
  738330
  738829
  739240
  739544
  739633
  739662
  743001
  743793
  744056
  744841
  745534
  745944
  746393
  746637
  746745
  747990
  747994
  748406
  750144
  750635
  750902
  751192
  753218
  753524
  754115
  755207
  755464
  757902
  758683
  760231
  761440
  763250
  763573
  763644
  764418
  765034
  772773
  774933
  781111
  781465
  786466
  786841
  793139
  796701
  797913
  799056
  801528
  801998
  802618
  803421
  808828
  810044
  813527
  816651
  821126
  824812
  825005
  825648
  826588
  828570
]
11.90 ms
(3.21%)
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
  796701
  801528
  801998
  725060
  725088
  725545
  726848
  728633
  730215
  735428
  743001
  746393
  746745
  750635
  753218
  758683
  761440
  763573
  772773
  786466
  786832
  786841
  793139
  797913
  808828
  813527
  724817
  727260
  728513
  728949
  730974
  731277
  734340
  737807
  738328
  739633
  744841
  747990
  747994
  750902
  754115
  723957
  729045
  733952
  735735
  736643
  738829
  739240
  739662
  745534
  748406
  753524
  755207
  760231
  765034
  728837
  733190
  739544
  746637
  751192
  757902
  763250
  764418
  724735
  725054
  730119
  730185
  738330
  743793
  744056
  745944
  750144
  755464
  763644
  608439
  633649
  644022
  703715
  703729
  712359
  714421
  714569
  714980
  718053
  718463
  718583
  718629
  720169
  774933
  781111
  781465
  799056
  802618
  803421
  810044
  402892
  824812
  816651
  821126
  825005
  825648
  826588
  828570
  523986
  529357
  691469
  696291
  701005
  721691
  723091
  705084
  683034
  715001
  594413
  606282
  608609
  630821
  724894
  734102
  734296
]
2.95 ms
(0.80%)
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
  402892
  523986
  529357
  594413
  606282
  608439
  608609
  630821
  633649
  644022
  683034
  691469
  696291
  701005
  703715
  703729
  705084
  712359
  714421
  714569
  714980
  715001
  718053
  718463
  718583
  718629
  720169
  721691
  723091
  723957
  724735
  724817
  724894
  725054
  725060
  725088
  725545
  726848
  727260
  728513
  728633
  728837
  728949
  729045
  730119
  730185
  730215
  730974
  731277
  733190
  733952
  734102
  734296
  734340
  735428
  735735
  736643
  737807
  738328
  738330
  738829
  739240
  739544
  739633
  739662
  743001
  743793
  744056
  744841
  745534
  745944
  746393
  746637
  746745
  747990
  747994
  748406
  750144
  750635
  750902
  751192
  753218
  753524
  754115
  755207
  755464
  757902
  758683
  760231
  761440
  763250
  763573
  763644
  764418
  765034
  772773
  774933
  781111
  781465
  786466
  786841
  793139
  796701
  797913
  799056
  801528
  801998
  802618
  803421
  808828
  810044
  813527
  816651
  821126
  824812
  825005
  825648
  826588
  828570
]
2.01 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cock cum"
]
1.88 ms
(0.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cock cum"
]
1.66 ms
(0.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cock cum"
]

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.