Query Metrics
7
Database Queries
7
Different statements
202.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.64 ms (86.18%) |
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 39356 81775 233333 381819 386662 388401 389980 392404 395871 396002 398774 399837 399922 400382 401336 401582 401917 401944 404188 404633 404672 408439 410776 414956 420607 425846 427970 430920 431694 437668 447445 448587 449118 454835 458017 461423 461448 461644 462687 463945 464598 465808 468574 470045 470137 482073 482084 489168 493218 494695 495670 501647 501831 506299 513307 517663 527856 529034 529036 541782 561893 589720 591841 596860 596995 598587 613129 623195 629092 643462 644246 649121 650118 652605 652882 655058 655090 662200 670989 673711 693111 697322 698013 698101 699587 715710 717499 719214 720506 722563 725409 728252 729674 731485 736580 741539 742225 743232 746157 746979 747147 753262 753307 753333 753395 753908 756106 757915 763533 775939 778374 778644 778647 779737 788906 795119 804871 811626 813903 822717 ] |
||||||||||||||||||||||||||||||
|
16.79 ms (8.29%) |
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 725409 741539 396002 408439 462687 449118 465808 470137 395871 427970 437668 458017 461423 461644 470045 482084 392404 399922 401944 431694 447445 454835 463945 468574 448587 482073 513307 493218 501647 501831 527856 529034 489168 495670 506299 517663 464598 389980 494695 404633 589720 598587 778647 401582 39356 822717 650118 652605 652882 715710 722563 649121 670989 693111 719214 720506 662200 698101 699587 591841 629092 644246 596995 779737 775939 746157 753307 753908 746979 747147 753262 753333 753395 757915 731485 743232 756106 400382 401336 410776 388401 414956 430920 381819 813903 541782 655090 673711 717499 655058 623195 643462 778644 729674 736580 742225 763533 788906 728252 795119 386662 425846 461448 613129 399837 697322 698013 596860 811626 804871 778374 404672 81775 401917 233333 420607 398774 404188 529036 561893 ] |
||||||||||||||||||||||||||||||
|
3.59 ms (1.77%) |
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 39356 81775 233333 381819 386662 388401 389980 392404 395871 396002 398774 399837 399922 400382 401336 401582 401917 401944 404188 404633 404672 408439 410776 414956 420607 425846 427970 430920 431694 437668 447445 448587 449118 454835 458017 461423 461448 461644 462687 463945 464598 465808 468574 470045 470137 482073 482084 489168 493218 494695 495670 501647 501831 506299 513307 517663 527856 529034 529036 541782 561893 589720 591841 596860 596995 598587 613129 623195 629092 643462 644246 649121 650118 652605 652882 655058 655090 662200 670989 673711 693111 697322 698013 698101 699587 715710 717499 719214 720506 722563 725409 728252 729674 731485 736580 741539 742225 743232 746157 746979 747147 753262 753307 753333 753395 753908 756106 757915 763533 775939 778374 778644 778647 779737 788906 795119 804871 811626 813903 822717 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful teen"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая teen"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая teen"
]
|
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.