Query Metrics
7
Database Queries
7
Different statements
400.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.60 ms (52.64%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature межрасов"
]
|
||||||||||||||||||||||||||||||
|
164.11 ms (41.02%) |
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 44998 161731 302771 305976 338025 342450 386198 387160 387524 398518 398528 401115 406191 407654 409066 432700 432704 457177 464445 470400 477764 478320 517741 531097 531698 531914 534316 535026 535817 536366 537773 540537 544748 554525 556043 558078 558441 567730 585113 592147 600359 604435 604480 604952 617424 629409 629868 630043 634528 637567 643767 651107 651356 666582 666820 667278 668985 669225 671353 675007 678940 681691 712337 712770 712785 715534 715551 715555 715600 719925 720117 720357 721870 724283 725606 726487 726498 726515 726637 728738 729286 729644 732740 733570 737123 740824 742591 742764 743066 744593 750246 750852 755222 778038 785092 790859 790963 797734 798207 803449 804681 805110 805607 806164 806198 806225 808094 809257 811663 815279 815493 816233 816574 817080 817857 817889 823388 823944 824345 825241 ] |
||||||||||||||||||||||||||||||
|
15.14 ms (3.79%) |
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 755222 726637 634528 712337 715534 715551 715555 715600 720117 720357 804681 806164 809257 387160 401115 338025 398528 432704 534316 726487 585113 535026 531097 537773 558441 681691 675007 617424 464445 386198 161731 302771 305976 342450 44998 387524 398518 406191 407654 409066 432700 815279 817080 817889 825241 815493 816574 823388 823944 816233 817857 824345 470400 457177 477764 517741 540537 531698 531914 536366 535817 478320 544748 554525 556043 651107 651356 666820 667278 712785 719925 668985 669225 671353 666582 678940 712770 558078 567730 592147 600359 629409 604952 629868 630043 637567 643767 778038 790963 797734 806225 790859 798207 803449 805607 725606 729644 733570 742591 743066 805110 808094 811663 732740 740824 726515 742764 744593 724283 728738 729286 737123 750852 726498 750246 604435 604480 721870 785092 806198 ] |
||||||||||||||||||||||||||||||
|
4.02 ms (1.01%) |
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 44998 161731 302771 305976 338025 342450 386198 387160 387524 398518 398528 401115 406191 407654 409066 432700 432704 457177 464445 470400 477764 478320 517741 531097 531698 531914 534316 535026 535817 536366 537773 540537 544748 554525 556043 558078 558441 567730 585113 592147 600359 604435 604480 604952 617424 629409 629868 630043 634528 637567 643767 651107 651356 666582 666820 667278 668985 669225 671353 675007 678940 681691 712337 712770 712785 715534 715551 715555 715600 719925 720117 720357 721870 724283 725606 726487 726498 726515 726637 728738 729286 729644 732740 733570 737123 740824 742591 742764 743066 744593 750246 750852 755222 778038 785092 790859 790963 797734 798207 803449 804681 805110 805607 806164 806198 806225 808094 809257 811663 815279 815493 816233 816574 817080 817857 817889 823388 823944 824345 825241 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature and interracial"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature межрасов"
]
|
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.