Query Metrics
7
Database Queries
7
Different statements
149.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.28 ms (81.12%) |
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 6866 16897 384917 395677 415745 420140 425529 427457 428848 430948 437807 444414 445956 451242 454008 454098 454906 455202 456931 463687 465558 466306 467616 467792 468269 468812 476062 476748 491107 500789 504794 504980 508266 509019 512143 515652 519531 519609 523761 524594 525910 526561 527913 528222 529149 529757 529902 532213 532538 535898 539699 552706 555111 555964 556603 556899 566595 567072 567190 569259 572187 574050 577345 580227 581276 583694 584619 589390 591529 594267 599084 600700 601228 607636 609554 609887 614979 615614 617472 620391 624116 624613 629481 634269 634742 643287 658445 666854 671518 672317 676769 680816 708062 709885 710308 717410 734253 740099 740754 742415 744798 750814 754436 760698 766503 766509 768500 770395 778393 781859 795403 799081 802314 803031 804434 807830 808962 816691 823903 826018 ] |
||||||||||||||||||||||||||||||
|
19.08 ms (12.76%) |
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 467616 508266 519609 500789 529757 532213 658445 680816 717410 584619 795403 523761 384917 395677 816691 823903 454008 451242 456931 539699 535898 527913 529902 532538 524594 569259 574050 577345 583694 567190 572187 580227 581276 708062 710308 666854 672317 555964 566595 567072 607636 634742 591529 600700 614979 629481 634269 589390 601228 620391 599084 609554 624116 624613 781859 802314 799081 803031 808962 734253 740099 740754 766509 744798 750814 766503 768500 742415 754436 760698 770395 617472 709885 778393 804434 807830 445956 466306 425529 437807 463687 430948 444414 504794 504980 509019 512143 525910 529149 526561 528222 491107 515652 415745 427457 555111 468812 6866 826018 556899 671518 676769 556603 615614 594267 609887 643287 467792 16897 428848 454098 454906 455202 519531 552706 420140 465558 468269 476062 476748 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.76%) |
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 6866 16897 384917 395677 415745 420140 425529 427457 428848 430948 437807 444414 445956 451242 454008 454098 454906 455202 456931 463687 465558 466306 467616 467792 468269 468812 476062 476748 491107 500789 504794 504980 508266 509019 512143 515652 519531 519609 523761 524594 525910 526561 527913 528222 529149 529757 529902 532213 532538 535898 539699 552706 555111 555964 556603 556899 566595 567072 567190 569259 572187 574050 577345 580227 581276 583694 584619 589390 591529 594267 599084 600700 601228 607636 609554 609887 614979 615614 617472 620391 624116 624613 629481 634269 634742 643287 658445 666854 671518 672317 676769 680816 708062 709885 710308 717410 734253 740099 740754 742415 744798 750814 754436 760698 766503 766509 768500 770395 778393 781859 795403 799081 802314 803031 804434 807830 808962 816691 823903 826018 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot solo ass"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot соло жоп"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot соло жоп"
]
|
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.