Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.43 ms
(83.04%)
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
  193890
  382057
  383343
  391669
  397188
  397912
  400861
  400998
  403308
  410861
  418669
  421820
  421836
  421847
  421885
  421889
  421898
  421902
  422345
  428128
  433388
  440723
  445302
  457990
  459086
  461843
  464659
  469372
  470109
  472679
  473194
  476981
  478652
  486190
  486578
  488457
  493179
  493471
  500781
  506222
  506860
  508450
  516792
  517023
  518956
  519350
  520377
  521137
  524862
  526454
  529157
  530329
  535437
  538005
  538831
  539262
  543176
  544462
  549846
  551118
  560008
  586124
  586150
  592227
  594884
  597047
  600377
  606628
  607181
  611766
  615352
  622354
  622930
  627181
  627880
  634559
  644781
  645365
  650630
  655211
  665205
  667993
  670181
  675405
  680833
  698859
  703428
  705531
  725635
  732408
  737614
  738265
  745749
  759907
  764149
  775640
  780902
  783992
  796157
  796730
  801012
  803145
  803377
  803547
  806174
  807134
  808379
  812701
  813412
  814613
  815408
  816853
  817840
  818741
  820680
  823274
  824585
  826160
  826649
]
19.03 ms
(11.17%)
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
  418669
  421885
  421898
  428128
  440723
  473194
  478652
  500781
  506860
  535437
  526454
  488457
  472679
  433388
  539262
  470109
  524862
  397912
  826160
  820680
  824585
  655211
  622354
  807134
  812701
  775640
  737614
  508450
  421820
  382057
  193890
  397188
  823274
  826649
  818741
  814613
  816853
  817840
  530329
  538831
  518956
  544462
  543176
  650630
  667993
  670181
  703428
  680833
  698859
  551118
  611766
  606628
  622930
  627880
  597047
  634559
  803377
  813412
  801012
  803547
  796157
  732408
  745749
  725635
  759907
  615352
  627181
  644781
  705531
  780902
  803145
  383343
  400861
  445302
  457990
  560008
  665205
  586124
  783992
  410861
  422345
  421836
  459086
  391669
  517023
  521137
  486190
  486578
  493179
  516792
  519350
  506222
  403308
  815408
  645365
  594884
  586150
  592227
  806174
  796730
  808379
  738265
  764149
  520377
  464659
  493471
  675405
  549846
  607181
  600377
  400998
  421902
  476981
  421847
  421889
  469372
  465885
  461843
  529157
  538005
]
2.74 ms
(1.61%)
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
  193890
  382057
  383343
  391669
  397188
  397912
  400861
  400998
  403308
  410861
  418669
  421820
  421836
  421847
  421885
  421889
  421898
  421902
  422345
  428128
  433388
  440723
  445302
  457990
  459086
  461843
  464659
  469372
  470109
  472679
  473194
  476981
  478652
  486190
  486578
  488457
  493179
  493471
  500781
  506222
  506860
  508450
  516792
  517023
  518956
  519350
  520377
  521137
  524862
  526454
  529157
  530329
  535437
  538005
  538831
  539262
  543176
  544462
  549846
  551118
  560008
  586124
  586150
  592227
  594884
  597047
  600377
  606628
  607181
  611766
  615352
  622354
  622930
  627181
  627880
  634559
  644781
  645365
  650630
  655211
  665205
  667993
  670181
  675405
  680833
  698859
  703428
  705531
  725635
  732408
  737614
  738265
  745749
  759907
  764149
  775640
  780902
  783992
  796157
  796730
  801012
  803145
  803377
  803547
  806174
  807134
  808379
  812701
  813412
  814613
  815408
  816853
  817840
  818741
  820680
  823274
  824585
  826160
  826649
]
1.88 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass mom doggy"
]
1.78 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп mom рак"
]
1.72 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп mom рак"
]

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.