Query Metrics
7
Database Queries
7
Different statements
215.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.67 ms (86.47%) |
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 14216 14508 28690 58554 383733 386613 388519 392238 392452 393267 395159 395440 395480 395557 396099 396365 396572 397647 398434 399306 399310 399345 399346 399412 399674 399754 407282 408331 417824 420230 420614 428518 430742 437562 465130 468704 468793 493806 495268 496372 513126 529600 533374 533375 534027 545773 545785 545803 550207 565038 566054 575872 595246 599957 600995 601600 604447 604474 605527 605677 611009 611193 621424 623196 623426 632578 632618 632635 632707 636293 637021 644005 645276 648809 648815 651209 652788 653178 661633 665932 666871 667741 673614 674688 675009 682936 688082 696204 696450 698044 702557 710667 716892 719788 719865 720123 720386 732412 732556 737571 738490 741434 743137 743165 744679 747460 747481 756001 758829 768785 776265 798403 798687 808079 817793 817842 820698 821200 823564 828648 ] |
||||||||||||||||||||||||||||||
|
20.14 ms (9.33%) |
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 395557 696450 399674 545803 666871 398434 743137 820698 529600 565038 533374 637021 392452 388519 399412 417824 768785 392238 575872 673614 632578 732556 623426 399310 28690 566054 720386 420230 747481 386613 395159 747460 513126 437562 682936 632707 821200 741434 599957 399346 645276 393267 661633 611009 611193 653178 399306 665932 756001 604474 420614 817793 823564 828648 688082 719865 595246 758829 397647 696204 648809 716892 545785 651209 399754 493806 605527 776265 732412 738490 430742 550207 383733 719788 495268 408331 702557 396365 533375 601600 600995 632618 14216 395440 743165 395480 545773 710667 652788 667741 605677 428518 648815 698044 675009 817842 621424 798403 798687 808079 58554 399345 468704 674688 604447 737571 396572 534027 623196 14508 396099 720123 465130 407282 636293 632635 644005 496372 744679 468793 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.20%) |
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 14216 14508 28690 58554 383733 386613 388519 392238 392452 393267 395159 395440 395480 395557 396099 396365 396572 397647 398434 399306 399310 399345 399346 399412 399674 399754 407282 408331 417824 420230 420614 428518 430742 437562 465130 468704 468793 493806 495268 496372 513126 529600 533374 533375 534027 545773 545785 545803 550207 565038 566054 575872 595246 599957 600995 601600 604447 604474 605527 605677 611009 611193 621424 623196 623426 632578 632618 632635 632707 636293 637021 644005 645276 648809 648815 651209 652788 653178 661633 665932 666871 667741 673614 674688 675009 682936 688082 696204 696450 698044 702557 710667 716892 719788 719865 720123 720386 732412 732556 737571 738490 741434 743137 743165 744679 747460 747481 756001 758829 768785 776265 798403 798687 808079 817793 817842 820698 821200 823564 828648 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc fuck girl"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc секс девушк"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc секс девушк"
]
|
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.