Query Metrics
7
Database Queries
7
Different statements
177.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.63 ms (87.09%) |
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 229389 382572 398804 409340 413792 419661 428093 454023 454342 454908 491875 505174 510309 515487 528985 529838 531034 542892 543052 552425 553810 553854 565123 568905 570042 570868 572424 573631 586035 598307 602137 605228 614592 619178 622367 625096 629880 631653 632232 634892 635804 636582 640908 644217 650204 666046 668777 670407 672376 675630 680704 688721 690768 693454 704626 705117 705335 706969 708495 709682 709844 716468 716576 718489 718645 730302 733657 737208 738520 741170 744201 745616 748329 749015 753699 755942 760194 764741 765244 765363 768570 768598 768834 769220 772063 773414 773502 773745 774215 777790 778155 778158 780109 781051 783191 783288 784678 790991 793928 798463 805040 806002 806540 807088 808642 810280 812492 816054 817490 818858 819106 819155 819181 823257 824674 825404 827185 827537 828306 ] |
||||||||||||||||||||||||||||||
|
13.04 ms (7.34%) |
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 824674 565123 632232 808642 738520 764741 529838 744201 542892 531034 709844 640908 749015 772063 552425 805040 398804 828306 598307 819106 528985 716468 709682 586035 778155 708495 781051 783288 816054 693454 650204 553810 605228 760194 793928 768598 409340 625096 784678 631653 769220 825404 680704 806002 798463 812492 413792 382572 819181 819155 543052 553854 570868 670407 672376 675630 706969 572424 635804 783191 773414 748329 768834 730302 773502 716576 229389 419661 510309 570042 622367 774215 823257 827537 818858 505174 688721 778158 745616 705117 718489 807088 573631 614592 733657 515487 454023 755942 806540 810280 768570 780109 790991 454342 428093 629880 454908 690768 666046 636582 827185 705335 644217 602137 753699 707498 741170 568905 668777 634892 777790 765244 765363 773745 491875 817490 718645 704626 619178 737208 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.73%) |
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 229389 382572 398804 409340 413792 419661 428093 454023 454342 454908 491875 505174 510309 515487 528985 529838 531034 542892 543052 552425 553810 553854 565123 568905 570042 570868 572424 573631 586035 598307 602137 605228 614592 619178 622367 625096 629880 631653 632232 634892 635804 636582 640908 644217 650204 666046 668777 670407 672376 675630 680704 688721 690768 693454 704626 705117 705335 706969 708495 709682 709844 716468 716576 718489 718645 730302 733657 737208 738520 741170 744201 745616 748329 749015 753699 755942 760194 764741 765244 765363 768570 768598 768834 769220 772063 773414 773502 773745 774215 777790 778155 778158 780109 781051 783191 783288 784678 790991 793928 798463 805040 806002 806540 807088 808642 810280 812492 816054 817490 818858 819106 819155 819181 823257 824674 825404 827185 827537 828306 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sexy girl tits"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy девушк сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy девушк сиськ"
]
|
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.