Query Metrics
7
Database Queries
7
Different statements
144.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.19 ms (84.77%) |
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 233733 538870 538937 540656 541419 541618 541886 542223 543495 544279 544288 544754 547431 547860 558801 560079 560993 561007 561030 562848 563436 563445 563533 564876 565828 566405 566689 568262 574222 576626 577381 581305 586294 587795 592450 593236 603273 605325 605341 605344 620141 620142 620156 621310 621698 624163 629898 644289 644300 644306 644311 644321 644922 647630 649129 649150 649560 668985 670093 670103 671714 671745 671898 672130 674100 677723 681085 689699 690809 692188 692319 692796 693049 693055 693980 694089 694553 695243 695930 696250 697266 697361 697364 697987 698423 698531 698590 699578 699755 703051 703432 703554 703556 705791 706589 707318 708468 708525 708605 716409 716572 717862 717903 719137 720385 721715 727819 730224 733145 741097 744259 748529 759706 770268 775776 784247 789659 789841 790814 801322 ] |
||||||||||||||||||||||||||||||
|
11.67 ms (8.09%) |
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 541419 538870 692319 605341 721715 581305 574222 566689 716409 790814 566405 698423 593236 547860 670103 706589 540656 770268 547431 703432 649129 705791 677723 708525 741097 801322 624163 693980 696250 697364 672130 693049 699755 733145 789841 748529 720385 563436 563533 541618 707318 689699 692796 703556 644300 727819 620141 775776 558801 544279 649560 671898 560993 605325 629898 716572 233733 542223 543495 565828 562848 560079 561030 690809 695930 647630 649150 694553 697361 671714 692188 544754 789659 564876 577381 563445 592450 620142 620156 538937 561007 674100 699578 576626 730224 708605 541886 703051 717862 644321 621698 544288 670093 717903 587795 744259 644306 586294 603273 568262 671745 693055 698531 719137 695243 703554 621310 759706 644922 605344 644311 644289 668985 694089 698590 681085 697987 697266 708468 784247 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (2.07%) |
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 233733 538870 538937 540656 541419 541618 541886 542223 543495 544279 544288 544754 547431 547860 558801 560079 560993 561007 561030 562848 563436 563445 563533 564876 565828 566405 566689 568262 574222 576626 577381 581305 586294 587795 592450 593236 603273 605325 605341 605344 620141 620142 620156 621310 621698 624163 629898 644289 644300 644306 644311 644321 644922 647630 649129 649150 649560 668985 670093 670103 671714 671745 671898 672130 674100 677723 681085 689699 690809 692188 692319 692796 693049 693055 693980 694089 694553 695243 695930 696250 697266 697361 697364 697987 698423 698531 698590 699578 699755 703051 703432 703554 703556 705791 706589 707318 708468 708525 708605 716409 716572 717862 717903 719137 720385 721715 727819 730224 733145 741097 744259 748529 759706 770268 775776 784247 789659 789841 790814 801322 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"retro anal sex"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ретр анал секс"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.17%) |
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.