Query Metrics
7
Database Queries
7
Different statements
184.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.78 ms (87.11%) |
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 31723 34296 150798 233346 265654 382554 387334 392880 395291 423383 442271 446721 448796 453303 453893 457180 460976 462558 482877 506002 509837 511485 512046 515603 520932 523002 530508 548154 556965 558539 563514 578100 581190 583564 584484 585453 585525 587155 588669 593112 594892 594942 594987 601251 601262 601285 605990 607229 613122 619235 621686 623991 626577 633172 637521 648206 648437 650490 660301 665122 667523 667846 679632 682516 684018 692654 695598 695730 708438 714429 714620 716111 716190 717692 722673 724171 724174 725513 726602 727006 727239 732970 735875 740985 741001 741009 741077 743861 750948 759867 760823 771291 772879 774196 774524 777792 780728 781893 782407 788866 789605 790000 790001 794786 796243 796957 799710 801416 802467 803495 806352 812912 814874 814922 815095 815395 815772 816085 818435 824473 ] |
||||||||||||||||||||||||||||||
|
13.66 ms (7.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 716111 556965 583564 585453 601251 601262 619235 585525 794786 799710 788866 741077 735875 759867 726602 743861 760823 724171 771291 727006 727239 732970 772879 637521 714429 722673 777792 781893 233346 392880 453893 265654 382554 520932 395291 457180 725513 724174 782407 558539 423383 462558 633172 796957 34296 448796 511485 150798 660301 442271 548154 515603 584484 815095 815395 446721 506002 593112 594987 806352 774196 523002 815772 824473 460976 714620 692654 578100 613122 780728 750948 482877 31723 387334 814874 816085 818435 814922 453303 530508 512046 509837 563514 581190 648206 650490 665122 682516 695598 648437 667523 684018 695730 667846 679632 708438 716190 717692 588669 621686 587155 594892 594942 605990 607229 601285 626577 623991 789605 790001 774524 790000 740985 741001 741009 796243 801416 802467 803495 812912 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.54%) |
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 31723 34296 150798 233346 265654 382554 387334 392880 395291 423383 442271 446721 448796 453303 453893 457180 460976 462558 482877 506002 509837 511485 512046 515603 520932 523002 530508 548154 556965 558539 563514 578100 581190 583564 584484 585453 585525 587155 588669 593112 594892 594942 594987 601251 601262 601285 605990 607229 613122 619235 621686 623991 626577 633172 637521 648206 648437 650490 660301 665122 667523 667846 679632 682516 684018 692654 695598 695730 708438 714429 714620 716111 716190 717692 722673 724171 724174 725513 726602 727006 727239 732970 735875 740985 741001 741009 741077 743861 750948 759867 760823 771291 772879 774196 774524 777792 780728 781893 782407 788866 789605 790000 790001 794786 796243 796957 799710 801416 802467 803495 806352 812912 814874 814922 815095 815395 815772 816085 818435 824473 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"office big ass"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секретарш большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секретарш большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.