Query Metrics
7
Database Queries
7
Different statements
226.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
203.49 ms (89.78%) |
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 7111 21981 54387 72889 382408 385082 386865 392760 396301 397510 400621 402112 408770 409200 411686 411883 412980 417742 418936 423564 431302 444709 446107 447999 448962 464677 467802 468053 480795 481667 503801 506817 507088 510368 518734 524332 532284 536585 538778 541528 557168 557678 565222 573922 574456 585780 591122 596156 608900 611305 614990 615650 627371 653081 653395 656537 660146 672622 672677 676575 677121 700741 704987 705741 715279 721116 726954 727684 729864 732425 735511 735549 739562 740149 742610 746627 748470 749553 751511 756236 756658 757098 757673 759414 760137 771968 775101 775770 776416 776570 777419 780944 781783 781817 781895 784831 787408 795257 795519 796292 800103 801370 804073 806184 806295 806301 806354 808958 809125 809246 815353 816222 818486 819361 820560 820594 821688 825553 825570 826521 ] |
||||||||||||||||||||||||||||||
|
13.64 ms (6.02%) |
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 820560 826521 809246 518734 480795 748470 739562 468053 538778 715279 705741 809125 801370 757673 385082 7111 418936 819361 815353 481667 557678 781817 757098 729864 749553 727684 804073 760137 818486 565222 585780 781895 795519 796292 740149 776416 780944 806295 397510 396301 660146 821688 676575 54387 510368 653081 775770 787408 777419 532284 608900 776570 795257 700741 784831 507088 411883 503801 541528 704987 808958 771968 735511 742610 726954 72889 392760 735549 825553 825570 653395 596156 806301 732425 751511 759414 382408 464677 386865 816222 721116 614990 409200 820594 746627 417742 21981 781783 756658 806184 408770 411686 444709 412980 448962 506817 524332 536585 677121 573922 591122 806354 800103 756236 775101 400621 447999 402112 423564 431302 446107 467802 574456 557168 656537 672622 672677 611305 615650 627371 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.11%) |
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 7111 21981 54387 72889 382408 385082 386865 392760 396301 397510 400621 402112 408770 409200 411686 411883 412980 417742 418936 423564 431302 444709 446107 447999 448962 464677 467802 468053 480795 481667 503801 506817 507088 510368 518734 524332 532284 536585 538778 541528 557168 557678 565222 573922 574456 585780 591122 596156 608900 611305 614990 615650 627371 653081 653395 656537 660146 672622 672677 676575 677121 700741 704987 705741 715279 721116 726954 727684 729864 732425 735511 735549 739562 740149 742610 746627 748470 749553 751511 756236 756658 757098 757673 759414 760137 771968 775101 775770 776416 776570 777419 780944 781783 781817 781895 784831 787408 795257 795519 796292 800103 801370 804073 806184 806295 806301 806354 808958 809125 809246 815353 816222 818486 819361 820560 820594 821688 825553 825570 826521 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"tit секс"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"tit секс"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tit sex"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.73%) |
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.