Query Metrics
7
Database Queries
7
Different statements
161.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.71 ms (84.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 482954 485426 509203 532827 536324 536447 537078 539460 542259 543546 543679 543747 543978 544981 545662 545911 547979 551252 554190 556601 557506 558000 566440 566672 567100 567902 575223 598955 613374 613861 619899 632949 650628 655092 659695 663808 666502 668285 678972 692441 695358 695402 695417 695545 695840 698158 700086 701901 714647 715498 715965 717095 721475 721572 722200 730511 731024 733702 738342 740837 755054 757924 759586 766492 777178 777242 777869 778506 778710 778770 778985 780806 781139 781381 781670 781709 781734 782674 783247 785867 785881 787654 788053 789366 789400 789931 794099 794406 795063 795635 795664 795947 796609 797932 799920 800226 802263 802341 803380 808313 808320 811142 811969 812215 818013 819350 819851 820218 820314 823579 824294 825523 825645 826194 826197 826233 826975 827657 828443 ] |
||||||||||||||||||||||||||||||
|
17.22 ms (10.66%) |
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 825645 826197 818013 819350 819851 820218 820314 823579 824294 825523 826194 826233 826975 827657 828443 482954 485426 532827 537078 536324 509203 536447 539460 554190 567100 542259 543546 543747 543978 544981 556601 567902 543679 545662 545911 547979 551252 557506 558000 666502 695358 695402 700086 701901 715965 722200 668285 678972 695545 721475 721572 650628 655092 659695 663808 692441 695417 695840 698158 702293 714647 715498 717095 566440 566672 575223 613374 632949 598955 613861 619899 777242 778506 778710 780806 781139 781670 781734 785867 785881 788053 789366 789931 794099 794406 795063 795635 802263 802341 808313 811142 777178 777869 778770 778985 781381 781709 782674 783247 787654 789400 795664 795947 796609 797932 799920 800226 803380 808320 811969 812215 730511 731024 733702 738342 740837 755054 757924 759586 766492 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.52%) |
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 482954 485426 509203 532827 536324 536447 537078 539460 542259 543546 543679 543747 543978 544981 545662 545911 547979 551252 554190 556601 557506 558000 566440 566672 567100 567902 575223 598955 613374 613861 619899 632949 650628 655092 659695 663808 666502 668285 678972 692441 695358 695402 695417 695545 695840 698158 700086 701901 714647 715498 715965 717095 721475 721572 722200 730511 731024 733702 738342 740837 755054 757924 759586 766492 777178 777242 777869 778506 778710 778770 778985 780806 781139 781381 781670 781709 781734 782674 783247 785867 785881 787654 788053 789366 789400 789931 794099 794406 795063 795635 795664 795947 796609 797932 799920 800226 802263 802341 803380 808313 808320 811142 811969 812215 818013 819350 819851 820218 820314 823579 824294 825523 825645 826194 826197 826233 826975 827657 828443 ] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"saggy russian"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"saggy русск"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"saggy русск"
]
|
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.