Query Metrics
7
Database Queries
7
Different statements
204.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.42 ms (89.17%) |
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 388782 396305 397672 417941 423937 442384 449468 453730 455860 460066 462087 476861 477193 482828 483050 493431 496793 500067 507787 507915 508524 509170 513558 514101 516215 516226 516488 521647 523878 527635 527835 529103 530216 531935 540612 540805 543592 552880 555452 558415 563686 563880 564122 566295 574018 574051 577314 590603 595226 595313 609986 610050 612287 618629 620465 624377 626910 636166 639120 640472 641524 641764 648009 649731 671697 675167 679287 689407 697707 704399 707474 710108 713309 713311 715440 721076 726126 738323 753158 755004 759854 766224 768577 768625 768643 770637 773776 778462 782705 784635 788561 788653 791872 794407 797290 802067 803340 811209 819287 823736 823981 824267 824323 824966 825046 825434 825891 826094 826164 826412 826533 828205 828351 828471 828581 828766 828806 ] |
||||||||||||||||||||||||||||||
|
12.60 ms (6.16%) |
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 493431 641764 574018 707474 636166 626910 811209 397672 823736 825046 825891 826094 828205 828581 766224 396305 609986 496793 540805 476861 508524 516215 527635 531935 552880 558415 566295 590603 462087 442384 455860 500067 527835 483050 514101 516488 523878 509170 555452 697707 704399 713309 721076 618629 639120 610050 791872 755004 759854 825203 828806 824267 825932 828580 788653 423937 449468 530216 516226 540612 543592 802067 417941 477193 521647 513558 388782 564122 612287 826412 826164 577314 574051 648009 649731 671697 710108 713311 675167 689407 679287 563686 595313 641524 624377 782705 726126 738323 753158 620465 640472 715440 778462 797290 824966 823981 825434 794407 768625 768643 784635 768577 770637 773776 788561 826533 819287 824323 828766 828351 803340 595226 828471 563880 482828 460066 453730 507915 507787 529103 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (1.71%) |
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 388782 396305 397672 417941 423937 442384 449468 453730 455860 460066 462087 476861 477193 482828 483050 493431 496793 500067 507787 507915 508524 509170 513558 514101 516215 516226 516488 521647 523878 527635 527835 529103 530216 531935 540612 540805 543592 552880 555452 558415 563686 563880 564122 566295 574018 574051 577314 590603 595226 595313 609986 610050 612287 618629 620465 624377 626910 636166 639120 640472 641524 641764 648009 649731 671697 675167 679287 689407 697707 704399 707474 710108 713309 713311 715440 721076 726126 738323 753158 755004 759854 766224 768577 768625 768643 770637 773776 778462 782705 784635 788561 788653 791872 794407 797290 802067 803340 811209 819287 823736 823981 824267 824323 824966 825046 825434 825891 826094 826164 826412 826533 828205 828351 828471 828581 828766 828806 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum amateur"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum любительск"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.31 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum любительск"
]
|
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.