Query Metrics
7
Database Queries
7
Different statements
152.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.20 ms (82.20%) |
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 204605 310672 385165 387350 388313 388891 389339 389610 391133 392994 395147 395598 396104 400002 408383 409930 411908 423345 427647 427950 431082 431167 437765 443915 444153 448666 450025 450912 451780 451786 452519 456151 463973 465333 465610 466261 469467 472889 472939 474090 478481 480902 486181 486376 489207 490914 501154 502532 503502 508493 509324 511387 512487 512775 513033 515581 516945 518241 518811 526733 527439 528507 533510 535346 536147 553248 556647 556658 561396 565510 571145 573475 581399 585331 586807 594522 600777 603667 607518 610500 612287 612413 628694 646016 651155 673325 676463 690783 710836 711589 711710 739060 743178 748197 760160 772581 774172 774675 784160 784493 785607 788978 791486 796442 797637 799256 801475 802716 807902 811284 814024 815817 817086 817238 818450 820694 820773 823044 824787 828751 ] |
||||||||||||||||||||||||||||||
|
17.27 ms (11.34%) |
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 785607 450912 503502 389610 535346 676463 437765 509324 784493 513033 451780 690783 585331 600777 431082 472889 508493 486376 528507 389339 388891 387350 391133 409930 456151 480902 411908 204605 443915 512775 486181 490914 820694 571145 784160 518811 465610 310672 603667 392994 817086 448666 444153 388313 396104 423345 472939 594522 400002 478481 431167 512487 463973 518241 565510 573475 427647 489207 553248 586807 807902 743178 828751 628694 772581 427950 533510 474090 802716 511387 515581 408383 526733 612413 395147 824787 465333 501154 607518 612287 450025 385165 395598 711710 646016 610500 760160 748197 452519 466261 451786 815817 823044 817238 820773 814024 818450 469467 527439 536147 502532 516945 556647 556658 561396 581399 673325 711589 651155 710836 791486 797637 799256 811284 774675 801475 739060 774172 788978 796442 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.46%) |
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 204605 310672 385165 387350 388313 388891 389339 389610 391133 392994 395147 395598 396104 400002 408383 409930 411908 423345 427647 427950 431082 431167 437765 443915 444153 448666 450025 450912 451780 451786 452519 456151 463973 465333 465610 466261 469467 472889 472939 474090 478481 480902 486181 486376 489207 490914 501154 502532 503502 508493 509324 511387 512487 512775 513033 515581 516945 518241 518811 526733 527439 528507 533510 535346 536147 553248 556647 556658 561396 565510 571145 573475 581399 585331 586807 594522 600777 603667 607518 610500 612287 612413 628694 646016 651155 673325 676463 690783 710836 711589 711710 739060 743178 748197 760160 772581 774172 774675 784160 784493 785607 788978 791486 796442 797637 799256 801475 802716 807902 811284 814024 815817 817086 817238 818450 820694 820773 823044 824787 828751 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big pussy stockings"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие pussy чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие pussy чулк нижн бел"
]
|
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.