Query Metrics
7
Database Queries
7
Different statements
173.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.44 ms (85.09%) |
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 391557 392600 400513 413090 414594 422203 440537 441003 452329 454185 454527 455343 455392 462705 462711 464771 465434 465534 466310 466756 468363 470560 470596 470654 472609 472691 477135 479128 479143 481254 484405 484586 484607 484629 485985 486813 488954 490396 494184 495326 502885 504211 506142 506865 510771 510855 510877 516477 517816 518912 520872 521134 523674 523833 526450 528355 530289 534134 534683 535441 535445 536431 540799 545535 549720 549825 555116 555119 556901 563246 565303 571399 587846 590331 590498 590613 591131 605742 616152 620215 620228 620258 627064 628661 672903 686383 697249 712563 721074 725170 733319 735929 736307 741690 741751 741759 741764 741772 741777 741778 741781 741788 742349 742385 742407 742556 745952 746713 752131 757541 758281 761147 761604 781753 792643 799917 805140 805666 827220 828553 ] |
||||||||||||||||||||||||||||||
|
14.70 ms (8.48%) |
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 506865 516477 510855 534683 517816 523833 526450 742385 506142 485985 752131 799917 414594 477135 462705 672903 697249 712563 556901 628661 590331 620258 620228 627064 741772 741777 741778 741788 746713 792643 735929 736307 725170 742349 742556 745952 741781 757541 741759 761147 466756 481254 465434 486813 523674 470596 392600 528355 510877 521134 479143 549825 452329 484607 587846 620215 472691 536431 440537 484586 761604 518912 400513 530289 571399 413090 454185 391557 549720 686383 781753 741690 721074 590498 758281 510771 565303 741751 742407 555116 555119 590613 733319 741764 455343 472609 520872 494184 454527 540799 466310 591131 422203 502885 616152 441003 484629 535441 470560 455392 488954 490396 805666 465534 464771 534134 545535 805140 563246 484405 504211 605742 462711 470654 535445 495326 479128 827220 828553 468363 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.55%) |
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 391557 392600 400513 413090 414594 422203 440537 441003 452329 454185 454527 455343 455392 462705 462711 464771 465434 465534 466310 466756 468363 470560 470596 470654 472609 472691 477135 479128 479143 481254 484405 484586 484607 484629 485985 486813 488954 490396 494184 495326 502885 504211 506142 506865 510771 510855 510877 516477 517816 518912 520872 521134 523674 523833 526450 528355 530289 534134 534683 535441 535445 536431 540799 545535 549720 549825 555116 555119 556901 563246 565303 571399 587846 590331 590498 590613 591131 605742 616152 620215 620228 620258 627064 628661 672903 686383 697249 712563 721074 725170 733319 735929 736307 741690 741751 741759 741764 741772 741777 741778 741781 741788 742349 742385 742407 742556 745952 746713 752131 757541 758281 761147 761604 781753 792643 799917 805140 805666 827220 828553 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жена зрелая русская"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен зрелая женщин русск"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.97%) |
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.