Query Metrics
7
Database Queries
7
Different statements
370.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.85 ms (56.66%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
140.14 ms (37.84%) |
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 402892 523986 529357 594413 606282 608439 608609 630821 633649 644022 683034 691469 696291 701005 703715 703729 705084 712359 714421 714569 714980 715001 718053 718463 718583 718629 720169 721691 723091 723957 724735 724817 724894 725054 725060 725088 725545 726848 727260 728513 728633 728837 728949 729045 730119 730185 730215 730974 731277 733190 733952 734102 734296 734340 735428 735735 736643 737807 738328 738330 738829 739240 739544 739633 739662 743001 743793 744056 744841 745534 745944 746393 746637 746745 747990 747994 748406 750144 750635 750902 751192 753218 753524 754115 755207 755464 757902 758683 760231 761440 763250 763573 763644 764418 765034 772773 774933 781111 781465 786466 786841 793139 796701 797913 799056 801528 801998 802618 803421 808828 810044 813527 816651 821126 824812 825005 825648 826588 828570 ] |
||||||||||||||||||||||||||||||
|
11.90 ms (3.21%) |
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 796701 801528 801998 725060 725088 725545 726848 728633 730215 735428 743001 746393 746745 750635 753218 758683 761440 763573 772773 786466 786832 786841 793139 797913 808828 813527 724817 727260 728513 728949 730974 731277 734340 737807 738328 739633 744841 747990 747994 750902 754115 723957 729045 733952 735735 736643 738829 739240 739662 745534 748406 753524 755207 760231 765034 728837 733190 739544 746637 751192 757902 763250 764418 724735 725054 730119 730185 738330 743793 744056 745944 750144 755464 763644 608439 633649 644022 703715 703729 712359 714421 714569 714980 718053 718463 718583 718629 720169 774933 781111 781465 799056 802618 803421 810044 402892 824812 816651 821126 825005 825648 826588 828570 523986 529357 691469 696291 701005 721691 723091 705084 683034 715001 594413 606282 608609 630821 724894 734102 734296 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (0.80%) |
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 402892 523986 529357 594413 606282 608439 608609 630821 633649 644022 683034 691469 696291 701005 703715 703729 705084 712359 714421 714569 714980 715001 718053 718463 718583 718629 720169 721691 723091 723957 724735 724817 724894 725054 725060 725088 725545 726848 727260 728513 728633 728837 728949 729045 730119 730185 730215 730974 731277 733190 733952 734102 734296 734340 735428 735735 736643 737807 738328 738330 738829 739240 739544 739633 739662 743001 743793 744056 744841 745534 745944 746393 746637 746745 747990 747994 748406 750144 750635 750902 751192 753218 753524 754115 755207 755464 757902 758683 760231 761440 763250 763573 763644 764418 765034 772773 774933 781111 781465 786466 786841 793139 796701 797913 799056 801528 801998 802618 803421 808828 810044 813527 816651 821126 824812 825005 825648 826588 828570 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cock cum"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cock cum"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cock cum"
]
|
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.