Query Metrics
7
Database Queries
7
Different statements
165.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.97 ms (86.24%) |
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 91663 100685 130054 194530 365868 382463 390052 391089 395986 396432 402596 403418 418443 425069 454786 456172 459106 468319 468552 509082 514662 529210 534864 536716 537797 542444 543655 543661 545358 549060 557446 561920 569537 569814 580356 588116 589655 595469 595928 596525 602153 605976 607628 609045 616592 619094 620219 621382 625755 626796 635029 636088 637383 640617 640935 641064 646129 651373 656879 661311 662085 662545 667075 667568 668485 669319 670934 671247 671906 673573 674279 675142 680330 680354 685900 686029 688129 692517 705726 712550 713840 720631 726767 732623 733088 733091 734011 739764 748744 749101 757246 760241 768194 773105 774855 779317 780089 780504 780723 780763 782349 785251 787148 787639 788318 788795 788833 790093 790630 793869 797269 798629 802434 808711 809205 809805 810345 812609 813576 814304 ] |
||||||||||||||||||||||||||||||
|
13.21 ms (7.97%) |
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 780504 780723 785251 808711 810345 395986 91663 194530 595928 788795 797269 733091 757246 726767 733088 773105 768194 402596 418443 692517 588116 616592 798629 793869 748744 732623 396432 403418 651373 609045 391089 468552 130054 425069 100685 365868 382463 390052 813576 814304 456172 459106 454786 468319 536716 534864 529210 537797 509082 514662 549060 557446 569814 542444 543655 545358 569537 543661 580356 662545 671247 671906 673573 680354 688129 712550 713840 656879 661311 662085 667075 668485 669319 675142 646129 667568 670934 674279 680330 685900 686029 705726 720631 561920 605976 607628 625755 595469 596525 620219 621382 637383 589655 602153 619094 635029 641064 626796 636088 640617 640935 779317 780089 788318 790093 809205 774855 780763 782349 787639 788833 790630 809805 812609 734011 739764 760241 787148 802434 749101 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.44%) |
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 91663 100685 130054 194530 365868 382463 390052 391089 395986 396432 402596 403418 418443 425069 454786 456172 459106 468319 468552 509082 514662 529210 534864 536716 537797 542444 543655 543661 545358 549060 557446 561920 569537 569814 580356 588116 589655 595469 595928 596525 602153 605976 607628 609045 616592 619094 620219 621382 625755 626796 635029 636088 637383 640617 640935 641064 646129 651373 656879 661311 662085 662545 667075 667568 668485 669319 670934 671247 671906 673573 674279 675142 680330 680354 685900 686029 688129 692517 705726 712550 713840 720631 726767 732623 733088 733091 734011 739764 748744 749101 757246 760241 768194 773105 774855 779317 780089 780504 780723 780763 782349 785251 787148 787639 788318 788795 788833 790093 790630 793869 797269 798629 802434 808711 809205 809805 810345 812609 813576 814304 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife blonde"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.98%) |
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.