Query Metrics
7
Database Queries
7
Different statements
274.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
239.70 ms (87.19%) |
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 9021 392903 401049 407464 431963 442168 442864 443600 446906 449855 452418 453631 453848 457590 459107 459597 459667 461346 461417 462548 462566 466255 470161 473969 474029 484919 487448 491027 492609 492627 497240 497416 500691 501623 504042 508484 518106 520468 520692 521977 522662 524408 526383 526426 526434 527943 528867 533021 534769 545725 548866 549783 555680 559080 559771 563549 570505 575189 575607 578565 578610 587579 587791 588762 590854 590877 590879 590881 590885 590906 591789 592421 593344 596556 597753 603175 606794 607058 608921 609412 610002 611190 613815 614020 615774 619247 619379 620377 625363 628194 633045 634297 635838 644399 649642 653900 654597 675898 676289 676804 696172 707557 707597 724425 728145 740212 764490 771971 776768 786230 792910 793431 797519 797849 799601 806765 812777 814062 814265 825299 ] |
||||||||||||||||||||||||||||||
|
24.01 ms (8.73%) |
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 799601 459107 520468 590906 814062 675898 707557 9021 593344 609412 392903 633045 625363 555680 619379 812777 526434 570505 449855 615774 470161 533021 649642 696172 588762 611190 526426 654597 492609 528867 613815 459667 527943 590854 491027 487448 610002 676804 596556 461346 442864 497240 501623 524408 628194 592421 452418 534769 559771 606794 676289 590881 806765 407464 590877 453631 500691 518106 724425 644399 446906 474029 797849 619247 453848 591789 793431 740212 764490 401049 462548 814265 545725 575607 492627 508484 504042 578565 442168 443600 461417 575189 563549 707597 548866 607058 634297 590879 614020 776768 792910 771971 459597 466255 825299 520692 484919 620377 590885 473969 497416 522662 526383 578610 549783 653900 559080 608921 587791 603175 635838 587579 597753 728145 786230 797519 462566 431963 457590 521977 ] |
||||||||||||||||||||||||||||||
|
3.72 ms (1.35%) |
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 9021 392903 401049 407464 431963 442168 442864 443600 446906 449855 452418 453631 453848 457590 459107 459597 459667 461346 461417 462548 462566 466255 470161 473969 474029 484919 487448 491027 492609 492627 497240 497416 500691 501623 504042 508484 518106 520468 520692 521977 522662 524408 526383 526426 526434 527943 528867 533021 534769 545725 548866 549783 555680 559080 559771 563549 570505 575189 575607 578565 578610 587579 587791 588762 590854 590877 590879 590881 590885 590906 591789 592421 593344 596556 597753 603175 606794 607058 608921 609412 610002 611190 613815 614020 615774 619247 619379 620377 625363 628194 633045 634297 635838 644399 649642 653900 654597 675898 676289 676804 696172 707557 707597 724425 728145 740212 764490 771971 776768 786230 792910 793431 797519 797849 799601 806765 812777 814062 814265 825299 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жмж секс втро домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жмж дом"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.56%) |
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.