Query Metrics
7
Database Queries
7
Different statements
153.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.90 ms (85.25%) |
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 70131 382540 385608 417521 418707 443949 445766 451590 459902 460531 464553 470345 470360 472305 477156 477594 478211 481641 482985 484075 486274 489779 491010 504613 506551 506978 512877 514480 523072 524618 525062 525638 525932 525959 526404 526427 527596 528911 537306 539339 540708 549992 551221 552823 559324 560493 561629 562618 569632 574300 574648 590606 592093 592971 603697 603959 606220 608683 611413 611954 616457 618005 618965 620786 622661 626143 630686 631185 634276 644847 645446 649870 650226 673097 673996 677524 692824 695665 696049 696062 696685 698214 698709 698819 699645 714040 715047 715675 716339 717767 719907 719933 721271 721918 725441 728276 729629 730441 731031 731147 732584 733021 734084 734224 743615 745074 749860 757026 780734 785103 792779 796248 804877 805225 813979 819099 828029 828075 828127 ] |
||||||||||||||||||||||||||||||
|
13.06 ms (8.50%) |
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 721271 804877 805225 725441 698214 525638 592971 418707 451590 477594 514480 524618 592093 729629 539339 482985 717767 715675 504613 699645 734224 734084 417521 506551 620786 819099 828029 828075 792779 382540 70131 525932 445766 472305 491010 525062 537306 527596 512877 562618 569632 645446 574300 634276 622661 626143 796248 478211 460531 525959 618005 526404 822647 828127 719933 477156 551221 560493 650226 692824 696049 714040 673996 695665 696062 603959 606220 590606 611413 780734 731031 749860 733021 732584 745074 728276 731147 611954 716339 559324 489779 677524 540708 696685 698709 721918 616457 757026 719907 785103 715047 464553 630686 618965 470360 574648 443949 644847 528911 631185 603697 481641 813979 470345 506978 523072 486274 649870 698819 608683 743615 561629 673097 549992 385608 730441 552823 484075 459902 526427 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.54%) |
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 70131 382540 385608 417521 418707 443949 445766 451590 459902 460531 464553 470345 470360 472305 477156 477594 478211 481641 482985 484075 486274 489779 491010 504613 506551 506978 512877 514480 523072 524618 525062 525638 525932 525959 526404 526427 527596 528911 537306 539339 540708 549992 551221 552823 559324 560493 561629 562618 569632 574300 574648 590606 592093 592971 603697 603959 606220 608683 611413 611954 616457 618005 618965 620786 622661 626143 630686 631185 634276 644847 645446 649870 650226 673097 673996 677524 692824 695665 696049 696062 696685 698214 698709 698819 699645 714040 715047 715675 716339 717767 719907 719933 721271 721918 725441 728276 729629 730441 731031 731147 732584 733021 734084 734224 743615 745074 749860 757026 780734 785103 792779 796248 804877 805225 813979 819099 828029 828075 828127 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public touch dick"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц трога член"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.