Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.14 ms
(83.05%)
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
  365871
  389150
  389193
  391557
  391564
  395378
  423983
  438736
  442027
  457001
  464924
  468344
  471552
  480796
  481504
  485343
  486830
  488466
  490127
  496555
  496726
  501068
  502036
  506486
  506672
  507158
  510604
  513811
  530617
  539930
  542297
  551660
  551691
  557794
  558865
  567600
  571156
  581257
  583988
  584003
  584840
  586075
  595326
  602432
  613580
  620938
  624143
  624969
  625503
  628671
  634697
  640233
  641351
  646052
  653006
  660340
  662469
  666677
  668133
  671906
  673496
  675494
  675495
  677265
  682908
  685372
  687441
  691182
  692475
  693789
  693794
  696297
  697465
  699828
  703687
  704034
  704422
  705139
  707591
  707604
  710479
  712653
  716984
  717412
  723819
  724027
  727407
  732793
  734401
  734620
  736480
  739071
  740173
  741723
  748459
  752131
  758949
  762380
  768657
  768745
  771442
  779266
  780711
  780802
  781279
  783630
  787676
  789466
  790080
  791490
  793819
  795130
  797012
  810384
  811231
  811599
  813833
  819334
  819751
  827432
]
18.09 ms
(10.80%)
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
  513811
  539930
  502036
  542297
  557794
  558865
  571156
  584840
  671906
  693789
  699828
  703687
  716984
  666677
  677265
  682908
  685372
  692475
  697465
  705139
  712653
  653006
  668133
  675494
  707604
  584003
  625503
  628671
  634697
  602432
  624143
  595326
  641351
  586075
  620938
  781279
  793819
  810384
  811231
  811599
  779266
  780711
  797012
  723819
  724027
  736480
  758949
  783630
  787676
  790080
  791490
  734401
  734620
  739071
  740173
  762380
  768657
  771442
  727407
  741723
  768745
  748459
  613580
  624969
  707591
  710479
  780802
  795130
  365871
  423983
  468344
  471552
  480796
  481504
  496726
  506486
  490127
  501068
  391557
  389193
  464924
  640233
  752131
  485343
  691182
  662469
  789466
  732793
  389150
  696297
  704422
  567600
  395378
  391564
  438736
  442027
  819751
  827432
  813833
  819334
  486830
  457001
  507158
  530617
  506672
  510604
  496555
  488466
  551660
  551691
  581257
  583988
  646052
  673496
  675495
  687441
  693794
  704034
  717412
  660340
]
2.48 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife couple"
]
2.23 ms
(1.33%)
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
  365871
  389150
  389193
  391557
  391564
  395378
  423983
  438736
  442027
  457001
  464924
  468344
  471552
  480796
  481504
  485343
  486830
  488466
  490127
  496555
  496726
  501068
  502036
  506486
  506672
  507158
  510604
  513811
  530617
  539930
  542297
  551660
  551691
  557794
  558865
  567600
  571156
  581257
  583988
  584003
  584840
  586075
  595326
  602432
  613580
  620938
  624143
  624969
  625503
  628671
  634697
  640233
  641351
  646052
  653006
  660340
  662469
  666677
  668133
  671906
  673496
  675494
  675495
  677265
  682908
  685372
  687441
  691182
  692475
  693789
  693794
  696297
  697465
  699828
  703687
  704034
  704422
  705139
  707591
  707604
  710479
  712653
  716984
  717412
  723819
  724027
  727407
  732793
  734401
  734620
  736480
  739071
  740173
  741723
  748459
  752131
  758949
  762380
  768657
  768745
  771442
  779266
  780711
  780802
  781279
  783630
  787676
  789466
  790080
  791490
  793819
  795130
  797012
  810384
  811231
  811599
  813833
  819334
  819751
  827432
]
1.98 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен couple"
]
1.90 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен couple"
]
1.71 ms
(1.02%)
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.