Query Metrics
7
Database Queries
7
Different statements
188.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.95 ms (86.26%) |
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 6806 395263 413999 416022 437494 438025 439256 444882 450579 452813 464188 469411 501931 508485 508888 512073 516652 527085 531677 531868 533481 533841 533944 537914 565501 566320 584267 585346 592862 594875 595977 596621 598720 599990 600257 601578 619175 620612 628401 633237 635975 639108 639823 642323 648744 649472 651912 660620 663293 671520 672396 683661 697220 705253 705262 711860 714142 715798 718793 719327 720339 720717 725743 726064 728930 735978 736959 740816 744560 744896 746087 748965 756708 758163 765211 765479 770271 772842 772887 781485 784792 784975 787043 787095 788922 789710 790069 791365 793723 794687 796177 796236 797050 797088 799651 800339 802803 805039 805201 806025 806653 806924 807261 807589 809556 809707 810884 813706 814038 814168 814211 815274 815585 816995 818465 818897 819585 824434 824498 826971 ] |
||||||||||||||||||||||||||||||
|
15.43 ms (8.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 635975 600257 601578 565501 592862 437494 452813 416022 395263 438025 413999 813706 824434 818897 816995 469411 531868 531677 584267 648744 660620 672396 649472 663293 671520 715798 720339 711860 633237 781485 789710 791365 796177 806025 807261 793723 794687 806924 809556 725743 740816 802803 806653 758163 744896 756708 765211 735978 744560 746087 748965 726064 736959 772842 772887 705253 705262 718793 797050 797088 810884 6806 594875 596621 598720 439256 444882 464188 566320 595977 628401 639823 599990 728930 770271 620612 450579 512073 508485 516652 527085 501931 533944 537914 619175 814038 533481 683661 639108 807589 805039 765479 819585 814168 814211 824498 826971 815274 815585 818465 508888 533841 651912 697220 720717 714142 719327 642323 585346 784792 787043 787095 788922 796236 799651 800339 805201 809707 784975 790069 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.62%) |
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 6806 395263 413999 416022 437494 438025 439256 444882 450579 452813 464188 469411 501931 508485 508888 512073 516652 527085 531677 531868 533481 533841 533944 537914 565501 566320 584267 585346 592862 594875 595977 596621 598720 599990 600257 601578 619175 620612 628401 633237 635975 639108 639823 642323 648744 649472 651912 660620 663293 671520 672396 683661 697220 705253 705262 711860 714142 715798 718793 719327 720339 720717 725743 726064 728930 735978 736959 740816 744560 744896 746087 748965 756708 758163 765211 765479 770271 772842 772887 781485 784792 784975 787043 787095 788922 789710 790069 791365 793723 794687 796177 796236 797050 797088 799651 800339 802803 805039 805201 806025 806653 806924 807261 807589 809556 809707 810884 813706 814038 814168 814211 815274 815585 816995 818465 818897 819585 824434 824498 826971 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сквирт татуированная …"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сквирт оргазм татуированные"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сквирт оргазм татуированные"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.89%) |
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.