Query Metrics
7
Database Queries
7
Different statements
141.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.39 ms (84.47%) |
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 34123 80203 382376 384972 425536 453254 453462 459777 471486 474431 485328 488017 508647 523013 534580 540627 546570 548267 563960 568462 583193 593714 607253 608236 612292 612578 616687 621725 624649 650964 653228 669685 672764 705339 707431 713509 713651 717229 717914 718026 718758 719165 722189 723173 724728 725627 726050 726208 726381 728759 729538 731685 733356 736422 737371 738335 738737 739540 740045 741212 742193 747610 758204 759400 761180 762499 764993 765025 767314 767403 767961 769610 775903 775909 775930 775939 775940 775943 775944 775945 775957 777536 780149 780465 782885 783064 783689 785019 787157 787518 787975 789924 790563 790746 791156 791702 791819 794057 795553 795575 796264 799689 800419 805361 807305 808253 809484 810344 810576 813495 814328 817797 818021 819676 819882 821307 825359 826305 826557 827313 ] |
||||||||||||||||||||||||||||||
|
12.61 ms (8.92%) |
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 775909 775943 775945 796264 808253 810344 733356 762499 791702 769610 742193 724728 758204 717229 775930 775940 785019 548267 726381 523013 382376 794057 80203 669685 672764 775957 787518 799689 775939 783064 807305 767961 726208 747610 761180 612578 722189 775944 818021 821307 826305 819882 827313 534580 546570 563960 705339 718758 718026 612292 780465 787975 790563 739540 767314 787157 791819 813495 731685 728759 719165 791156 759400 783689 723173 707431 593714 789924 795575 738335 767403 790746 459777 540627 608236 737371 740045 800419 810576 34123 425536 825359 826557 819676 474431 568462 583193 713509 650964 653228 713651 607253 616687 621725 782885 795553 805361 736422 741212 725627 726050 738737 765025 624649 780149 384972 488017 453254 453462 485328 508647 717914 775903 777536 729538 764993 809484 471486 817797 814328 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.72%) |
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 34123 80203 382376 384972 425536 453254 453462 459777 471486 474431 485328 488017 508647 523013 534580 540627 546570 548267 563960 568462 583193 593714 607253 608236 612292 612578 616687 621725 624649 650964 653228 669685 672764 705339 707431 713509 713651 717229 717914 718026 718758 719165 722189 723173 724728 725627 726050 726208 726381 728759 729538 731685 733356 736422 737371 738335 738737 739540 740045 741212 742193 747610 758204 759400 761180 762499 764993 765025 767314 767403 767961 769610 775903 775909 775930 775939 775940 775943 775944 775945 775957 777536 780149 780465 782885 783064 783689 785019 787157 787518 787975 789924 790563 790746 791156 791702 791819 794057 795553 795575 796264 799689 800419 805361 807305 808253 809484 810344 810576 813495 814328 817797 818021 819676 819882 821307 825359 826305 826557 827313 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"swallows sperm"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"swallows сперм"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"swallows сперм"
]
|
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.