Query Metrics
7
Database Queries
7
Different statements
147.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.19 ms (81.64%) |
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 381819 388401 389980 392404 395871 396002 399922 400382 401336 401582 401944 404633 408439 410776 414956 427970 430920 437668 447445 448587 449118 454835 458017 461423 461644 462687 463945 464598 465808 468574 470137 482073 482084 489168 493218 494695 495670 501647 501831 505977 506299 510687 511063 513307 517663 527856 529034 541782 557086 561694 565158 565959 566022 570705 575430 575464 575804 576314 579976 582708 589720 590413 591841 592071 592358 593878 595412 596995 597048 597472 598471 598587 598695 604255 610421 623195 629092 634517 643462 644246 649121 650118 650187 652605 652882 655058 655090 662200 670989 673711 692422 693111 698101 699587 715710 717499 719214 720506 722563 725409 731485 741539 743232 746157 746979 747147 753262 753307 753333 753395 753908 756106 757915 775939 778644 778647 779737 813903 822717 ] |
||||||||||||||||||||||||||||||
|
17.31 ms (11.76%) |
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 505977 510687 565158 566022 575464 575804 557086 561694 565959 570705 582708 576314 650187 575430 592071 592358 593878 595412 597048 634517 590413 597472 598695 598471 604255 725409 741539 396002 408439 462687 449118 465808 470137 395871 427970 437668 458017 461423 461644 482084 392404 399922 401944 447445 454835 463945 468574 448587 482073 513307 493218 501647 501831 527856 529034 489168 495670 506299 511063 517663 464598 389980 494695 404633 589720 610421 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 579976 381819 813903 541782 655090 673711 717499 655058 692422 623195 643462 778644 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.82%) |
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 381819 388401 389980 392404 395871 396002 399922 400382 401336 401582 401944 404633 408439 410776 414956 427970 430920 437668 447445 448587 449118 454835 458017 461423 461644 462687 463945 464598 465808 468574 470137 482073 482084 489168 493218 494695 495670 501647 501831 505977 506299 510687 511063 513307 517663 527856 529034 541782 557086 561694 565158 565959 566022 570705 575430 575464 575804 576314 579976 582708 589720 590413 591841 592071 592358 593878 595412 596995 597048 597472 598471 598587 598695 604255 610421 623195 629092 634517 643462 644246 649121 650118 650187 652605 652882 655058 655090 662200 670989 673711 692422 693111 698101 699587 715710 717499 719214 720506 722563 725409 731485 741539 743232 746157 746979 747147 753262 753307 753333 753395 753908 756106 757915 775939 778644 778647 779737 813903 822717 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen красивая"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.05%) |
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.