Query Metrics
7
Database Queries
7
Different statements
137.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.47 ms (84.89%) |
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 3786 91829 358193 382816 392043 393423 394064 395349 398930 405974 428087 458948 459451 494681 497841 514196 534719 535152 538114 565895 568184 575000 575680 585785 588119 590060 590176 590584 592680 593887 596335 596965 597218 601455 612535 615256 619563 620568 627279 633903 634007 635019 635404 636430 636585 642143 645509 648952 649276 650696 650746 651917 652109 652338 653174 665601 665954 691207 691676 706816 708664 710123 710278 711102 711278 713830 717927 719823 726283 726578 737240 738887 738957 740632 747068 755726 759752 762609 764384 764856 765279 765997 767465 767861 768445 769289 770455 774218 775442 778184 778287 778513 778597 778667 779233 779577 780257 780401 780882 782383 782390 783530 783658 785740 789082 789355 789411 789911 790250 790772 790936 797188 797344 797889 802893 827222 ] |
||||||||||||||||||||||||||||||
|
11.09 ms (8.08%) |
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 565895 575000 645509 652338 665954 706816 710278 713830 648952 652109 653174 691207 650696 665601 710123 717927 575680 596335 597218 620568 590060 592680 634007 636585 590584 612535 635019 593887 596965 619563 627279 790772 797344 767421 789411 797889 755726 615256 635404 708664 711278 780257 789355 585785 738887 642143 797188 769527 3786 405974 428087 827222 538114 494681 534719 651917 711102 650746 719823 633903 636430 783658 790936 775442 782383 782390 765279 789082 802893 769289 740632 747068 762609 764896 768445 759752 764384 764856 765782 767465 770455 778287 778667 779233 780882 785740 458948 778184 588119 497841 91829 393423 394064 395349 459451 780401 726283 765997 783530 789911 790250 774218 778513 778597 382816 392043 649276 726578 737240 358193 514196 779577 568184 398930 738957 535152 601455 691676 590176 767861 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.87%) |
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 3786 91829 358193 382816 392043 393423 394064 395349 398930 405974 428087 458948 459451 494681 497841 514196 534719 535152 538114 565895 568184 575000 575680 585785 588119 590060 590176 590584 592680 593887 596335 596965 597218 601455 612535 615256 619563 620568 627279 633903 634007 635019 635404 636430 636585 642143 645509 648952 649276 650696 650746 651917 652109 652338 653174 665601 665954 691207 691676 706816 708664 710123 710278 711102 711278 713830 717927 719823 726283 726578 737240 738887 738957 740632 747068 755726 759752 762609 764384 764856 765279 765997 767465 767861 768445 769289 770455 774218 775442 778184 778287 778513 778597 778667 779233 779577 780257 780401 780882 782383 782390 783530 783658 785740 789082 789355 789411 789911 790250 790772 790936 797188 797344 797889 802893 827222 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"изменяет мужу частное…"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен жен любительск"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (1.06%) |
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.