Query Metrics
7
Database Queries
7
Different statements
180.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.87 ms (86.18%) |
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 444720 445390 445735 451779 455204 459518 461563 462904 464372 466355 467591 469586 472252 476022 484695 486336 491022 495275 497166 500482 502539 510157 512137 512478 517372 517450 517455 520405 520714 520774 525137 527031 543425 545009 546564 554649 558338 560368 561114 561131 561391 564545 566187 567597 571308 574855 576113 577209 577437 579541 581305 587542 587665 587860 588309 591908 593894 594768 599272 603604 603618 603640 603652 604746 607146 608177 611611 611902 612030 615394 617174 627380 628654 637731 648899 653876 654521 654840 655410 655647 655671 656076 656400 656472 656708 656789 657033 657692 659715 661567 664521 666066 671439 677881 685767 716380 724421 725921 731400 742683 743906 748433 755170 759696 759760 769579 776530 779615 779627 780073 786474 796811 797162 801983 810798 811964 813050 825098 826363 827101 ] |
||||||||||||||||||||||||||||||
|
15.67 ms (8.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 627380 748433 497166 512478 525137 444720 512137 577209 661567 566187 593894 797162 811964 813050 742683 755170 743906 445390 451779 469586 653876 604746 517372 827101 677881 561391 571308 594768 607146 611902 655410 520405 611611 725921 716380 724421 554649 664521 615394 603652 527031 520714 510157 628654 801983 685767 587665 780073 486336 495275 591908 603618 500482 484695 656076 657033 655671 759760 545009 561131 577437 587542 671439 826363 779615 517455 656400 656472 612030 445735 464372 560368 579541 561114 637731 462904 502539 657692 648899 581305 810798 455204 476022 517450 520774 466355 786474 491022 543425 467591 567597 769579 587860 588309 655647 666066 779627 656789 659715 546564 599272 603604 564545 574855 459518 461563 576113 825098 759696 776530 608177 558338 654840 603640 656708 472252 654521 796811 731400 617174 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.50%) |
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 444720 445390 445735 451779 455204 459518 461563 462904 464372 466355 467591 469586 472252 476022 484695 486336 491022 495275 497166 500482 502539 510157 512137 512478 517372 517450 517455 520405 520714 520774 525137 527031 543425 545009 546564 554649 558338 560368 561114 561131 561391 564545 566187 567597 571308 574855 576113 577209 577437 579541 581305 587542 587665 587860 588309 591908 593894 594768 599272 603604 603618 603640 603652 604746 607146 608177 611611 611902 612030 615394 617174 627380 628654 637731 648899 653876 654521 654840 655410 655647 655671 656076 656400 656472 656708 656789 657033 657692 659715 661567 664521 666066 671439 677881 685767 716380 724421 725921 731400 742683 743906 748433 755170 759696 759760 769579 776530 779615 779627 780073 786474 796811 797162 801983 810798 811964 813050 825098 826363 827101 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob cuckold"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член куколд"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.83%) |
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.