Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.65 ms
(87.59%)
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
  102626
  182185
  416007
  418128
  418730
  424028
  431747
  450076
  460382
  473535
  478101
  484268
  500874
  511355
  514017
  517806
  522935
  527670
  531291
  541755
  544036
  550926
  555292
  556898
  564243
  582822
  583347
  583727
  588034
  588538
  597845
  598220
  605087
  608003
  610131
  627472
  629606
  635270
  640948
  652777
  657236
  659449
  669946
  678872
  681491
  683275
  686138
  701658
  709660
  710895
  712962
  714097
  716229
  722059
  728903
  728916
  728926
  738460
  738679
  738684
  740848
  741217
  741222
  744150
  744151
  748623
  748637
  750582
  751315
  751705
  763922
  766156
  766157
  766347
  766378
  767390
  767479
  771623
  771884
  773055
  773056
  776064
  778230
  780038
  780333
  783893
  784984
  785109
  785113
  785678
  785780
  791999
  792665
  793115
  794674
  795024
  800381
  800755
  801628
  803579
  803606
  803986
  806597
  807009
  807010
  807585
  808262
  808269
  808644
  809626
  809696
  810082
  810127
  810281
  811343
  812964
  814175
  824798
  825058
  826768
]
13.57 ms
(7.31%)
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
  795024
  766378
  763922
  738684
  701658
  810281
  683275
  629606
  582822
  605087
  780333
  450076
  807009
  803986
  424028
  659449
  681491
  564243
  807585
  783893
  808644
  751315
  748637
  744151
  771884
  750582
  767390
  709660
  800381
  588538
  511355
  500874
  678872
  608003
  597845
  814175
  583347
  555292
  517806
  808269
  776064
  793115
  800755
  803579
  784984
  766347
  810127
  714097
  544036
  728916
  610131
  473535
  716229
  588034
  741217
  431747
  182185
  785678
  460382
  810082
  766156
  478101
  794674
  806597
  780038
  740848
  773056
  826768
  722059
  773055
  484268
  522935
  803606
  809626
  640948
  669946
  712962
  527670
  102626
  824798
  825058
  791999
  416007
  418730
  686138
  635270
  767479
  811343
  741222
  748623
  751705
  807010
  418128
  541755
  710895
  583727
  785113
  792665
  812964
  514017
  531291
  652777
  657236
  744150
  598220
  550926
  627472
  778230
  785780
  738460
  801628
  808262
  728903
  771623
  738679
  728926
  766157
  785109
  809696
  556898
]
2.57 ms
(1.38%)
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
  102626
  182185
  416007
  418128
  418730
  424028
  431747
  450076
  460382
  473535
  478101
  484268
  500874
  511355
  514017
  517806
  522935
  527670
  531291
  541755
  544036
  550926
  555292
  556898
  564243
  582822
  583347
  583727
  588034
  588538
  597845
  598220
  605087
  608003
  610131
  627472
  629606
  635270
  640948
  652777
  657236
  659449
  669946
  678872
  681491
  683275
  686138
  701658
  709660
  710895
  712962
  714097
  716229
  722059
  728903
  728916
  728926
  738460
  738679
  738684
  740848
  741217
  741222
  744150
  744151
  748623
  748637
  750582
  751315
  751705
  763922
  766156
  766157
  766347
  766378
  767390
  767479
  771623
  771884
  773055
  773056
  776064
  778230
  780038
  780333
  783893
  784984
  785109
  785113
  785678
  785780
  791999
  792665
  793115
  794674
  795024
  800381
  800755
  801628
  803579
  803606
  803986
  806597
  807009
  807010
  807585
  808262
  808269
  808644
  809626
  809696
  810082
  810127
  810281
  811343
  812964
  814175
  824798
  825058
  826768
]
1.99 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "squirt homemade"
]
1.79 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сквирт оргазм домашн любительск"
]
1.69 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сквирт оргазм домашн любительск"
]

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.