Query Metrics
7
Database Queries
7
Different statements
192.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.05 ms (86.58%) |
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 383719 395755 397896 401957 408206 411591 411841 415563 418865 421102 421822 423802 425653 433808 443712 450848 451479 455322 458724 459086 462707 464442 467940 474447 479042 480415 485061 486834 489127 499915 507909 512555 513435 513819 515364 517003 519726 522601 522923 523133 524171 524910 524928 526165 526547 529251 531238 533963 534959 541587 542090 547734 549236 559841 559979 560141 566760 567054 567097 570405 576680 580319 586372 586407 586408 592015 593270 594150 598864 601210 601653 603897 605488 607464 612026 614568 615761 617009 622054 623416 635946 638437 649586 654919 667555 667880 671639 683973 687604 691626 693900 702125 706294 712106 738503 741613 770663 772248 775246 775276 776531 777003 777577 783161 786454 790841 799256 801287 804613 805896 809415 809516 809521 813067 813110 813552 814765 817319 818998 820529 ] |
||||||||||||||||||||||||||||||
|
16.25 ms (8.42%) |
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 559979 570405 547734 671639 586408 586407 777577 741613 423802 397896 418865 425653 443712 480415 522923 529251 464442 814765 467940 693900 607464 804613 479042 395755 485061 649586 594150 801287 813067 541587 531238 601653 738503 772248 421822 455322 524928 433808 408206 820529 813552 817319 818998 450848 489127 515364 523133 499915 526165 534959 524171 524910 533963 542090 549236 567054 566760 576680 580319 667555 667880 683973 687604 691626 702125 706294 559841 560141 601210 614568 638437 586372 623416 635946 605488 612026 622054 615761 775276 776531 813110 805896 809415 809516 783161 786454 790841 809521 770663 617009 775246 777003 401957 411841 459086 462707 451479 458724 474447 411591 415563 512555 519726 526547 507909 517003 522601 654919 712106 567097 593270 598864 592015 799256 603897 383719 421102 486834 513435 513819 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.57%) |
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 383719 395755 397896 401957 408206 411591 411841 415563 418865 421102 421822 423802 425653 433808 443712 450848 451479 455322 458724 459086 462707 464442 467940 474447 479042 480415 485061 486834 489127 499915 507909 512555 513435 513819 515364 517003 519726 522601 522923 523133 524171 524910 524928 526165 526547 529251 531238 533963 534959 541587 542090 547734 549236 559841 559979 560141 566760 567054 567097 570405 576680 580319 586372 586407 586408 592015 593270 594150 598864 601210 601653 603897 605488 607464 612026 614568 615761 617009 622054 623416 635946 638437 649586 654919 667555 667880 671639 683973 687604 691626 693900 702125 706294 712106 738503 741613 770663 772248 775246 775276 776531 777003 777577 783161 786454 790841 799256 801287 804613 805896 809415 809516 809521 813067 813110 813552 814765 817319 818998 820529 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom жоп fucking"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom ass fucking"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom жоп fucking"
]
|
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.