Query Metrics
7
Database Queries
7
Different statements
172.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.46 ms (85.05%) |
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 33602 156920 309223 317898 338731 404124 532278 533474 533779 535083 536211 537181 537606 537637 540469 542278 557712 566816 568015 571206 572665 574114 578614 579300 581845 585567 589199 589309 591635 591999 592177 592668 595606 596284 596964 597431 597766 601516 602066 602067 602082 602560 603138 605012 605019 605499 611193 615914 616536 617754 626998 627000 627928 630089 630626 630696 631012 631062 631376 632508 633714 633856 633981 633990 634043 643783 643849 643854 643949 645568 646639 647083 647484 647915 648907 650854 651058 651577 652521 652786 653745 653823 653838 654970 655288 656529 658128 661633 684361 686305 690711 692456 694904 696094 699422 699451 701008 708213 709367 710356 712784 718580 719848 722342 729064 732753 734792 737259 740878 743970 750616 803376 819642 823758 824444 826711 826886 827877 ] |
||||||||||||||||||||||||||||||
|
14.76 ms (8.57%) |
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 740878 743970 750616 718580 722342 630626 643849 630696 737259 536211 719848 686305 692456 338731 572665 602082 605499 535083 542278 581845 709367 605019 591999 803376 827877 533474 537181 537606 537637 540469 532278 557712 566816 568015 579300 651577 652786 653745 655288 661633 690711 646639 647083 647484 651058 654970 656529 658128 699422 699451 701008 710356 645568 650854 652521 653838 684361 694904 696094 712784 574114 589199 592177 596284 602067 633981 634043 643949 589309 591635 615914 617754 585567 592668 595606 597431 601516 602066 602560 603138 616536 627928 628493 597766 597860 627000 631062 631376 632508 643783 643854 734792 729064 611193 626998 630089 631012 633714 633990 708213 648907 653823 571206 605012 596964 633856 309223 156920 33602 823758 732753 317898 533779 578614 647915 404124 826711 824444 826886 819642 ] |
||||||||||||||||||||||||||||||
|
4.28 ms (2.49%) |
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 33602 156920 309223 317898 338731 404124 532278 533474 533779 535083 536211 537181 537606 537637 540469 542278 557712 566816 568015 571206 572665 574114 578614 579300 581845 585567 589199 589309 591635 591999 592177 592668 595606 596284 596964 597431 597766 601516 602066 602067 602082 602560 603138 605012 605019 605499 611193 615914 616536 617754 626998 627000 627928 630089 630626 630696 631012 631062 631376 632508 633714 633856 633981 633990 634043 643783 643849 643854 643949 645568 646639 647083 647484 647915 648907 650854 651058 651577 652521 652786 653745 653823 653838 654970 655288 656529 658128 661633 684361 686305 690711 692456 694904 696094 699422 699451 701008 708213 709367 710356 712784 718580 719848 722342 729064 732753 734792 737259 740878 743970 750616 803376 819642 823758 824444 826711 826886 827877 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur wife interracial"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск жен межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.