Query Metrics
7
Database Queries
7
Different statements
178.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.48 ms (85.93%) |
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 31305 390487 423084 425928 445003 454040 454290 460576 470035 472357 477810 481927 503676 514227 534472 535818 541199 545004 554953 561908 562564 579478 582745 591276 600362 602222 602366 606389 607298 614582 617065 617777 618020 620938 624752 628455 628563 629788 630316 635129 640475 642996 644178 648744 666026 668698 671558 672811 672876 677914 679689 680573 686148 689840 689872 692165 693806 697100 698156 700906 704074 712143 712228 714004 715171 719986 722323 725183 730697 731019 733428 734108 736565 737106 740858 744380 745480 745985 746098 747957 751843 754574 758353 764074 764268 765900 767518 778387 778448 778808 780165 781945 783290 783417 784379 787355 788612 789497 794197 795821 798827 803150 806819 809109 809358 810461 810874 811913 812397 812401 813604 814305 814337 814363 816700 824531 824735 826720 826957 ] |
||||||||||||||||||||||||||||||
|
14.54 ms (8.14%) |
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 814337 826957 814305 477810 472357 545004 715171 677914 686148 689840 602366 795821 809358 725183 783417 751843 764074 767518 697100 803150 31305 826720 541199 689872 628563 600362 629788 811913 812401 758353 810874 765900 635129 778387 789497 562564 604910 824531 672811 554953 737106 813604 814363 514227 535818 666026 714004 698156 700906 671558 602222 591276 618020 794197 734108 733428 764268 617065 704074 745480 425928 534472 668698 719986 606389 624752 644178 614582 620938 642996 780165 783290 787355 809109 740858 747957 730697 617777 788612 806819 503676 579478 582745 648744 712228 672876 630316 745985 640475 784379 722323 628455 390487 454290 607298 824735 454040 460576 470035 481927 680573 693806 778448 798827 810461 812397 731019 744380 736565 754574 746098 778808 781945 423084 445003 816700 561908 712143 679689 692165 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.62%) |
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 31305 390487 423084 425928 445003 454040 454290 460576 470035 472357 477810 481927 503676 514227 534472 535818 541199 545004 554953 561908 562564 579478 582745 591276 600362 602222 602366 606389 607298 614582 617065 617777 618020 620938 624752 628455 628563 629788 630316 635129 640475 642996 644178 648744 666026 668698 671558 672811 672876 677914 679689 680573 686148 689840 689872 692165 693806 697100 698156 700906 704074 712143 712228 714004 715171 719986 722323 725183 730697 731019 733428 734108 736565 737106 740858 744380 745480 745985 746098 747957 751843 754574 758353 764074 764268 765900 767518 778387 778448 778808 780165 781945 783290 783417 784379 787355 788612 789497 794197 795821 798827 803150 806819 809109 809358 810461 810874 811913 812397 812401 813604 814305 814337 814363 816700 824531 824735 826720 826957 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big masturbate"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие masturbate"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие masturbate"
]
|
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.