Query Metrics
7
Database Queries
7
Different statements
153.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.20 ms (83.28%) |
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 391925 422453 423813 426876 434327 434332 436942 445395 446639 446661 454558 454567 454861 455994 456293 460599 460941 461992 462022 463973 465367 465375 465401 466085 466494 466818 466977 467923 469774 470779 470788 471976 472665 475888 476001 477974 477983 479114 479506 482837 484032 484573 485295 492798 492968 493754 494589 495051 498875 498927 504056 504807 506094 506458 511610 513010 518150 518868 519309 519363 519512 523595 526952 527937 528127 533874 536049 536062 540911 541015 541068 544619 546059 546109 553441 555795 560130 568214 578323 581126 596796 597091 598783 605475 617698 623821 649306 676825 714346 714443 719461 725490 728956 739779 743641 746093 756245 766143 769071 769465 782093 783419 790809 794063 794166 795948 800753 800906 801639 802291 802340 802652 805368 807336 807842 807902 809649 810409 810524 823368 ] |
||||||||||||||||||||||||||||||
|
15.93 ms (10.34%) |
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 605475 790809 795948 800753 802340 766143 802652 782093 391925 422453 454861 456293 482837 513010 526952 494589 504807 463973 469774 466818 472665 470779 484032 495051 519309 519512 493754 536049 536062 492968 541015 541068 544619 553441 568214 540911 560130 649306 714346 719461 546109 623821 596796 617698 783419 809649 728956 769071 725490 739779 743641 746093 794166 466977 470788 465401 423813 479506 434327 465375 436942 476001 506458 511610 528127 504056 492798 519363 527937 498875 518150 465367 475888 484573 533874 466494 506094 471976 578323 581126 460599 479114 446639 454567 477974 477983 454558 466085 555795 462022 597091 598783 426876 823368 485295 498927 518868 523595 546059 676825 714443 794063 801639 802291 807336 805368 807842 810409 810524 807902 756245 769465 800906 434332 445395 461992 467923 446661 460941 455994 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.77%) |
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 391925 422453 423813 426876 434327 434332 436942 445395 446639 446661 454558 454567 454861 455994 456293 460599 460941 461992 462022 463973 465367 465375 465401 466085 466494 466818 466977 467923 469774 470779 470788 471976 472665 475888 476001 477974 477983 479114 479506 482837 484032 484573 485295 492798 492968 493754 494589 495051 498875 498927 504056 504807 506094 506458 511610 513010 518150 518868 519309 519363 519512 523595 526952 527937 528127 533874 536049 536062 540911 541015 541068 544619 546059 546109 553441 555795 560130 568214 578323 581126 596796 597091 598783 605475 617698 623821 649306 676825 714346 714443 719461 725490 728956 739779 743641 746093 756245 766143 769071 769465 782093 783419 790809 794063 794166 795948 800753 800906 801639 802291 802340 802652 805368 807336 807842 807902 809649 810409 810524 823368 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian hairy homemade"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск волосатая домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.92%) |
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.