Query Metrics
7
Database Queries
7
Different statements
174.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.26 ms (90.16%) |
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 233489 523627 529925 531642 534692 535281 539552 540191 540554 541459 542443 543955 544051 546087 547541 549440 550002 551013 553753 554122 559422 560678 561152 563977 567121 575942 576424 576562 576784 581381 583915 585654 596542 603633 604573 605216 611541 613769 622511 628442 629749 636957 642824 647211 650706 655505 660846 664402 666096 669257 670939 674174 678765 684836 689223 704992 706008 709123 710333 710494 710538 723199 724693 727397 731214 731217 734109 734261 739553 740238 740895 742110 742122 744000 746113 746789 749453 755056 756520 758015 758839 759142 759149 759489 761942 762119 773175 773717 773738 780847 783280 783837 790735 794614 795261 796508 797184 800160 804523 804770 806806 806990 807880 810460 811787 812201 812330 816643 817338 817560 817566 817587 819424 824922 825538 826565 826717 826768 827609 ] |
||||||||||||||||||||||||||||||
|
8.12 ms (4.66%) |
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 575942 706008 684836 723199 613769 636957 642824 628442 783280 783837 795261 742110 762119 773175 746113 758015 605216 780847 576562 560678 550002 664402 622511 800160 724693 755056 756520 758839 759142 603633 233489 817338 817587 826565 826717 824922 826768 816643 817566 817560 819424 825538 827609 523627 529925 534692 531642 535281 539552 540191 540554 529752 542443 567121 544051 553753 554122 581381 541459 543955 563977 576784 660846 666096 710538 647211 655505 669257 670939 674174 704992 710333 650706 678765 689223 709123 710494 546087 547541 549440 551013 559422 561152 576424 583915 585654 611541 629749 596542 604573 806806 806990 810460 811787 812201 790735 794614 797184 804523 804770 812330 734261 740895 796508 807880 742122 744000 749453 731214 746789 759149 759489 727397 731217 734109 739553 740238 773738 761942 773717 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.40%) |
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 233489 523627 529925 531642 534692 535281 539552 540191 540554 541459 542443 543955 544051 546087 547541 549440 550002 551013 553753 554122 559422 560678 561152 563977 567121 575942 576424 576562 576784 581381 583915 585654 596542 603633 604573 605216 611541 613769 622511 628442 629749 636957 642824 647211 650706 655505 660846 664402 666096 669257 670939 674174 678765 684836 689223 704992 706008 709123 710333 710494 710538 723199 724693 727397 731214 731217 734109 734261 739553 740238 740895 742110 742122 744000 746113 746789 749453 755056 756520 758015 758839 759142 759149 759489 761942 762119 773175 773717 773738 780847 783280 783837 790735 794614 795261 796508 797184 800160 804523 804770 806806 806990 807880 810460 811787 812201 812330 816643 817338 817560 817566 817587 819424 824922 825538 826565 826717 826768 827609 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"erotic my wife"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"эротик my жен"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.18 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"эротик my жен"
]
|
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.