Query Metrics
7
Database Queries
7
Different statements
370.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.69 ms (56.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"love tits"
]
|
||||||||||||||||||||||||||||||
|
141.75 ms (38.26%) |
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 21221 386195 386228 389657 413125 420240 428360 429755 452204 458238 499042 519556 521860 526031 539550 540535 543694 555506 565902 586924 593919 595645 598181 600022 607414 628912 630045 633340 633491 635662 635721 640304 644142 655005 656363 670946 678131 681281 689857 691479 696785 705067 714808 723522 726263 727589 730790 731186 732226 732982 733089 736465 740181 745513 746452 750535 755111 756256 757987 759483 760120 762748 765556 765909 765913 768301 770423 771979 771990 772388 772394 773621 778058 778750 781368 781748 781963 788917 791262 791306 791475 792618 792815 792930 793550 793565 793797 794299 794901 795130 795637 801372 803816 804593 804612 806532 806700 806705 811087 811965 811979 812083 813702 813817 814182 816744 816815 817020 817105 817636 818240 819160 822482 825156 825708 825710 826113 826545 827573 827601 ] |
||||||||||||||||||||||||||||||
|
13.65 ms (3.68%) |
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 768301 772388 770423 746452 771979 765913 822482 825708 825156 819160 458238 781748 794901 801372 811087 726263 745513 750535 644142 793797 428360 555506 519556 678131 633491 600022 429755 826545 818240 816744 816815 781963 791306 760120 812083 730790 732226 635662 795130 389657 817105 826113 539550 543694 670946 586924 607414 630045 598181 792930 806532 772394 791262 804593 811979 731186 771990 795637 21221 736465 803816 540535 386228 420240 723522 817020 817636 813702 827601 452204 521860 499042 565902 656363 689857 714808 655005 696785 593919 595645 628912 635721 791475 793550 793565 778750 781368 788917 727589 740181 755111 765556 732982 733089 765909 757987 762748 633340 705067 811965 413125 813817 825710 640304 794299 806700 759483 773621 778058 804612 806705 526031 792618 756256 792815 386195 814182 827573 681281 691479 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (0.71%) |
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 21221 386195 386228 389657 413125 420240 428360 429755 452204 458238 499042 519556 521860 526031 539550 540535 543694 555506 565902 586924 593919 595645 598181 600022 607414 628912 630045 633340 633491 635662 635721 640304 644142 655005 656363 670946 678131 681281 689857 691479 696785 705067 714808 723522 726263 727589 730790 731186 732226 732982 733089 736465 740181 745513 746452 750535 755111 756256 757987 759483 760120 762748 765556 765909 765913 768301 770423 771979 771990 772388 772394 773621 778058 778750 781368 781748 781963 788917 791262 791306 791475 792618 792815 792930 793550 793565 793797 794299 794901 795130 795637 801372 803816 804593 804612 806532 806700 806705 811087 811965 811979 812083 813702 813817 814182 816744 816815 817020 817105 817636 818240 819160 822482 825156 825708 825710 826113 826545 827573 827601 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"love сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"love сиськ"
]
|
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.