Query Metrics
7
Database Queries
7
Different statements
175.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.89 ms (85.60%) |
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 492182 496296 539287 540132 540139 540159 547414 553317 554684 554714 554717 554723 558638 560342 562054 567515 568293 571708 575026 575326 577019 578148 583536 585812 596244 597763 598048 599232 601684 601830 606644 610199 628747 630254 632991 633182 634216 636707 641778 643705 649472 650139 657525 659009 659033 662214 662217 662220 669025 670266 670402 670813 671780 671782 671791 671991 675169 680778 680937 692713 692714 710452 710471 714737 716672 718581 720446 722966 725229 725669 727033 728517 733022 737605 738821 743376 744418 744820 746011 746021 746176 747137 747384 748927 748937 748964 748965 748974 749129 749620 750533 752736 757211 757212 757569 770039 775212 788111 790124 790371 790376 790381 794355 795416 796052 800489 800495 800506 800527 800913 800920 803700 807834 810076 817889 818377 818475 820768 820774 820778 ] |
||||||||||||||||||||||||||||||
|
14.10 ms (8.05%) |
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 659009 662217 649472 670813 692713 599232 636707 585812 643705 788111 795416 749129 800506 737605 744418 744820 770039 728517 748937 748965 725669 749620 757212 633182 720446 800920 817889 540132 539287 560342 577019 575326 575026 662214 680778 716672 671780 671782 710452 568293 598048 628747 634216 790371 800527 800913 725229 733022 790124 810076 727033 746011 748927 748964 746176 748974 752736 747384 757211 722966 796052 540139 540159 492182 583536 554723 671991 692714 657525 659033 675169 547414 554684 558638 597763 610199 630254 790376 790381 775212 800489 800495 803700 743376 747137 794355 807834 757569 746021 738821 750533 710471 714737 718581 818475 818377 820768 820774 820778 496296 554714 562054 571708 553317 567515 662220 671791 650139 680937 669025 670266 670402 554717 578148 601684 606644 641778 632991 596244 601830 ] |
||||||||||||||||||||||||||||||
|
4.18 ms (2.38%) |
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 492182 496296 539287 540132 540139 540159 547414 553317 554684 554714 554717 554723 558638 560342 562054 567515 568293 571708 575026 575326 577019 578148 583536 585812 596244 597763 598048 599232 601684 601830 606644 610199 628747 630254 632991 633182 634216 636707 641778 643705 649472 650139 657525 659009 659033 662214 662217 662220 669025 670266 670402 670813 671780 671782 671791 671991 675169 680778 680937 692713 692714 710452 710471 714737 716672 718581 720446 722966 725229 725669 727033 728517 733022 737605 738821 743376 744418 744820 746011 746021 746176 747137 747384 748927 748937 748964 748965 748974 749129 749620 750533 752736 757211 757212 757569 770039 775212 788111 790124 790371 790376 790381 794355 795416 796052 800489 800495 800506 800527 800913 800920 803700 807834 810076 817889 818377 818475 820768 820774 820778 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pee and"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pee"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pee"
]
|
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.