Query Metrics
7
Database Queries
7
Different statements
158.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.25 ms (82.26%) |
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 188062 383987 384998 385296 395552 395687 395727 396742 397306 401127 401842 404939 405012 405028 405093 405176 405222 408601 409995 411717 411747 412262 417897 420762 423657 424470 425332 430072 435624 442494 443726 443806 445896 445971 448215 449060 449933 454065 463073 464703 467614 468039 468637 470643 471881 474635 476257 477549 483581 484402 484739 484767 484821 486589 488805 491859 495014 495905 501931 505012 505625 512181 512215 515165 518493 518547 518588 519038 521805 522592 525133 525701 527888 530500 538190 538360 541605 543376 549500 550764 550781 551991 557526 559918 568480 570394 572027 572550 576634 583503 586673 592403 592530 592533 593541 595798 599844 603628 605617 606778 611571 616025 616336 642378 649186 650459 667898 670959 681833 688045 691200 692237 720245 720885 731877 742849 792554 810013 814850 815490 ] |
||||||||||||||||||||||||||||||
|
17.57 ms (11.09%) |
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 417897 538190 605617 518493 384998 397306 411717 435624 814850 530500 512215 572550 650459 692237 720245 691200 592533 731877 420762 464703 395727 474635 401842 405093 409995 488805 188062 401127 411747 468637 476257 515165 570394 603628 792554 742849 443806 424470 443726 483581 815490 445896 463073 512181 495905 518547 550764 550781 559918 522592 484767 667898 720885 593541 810013 616336 616025 486589 405176 470643 467614 445971 572027 557526 505012 519038 642378 525701 606778 495014 543376 568480 408601 425332 449933 468039 449060 549500 405222 538360 599844 404939 471881 491859 521805 484821 541605 670959 551991 576634 586673 396742 405028 430072 423657 448215 477549 518588 681833 592530 395552 395687 405012 527888 501931 484402 385296 383987 412262 442494 454065 484739 505625 525133 583503 688045 649186 611571 592403 595798 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.96%) |
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 188062 383987 384998 385296 395552 395687 395727 396742 397306 401127 401842 404939 405012 405028 405093 405176 405222 408601 409995 411717 411747 412262 417897 420762 423657 424470 425332 430072 435624 442494 443726 443806 445896 445971 448215 449060 449933 454065 463073 464703 467614 468039 468637 470643 471881 474635 476257 477549 483581 484402 484739 484767 484821 486589 488805 491859 495014 495905 501931 505012 505625 512181 512215 515165 518493 518547 518588 519038 521805 522592 525133 525701 527888 530500 538190 538360 541605 543376 549500 550764 550781 551991 557526 559918 568480 570394 572027 572550 576634 583503 586673 592403 592530 592533 593541 595798 599844 603628 605617 606778 611571 616025 616336 642378 649186 650459 667898 670959 681833 688045 691200 692237 720245 720885 731877 742849 792554 810013 814850 815490 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"волосатая мжм"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.00%) |
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.