Query Metrics
7
Database Queries
7
Different statements
412.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.29 ms (52.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск бдсм"
]
|
||||||||||||||||||||||||||||||
|
173.19 ms (42.04%) |
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 345303 401599 414212 424679 441110 456215 456333 456818 460209 469696 475902 482615 486969 491666 497904 507441 516144 517018 517236 521789 522521 523498 526314 526767 529728 531662 532500 534742 534853 537806 542386 542396 546180 547532 552732 558620 558933 559666 560987 574123 579851 579872 582757 583360 583386 588220 593003 615658 624503 633340 634608 638052 639621 646682 648125 659952 660249 661506 661652 677919 689964 691725 699480 710339 713399 714279 716699 726041 726055 729943 730363 733264 733759 734222 738939 745227 747396 754481 757182 761996 765752 767069 767751 768499 773291 773391 777113 777204 778569 780935 782762 782773 785472 786515 789898 793117 793201 795002 795111 795945 796724 796745 796751 796772 796785 797350 800526 801067 806853 809827 814281 817128 817168 818841 819636 820069 821871 825762 827433 827871 ] |
||||||||||||||||||||||||||||||
|
15.62 ms (3.79%) |
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 768499 785472 726041 733759 729943 745227 747396 757182 733264 754481 773391 738939 767069 777204 780935 795111 469696 552732 583386 710339 491666 716699 827871 529728 517236 526314 534742 507441 534853 537806 583360 574123 646682 648125 659952 661506 661652 689964 691725 660249 677919 714279 546180 558933 559666 582757 634608 639621 633340 638052 699480 713399 532500 523498 817168 818841 819636 821871 814281 817128 820069 827433 482615 521789 517018 475902 542396 624503 777113 778569 782762 786515 789898 795002 796772 796785 801067 782773 793117 796724 796745 800526 806853 795945 796751 726055 734222 767751 761996 730363 773291 793201 797350 809827 345303 531662 526767 560987 547532 579872 588220 401599 516144 414212 441110 424679 825762 456818 456215 460209 579851 542386 558620 593003 615658 765752 456333 486969 522521 497904 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (0.73%) |
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 345303 401599 414212 424679 441110 456215 456333 456818 460209 469696 475902 482615 486969 491666 497904 507441 516144 517018 517236 521789 522521 523498 526314 526767 529728 531662 532500 534742 534853 537806 542386 542396 546180 547532 552732 558620 558933 559666 560987 574123 579851 579872 582757 583360 583386 588220 593003 615658 624503 633340 634608 638052 639621 646682 648125 659952 660249 661506 661652 677919 689964 691725 699480 710339 713399 714279 716699 726041 726055 729943 730363 733264 733759 734222 738939 745227 747396 754481 757182 761996 765752 767069 767751 768499 773291 773391 777113 777204 778569 780935 782762 782773 785472 786515 789898 793117 793201 795002 795111 795945 796724 796745 796751 796772 796785 797350 800526 801067 806853 809827 814281 817128 817168 818841 819636 820069 821871 825762 827433 827871 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade bondage"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.43%) |
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.