Query Metrics
7
Database Queries
7
Different statements
141.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
114.28 ms (80.75%) |
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 12811 13202 80510 86510 86826 123257 150899 195888 271329 390058 391349 396150 396347 398314 398746 398779 400882 407482 424263 442968 444316 454107 512812 515644 517237 523825 524926 530819 533984 539633 542668 554509 557108 558586 558966 565598 573269 574067 588007 597920 598421 601556 625950 626753 627697 631143 639757 649573 653306 653313 674523 681734 684301 692069 700885 701281 701794 712879 717212 717226 719472 723095 727870 728922 731199 733401 737809 737968 744664 751701 763695 763889 765088 767553 768403 776944 778226 778908 779442 779574 780209 782976 788442 793384 793389 793465 794586 798259 798391 803653 805628 806308 810617 815482 816385 816523 817137 817357 817760 818131 818155 818250 818664 819772 820622 823340 824114 824918 825177 825222 825379 825745 826559 827164 827671 827727 828264 828509 ] |
||||||||||||||||||||||||||||||
|
17.12 ms (12.10%) |
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 597920 793384 818155 827671 539633 542668 558586 442968 515644 565598 424263 639757 444316 517237 523825 818664 817137 828264 524926 391349 573269 625950 13202 825222 737968 123257 712879 398314 825379 819772 815482 825745 601556 776944 798259 805628 825177 86826 788442 396150 817760 827727 701794 390058 400882 826559 817357 816385 828509 533984 684301 764590 717212 195888 737809 626753 150899 271329 398779 824918 701281 692069 588007 793465 780209 751701 763695 727870 12811 398746 763889 454107 731199 818250 86510 396347 818131 820622 827164 823340 816523 822579 824114 512812 554509 558966 653313 717226 723095 674523 700885 803653 782976 728922 744664 631143 765088 653306 719472 627697 778908 778226 810617 733401 767553 768403 574067 557108 598421 779574 798391 793389 806308 779442 794586 80510 407482 530819 681734 649573 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.91%) |
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 12811 13202 80510 86510 86826 123257 150899 195888 271329 390058 391349 396150 396347 398314 398746 398779 400882 407482 424263 442968 444316 454107 512812 515644 517237 523825 524926 530819 533984 539633 542668 554509 557108 558586 558966 565598 573269 574067 588007 597920 598421 601556 625950 626753 627697 631143 639757 649573 653306 653313 674523 681734 684301 692069 700885 701281 701794 712879 717212 717226 719472 723095 727870 728922 731199 733401 737809 737968 744664 751701 763695 763889 765088 767553 768403 776944 778226 778908 779442 779574 780209 782976 788442 793384 793389 793465 794586 798259 798391 803653 805628 806308 810617 815482 816385 816523 817137 817357 817760 818131 818155 818250 818664 819772 820622 823340 824114 824918 825177 825222 825379 825745 826559 827164 827671 827727 828264 828509 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob deepthroat"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.