Query Metrics
7
Database Queries
7
Different statements
154.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.97 ms (85.25%) |
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 410563 411818 411845 413304 417042 424480 438283 443094 452241 457206 463818 463848 464445 464608 465618 465664 474695 477032 478455 480390 480392 480396 480415 482790 482795 485216 486413 486446 486478 486516 488746 499805 502250 513216 516218 518218 518228 519465 519726 521587 522191 530728 531124 531186 532752 533563 534631 536286 536624 537912 542212 543607 544477 545217 558443 565484 576972 577634 587418 590707 591792 591867 596075 596108 598194 599915 599993 600312 601535 601536 601604 604523 604575 604905 606635 620663 625521 630053 630633 634209 639717 639784 642346 643263 649108 649132 651082 651851 665930 666869 668537 670293 671639 675405 691598 700851 710500 712010 713091 714117 716116 717918 718838 720711 720743 724256 724289 725642 726461 726662 726675 726871 726872 738519 742244 750549 756425 759733 765297 804491 ] |
||||||||||||||||||||||||||||||
|
14.19 ms (9.17%) |
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 598194 410563 639784 411845 464608 464445 443094 438283 486478 482795 480392 534631 544477 591867 596075 630053 726872 804491 499805 486516 601535 604523 411818 465618 463818 488746 521587 536286 536624 519465 537912 545217 542212 691598 649108 651851 666869 671639 720711 668537 625521 643263 587418 630633 642346 750549 765297 724289 726675 738519 601536 417042 463848 465664 480415 519726 518218 675405 533563 543607 482790 486446 513216 502250 486413 620663 452241 474695 485216 457206 477032 480390 516218 518228 530728 532752 565484 576972 577634 649132 651082 665930 710500 712010 713091 714117 720743 700851 717918 718838 558443 590707 599993 604905 604575 606635 634209 596108 726871 742244 724256 725642 756425 726461 726662 759733 716116 413304 478455 522191 424480 670293 601604 480396 531186 531124 591792 599915 600312 639717 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.75%) |
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 410563 411818 411845 413304 417042 424480 438283 443094 452241 457206 463818 463848 464445 464608 465618 465664 474695 477032 478455 480390 480392 480396 480415 482790 482795 485216 486413 486446 486478 486516 488746 499805 502250 513216 516218 518218 518228 519465 519726 521587 522191 530728 531124 531186 532752 533563 534631 536286 536624 537912 542212 543607 544477 545217 558443 565484 576972 577634 587418 590707 591792 591867 596075 596108 598194 599915 599993 600312 601535 601536 601604 604523 604575 604905 606635 620663 625521 630053 630633 634209 639717 639784 642346 643263 649108 649132 651082 651851 665930 666869 668537 670293 671639 675405 691598 700851 710500 712010 713091 714117 716116 717918 718838 720711 720743 724256 724289 725642 726461 726662 726675 726871 726872 738519 742244 750549 756425 759733 765297 804491 ] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"casting anal mature"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг анал mature"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кастинг анал mature"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.