Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.45 ms
(59.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "bbc double penetration"
]
116.17 ms
(32.74%)
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
  403162
  403641
  404368
  405054
  405468
  406304
  409921
  413263
  414342
  414358
  416794
  416820
  421200
  421557
  423655
  424782
  429766
  429770
  432799
  435624
  435695
  437526
  455851
  463073
  464704
  467583
  468637
  469555
  471317
  474619
  474714
  476143
  482936
  482938
  491449
  497901
  501255
  511318
  514798
  518554
  527411
  530019
  530022
  530483
  530627
  530643
  530766
  530911
  531175
  531189
  531198
  531206
  531211
  532988
  533051
  533870
  534041
  534150
  534381
  534650
  534986
  534993
  535005
  535024
  536580
  536640
  537196
  537590
  537747
  537899
  537901
  537917
  538881
  541844
  542591
  542965
  544819
  545399
  549514
  550201
  556421
  572042
  578596
  583905
  644940
  645812
  646178
  646875
  648832
  648855
  648867
  649110
  649188
  649504
  650161
  650165
  650333
  651090
  651135
  651204
  666907
  667747
  674980
  674984
  676080
  676111
  676622
  677827
  678109
  679317
  679326
  679744
  679773
  679803
  680127
  680149
  693504
  714464
  720245
  815413
]
19.96 ms
(5.62%)
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
  403162
  403641
  404368
  406304
  405054
  405468
  413263
  432799
  435695
  437526
  409921
  414342
  416794
  416820
  414358
  424782
  429770
  435624
  421200
  423655
  429766
  421557
  644940
  815413
  467583
  468637
  476143
  463073
  482936
  491449
  455851
  469555
  497901
  501255
  518554
  530022
  530483
  530627
  530911
  531189
  531206
  534041
  534150
  534650
  534986
  530766
  531175
  532988
  533051
  533870
  534993
  535005
  536580
  537196
  537590
  537899
  511318
  514798
  530019
  531211
  534381
  535024
  537901
  537917
  538881
  527411
  530643
  531198
  536640
  537747
  464704
  471317
  474619
  474714
  482938
  541844
  542591
  545399
  549514
  556421
  572042
  578596
  583905
  542965
  544819
  550201
  646178
  648832
  648867
  649504
  650161
  650333
  674980
  676080
  676111
  677827
  679744
  679773
  680149
  714464
  720245
  645812
  648855
  649110
  650165
  651090
  651135
  651204
  666907
  667747
  674984
  676622
  678109
  679317
  679326
  679803
  680127
  693504
  646875
  649188
]
2.52 ms
(0.71%)
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
  403162
  403641
  404368
  405054
  405468
  406304
  409921
  413263
  414342
  414358
  416794
  416820
  421200
  421557
  423655
  424782
  429766
  429770
  432799
  435624
  435695
  437526
  455851
  463073
  464704
  467583
  468637
  469555
  471317
  474619
  474714
  476143
  482936
  482938
  491449
  497901
  501255
  511318
  514798
  518554
  527411
  530019
  530022
  530483
  530627
  530643
  530766
  530911
  531175
  531189
  531198
  531206
  531211
  532988
  533051
  533870
  534041
  534150
  534381
  534650
  534986
  534993
  535005
  535024
  536580
  536640
  537196
  537590
  537747
  537899
  537901
  537917
  538881
  541844
  542591
  542965
  544819
  545399
  549514
  550201
  556421
  572042
  578596
  583905
  644940
  645812
  646178
  646875
  648832
  648855
  648867
  649110
  649188
  649504
  650161
  650165
  650333
  651090
  651135
  651204
  666907
  667747
  674980
  674984
  676080
  676111
  676622
  677827
  678109
  679317
  679326
  679744
  679773
  679803
  680127
  680149
  693504
  714464
  720245
  815413
]
2.05 ms
(0.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bbc double penetration"
]
1.99 ms
(0.56%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "bbc double penetration"
]
1.66 ms
(0.47%)
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.