Query Metrics
7
Database Queries
7
Different statements
182.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.61 ms (84.16%) |
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 99145 381933 385440 394773 397639 401553 404275 404464 407681 408138 408207 411189 416030 416277 423318 425597 427898 432618 432675 440647 442144 443984 448051 450255 450455 450803 454541 458578 462915 463960 464202 471671 472907 474743 474756 481470 481665 482517 491934 496771 496802 501137 507217 517240 520686 523049 531782 535068 537640 540074 540478 542727 549881 585726 586652 592923 597682 610062 610580 615197 623804 626136 643264 643777 654257 673981 674452 678940 716277 716305 723738 723778 726631 730069 730364 731341 734996 735022 736093 737637 740225 744292 746486 750684 753542 758605 759886 760999 766592 766652 766808 769308 769311 774769 779969 785092 788831 792133 792184 795551 795686 796166 797020 798495 801618 804010 804549 804979 805717 806357 809291 813651 815765 816574 817836 818827 821899 824740 825981 828605 ] |
||||||||||||||||||||||||||||||
|
17.56 ms (9.62%) |
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 792184 795551 796166 801618 804010 804549 805717 806357 730069 759886 766652 766808 730364 731341 735022 746486 750684 758605 760999 610062 623804 792133 472907 817836 448051 407681 408207 462915 517240 458578 425597 416030 531782 540074 501137 542727 654257 615197 597682 643777 643264 774769 804979 404275 813651 818827 535068 408138 411189 496771 432675 440647 454541 463960 471671 795686 769308 769311 766592 432618 442144 825981 828605 549881 491934 824740 482517 385440 626136 523049 540478 496802 537640 394773 381933 404464 416277 423318 443984 481470 450455 464202 586652 809291 481665 450803 474743 397639 474756 427898 450255 520686 507217 99145 401553 716305 779969 788831 736093 740225 723738 723778 734996 737637 744292 726631 610580 797020 821899 816574 815765 674452 673981 716277 678940 585726 592923 753542 785092 798495 ] |
||||||||||||||||||||||||||||||
|
2.91 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 99145 381933 385440 394773 397639 401553 404275 404464 407681 408138 408207 411189 416030 416277 423318 425597 427898 432618 432675 440647 442144 443984 448051 450255 450455 450803 454541 458578 462915 463960 464202 471671 472907 474743 474756 481470 481665 482517 491934 496771 496802 501137 507217 517240 520686 523049 531782 535068 537640 540074 540478 542727 549881 585726 586652 592923 597682 610062 610580 615197 623804 626136 643264 643777 654257 673981 674452 678940 716277 716305 723738 723778 726631 730069 730364 731341 734996 735022 736093 737637 740225 744292 746486 750684 753542 758605 759886 760999 766592 766652 766808 769308 769311 774769 779969 785092 788831 792133 792184 795551 795686 796166 797020 798495 801618 804010 804549 804979 805717 806357 809291 813651 815765 816574 817836 818827 821899 824740 825981 828605 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"латин мама"
]
|
||||||||||||||||||||||||||||||
|
2.24 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.04%) |
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.