Query Metrics
7
Database Queries
7
Different statements
363.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.67 ms (59.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс постел"
]
|
||||||||||||||||||||||||||||||
|
128.50 ms (35.33%) |
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 358200 389859 391543 403596 410979 416933 420635 453677 486131 487455 490386 497329 497772 497840 500998 502087 506288 508238 509871 512149 517789 523515 526869 527159 527236 530240 533535 533924 535913 536806 537380 540257 544741 545743 546527 546703 547095 547300 547551 549419 549953 552988 553871 553886 556668 556696 557587 557908 558300 558837 558913 560720 561487 562305 562474 562611 562998 563984 567629 567650 568312 569265 574143 575382 576810 579550 579967 588096 589307 591927 594767 596561 598017 600649 603315 603517 604416 607412 608344 609474 610381 612111 612152 612293 612303 612635 614909 615265 615673 616680 619017 621250 621370 621726 624570 630145 630925 632155 632467 637560 638160 640334 640363 644037 644203 651767 653661 653890 657737 658863 660022 667912 670732 671702 674637 678814 688255 689404 691155 765098 ] |
||||||||||||||||||||||||||||||
|
11.37 ms (3.13%) |
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 607412 612293 615673 533924 453677 523515 497772 497840 527236 537380 526869 535913 579967 563984 576810 544741 553886 558837 561487 562474 562998 575382 653661 670732 678814 667912 671702 546703 547095 558913 569265 591927 600649 603517 609474 621370 640363 619017 594767 596561 630145 632467 765098 612152 644037 621726 653890 621250 558300 637560 547300 358200 562305 674637 689404 660022 589307 632155 416933 540257 557908 556696 567629 579550 658863 651767 549419 598017 603315 640334 604416 608344 630925 614909 638160 420635 403596 487455 517789 533535 552988 553871 562611 657737 688255 691155 567650 612111 612635 615265 616680 610381 612303 588096 624570 644203 389859 391543 410979 486131 497329 530240 502087 506288 508238 509871 527159 536806 500998 512149 490386 546527 574143 545743 547551 568312 549953 556668 557587 560720 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (0.90%) |
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 358200 389859 391543 403596 410979 416933 420635 453677 486131 487455 490386 497329 497772 497840 500998 502087 506288 508238 509871 512149 517789 523515 526869 527159 527236 530240 533535 533924 535913 536806 537380 540257 544741 545743 546527 546703 547095 547300 547551 549419 549953 552988 553871 553886 556668 556696 557587 557908 558300 558837 558913 560720 561487 562305 562474 562611 562998 563984 567629 567650 568312 569265 574143 575382 576810 579550 579967 588096 589307 591927 594767 596561 598017 600649 603315 603517 604416 607412 608344 609474 610381 612111 612152 612293 612303 612635 614909 615265 615673 616680 619017 621250 621370 621726 624570 630145 630925 632155 632467 637560 638160 640334 640363 644037 644203 651767 653661 653890 657737 658863 660022 667912 670732 671702 674637 678814 688255 689404 691155 765098 ] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс постел"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex in bed"
]
|
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.