Query Metrics
7
Database Queries
7
Different statements
169.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.59 ms (85.86%) |
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 152276 156525 185123 185332 185606 319841 382465 382696 382745 382957 389518 390215 398872 398918 399627 401281 404304 411609 418933 419794 424352 431019 441758 445233 447493 449713 450968 453295 454323 461091 464195 467273 469675 473488 474823 478760 484355 486923 489110 494771 499643 501805 503215 507168 508568 511902 518032 518328 518767 523971 524003 526824 530718 531471 538365 543791 551292 551319 551409 551422 551741 554758 558617 560101 562881 563796 566848 568129 572010 572013 578478 596908 601618 602725 603583 610226 614726 618883 622986 625452 630616 636836 643520 645847 653247 653251 663533 667675 667894 669130 671703 682493 687263 689325 689591 690148 695292 696102 716753 720535 737535 744601 749553 750782 756460 758102 771354 773098 773174 796205 801366 802737 805566 810842 814758 814806 815691 816556 820009 825210 ] |
||||||||||||||||||||||||||||||
|
14.59 ms (8.60%) |
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 558617 563796 551422 572010 653247 682493 603583 625452 478760 445233 503215 489110 518032 501805 418933 454323 518328 566848 467273 461091 551741 572013 560101 720535 671703 689591 562881 802737 185123 152276 399627 523971 404304 484355 526824 530718 687263 554758 618883 469675 508568 494771 524003 749553 382745 825210 815691 816556 645847 382465 185332 390215 419794 474823 551319 382957 398918 511902 507168 596908 578478 667894 667675 614726 601618 464195 431019 531471 398872 401281 411609 551292 689325 695292 622986 602725 630616 810842 773174 801366 737535 756460 447493 156525 185606 319841 389518 441758 424352 814806 814758 486923 538365 543791 551409 653251 663533 696102 610226 796205 805566 750782 744601 773098 758102 771354 449713 450968 499643 518767 568129 453295 473488 382696 820009 716753 690148 669130 643520 636836 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.72%) |
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 152276 156525 185123 185332 185606 319841 382465 382696 382745 382957 389518 390215 398872 398918 399627 401281 404304 411609 418933 419794 424352 431019 441758 445233 447493 449713 450968 453295 454323 461091 464195 467273 469675 473488 474823 478760 484355 486923 489110 494771 499643 501805 503215 507168 508568 511902 518032 518328 518767 523971 524003 526824 530718 531471 538365 543791 551292 551319 551409 551422 551741 554758 558617 560101 562881 563796 566848 568129 572010 572013 578478 596908 601618 602725 603583 610226 614726 618883 622986 625452 630616 636836 643520 645847 653247 653251 663533 667675 667894 669130 671703 682493 687263 689325 689591 690148 695292 696102 716753 720535 737535 744601 749553 750782 756460 758102 771354 773098 773174 796205 801366 802737 805566 810842 814758 814806 815691 816556 820009 825210 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits massage"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ массаж"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ массаж"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.