Query Metrics
7
Database Queries
7
Different statements
376.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.11 ms (56.67%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fucked hard 18"
]
|
||||||||||||||||||||||||||||||
|
140.88 ms (37.46%) |
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 384963 386567 392477 397288 398204 399194 408711 423725 435364 461275 463302 467174 472427 497365 503529 504581 509088 510535 517573 518348 526387 534430 540176 541817 545131 545712 551674 554956 556592 558218 561901 567558 567567 570403 571557 571727 572213 579650 588463 592429 594271 600682 610109 614571 616820 621671 621733 630825 636062 641207 643624 652519 653494 659452 659970 662172 663721 664151 669003 672586 672589 677375 684369 687422 691674 695775 698847 701509 704654 709228 709935 712814 712987 714901 714937 716744 718190 718278 720163 722833 724307 725713 729962 739792 750195 750852 758486 761619 762041 762928 765234 767098 770096 770456 770956 771770 772442 774295 774833 774883 775237 778702 778936 783896 785554 788515 789499 789926 790207 790514 790951 791681 797189 804876 807585 808318 809605 810414 813764 814424 ] |
||||||||||||||||||||||||||||||
|
13.84 ms (3.68%) |
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 545712 652519 677375 729962 463302 398204 663721 669003 704654 712987 720163 554956 774833 775237 790951 797189 765234 724307 750852 767098 758486 761619 714901 778936 408711 397288 461275 423725 503529 534430 540176 467174 551674 545131 561901 570403 571557 572213 659452 712814 653494 691674 709228 718190 621733 643624 630825 600682 778702 790207 809605 804876 771770 785554 399194 435364 384963 472427 504581 509088 541817 510535 518348 386567 392477 813764 814424 497365 517573 526387 558218 567567 556592 579650 672586 687422 716744 722833 662172 664151 684369 695775 698847 701509 709935 659970 672589 567558 571727 610109 592429 614571 616820 636062 588463 594271 621671 641207 774883 788515 790514 807585 789499 791681 808318 770096 774295 789926 810414 739792 762041 770456 770956 725713 762928 772442 750195 714937 718278 783896 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (0.78%) |
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 384963 386567 392477 397288 398204 399194 408711 423725 435364 461275 463302 467174 472427 497365 503529 504581 509088 510535 517573 518348 526387 534430 540176 541817 545131 545712 551674 554956 556592 558218 561901 567558 567567 570403 571557 571727 572213 579650 588463 592429 594271 600682 610109 614571 616820 621671 621733 630825 636062 641207 643624 652519 653494 659452 659970 662172 663721 664151 669003 672586 672589 677375 684369 687422 691674 695775 698847 701509 704654 709228 709935 712814 712987 714901 714937 716744 718190 718278 720163 722833 724307 725713 729962 739792 750195 750852 758486 761619 762041 762928 765234 767098 770096 770456 770956 771770 772442 774295 774833 774883 775237 778702 778936 783896 785554 788515 789499 789926 790207 790514 790951 791681 797189 804876 807585 808318 809605 810414 813764 814424 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fucked hard 18"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fucked hard 18"
]
|
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.