Query Metrics
7
Database Queries
7
Different statements
179.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.96 ms (87.05%) |
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 561445 562911 569975 571085 578045 582213 590239 591120 595949 597047 599909 603190 603343 605137 605614 606384 606826 607170 611343 617677 618341 624447 634813 641810 643092 643543 649634 659079 661039 666626 668948 671918 672381 678780 682166 683006 687552 687605 689584 689682 694228 696171 709408 710593 713561 714344 714408 717003 717076 718359 718523 721692 721831 722551 722700 723981 726289 727685 745476 775129 776714 776766 777228 777230 778136 779608 780262 780614 781486 784559 785157 785389 785750 785762 786283 786371 786688 787337 789201 789216 789474 789967 791965 793409 794568 797417 797638 797678 797768 798215 799986 800025 800416 801019 801170 801378 801871 801884 801933 802451 803080 803464 803469 804403 805012 805148 805560 805625 805719 806787 807700 808121 809032 809192 810801 811028 811065 811308 811331 812657 ] |
||||||||||||||||||||||||||||||
|
13.33 ms (7.44%) |
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 714408 718359 721692 722551 722700 659079 666626 668948 671918 672381 682166 683006 687552 687605 696171 709408 710593 713561 714344 717076 649634 661039 678780 689584 689682 694228 717003 718523 721831 561445 562911 569975 571085 578045 582213 591120 606384 606826 641810 643092 605614 611343 603190 603343 624447 643543 590239 595949 597047 599909 605137 607170 617677 618341 634813 775129 776714 778136 785157 785389 785750 786283 787337 789201 789967 793409 797417 797678 799986 800416 801019 801170 801378 801933 802451 803469 805012 805560 807700 809192 810801 811028 811065 811308 811331 812657 776766 777228 777230 779608 780262 780614 781486 784559 785762 786371 786688 789216 789474 791965 794568 797638 797768 798215 800025 801871 801884 803080 803464 804403 805148 805625 805719 806787 808121 809032 723981 726289 727685 745476 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.43%) |
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 561445 562911 569975 571085 578045 582213 590239 591120 595949 597047 599909 603190 603343 605137 605614 606384 606826 607170 611343 617677 618341 624447 634813 641810 643092 643543 649634 659079 661039 666626 668948 671918 672381 678780 682166 683006 687552 687605 689584 689682 694228 696171 709408 710593 713561 714344 714408 717003 717076 718359 718523 721692 721831 722551 722700 723981 726289 727685 745476 775129 776714 776766 777228 777230 778136 779608 780262 780614 781486 784559 785157 785389 785750 785762 786283 786371 786688 787337 789201 789216 789474 789967 791965 793409 794568 797417 797638 797678 797768 798215 799986 800025 800416 801019 801170 801378 801871 801884 801933 802451 803080 803464 803469 804403 805012 805148 805560 805625 805719 806787 807700 808121 809032 809192 810801 811028 811065 811308 811331 812657 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tattoo mom"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"татуированные mom"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"татуированные mom"
]
|
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.