Query Metrics
7
Database Queries
7
Different statements
176.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.48 ms (83.50%) |
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 34123 320879 369353 381853 390851 401532 415784 416056 418669 434091 435158 439467 440908 443468 443812 444883 451506 452092 453085 454130 454185 454274 454428 454432 455949 455995 456842 457444 458701 458728 458730 459242 460444 460689 461318 468685 469906 471449 472596 472680 473315 474257 475539 476039 476342 477462 478611 478835 479078 479079 480959 481345 484581 484598 485274 485625 486901 489791 492631 493193 494184 494195 496979 499896 502062 504019 505311 507663 509193 509279 509284 510165 511069 513518 513649 513838 520681 523032 526523 526885 528393 529604 544613 547607 548011 555075 555112 555138 561423 566358 567395 569099 569146 571103 591039 591736 593856 603363 606009 606292 614789 616915 626136 631058 636434 674269 680441 714544 717927 718119 726432 727783 742532 759571 783145 786525 791589 796017 799776 811649 ] |
||||||||||||||||||||||||||||||
|
18.52 ms (10.49%) |
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 526523 509279 511069 504019 555075 742532 443468 523032 369353 401532 454130 476039 492631 475539 472596 469906 474257 548011 593856 636434 529604 434091 606009 454432 567395 502062 439467 458730 499896 528393 569099 674269 616915 631058 786525 726432 381853 480959 418669 476342 479079 471449 479078 458701 416056 509284 484598 489791 513838 513649 591736 451506 390851 614789 494195 569146 680441 791589 571103 555138 443812 457444 478835 493193 486901 626136 453085 477462 561423 555112 520681 510165 544613 34123 440908 714544 717927 603363 811649 454185 444883 526885 454428 481345 606292 485625 759571 718119 513518 484581 783145 496979 460689 472680 485274 591039 454274 507663 459242 452092 455995 456842 435158 566358 468685 727783 320879 494184 509193 415784 458728 460444 799776 455949 461318 473315 478611 505311 796017 547607 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.65%) |
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 34123 320879 369353 381853 390851 401532 415784 416056 418669 434091 435158 439467 440908 443468 443812 444883 451506 452092 453085 454130 454185 454274 454428 454432 455949 455995 456842 457444 458701 458728 458730 459242 460444 460689 461318 468685 469906 471449 472596 472680 473315 474257 475539 476039 476342 477462 478611 478835 479078 479079 480959 481345 484581 484598 485274 485625 486901 489791 492631 493193 494184 494195 496979 499896 502062 504019 505311 507663 509193 509279 509284 510165 511069 513518 513649 513838 520681 523032 526523 526885 528393 529604 544613 547607 548011 555075 555112 555138 561423 566358 567395 569099 569146 571103 591039 591736 593856 603363 606009 606292 614789 616915 626136 631058 636434 674269 680441 714544 717927 718119 726432 727783 742532 759571 783145 786525 791589 796017 799776 811649 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кончает в зрелую жену"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм в зрелая женщин жен"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм в зрелая женщин жен"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.95%) |
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.