Query Metrics
7
Database Queries
7
Different statements
153.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.99 ms (81.19%) |
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 68412 412180 414070 416002 416009 416019 416025 418719 418720 419459 419640 419822 424043 424608 424624 426268 426519 427898 429114 435734 438333 443452 443636 450250 452843 452847 452990 454865 455082 456007 458435 460559 462886 464642 464659 464687 467939 468250 474596 476903 484972 493311 496361 497514 509833 510561 511507 511856 512477 513809 516024 520405 520972 522328 524562 526789 527178 528186 529342 531021 533538 541096 541541 542160 550402 556183 558623 570421 570697 572005 579396 582073 583200 585229 587731 588052 588449 589145 595899 598859 604056 605634 613708 624907 629819 630150 630558 630919 631616 633216 638737 639121 643510 644498 648880 657136 659981 667344 674474 675402 682352 699160 718513 734137 734534 735906 742891 750852 751001 761293 765712 784874 798953 800895 803163 808956 809631 812043 812763 814519 ] |
||||||||||||||||||||||||||||||
|
17.56 ms (11.40%) |
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 68412 419459 424043 814519 452847 531021 511507 541096 556183 541541 682352 675402 570421 595899 624907 639121 587731 604056 638737 751001 809631 734137 630150 643510 644498 784874 800895 808956 419822 416019 497514 524562 510561 583200 812763 424624 435734 456007 458435 496361 464642 464687 474596 582073 718513 674474 570697 605634 630558 761293 735906 765712 633216 699160 419640 468250 426268 443452 455082 416002 450250 579396 462886 438333 516024 520972 558623 734534 416025 613708 509833 418719 426519 412180 464659 484972 512477 528186 511856 526789 542160 648880 667344 657136 588052 588449 589145 812043 418720 424608 427898 513809 798953 460559 414070 452843 585229 629819 429114 454865 416009 520405 750852 522328 476903 467939 533538 529342 572005 631616 630919 452990 803163 443636 550402 659981 742891 527178 598859 493311 ] |
||||||||||||||||||||||||||||||
|
3.46 ms (2.25%) |
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 68412 412180 414070 416002 416009 416019 416025 418719 418720 419459 419640 419822 424043 424608 424624 426268 426519 427898 429114 435734 438333 443452 443636 450250 452843 452847 452990 454865 455082 456007 458435 460559 462886 464642 464659 464687 467939 468250 474596 476903 484972 493311 496361 497514 509833 510561 511507 511856 512477 513809 516024 520405 520972 522328 524562 526789 527178 528186 529342 531021 533538 541096 541541 542160 550402 556183 558623 570421 570697 572005 579396 582073 583200 585229 587731 588052 588449 589145 595899 598859 604056 605634 613708 624907 629819 630150 630558 630919 631616 633216 638737 639121 643510 644498 648880 657136 659981 667344 674474 675402 682352 699160 718513 734137 734534 735906 742891 750852 751001 761293 765712 784874 798953 800895 803163 808956 809631 812043 812763 814519 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"watch мастурбац"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"watch мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"watch masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.16%) |
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.