Query Metrics
7
Database Queries
7
Different statements
262.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
240.17 ms (91.36%) |
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 91344 402792 403871 415311 421488 427132 434371 437867 438178 440706 441402 448522 449908 450067 459207 460804 462862 467880 467889 467929 474806 493339 493909 499789 503486 510761 515435 515959 521238 522324 525209 525304 528770 530862 543648 544852 546981 554166 555044 555306 556530 557582 566777 566843 569450 578039 579582 586435 587030 588650 591487 595612 602793 609930 612783 619367 624164 648716 665993 669000 682347 696499 698801 705427 708013 712512 714090 721903 725600 731144 731692 733280 735555 735939 737574 739154 740803 745464 752758 758952 766155 768952 771171 772951 772976 773302 774227 783900 783907 784704 784759 785665 785775 786726 787524 792176 793205 793207 794217 795029 795231 797079 798727 799947 801054 801636 803601 806801 806986 808158 809618 809679 809751 810913 812538 813203 818944 826475 826766 827496 ] |
||||||||||||||||||||||||||||||
|
13.45 ms (5.12%) |
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 808158 813203 752758 705427 809618 586435 591487 467929 557582 794217 799947 449908 493909 682347 698801 803601 402792 522324 528770 648716 566843 462862 427132 521238 708013 665993 669000 595612 739154 795029 733280 798727 818944 827496 826766 721903 783907 725600 731144 731692 758952 787524 737574 772976 745464 735939 740803 772951 773302 450067 467880 525209 546981 555306 735555 771171 440706 474806 588650 437867 448522 503486 510761 499789 544852 555044 556530 619367 624164 801636 602793 434371 441402 421488 460804 578039 467889 809679 587030 459207 566777 783900 784759 785775 806986 806801 768952 793205 793207 809751 810913 812538 766155 784704 785665 797079 415311 786726 792176 795231 774227 569450 579582 554166 714090 801054 712512 609930 696499 515435 515959 438178 91344 403871 826475 525304 530862 493339 543648 612783 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.06%) |
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 91344 402792 403871 415311 421488 427132 434371 437867 438178 440706 441402 448522 449908 450067 459207 460804 462862 467880 467889 467929 474806 493339 493909 499789 503486 510761 515435 515959 521238 522324 525209 525304 528770 530862 543648 544852 546981 554166 555044 555306 556530 557582 566777 566843 569450 578039 579582 586435 587030 588650 591487 595612 602793 609930 612783 619367 624164 648716 665993 669000 682347 696499 698801 705427 708013 712512 714090 721903 725600 731144 731692 733280 735555 735939 737574 739154 740803 745464 752758 758952 766155 768952 771171 772951 772976 773302 774227 783900 783907 784704 784759 785665 785775 786726 787524 792176 793205 793207 794217 795029 795231 797079 798727 799947 801054 801636 803601 806801 806986 808158 809618 809679 809751 810913 812538 813203 818944 826475 826766 827496 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сквирт оргазм домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сквирт оргазм домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"squirt homemade"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.