Query Metrics
7
Database Queries
7
Different statements
558.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
328.88 ms (58.85%) |
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 364242 390794 392789 393865 398542 400143 400156 403600 407154 407384 408293 415598 425360 430835 432834 437583 449218 450399 450843 450855 455281 456736 460191 460555 464189 477335 478107 481874 482251 505973 510287 518046 521997 527687 530546 532058 532112 532134 533474 533959 534079 535010 539460 547705 551717 559008 561609 563443 566257 571508 579371 584106 584739 585434 589199 601234 602959 605560 607311 608355 622710 639152 646199 653126 653127 660618 660622 661944 680830 691819 692424 695128 702454 702707 709440 712041 714523 717688 718459 726882 729884 732171 732989 734759 735518 740768 741268 744173 744183 750883 750890 750922 756803 760714 762218 764142 769487 771730 775738 775739 781244 784304 788804 791120 798594 807378 807407 810760 812885 814414 816766 816773 818212 819175 820323 823619 823637 824767 824832 827868 ] |
||||||||||||||||||||||||||||||
|
210.79 ms (37.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
10.54 ms (1.89%) |
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 812885 769487 756803 726882 639152 810760 464189 482251 460191 415598 450855 390794 400156 450399 527687 518046 521997 505973 646199 566257 477335 392789 398542 407384 425360 816766 816773 823619 824767 814414 823637 818212 819175 824832 820323 827868 460555 450843 532134 533474 534079 530546 532112 539460 532058 547705 551717 584106 680830 712041 653126 653127 660618 691819 702707 709440 717688 718459 660622 661944 692424 695128 561609 589199 585434 607311 608355 775738 807378 729884 734759 741268 744173 744183 750922 791120 798594 732989 750890 735518 760714 762218 764142 732171 750883 740768 771730 605560 702454 714523 775739 781244 788804 364242 449218 584739 403600 432834 455281 456736 579371 559008 563443 571508 601234 622710 602959 784304 807407 408293 400143 393865 478107 481874 437583 407154 430835 510287 533959 535010 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (0.50%) |
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 364242 390794 392789 393865 398542 400143 400156 403600 407154 407384 408293 415598 425360 430835 432834 437583 449218 450399 450843 450855 455281 456736 460191 460555 464189 477335 478107 481874 482251 505973 510287 518046 521997 527687 530546 532058 532112 532134 533474 533959 534079 535010 539460 547705 551717 559008 561609 563443 566257 571508 579371 584106 584739 585434 589199 601234 602959 605560 607311 608355 622710 639152 646199 653126 653127 660618 660622 661944 680830 691819 692424 695128 702454 702707 709440 712041 714523 717688 718459 726882 729884 732171 732989 734759 735518 740768 741268 744173 744183 750883 750890 750922 756803 760714 762218 764142 769487 771730 775738 775739 781244 784304 788804 791120 798594 807378 807407 810760 812885 814414 816766 816773 818212 819175 820323 823619 823637 824767 824832 827868 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom step mom"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom step mom"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom step mom"
]
|
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.