Query Metrics
7
Database Queries
7
Different statements
163.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.81 ms (86.15%) |
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 33113 236765 370755 382134 382280 384193 388434 388766 388792 391704 393056 395572 395646 395713 395758 395923 395929 396224 397643 397881 401313 404664 407867 411322 412315 413460 417647 422504 425014 428136 433652 444661 453914 465902 465953 466877 468167 472223 476349 479756 490567 490783 493306 496172 508721 512868 519947 522908 523367 523564 525479 530576 537475 537844 546687 559214 563074 565648 571218 594261 596161 598069 598679 599586 599946 604968 605324 623200 626735 635968 636269 637436 644291 644699 646824 649190 650192 651161 667904 678734 678954 683955 695316 699583 705320 705878 708468 709688 712311 718870 718947 719016 720462 720677 720698 722645 725561 726461 733876 733906 737161 740505 747996 750242 751722 757896 758199 758432 761290 762984 789691 789733 790874 799146 807918 815778 816340 821503 824940 827328 ] |
||||||||||||||||||||||||||||||
|
12.93 ms (7.91%) |
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 757896 453914 397881 413460 417647 490783 465953 559214 563074 799146 465902 411322 425014 718870 388766 599586 433652 490567 519947 523564 725561 407867 388792 382134 396224 404664 422504 523367 530576 537844 537475 699583 720698 605324 790874 733906 758432 33113 382280 395572 388434 384193 395646 395713 444661 468167 479756 395923 395929 397643 401313 512868 493306 496172 236765 412315 821503 815778 827328 824940 816340 472223 718947 649190 720462 604968 644291 598679 626735 789691 789733 762984 740505 726461 737161 747996 751722 733876 758199 761290 719016 807918 395758 391704 393056 370755 525479 476349 623200 428136 466877 508721 565648 644699 750242 522908 571218 650192 667904 678954 705878 720677 678734 705320 709688 646824 651161 683955 695316 708468 712311 722645 546687 598069 599946 635968 636269 637436 594261 596161 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.69%) |
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 33113 236765 370755 382134 382280 384193 388434 388766 388792 391704 393056 395572 395646 395713 395758 395923 395929 396224 397643 397881 401313 404664 407867 411322 412315 413460 417647 422504 425014 428136 433652 444661 453914 465902 465953 466877 468167 472223 476349 479756 490567 490783 493306 496172 508721 512868 519947 522908 523367 523564 525479 530576 537475 537844 546687 559214 563074 565648 571218 594261 596161 598069 598679 599586 599946 604968 605324 623200 626735 635968 636269 637436 644291 644699 646824 649190 650192 651161 667904 678734 678954 683955 695316 699583 705320 705878 708468 709688 712311 718870 718947 719016 720462 720677 720698 722645 725561 726461 733876 733906 737161 740505 747996 750242 751722 757896 758199 758432 761290 762984 789691 789733 790874 799146 807918 815778 816340 821503 824940 827328 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big anal old"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие анал old"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие анал old"
]
|
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.