Query Metrics
7
Database Queries
7
Different statements
194.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.81 ms (85.25%) |
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 88591 135519 156525 197527 247954 308832 382906 383687 383888 386725 387808 391270 391535 391928 393790 394582 396378 396623 397708 398678 404477 419120 419324 427339 429872 444251 457205 458561 459887 461580 464268 464716 469647 469673 470192 475524 476655 482737 491244 495328 503690 506441 507405 510570 526291 530652 537107 539316 543569 547871 552324 552908 560576 561451 562526 564049 569160 571187 578652 581747 585537 585677 599748 603054 606594 607444 629311 635355 636358 642788 649059 651852 652884 654784 655295 659176 661036 665247 670238 670825 672388 676573 676679 694539 694962 707388 712707 717079 718856 730269 737563 742696 745054 745744 754653 760790 768287 774730 783357 787334 793576 794413 794718 794810 795778 799769 804265 808281 811862 811882 811900 818778 819661 820124 823918 824465 824989 825298 826073 828482 ] |
||||||||||||||||||||||||||||||
|
16.71 ms (8.59%) |
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 386725 457205 543569 569160 694962 717079 712707 635355 811900 754653 768287 387808 247954 391535 382906 826073 828482 547871 642788 464716 475524 419120 654784 665247 774730 794810 745744 730269 396623 818778 824465 823918 491244 539316 530652 571187 578652 581747 670825 676679 629311 585537 795778 808281 793576 383888 156525 396378 537107 599748 804265 469673 464268 197527 564049 787334 397708 476655 560576 651852 652884 655295 649059 670238 707388 606594 603054 811882 799769 760790 737563 742696 811862 459887 482737 383687 135519 718856 794413 308832 391928 88591 444251 427339 458561 503690 510570 552324 552908 561451 404477 429872 470192 393790 398678 461580 469647 526291 506441 507405 495328 419324 694539 672388 394582 391270 820124 824989 819661 825298 562526 661036 659176 676573 636358 585677 783357 794718 745054 607444 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.60%) |
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 88591 135519 156525 197527 247954 308832 382906 383687 383888 386725 387808 391270 391535 391928 393790 394582 396378 396623 397708 398678 404477 419120 419324 427339 429872 444251 457205 458561 459887 461580 464268 464716 469647 469673 470192 475524 476655 482737 491244 495328 503690 506441 507405 510570 526291 530652 537107 539316 543569 547871 552324 552908 560576 561451 562526 564049 569160 571187 578652 581747 585537 585677 599748 603054 606594 607444 629311 635355 636358 642788 649059 651852 652884 654784 655295 659176 661036 665247 670238 670825 672388 676573 676679 694539 694962 707388 712707 717079 718856 730269 737563 742696 745054 745744 754653 760790 768287 774730 783357 787334 793576 794413 794718 794810 795778 799769 804265 808281 811862 811882 811900 818778 819661 820124 823918 824465 824989 825298 826073 828482 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая ван"
]
|
||||||||||||||||||||||||||||||
|
2.20 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"черноволосая ван"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette bathroom"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.83%) |
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.