Query Metrics
7
Database Queries
7
Different statements
170.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.60 ms (86.95%) |
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 65834 145666 263331 397689 398003 403948 407165 418334 420829 434886 449181 456473 494615 497629 506474 539388 577677 578301 619385 657781 665626 680593 694637 699519 702639 704593 704957 708399 717919 720576 722237 726116 726918 728892 737843 741160 742284 744162 747488 748279 748867 748876 748990 750592 750656 753080 753223 760635 761526 763966 766042 767350 767462 767469 768105 768226 771915 772602 772603 773361 775600 775641 775647 775650 775656 780323 780328 780379 782774 784357 785508 786882 786909 787649 787963 792341 793830 794000 794178 794196 794520 794676 795012 796589 800044 800116 801580 803150 804400 804762 810397 812439 812466 813366 817565 817584 817909 818521 819105 819713 819814 820000 820011 820161 820310 820688 824208 824424 824642 824750 824752 824811 825028 826349 826357 826466 826949 827375 827544 827711 ] |
||||||||||||||||||||||||||||||
|
12.14 ms (7.10%) |
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 775647 780323 796589 824752 824424 824750 742284 771915 761526 657781 794196 397689 407165 820011 827711 824642 497629 702639 708399 722237 680593 694637 786909 800044 775656 800116 744162 747488 748876 748990 784357 792341 810397 728892 753223 767462 768226 767469 768105 741160 763966 773361 794000 803150 804400 418334 398003 403948 434886 145666 818521 827375 820161 665626 794520 812439 780379 726116 737843 812466 494615 780328 793830 786882 760635 817909 819814 826949 819105 826466 577677 704593 704957 717919 804762 787649 787963 750656 772603 785508 748867 420829 824208 449181 699519 720576 794178 794676 795012 801580 775600 775650 813366 748279 750592 766042 772602 726918 753080 767350 775641 782774 506474 578301 619385 65834 263331 817565 820688 824811 826357 819713 827544 817584 820000 820310 825028 826349 456473 539388 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (1.84%) |
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 65834 145666 263331 397689 398003 403948 407165 418334 420829 434886 449181 456473 494615 497629 506474 539388 577677 578301 619385 657781 665626 680593 694637 699519 702639 704593 704957 708399 717919 720576 722237 726116 726918 728892 737843 741160 742284 744162 747488 748279 748867 748876 748990 750592 750656 753080 753223 760635 761526 763966 766042 767350 767462 767469 768105 768226 771915 772602 772603 773361 775600 775641 775647 775650 775656 780323 780328 780379 782774 784357 785508 786882 786909 787649 787963 792341 793830 794000 794178 794196 794520 794676 795012 796589 800044 800116 801580 803150 804400 804762 810397 812439 812466 813366 817565 817584 817909 818521 819105 819713 819814 820000 820011 820161 820310 820688 824208 824424 824642 824750 824752 824811 825028 826349 826357 826466 826949 827375 827544 827711 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"orgasm pussy"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"orgasm pussy"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"orgasm pussy"
]
|
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.