Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
369.63 ms
(93.42%)
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
  75896
  97290
  382202
  389208
  399609
  403592
  409180
  449021
  502487
  612053
  712696
  806220
  815180
  815191
  815195
  815229
  815236
  815238
  815242
  815254
  815256
  815288
  815306
  815311
  815340
  815343
  815363
  815365
  815372
  815389
  815403
  815409
  815441
  815452
  815454
  815459
  815462
  815469
  815472
  815481
  815496
  815502
  815509
  815518
  815519
  815523
  815531
  815539
  815573
  815579
  815625
  815629
  815653
  815671
  815676
  815677
  815678
  815683
  815696
  815715
  815726
  815729
  815749
  815771
  815774
  815777
  815785
  815787
  815791
  815797
  815804
  815814
  815874
  815890
  815899
  815905
  815912
  815913
  815914
  815941
  815958
  815962
  815965
  815973
  815980
  815993
  815998
  816030
  816035
  816066
  816069
  816074
  816080
  816083
  816330
  816367
  816384
  816405
  816419
  816508
  816510
  816538
  816539
  816542
  816544
  816554
  816583
  816586
  816876
  816886
  816892
  816893
  816894
  816916
  816932
  816934
  816970
  820120
  820667
]
14.18 ms
(3.58%)
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
  815726
  815993
  816074
  816367
  815941
  612053
  449021
  389208
  502487
  816384
  815180
  815340
  815288
  815678
  815715
  815913
  816080
  816542
  816886
  815469
  815749
  815771
  816894
  815256
  815653
  815890
  820120
  815523
  816538
  816934
  815625
  815791
  815914
  816330
  815403
  815579
  815787
  815874
  816554
  97290
  815229
  816586
  712696
  75896
  816419
  815236
  815774
  816030
  816892
  815238
  815242
  815496
  815962
  820667
  815519
  815777
  815454
  816405
  815629
  815696
  815182
  815254
  815372
  815452
  815502
  815539
  815677
  816066
  816539
  816583
  816916
  816932
  815343
  815804
  815998
  816510
  815441
  815306
  815472
  399609
  815814
  815531
  815797
  816876
  816893
  815389
  815980
  815365
  382202
  403592
  409180
  815311
  815363
  815409
  815481
  815683
  815785
  816069
  815191
  816035
  816083
  816970
  816508
  816544
  815958
  815965
  806220
  815462
  815671
  815459
  815509
  815518
  815573
  815676
  815729
  815899
  815905
  815912
  815973
  815195
]
3.81 ms
(0.96%)
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
  75896
  97290
  382202
  389208
  399609
  403592
  409180
  449021
  502487
  612053
  712696
  806220
  815180
  815191
  815195
  815229
  815236
  815238
  815242
  815254
  815256
  815288
  815306
  815311
  815340
  815343
  815363
  815365
  815372
  815389
  815403
  815409
  815441
  815452
  815454
  815459
  815462
  815469
  815472
  815481
  815496
  815502
  815509
  815518
  815519
  815523
  815531
  815539
  815573
  815579
  815625
  815629
  815653
  815671
  815676
  815677
  815678
  815683
  815696
  815715
  815726
  815729
  815749
  815771
  815774
  815777
  815785
  815787
  815791
  815797
  815804
  815814
  815874
  815890
  815899
  815905
  815912
  815913
  815914
  815941
  815958
  815962
  815965
  815973
  815980
  815993
  815998
  816030
  816035
  816066
  816069
  816074
  816080
  816083
  816330
  816367
  816384
  816405
  816419
  816508
  816510
  816538
  816539
  816542
  816544
  816554
  816583
  816586
  816876
  816886
  816892
  816893
  816894
  816916
  816932
  816934
  816970
  820120
  820667
]
2.19 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "brazzers big boobs"
]
2.07 ms
(0.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "brazzers большие boobs"
]
2.04 ms
(0.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "brazzers большие boobs"
]

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.