Query Metrics
7
Database Queries
7
Different statements
162.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.14 ms (85.50%) |
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 4324 89021 346907 387489 389065 390707 396441 418562 419053 422450 423431 432387 432392 432430 432478 432528 433429 433433 433662 433740 433758 434236 435701 437403 440793 446527 458779 490732 502372 509772 515295 516413 528661 528861 529657 530168 531526 532301 538060 539006 547837 561571 563088 577667 588481 594238 595113 599798 610242 610696 618749 641865 697392 701938 710050 710577 710880 717119 719972 721962 723446 725438 726397 728651 731259 734013 734041 734247 737613 737805 739739 741665 742924 744764 745318 746436 748557 749427 751476 753494 754145 755364 761316 767720 767737 768161 768809 769181 780073 780187 780208 783807 785347 789572 791711 791814 792463 792538 792921 792926 795327 795795 795802 795813 795929 797527 801451 811426 817397 817579 823179 823623 824222 824697 826302 828020 828337 828660 828780 ] |
||||||||||||||||||||||||||||||
|
13.41 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 528661 490732 547837 792921 734041 418562 419053 748557 755364 767720 446527 432528 433662 440793 595113 387489 422450 717119 434236 824222 817397 824697 435701 641865 754145 396441 516413 610242 769181 734013 751476 561571 594238 437403 701938 563088 710577 610696 618749 792538 737805 789572 795929 423431 432430 432392 795795 780208 346907 4324 458779 529657 710880 577667 588481 734247 811426 731259 739739 753494 749427 728651 746436 710050 792463 389065 390707 433433 539006 823623 828020 768161 823179 828660 795802 795813 742924 433758 515295 509772 433740 744764 745318 725438 791711 538060 697392 719972 599798 828337 531526 726397 741665 767737 737613 792926 433429 432478 89021 532301 780073 432387 721962 791814 780187 795327 768809 785347 801451 502372 826302 817579 828780 530168 723446 782798 783807 797527 761316 528861 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.81%) |
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 4324 89021 346907 387489 389065 390707 396441 418562 419053 422450 423431 432387 432392 432430 432478 432528 433429 433433 433662 433740 433758 434236 435701 437403 440793 446527 458779 490732 502372 509772 515295 516413 528661 528861 529657 530168 531526 532301 538060 539006 547837 561571 563088 577667 588481 594238 595113 599798 610242 610696 618749 641865 697392 701938 710050 710577 710880 717119 719972 721962 723446 725438 726397 728651 731259 734013 734041 734247 737613 737805 739739 741665 742924 744764 745318 746436 748557 749427 751476 753494 754145 755364 761316 767720 767737 768161 768809 769181 780073 780187 780208 783807 785347 789572 791711 791814 792463 792538 792921 792926 795327 795795 795802 795813 795929 797527 801451 811426 817397 817579 823179 823623 824222 824697 826302 828020 828337 828660 828780 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife handjob"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.94%) |
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.