Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.00 ms
(84.73%)
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
  73246
  221799
  311201
  383541
  387953
  391394
  394704
  406330
  414088
  426224
  426256
  441788
  442088
  456890
  457167
  459976
  482144
  496589
  499359
  508258
  513323
  536421
  538527
  540092
  541270
  546046
  553440
  553749
  554101
  554795
  554860
  554866
  555670
  558777
  583547
  589221
  591558
  595316
  600335
  604405
  610044
  613651
  615358
  618644
  619533
  620061
  630233
  638872
  640847
  650519
  651423
  653907
  660583
  662074
  664772
  673328
  677724
  681002
  681140
  705472
  706381
  710516
  711628
  713449
  714895
  715517
  726455
  726768
  726906
  726966
  727743
  727778
  730301
  730943
  731032
  731254
  735805
  742712
  744086
  744952
  750233
  750374
  750747
  755589
  756310
  759860
  759891
  769624
  774427
  774672
  775228
  775888
  776176
  781455
  790817
  790842
  794927
  795331
  795752
  796139
  796571
  796718
  796726
  802253
  802554
  803157
  805352
  809242
  812391
  813887
  814962
  815141
  817063
  817119
  817948
  818106
  818281
  824496
  825457
]
15.18 ms
(8.75%)
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
  750233
  756310
  759860
  769624
  604405
  710516
  795752
  796718
  803157
  805352
  809242
  394704
  499359
  426256
  536421
  583547
  553440
  664772
  714895
  775228
  727743
  796139
  759891
  726455
  727778
  731254
  610044
  790842
  383541
  221799
  311201
  73246
  391394
  387953
  406330
  426224
  441788
  414088
  442088
  817948
  774427
  813887
  815141
  817063
  818106
  824496
  814962
  818281
  825457
  817119
  457167
  456890
  508258
  496589
  540092
  513323
  538527
  459976
  482144
  553749
  554860
  554866
  541270
  546559
  558777
  554795
  555670
  650519
  651423
  660583
  715517
  673328
  706381
  653907
  662074
  677724
  681002
  681140
  705472
  711628
  713449
  546046
  554101
  615358
  638872
  595316
  618644
  620061
  589221
  600335
  619533
  630233
  591558
  613651
  640847
  774672
  781455
  790817
  794927
  802253
  812391
  775888
  776176
  796726
  802554
  744086
  744952
  750374
  755589
  795331
  796571
  730301
  730943
  731032
  735805
  750747
  726906
  726966
  742712
  726768
]
2.82 ms
(1.62%)
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
  73246
  221799
  311201
  383541
  387953
  391394
  394704
  406330
  414088
  426224
  426256
  441788
  442088
  456890
  457167
  459976
  482144
  496589
  499359
  508258
  513323
  536421
  538527
  540092
  541270
  546046
  553440
  553749
  554101
  554795
  554860
  554866
  555670
  558777
  583547
  589221
  591558
  595316
  600335
  604405
  610044
  613651
  615358
  618644
  619533
  620061
  630233
  638872
  640847
  650519
  651423
  653907
  660583
  662074
  664772
  673328
  677724
  681002
  681140
  705472
  706381
  710516
  711628
  713449
  714895
  715517
  726455
  726768
  726906
  726966
  727743
  727778
  730301
  730943
  731032
  731254
  735805
  742712
  744086
  744952
  750233
  750374
  750747
  755589
  756310
  759860
  759891
  769624
  774427
  774672
  775228
  775888
  776176
  781455
  790817
  790842
  794927
  795331
  795752
  796139
  796571
  796718
  796726
  802253
  802554
  803157
  805352
  809242
  812391
  813887
  814962
  815141
  817063
  817119
  817948
  818106
  818281
  824496
  825457
]
2.24 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf slut"
]
2.15 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf slut"
]
2.14 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf slut"
]
1.97 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.