Query Metrics
7
Database Queries
7
Different statements
155.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.43 ms (84.62%) |
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 190891 391581 396765 396980 402346 405116 409121 413505 413531 422170 438029 443641 444386 449180 462490 464187 465498 468747 470680 472346 480904 482778 486606 486736 489772 496220 499731 500088 501539 506429 506533 511543 522439 525663 526720 530070 531611 532850 536483 543400 546920 548409 551539 555643 558795 560373 561615 565035 566222 569013 571069 572537 579089 581600 583529 584953 585722 585808 588304 589329 590860 592391 594852 599770 599779 599786 599811 602700 604927 620746 621524 622063 626759 626829 638087 638588 638590 645316 650266 672403 689300 689682 715002 717721 717823 721272 723692 727018 728871 731438 731439 731443 731447 733789 745040 746456 749633 750336 762443 769658 784024 798714 798716 798884 799009 799012 802313 802695 813306 817425 817432 817456 817465 817473 817479 817610 817664 818777 826640 826882 ] |
||||||||||||||||||||||||||||||
|
13.69 ms (8.82%) |
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 731447 571069 583529 798714 689682 405116 817465 391581 443641 784024 715002 462490 817425 486736 645316 480904 826640 579089 731443 721272 413531 496220 588304 551539 561615 464187 581600 511543 572537 449180 402346 506533 546920 599779 590860 499731 818777 422170 525663 569013 799009 731438 396980 526720 560373 592391 599770 817456 396765 826882 626759 798884 532850 190891 409121 817473 689300 465498 622063 555643 472346 604927 489772 749633 470680 522439 817432 817664 530070 565035 672403 599811 602700 589329 638590 798716 745040 746456 750336 802695 723692 728871 731439 717721 799012 584953 585722 585808 599786 638087 638588 733789 817610 543400 594852 817479 769658 558795 650266 802313 531611 536483 438029 468747 548409 501539 620746 626829 500088 482778 727018 413505 762443 566222 506429 621524 486606 717823 813306 444386 ] |
||||||||||||||||||||||||||||||
|
2.75 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 190891 391581 396765 396980 402346 405116 409121 413505 413531 422170 438029 443641 444386 449180 462490 464187 465498 468747 470680 472346 480904 482778 486606 486736 489772 496220 499731 500088 501539 506429 506533 511543 522439 525663 526720 530070 531611 532850 536483 543400 546920 548409 551539 555643 558795 560373 561615 565035 566222 569013 571069 572537 579089 581600 583529 584953 585722 585808 588304 589329 590860 592391 594852 599770 599779 599786 599811 602700 604927 620746 621524 622063 626759 626829 638087 638588 638590 645316 650266 672403 689300 689682 715002 717721 717823 721272 723692 727018 728871 731438 731439 731443 731447 733789 745040 746456 749633 750336 762443 769658 784024 798714 798716 798884 799009 799012 802313 802695 813306 817425 817432 817456 817465 817473 817479 817610 817664 818777 826640 826882 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf car blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf вмашин минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf вмашин минет оральн секс"
]
|
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.