Query Metrics
7
Database Queries
7
Different statements
136.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.02 ms (84.75%) |
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 7677 119687 308582 367800 381813 388712 389877 397711 398023 432936 448757 450851 457399 477494 484245 512897 526228 535379 535549 540113 540121 548012 552277 554735 557160 581040 583580 588047 600277 602559 603124 604947 605230 618510 619702 623696 630252 631183 633402 634375 636965 636967 645638 651835 653691 654355 661316 669720 675025 681242 681741 681795 685664 687830 697744 699645 704412 712074 715703 730901 733368 733436 740270 740820 742021 744034 744098 746184 748410 749045 753636 753909 754064 754085 754312 757282 759379 763544 770167 773667 775109 777430 779644 785966 786018 788417 788758 789501 791350 795520 796799 797722 798755 799144 801449 802260 802919 803482 810216 811099 815407 817013 817554 818933 819167 819631 820570 823399 823487 824110 824359 825142 825608 827504 828030 828109 828218 828221 828227 828723 ] |
||||||||||||||||||||||||||||||
|
11.85 ms (8.65%) |
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 824359 828109 828218 484245 557160 619702 633402 600277 763544 748410 820570 823399 535549 554735 583580 552277 685664 661316 704412 681741 712074 636967 588047 786018 788758 746184 744034 618510 630252 697744 715703 777430 7677 432936 450851 603124 825142 827504 828723 540121 581040 730901 742021 753636 757282 770167 811099 754085 733368 779644 526228 367800 308582 825608 828221 828030 457399 535379 512897 645638 699645 602559 631183 798755 754312 753909 388712 448757 548012 477494 791350 119687 389877 398023 817554 824110 817013 819167 819631 818933 823487 815407 828227 540113 653691 669720 675025 681242 681795 651835 623696 636965 605230 634375 775109 795520 799144 802260 744098 759379 773667 789501 797722 754064 733436 785966 796799 802919 803482 810216 381813 654355 687830 604947 788417 749045 740270 740820 801449 397711 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.71%) |
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 7677 119687 308582 367800 381813 388712 389877 397711 398023 432936 448757 450851 457399 477494 484245 512897 526228 535379 535549 540113 540121 548012 552277 554735 557160 581040 583580 588047 600277 602559 603124 604947 605230 618510 619702 623696 630252 631183 633402 634375 636965 636967 645638 651835 653691 654355 661316 669720 675025 681242 681741 681795 685664 687830 697744 699645 704412 712074 715703 730901 733368 733436 740270 740820 742021 744034 744098 746184 748410 749045 753636 753909 754064 754085 754312 757282 759379 763544 770167 773667 775109 777430 779644 785966 786018 788417 788758 789501 791350 795520 796799 797722 798755 799144 801449 802260 802919 803482 810216 811099 815407 817013 817554 818933 819167 819631 820570 823399 823487 824110 824359 825142 825608 827504 828030 828109 828218 828221 828227 828723 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"glasses girl"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"очкастая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"очкастая девушк"
]
|
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.