Query Metrics
7
Database Queries
7
Different statements
155.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.30 ms (86.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 416883 422207 442444 443130 445201 461366 465276 467682 469486 469523 484363 507805 508946 512343 517114 517375 522062 545645 546906 551072 563083 565648 569655 574328 574425 610058 623390 623392 623396 626281 628160 668457 670749 675359 682261 682276 682351 682368 683126 687506 688307 696314 696990 705880 708259 708582 709346 710555 710586 712619 712622 712689 714919 714966 715997 716010 719280 721580 724123 726555 728808 729650 742665 742812 742956 743809 744165 744462 753656 754482 755611 756614 759105 775764 777755 778801 779551 779804 779906 780409 782522 784920 785107 786569 787149 788605 788883 791365 793467 793626 793915 795631 796148 796211 800816 800934 802010 802250 803339 805704 805705 805819 807732 809740 812785 813552 813922 814063 814077 816605 817737 818053 819916 819919 820214 820736 824125 824250 826194 827705 ] |
||||||||||||||||||||||||||||||
|
11.91 ms (7.69%) |
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 820214 775764 782522 793626 754482 824125 696314 814063 712622 670749 755611 742665 416883 819916 759105 714966 802010 461366 818053 675359 816605 668457 726555 814077 820736 826194 563083 565648 708259 682276 719280 709346 508946 467682 817737 507805 795631 777755 805705 712619 787149 742812 682368 512343 819919 827705 710555 779906 793467 753656 724123 610058 696990 780409 788883 422207 517375 517114 551072 442444 569655 712689 803339 682351 778801 779804 779551 805704 784920 705880 785107 744165 802250 809740 729650 800816 443130 805819 813552 688307 714919 788605 812785 546906 574425 574328 791365 742956 824250 813922 683126 687506 716010 807732 623390 484363 445201 710586 626281 786569 744462 796211 800934 682261 793915 623396 469523 522062 465276 708582 721580 628160 796148 756614 545645 469486 715997 623392 743809 728808 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.41%) |
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 416883 422207 442444 443130 445201 461366 465276 467682 469486 469523 484363 507805 508946 512343 517114 517375 522062 545645 546906 551072 563083 565648 569655 574328 574425 610058 623390 623392 623396 626281 628160 668457 670749 675359 682261 682276 682351 682368 683126 687506 688307 696314 696990 705880 708259 708582 709346 710555 710586 712619 712622 712689 714919 714966 715997 716010 719280 721580 724123 726555 728808 729650 742665 742812 742956 743809 744165 744462 753656 754482 755611 756614 759105 775764 777755 778801 779551 779804 779906 780409 782522 784920 785107 786569 787149 788605 788883 791365 793467 793626 793915 795631 796148 796211 800816 800934 802010 802250 803339 805704 805705 805819 807732 809740 812785 813552 813922 814063 814077 816605 817737 818053 819916 819919 820214 820736 824125 824250 826194 827705 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stepmom sleeping sex"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stepmom спящ секс"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stepmom спящ секс"
]
|
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.