Query Metrics
7
Database Queries
7
Different statements
172.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.10 ms (83.02%) |
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 97276 391513 393641 395920 397130 397353 397690 401940 414783 415520 418887 419383 427781 433086 445903 447436 447662 461077 461743 462687 464696 476962 480945 486044 493218 495331 497439 508149 513482 516692 517990 518468 527339 527523 527546 527567 527927 528951 528995 529015 529066 529574 529628 530480 531868 535423 538316 547136 553674 565162 573767 573793 574510 574789 575131 580318 584341 585781 595401 595412 597048 597573 597801 598056 598510 598712 598752 600485 606408 614354 616728 617336 622045 626295 629696 633768 636057 677367 694424 697427 705753 708770 715087 719303 720419 721882 721909 722782 724206 728713 731693 734349 736538 737298 737343 744551 754073 756094 760902 760924 761135 762228 766814 769098 774021 778867 785346 786493 791668 801265 802169 814010 817378 817402 817505 817611 821482 821705 823235 825890 ] |
||||||||||||||||||||||||||||||
|
18.17 ms (10.54%) |
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 527546 415520 595412 597048 462687 414783 517990 573767 573793 445903 480945 527339 736538 397690 817378 821482 825890 715087 705753 708770 626295 629696 614354 791668 801265 774021 762228 766814 769098 760924 724206 622045 786493 97276 393641 529066 531868 721882 397130 823235 529574 547136 697427 719303 720419 636057 778867 756094 754073 760902 721909 401940 527567 433086 633768 486044 529015 574510 802169 785346 737343 744551 606408 391513 518468 395920 528951 528995 527523 616728 553674 821705 529628 734349 447662 677367 585781 597801 598712 737298 722782 397353 535423 580318 427781 516692 461077 530480 575131 538316 513482 565162 595401 598510 419383 464696 461743 497439 527927 598056 600485 418887 447436 493218 508149 694424 617336 731693 495331 728713 761135 574789 597573 598752 476962 814010 817505 817611 817402 584341 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.91%) |
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 97276 391513 393641 395920 397130 397353 397690 401940 414783 415520 418887 419383 427781 433086 445903 447436 447662 461077 461743 462687 464696 476962 480945 486044 493218 495331 497439 508149 513482 516692 517990 518468 527339 527523 527546 527567 527927 528951 528995 529015 529066 529574 529628 530480 531868 535423 538316 547136 553674 565162 573767 573793 574510 574789 575131 580318 584341 585781 595401 595412 597048 597573 597801 598056 598510 598712 598752 600485 606408 614354 616728 617336 622045 626295 629696 633768 636057 677367 694424 697427 705753 708770 715087 719303 720419 721882 721909 722782 724206 728713 731693 734349 736538 737298 737343 744551 754073 756094 760902 760924 761135 762228 766814 769098 774021 778867 785346 786493 791668 801265 802169 814010 817378 817402 817505 817611 821482 821705 823235 825890 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на 18 улиц teen"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public 18 teen"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на 18 улиц teen"
]
|
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.