Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.11 ms
(85.21%)
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
  12132
  14387
  31106
  177739
  381789
  382556
  384811
  389891
  393355
  395325
  398047
  398230
  401157
  401811
  401840
  401865
  403559
  403759
  409701
  411223
  418531
  422285
  451827
  458992
  461361
  464900
  469105
  479874
  485066
  486236
  539233
  545217
  557959
  571054
  588278
  600543
  603220
  605317
  608423
  625765
  626729
  630679
  632656
  635436
  636258
  642723
  646001
  647891
  649114
  660106
  665921
  670227
  672161
  675633
  710837
  720379
  723559
  724860
  726301
  731971
  731990
  732326
  737589
  749456
  749629
  750884
  752442
  758511
  760939
  765761
  769502
  772675
  772892
  773813
  774470
  774559
  775754
  784823
  790801
  792182
  792625
  793425
  793448
  795054
  797429
  797456
  798517
  800177
  800209
  801372
  801666
  806158
  806210
  808081
  810214
  810248
  810249
  810591
  810993
  811075
  811542
  811592
  813879
  814958
  818179
  819122
  820032
  820342
  820501
  821012
  821113
  821642
  821643
  822181
  822560
  822615
  822653
  822668
  823304
  826100
]
11.72 ms
(8.18%)
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
  798517
  393355
  382556
  401157
  720379
  398230
  647891
  403559
  774559
  384811
  822653
  820501
  821113
  177739
  401811
  636258
  800177
  808081
  737589
  772675
  797456
  821642
  422285
  458992
  810591
  672161
  539233
  826100
  723559
  626729
  752442
  818179
  819122
  401865
  464900
  398047
  810214
  710837
  822181
  823304
  821012
  822560
  822615
  660106
  588278
  605317
  608423
  792182
  806210
  811542
  749629
  760939
  749456
  784823
  806158
  820342
  469105
  820032
  732326
  813879
  625765
  486236
  409701
  649114
  665921
  793448
  731990
  731971
  600543
  773813
  418531
  381789
  814958
  635436
  632656
  642723
  603220
  401840
  14387
  461361
  479874
  485066
  801666
  545217
  670227
  675633
  630679
  810249
  403759
  395325
  822668
  726301
  31106
  451827
  571054
  790801
  800209
  769502
  12132
  389891
  821643
  775754
  411223
  774470
  811075
  646001
  557959
  797429
  801372
  810248
  795054
  758511
  772892
  792625
  750884
  724860
  765761
  810993
  811592
  793425
]
2.72 ms
(1.90%)
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
  12132
  14387
  31106
  177739
  381789
  382556
  384811
  389891
  393355
  395325
  398047
  398230
  401157
  401811
  401840
  401865
  403559
  403759
  409701
  411223
  418531
  422285
  451827
  458992
  461361
  464900
  469105
  479874
  485066
  486236
  539233
  545217
  557959
  571054
  588278
  600543
  603220
  605317
  608423
  625765
  626729
  630679
  632656
  635436
  636258
  642723
  646001
  647891
  649114
  660106
  665921
  670227
  672161
  675633
  710837
  720379
  723559
  724860
  726301
  731971
  731990
  732326
  737589
  749456
  749629
  750884
  752442
  758511
  760939
  765761
  769502
  772675
  772892
  773813
  774470
  774559
  775754
  784823
  790801
  792182
  792625
  793425
  793448
  795054
  797429
  797456
  798517
  800177
  800209
  801372
  801666
  806158
  806210
  808081
  810214
  810248
  810249
  810591
  810993
  811075
  811542
  811592
  813879
  814958
  818179
  819122
  820032
  820342
  820501
  821012
  821113
  821642
  821643
  822181
  822560
  822615
  822653
  822668
  823304
  826100
]
2.23 ms
(1.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "latina blowjob"
]
1.63 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "латинская минет оральн секс"
]
1.47 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "латинская минет оральн секс"
]
1.43 ms
(0.99%)
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.