Query Metrics
7
Database Queries
7
Different statements
215.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
190.49 ms (88.56%) |
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 326039 384790 385185 386890 416031 416098 434282 445776 465010 472208 490068 490827 491084 499010 499504 510624 517301 523395 524621 526487 531278 531441 535960 542502 554931 555165 557948 559717 560783 562754 566860 576651 579938 581390 585159 592483 593743 597787 603239 603548 603991 617193 620563 628393 637280 637522 637673 640703 641757 643095 649210 649939 652617 664833 669628 672490 672618 676342 677003 677060 678561 678996 679058 681006 681025 681154 681785 690839 693849 698051 703213 705558 717680 719234 720273 721185 721188 721837 723527 723603 726144 732805 736663 741097 742596 744441 753134 756246 756638 757544 758201 759529 759548 759574 770520 770630 770852 776280 790063 792488 792630 792801 792822 797574 803681 806346 811975 814236 814488 815345 815522 815693 815880 818386 818459 820047 821384 821989 824315 827776 ] |
||||||||||||||||||||||||||||||
|
15.54 ms (7.23%) |
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 741097 744441 818459 815522 566860 679058 681154 721188 681006 759548 821384 815345 652617 669628 721185 620563 803681 732805 753134 698051 579938 416031 603239 790063 792801 797574 814236 542502 603548 792488 385185 681785 641757 736663 585159 523395 434282 557948 416098 597787 593743 499504 535960 677060 472208 592483 499010 560783 562754 531278 576651 603991 465010 531441 524621 490068 815880 554931 581390 643095 776280 811975 517301 820047 637673 792822 758201 759529 742596 721837 386890 814488 723527 723603 821989 672490 719234 677003 678561 693849 703213 720273 640703 617193 806346 770852 757544 770520 705558 792630 445776 510624 384790 326039 815693 818386 824315 827776 491084 678996 664833 676342 672618 690839 559717 637280 628393 637522 726144 756246 756638 759574 770630 681025 490827 526487 555165 649210 649939 717680 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.21%) |
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 326039 384790 385185 386890 416031 416098 434282 445776 465010 472208 490068 490827 491084 499010 499504 510624 517301 523395 524621 526487 531278 531441 535960 542502 554931 555165 557948 559717 560783 562754 566860 576651 579938 581390 585159 592483 593743 597787 603239 603548 603991 617193 620563 628393 637280 637522 637673 640703 641757 643095 649210 649939 652617 664833 669628 672490 672618 676342 677003 677060 678561 678996 679058 681006 681025 681154 681785 690839 693849 698051 703213 705558 717680 719234 720273 721185 721188 721837 723527 723603 726144 732805 736663 741097 742596 744441 753134 756246 756638 757544 758201 759529 759548 759574 770520 770630 770852 776280 790063 792488 792630 792801 792822 797574 803681 806346 811975 814236 814488 815345 815522 815693 815880 818386 818459 820047 821384 821989 824315 827776 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"поцел жмж секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"цело жмж"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.