Query Metrics
7
Database Queries
7
Different statements
208.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.84 ms (89.66%) |
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 366011 383377 384814 386068 387115 389806 393458 395320 395449 395699 395809 399630 400417 400969 411663 414156 417639 426014 428457 428466 429824 432405 435315 442464 444644 445458 450765 452222 453778 453851 455177 457507 460746 467682 467686 469680 474389 474458 475027 478749 478764 488929 492049 493217 495191 506219 507341 508946 512343 514116 514769 514779 521050 523614 525177 527789 530357 532077 539171 540609 543811 547259 549892 549905 549920 549988 554579 560519 565743 566805 571245 572489 572638 572899 573472 574618 575696 586921 589426 608346 612110 615304 634133 668454 676599 680665 684282 685378 692180 701805 703173 703883 705799 713481 728164 732630 739939 748805 757499 759558 762050 771741 785054 795078 816808 818148 818285 818311 820140 823979 824976 825057 825535 825662 826810 826922 827124 827568 828720 828830 ] |
||||||||||||||||||||||||||||||
|
12.03 ms (5.77%) |
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 680665 705799 387115 417639 386068 453851 474389 474458 475027 428466 508946 523614 492049 521050 818311 825535 540609 543811 676599 692180 589426 384814 488929 572899 554579 571245 565743 820140 818148 826810 826922 825057 828830 525177 549905 549920 547259 668454 701805 703883 549892 586921 785054 739939 728164 732630 612110 383377 395809 400417 399630 428457 435315 442464 444644 429824 411663 414156 455177 445458 453778 450765 452222 478764 514116 512343 467682 467686 478749 560519 572489 575696 685378 573472 574618 615304 389806 393458 426014 395320 432405 469680 366011 400969 457507 460746 493217 514769 495191 506219 507341 514779 816808 823979 824976 818285 827124 827568 825662 828720 530357 527789 532077 539171 572638 549988 566805 713481 684282 634133 608346 795078 762050 748805 757499 759558 771741 703173 395449 395699 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.32%) |
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 366011 383377 384814 386068 387115 389806 393458 395320 395449 395699 395809 399630 400417 400969 411663 414156 417639 426014 428457 428466 429824 432405 435315 442464 444644 445458 450765 452222 453778 453851 455177 457507 460746 467682 467686 469680 474389 474458 475027 478749 478764 488929 492049 493217 495191 506219 507341 508946 512343 514116 514769 514779 521050 523614 525177 527789 530357 532077 539171 540609 543811 547259 549892 549905 549920 549988 554579 560519 565743 566805 571245 572489 572638 572899 573472 574618 575696 586921 589426 608346 612110 615304 634133 668454 676599 680665 684282 685378 692180 701805 703173 703883 705799 713481 728164 732630 739939 748805 757499 759558 762050 771741 785054 795078 816808 818148 818285 818311 820140 823979 824976 825057 825535 825662 826810 826922 827124 827568 828720 828830 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"xxx sleep"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"xxx спящ"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"xxx спящ"
]
|
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.