Query Metrics
7
Database Queries
7
Different statements
197.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.25 ms (85.87%) |
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 90718 163429 323041 381776 382812 392086 393754 396884 400440 402093 402245 419386 429124 443225 443381 445057 453118 458414 462510 494382 515140 515194 515234 525778 529307 548533 551557 554428 557207 558050 558320 561725 566170 566521 569666 570076 572099 586582 601650 621657 621709 624858 630155 648504 652573 655366 655752 655940 663353 664539 664840 667231 667858 668648 674356 677044 678726 678763 684205 684583 685004 687187 688307 688677 689579 689685 694540 697298 701118 704788 708389 708431 710970 715300 716468 717699 725914 730579 739074 740522 741889 742698 743039 743096 747450 747895 751833 753815 753853 755961 756620 757200 762999 765442 770980 774090 784600 785019 787955 788595 789228 789885 790966 791000 794769 795911 798585 802632 806277 807965 813660 817364 817621 818994 819605 821178 822178 822718 825137 827978 ] |
||||||||||||||||||||||||||||||
|
17.28 ms (8.77%) |
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 806277 739074 742698 798585 163429 396884 548533 655940 586582 462510 819605 817621 818994 817364 708431 716468 678763 684583 689579 715300 687187 694540 704788 807965 765442 787955 730579 747895 751833 755961 785019 802632 601650 515194 402245 743096 770980 382812 393754 381776 402093 419386 443381 429124 458414 515140 554428 569666 551557 566521 677044 685004 624858 621709 788595 400440 570076 515234 557207 558050 621657 453118 561725 663353 697298 648504 674356 708389 710970 572099 794769 790966 443225 445057 529307 558320 566170 664840 90718 494382 684205 813660 821178 822178 822718 825137 827978 525778 655366 664539 678726 701118 667858 688307 689685 652573 655752 667231 668648 688677 717699 630155 789228 795911 789885 791000 747450 757200 774090 784600 725914 741889 753815 753853 756620 762999 743039 740522 323041 392086 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.53%) |
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 90718 163429 323041 381776 382812 392086 393754 396884 400440 402093 402245 419386 429124 443225 443381 445057 453118 458414 462510 494382 515140 515194 515234 525778 529307 548533 551557 554428 557207 558050 558320 561725 566170 566521 569666 570076 572099 586582 601650 621657 621709 624858 630155 648504 652573 655366 655752 655940 663353 664539 664840 667231 667858 668648 674356 677044 678726 678763 684205 684583 685004 687187 688307 688677 689579 689685 694540 697298 701118 704788 708389 708431 710970 715300 716468 717699 725914 730579 739074 740522 741889 742698 743039 743096 747450 747895 751833 753815 753853 755961 756620 757200 762999 765442 770980 774090 784600 785019 787955 788595 789228 789885 790966 791000 794769 795911 798585 802632 806277 807965 813660 817364 817621 818994 819605 821178 822178 822718 825137 827978 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young vagina"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young вагин"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young вагин"
]
|
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.