Query Metrics
7
Database Queries
7
Different statements
181.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.42 ms (87.85%) |
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 415736 453470 535893 535996 553327 555295 555353 586209 592908 595066 608628 609765 632284 648697 662536 666685 666707 686373 697222 697731 700897 704622 716710 717997 718450 718844 719859 722992 723138 724579 725313 725388 728105 728122 729434 729758 731572 733372 736278 743575 743608 746073 746553 747202 754368 755044 755046 755395 758412 760340 761657 762469 763030 763374 767411 767535 767903 769656 769913 771802 772895 776179 777701 777803 777946 777962 778073 778305 778617 779337 779827 780171 780213 780479 783427 786621 786821 787540 787924 788665 794057 795293 798381 801983 808843 810325 813600 814325 817987 819263 819327 819746 819797 819934 821791 824001 824045 824260 824337 825246 825321 825363 825364 825399 825609 825624 826196 826583 826584 826641 826907 826995 827118 827141 828234 828317 828342 828431 ] |
||||||||||||||||||||||||||||||
|
11.32 ms (6.24%) |
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 795293 821791 825624 826641 824001 819934 824260 826907 819797 817987 718450 719859 718844 723138 586209 777701 777946 787924 788665 798381 777803 778044 725388 733372 760340 763030 767411 769913 786621 808843 810325 728105 728122 731572 758412 761657 729434 736278 743608 747202 755044 769656 772895 729758 755395 767535 771802 743575 746553 763374 716710 717997 722992 778073 786821 787733 535996 780213 780171 553327 555295 648697 666685 666707 697731 686373 697222 700897 608628 595066 592908 776179 801983 783427 794057 755046 754368 632284 777962 778305 787540 780479 824045 827118 828431 609765 767903 779827 828342 725313 724579 762469 746073 779337 415736 453470 704622 778617 662536 535893 819327 825364 825399 813600 826196 826584 826583 824337 826995 827141 819263 819746 825321 825363 825609 814325 825246 828234 828317 555353 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.39%) |
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 415736 453470 535893 535996 553327 555295 555353 586209 592908 595066 608628 609765 632284 648697 662536 666685 666707 686373 697222 697731 700897 704622 716710 717997 718450 718844 719859 722992 723138 724579 725313 725388 728105 728122 729434 729758 731572 733372 736278 743575 743608 746073 746553 747202 754368 755044 755046 755395 758412 760340 761657 762469 763030 763374 767411 767535 767903 769656 769913 771802 772895 776179 777701 777803 777946 777962 778073 778305 778617 779337 779827 780171 780213 780479 783427 786621 786821 787540 787924 788665 794057 795293 798381 801983 808843 810325 813600 814325 817987 819263 819327 819746 819797 819934 821791 824001 824045 824260 824337 825246 825321 825363 825364 825399 825609 825624 826196 826583 826584 826641 826907 826995 827118 827141 828234 828317 828342 828431 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"реальная дрочка члена…"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск дрочк член"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.09%) |
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.