Query Metrics
7
Database Queries
7
Different statements
155.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.71 ms (80.08%) |
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 390653 392605 394120 398909 400166 400948 401223 401799 404429 413908 414946 420584 428124 428472 428895 430835 432837 442204 444171 445424 446022 446706 455281 457440 464661 465649 465791 468843 476559 482629 486252 486533 486539 488073 492331 492333 494797 502306 510074 510466 513113 513728 514042 514297 514589 516791 516966 518927 519929 520683 520696 521176 524291 524323 524862 524866 527249 529170 532125 533965 537550 537558 537815 540549 543774 548848 556651 556654 556655 559008 563443 565626 569555 569768 571494 571508 573758 579371 580300 585724 596573 602194 602959 625649 628653 634430 644254 664660 681293 682181 694508 696329 699536 712564 713065 716927 732160 736770 751498 761370 769490 784304 799941 805945 815756 816008 816993 817094 817130 819220 820335 825965 826663 828397 828439 828526 828533 828536 ] |
||||||||||||||||||||||||||||||
|
20.87 ms (13.40%) |
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 519929 513728 486252 527249 514297 518927 824187 394120 694508 400948 826663 537815 543774 556651 716927 713065 571494 602194 628653 799941 805945 736770 404429 446022 398909 401223 413908 432837 428472 445424 414946 516966 529170 817094 828536 634430 464661 492331 428124 442204 455281 502306 565626 579371 559008 573758 682181 563443 571508 585724 596573 602959 784304 420584 465791 430835 457440 390653 820335 524291 556654 664660 712564 681293 569555 625649 769490 751498 392605 761370 732160 400166 482629 524866 556655 446706 533965 494797 513113 521176 492333 816008 819220 828397 828533 828526 537550 532125 696329 644254 524323 537558 488073 510466 520683 540549 524862 510074 548848 580300 699536 401799 428895 444171 476559 465649 468843 514042 486533 520696 486539 514589 516791 824189 569768 815756 825965 828439 817130 816993 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.77%) |
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 390653 392605 394120 398909 400166 400948 401223 401799 404429 413908 414946 420584 428124 428472 428895 430835 432837 442204 444171 445424 446022 446706 455281 457440 464661 465649 465791 468843 476559 482629 486252 486533 486539 488073 492331 492333 494797 502306 510074 510466 513113 513728 514042 514297 514589 516791 516966 518927 519929 520683 520696 521176 524291 524323 524862 524866 527249 529170 532125 533965 537550 537558 537815 540549 543774 548848 556651 556654 556655 559008 563443 565626 569555 569768 571494 571508 573758 579371 580300 585724 596573 602194 602959 625649 628653 634430 644254 664660 681293 682181 694508 696329 699536 712564 713065 716927 732160 736770 751498 761370 769490 784304 799941 805945 815756 816008 816993 817094 817130 819220 820335 825965 826663 828397 828439 828526 828533 828536 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big as mom"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие mom"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие mom"
]
|
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.