Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.53 ms
(51.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "double dildo deepthroat"
]
168.20 ms
(41.52%)
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
  390667
  431643
  443103
  445737
  451663
  452136
  454084
  460027
  474349
  481142
  489424
  499104
  508133
  509552
  516684
  522138
  530024
  530057
  530382
  530479
  530483
  530495
  530501
  531088
  531135
  532360
  532843
  532847
  532963
  533042
  533928
  534041
  534372
  534984
  534986
  534988
  536459
  536582
  536638
  536783
  537648
  537660
  538360
  540333
  540572
  541854
  541863
  544840
  545444
  549514
  555140
  565248
  565264
  566786
  577966
  584006
  586933
  599867
  599885
  599967
  600296
  600337
  601613
  612399
  617414
  617424
  628383
  630511
  631202
  631209
  631256
  632269
  632283
  632678
  633123
  633445
  633787
  634155
  634780
  634793
  635215
  636286
  636320
  637049
  637136
  637442
  639716
  640751
  640806
  642053
  642660
  642777
  645284
  646427
  647307
  647936
  647972
  649514
  649546
  650198
  651634
  651666
  667748
  668505
  674968
  674988
  674995
  677296
  677676
  677783
  678109
  678117
  678504
  680174
  696582
  702622
  716901
  742356
  750701
  803455
]
19.44 ms
(4.80%)
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
  533928
  536638
  531088
  534988
  647936
  678504
  696582
  651666
  677676
  637442
  612399
  600337
  640751
  445737
  481142
  532847
  650198
  632283
  532360
  537660
  530501
  531135
  532963
  541863
  678117
  716901
  651634
  674988
  668505
  584006
  599867
  600296
  631202
  633123
  601613
  617424
  631209
  530479
  536459
  532843
  566786
  451663
  516684
  452136
  530024
  431643
  443103
  508133
  533042
  536783
  530382
  390667
  509552
  674995
  628383
  599967
  534986
  677296
  586933
  637049
  460027
  534372
  541854
  647307
  636320
  474349
  649546
  667748
  530483
  534041
  565248
  636286
  642777
  634793
  640806
  631256
  702622
  544840
  674968
  803455
  489424
  639716
  522138
  549514
  565264
  537648
  677783
  645284
  647972
  540333
  530057
  678109
  680174
  599885
  633787
  634155
  637136
  630511
  642053
  617414
  454084
  499104
  536582
  545444
  742356
  555140
  534984
  540572
  646427
  649514
  633445
  632269
  632678
  635215
  530495
  577966
  634780
  750701
  642660
  538360
]
4.35 ms
(1.07%)
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
  390667
  431643
  443103
  445737
  451663
  452136
  454084
  460027
  474349
  481142
  489424
  499104
  508133
  509552
  516684
  522138
  530024
  530057
  530382
  530479
  530483
  530495
  530501
  531088
  531135
  532360
  532843
  532847
  532963
  533042
  533928
  534041
  534372
  534984
  534986
  534988
  536459
  536582
  536638
  536783
  537648
  537660
  538360
  540333
  540572
  541854
  541863
  544840
  545444
  549514
  555140
  565248
  565264
  566786
  577966
  584006
  586933
  599867
  599885
  599967
  600296
  600337
  601613
  612399
  617414
  617424
  628383
  630511
  631202
  631209
  631256
  632269
  632283
  632678
  633123
  633445
  633787
  634155
  634780
  634793
  635215
  636286
  636320
  637049
  637136
  637442
  639716
  640751
  640806
  642053
  642660
  642777
  645284
  646427
  647307
  647936
  647972
  649514
  649546
  650198
  651634
  651666
  667748
  668505
  674968
  674988
  674995
  677296
  677676
  677783
  678109
  678117
  678504
  680174
  696582
  702622
  716901
  742356
  750701
  803455
]
2.00 ms
(0.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "double дилд глубокийминет минет оральн секс"
]
1.89 ms
(0.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "double дилд глубокийминет минет оральн секс"
]

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.