Query Metrics
7
Database Queries
7
Different statements
169.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.37 ms (84.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 233042 400619 430858 448998 454516 460029 466488 478007 488260 496400 498720 509185 513210 524058 525596 526804 527784 530969 531760 536468 536567 537822 538455 538717 539977 543187 554180 568902 569637 591104 604988 605147 605719 607434 614848 616991 617596 621761 627636 628591 641444 642187 657514 662117 676717 677749 677907 678699 678836 679836 683672 690634 693789 696194 696775 701660 710851 714531 718746 718793 720870 723851 736048 736097 738285 739140 740258 741243 741343 746573 746785 747433 749078 754537 756708 756999 758953 759701 760170 762208 768793 769286 772637 774727 776053 776818 778101 778863 784048 785250 787179 798481 799646 800739 800744 801828 802932 804453 804679 804782 805145 806535 807263 807432 808561 810169 810180 810390 810799 810892 810920 810965 811599 811912 812394 813710 814202 815462 818781 826387 ] |
||||||||||||||||||||||||||||||
|
15.44 ms (9.13%) |
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 642187 776818 778863 811599 811912 802932 804782 810892 736097 746573 800739 801828 804453 804679 723851 741243 754537 760170 762208 710851 774727 800744 806535 807432 498720 496400 554180 696194 627636 617596 778101 810920 746785 756999 758953 812394 739140 740258 756708 810799 810965 814202 813710 537822 538717 488260 543187 657514 604988 605719 616991 591104 785250 714531 400619 448998 526804 454516 513210 536468 536567 539977 678699 718746 662117 676717 683672 677749 690634 696775 605147 607434 621761 628591 641444 799646 805145 808561 807263 810180 749078 772637 784048 741343 768793 747433 738285 736048 718793 787179 233042 568902 478007 569637 524058 525596 701660 810169 798481 460029 527784 530969 531760 538455 677907 810390 769286 776053 430858 466488 815462 826387 818781 509185 678836 679836 693789 720870 614848 759701 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (1.98%) |
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 233042 400619 430858 448998 454516 460029 466488 478007 488260 496400 498720 509185 513210 524058 525596 526804 527784 530969 531760 536468 536567 537822 538455 538717 539977 543187 554180 568902 569637 591104 604988 605147 605719 607434 614848 616991 617596 621761 627636 628591 641444 642187 657514 662117 676717 677749 677907 678699 678836 679836 683672 690634 693789 696194 696775 701660 710851 714531 718746 718793 720870 723851 736048 736097 738285 739140 740258 741243 741343 746573 746785 747433 749078 754537 756708 756999 758953 759701 760170 762208 768793 769286 772637 774727 776053 776818 778101 778863 784048 785250 787179 798481 799646 800739 800744 801828 802932 804453 804679 804782 805145 806535 807263 807432 808561 810169 810180 810390 810799 810892 810920 810965 811599 811912 812394 813710 814202 815462 818781 826387 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl masturbates"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк masturbates"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк masturbates"
]
|
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.