Query Metrics
7
Database Queries
7
Different statements
187.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.05 ms (85.00%) |
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 362958 420083 443752 443780 451562 451572 454115 454251 454277 460726 462310 466077 470568 470657 470935 473241 473986 474013 474016 474494 474627 474634 474678 474686 474942 476015 476619 479126 484051 484656 484668 484721 484853 486434 486435 488734 491373 491395 495744 497547 497554 497584 500901 504137 504139 504191 506048 506050 506782 506794 509851 510748 511736 511762 511766 512274 512313 512830 520903 521966 522791 522792 523301 526597 529434 535593 535620 535631 540908 540914 540932 545377 546682 546761 548698 548732 548733 549763 551937 556051 557976 557983 558126 559060 560432 560598 560602 560603 560624 562253 562266 562360 562372 568193 573776 574504 574833 574884 575800 576116 576346 576358 576364 576403 578373 580263 584813 598939 599197 631962 660882 675799 714449 738440 742205 755176 775960 775967 803843 827965 ] |
||||||||||||||||||||||||||||||
|
16.16 ms (8.63%) |
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 548732 562253 576116 562372 598939 454115 454277 535593 549763 576403 576358 575800 574504 584813 473986 491395 512830 497554 497584 479126 470568 560598 548698 560624 470935 473241 520903 484853 511736 522791 512274 497547 511762 560432 578373 560602 631962 775960 775967 451562 443752 509851 510748 522792 491373 529434 573776 474942 460726 476619 521966 486435 504191 506782 559060 484721 474627 486434 504137 576364 580263 548733 738440 546682 574884 599197 420083 523301 827965 551937 560603 568193 714449 474634 454251 540914 557976 562266 474013 511766 500901 540932 546761 443780 545377 557983 755176 495744 504139 506794 512313 474494 484668 506050 474678 506048 362958 742205 556051 660882 675799 540908 451572 574833 470657 526597 484051 558126 535631 474686 488734 462310 576346 466077 484656 562360 535620 474016 476015 803843 ] |
||||||||||||||||||||||||||||||
|
4.42 ms (2.36%) |
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 362958 420083 443752 443780 451562 451572 454115 454251 454277 460726 462310 466077 470568 470657 470935 473241 473986 474013 474016 474494 474627 474634 474678 474686 474942 476015 476619 479126 484051 484656 484668 484721 484853 486434 486435 488734 491373 491395 495744 497547 497554 497584 500901 504137 504139 504191 506048 506050 506782 506794 509851 510748 511736 511762 511766 512274 512313 512830 520903 521966 522791 522792 523301 526597 529434 535593 535620 535631 540908 540914 540932 545377 546682 546761 548698 548732 548733 549763 551937 556051 557976 557983 558126 559060 560432 560598 560602 560603 560624 562253 562266 562360 562372 568193 573776 574504 574833 574884 575800 576116 576346 576358 576364 576403 578373 580263 584813 598939 599197 631962 660882 675799 714449 738440 742205 755176 775960 775967 803843 827965 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ÐÇÐâÐüÐüð║ð░ÐÅ ð│ÐÇÐâð┐ð┐ð¥ð▓ÐâÐàð░ Ðü ðÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск группов секс"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.85%) |
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.