Query Metrics
7
Database Queries
7
Different statements
179.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.91 ms (85.66%) |
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 389712 426484 427425 441815 442003 443958 444356 446221 452655 452656 456733 472095 472383 498670 504376 507519 530028 530194 530487 530744 531089 531165 531272 532754 533374 533375 535505 535584 537654 537944 540518 540577 542444 542620 545441 549490 550128 553713 555088 557901 563982 576558 580748 588301 597199 599890 599914 599915 600206 602508 607481 615943 620875 627807 628589 630450 631200 631247 632617 632659 632691 634334 636299 636304 637021 637434 641110 641171 641919 642002 645858 646025 646771 646786 646838 647340 648795 648809 648841 650330 651209 651599 666901 671213 673862 677581 678127 682865 687257 695126 696204 696579 703831 703833 705874 707431 716878 722796 728879 730404 734130 742761 743737 744870 762624 765382 769422 777814 782738 789843 790729 791250 797261 800579 802865 813304 813621 819019 826256 826539 ] |
||||||||||||||||||||||||||||||
|
16.19 ms (9.01%) |
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 802865 427425 532754 730404 472095 580748 777814 441815 819019 826539 791250 443958 542444 769422 742761 813304 537944 641110 530744 678127 646838 677581 641171 666901 537654 530028 530487 540518 696204 648809 632617 632659 722796 545441 651209 642002 588301 389712 826256 789843 446221 563982 530194 531272 535505 531165 533374 533375 531089 540577 535584 550128 646025 687257 696579 646771 648795 648841 651599 695126 703831 716878 646786 647340 650330 599890 599915 600206 632691 637021 599914 636304 597199 636299 637434 627807 631247 703833 682865 671213 707431 705874 576558 607481 602508 498670 507519 426484 645858 631200 555088 673862 444356 641919 549490 442003 630450 456733 542620 553713 790729 762624 744870 765382 813621 452655 557901 628589 452656 472383 782738 743737 728879 797261 620875 615943 634334 800579 504376 734130 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.55%) |
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 389712 426484 427425 441815 442003 443958 444356 446221 452655 452656 456733 472095 472383 498670 504376 507519 530028 530194 530487 530744 531089 531165 531272 532754 533374 533375 535505 535584 537654 537944 540518 540577 542444 542620 545441 549490 550128 553713 555088 557901 563982 576558 580748 588301 597199 599890 599914 599915 600206 602508 607481 615943 620875 627807 628589 630450 631200 631247 632617 632659 632691 634334 636299 636304 637021 637434 641110 641171 641919 642002 645858 646025 646771 646786 646838 647340 648795 648809 648841 650330 651209 651599 666901 671213 673862 677581 678127 682865 687257 695126 696204 696579 703831 703833 705874 707431 716878 722796 728879 730404 734130 742761 743737 744870 762624 765382 769422 777814 782738 789843 790729 791250 797261 800579 802865 813304 813621 819019 826256 826539 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade deepthroat swallow"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск глубокийминет минет оральн секс глота"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск глубокийминет минет оральн секс глота"
]
|
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.