Query Metrics
7
Database Queries
7
Different statements
156.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.06 ms (85.57%) |
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 458816 474263 526849 542573 544369 547405 549012 552645 552689 571085 576934 576977 579023 580343 585998 586017 588606 590777 605816 607098 608225 608264 608322 611040 618451 619934 620980 628053 629587 634562 638097 643516 643647 645761 646135 647108 650094 650315 651040 655289 656286 656654 657458 661607 669279 671829 675571 675856 680294 681208 685540 693366 701526 701535 707045 710859 713420 715620 717756 719678 728407 742233 757062 761462 761766 763503 764833 764868 764888 766742 767033 767053 769496 769892 769909 771338 773405 773830 775711 775712 777696 781357 782184 783104 786047 788099 791418 792970 793991 795122 796196 798887 800793 802754 803422 807082 807099 812902 812985 812996 817342 818036 820568 820569 820921 821088 821182 821204 821334 821380 821392 821937 822713 822786 822846 823049 826153 826181 827588 ] |
||||||||||||||||||||||||||||||
|
12.92 ms (8.25%) |
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 817342 818036 821088 821392 822786 823049 821182 821204 526849 542573 544369 576934 693366 719678 685540 710859 571085 586017 798887 802754 803422 777696 786047 761766 767033 788099 795122 763503 764888 769909 773405 771338 773830 757062 628053 782184 807099 812902 812985 821334 822713 826181 820568 820569 820921 821937 826153 821380 822846 827588 474263 458816 552645 552689 549012 579023 645761 651040 675856 715620 656654 661607 681208 701526 701535 707045 713420 717756 646135 647108 650094 650315 655289 656286 657458 669279 671829 675571 680294 547405 576977 580343 608322 585998 607098 608264 619934 638097 643516 590777 643647 588606 605816 608225 611040 618451 620980 629587 634562 775711 783104 792970 796196 775712 791418 800793 812996 742233 755642 761462 781357 793991 807082 764833 766742 767053 728407 764868 769496 769892 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.78%) |
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 458816 474263 526849 542573 544369 547405 549012 552645 552689 571085 576934 576977 579023 580343 585998 586017 588606 590777 605816 607098 608225 608264 608322 611040 618451 619934 620980 628053 629587 634562 638097 643516 643647 645761 646135 647108 650094 650315 651040 655289 656286 656654 657458 661607 669279 671829 675571 675856 680294 681208 685540 693366 701526 701535 707045 710859 713420 715620 717756 719678 728407 742233 757062 761462 761766 763503 764833 764868 764888 766742 767033 767053 769496 769892 769909 771338 773405 773830 775711 775712 777696 781357 782184 783104 786047 788099 791418 792970 793991 795122 796196 798887 800793 802754 803422 807082 807099 812902 812985 812996 817342 818036 820568 820569 820921 821088 821182 821204 821334 821380 821392 821937 822713 822786 822846 823049 826153 826181 827588 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov teen anal"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов teen анал"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов teen анал"
]
|
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.