Query Metrics
7
Database Queries
7
Different statements
247.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
221.17 ms (89.35%) |
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 76122 81603 91663 162863 329296 384501 388417 392691 396512 398230 401114 401477 401917 402056 402080 403346 409233 412367 413706 415533 418020 419014 420607 421238 422704 424842 425609 425891 426030 435341 448014 451795 452017 458511 461079 462724 463094 463952 468639 472918 473258 474059 476761 476916 478074 478850 480231 481816 482140 484749 488474 488773 489602 491641 492313 495771 496536 497270 498475 498511 499224 510568 512665 513408 522966 525049 525223 526842 526949 528406 531423 532842 536022 537993 538173 538634 542521 546019 549350 551497 552521 560653 562398 564707 570366 573848 575989 586985 587529 588305 589358 605178 619675 630832 645052 648527 648572 655066 676527 679653 682232 688855 694110 694438 698013 725891 736644 739042 741239 747312 755277 773826 778374 781285 788182 791329 810712 810926 813500 814014 ] |
||||||||||||||||||||||||||||||
|
15.63 ms (6.31%) |
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 76122 91663 402056 415533 422704 484749 424842 538173 682232 694110 645052 655066 619675 813500 736644 755277 409233 413706 329296 401477 388417 392691 688855 81603 402080 403346 551497 694438 575989 747312 781285 741239 162863 412367 398230 451795 458511 497270 495771 482140 552521 564707 679653 562398 587529 810926 448014 474059 435341 463952 419014 425891 468639 478074 478850 480231 462724 473258 476761 476916 481816 512665 522966 525049 525223 526842 526949 537993 489602 491641 498511 499224 488474 814014 570366 549350 560653 573848 648527 676527 698013 546019 630832 586985 589358 605178 788182 739042 791329 773826 725891 778374 396512 401917 420607 810712 496536 425609 513408 588305 401114 426030 461079 463094 421238 452017 472918 528406 510568 531423 488773 498475 384501 418020 492313 538634 532842 536022 542521 648572 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.22%) |
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 76122 81603 91663 162863 329296 384501 388417 392691 396512 398230 401114 401477 401917 402056 402080 403346 409233 412367 413706 415533 418020 419014 420607 421238 422704 424842 425609 425891 426030 435341 448014 451795 452017 458511 461079 462724 463094 463952 468639 472918 473258 474059 476761 476916 478074 478850 480231 481816 482140 484749 488474 488773 489602 491641 492313 495771 496536 497270 498475 498511 499224 510568 512665 513408 522966 525049 525223 526842 526949 528406 531423 532842 536022 537993 538173 538634 542521 546019 549350 551497 552521 560653 562398 564707 570366 573848 575989 586985 587529 588305 589358 605178 619675 630832 645052 648527 648572 655066 676527 679653 682232 688855 694110 694438 698013 725891 736644 739042 741239 747312 755277 773826 778374 781285 788182 791329 810712 810926 813500 814014 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие красивая"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big this beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.65%) |
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.