Query Metrics
7
Database Queries
7
Different statements
148.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.61 ms (85.44%) |
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 398588 402892 421144 422129 422350 425733 441815 452694 467859 479200 480251 512413 535806 546560 552385 553701 557922 559616 560791 575238 581289 584956 585905 586978 593810 597829 623407 624028 628702 634597 634614 634619 653952 663223 666402 674616 675410 689970 692710 695693 697731 703327 704361 710784 712526 717958 719211 719821 722121 722124 722165 724688 725331 726939 728865 731140 731429 733138 733297 734007 734140 735009 735322 735446 736497 740005 741760 743422 749417 749592 752082 755615 764581 764749 766966 767805 768803 772371 772826 774265 777452 777508 777928 778753 779047 779533 779850 780233 780405 781465 784056 784196 784686 786821 787116 787273 787409 790577 791250 792208 793759 799991 803416 803421 808840 810216 813323 814675 816156 819332 820091 825364 825399 825977 826373 827031 827141 827690 ] |
||||||||||||||||||||||||||||||
|
12.34 ms (8.32%) |
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 731429 764581 779047 781465 784056 803421 810216 402892 559616 634614 743422 808840 735446 441815 552385 634597 725331 726939 722124 512413 689970 791250 422129 535806 546560 663223 703327 666402 674616 695693 697731 704361 710784 624028 623407 634619 597829 787273 749592 784686 724688 766966 728865 717958 719821 820091 452694 653952 675410 712526 628702 593810 586978 803416 784196 479200 692710 585905 560791 467859 398588 825364 825399 827031 827141 816156 819332 722165 575238 584956 777452 777508 778753 787116 799991 777928 779533 792208 813323 749417 755615 767805 772371 772826 787409 734007 764749 774265 731140 735322 736497 752082 765378 733297 740005 768803 735009 722121 780233 786821 793759 422350 814675 557922 734140 741760 421144 733138 425733 825977 826373 816149 827690 480251 553701 719211 581289 780405 790577 779850 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (2.21%) |
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 398588 402892 421144 422129 422350 425733 441815 452694 467859 479200 480251 512413 535806 546560 552385 553701 557922 559616 560791 575238 581289 584956 585905 586978 593810 597829 623407 624028 628702 634597 634614 634619 653952 663223 666402 674616 675410 689970 692710 695693 697731 703327 704361 710784 712526 717958 719211 719821 722121 722124 722165 724688 725331 726939 728865 731140 731429 733138 733297 734007 734140 735009 735322 735446 736497 740005 741760 743422 749417 749592 752082 755615 764581 764749 766966 767805 768803 772371 772826 774265 777452 777508 777928 778753 779047 779533 779850 780233 780405 781465 784056 784196 784686 786821 787116 787273 787409 790577 791250 792208 793759 799991 803416 803421 808840 810216 813323 814675 816156 819332 820091 825364 825399 825977 826373 827031 827141 827690 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur mouth cum"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск mouth cum"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск mouth 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.