Query Metrics
7
Database Queries
7
Different statements
180.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.11 ms (85.15%) |
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 6937 120432 120497 384762 394136 396730 397808 398651 406406 406933 409862 412725 415005 415963 422330 426557 435225 436314 464857 465613 468603 470053 474294 477618 491606 501541 514145 515506 525679 531283 538818 540056 541377 551202 553722 560952 561807 563870 565491 567122 568034 568068 568210 569894 576590 596198 603603 605850 609899 617031 620196 628258 629194 637133 637721 638585 649105 649536 650039 656804 662042 664781 666858 671660 674452 687432 690450 695908 699624 702162 702268 703973 719022 721302 721443 721876 723167 724169 724366 725146 729644 739460 740373 745341 750187 751585 753638 754512 756719 765302 766910 769747 770541 772804 779711 784740 785051 786454 788133 788826 788859 790069 791572 792175 795893 797178 797505 798495 806676 815053 815137 815168 815495 815606 815774 815991 817276 823092 824864 824915 ] |
||||||||||||||||||||||||||||||
|
15.66 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 474294 551202 721443 637721 772804 786454 409862 435225 468603 514145 525679 491606 384762 815991 815168 540056 531283 719022 560952 406933 394136 815774 815495 538818 568034 568210 569894 666858 703973 721876 638585 596198 779711 795893 754512 120432 477618 662042 725146 769747 398651 120497 815137 823092 561807 553722 541377 649105 674452 687432 690450 656804 671660 699624 723167 567122 605850 620196 603603 609899 628258 788826 791572 792175 788859 790069 729644 740373 797178 797505 750187 751585 765302 766910 724366 739460 753638 770541 745341 756719 617031 784740 798495 515506 470053 568068 695908 702162 637133 788133 785051 6937 396730 406406 412725 815053 824915 815606 817276 824864 501541 563870 649536 650039 664781 576590 806676 724169 629194 702268 721302 397808 415005 426557 415963 464857 565491 422330 436314 465613 ] |
||||||||||||||||||||||||||||||
|
3.51 ms (1.94%) |
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 6937 120432 120497 384762 394136 396730 397808 398651 406406 406933 409862 412725 415005 415963 422330 426557 435225 436314 464857 465613 468603 470053 474294 477618 491606 501541 514145 515506 525679 531283 538818 540056 541377 551202 553722 560952 561807 563870 565491 567122 568034 568068 568210 569894 576590 596198 603603 605850 609899 617031 620196 628258 629194 637133 637721 638585 649105 649536 650039 656804 662042 664781 666858 671660 674452 687432 690450 695908 699624 702162 702268 703973 719022 721302 721443 721876 723167 724169 724366 725146 729644 739460 740373 745341 750187 751585 753638 754512 756719 765302 766910 769747 770541 772804 779711 784740 785051 786454 788133 788826 788859 790069 791572 792175 795893 797178 797505 798495 806676 815053 815137 815168 815495 815606 815774 815991 817276 823092 824864 824915 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal sport"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал спортивная"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.84%) |
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.