Query Metrics
7
Database Queries
7
Different statements
208.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
187.46 ms (89.85%) |
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 391582 403628 411958 417454 426490 427399 435929 437157 437556 437791 441659 441912 446498 449647 450473 450876 455059 455733 456311 457067 457926 458504 458835 459092 464475 465692 468991 471830 472180 475385 476893 477244 479518 480114 480626 481356 491653 493937 495851 497201 497756 498699 498854 499414 500263 509945 512948 520987 523935 524719 526487 529474 531216 539549 540587 541868 542493 542640 555754 562065 563653 568266 574362 584086 587299 595278 604924 624893 629569 633322 650076 651376 664543 666164 670184 677910 684053 696493 697166 700732 705677 706785 707510 707531 709536 714944 719115 722020 729548 730381 735392 736631 738053 741053 747454 751410 756798 757152 757232 759121 760567 762886 768387 771348 785188 786081 790843 793923 795600 798329 800706 800851 801026 812979 813150 817571 822042 822228 822694 823326 ] |
||||||||||||||||||||||||||||||
|
12.37 ms (5.93%) |
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 520987 542493 670184 650076 706785 568266 785188 813150 771348 756798 738053 741053 455059 459092 437791 472180 465692 531216 539549 476893 562065 584086 574362 705677 697166 709536 587299 629569 801026 736631 714944 403628 391582 471830 822042 822228 458504 458835 457067 526487 497756 475385 696493 604924 800851 812979 729548 759121 751410 757232 624893 437556 529474 498699 441912 426490 427399 411958 441659 435929 823326 822694 464475 477244 481356 498854 540587 500263 512948 468991 493937 542640 684053 700732 563653 595278 795600 786081 757152 735392 762886 760567 719115 790843 455733 457926 479518 450876 480114 437157 449647 456311 480626 417454 446498 450473 523935 491653 524719 499414 509945 495851 497201 817571 541868 555754 664543 666164 707531 707510 722020 651376 677910 633322 793923 798329 800706 730381 747454 768387 ] |
||||||||||||||||||||||||||||||
|
2.32 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 391582 403628 411958 417454 426490 427399 435929 437157 437556 437791 441659 441912 446498 449647 450473 450876 455059 455733 456311 457067 457926 458504 458835 459092 464475 465692 468991 471830 472180 475385 476893 477244 479518 480114 480626 481356 491653 493937 495851 497201 497756 498699 498854 499414 500263 509945 512948 520987 523935 524719 526487 529474 531216 539549 540587 541868 542493 542640 555754 562065 563653 568266 574362 584086 587299 595278 604924 624893 629569 633322 650076 651376 664543 666164 670184 677910 684053 696493 697166 700732 705677 706785 707510 707531 709536 714944 719115 722020 729548 730381 735392 736631 738053 741053 747454 751410 756798 757152 757232 759121 760567 762886 768387 771348 785188 786081 790843 793923 795600 798329 800706 800851 801026 812979 813150 817571 822042 822228 822694 823326 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ride big"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ride большие"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ride большие"
]
|
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.