Query Metrics
7
Database Queries
7
Different statements
207.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.67 ms (85.77%) |
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 6710 327378 393462 409234 412362 413524 416859 418188 430203 439558 439581 443809 450825 451321 469020 470179 471176 471809 473179 474095 474563 474735 483103 483669 486800 490831 490905 491637 497492 507257 519748 524056 524986 528749 530470 533447 535374 554784 563228 565261 565677 567167 569975 570169 573938 576676 576694 577355 581363 599934 615744 630711 634546 643092 643122 644038 645898 647901 649216 662601 666031 702621 721141 724268 724425 726677 730225 730386 732068 733603 734038 734623 735544 740593 743029 744591 751498 757525 761321 766260 766597 770555 771426 772807 774256 780594 781019 794985 796193 797541 802228 802384 804611 805638 805784 805979 809468 809477 810062 813568 813785 814392 815648 815696 816007 817104 817800 817802 817918 818419 818445 818521 818546 818977 820014 820060 820136 821083 826276 ] |
||||||||||||||||||||||||||||||
|
19.12 ms (9.23%) |
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 630711 796193 802228 805979 743029 766260 770555 805784 734623 740593 802384 327378 393462 483669 766597 781019 409234 439581 815696 817918 818419 818445 817104 817802 818977 820014 820136 813785 817800 820060 821083 530470 533447 581363 666031 569975 643092 780594 804611 730225 774256 794985 744591 759378 726677 733603 735544 757525 761321 771426 721141 810062 439558 524986 474095 490905 6710 416859 751498 450825 813568 814392 815648 816007 474735 483103 486800 490831 473179 497492 535374 528749 471809 565261 577355 563228 570169 567167 573938 576676 576694 662601 645898 647901 649216 702621 565677 599934 634546 643122 644038 724268 772807 809477 724425 732068 734038 730386 615744 797541 805638 809468 413524 418188 443809 471176 412362 469020 470179 474563 430203 451321 524056 491637 507257 519748 554784 818521 818546 826276 ] |
||||||||||||||||||||||||||||||
|
3.34 ms (1.61%) |
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 6710 327378 393462 409234 412362 413524 416859 418188 430203 439558 439581 443809 450825 451321 469020 470179 471176 471809 473179 474095 474563 474735 483103 483669 486800 490831 490905 491637 497492 507257 519748 524056 524986 528749 530470 533447 535374 554784 563228 565261 565677 567167 569975 570169 573938 576676 576694 577355 581363 599934 615744 630711 634546 643092 643122 644038 645898 647901 649216 662601 666031 702621 721141 724268 724425 726677 730225 730386 732068 733603 734038 734623 735544 740593 743029 744591 751498 757525 761321 766260 766597 770555 771426 772807 774256 780594 781019 794985 796193 797541 802228 802384 804611 805638 805784 805979 809468 809477 810062 813568 813785 814392 815648 815696 816007 817104 817800 817802 817918 818419 818445 818521 818546 818977 820014 820060 820136 821083 826276 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин лиза"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мамочку лизать"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.77%) |
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.