Query Metrics
7
Database Queries
7
Different statements
185.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.10 ms (85.67%) |
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 396813 478767 491301 500389 522055 527864 533405 535664 537283 537636 542479 543733 547685 547725 554882 560545 562428 564698 569800 572662 576460 577308 588695 590005 590674 606641 608600 617245 626622 632304 635649 635812 642182 649480 651223 651243 651355 651953 659416 660738 664696 665696 670727 670736 675163 682846 685434 686494 692701 698775 701962 703281 704722 707214 711802 714673 722071 727716 735499 736889 737365 738108 738995 740303 743196 743738 745593 746871 751619 752020 752752 753166 753304 753349 759612 761727 761944 762278 769525 771053 771784 775453 775646 776109 778450 778905 779841 782184 782732 782796 784218 784309 785506 786402 787132 788390 792340 794069 794079 796792 796847 797160 797370 801136 809599 809965 810891 812079 813327 813928 816693 817342 817556 817621 818926 819850 819907 823131 827535 ] |
||||||||||||||||||||||||||||||
|
15.32 ms (8.25%) |
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 746871 753304 769525 738995 740303 727716 771053 738108 608600 642182 722071 788390 794069 796792 810891 812079 813928 533405 576460 617245 782732 787132 752752 782184 632304 827535 817621 819907 522055 543733 547685 651953 686494 701962 651355 675163 704722 562428 590674 626622 794079 775453 784309 809599 752020 762278 735499 761727 635812 698775 649480 547725 792340 782796 743196 813327 396813 816693 817342 818926 823131 819850 527864 478767 560545 651223 651243 660738 664696 670727 682846 707214 711802 665696 692701 659416 670736 685434 714673 572662 588695 590005 635649 606641 778450 785506 775646 776109 778905 779841 786402 796847 797370 745593 753166 784218 801136 736889 753349 759612 761944 751619 737365 743738 771784 703281 797160 809965 817556 826109 491301 500389 535664 537636 537283 554882 577308 542479 564698 569800 ] |
||||||||||||||||||||||||||||||
|
3.85 ms (2.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 396813 478767 491301 500389 522055 527864 533405 535664 537283 537636 542479 543733 547685 547725 554882 560545 562428 564698 569800 572662 576460 577308 588695 590005 590674 606641 608600 617245 626622 632304 635649 635812 642182 649480 651223 651243 651355 651953 659416 660738 664696 665696 670727 670736 675163 682846 685434 686494 692701 698775 701962 703281 704722 707214 711802 714673 722071 727716 735499 736889 737365 738108 738995 740303 743196 743738 745593 746871 751619 752020 752752 753166 753304 753349 759612 761727 761944 762278 769525 771053 771784 775453 775646 776109 778450 778905 779841 782184 782732 782796 784218 784309 785506 786402 787132 788390 792340 794069 794079 796792 796847 797160 797370 801136 809599 809965 810891 812079 813327 813928 816693 817342 817556 817621 818926 819850 819907 823131 827535 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"home girl"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"home девушк"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"home девушк"
]
|
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.