Query Metrics
7
Database Queries
7
Different statements
569.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
330.91 ms (58.13%) |
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 398114 400494 416467 419319 419320 421831 422151 422186 424658 427246 428587 428756 428929 428965 433380 439697 439746 439763 439770 439808 440601 443913 445661 445967 446181 448519 451129 453365 454801 456249 456695 460535 462556 463980 465719 472299 481772 485064 486854 488249 488772 491911 491924 492495 495686 495818 496060 497236 498555 502191 503350 504450 505039 506133 507817 508003 508701 513498 513750 514796 514977 517832 521927 526066 526698 528262 528638 530001 533010 533833 534201 534464 535434 536636 537926 539159 542042 551172 564267 566788 571257 576697 578382 580183 583609 586009 587435 598899 601444 605698 610821 612699 613981 620116 624953 626405 628403 628415 631597 631919 637065 637107 637176 642359 644982 645004 647600 716085 725230 727783 735920 739900 759459 768739 809228 811764 811822 813863 ] |
||||||||||||||||||||||||||||||
|
213.70 ms (37.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал real"
]
|
||||||||||||||||||||||||||||||
|
15.81 ms (2.78%) |
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 735920 759459 739900 809228 443913 416467 504450 419319 485064 537926 534464 551172 564267 571257 605698 642359 628403 624953 433380 422186 439770 530001 398114 498555 497236 576697 583609 662221 598899 601444 445967 446181 439763 462556 521927 813863 637176 811764 725230 768739 419320 644982 481772 445661 535434 533010 534201 536636 566788 542042 637065 620116 626405 612699 428965 460535 400494 421831 424658 428587 448519 439746 508003 528638 488249 488772 502191 514977 491911 514796 528262 506133 631597 456695 508701 513750 523324 526066 586009 440601 427246 422151 645004 454801 539159 533833 495818 578382 647600 580183 637107 727783 716085 428929 505039 517832 811822 472299 492495 587435 613981 453365 456249 463980 465719 526698 496060 631919 451129 439808 439697 507817 513498 491924 503350 428756 628415 610821 495686 486854 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (0.56%) |
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 398114 400494 416467 419319 419320 421831 422151 422186 424658 427246 428587 428756 428929 428965 433380 439697 439746 439763 439770 439808 440601 443913 445661 445967 446181 448519 451129 453365 454801 456249 456695 460535 462556 463980 465719 472299 481772 485064 486854 488249 488772 491911 491924 492495 495686 495818 496060 497236 498555 502191 503350 504450 505039 506133 507817 508003 508701 513498 513750 514796 514977 517832 521927 526066 526698 528262 528638 530001 533010 533833 534201 534464 535434 536636 537926 539159 542042 551172 564267 566788 571257 576697 578382 580183 583609 586009 587435 598899 601444 605698 610821 612699 613981 620116 624953 626405 628403 628415 631597 631919 637065 637107 637176 642359 644982 645004 647600 716085 725230 727783 735920 739900 759459 768739 809228 811764 811822 813863 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal real"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал real"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.