Query Metrics
7
Database Queries
7
Different statements
167.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.95 ms (84.74%) |
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 306045 382926 396507 401969 405061 405718 429189 437618 438759 447812 457401 458781 459022 461448 463470 474621 488823 491227 491656 491662 491669 491686 494561 500498 500530 501830 502537 507136 517395 517588 525202 527632 540095 541593 542319 545086 545359 547141 558980 563634 566817 567340 567345 569535 572246 574562 574796 574863 575075 575451 575483 575789 587689 594860 599533 604539 604698 604977 605624 605643 607319 607448 610076 610689 611820 615426 625086 630893 636550 636567 646012 648917 650983 654534 655320 663446 663981 682291 687989 691717 691724 691729 692845 701472 709337 713055 720223 724723 725089 725948 726157 727721 727799 731058 731727 732633 732644 734388 737847 742145 742153 742261 745518 747760 748441 749743 757897 758406 760534 769379 773960 773971 795150 795955 797138 808064 809879 813438 814083 828379 ] |
||||||||||||||||||||||||||||||
|
15.62 ms (9.32%) |
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 501830 517395 654534 655320 630893 502537 611820 405061 599533 563634 474621 488823 463470 542319 545086 541593 725089 575075 691717 709337 574562 569535 701472 574796 742145 458781 691724 760534 745518 725948 813438 494561 605624 636567 615426 795955 795150 461448 540095 575789 749743 605643 757897 575483 437618 491686 396507 650983 769379 732633 491669 663981 713055 773960 747760 828379 727799 382926 517588 567345 742261 731727 459022 491656 527632 687989 604539 438759 491662 732644 401969 547141 691729 682291 773971 636550 500530 447812 604698 405718 692845 724723 604977 797138 507136 607319 607448 727721 742153 758406 809879 731058 306045 500498 491227 575451 648917 587689 625086 429189 457401 814083 566817 567340 545359 646012 720223 594860 734388 748441 610076 558980 572246 574863 610689 737847 663446 525202 726157 808064 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.82%) |
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 306045 382926 396507 401969 405061 405718 429189 437618 438759 447812 457401 458781 459022 461448 463470 474621 488823 491227 491656 491662 491669 491686 494561 500498 500530 501830 502537 507136 517395 517588 525202 527632 540095 541593 542319 545086 545359 547141 558980 563634 566817 567340 567345 569535 572246 574562 574796 574863 575075 575451 575483 575789 587689 594860 599533 604539 604698 604977 605624 605643 607319 607448 610076 610689 611820 615426 625086 630893 636550 636567 646012 648917 650983 654534 655320 663446 663981 682291 687989 691717 691724 691729 692845 701472 709337 713055 720223 724723 725089 725948 726157 727721 727799 731058 731727 732633 732644 734388 737847 742145 742153 742261 745518 747760 748441 749743 757897 758406 760534 769379 773960 773971 795150 795955 797138 808064 809879 813438 814083 828379 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex cuckold"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс куколд"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.85%) |
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.