Query Metrics
7
Database Queries
7
Different statements
446.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
413.66 ms (92.63%) |
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 394406 395622 402235 402718 412716 421565 422356 427308 429001 433322 435355 439854 443716 446112 446902 447147 447809 448706 454938 458051 463950 463968 464584 466369 466599 470082 473139 473909 489484 490202 490741 491640 491644 491702 491944 492163 495467 498641 504793 508660 510503 512257 512298 518013 528020 533760 535622 540891 545517 545804 558020 560191 560441 561675 561703 561826 562373 562491 567664 572763 573788 574522 574916 575069 575122 575123 575137 575162 575472 575751 575802 576043 576082 576112 576399 576414 580298 586491 587133 595383 595489 595520 595874 596659 597043 597607 598042 598440 598450 598465 598490 598683 600078 612799 634962 638985 663785 674220 684566 685425 689949 699487 702166 702621 716030 716032 720790 721381 725126 727416 728241 733879 733884 733886 745457 762252 786771 794791 801274 814266 ] |
||||||||||||||||||||||||||||||
|
20.91 ms (4.68%) |
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 598042 597043 470082 495467 498641 540891 535622 674220 689949 597607 727416 725126 745457 402235 512298 489484 595874 598450 598490 598683 595520 598440 575162 702621 512257 814266 518013 533760 561826 567664 575069 575802 576043 576082 545804 716032 545517 575123 575472 596659 587133 595489 586491 600078 638985 733884 733886 733879 716030 473909 466599 395622 429001 439854 491702 504793 490202 491644 580298 560441 572763 612799 458051 473139 508660 561703 699487 663785 685425 720790 574522 634962 801274 786771 794791 728241 762252 721381 412716 492163 560191 422356 575122 558020 576414 573788 575137 561675 575751 447809 448706 427308 435355 463950 433322 402718 454938 463968 447147 491944 528020 491640 510503 598465 595383 446902 394406 464584 443716 490741 446112 421565 466369 562373 576399 562491 574916 576112 684566 702166 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (0.78%) |
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 394406 395622 402235 402718 412716 421565 422356 427308 429001 433322 435355 439854 443716 446112 446902 447147 447809 448706 454938 458051 463950 463968 464584 466369 466599 470082 473139 473909 489484 490202 490741 491640 491644 491702 491944 492163 495467 498641 504793 508660 510503 512257 512298 518013 528020 533760 535622 540891 545517 545804 558020 560191 560441 561675 561703 561826 562373 562491 567664 572763 573788 574522 574916 575069 575122 575123 575137 575162 575472 575751 575802 576043 576082 576112 576399 576414 580298 586491 587133 595383 595489 595520 595874 596659 597043 597607 598042 598440 598450 598465 598490 598683 600078 612799 634962 638985 663785 674220 684566 685425 689949 699487 702166 702621 716030 716032 720790 721381 725126 727416 728241 733879 733884 733886 745457 762252 786771 794791 801274 814266 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian young teen"
]
|
||||||||||||||||||||||||||||||
|
2.18 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск young teen"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск young teen"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.43%) |
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.