Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.83 ms
(84.71%)
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
  444315
  452983
  453046
  469525
  542021
  542746
  542753
  543405
  553660
  583688
  586245
  591167
  591170
  595101
  603544
  624818
  625241
  632851
  638761
  638997
  640346
  645105
  648915
  653398
  653698
  653758
  654217
  654294
  660571
  707843
  710509
  710631
  723455
  726799
  727125
  730797
  731195
  731481
  732257
  733050
  741203
  742682
  744850
  744856
  746849
  747656
  749686
  749964
  752051
  757932
  759355
  759464
  761008
  762487
  765285
  765362
  765397
  765638
  765699
  765706
  765709
  765809
  766943
  767011
  767012
  767868
  768332
  768355
  768359
  768361
  768590
  772517
  773948
  773966
  773981
  775211
  775799
  776232
  778115
  778670
  781638
  784875
  784979
  785628
  785963
  789823
  789892
  790390
  790753
  797126
  797152
  797203
  799430
  800487
  804508
  804518
  806068
  806072
  809184
  809315
  809317
  809527
  810106
  812993
  812998
  813018
  813044
  814411
  814418
  821780
  821834
  821844
  821857
  821864
  824668
  825500
  825629
  825690
]
12.03 ms
(8.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
  809527
  710631
  821857
  825690
  767868
  730797
  778115
  797203
  784979
  765362
  542753
  638761
  542746
  452983
  821780
  768361
  768332
  767011
  768359
  775799
  632851
  813044
  732257
  825629
  543405
  653758
  800487
  775211
  645105
  591170
  749686
  790453
  765709
  765285
  444315
  767012
  762487
  790390
  806072
  785628
  595101
  744850
  747656
  773948
  809315
  784875
  781638
  804508
  809184
  744856
  812998
  731195
  789823
  648915
  625241
  746849
  785963
  810106
  653698
  790753
  773966
  812993
  806068
  765699
  583688
  749964
  757932
  768355
  653398
  765397
  824668
  791973
  542021
  776232
  813018
  733050
  778670
  591167
  797126
  469525
  814418
  789892
  765809
  603544
  654294
  624818
  804518
  814411
  821834
  821864
  660571
  586245
  638997
  797152
  799430
  741203
  727125
  742682
  759355
  768590
  773981
  731481
  710509
  809317
  723455
  761008
  766943
  825500
  772517
  553660
  752051
  765638
  707843
  654217
  759464
  453046
  765706
  726799
  640346
  821844
]
3.11 ms
(2.16%)
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
  444315
  452983
  453046
  469525
  542021
  542746
  542753
  543405
  553660
  583688
  586245
  591167
  591170
  595101
  603544
  624818
  625241
  632851
  638761
  638997
  640346
  645105
  648915
  653398
  653698
  653758
  654217
  654294
  660571
  707843
  710509
  710631
  723455
  726799
  727125
  730797
  731195
  731481
  732257
  733050
  741203
  742682
  744850
  744856
  746849
  747656
  749686
  749964
  752051
  757932
  759355
  759464
  761008
  762487
  765285
  765362
  765397
  765638
  765699
  765706
  765709
  765809
  766943
  767011
  767012
  767868
  768332
  768355
  768359
  768361
  768590
  772517
  773948
  773966
  773981
  775211
  775799
  776232
  778115
  778670
  781638
  784875
  784979
  785628
  785963
  789823
  789892
  790390
  790753
  797126
  797152
  797203
  799430
  800487
  804508
  804518
  806068
  806072
  809184
  809315
  809317
  809527
  810106
  812993
  812998
  813018
  813044
  814411
  814418
  821780
  821834
  821844
  821857
  821864
  824668
  825500
  825629
  825690
]
1.84 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал жмж секс втро онлифанс социальн сет"
]
1.78 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal ffm onlyfans"
]
1.58 ms
(1.10%)
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.