Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.40 ms
(87.00%)
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
  108029
  461127
  498642
  502365
  509542
  522055
  530172
  540169
  541704
  544593
  544877
  546321
  546871
  550783
  553806
  558154
  563751
  566902
  571110
  572270
  576237
  584060
  592096
  593611
  595183
  610128
  610513
  610772
  612621
  616506
  619017
  621799
  622904
  626637
  627546
  628192
  628510
  628723
  629547
  630145
  632092
  633268
  633640
  634922
  636911
  640254
  641219
  643786
  650723
  653031
  656167
  656538
  670550
  670914
  686341
  687847
  691784
  692919
  693716
  696708
  702005
  703709
  703772
  704346
  708755
  710218
  710309
  710880
  720337
  724012
  725662
  727486
  728952
  729050
  729063
  730175
  732193
  734876
  734954
  735187
  742277
  742785
  748565
  748570
  749144
  750743
  759050
  762063
  765383
  767535
  767570
  768300
  768527
  769914
  770086
  770571
  771900
  773385
  778153
  779070
  780112
  780405
  780585
  784413
  786208
  787218
  790138
  790637
  790904
  792429
  793049
  793055
  797581
  798812
  799377
  803903
  808645
]
9.76 ms
(6.37%)
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
  593611
  633640
  787218
  734954
  767535
  771900
  558154
  584060
  768527
  793049
  592096
  498642
  610772
  546321
  550783
  641219
  797581
  766664
  750743
  732193
  734876
  742785
  803903
  502365
  540169
  546871
  610128
  627546
  799377
  727486
  749144
  696708
  704346
  710309
  622904
  628192
  792429
  735187
  748565
  769914
  786208
  728952
  762063
  634922
  790138
  108029
  509542
  530172
  576237
  650723
  653031
  693716
  670550
  670914
  686341
  703772
  595183
  610513
  616506
  628723
  636911
  628510
  633268
  780405
  790904
  729063
  793055
  729050
  763487
  770571
  730175
  765383
  767570
  703709
  798812
  656538
  708755
  621799
  790637
  773385
  770086
  773406
  612621
  780112
  544593
  626637
  759050
  808645
  643786
  572270
  742277
  725662
  768300
  710880
  778153
  566902
  656167
  691784
  522055
  553806
  544877
  748570
  461127
  541704
  724012
  619017
  630145
  779070
  784413
  563751
  702005
  720337
  692919
  710218
  687847
  571110
  640254
  632092
  629547
  780585
]
2.76 ms
(1.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
  108029
  461127
  498642
  502365
  509542
  522055
  530172
  540169
  541704
  544593
  544877
  546321
  546871
  550783
  553806
  558154
  563751
  566902
  571110
  572270
  576237
  584060
  592096
  593611
  595183
  610128
  610513
  610772
  612621
  616506
  619017
  621799
  622904
  626637
  627546
  628192
  628510
  628723
  629547
  630145
  632092
  633268
  633640
  634922
  636911
  640254
  641219
  643786
  650723
  653031
  656167
  656538
  670550
  670914
  686341
  687847
  691784
  692919
  693716
  696708
  702005
  703709
  703772
  704346
  708755
  710218
  710309
  710880
  720337
  724012
  725662
  727486
  728952
  729050
  729063
  730175
  732193
  734876
  734954
  735187
  742277
  742785
  748565
  748570
  749144
  750743
  759050
  762063
  765383
  767535
  767570
  768300
  768527
  769914
  770086
  770571
  771900
  773385
  778153
  779070
  780112
  780405
  780585
  784413
  786208
  787218
  790138
  790637
  790904
  792429
  793049
  793055
  797581
  798812
  799377
  803903
  808645
]
2.12 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð┤ðÁð▓ÐâÐêð║ð© ð▒ÐïÐüÐéÐÇð¥ ð║ð¥ð¢Ðçð░Ð%ÔǪ"
]
1.90 ms
(1.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк быстр сперм"
]
1.61 ms
(1.05%)
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.