Query Metrics
7
Database Queries
7
Different statements
152.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.93 ms (85.09%) |
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 391947 406949 427163 444639 456831 489699 514346 534461 537401 572713 578839 588284 588708 607253 612488 614821 616771 619360 627927 634737 636261 638145 652665 658553 662074 667082 667257 670003 671472 680611 696096 701200 701939 709155 709323 715530 716597 716929 719787 726373 727884 729269 734238 734350 734356 735797 739915 744486 746616 747169 747946 748767 749138 754122 757280 757285 758405 760696 761681 763122 763334 765029 765197 765770 766493 766518 771849 772251 772836 775496 775518 777199 777212 777612 777935 778054 778939 779004 779429 779949 781555 782326 782799 785085 785984 786030 787585 788840 789165 790159 790838 791017 791995 792197 792252 792398 794470 794990 795618 795765 797745 799747 800534 802859 803435 803443 808256 809235 809964 814207 814283 816800 818826 819850 824410 826308 826483 826594 826692 827578 ] |
||||||||||||||||||||||||||||||
|
12.22 ms (8.01%) |
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 799747 791017 757285 795618 761681 794470 809964 391947 818826 775496 534461 489699 696096 779004 744486 701939 794990 719787 716597 588708 787585 760696 726373 772251 748767 778939 406949 667082 667257 709155 578839 734356 634737 739915 788840 803443 727884 749138 729269 777199 777612 444639 826483 826692 826308 777212 791995 792398 734238 765029 765197 779949 790159 427163 816800 827578 819850 537401 715530 716929 785984 777935 786030 800534 803435 766493 766518 772836 782326 797745 735797 758405 747946 775518 779429 781555 785085 792252 809235 456831 572713 680611 671472 614821 616771 619360 636261 607253 627927 612488 701200 709323 514346 790838 670003 652665 658553 662074 638145 802859 814207 814283 789165 771849 763122 763334 765770 792197 826594 824410 588284 778054 782799 795765 808256 754122 757280 747169 734350 746616 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (2.04%) |
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 391947 406949 427163 444639 456831 489699 514346 534461 537401 572713 578839 588284 588708 607253 612488 614821 616771 619360 627927 634737 636261 638145 652665 658553 662074 667082 667257 670003 671472 680611 696096 701200 701939 709155 709323 715530 716597 716929 719787 726373 727884 729269 734238 734350 734356 735797 739915 744486 746616 747169 747946 748767 749138 754122 757280 757285 758405 760696 761681 763122 763334 765029 765197 765770 766493 766518 771849 772251 772836 775496 775518 777199 777212 777612 777935 778054 778939 779004 779429 779949 781555 782326 782799 785085 785984 786030 787585 788840 789165 790159 790838 791017 791995 792197 792252 792398 794470 794990 795618 795765 797745 799747 800534 802859 803435 803443 808256 809235 809964 814207 814283 816800 818826 819850 824410 826308 826483 826594 826692 827578 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur face fuck"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск face секс"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск face секс"
]
|
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.