Query Metrics
7
Database Queries
7
Different statements
199.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.43 ms (84.00%) |
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 392225 411150 435697 471636 480503 481143 520516 522440 522920 523950 526232 528709 528714 529366 530268 530624 530625 530627 530630 530790 532906 532960 532967 533051 534201 536281 536372 536689 537187 539403 541839 543017 543843 549358 550602 550887 552917 557530 558348 561929 562827 569147 572505 574696 578661 580180 583112 590959 594861 599826 605807 609905 611190 621596 630638 631171 635574 635988 636271 637431 640805 645858 646175 650486 650949 653383 653594 653596 655614 655644 657363 657888 659526 659548 659619 666874 666876 671143 673045 675167 678099 679003 691617 693024 694123 696451 705238 709486 719887 720241 722691 724482 731037 733400 735928 737424 741017 741037 742127 752992 765880 765883 769237 770329 773679 780488 781998 783295 789889 799801 801965 805139 805275 812987 826099 827040 828164 828468 828838 ] |
||||||||||||||||||||||||||||||
|
21.77 ms (10.92%) |
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 693024 549358 562827 621596 630638 805275 812987 731037 605807 611190 720241 781998 789889 522440 528714 530790 536372 480503 552917 719887 722691 653383 653594 657363 679003 550887 569147 583112 594861 636271 637431 609905 799801 801965 826351 481143 530627 532906 536281 529366 533051 534201 537187 520516 528709 530268 550602 580180 557530 653596 678099 696451 561929 578661 590959 635988 770329 805139 435697 826099 655644 572505 635574 742127 530624 532960 532967 526232 541839 543843 574696 646175 666874 631171 827040 828838 659526 691617 659548 741037 769237 694123 650949 659619 673045 671143 733400 737424 773679 765880 735928 741017 752992 765883 523950 522920 530625 530630 536689 558348 645858 650486 666876 640805 599826 471636 392225 828164 828468 539403 543017 655614 657888 675167 709486 705238 780488 724482 783295 411150 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.37%) |
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 392225 411150 435697 471636 480503 481143 520516 522440 522920 523950 526232 528709 528714 529366 530268 530624 530625 530627 530630 530790 532906 532960 532967 533051 534201 536281 536372 536689 537187 539403 541839 543017 543843 549358 550602 550887 552917 557530 558348 561929 562827 569147 572505 574696 578661 580180 583112 590959 594861 599826 605807 609905 611190 621596 630638 631171 635574 635988 636271 637431 640805 645858 646175 650486 650949 653383 653594 653596 655614 655644 657363 657888 659526 659548 659619 666874 666876 671143 673045 675167 678099 679003 691617 693024 694123 696451 705238 709486 719887 720241 722691 724482 731037 733400 735928 737424 741017 741037 742127 752992 765880 765883 769237 770329 773679 780488 781998 783295 789889 799801 801965 805139 805275 812987 826099 827040 828164 828468 828838 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"милая"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"милая"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sweet and"
]
|
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.