Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
226.35 ms
(36.98%)
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
  727741
  735404
  761555
  773470
  731310
  733416
  738583
  738868
  753072
  760730
  602806
  607149
  614748
  630376
  639655
  714256
  778864
  785540
  793934
  794995
  796270
  134506
  187819
  122767
  428089
  485986
  523596
  454549
  499921
  502590
  536427
  632018
  729999
  727334
  762848
  527258
  387192
  814092
  822426
  814713
  815521
  818613
  823944
  826232
  472690
  456067
  531275
  533679
  521157
  537665
  531161
  478524
  548419
  548458
  578759
  580561
  680442
  681012
  681106
  699599
  666712
  674284
  680436
  681076
  683290
  661023
  670210
  717900
  569764
  590441
  595767
  605950
  598433
  599796
  624800
  590691
  617817
  774609
  787294
  788803
  789605
  793438
  798572
  800667
  775841
  776749
  786511
  789109
  791974
  805607
  809241
  809470
  731417
  734373
  740847
  747135
  748757
  770143
  783281
  796354
  811470
  726278
  757867
  726651
  727754
  733024
  740599
  744593
  749553
  757226
  765515
  773482
  728738
  729286
  751581
  763561
  735017
  761306
  770530
  604353
]
214.19 ms
(35.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf slut"
]
161.61 ms
(26.41%)
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
  122767
  134506
  187819
  387192
  428089
  454549
  456067
  472690
  478524
  485986
  499921
  502590
  521157
  523596
  527258
  531161
  531275
  533679
  536427
  537665
  548419
  548458
  569764
  578759
  580561
  590441
  590691
  595767
  598433
  599796
  602806
  604353
  605950
  607149
  614748
  617817
  624800
  630376
  632018
  639655
  661023
  666712
  670210
  674284
  680436
  680442
  681012
  681076
  681106
  683290
  699599
  714256
  717900
  726278
  726651
  727334
  727741
  727754
  728738
  729286
  729999
  731310
  731417
  733024
  733416
  734373
  735017
  735404
  738583
  738868
  740599
  740847
  744593
  747135
  748757
  749553
  751581
  753072
  757226
  757867
  760730
  761306
  761555
  762848
  763561
  765515
  770143
  770530
  773470
  773482
  774609
  775841
  776749
  778864
  783281
  785540
  786511
  787294
  788803
  789109
  789605
  791974
  793438
  793934
  794995
  796270
  796354
  798572
  800667
  805607
  809241
  809470
  811470
  814092
  814713
  815521
  818613
  822426
  823944
  826232
]
3.49 ms
(0.57%)
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
  122767
  134506
  187819
  387192
  428089
  454549
  456067
  472690
  478524
  485986
  499921
  502590
  521157
  523596
  527258
  531161
  531275
  533679
  536427
  537665
  548419
  548458
  569764
  578759
  580561
  590441
  590691
  595767
  598433
  599796
  602806
  604353
  605950
  607149
  614748
  617817
  624800
  630376
  632018
  639655
  661023
  666712
  670210
  674284
  680436
  680442
  681012
  681076
  681106
  683290
  699599
  714256
  717900
  726278
  726651
  727334
  727741
  727754
  728738
  729286
  729999
  731310
  731417
  733024
  733416
  734373
  735017
  735404
  738583
  738868
  740599
  740847
  744593
  747135
  748757
  749553
  751581
  753072
  757226
  757867
  760730
  761306
  761555
  762848
  763561
  765515
  770143
  770530
  773470
  773482
  774609
  775841
  776749
  778864
  783281
  785540
  786511
  787294
  788803
  789109
  789605
  791974
  793438
  793934
  794995
  796270
  796354
  798572
  800667
  805607
  809241
  809470
  811470
  814092
  814713
  815521
  818613
  822426
  823944
  826232
]
2.38 ms
(0.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf slut"
]
2.14 ms
(0.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf slut"
]
1.85 ms
(0.30%)
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.