Query Metrics
7
Database Queries
7
Different statements
168.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.17 ms (85.64%) |
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 403642 411018 419953 488093 508456 544345 544426 546383 547185 547686 551144 551154 552489 555382 561437 562720 564913 585155 585356 591542 597176 601663 608696 612294 616031 616554 620020 620109 628668 652895 659220 663278 666059 667786 667807 672783 677875 690300 693342 700028 701631 707403 707469 709969 710116 716149 717007 717967 719276 719875 720118 720175 724878 725688 725789 727426 730925 730929 731609 732858 735489 738206 739222 740003 740577 742251 745985 746042 747555 749882 752406 757066 757567 758110 758598 759836 761162 761300 761510 761889 762437 766867 767064 768024 771525 772362 773310 775030 776182 779757 779906 783391 783976 788376 788449 788498 790058 790083 791073 791184 792158 797098 797796 798635 799098 802648 802799 803614 805044 809210 809822 810382 810430 811415 811575 813471 818025 823828 825388 825449 ] |
||||||||||||||||||||||||||||||
|
14.19 ms (8.43%) |
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 690300 544345 672783 547185 612294 591542 779906 791184 725789 803614 730929 727426 719276 776182 720118 788449 739222 757066 825388 717007 620020 616554 740003 735489 659220 667786 667807 758110 749882 799098 772362 551154 811575 411018 788376 759836 745985 747555 707403 797098 761510 823828 717967 716149 746042 775030 710116 709969 561437 797796 730925 757567 742251 788498 802648 809210 761300 779757 488093 790083 752406 771525 825449 616031 608696 811415 732858 761162 783391 792158 818025 601663 552489 666059 677875 620109 585155 810430 805044 791073 761889 731609 740577 597176 768024 564913 693342 720175 700028 585356 790058 724878 652895 562720 809822 508456 403642 419953 628668 762437 725688 738206 766867 767064 773310 707469 701631 802799 783976 813471 758598 544426 551144 555382 546383 663278 719875 547686 798635 810382 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.83%) |
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 403642 411018 419953 488093 508456 544345 544426 546383 547185 547686 551144 551154 552489 555382 561437 562720 564913 585155 585356 591542 597176 601663 608696 612294 616031 616554 620020 620109 628668 652895 659220 663278 666059 667786 667807 672783 677875 690300 693342 700028 701631 707403 707469 709969 710116 716149 717007 717967 719276 719875 720118 720175 724878 725688 725789 727426 730925 730929 731609 732858 735489 738206 739222 740003 740577 742251 745985 746042 747555 749882 752406 757066 757567 758110 758598 759836 761162 761300 761510 761889 762437 766867 767064 768024 771525 772362 773310 775030 776182 779757 779906 783391 783976 788376 788449 788498 790058 790083 791073 791184 792158 797098 797796 798635 799098 802648 802799 803614 805044 809210 809822 810382 810430 811415 811575 813471 818025 823828 825388 825449 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck you"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс you"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс you"
]
|
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.