Query Metrics
7
Database Queries
7
Different statements
239.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.18 ms (89.53%) |
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 383954 384162 392547 401201 423497 445426 455924 508550 531767 534331 544369 545114 568221 578807 581236 586618 592190 592633 593809 601303 603508 605547 606752 608544 609634 620737 620828 625240 630369 639037 639293 645770 645912 646077 647809 649536 650658 653230 656660 657879 660407 660418 665905 670964 680431 681126 686813 691226 693367 696722 700924 702274 713671 715761 715800 717942 718134 719996 720661 724849 728259 738199 740413 741583 742025 743786 746486 750100 750719 750910 753497 756678 757459 757792 758152 759542 760689 760892 761085 762270 764871 765335 765759 765896 766598 767377 771326 777513 777696 777996 778846 779140 780156 780873 783416 786041 787217 788414 789450 790061 791468 791537 793221 794294 796092 796134 797094 798887 801175 801282 801630 805404 815849 817255 818635 822203 824580 824585 827876 ] |
||||||||||||||||||||||||||||||
|
13.58 ms (5.67%) |
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 568221 545114 647809 665905 700924 645770 646077 650658 717942 620828 586618 593809 603508 592633 777513 801175 780156 801282 753497 757792 765335 790061 791537 728259 758152 766598 740413 743786 771326 741583 757459 609634 630369 702274 777996 778846 783416 787217 797094 384162 445426 818635 649536 653230 761085 764871 383954 392547 423497 817255 815849 824580 824585 827876 534331 581236 656660 670964 680431 645912 691226 715800 719996 720661 578807 592190 625240 601303 608544 639293 605547 620737 780873 793221 779140 796134 762270 801630 805404 750910 760892 750719 756678 767377 746486 750100 765759 606752 696722 796092 401201 765896 822203 455924 531767 508550 544369 657879 660418 686813 713671 715761 660407 681126 693367 718134 639037 786041 788414 789450 794294 798887 777696 760689 791468 738199 742025 724849 765106 759542 ] |
||||||||||||||||||||||||||||||
|
4.10 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 383954 384162 392547 401201 423497 445426 455924 508550 531767 534331 544369 545114 568221 578807 581236 586618 592190 592633 593809 601303 603508 605547 606752 608544 609634 620737 620828 625240 630369 639037 639293 645770 645912 646077 647809 649536 650658 653230 656660 657879 660407 660418 665905 670964 680431 681126 686813 691226 693367 696722 700924 702274 713671 715761 715800 717942 718134 719996 720661 724849 728259 738199 740413 741583 742025 743786 746486 750100 750719 750910 753497 756678 757459 757792 758152 759542 760689 760892 761085 762270 764871 765335 765759 765896 766598 767377 771326 777513 777696 777996 778846 779140 780156 780873 783416 786041 787217 788414 789450 790061 791468 791537 793221 794294 796092 796134 797094 798887 801175 801282 801630 805404 815849 817255 818635 822203 824580 824585 827876 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"her жоп"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"in her ass"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"her жоп"
]
|
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.