Query Metrics
7
Database Queries
7
Different statements
141.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.37 ms (84.59%) |
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 401787 486811 494903 496805 511321 528146 533714 541034 542328 543079 543542 543762 545742 545946 546477 547133 555669 556564 560713 561179 562392 564357 564691 568016 571959 574223 579440 583674 584060 584137 594359 605938 618245 638101 645511 648316 651751 655201 655523 659165 661679 662786 667925 670709 675164 684441 687051 689060 690923 693727 700918 702008 703275 703732 703740 704480 705223 708085 712610 714366 731271 732564 732959 733580 733655 733662 737665 740725 743033 744452 748085 757895 765925 766190 766399 777183 778368 778371 778664 785262 787425 787784 793007 793856 794473 794618 795496 795609 795671 795844 795876 796061 797137 803785 810387 810594 811717 812133 813682 813736 816672 816750 818708 819456 824522 825513 825786 825834 825887 825922 827133 827363 827381 828786 828804 ] |
||||||||||||||||||||||||||||||
|
11.40 ms (8.08%) |
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 568016 690923 594359 401787 816750 825513 825834 827133 827381 813682 819456 712610 561179 638101 618245 777183 778368 785262 793856 794618 733580 733655 795844 748085 757895 765925 766399 766674 737665 766190 732564 740725 744452 731271 733662 743033 787784 794473 795496 811717 816672 825887 818708 825786 826047 825922 826029 828804 828586 793007 795609 795671 795876 778371 810594 812133 797137 803785 810387 732959 778664 787425 828786 605938 796061 562392 687051 661679 528146 827363 824522 813736 486811 533714 494903 511321 496805 543079 543542 545946 546477 555669 556564 560713 571959 574223 579440 542328 543762 547133 564691 583674 584137 541034 545742 564357 584060 648316 651751 655201 662786 667925 670709 675164 684441 689060 693727 700918 702008 703275 703732 703740 704480 705223 708085 714366 645511 655523 658129 659165 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (2.03%) |
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 401787 486811 494903 496805 511321 528146 533714 541034 542328 543079 543542 543762 545742 545946 546477 547133 555669 556564 560713 561179 562392 564357 564691 568016 571959 574223 579440 583674 584060 584137 594359 605938 618245 638101 645511 648316 651751 655201 655523 659165 661679 662786 667925 670709 675164 684441 687051 689060 690923 693727 700918 702008 703275 703732 703740 704480 705223 708085 712610 714366 731271 732564 732959 733580 733655 733662 737665 740725 743033 744452 748085 757895 765925 766190 766399 777183 778368 778371 778664 785262 787425 787784 793007 793856 794473 794618 795496 795609 795671 795844 795876 796061 797137 803785 810387 810594 811717 812133 813682 813736 816672 816750 818708 819456 824522 825513 825786 825834 825887 825922 827133 827363 827381 828786 828804 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur fucked"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск fucked"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск fucked"
]
|
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.