Query Metrics
7
Database Queries
7
Different statements
357.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.08 ms (59.04%) |
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 20617 50537 144252 153922 359075 382272 385750 387186 387245 395670 401582 401886 413560 413792 414220 416402 418803 419095 419661 460614 469753 473055 474347 489102 499177 536359 539808 545524 551619 572796 582648 582654 587058 599199 600795 604619 613945 621875 621995 624207 625300 629072 633075 633289 650037 664512 665966 668330 672534 672547 674524 679370 684847 689482 692756 695113 695552 697618 712817 717667 719262 723713 724399 725129 725353 725381 725487 733098 734353 734778 736446 737533 739762 739959 741212 742274 743914 744556 749015 749577 753333 753699 756202 756223 756538 759595 759711 760549 765363 765411 771491 772359 773745 776011 777790 780680 783290 783348 789477 790815 792430 792788 796576 797254 802043 805040 805108 809956 810974 816083 816132 817645 817766 817796 817934 818936 824394 824636 827958 ] |
||||||||||||||||||||||||||||||
|
122.32 ms (34.21%) |
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 20617 50537 144252 153922 359075 382272 385750 387186 387245 395670 401582 401886 413560 413792 414220 416402 418803 419095 419661 460614 469753 473055 474347 489102 499177 536359 539808 545524 551619 572796 582648 582654 587058 599199 600795 604619 613945 621875 621995 624207 625300 629072 633075 633289 650037 664512 665966 668330 672534 672547 674524 679370 684847 689482 692756 695113 695552 697618 712817 717667 719262 723713 724399 725129 725353 725381 725487 733098 734353 734778 736446 737533 739762 739959 741212 742274 743914 744556 749015 749577 753333 753699 756202 756223 756538 759595 759711 760549 765363 765411 771491 772359 773745 776011 777790 780680 783290 783348 789477 790815 792430 792788 796576 797254 802043 805040 805108 809956 810974 816083 816132 817645 817766 817796 817934 818936 824394 824636 827958 ] |
||||||||||||||||||||||||||||||
|
16.61 ms (4.65%) |
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 743914 744556 756538 621995 629072 633075 697618 719262 792788 797254 153922 359075 382272 413792 395670 536359 590749 599199 50537 401886 416402 413560 419661 824394 824636 816083 816132 817766 817796 827958 489102 539808 582648 582654 674524 679370 692756 717667 665966 668330 689482 695113 695552 650037 664512 672534 672547 684847 712817 572796 625300 633289 600795 613945 777790 783290 783348 802043 780680 790815 796576 805040 805108 809956 723713 725353 734353 737533 749015 753699 771491 792430 725381 725487 734778 749577 756202 759595 733098 736446 741212 756223 765363 772359 773745 724399 739762 753333 759711 765411 725129 739959 742274 760549 621875 776011 810974 387186 20617 385750 387245 401582 818936 460614 545524 551619 604619 587058 789477 418803 469753 474347 414220 419095 499177 624207 144252 817645 817934 473055 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy sexy"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy sexy"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy sexy"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.