Query Metrics
7
Database Queries
7
Different statements
185.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.03 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 445731 463701 465160 470462 472860 474219 474582 478035 485815 487320 496307 512623 531389 532126 532304 532321 538147 539597 541406 545046 546011 549781 551926 551967 554795 560259 566145 585496 588366 588518 589578 592472 604985 613456 617807 618644 621291 621488 622823 627656 629798 630052 636929 639571 645387 645871 648672 649542 652122 656747 657370 657571 657613 657996 665434 665456 665499 666105 667938 670546 677341 678184 681168 683126 692958 695692 695706 697971 701255 710102 710481 710762 710822 711531 711540 711573 711575 711580 711582 712089 714558 715297 716172 716418 721916 725709 726355 726637 727017 727788 731040 732287 734462 735610 741621 742560 745264 745974 745985 747956 748668 755222 758801 759006 759011 759018 762547 770342 770346 770350 770355 774883 775732 777668 785056 786440 787027 800683 808268 810261 ] |
||||||||||||||||||||||||||||||
|
15.96 ms (8.62%) |
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 470462 487320 445731 465160 474582 485815 463701 478035 512623 532126 532321 538147 539597 496307 531389 532304 472860 474219 549781 551926 566145 541406 551967 554795 645871 648672 649542 652122 657571 665434 667938 670546 677341 678184 683126 692958 695706 711573 715297 716418 657370 657996 665499 666105 681168 695692 697971 701255 711540 645387 656747 657613 665456 710102 710762 710822 711531 711580 712089 714558 716172 545046 546011 560259 585496 588366 589578 592472 588518 618644 621291 622823 629798 639571 621488 636929 604985 627656 774883 787027 810261 775732 786440 800683 808268 725709 759006 759011 785056 731040 734462 745264 747956 770346 727017 742560 745974 758801 759018 770350 726355 727788 735610 748668 755222 726637 732287 741621 745985 762547 770342 770355 613456 617807 630052 710481 711575 711582 721916 777668 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (1.74%) |
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 445731 463701 465160 470462 472860 474219 474582 478035 485815 487320 496307 512623 531389 532126 532304 532321 538147 539597 541406 545046 546011 549781 551926 551967 554795 560259 566145 585496 588366 588518 589578 592472 604985 613456 617807 618644 621291 621488 622823 627656 629798 630052 636929 639571 645387 645871 648672 649542 652122 656747 657370 657571 657613 657996 665434 665456 665499 666105 667938 670546 677341 678184 681168 683126 692958 695692 695706 697971 701255 710102 710481 710762 710822 711531 711540 711573 711575 711580 711582 712089 714558 715297 716172 716418 721916 725709 726355 726637 727017 727788 731040 732287 734462 735610 741621 742560 745264 745974 745985 747956 748668 755222 758801 759006 759011 759018 762547 770342 770346 770350 770355 774883 775732 777668 785056 786440 787027 800683 808268 810261 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (1.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая short hair"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette short hair"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"черноволосая short hair"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.02%) |
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.