Query Metrics
7
Database Queries
7
Different statements
139.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.06 ms (85.80%) |
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 386195 387615 391358 397081 398842 427783 438181 447966 469813 479576 490618 514219 526031 537474 539204 540633 572538 576511 579500 580466 585992 590765 591779 597507 608519 609285 612098 616178 618600 619997 620856 622790 626729 627838 629253 629472 631296 634585 635073 642430 645149 658015 658035 661495 684254 685125 686271 693150 698039 706754 708035 709393 713683 717048 718545 719770 722276 723116 724395 726263 729666 732849 734986 736352 739041 740181 741237 742239 744726 745513 746232 749007 749557 750229 757789 757987 759037 762035 763068 763414 763499 765556 766388 766519 767518 767962 768092 768826 770505 775698 775926 777171 777503 778750 779918 782401 782486 782497 785157 785984 787605 789487 792815 795614 796074 796086 796838 798345 801502 803816 803822 807261 808240 809957 810989 814182 819157 819910 824048 824577 ] |
||||||||||||||||||||||||||||||
|
10.55 ms (7.54%) |
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 708035 713683 576511 616178 619997 634585 642430 612098 618600 622790 626729 785157 785984 798345 808240 810989 777503 778750 779918 789487 801502 740181 749007 759037 765556 768826 782401 726263 732849 745513 766388 729666 757987 744726 767518 768092 629253 629472 635073 717048 719770 723116 782486 796074 391358 397081 438181 661495 684254 585992 608519 591779 741237 763414 766519 757789 734986 514219 819157 819910 447966 539204 540633 698039 658015 658035 685125 686271 722276 620856 627838 795614 807261 739041 746232 763499 742239 767962 796838 803816 469813 427783 580466 762035 386195 398842 814182 824048 824577 479576 490618 526031 537474 572538 579500 693150 645149 709393 631296 590765 597507 775698 775926 782497 796086 736352 770505 787605 803822 749557 724395 763068 750229 609285 706754 718545 777171 792815 809957 387615 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.71%) |
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 386195 387615 391358 397081 398842 427783 438181 447966 469813 479576 490618 514219 526031 537474 539204 540633 572538 576511 579500 580466 585992 590765 591779 597507 608519 609285 612098 616178 618600 619997 620856 622790 626729 627838 629253 629472 631296 634585 635073 642430 645149 658015 658035 661495 684254 685125 686271 693150 698039 706754 708035 709393 713683 717048 718545 719770 722276 723116 724395 726263 729666 732849 734986 736352 739041 740181 741237 742239 744726 745513 746232 749007 749557 750229 757789 757987 759037 762035 763068 763414 763499 765556 766388 766519 767518 767962 768092 768826 770505 775698 775926 777171 777503 778750 779918 782401 782486 782497 785157 785984 787605 789487 792815 795614 796074 796086 796838 798345 801502 803816 803822 807261 808240 809957 810989 814182 819157 819910 824048 824577 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl love"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк love"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк love"
]
|
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.