Query Metrics
7
Database Queries
7
Different statements
209.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
183.78 ms (87.57%) |
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 166675 400486 418566 421914 422141 422151 422152 423311 424124 426414 439743 440265 440414 440441 440580 440890 440900 440954 442629 443161 443166 443182 451494 454801 460046 461843 463313 464853 465382 466799 468129 470609 471786 472652 474146 474778 478983 481644 484440 488948 490158 493083 503954 509609 513498 516483 520998 523514 526393 530318 531377 534207 539531 554353 560968 565275 577602 583096 583564 603601 604221 605956 610118 625435 631865 635133 656219 669189 670084 670715 685061 694568 699090 714602 716570 716877 718235 719294 720612 724681 727451 727783 728905 729789 730104 730478 730641 735920 737468 738420 746453 751958 756875 757910 759014 768047 769291 771412 775826 779410 790831 791709 794421 794516 794709 795771 798884 800024 801500 802044 813667 814762 814763 815442 815917 815973 816001 816568 816951 817688 ] |
||||||||||||||||||||||||||||||
|
16.13 ms (7.69%) |
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 534207 539531 554353 699090 716877 718235 714602 694568 635133 631865 603601 779410 794516 794709 800024 790831 791709 795771 724681 728905 738420 730478 746453 737468 768047 771412 610118 798884 801500 802044 440414 440580 440890 443182 423311 816568 464853 474146 530318 520998 583096 656219 685061 670084 605956 604221 625435 751958 769291 759014 443161 443166 466799 400486 418566 426414 460046 493083 523514 440954 454801 560968 727783 461843 516483 440900 463313 488948 424124 474778 465382 468129 421914 816951 490158 583564 794421 513498 166675 478983 481644 670715 719294 757910 756875 470609 451494 526393 422151 813667 814762 816001 814763 815973 817688 815917 503954 531377 577602 716570 720612 729789 730641 727451 775826 440265 440441 442629 471786 509609 484440 422152 422141 815442 472652 669189 565275 730104 735920 439743 ] |
||||||||||||||||||||||||||||||
|
4.08 ms (1.94%) |
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 166675 400486 418566 421914 422141 422151 422152 423311 424124 426414 439743 440265 440414 440441 440580 440890 440900 440954 442629 443161 443166 443182 451494 454801 460046 461843 463313 464853 465382 466799 468129 470609 471786 472652 474146 474778 478983 481644 484440 488948 490158 493083 503954 509609 513498 516483 520998 523514 526393 530318 531377 534207 539531 554353 560968 565275 577602 583096 583564 603601 604221 605956 610118 625435 631865 635133 656219 669189 670084 670715 685061 694568 699090 714602 716570 716877 718235 719294 720612 724681 727451 727783 728905 729789 730104 730478 730641 735920 737468 738420 746453 751958 756875 757910 759014 768047 769291 771412 775826 779410 790831 791709 794421 794516 794709 795771 798884 800024 801500 802044 813667 814762 814763 815442 815917 815973 816001 816568 816951 817688 ] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин real"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother real"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин real"
]
|
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.