Query Metrics
7
Database Queries
7
Different statements
224.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
198.31 ms (88.33%) |
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 381776 382661 382724 383046 384789 385000 386285 390001 392086 392903 393728 393756 394198 396522 396884 397059 397279 397387 398805 400457 400718 401958 402093 402245 402503 404267 405811 408708 418649 419674 425707 427179 445079 463168 465805 466187 469874 473549 473955 478361 484127 494367 495374 503922 513739 515070 515096 515219 515290 518933 521854 527513 545522 546692 548092 550602 551431 553863 558072 566519 566520 569659 570060 578474 580399 588747 593847 595863 596453 598696 599711 599747 622929 663899 664288 670486 677044 678803 684564 693076 693902 700654 704533 708459 708799 708800 708803 717109 717834 720439 724175 730600 731386 731914 743139 743158 743369 744296 744329 747839 759587 759590 759652 759653 766037 767950 775828 776881 780141 783780 784618 789198 790988 798992 799402 802632 805383 809125 817364 ] |
||||||||||||||||||||||||||||||
|
15.71 ms (7.00%) |
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 776881 381776 548092 580399 678803 566520 570060 578474 598696 595863 744329 400457 393728 515219 527513 553863 546692 743158 382661 731386 622929 809125 780141 784618 731914 401958 405811 393756 392903 402245 402093 418649 664288 677044 704533 386285 394198 463168 503922 397059 396884 599747 708803 743139 392086 402503 400718 469874 663899 789198 515070 566519 717834 382724 545522 693076 593847 805383 817364 717109 700654 767950 724175 802632 708459 790988 798992 759587 684564 708799 747839 766037 759652 744296 759653 708800 383046 551431 397387 427179 385000 515096 693902 743369 513739 518933 390001 408708 419674 473955 478361 484127 466187 404267 473549 397279 396522 521854 799402 783780 720439 495374 759590 775828 384789 670486 788760 730600 398805 425707 445079 550602 569659 558072 588747 596453 599711 465805 515290 494367 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.25%) |
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 381776 382661 382724 383046 384789 385000 386285 390001 392086 392903 393728 393756 394198 396522 396884 397059 397279 397387 398805 400457 400718 401958 402093 402245 402503 404267 405811 408708 418649 419674 425707 427179 445079 463168 465805 466187 469874 473549 473955 478361 484127 494367 495374 503922 513739 515070 515096 515219 515290 518933 521854 527513 545522 546692 548092 550602 551431 553863 558072 566519 566520 569659 570060 578474 580399 588747 593847 595863 596453 598696 599711 599747 622929 663899 664288 670486 677044 678803 684564 693076 693902 700654 704533 708459 708799 708800 708803 717109 717834 720439 724175 730600 731386 731914 743139 743158 743369 744296 744329 747839 759587 759590 759652 759653 766037 767950 775828 776881 780141 783780 784618 789198 790988 798992 799402 802632 805383 809125 817364 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old man girl"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old мужчин девушк"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old мужчин девушк"
]
|
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.