Query Metrics
7
Database Queries
7
Different statements
586.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
412.60 ms (70.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
148.12 ms (25.28%) |
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 7322 7740 395978 402065 404055 418346 420063 426266 455109 469802 472865 475343 490134 490536 490764 503764 510703 514483 517996 525326 529067 529077 532899 544751 547702 552203 552875 558421 562175 564322 565344 566037 567642 606277 606515 607253 608818 618549 618862 619476 619774 620785 625379 626453 627759 632931 637018 644780 649276 659420 664650 668646 674550 678981 680143 686589 687784 693322 697896 698718 699216 701200 703395 704025 714126 714845 717656 722583 726464 732412 735772 737240 739436 742806 743760 744840 749659 750392 753814 755403 760461 761404 763592 764274 764768 765411 765704 767861 768130 771038 775489 777566 777599 778185 780208 783159 788175 792183 793663 795129 796628 796699 797087 798969 798996 799568 800410 801925 802805 804819 808153 809121 810709 811153 811759 813129 814019 816804 822166 826800 ] |
||||||||||||||||||||||||||||||
|
16.85 ms (2.88%) |
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 742806 749659 764274 768130 626453 775489 797087 798996 799568 808153 810709 395978 469802 418346 475343 490134 822166 816804 472865 503764 532899 544751 567642 703395 649276 664650 686589 714126 674550 687784 699216 714845 552875 564322 607253 618549 800410 811153 777566 778185 804819 760461 798969 811759 764768 750392 765704 737240 755403 761404 765411 767861 771038 763592 606515 644780 697896 698718 701200 777599 780208 783159 788175 795129 801925 813129 404055 7740 717656 814019 826800 490536 514483 517996 547702 558421 566037 552203 565344 659420 678981 680143 704025 693322 722583 562175 606277 618862 625379 619774 627759 637018 619476 796699 739436 744840 792183 793663 802805 809121 726464 753814 732412 735772 743760 608818 620785 632931 796628 7322 402065 455109 426266 490764 510703 529067 529077 420063 668646 525326 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (0.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 7322 7740 395978 402065 404055 418346 420063 426266 455109 469802 472865 475343 490134 490536 490764 503764 510703 514483 517996 525326 529067 529077 532899 544751 547702 552203 552875 558421 562175 564322 565344 566037 567642 606277 606515 607253 608818 618549 618862 619476 619774 620785 625379 626453 627759 632931 637018 644780 649276 659420 664650 668646 674550 678981 680143 686589 687784 693322 697896 698718 699216 701200 703395 704025 714126 714845 717656 722583 726464 732412 735772 737240 739436 742806 743760 744840 749659 750392 753814 755403 760461 761404 763592 764274 764768 765411 765704 767861 768130 771038 775489 777566 777599 778185 780208 783159 788175 792183 793663 795129 796628 796699 797087 798969 798996 799568 800410 801925 802805 804819 808153 809121 810709 811153 811759 813129 814019 816804 822166 826800 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк first"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl first"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк first"
]
|
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.