Query Metrics
7
Database Queries
7
Different statements
209.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.87 ms (88.69%) |
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 14320 96463 387648 397903 420240 421889 428858 430908 436138 446724 455530 460127 460130 465406 465954 466021 476220 478039 478949 489181 490742 497969 500912 528087 531426 532090 537593 537645 538165 546666 555318 561588 563056 563229 565902 569736 570753 578166 580872 600798 601341 605015 606842 609361 615277 615355 624989 627196 629472 635662 653347 655840 667979 669895 680611 681276 681614 681636 690842 697465 713126 714808 717048 717062 726515 728887 731753 732226 734268 734620 737863 738207 745320 745852 747144 748709 750797 754401 755111 762748 763373 764290 764448 765909 766388 767518 767987 768092 770069 771442 773621 782401 784357 784388 786353 788076 793565 793797 794178 794408 794713 794715 795130 796074 796710 797215 797903 800015 801372 801935 803821 806705 807887 810774 810899 812083 813647 819468 824442 825348 ] |
||||||||||||||||||||||||||||||
|
13.47 ms (6.43%) |
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 478949 430908 436138 446724 489181 490742 497969 478039 810774 421889 465406 14320 387648 420240 825348 538165 563229 565902 578166 714808 653347 615355 624989 793565 794715 797215 801372 801935 728887 755111 764290 767987 782401 784357 796710 797903 807887 734268 745852 766388 738207 754401 764448 765909 770069 762748 767518 768092 629472 717048 793797 796074 96463 824442 563056 428858 460127 460130 397903 570753 465954 466021 681636 606842 601341 726515 737863 476220 555318 561588 681276 681614 605015 600798 810899 747144 455530 500912 528087 813647 537645 532090 537593 546666 569736 655840 680611 713126 697465 667979 669895 690842 615277 609361 627196 794178 794408 794713 784388 786353 788076 800015 812083 734620 745320 763373 771442 732226 748709 750797 731753 773621 635662 717062 795130 803821 806705 819468 531426 580872 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.28%) |
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 14320 96463 387648 397903 420240 421889 428858 430908 436138 446724 455530 460127 460130 465406 465954 466021 476220 478039 478949 489181 490742 497969 500912 528087 531426 532090 537593 537645 538165 546666 555318 561588 563056 563229 565902 569736 570753 578166 580872 600798 601341 605015 606842 609361 615277 615355 624989 627196 629472 635662 653347 655840 667979 669895 680611 681276 681614 681636 690842 697465 713126 714808 717048 717062 726515 728887 731753 732226 734268 734620 737863 738207 745320 745852 747144 748709 750797 754401 755111 762748 763373 764290 764448 765909 766388 767518 767987 768092 770069 771442 773621 782401 784357 784388 786353 788076 793565 793797 794178 794408 794713 794715 795130 796074 796710 797215 797903 800015 801372 801935 803821 806705 807887 810774 810899 812083 813647 819468 824442 825348 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother in love"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин love"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин love"
]
|
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.