Query Metrics
7
Database Queries
7
Different statements
382.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.01 ms (55.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ group"
]
|
||||||||||||||||||||||||||||||
|
140.63 ms (36.76%) |
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 44177 102086 123741 130022 130089 142809 143010 143291 214719 320078 383517 385301 385704 392957 396030 396571 396910 404237 407767 410745 415307 428979 443738 443756 446880 461384 462361 463246 464682 472778 473245 474055 474845 482553 484842 484849 484863 486392 486807 487115 487122 494687 501234 515569 515895 518769 523602 529545 531507 532361 534236 534757 542579 542953 543413 546854 548392 558431 566808 580881 583948 589154 595828 607155 610814 622236 622639 623517 635160 643074 643948 644398 645232 645235 645944 653154 659329 660075 665751 667230 672396 672765 683802 709261 711689 712686 712712 714014 718955 721140 721600 721687 731950 732954 735852 740832 741051 748621 749918 775046 775783 775980 775984 786255 787676 800019 801405 802101 803347 804472 804477 806445 809529 813640 814565 817718 818516 820160 822154 824052 ] |
||||||||||||||||||||||||||||||
|
18.14 ms (4.74%) |
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 543413 566808 542579 712712 645235 667230 645232 589154 607155 786255 635160 775984 407767 428979 130089 396910 487115 474845 534757 473245 824052 542953 712686 775046 800019 484863 415307 472778 462361 130022 818516 822154 672396 683802 711689 718955 645944 653154 721600 659329 709261 775783 732954 748621 740832 749918 731950 622236 775980 721687 102086 486807 482553 487122 531507 534236 518769 523602 494687 529545 463246 546854 660075 464682 484842 486392 484849 385301 123741 143291 44177 820160 817718 446880 665751 622639 809529 802101 803347 804472 741051 787676 643948 644398 801405 804477 142809 214719 396030 385704 143010 392957 320078 410745 474055 583948 580881 714014 672765 735852 623517 396571 461384 383517 814565 501234 515569 515895 532361 643074 721140 404237 548392 558431 595828 806445 443756 443738 813640 610814 ] |
||||||||||||||||||||||||||||||
|
3.57 ms (0.93%) |
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 44177 102086 123741 130022 130089 142809 143010 143291 214719 320078 383517 385301 385704 392957 396030 396571 396910 404237 407767 410745 415307 428979 443738 443756 446880 461384 462361 463246 464682 472778 473245 474055 474845 482553 484842 484849 484863 486392 486807 487115 487122 494687 501234 515569 515895 518769 523602 529545 531507 532361 534236 534757 542579 542953 543413 546854 548392 558431 566808 580881 583948 589154 595828 607155 610814 622236 622639 623517 635160 643074 643948 644398 645232 645235 645944 653154 659329 660075 665751 667230 672396 672765 683802 709261 711689 712686 712712 714014 718955 721140 721600 721687 731950 732954 735852 740832 741051 748621 749918 775046 775783 775980 775984 786255 787676 800019 801405 802101 803347 804472 804477 806445 809529 813640 814565 817718 818516 820160 822154 824052 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.56%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits group"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ group"
]
|
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.