Query Metrics
7
Database Queries
7
Different statements
157.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.35 ms (84.78%) |
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 406917 414317 424200 426468 428617 430621 434455 435768 444134 448869 451030 466963 468036 468606 471858 471888 472217 472229 472788 481668 484744 487931 491359 491566 491704 501830 507521 507701 511700 512240 512487 514709 515067 516140 516888 517698 518771 518786 519838 524460 524910 529251 530109 531935 532061 534733 539480 542664 544513 549858 556428 556927 558762 558868 560471 565164 565468 565506 565507 566013 567154 568452 568560 571254 571684 576626 577358 578057 585127 586931 589551 590948 591346 594792 594880 596242 599565 601544 601600 603773 604984 606185 606618 607079 607080 607707 607813 612867 617825 636053 670513 671584 673357 676427 685475 687503 691254 702463 716055 720603 726603 727622 730933 734016 737633 770878 770882 785939 797675 805484 806445 807686 807957 811051 814288 814778 815194 817115 817860 828006 ] |
||||||||||||||||||||||||||||||
|
12.96 ms (8.24%) |
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 539480 577358 560471 566013 544513 568560 670513 676427 691254 607080 589551 599565 607813 612867 601544 603773 785939 727622 730933 797675 565506 466963 514709 424200 472217 414317 434455 815194 487931 471858 515067 507701 532061 516888 542664 549858 811051 472788 428617 444134 472229 501830 512240 491359 491704 511700 484744 507521 518786 529251 607707 430621 524460 828006 685475 734016 558762 567154 601600 531935 565468 585127 814288 817860 558868 565164 716055 556927 576626 591346 594792 606185 606618 596242 770878 807686 726603 617825 702463 720603 406917 435768 817115 814778 468606 534733 524910 530109 565507 571254 571684 556428 671584 687503 673357 568452 578057 586931 590948 594880 636053 807957 805484 737633 770882 604984 607079 806445 468036 471888 481668 426468 448869 451030 517698 491566 512487 516140 518771 519838 ] |
||||||||||||||||||||||||||||||
|
3.65 ms (2.32%) |
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 406917 414317 424200 426468 428617 430621 434455 435768 444134 448869 451030 466963 468036 468606 471858 471888 472217 472229 472788 481668 484744 487931 491359 491566 491704 501830 507521 507701 511700 512240 512487 514709 515067 516140 516888 517698 518771 518786 519838 524460 524910 529251 530109 531935 532061 534733 539480 542664 544513 549858 556428 556927 558762 558868 560471 565164 565468 565506 565507 566013 567154 568452 568560 571254 571684 576626 577358 578057 585127 586931 589551 590948 591346 594792 594880 596242 599565 601544 601600 603773 604984 606185 606618 607079 607080 607707 607813 612867 617825 636053 670513 671584 673357 676427 685475 687503 691254 702463 716055 720603 726603 727622 730933 734016 737633 770878 770882 785939 797675 805484 806445 807686 807957 811051 814288 814778 815194 817115 817860 828006 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small dick mom"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая член mom"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая член mom"
]
|
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.