Query Metrics
7
Database Queries
7
Different statements
191.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.60 ms (87.39%) |
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 182232 187735 322815 386062 388774 391635 393233 396710 401368 409469 415921 422024 424216 424234 441031 441824 442144 448245 461261 463950 468121 485555 497563 509975 514839 520785 521819 534596 541328 547809 555101 558519 558885 559961 564495 588712 591805 592569 602694 604329 604350 604403 604676 616795 626144 637654 641097 660330 662183 665694 666732 680199 681804 688996 695339 699487 700478 702157 711953 714665 718657 720160 720583 721367 722882 725362 726314 726934 727180 729231 729548 735103 735294 736784 738435 740318 741274 744022 747694 750706 752673 754222 756234 757175 758097 761347 763452 766748 766749 767004 767329 769584 770280 771816 772664 777121 777921 786201 789092 790162 795142 796048 796116 796204 798908 799413 801249 803446 803454 803504 804697 805524 806327 814963 815929 817267 817444 824121 825811 827328 ] |
||||||||||||||||||||||||||||||
|
14.49 ms (7.55%) |
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 801249 726314 750706 752673 757175 798908 805524 766748 726934 756234 767004 747694 767329 771816 761347 602694 711953 803504 441824 541328 720160 718657 641097 604329 591805 604350 799413 729548 754222 729231 770280 409469 396710 187735 468121 514839 534596 666732 558519 626144 604676 588712 796116 736784 393233 424216 442144 448245 509975 386062 388774 555101 665694 688996 695339 699487 700478 714665 722882 662183 681804 720583 558885 604403 616795 637654 804697 789092 790162 796048 796204 786201 795142 735103 738435 744022 769584 725362 763452 766749 741274 758097 772664 721367 777921 803446 424234 660330 680199 463950 182232 735294 391635 322815 461261 547809 559961 564495 702157 592569 777121 806327 740318 727180 803454 441031 520785 521819 485555 497563 401368 415921 422024 817267 817444 815929 825811 827328 824121 814963 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.54%) |
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 182232 187735 322815 386062 388774 391635 393233 396710 401368 409469 415921 422024 424216 424234 441031 441824 442144 448245 461261 463950 468121 485555 497563 509975 514839 520785 521819 534596 541328 547809 555101 558519 558885 559961 564495 588712 591805 592569 602694 604329 604350 604403 604676 616795 626144 637654 641097 660330 662183 665694 666732 680199 681804 688996 695339 699487 700478 702157 711953 714665 718657 720160 720583 721367 722882 725362 726314 726934 727180 729231 729548 735103 735294 736784 738435 740318 741274 744022 747694 750706 752673 754222 756234 757175 758097 761347 763452 766748 766749 767004 767329 769584 770280 771816 772664 777121 777921 786201 789092 790162 795142 796048 796116 796204 798908 799413 801249 803446 803454 803504 804697 805524 806327 814963 815929 817267 817444 824121 825811 827328 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"holes anal"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"holes анал"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"holes анал"
]
|
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.