Query Metrics
7
Database Queries
7
Different statements
182.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.04 ms (88.72%) |
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 131726 417832 417839 426245 437417 449185 453584 454491 455322 457508 464473 476729 480087 483456 483910 489268 493962 494680 496330 510197 510293 515806 517337 531909 532207 533962 539348 546026 556865 557430 557581 560865 561510 569043 583049 584145 589064 589277 592217 595544 597769 605440 612148 613766 615068 618719 619964 624661 631311 631793 636419 639596 646719 647080 647814 648178 650859 651333 653177 657205 657567 664616 666060 672281 673425 685736 698774 702375 710006 711103 713444 717614 724080 726519 727076 727507 727874 733318 734601 738395 738408 738827 742272 744067 750789 752834 753039 754954 755829 756376 758110 759638 760332 761164 766498 767377 773105 778449 778878 780274 780667 780743 782497 784225 785631 789395 791531 794695 796104 796295 797364 797496 798557 800962 801074 801791 809575 809923 817395 827287 ] |
||||||||||||||||||||||||||||||
|
11.70 ms (6.41%) |
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 647080 657567 666060 592217 613766 631793 589277 618719 595544 612148 597769 636419 639596 778878 780274 780743 794695 800962 778449 784225 785631 796104 796295 798557 801791 753039 756376 760332 789395 797364 758110 766498 724080 727507 738408 750789 742272 744067 759638 767377 734601 761164 615068 631311 698774 702375 710006 711103 713444 780667 791531 801074 437417 483910 483456 493962 650859 496330 510293 733318 754954 464473 685736 717614 664616 619964 782497 738395 755829 727874 556865 797496 727076 672281 809575 449185 533962 605440 752834 773105 494680 453584 476729 517337 561510 569043 583049 560865 653177 589064 624661 809923 726519 738827 417839 455322 417832 489268 480087 131726 426245 827287 817395 454491 457508 515806 531909 510197 532207 539348 546026 557430 557581 584145 646719 647814 648178 651333 657205 673425 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.22%) |
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 131726 417832 417839 426245 437417 449185 453584 454491 455322 457508 464473 476729 480087 483456 483910 489268 493962 494680 496330 510197 510293 515806 517337 531909 532207 533962 539348 546026 556865 557430 557581 560865 561510 569043 583049 584145 589064 589277 592217 595544 597769 605440 612148 613766 615068 618719 619964 624661 631311 631793 636419 639596 646719 647080 647814 648178 650859 651333 653177 657205 657567 664616 666060 672281 673425 685736 698774 702375 710006 711103 713444 717614 724080 726519 727076 727507 727874 733318 734601 738395 738408 738827 742272 744067 750789 752834 753039 754954 755829 756376 758110 759638 760332 761164 766498 767377 773105 778449 778878 780274 780667 780743 782497 784225 785631 789395 791531 794695 796104 796295 797364 797496 798557 800962 801074 801791 809575 809923 817395 827287 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fucking my wife"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fucking my жен"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fucking 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.