Query Metrics
7
Database Queries
7
Different statements
145.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.80 ms (86.72%) |
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 532184 532859 536199 537179 539773 540768 540877 543895 544133 546065 546067 546070 546429 546708 547153 548989 550779 553362 557053 558733 559653 561043 562021 574051 577278 578826 580009 581155 590531 591424 602582 602979 605032 607822 613724 613814 613913 616453 617225 618200 619601 619876 621634 622557 623131 626187 627581 631050 631577 632820 633651 634980 635012 635705 637639 639454 639918 640212 642131 642451 645116 645390 645527 645756 646387 646414 649078 650787 650977 651821 652693 653390 653683 653962 655046 660259 661614 661631 664390 668564 671198 671251 671697 676557 678465 685041 690230 691640 697510 701030 701416 703727 706011 706787 707711 708005 708651 710108 711067 711228 716431 728683 728875 731504 733731 733747 734059 734606 734741 734795 737252 739770 746854 752489 758019 761315 761683 791266 821796 ] |
||||||||||||||||||||||||||||||
|
9.92 ms (6.84%) |
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 664390 728875 734741 562021 678465 591424 605032 697510 701030 650977 671251 540877 546065 546708 701416 752489 627581 634980 532859 539773 536199 537179 548989 577278 540768 532184 557053 580009 544133 546067 546070 546429 553362 559653 574051 578826 581155 543895 547153 550779 561043 645527 652693 653390 661631 671198 671697 685041 707711 710108 716431 645116 645390 646387 649078 651821 655046 660259 668564 676557 690230 708005 708651 711228 645756 646414 650787 653683 653962 661614 691640 703727 706011 706787 558733 616453 621634 633651 635012 642451 590531 613724 613814 618200 619601 626187 631577 637639 639454 640212 642131 602582 613913 617225 623131 635705 602979 607822 622557 791266 733747 737252 761683 734606 739770 731504 761315 728683 746854 619876 631050 632820 639918 711067 825655 733731 734795 734059 758019 821796 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.63%) |
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 532184 532859 536199 537179 539773 540768 540877 543895 544133 546065 546067 546070 546429 546708 547153 548989 550779 553362 557053 558733 559653 561043 562021 574051 577278 578826 580009 581155 590531 591424 602582 602979 605032 607822 613724 613814 613913 616453 617225 618200 619601 619876 621634 622557 623131 626187 627581 631050 631577 632820 633651 634980 635012 635705 637639 639454 639918 640212 642131 642451 645116 645390 645527 645756 646387 646414 649078 650787 650977 651821 652693 653390 653683 653962 655046 660259 661614 661631 664390 668564 671198 671251 671697 676557 678465 685041 690230 691640 697510 701030 701416 703727 706011 706787 707711 708005 708651 710108 711067 711228 716431 728683 728875 731504 733731 733747 734059 734606 734741 734795 737252 739770 746854 752489 758019 761315 761683 791266 821796 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие cock любительск"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big cock amateur"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие cock любительск"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (1.01%) |
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.