Query Metrics
7
Database Queries
7
Different statements
148.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.00 ms (84.31%) |
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 6640 38135 82143 198616 383659 425459 426467 444349 460475 471066 485021 495308 499911 505935 507488 525367 529729 535701 546907 554960 556160 569971 578740 583633 586542 588221 591005 598929 605828 616007 621464 627491 632296 661378 672833 679361 680650 681075 699277 700652 708594 714254 714564 716915 718729 719563 721903 729031 729132 729683 734414 736379 740070 741075 742698 742824 743329 743350 746594 750729 751767 753043 753646 753849 756342 758269 758624 759160 767991 768200 768969 770367 770981 773114 773444 774828 778602 779341 782052 782766 783841 784347 784446 785873 786260 788302 788956 789278 795678 796027 798763 800107 800129 800654 801517 804030 804098 804300 804413 805544 807003 807593 807740 810037 811785 812053 812447 813261 813745 814378 815540 815692 817887 820577 820664 821554 824634 825340 825488 826560 ] |
||||||||||||||||||||||||||||||
|
13.86 ms (9.35%) |
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 425459 38135 495308 505935 708594 718729 680650 588221 804300 773444 815692 810037 740070 750729 6640 817887 826560 821554 824634 820664 825340 825488 471066 525367 507488 460475 583633 554960 556160 699277 714564 661378 716915 700652 714254 719563 578740 598929 605828 632296 774828 783841 785873 786260 784446 788956 796027 798763 801517 807740 812447 734414 743350 758624 768200 805544 807593 811785 742698 758269 729683 736379 759160 768969 729031 756342 767991 770367 773114 782052 800654 813261 198616 444349 820577 672833 591005 746594 743329 426467 813745 815540 485021 499911 535701 529729 546907 679361 721903 681075 569971 586542 616007 627491 804030 807003 789278 795678 729132 782766 788302 800107 800129 753646 753849 741075 742824 751767 753043 770981 778602 779341 784347 804098 804413 812053 82143 383659 621464 814378 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.63%) |
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 6640 38135 82143 198616 383659 425459 426467 444349 460475 471066 485021 495308 499911 505935 507488 525367 529729 535701 546907 554960 556160 569971 578740 583633 586542 588221 591005 598929 605828 616007 621464 627491 632296 661378 672833 679361 680650 681075 699277 700652 708594 714254 714564 716915 718729 719563 721903 729031 729132 729683 734414 736379 740070 741075 742698 742824 743329 743350 746594 750729 751767 753043 753646 753849 756342 758269 758624 759160 767991 768200 768969 770367 770981 773114 773444 774828 778602 779341 782052 782766 783841 784347 784446 785873 786260 788302 788956 789278 795678 796027 798763 800107 800129 800654 801517 804030 804098 804300 804413 805544 807003 807593 807740 810037 811785 812053 812447 813261 813745 814378 815540 815692 817887 820577 820664 821554 824634 825340 825488 826560 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"her pussy"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"her pussy"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"her pussy"
]
|
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.