Query Metrics
7
Database Queries
7
Different statements
144.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.77 ms (81.72%) |
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 88505 88614 186858 226412 336085 383687 389976 406652 419616 428544 436965 458203 460327 465579 470081 478516 494216 511053 529638 529865 531742 531836 534451 536468 536567 538378 539881 540099 548945 549515 554180 555383 558402 559863 560345 563628 563998 571304 574341 575378 576534 576540 578857 579675 581550 585435 589593 593798 607434 623068 623690 645844 649388 649437 651584 652878 652881 666492 667354 669896 671779 672811 677148 677432 678003 678780 679283 683080 683698 684789 689847 690031 690634 691785 698478 700906 700907 702319 704788 707388 707906 708226 710860 712366 712446 715291 718537 737106 740258 742536 754986 764268 765423 781417 784001 784513 785250 787078 800134 805145 813791 814363 814410 816147 817181 817734 819665 822698 823773 823890 824000 824103 824319 824483 824663 824765 824931 825582 826719 826873 ] |
||||||||||||||||||||||||||||||
|
14.76 ms (10.24%) |
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 460327 781417 436965 558402 712366 715291 784513 470081 186858 88505 389976 814363 478516 536468 536567 494216 554180 578857 645844 672811 677148 689847 700906 649437 690634 707388 708226 607434 585435 787078 805145 785250 737106 800134 740258 742536 754986 764268 765423 784001 465579 419616 511053 383687 226412 336085 88614 406652 428544 824103 824663 825582 826719 816147 817181 824483 824931 813791 817734 819665 822698 823773 824765 814410 823890 824000 824319 826873 458203 529638 531742 534451 539881 538378 540099 529865 531836 549515 559863 571304 548945 563628 563998 574341 575378 560345 576540 579675 581550 652878 652881 671779 677432 683080 684789 700907 702319 707906 651584 667354 683698 690031 710860 649388 666492 669896 678003 678780 679283 691785 698478 704788 712446 718537 555383 576534 589593 593798 623068 623690 ] |
||||||||||||||||||||||||||||||
|
3.80 ms (2.64%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац туалет"
]
|
||||||||||||||||||||||||||||||
|
2.92 ms (2.02%) |
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 88505 88614 186858 226412 336085 383687 389976 406652 419616 428544 436965 458203 460327 465579 470081 478516 494216 511053 529638 529865 531742 531836 534451 536468 536567 538378 539881 540099 548945 549515 554180 555383 558402 559863 560345 563628 563998 571304 574341 575378 576534 576540 578857 579675 581550 585435 589593 593798 607434 623068 623690 645844 649388 649437 651584 652878 652881 666492 667354 669896 671779 672811 677148 677432 678003 678780 679283 683080 683698 684789 689847 690031 690634 691785 698478 700906 700907 702319 704788 707388 707906 708226 710860 712366 712446 715291 718537 737106 740258 742536 754986 764268 765423 781417 784001 784513 785250 787078 800134 805145 813791 814363 814410 816147 817181 817734 819665 822698 823773 823890 824000 824103 824319 824483 824663 824765 824931 825582 826719 826873 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation toilet"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (1.04%) |
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.