Query Metrics
7
Database Queries
7
Different statements
197.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.84 ms (87.36%) |
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 391491 391669 392066 392599 397894 400998 401807 423772 424265 424276 433281 437258 439727 444144 446975 452215 454555 454868 455331 459024 460143 460748 462117 462708 466274 472804 474797 475871 477711 477794 477950 477996 479124 483654 486846 486933 488887 505747 508367 508784 512485 513501 516923 523528 525310 535332 542370 542925 543332 543708 545726 547743 547778 558117 560866 562192 562743 565898 568698 577598 590441 598483 598541 599535 602806 603767 612977 659986 667774 669857 677862 695707 697865 702312 709540 713384 716738 716915 736130 738525 742303 745462 746267 751536 751803 752134 753507 755132 758171 758804 760875 760881 765834 765837 766385 767459 768553 771375 777217 777739 777759 777861 778383 778748 778749 779902 780088 789188 792522 793997 795521 796214 796583 800934 803562 804836 805145 811919 814028 820107 ] |
||||||||||||||||||||||||||||||
|
15.88 ms (8.03%) |
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 454868 477950 466274 392599 793997 820107 814028 525310 547743 697865 716738 669857 716915 667774 562743 778383 789188 805145 777217 777759 778749 780088 792522 803562 804836 811919 736130 755132 766385 795521 796214 760881 765837 771375 746267 752134 758804 760875 745462 751803 768553 751536 753507 758171 602806 777739 777861 778748 779902 800934 459024 565898 391491 433281 460748 391669 424265 454555 462708 523528 513501 401807 543708 659986 560866 577598 562192 713384 677862 695707 702312 590441 598541 612977 599535 603767 765834 709540 516923 598483 452215 477711 488887 460143 543332 547778 558117 568698 423772 462117 477794 397894 439727 446975 479124 424276 437258 477996 474797 444144 472804 475871 505747 508367 512485 486846 508784 483654 400998 535332 542370 796583 767459 742303 738525 455331 392066 486933 545726 542925 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.34%) |
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 391491 391669 392066 392599 397894 400998 401807 423772 424265 424276 433281 437258 439727 444144 446975 452215 454555 454868 455331 459024 460143 460748 462117 462708 466274 472804 474797 475871 477711 477794 477950 477996 479124 483654 486846 486933 488887 505747 508367 508784 512485 513501 516923 523528 525310 535332 542370 542925 543332 543708 545726 547743 547778 558117 560866 562192 562743 565898 568698 577598 590441 598483 598541 599535 602806 603767 612977 659986 667774 669857 677862 695707 697865 702312 709540 713384 716738 716915 736130 738525 742303 745462 746267 751536 751803 752134 753507 755132 758171 758804 760875 760881 765834 765837 766385 767459 768553 771375 777217 777739 777759 777861 778383 778748 778749 779902 780088 789188 792522 793997 795521 796214 796583 800934 803562 804836 805145 811919 814028 820107 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian mom amateur"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск mom любительск"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.68%) |
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.