Query Metrics
7
Database Queries
7
Different statements
141.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.55 ms (85.77%) |
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 12904 20031 105005 233618 238244 270932 371547 382445 385884 391269 402674 403755 411119 418793 421444 425392 425757 454760 460661 462334 466704 467245 472749 494412 502720 508694 512793 513251 515586 515734 517360 522815 524993 530607 531033 531631 543723 544953 551334 553876 570144 570454 570674 571899 571908 572497 575692 577381 582136 593111 600199 604035 605113 611382 619178 626883 634457 641053 646253 650232 651075 651332 655470 656202 656279 660714 662571 663457 667058 670407 676983 679083 681963 691451 692404 704626 708543 709046 713024 714324 716125 716360 717755 737397 742216 744130 744566 745543 749980 755565 755595 760684 760961 770931 772799 773151 777835 778158 782787 788012 790242 797853 803018 803245 807925 810738 812441 813054 813895 814131 817740 817839 819155 821238 821602 821673 821988 822103 ] |
||||||||||||||||||||||||||||||
|
11.09 ms (7.82%) |
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 656279 692404 655470 660714 704626 708543 611382 626883 641053 604035 600199 605113 619178 634457 777835 788012 790242 803245 778158 797853 812441 755595 782787 807925 742216 745543 755565 770931 773151 744130 744566 749980 760684 760961 772799 716360 776051 803018 810738 12904 233618 238244 270932 105005 418793 570144 570674 577381 737397 20031 371547 460661 425757 502720 515586 403755 472749 508694 512793 544953 570454 571908 714324 551334 571899 572497 593111 813054 391269 466704 421444 462334 467245 454760 411119 513251 515734 494412 522815 385884 382445 402674 425392 814131 821673 822103 821602 817839 821238 813895 817740 819155 821988 531033 524993 531631 517360 530607 552786 575692 553876 582136 543723 646253 650232 651075 651332 656202 663457 670407 676983 709046 716125 667058 679083 681963 691451 717755 662571 713024 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.80%) |
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 12904 20031 105005 233618 238244 270932 371547 382445 385884 391269 402674 403755 411119 418793 421444 425392 425757 454760 460661 462334 466704 467245 472749 494412 502720 508694 512793 513251 515586 515734 517360 522815 524993 530607 531033 531631 543723 544953 551334 553876 570144 570454 570674 571899 571908 572497 575692 577381 582136 593111 600199 604035 605113 611382 619178 626883 634457 641053 646253 650232 651075 651332 655470 656202 656279 660714 662571 663457 667058 670407 676983 679083 681963 691451 692404 704626 708543 709046 713024 714324 716125 716360 717755 737397 742216 744130 744566 745543 749980 755565 755595 760684 760961 770931 772799 773151 777835 778158 782787 788012 790242 797853 803018 803245 807925 810738 812441 813054 813895 814131 817740 817839 819155 821238 821602 821673 821988 822103 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful sexy"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая sexy"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая sexy"
]
|
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.