Query Metrics
7
Database Queries
7
Different statements
187.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.35 ms (86.16%) |
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 392480 393999 424124 435046 439487 440798 440805 440857 440859 440947 441943 441984 442463 444601 446649 450646 458804 459061 460548 461005 461267 461867 464581 469044 470616 472652 474782 477902 479311 481238 482876 484024 485452 486392 486643 486820 490976 496850 502849 513466 517619 518156 520799 521332 524185 525071 549648 558213 558618 561435 564091 564670 565380 565757 566941 569443 569629 575542 577485 578655 583662 584175 588517 590532 590556 591052 598101 598966 601508 603742 605831 630716 630731 630736 636442 643334 651832 651979 652121 652126 652127 652129 658110 658208 658216 658222 658223 658224 658225 658226 658555 658989 674263 674292 675769 678696 680682 680749 685931 716383 717453 718864 719112 723845 724633 734008 735839 738951 743933 744520 745565 747563 765959 768739 771673 794416 794421 797773 799145 801094 ] |
||||||||||||||||||||||||||||||
|
15.96 ms (8.52%) |
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 651832 797773 685931 717453 658555 794421 392480 768739 440947 799145 458804 583662 735839 461267 674292 601508 747563 561435 680749 393999 484024 549648 652127 652129 598966 738951 745565 743933 590556 598101 801094 678696 440805 565757 680682 643334 439487 441984 490976 651979 658216 734008 461867 481238 718864 525071 565380 724633 470616 486643 652126 794416 719112 440798 566941 521332 440859 477902 558618 577485 564670 584175 658224 658223 630736 765959 482876 569443 674263 590532 520799 502849 446649 486820 658208 658222 658225 658226 630716 442463 771673 652121 744520 444601 575542 578655 588517 450646 658989 558213 603742 630731 464581 517619 524185 486392 459061 518156 485452 564091 461005 435046 513466 496850 569629 658110 605831 460548 440857 424124 479311 591052 716383 441943 469044 472652 636442 474782 675769 723845 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.38%) |
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 392480 393999 424124 435046 439487 440798 440805 440857 440859 440947 441943 441984 442463 444601 446649 450646 458804 459061 460548 461005 461267 461867 464581 469044 470616 472652 474782 477902 479311 481238 482876 484024 485452 486392 486643 486820 490976 496850 502849 513466 517619 518156 520799 521332 524185 525071 549648 558213 558618 561435 564091 564670 565380 565757 566941 569443 569629 575542 577485 578655 583662 584175 588517 590532 590556 591052 598101 598966 601508 603742 605831 630716 630731 630736 636442 643334 651832 651979 652121 652126 652127 652129 658110 658208 658216 658222 658223 658224 658225 658226 658555 658989 674263 674292 675769 678696 680682 680749 685931 716383 717453 718864 719112 723845 724633 734008 735839 738951 743933 744520 745565 747563 765959 768739 771673 794416 794421 797773 799145 801094 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real секс"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real fuck"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real секс"
]
|
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.