Query Metrics
7
Database Queries
7
Different statements
135.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
114.33 ms (84.12%) |
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 398003 398656 418334 422817 426628 432670 434877 445713 447624 449238 451166 459596 470384 479745 480275 481130 501672 521676 528294 551602 563678 564887 566537 571313 582079 590415 593217 595938 616816 621498 631426 648471 660692 668692 672878 675084 680611 699166 714587 722124 724441 728121 728958 732432 732793 732837 733220 733450 734344 734740 739645 742337 743492 743968 744144 744825 744834 746304 748990 749289 750319 752744 753223 756318 758245 759040 759775 762805 767186 767469 768626 771426 773546 775653 775656 777128 778684 780158 780294 780297 780326 782769 784357 786880 786883 786920 787691 788564 790901 791725 792228 792258 793221 793246 795009 795257 795374 797264 798257 798775 800044 800598 801612 802319 802368 804413 806111 807963 808263 809503 811710 812271 818977 819014 819331 819838 820011 820014 824145 825202 ] |
||||||||||||||||||||||||||||||
|
12.70 ms (9.35%) |
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 775653 780158 780326 795374 775656 786883 788564 792258 812271 743968 746304 748990 790901 800598 807963 808263 724441 728121 734344 734740 739645 744144 744834 759040 756318 768626 732432 742337 771426 749289 758245 714587 777128 792228 398003 480275 470384 551602 563678 680611 699166 648471 582079 631426 479745 501672 722124 773546 780294 422817 809503 804413 521676 593217 595938 616816 668692 672878 447624 451166 795257 733450 732793 752744 759775 787691 449238 459596 797264 798775 426628 398656 434877 660692 621498 590415 793221 780297 798257 801612 811710 762805 744825 819014 528294 432670 571313 445713 825202 818977 820011 820014 824145 819331 819838 564887 778684 782769 793246 795009 800044 767186 784357 786880 786920 791725 802319 728958 732837 743492 753223 750319 767469 802368 806111 418334 481130 675084 733220 566537 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.63%) |
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 398003 398656 418334 422817 426628 432670 434877 445713 447624 449238 451166 459596 470384 479745 480275 481130 501672 521676 528294 551602 563678 564887 566537 571313 582079 590415 593217 595938 616816 621498 631426 648471 660692 668692 672878 675084 680611 699166 714587 722124 724441 728121 728958 732432 732793 732837 733220 733450 734344 734740 739645 742337 743492 743968 744144 744825 744834 746304 748990 749289 750319 752744 753223 756318 758245 759040 759775 762805 767186 767469 768626 771426 773546 775653 775656 777128 778684 780158 780294 780297 780326 782769 784357 786880 786883 786920 787691 788564 790901 791725 792228 792258 793221 793246 795009 795257 795374 797264 798257 798775 800044 800598 801612 802319 802368 804413 806111 807963 808263 809503 811710 812271 818977 819014 819331 819838 820011 820014 824145 825202 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"лижет у жены дома"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза жен домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.