Query Metrics
7
Database Queries
7
Different statements
183.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.86 ms (78.51%) |
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 88486 154692 384117 385713 386193 387218 388930 392839 395479 414064 418112 432683 434324 435559 441095 447315 455004 492215 501611 510812 515364 515564 520907 522205 530426 533308 536684 542413 542588 545551 546829 547470 548153 548458 550930 555029 556877 556881 558725 559281 560086 568259 568270 574458 584374 590476 591334 605711 610075 617577 617807 619533 620061 621682 622720 624193 630798 634750 636293 639802 640242 647885 648716 649579 650305 650498 651962 653028 666672 673838 677307 678707 688181 693927 696216 696584 699556 707571 713885 718987 722390 724580 728215 736164 736307 738461 738501 739948 740817 744021 744795 746177 748287 752609 752627 752689 756773 758322 782108 784236 786876 788528 790954 792689 792761 794307 794651 796270 796872 797279 800293 801626 801629 801639 803134 804198 807569 811013 811785 812057 ] |
||||||||||||||||||||||||||||||
|
27.39 ms (14.95%) |
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 530426 533308 550930 555029 584374 568270 545551 653028 718987 650305 651962 693927 699556 722390 558725 620061 630798 619533 634750 617577 794307 784236 790954 801626 738501 782108 792689 811785 740817 739948 756773 738461 752689 617807 796270 796872 797279 88486 395479 154692 677307 542588 591334 520907 605711 678707 610075 801639 736164 455004 536684 522205 696216 649579 647885 639802 447315 501611 515364 556881 492215 636293 547470 548153 713885 800293 752609 786876 385713 384117 432683 435559 546829 542413 548458 688181 673838 696584 650498 707571 568259 640242 621682 624193 788528 807569 792761 804198 758322 736307 724580 746177 744021 744795 728215 748287 752627 622720 801629 803134 812057 392839 386193 388930 387218 418112 441095 414064 510812 515564 560086 559281 666672 648716 556877 574458 590476 811013 794651 434324 ] |
||||||||||||||||||||||||||||||
|
4.34 ms (2.37%) |
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 88486 154692 384117 385713 386193 387218 388930 392839 395479 414064 418112 432683 434324 435559 441095 447315 455004 492215 501611 510812 515364 515564 520907 522205 530426 533308 536684 542413 542588 545551 546829 547470 548153 548458 550930 555029 556877 556881 558725 559281 560086 568259 568270 574458 584374 590476 591334 605711 610075 617577 617807 619533 620061 621682 622720 624193 630798 634750 636293 639802 640242 647885 648716 649579 650305 650498 651962 653028 666672 673838 677307 678707 688181 693927 696216 696584 699556 707571 713885 718987 722390 724580 728215 736164 736307 738461 738501 739948 740817 744021 744795 746177 748287 752609 752627 752689 756773 758322 782108 784236 786876 788528 790954 792689 792761 794307 794651 796270 796872 797279 800293 801626 801629 801639 803134 804198 807569 811013 811785 812057 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"extreme fisting pussy"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор фистинг pussy"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"хардкор фистинг pussy"
]
|
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.