Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.77 ms
(55.41%)
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
  392423
  393061
  394535
  395578
  398049
  399267
  399292
  399311
  399705
  403519
  406521
  407322
  408299
  409010
  414123
  417797
  417878
  417893
  417895
  417904
  419876
  419892
  420084
  421556
  424783
  425395
  428410
  430696
  436250
  444746
  446698
  446870
  449563
  451872
  458098
  458625
  461637
  463092
  464147
  465513
  469001
  478481
  480137
  480779
  486233
  496395
  496721
  497687
  505100
  510264
  513746
  520137
  528102
  530370
  532754
  532995
  533064
  537661
  538773
  545532
  545785
  547362
  557199
  565507
  573308
  574240
  577265
  578412
  581831
  584951
  591936
  599862
  599876
  602070
  604025
  604466
  604510
  605007
  605544
  606858
  607126
  610717
  612182
  619645
  622452
  629045
  630193
  630955
  631604
  632618
  636293
  636576
  637021
  637501
  641481
  647665
  649187
  650808
  682517
  687881
  708920
  713332
  715089
  719832
  720287
  722541
  733364
  737177
  741305
  744665
  744822
  770625
  785657
  800287
  800513
  804756
  805271
  817127
  818284
  820780
]
144.56 ms
(37.47%)
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
  392423
  393061
  394535
  395578
  398049
  399267
  399292
  399311
  399705
  403519
  406521
  407322
  408299
  409010
  414123
  417797
  417878
  417893
  417895
  417904
  419876
  419892
  420084
  421556
  424783
  425395
  428410
  430696
  436250
  444746
  446698
  446870
  449563
  451872
  458098
  458625
  461637
  463092
  464147
  465513
  469001
  478481
  480137
  480779
  486233
  496395
  496721
  497687
  505100
  510264
  513746
  520137
  528102
  530370
  532754
  532995
  533064
  537661
  538773
  545532
  545785
  547362
  557199
  565507
  573308
  574240
  577265
  578412
  581831
  584951
  591936
  599862
  599876
  602070
  604025
  604466
  604510
  605007
  605544
  606858
  607126
  610717
  612182
  619645
  622452
  629045
  630193
  630955
  631604
  632618
  636293
  636576
  637021
  637501
  641481
  647665
  649187
  650808
  682517
  687881
  708920
  713332
  715089
  719832
  720287
  722541
  733364
  737177
  741305
  744665
  744822
  770625
  785657
  800287
  800513
  804756
  805271
  817127
  818284
  820780
]
20.48 ms
(5.31%)
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
  417797
  407322
  414123
  419876
  424783
  419892
  417893
  428410
  444746
  818284
  451872
  449563
  458625
  461637
  463092
  497687
  520137
  528102
  469001
  715089
  649187
  687881
  719832
  573308
  604466
  607126
  591936
  602070
  636576
  599876
  604510
  612182
  737177
  744665
  606858
  630955
  713332
  800513
  395578
  458098
  393061
  417878
  480137
  420084
  425395
  465513
  399267
  446870
  406521
  496721
  510264
  513746
  532754
  545785
  637021
  632618
  630193
  530370
  605544
  708920
  744822
  532995
  537661
  533064
  629045
  599862
  636293
  392423
  398049
  399292
  399705
  417895
  421556
  417904
  430696
  436250
  817127
  820780
  486233
  480779
  505100
  538773
  496395
  464147
  547362
  565507
  577265
  557199
  578412
  581831
  584951
  545532
  650808
  682517
  647665
  720287
  722541
  574240
  604025
  619645
  631604
  610717
  605007
  641481
  800287
  770625
  804756
  805271
  741305
  733364
  622452
  637501
  785657
  409010
  446698
  399311
  403519
  408299
  394535
  478481
]
1.88 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy bbc"
]
1.79 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy bbc"
]
1.77 ms
(0.46%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy bbc"
]

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.