Query Metrics
7
Database Queries
7
Different statements
163.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.93 ms (84.85%) |
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 398274 400881 404112 418689 437767 441453 441517 441583 449297 449310 456077 462578 467057 468408 478101 508197 524954 527956 529605 531839 531887 532369 534555 536439 537474 541509 554934 555820 575954 575993 578761 583276 603391 615295 635752 639357 641318 663224 695906 697249 708389 717162 722377 724059 724109 725747 727859 734414 735517 737458 739389 739624 740876 741828 742560 743490 743615 745795 745959 752712 752732 754070 757538 761199 761594 761758 762041 763032 763460 764693 765756 766288 767052 767630 768297 769161 769423 769896 772927 773737 776968 777315 778082 778659 778734 779563 783271 783744 785004 786051 786421 786496 788476 789436 790399 790502 792175 792335 793765 794370 794717 794900 797210 801263 801802 802295 804526 804565 805053 807304 809751 810579 810602 813467 813953 814521 816167 817708 819947 825758 ] |
||||||||||||||||||||||||||||||
|
14.71 ms (8.98%) |
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 615295 641318 462578 404112 441453 813953 814521 816167 819947 467057 532369 534555 537474 508197 468408 541509 575954 555820 790399 793765 801802 804526 777315 779563 783744 788476 790502 794370 802295 734414 752732 794717 794900 797210 807304 809751 810579 727859 767630 741828 742560 745795 762041 763460 767052 725747 743615 765756 766288 769423 769896 778659 778734 786421 786496 789436 792335 801263 804565 805053 437767 398274 400881 536439 697249 663224 695906 708389 639357 813467 441517 817708 418689 441583 825758 456077 449297 449310 478101 527956 524954 531887 529605 531839 554934 575993 578761 583276 717162 722377 635752 603391 776968 778082 783271 792175 785004 724109 735517 737458 739624 743490 745959 754070 761199 761594 761758 763032 786051 810602 740876 752712 757538 764693 768297 769161 772927 773737 724059 739389 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.55%) |
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 398274 400881 404112 418689 437767 441453 441517 441583 449297 449310 456077 462578 467057 468408 478101 508197 524954 527956 529605 531839 531887 532369 534555 536439 537474 541509 554934 555820 575954 575993 578761 583276 603391 615295 635752 639357 641318 663224 695906 697249 708389 717162 722377 724059 724109 725747 727859 734414 735517 737458 739389 739624 740876 741828 742560 743490 743615 745795 745959 752712 752732 754070 757538 761199 761594 761758 762041 763032 763460 764693 765756 766288 767052 767630 768297 769161 769423 769896 772927 773737 776968 777315 778082 778659 778734 779563 783271 783744 785004 786051 786421 786496 788476 789436 790399 790502 792175 792335 793765 794370 794717 794900 797210 801263 801802 802295 804526 804565 805053 807304 809751 810579 810602 813467 813953 814521 816167 817708 819947 825758 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur deep"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск deep"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск deep"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.11%) |
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.