Query Metrics
7
Database Queries
7
Different statements
268.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
245.82 ms (91.55%) |
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 453273 465672 470033 471977 472698 477154 480656 490598 491108 492542 501618 507031 507624 509098 511117 511314 514620 515025 517539 529676 529838 530566 531370 532818 533662 536298 538057 545143 545920 546132 546139 547007 547408 557965 558724 568221 570940 570950 577088 577116 580862 583232 584314 588429 592228 592938 596158 602210 603198 603383 603768 605485 605628 607573 607690 609721 610062 623804 636429 643284 662401 664556 705376 709276 714309 714331 714409 714450 725444 725492 730641 731127 731154 731189 735338 738334 741773 741789 742104 742647 742770 744394 744423 745324 746138 751479 753699 754656 757222 758168 758274 758306 758347 758358 759125 762227 790193 793504 793506 800654 800739 802365 803049 803396 803820 804433 807424 807868 808153 810094 810096 810098 812407 812551 812725 816184 819645 823582 824555 827398 ] |
||||||||||||||||||||||||||||||
|
12.85 ms (4.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 623804 714450 480656 490598 790193 741773 583232 584314 816184 819645 827398 824555 465672 517539 511117 538057 545143 547007 580862 714409 546139 603383 803049 810096 812407 802365 803396 741789 758347 793506 812551 725444 742770 744423 731189 762227 731154 793504 803820 804433 807868 471977 470033 568221 603198 605628 643284 596158 607690 742647 532818 511314 800654 808153 714309 725492 515025 507031 477154 570940 636429 509098 491108 605485 507624 823582 492542 453273 514620 530566 536298 501618 529838 531370 529676 533662 547408 558724 545920 557965 577088 546132 570950 577116 662401 709276 714331 602210 607573 609721 588429 807424 738334 742104 753699 754656 757222 758306 759125 800739 810094 730641 745324 744394 746138 758274 731127 735338 751479 758168 758358 610062 810098 812725 705376 472698 664556 592228 592938 603768 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.14%) |
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 453273 465672 470033 471977 472698 477154 480656 490598 491108 492542 501618 507031 507624 509098 511117 511314 514620 515025 517539 529676 529838 530566 531370 532818 533662 536298 538057 545143 545920 546132 546139 547007 547408 557965 558724 568221 570940 570950 577088 577116 580862 583232 584314 588429 592228 592938 596158 602210 603198 603383 603768 605485 605628 607573 607690 609721 610062 623804 636429 643284 662401 664556 705376 709276 714309 714331 714409 714450 725444 725492 730641 731127 731154 731189 735338 738334 741773 741789 742104 742647 742770 744394 744423 745324 746138 751479 753699 754656 757222 758168 758274 758306 758347 758358 759125 762227 790193 793504 793506 800654 800739 802365 803049 803396 803820 804433 807424 807868 808153 810094 810096 810098 812407 812551 812725 816184 819645 823582 824555 827398 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade erotic mature"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.67%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск эротик mature"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск эротик mature"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.56%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.