Query Metrics
7
Database Queries
7
Different statements
160.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.98 ms (83.54%) |
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 413808 414807 417340 418221 419471 420194 420507 422287 438004 441611 444035 444939 448752 450130 450154 450867 452375 454050 455491 455649 456153 456694 458473 459959 460055 460093 462405 463404 463460 466381 466780 466799 467069 471460 475177 478220 478222 478330 480032 480187 480331 480450 480714 482876 484023 489756 490263 492343 496687 496733 497077 498086 499514 501047 502368 504065 504320 504473 504656 507095 507249 512017 514234 518004 522629 523433 525863 526236 526508 527810 528142 530103 533241 539940 543828 545821 546308 552255 552275 553082 554275 559465 560260 564080 564928 565819 567833 568915 572195 579220 582592 583558 590094 593988 594557 596943 605905 606974 607648 609614 617672 624797 629337 640349 670180 732204 736368 739652 749436 756165 765250 782594 787214 790055 792344 793844 803534 805254 807582 810931 ] |
||||||||||||||||||||||||||||||
|
17.24 ms (10.75%) |
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 554275 466780 528142 504320 501047 525863 518004 527810 454050 522629 467069 640349 782594 792344 736368 810931 749436 417340 475177 420194 438004 448752 455491 455649 526236 545821 552275 583558 670180 605905 607648 594557 596943 617672 793844 805254 739652 606974 466799 504065 490263 498086 507095 507249 567833 579220 593988 441611 492343 489756 504656 480187 480714 568915 414807 480450 460093 480331 466381 478220 512017 484023 496733 422287 419471 450130 499514 533241 496687 514234 463404 559465 564080 543828 552255 564928 553082 582592 609614 765250 790055 807582 756165 732204 459959 478222 450867 456153 462405 497077 502368 523433 572195 624797 504473 444035 413808 450154 471460 463460 526508 530103 539940 482876 560260 565819 546308 590094 787214 803534 629337 420507 452375 456694 418221 478330 444939 460055 480032 458473 ] |
||||||||||||||||||||||||||||||
|
2.74 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 413808 414807 417340 418221 419471 420194 420507 422287 438004 441611 444035 444939 448752 450130 450154 450867 452375 454050 455491 455649 456153 456694 458473 459959 460055 460093 462405 463404 463460 466381 466780 466799 467069 471460 475177 478220 478222 478330 480032 480187 480331 480450 480714 482876 484023 489756 490263 492343 496687 496733 497077 498086 499514 501047 502368 504065 504320 504473 504656 507095 507249 512017 514234 518004 522629 523433 525863 526236 526508 527810 528142 530103 533241 539940 543828 545821 546308 552255 552275 553082 554275 559465 560260 564080 564928 565819 567833 568915 572195 579220 582592 583558 590094 593988 594557 596943 605905 606974 607648 609614 617672 624797 629337 640349 670180 732204 736368 739652 749436 756165 765250 782594 787214 790055 792344 793844 803534 805254 807582 810931 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggystyle public amateur"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"doggystyle на улиц любительск"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"doggystyle на улиц любительск"
]
|
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.