Query Metrics
7
Database Queries
7
Different statements
199.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.09 ms (87.16%) |
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 397918 428734 452320 454319 457205 458281 460063 464868 465254 482437 485611 485649 497203 511199 517337 518595 518952 519610 521505 523121 526385 527284 534183 536392 538753 539670 544452 545014 546089 557051 557096 560680 563667 563721 567143 571308 577537 578521 578566 579617 584155 587523 591965 601955 603021 604097 604993 606115 612909 613813 614695 615079 618363 621718 623390 625608 627570 637765 640149 648984 655857 658869 663152 664214 664616 667057 672281 674294 677511 679660 704314 713833 715404 718849 720025 727502 729562 733116 736621 739595 742022 749555 749871 756639 757866 760332 764125 764378 765394 765717 766171 769263 770778 773105 773680 775348 778790 780743 780749 783108 784088 785035 786121 791052 792571 793792 794907 795864 796110 796380 799348 799720 800784 801074 805108 809782 810017 812812 817142 825941 ] |
||||||||||||||||||||||||||||||
|
15.64 ms (7.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 655857 667057 591965 793792 733116 791052 397918 428734 817142 544452 578566 809782 464868 465254 457205 538753 679660 648984 658869 713833 577537 613813 603021 775348 780743 783108 796380 778790 780749 786121 805108 812812 760332 794907 736621 770778 764378 765717 764125 601955 715404 801074 810017 518595 526385 519610 497203 521505 523121 567143 458281 485611 563667 720025 664616 545014 785035 757866 766171 749555 756639 452320 454319 672281 518952 560680 739595 773105 773680 799720 825941 482437 511199 534183 539670 536392 557051 563721 546089 584155 664214 677511 663152 674294 587523 615079 621718 640149 604993 637765 606115 612909 618363 625608 627570 795864 799348 800784 729562 727502 742022 765394 769263 749871 614695 623390 796110 527284 792571 578521 557096 718849 784088 704314 485649 604097 571308 517337 460063 579617 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.40%) |
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 397918 428734 452320 454319 457205 458281 460063 464868 465254 482437 485611 485649 497203 511199 517337 518595 518952 519610 521505 523121 526385 527284 534183 536392 538753 539670 544452 545014 546089 557051 557096 560680 563667 563721 567143 571308 577537 578521 578566 579617 584155 587523 591965 601955 603021 604097 604993 606115 612909 613813 614695 615079 618363 621718 623390 625608 627570 637765 640149 648984 655857 658869 663152 664214 664616 667057 672281 674294 677511 679660 704314 713833 715404 718849 720025 727502 729562 733116 736621 739595 742022 749555 749871 756639 757866 760332 764125 764378 765394 765717 766171 769263 770778 773105 773680 775348 778790 780743 780749 783108 784088 785035 786121 791052 792571 793792 794907 795864 796110 796380 799348 799720 800784 801074 805108 809782 810017 812812 817142 825941 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"my best жен"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"my best wife"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"my best жен"
]
|
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.