Query Metrics
7
Database Queries
7
Different statements
177.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.99 ms (87.00%) |
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 403229 408586 422483 423333 423455 432789 434370 453730 455597 459407 459477 460076 484312 496124 497174 510332 527100 536442 546223 547806 555098 555742 556714 562732 568735 574329 577663 582097 585380 590078 591913 591925 593151 594536 595182 599981 604669 608092 620653 623947 624196 626401 630112 648497 663224 674916 682882 685401 692718 692817 694953 697249 697720 698228 700031 702488 707673 710476 712517 715370 719461 726143 730336 738834 739624 740849 741785 741828 742560 742751 742756 742769 743650 754110 756074 756661 758097 759926 761012 761668 761712 762327 763194 764806 764922 767630 769528 770601 772404 772927 773271 776479 778298 778492 779278 780932 782539 782568 783385 785462 786421 786496 787511 791106 792388 794161 794717 794900 795023 797210 799393 800730 800731 800747 801264 803726 809310 811138 813089 819884 ] |
||||||||||||||||||||||||||||||
|
13.13 ms (7.42%) |
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 497174 591913 819884 648497 799393 778298 772404 726143 756661 630112 794717 794900 797210 767630 741828 742560 786421 786496 674916 707673 710476 778492 741785 697249 663224 769528 739624 772927 742769 740849 742756 608092 702488 785462 811138 800730 782539 800731 803726 730336 756074 459477 685401 527100 496124 682882 620653 700031 712517 453730 546223 623947 423333 434370 715370 698228 813089 779278 770601 795023 764922 742751 763194 773271 738834 761012 761712 783385 809310 408586 555098 776479 782568 792388 794161 801264 787511 762327 759926 758097 423455 484312 577663 692817 694953 692718 599981 624196 595182 536442 590078 422483 574329 547806 556714 719461 582097 626401 593151 754110 743650 761668 459407 403229 455597 460076 562732 697720 585380 780932 800747 764806 791106 510332 432789 594536 555742 568735 591925 604669 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.53%) |
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 403229 408586 422483 423333 423455 432789 434370 453730 455597 459407 459477 460076 484312 496124 497174 510332 527100 536442 546223 547806 555098 555742 556714 562732 568735 574329 577663 582097 585380 590078 591913 591925 593151 594536 595182 599981 604669 608092 620653 623947 624196 626401 630112 648497 663224 674916 682882 685401 692718 692817 694953 697249 697720 698228 700031 702488 707673 710476 712517 715370 719461 726143 730336 738834 739624 740849 741785 741828 742560 742751 742756 742769 743650 754110 756074 756661 758097 759926 761012 761668 761712 762327 763194 764806 764922 767630 769528 770601 772404 772927 773271 776479 778298 778492 779278 780932 782539 782568 783385 785462 786421 786496 787511 791106 792388 794161 794717 794900 795023 797210 799393 800730 800731 800747 801264 803726 809310 811138 813089 819884 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur deep cum"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск deep cum"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск deep cum"
]
|
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.