Query Metrics
7
Database Queries
7
Different statements
186.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.17 ms (86.53%) |
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 66611 187759 188118 188133 188169 188335 276696 358272 382434 382937 388716 388862 389223 389895 391913 392031 396956 396970 398563 404314 404441 407727 408613 409931 411385 411718 411766 411773 411960 413474 424985 439658 439816 451488 452252 454879 454887 457991 462348 465390 466189 469509 470180 471411 479126 482563 485690 486341 516461 531318 609268 609274 624470 625036 645840 650388 664861 665264 665395 665483 667281 667661 668684 668888 697180 703448 705359 711661 714909 716557 716586 718553 718981 721467 722127 724232 724302 724476 726859 726955 727924 728240 728442 736402 737164 739955 741080 741896 742595 745379 748163 748213 748226 748245 749907 758431 758436 758437 759761 770139 772100 772113 774200 781759 781777 781930 785848 789292 789528 803498 807376 808456 808500 808506 808549 808558 818630 824244 825915 826346 ] |
||||||||||||||||||||||||||||||
|
15.65 ms (8.40%) |
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 728240 726955 759761 808500 808506 188335 486341 411766 454887 665395 781759 803498 808549 745379 758436 382434 439658 389895 462348 665264 469509 188169 457991 471411 451488 465390 389223 408613 825915 516461 668684 722127 703448 705359 785848 741080 188133 187759 404441 276696 358272 398563 404314 407727 409931 424985 824244 482563 452252 454879 531318 470180 718981 667281 697180 716557 718553 664861 667661 711661 721467 609274 624470 609268 726859 727924 748226 758431 758437 781777 724476 736402 748213 748245 772100 737164 772113 728442 748163 724232 742595 625036 188118 392031 391913 388716 741896 739955 774200 826346 665483 645840 789292 716586 382937 388862 396956 413474 411773 411960 818630 714909 650388 668888 789528 807376 770139 808456 808558 749907 724302 781930 411385 66611 396970 411718 485690 466189 439816 479126 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.33%) |
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 66611 187759 188118 188133 188169 188335 276696 358272 382434 382937 388716 388862 389223 389895 391913 392031 396956 396970 398563 404314 404441 407727 408613 409931 411385 411718 411766 411773 411960 413474 424985 439658 439816 451488 452252 454879 454887 457991 462348 465390 466189 469509 470180 471411 479126 482563 485690 486341 516461 531318 609268 609274 624470 625036 645840 650388 664861 665264 665395 665483 667281 667661 668684 668888 697180 703448 705359 711661 714909 716557 716586 718553 718981 721467 722127 724232 724302 724476 726859 726955 727924 728240 728442 736402 737164 739955 741080 741896 742595 745379 748163 748213 748226 748245 749907 758431 758436 758437 759761 770139 772100 772113 774200 781759 781777 781930 785848 789292 789528 803498 807376 808456 808500 808506 808549 808558 818630 824244 825915 826346 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature big"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature большие"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature большие"
]
|
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.