Query Metrics
7
Database Queries
7
Different statements
202.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.05 ms (89.21%) |
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 438682 476614 477746 477752 477767 501671 507396 535151 545663 546692 547309 563572 578104 582518 583115 609089 610475 613989 621995 622853 622884 631591 641654 646995 647453 647759 650717 652551 652554 653821 674970 678772 681937 682256 684414 685255 685515 690057 690918 692822 694159 697552 701864 707093 708166 708625 709870 712790 716350 719270 724752 727494 728682 729007 729434 730681 730941 730944 733507 734617 734629 735158 740090 740211 740674 742652 743739 744684 747501 752936 755289 761868 768074 768286 768307 770101 770596 770616 771957 773178 773179 773546 773680 774280 776137 776654 777014 777227 778483 785189 786204 786488 787146 789383 790718 791302 792206 792334 793548 793615 794451 795268 800547 802840 803851 809578 817277 817691 817909 820366 823442 823596 824219 824301 824960 825188 825989 826804 827709 828378 ] |
||||||||||||||||||||||||||||||
|
11.84 ms (5.83%) |
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 740674 776654 785189 792206 828378 681937 684414 582518 716350 546692 773680 773178 747501 827709 824960 535151 789383 793615 795268 791302 768286 768307 777227 787146 545663 647759 647453 685515 692822 613989 817277 825989 817691 820366 501671 719270 790718 792334 793548 800547 740211 770101 734629 786488 712790 477767 578104 694159 708625 709870 646995 650717 653821 678772 631591 610475 803851 707093 802840 622884 609089 774280 817909 477746 438682 690057 825188 730941 761868 697552 682256 786204 794451 742652 773179 730944 727494 752936 768074 735158 770596 477752 826804 730681 690918 621995 824219 701864 708166 776137 777014 770616 773546 809578 729007 729434 734617 740090 771957 733507 744684 778483 563572 824301 547309 652551 652554 507396 823596 755289 476614 685255 674970 622853 823442 583115 641654 724752 728682 743739 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.43%) |
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 438682 476614 477746 477752 477767 501671 507396 535151 545663 546692 547309 563572 578104 582518 583115 609089 610475 613989 621995 622853 622884 631591 641654 646995 647453 647759 650717 652551 652554 653821 674970 678772 681937 682256 684414 685255 685515 690057 690918 692822 694159 697552 701864 707093 708166 708625 709870 712790 716350 719270 724752 727494 728682 729007 729434 730681 730941 730944 733507 734617 734629 735158 740090 740211 740674 742652 743739 744684 747501 752936 755289 761868 768074 768286 768307 770101 770596 770616 771957 773178 773179 773546 773680 774280 776137 776654 777014 777227 778483 785189 786204 786488 787146 789383 790718 791302 792206 792334 793548 793615 794451 795268 800547 802840 803851 809578 817277 817691 817909 820366 823442 823596 824219 824301 824960 825188 825989 826804 827709 828378 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк kissing любительск"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls kissing amateur"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк kissing любительск"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.