Query Metrics
7
Database Queries
7
Different statements
147.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.64 ms (82.43%) |
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 13066 95788 187567 187953 191048 382697 386682 388821 391908 399824 403283 405175 406289 411854 422688 426698 427974 451963 453812 456680 464025 464384 466316 466731 470547 470637 473846 475115 476838 477943 478555 480340 480752 485100 492691 493893 497388 502021 518744 522794 536898 538814 540089 541246 544112 556535 559374 560368 561087 561140 562803 566155 566577 567338 568997 568999 587505 587797 593872 598745 606496 607129 608376 612863 613300 615575 640530 641744 644894 645105 645880 648526 649837 649902 650165 650487 650781 653628 664591 666149 666796 666841 670769 675971 675986 676402 677706 683228 692463 697789 710212 710407 720115 720720 722876 731774 733020 736263 746876 748551 748909 758298 761506 770300 789708 794795 801069 802109 807927 809636 809941 810822 814392 814946 815124 815952 816475 817341 817922 828157 ] |
||||||||||||||||||||||||||||||
|
15.81 ms (10.71%) |
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 492691 473846 478555 544112 587797 470547 648526 640530 566155 386682 566577 411854 191048 466731 541246 480340 485100 567338 405175 422688 802109 593872 480752 720720 464025 187953 493893 677706 562803 683228 456680 568999 560368 587505 748551 809636 426698 502021 497388 666796 675986 710407 606496 746876 770300 794795 475115 615575 815124 649902 650781 666149 187567 470637 675971 676402 522794 464384 645105 536898 612863 613300 664591 466316 568997 561087 561140 645880 608376 13066 644894 816475 828157 540089 649837 692463 641744 809941 382697 556535 453812 406289 748909 607129 391908 477943 427974 95788 817922 817341 815952 814946 538814 653628 722876 666841 710212 789708 801069 736263 758298 731774 733020 761506 697789 476838 388821 518744 814392 451963 650487 720115 650165 807927 810822 403283 670769 559374 399824 598745 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.99%) |
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 13066 95788 187567 187953 191048 382697 386682 388821 391908 399824 403283 405175 406289 411854 422688 426698 427974 451963 453812 456680 464025 464384 466316 466731 470547 470637 473846 475115 476838 477943 478555 480340 480752 485100 492691 493893 497388 502021 518744 522794 536898 538814 540089 541246 544112 556535 559374 560368 561087 561140 562803 566155 566577 567338 568997 568999 587505 587797 593872 598745 606496 607129 608376 612863 613300 615575 640530 641744 644894 645105 645880 648526 649837 649902 650165 650487 650781 653628 664591 666149 666796 666841 670769 675971 675986 676402 677706 683228 692463 697789 710212 710407 720115 720720 722876 731774 733020 736263 746876 748551 748909 758298 761506 770300 789708 794795 801069 802109 807927 809636 809941 810822 814392 814946 815124 815952 816475 817341 817922 828157 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"threesome stockings"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.03%) |
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.