Query Metrics
7
Database Queries
7
Different statements
213.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
188.18 ms (88.15%) |
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 396275 415093 417102 419407 420645 423269 428523 443492 443572 448924 449821 451706 452499 456944 464741 477000 480523 487146 488776 493236 494482 501015 513051 513568 514781 515175 515178 516969 530254 531494 531650 534763 549075 549577 556549 562118 565099 565241 565256 567503 577583 579495 588221 592261 593725 594236 603725 609072 616592 617080 617849 627778 630297 633446 634100 634482 636889 640149 659247 665681 682223 688211 690304 696139 698797 700649 701267 705791 708762 716001 722585 724898 726182 727399 731695 734400 744290 747873 750436 750951 751337 751728 751801 752615 752960 755483 755925 756989 757955 760597 761995 762485 762986 763827 764020 766102 768462 768465 771986 772026 772650 773687 773939 775434 778448 780027 782828 783617 785731 787965 788405 791133 791851 793395 799818 802572 809945 810702 812232 819780 ] |
||||||||||||||||||||||||||||||
|
15.73 ms (7.37%) |
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 456944 688211 780027 768465 773687 773939 787965 802572 812232 762485 771986 726182 763827 617849 698797 775434 788405 633446 417102 480523 513051 443572 579495 513568 549075 682223 556549 617080 793395 734400 593725 727399 634482 716001 659247 627778 778448 724898 772650 428523 419407 630297 515178 493236 690304 701267 708762 636889 588221 782828 752615 757955 464741 396275 443492 451706 501015 665681 423269 448924 477000 487146 515175 819780 531650 530254 700649 696139 592261 640149 616592 756989 760597 783617 785731 791133 747873 772026 751728 764020 752960 567503 452499 534763 791851 750951 751801 766102 761995 731695 755925 768462 762986 750436 562118 603725 449821 488776 415093 565256 494482 549577 722585 609072 634100 751337 809945 420645 565241 516969 565099 577583 514781 531494 705791 594236 744290 755483 799818 810702 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.20%) |
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 396275 415093 417102 419407 420645 423269 428523 443492 443572 448924 449821 451706 452499 456944 464741 477000 480523 487146 488776 493236 494482 501015 513051 513568 514781 515175 515178 516969 530254 531494 531650 534763 549075 549577 556549 562118 565099 565241 565256 567503 577583 579495 588221 592261 593725 594236 603725 609072 616592 617080 617849 627778 630297 633446 634100 634482 636889 640149 659247 665681 682223 688211 690304 696139 698797 700649 701267 705791 708762 716001 722585 724898 726182 727399 731695 734400 744290 747873 750436 750951 751337 751728 751801 752615 752960 755483 755925 756989 757955 760597 761995 762485 762986 763827 764020 766102 768462 768465 771986 772026 772650 773687 773939 775434 778448 780027 782828 783617 785731 787965 788405 791133 791851 793395 799818 802572 809945 810702 812232 819780 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small little girl"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая little девушк"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая little девушк"
]
|
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.