Query Metrics
7
Database Queries
7
Different statements
206.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.53 ms (88.28%) |
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 54117 182110 319863 389680 389697 389858 390052 390497 390749 391512 391993 395933 398564 400684 400811 402963 408435 418918 424040 424045 424169 424243 425244 433781 453921 454106 455579 456890 457912 462347 466497 479284 485658 492027 496685 504167 513816 515731 521049 529885 529963 530937 535332 535984 540660 545179 554772 555092 556670 557367 557450 559005 569010 582153 593144 602680 611192 623147 625236 629512 638872 639801 641118 643194 644707 647916 660129 664237 667757 669907 673647 675226 675393 693679 698910 714795 717943 724628 728225 728957 733088 734427 735498 736020 740162 741067 741201 753247 756669 763697 764030 764034 768001 768194 769517 770039 770990 771316 772626 773105 776737 778117 779558 779883 783327 788824 795519 798629 801384 801385 805809 806140 811730 812715 814304 819814 819815 827829 828155 ] |
||||||||||||||||||||||||||||||
|
14.76 ms (7.14%) |
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 768001 771316 740162 756669 772626 398564 462347 556670 425244 395933 433781 390497 669907 806140 424169 400684 453921 513816 667757 389858 496685 557367 660129 664237 675393 639801 644707 623147 728225 602680 629512 424045 54117 389697 408435 805809 753247 529963 535332 625236 724628 733088 764034 402963 319863 182110 390052 814304 390749 418918 457912 479284 456890 529885 530937 698910 693679 638872 798629 801384 776737 783327 801385 734427 770039 770990 735498 764030 741201 763697 714795 811730 812715 391993 424040 504167 424243 515731 557450 582153 675226 673647 717943 555092 641118 779558 779883 778117 795519 741067 769517 773105 736020 768194 788824 454106 466497 492027 819814 824575 400811 521049 569010 643194 728957 455579 389680 827829 554772 647916 593144 485658 819815 828155 391512 540660 535984 559005 545179 611192 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (1.68%) |
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 54117 182110 319863 389680 389697 389858 390052 390497 390749 391512 391993 395933 398564 400684 400811 402963 408435 418918 424040 424045 424169 424243 425244 433781 453921 454106 455579 456890 457912 462347 466497 479284 485658 492027 496685 504167 513816 515731 521049 529885 529963 530937 535332 535984 540660 545179 554772 555092 556670 557367 557450 559005 569010 582153 593144 602680 611192 623147 625236 629512 638872 639801 641118 643194 644707 647916 660129 664237 667757 669907 673647 675226 675393 693679 698910 714795 717943 724628 728225 728957 733088 734427 735498 736020 740162 741067 741201 753247 756669 763697 764030 764034 768001 768194 769517 770039 770990 771316 772626 773105 776737 778117 779558 779883 783327 788824 795519 798629 801384 801385 805809 806140 811730 812715 814304 819814 819815 827829 828155 ] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск milf беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск milf беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur milf blonde"
]
|
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.