Query Metrics
7
Database Queries
7
Different statements
165.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.01 ms (84.69%) |
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 386816 411310 422336 446316 453252 453462 453465 455321 469693 480248 494722 500818 530523 540753 549656 552589 556625 562992 565872 576975 578200 580608 587155 596468 601619 603612 604327 604937 605527 623325 623656 630402 637752 667015 667021 675941 681074 681307 690100 693563 694194 697220 698983 699139 699370 702689 702898 702936 704265 710460 712130 714421 718393 718694 722112 723093 723728 725650 726848 727393 727653 727757 727972 728984 729056 729298 729932 730171 730793 731143 732184 732933 733586 734073 734207 734296 734532 735581 738851 740806 741785 742821 745165 747250 748470 750635 751661 755464 755555 756632 756725 758077 760592 761525 762781 764093 766114 769726 774248 784211 789958 796037 800018 800101 800110 802726 805808 808183 809721 809898 812924 813527 815332 815343 815353 817313 818511 820151 820329 ] |
||||||||||||||||||||||||||||||
|
14.52 ms (8.78%) |
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 623325 800018 784211 796037 809721 812924 726848 727757 729932 734207 750635 755555 766114 802726 813527 730793 732184 725650 728984 738851 756632 762781 764093 729298 734532 745165 761525 730171 731143 734073 740806 755464 760592 630402 699139 702689 702898 704265 714421 722112 800110 818511 826136 815332 815343 500818 540753 576975 702936 723093 596468 601619 734296 742821 774248 800101 733586 729056 386816 411310 422336 820151 820329 815353 817313 453252 453465 480248 446316 453462 530523 549656 556625 562992 578200 552589 565872 667021 693563 697220 698983 710460 712130 718393 675941 681307 690100 694194 667015 681074 580608 604937 623656 587155 604327 605527 809898 727653 748470 758077 805808 732933 747250 723728 727393 727972 735581 751661 756725 769726 741785 637752 699370 718694 789958 808183 469693 494722 603612 455321 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (1.97%) |
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 386816 411310 422336 446316 453252 453462 453465 455321 469693 480248 494722 500818 530523 540753 549656 552589 556625 562992 565872 576975 578200 580608 587155 596468 601619 603612 604327 604937 605527 623325 623656 630402 637752 667015 667021 675941 681074 681307 690100 693563 694194 697220 698983 699139 699370 702689 702898 702936 704265 710460 712130 714421 718393 718694 722112 723093 723728 725650 726848 727393 727653 727757 727972 728984 729056 729298 729932 730171 730793 731143 732184 732933 733586 734073 734207 734296 734532 735581 738851 740806 741785 742821 745165 747250 748470 750635 751661 755464 755555 756632 756725 758077 760592 761525 762781 764093 766114 769726 774248 784211 789958 796037 800018 800101 800110 802726 805808 808183 809721 809898 812924 813527 815332 815343 815353 817313 818511 820151 820329 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy milf cock"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy milf cock"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy milf cock"
]
|
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.