Query Metrics
7
Database Queries
7
Different statements
362.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.77 ms (58.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
124.39 ms (34.33%) |
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 7286 106162 295523 360015 385079 385092 385745 387274 393659 395572 395609 395686 395913 395984 396184 396640 396654 397329 400436 400672 401091 401975 401993 402267 402678 404059 404633 404753 404935 405100 410573 414198 414498 414710 415256 416303 416934 419590 420207 422500 422565 422924 422985 423464 428631 432752 434208 443513 445933 447675 448507 451554 451749 456215 456414 458051 462803 465237 468715 470154 474295 474626 476808 478853 479765 481719 482080 510964 515165 515186 519227 519469 520733 523274 543863 544368 550051 550236 559507 561826 567605 576021 581096 593125 597264 601877 621317 626543 642779 655861 676924 696969 696973 696995 702633 704841 708457 709703 717892 720462 721551 723536 726461 738274 743131 744300 744328 751500 760925 771180 775784 784600 788739 801281 808266 810775 812097 814125 815855 827523 ] |
||||||||||||||||||||||||||||||
|
16.48 ms (4.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 721551 550051 404059 476808 405100 414710 448507 519227 621317 416303 704841 775784 387274 414498 397329 447675 401993 515165 723536 597264 743131 422500 420207 510964 561826 543863 519469 676924 696969 434208 422924 474295 550236 601877 295523 415256 385745 385092 395686 445933 451554 462803 395609 422985 401975 812097 788739 396184 815855 720462 726461 744300 106162 482080 642779 400436 479765 428631 419590 422565 410573 416934 468715 395984 581096 458051 810775 808266 515186 395572 396654 404935 404753 393659 423464 465237 396640 520733 443513 567605 401091 402267 696995 593125 456414 478853 626543 751500 801281 738274 414198 432752 395913 400672 709703 402678 451749 456215 576021 559507 544368 360015 481719 385079 470154 474626 814125 827523 655861 696973 771180 744328 523274 7286 404633 702633 708457 717892 784600 760925 ] |
||||||||||||||||||||||||||||||
|
4.18 ms (1.15%) |
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 7286 106162 295523 360015 385079 385092 385745 387274 393659 395572 395609 395686 395913 395984 396184 396640 396654 397329 400436 400672 401091 401975 401993 402267 402678 404059 404633 404753 404935 405100 410573 414198 414498 414710 415256 416303 416934 419590 420207 422500 422565 422924 422985 423464 428631 432752 434208 443513 445933 447675 448507 451554 451749 456215 456414 458051 462803 465237 468715 470154 474295 474626 476808 478853 479765 481719 482080 510964 515165 515186 519227 519469 520733 523274 543863 544368 550051 550236 559507 561826 567605 576021 581096 593125 597264 601877 621317 626543 642779 655861 676924 696969 696973 696995 702633 704841 708457 709703 717892 720462 721551 723536 726461 738274 743131 744300 744328 751500 760925 771180 775784 784600 788739 801281 808266 810775 812097 814125 815855 827523 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old man anal"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old мужчин анал"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old мужчин анал"
]
|
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.