Query Metrics
7
Database Queries
7
Different statements
144.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.77 ms (81.29%) |
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 89480 235887 382184 384178 384878 386122 391492 392563 392599 397475 398548 398561 398606 400859 400985 400999 401921 401939 405810 407685 407765 409156 409937 411333 411346 411690 414365 419272 421780 422420 424481 428057 428073 432886 439592 439615 439854 442932 443712 443763 443812 444104 446893 447236 455140 459907 460745 460852 460925 465412 465525 466023 467512 470762 471061 471416 475452 475658 476252 476271 476285 476339 477981 478017 479027 482490 484405 484587 484702 485576 489484 496864 498822 499423 502749 513609 518876 519141 522771 532135 536273 546680 549639 551254 557977 558009 559009 560558 561871 563072 576342 591595 603663 716030 726478 726565 726574 726753 728964 731137 732725 733832 738404 739739 740136 742812 742889 743679 761979 764593 780667 795041 796084 796109 801514 802186 802730 806324 810566 826645 ] |
||||||||||||||||||||||||||||||
|
17.96 ms (12.40%) |
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 400999 384878 409937 455140 400859 397475 398548 398606 401939 411346 536273 802186 810566 731137 739739 761979 732725 742812 400985 513609 522771 551254 557977 546680 559009 603663 716030 806324 447236 439854 485576 498822 446893 726574 392599 407685 466023 489484 432886 476252 484405 459907 465412 460925 549639 558009 443812 460745 442932 476271 479027 476339 476285 477981 439592 443763 502749 484587 496864 499423 484702 386122 475658 475452 382184 405810 563072 411333 424481 401921 407765 392563 443712 467512 478017 519141 518876 384178 826645 532135 738404 740136 742889 743679 728964 733832 764593 780667 391492 422420 591595 470762 439615 465525 89480 398561 409156 414365 419272 428073 444104 411690 428057 421780 482490 460852 471061 471416 560558 561871 576342 802730 796109 795041 726478 726565 726753 796084 801514 235887 ] |
||||||||||||||||||||||||||||||
|
2.52 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 89480 235887 382184 384178 384878 386122 391492 392563 392599 397475 398548 398561 398606 400859 400985 400999 401921 401939 405810 407685 407765 409156 409937 411333 411346 411690 414365 419272 421780 422420 424481 428057 428073 432886 439592 439615 439854 442932 443712 443763 443812 444104 446893 447236 455140 459907 460745 460852 460925 465412 465525 466023 467512 470762 471061 471416 475452 475658 476252 476271 476285 476339 477981 478017 479027 482490 484405 484587 484702 485576 489484 496864 498822 499423 502749 513609 518876 519141 522771 532135 536273 546680 549639 551254 557977 558009 559009 560558 561871 563072 576342 591595 603663 716030 726478 726565 726574 726753 728964 731137 732725 733832 738404 739739 740136 742812 742889 743679 761979 764593 780667 795041 796084 796109 801514 802186 802730 806324 810566 826645 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur young boy"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск young парен"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск young парен"
]
|
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.