Query Metrics
7
Database Queries
7
Different statements
1027.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
635.92 ms (61.87%) |
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 397008 815940 486531 502505 685864 718870 719015 814506 543509 705739 605415 792910 789694 792648 429307 723175 606455 531991 531498 617216 707370 442237 430241 433656 690102 609816 582531 504930 671351 416072 413993 429985 816086 395701 407089 469288 524560 529412 484416 430833 405977 406990 517012 689365 444435 814949 471589 646033 603431 437516 396957 407015 815885 494752 550689 715595 716404 411747 682107 716853 792617 431365 507528 484609 400106 414047 531519 531496 580765 688073 801906 706676 802763 431133 531508 480786 750445 573806 506908 437843 395721 431350 562858 598122 395516 528181 628654 407148 409043 433747 456615 685682 404743 494731 505625 649175 688324 622055 811133 451804 425800 484695 484559 395720 446743 448938 482292 546063 698284 586805 586457 724643 492712 721617 606738 430979 484669 418922 522926 688548 ] |
||||||||||||||||||||||||||||||
|
210.81 ms (20.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stepmom секс втро"
]
|
||||||||||||||||||||||||||||||
|
171.72 ms (16.71%) |
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 395516 395701 395720 395721 396957 397008 400106 404743 405977 406990 407015 407089 407148 409043 411747 413993 414047 416072 418922 425800 429307 429985 430241 430833 430979 431133 431350 431365 433656 433747 437516 437843 442237 444435 446743 448938 451804 456615 469288 471589 480786 482292 484416 484559 484609 484669 484695 486531 492712 494731 494752 502505 504930 505625 506908 507528 517012 522926 524560 528181 529412 531496 531498 531508 531519 531991 543509 546063 550689 562858 573806 580765 582531 586457 586805 598122 603431 605415 606455 606738 609816 617216 622055 628654 646033 649175 671351 682107 685682 685864 688073 688324 688548 689365 690102 698284 705739 706676 707370 715595 716404 716853 718870 719015 721617 723175 724643 750445 789694 792617 792648 792910 801906 802763 811133 814506 814949 815885 815940 816086 ] |
||||||||||||||||||||||||||||||
|
3.84 ms (0.37%) |
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 395516 395701 395720 395721 396957 397008 400106 404743 405977 406990 407015 407089 407148 409043 411747 413993 414047 416072 418922 425800 429307 429985 430241 430833 430979 431133 431350 431365 433656 433747 437516 437843 442237 444435 446743 448938 451804 456615 469288 471589 480786 482292 484416 484559 484609 484669 484695 486531 492712 494731 494752 502505 504930 505625 506908 507528 517012 522926 524560 528181 529412 531496 531498 531508 531519 531991 543509 546063 550689 562858 573806 580765 582531 586457 586805 598122 603431 605415 606455 606738 609816 617216 622055 628654 646033 649175 671351 682107 685682 685864 688073 688324 688548 689365 690102 698284 705739 706676 707370 715595 716404 716853 718870 719015 721617 723175 724643 750445 789694 792617 792648 792910 801906 802763 811133 814506 814949 815885 815940 816086 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stepmom threesome"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stepmom секс втро"
]
|
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.