Query Metrics
7
Database Queries
7
Different statements
155.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.66 ms (82.74%) |
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 422291 422524 422557 422618 423264 429174 444386 444768 445057 446133 446143 449911 454151 462781 464355 464880 466677 472223 476157 477467 479825 482522 482818 485479 489842 491700 492394 496993 506850 509487 519682 522117 523446 523987 524227 529048 531429 531430 533814 547061 551892 553128 554068 554302 556329 566029 566063 567360 575500 577515 578360 580185 580776 582548 582597 583679 586498 587202 590934 593354 593418 594014 595925 596566 597226 598438 600559 602044 603773 605727 609052 616000 618916 620011 620103 623598 624273 624276 630528 653548 654392 654423 665296 672588 677311 700659 705667 705717 709636 709732 715138 716528 717610 717708 717845 719102 720802 720819 721704 722199 722462 724509 725115 727696 727753 732423 736631 740526 744511 745322 747439 747984 751722 752132 756181 757442 758193 761474 793436 810242 ] |
||||||||||||||||||||||||||||||
|
18.04 ms (11.60%) |
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 422618 423264 429174 422524 445057 422291 422557 444386 444768 482818 466677 477467 479825 489842 492394 454151 476157 446133 446143 449911 464355 485479 496993 523987 506850 519682 522117 529048 523446 531429 531430 509487 524227 533814 462781 464880 472223 482522 491700 577515 580776 582548 547061 566063 551892 554068 556329 567360 578360 580185 653548 654392 700659 709732 716528 719102 654423 665296 672588 705717 709636 677311 717610 717845 720802 720819 722199 722462 553128 554302 566029 575500 582597 583679 586498 595925 605727 587202 590934 593354 598438 600559 618916 593418 594014 597226 616000 620103 624273 596566 603773 609052 620011 624276 630528 793436 740526 752132 810242 724509 725115 727696 747439 747984 756181 757442 736631 758193 727753 732423 744511 751722 745322 761474 602044 623598 705667 715138 717708 721704 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.51%) |
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 422291 422524 422557 422618 423264 429174 444386 444768 445057 446133 446143 449911 454151 462781 464355 464880 466677 472223 476157 477467 479825 482522 482818 485479 489842 491700 492394 496993 506850 509487 519682 522117 523446 523987 524227 529048 531429 531430 533814 547061 551892 553128 554068 554302 556329 566029 566063 567360 575500 577515 578360 580185 580776 582548 582597 583679 586498 587202 590934 593354 593418 594014 595925 596566 597226 598438 600559 602044 603773 605727 609052 616000 618916 620011 620103 623598 624273 624276 630528 653548 654392 654423 665296 672588 677311 700659 705667 705717 709636 709732 715138 716528 717610 717708 717845 719102 720802 720819 721704 722199 722462 724509 725115 727696 727753 732423 736631 740526 744511 745322 747439 747984 751722 752132 756181 757442 758193 761474 793436 810242 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"man casting"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мужчин кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.23 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.