Query Metrics
7
Database Queries
7
Different statements
183.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.01 ms (88.38%) |
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 305548 390508 395450 398828 412043 422735 432115 465608 508271 514416 525526 525545 531298 532708 533498 533779 534696 535074 535083 536980 538451 538749 540479 540833 542988 543149 544649 546296 548116 550309 556086 556091 556406 557269 562436 571357 581275 586320 587723 596210 596484 596574 601740 604585 606240 606926 609361 615291 616578 622679 626264 629419 630465 632476 633615 633856 637869 639078 645213 645406 652691 653079 653391 653747 653823 654973 665334 690737 690885 694031 696407 696983 697607 706454 708494 709427 711558 716017 716669 717080 717156 719827 720010 723993 731300 732646 732651 732684 732912 734996 737305 738079 739568 740673 740779 741174 742551 750275 751829 752472 764309 779232 790761 803477 804026 805729 810424 810426 816610 819721 827830 827849 827850 827854 827855 827873 827895 827896 ] |
||||||||||||||||||||||||||||||
|
11.20 ms (6.11%) |
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 626264 633615 752472 550309 711558 653747 716017 740779 762326 740673 804026 810424 535083 546296 556091 645213 696407 654973 596574 639078 586320 616578 615291 827854 398828 827849 810426 779232 741174 751829 742551 536980 708494 645406 697607 694031 632476 732651 827873 827896 606240 533779 596210 305548 816610 819721 581275 731300 827855 827850 827830 587723 395450 412043 422735 544649 630465 609361 562436 652691 653079 665334 738079 601740 432115 525526 571357 717156 739568 732912 734996 732646 803477 764309 556406 534696 696983 596484 604585 690737 706454 390508 543149 717080 716669 723993 737305 762399 732684 750275 622679 720010 542988 719827 790761 514416 508271 525545 690885 606926 805729 540479 827895 531298 535074 538451 557269 653823 653391 637869 633856 629419 540833 532708 556086 709427 465608 533498 538749 548116 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.46%) |
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 305548 390508 395450 398828 412043 422735 432115 465608 508271 514416 525526 525545 531298 532708 533498 533779 534696 535074 535083 536980 538451 538749 540479 540833 542988 543149 544649 546296 548116 550309 556086 556091 556406 557269 562436 571357 581275 586320 587723 596210 596484 596574 601740 604585 606240 606926 609361 615291 616578 622679 626264 629419 630465 632476 633615 633856 637869 639078 645213 645406 652691 653079 653391 653747 653823 654973 665334 690737 690885 694031 696407 696983 697607 706454 708494 709427 711558 716017 716669 717080 717156 719827 720010 723993 731300 732646 732651 732684 732912 734996 737305 738079 739568 740673 740779 741174 742551 750275 751829 752472 764309 779232 790761 803477 804026 805729 810424 810426 816610 819721 827830 827849 827850 827854 827855 827873 827895 827896 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc homemade sex"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc домашн любительск секс"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc домашн любительск секс"
]
|
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.