Query Metrics
7
Database Queries
7
Different statements
160.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.77 ms (83.99%) |
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 453560 456244 495407 506133 511799 552532 558170 575591 585467 605696 617171 630797 634618 647797 663301 692032 703306 705435 709870 714553 714709 716916 716986 720039 720566 724616 724735 724816 728955 729293 729907 732815 732979 734174 734795 735917 736581 744529 748406 748633 749523 750821 754064 755875 757300 759029 759683 759794 760506 761682 761961 764048 764103 766451 766885 768192 768463 768830 768926 771919 773448 774884 775283 775644 778203 779781 782991 787392 787622 787646 787681 788503 789348 789422 789804 790317 791795 792408 792751 793526 793867 794119 794476 794535 794987 795460 796218 796884 797702 797805 800576 801659 804946 807736 808096 808426 810323 811838 816679 817206 817551 817588 817643 818820 819753 820055 820198 823600 823856 824237 824552 824736 824958 825473 825764 825838 826176 826788 827386 827685 ] |
||||||||||||||||||||||||||||||
|
14.15 ms (8.82%) |
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 705435 709870 748633 735917 820198 736581 791795 453560 456244 663301 817588 818820 823600 823856 824552 788503 789422 804946 761961 778203 787681 811838 824237 824736 826788 827386 816679 817206 827685 495407 552532 558170 647797 716986 720039 630797 585467 787392 794476 794535 795460 796218 808096 775283 775644 797702 729293 729907 734795 757300 759029 761682 766451 773448 782991 792751 808426 734174 750821 759683 759794 766885 768926 732815 755875 768463 768830 771919 744529 760506 724735 732979 768192 716916 810323 605696 794987 807736 575591 824958 714553 617171 506133 692032 634618 714709 703306 817551 817643 819753 820055 825838 826176 825473 825764 511799 720566 774884 779781 789804 793867 800576 789348 790317 793526 796884 764103 787622 787646 792408 794119 797805 801659 728955 749523 724616 724816 748406 754064 764048 ] |
||||||||||||||||||||||||||||||
|
4.06 ms (2.53%) |
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 453560 456244 495407 506133 511799 552532 558170 575591 585467 605696 617171 630797 634618 647797 663301 692032 703306 705435 709870 714553 714709 716916 716986 720039 720566 724616 724735 724816 728955 729293 729907 732815 732979 734174 734795 735917 736581 744529 748406 748633 749523 750821 754064 755875 757300 759029 759683 759794 760506 761682 761961 764048 764103 766451 766885 768192 768463 768830 768926 771919 773448 774884 775283 775644 778203 779781 782991 787392 787622 787646 787681 788503 789348 789422 789804 790317 791795 792408 792751 793526 793867 794119 794476 794535 794987 795460 796218 796884 797702 797805 800576 801659 804946 807736 808096 808426 810323 811838 816679 817206 817551 817588 817643 818820 819753 820055 820198 823600 823856 824237 824552 824736 824958 825473 825764 825838 826176 826788 827386 827685 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur wife hard"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск жен hard"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск жен hard"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.