Query Metrics
7
Database Queries
7
Different statements
270.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
245.14 ms (90.65%) |
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 11393 397065 415257 417952 421660 423767 424165 428385 429945 437710 441397 443120 443549 445274 446634 447432 448588 452896 458778 465908 467889 468757 469917 470187 471978 474590 475894 477004 477734 482532 484057 484278 485629 488725 489875 490788 491926 491941 492746 501653 501718 503947 505021 517864 518279 518921 527860 528639 541303 552131 556442 560478 560645 561621 561710 561929 562265 563618 565402 565954 568897 570494 572687 574540 575770 579580 581617 595375 597501 597823 597982 598084 598721 598782 598822 600128 610183 611498 641737 652978 653561 654317 654403 655346 656045 657057 658728 673178 676498 677341 677356 678580 679084 679105 679375 680808 685537 685807 686414 716036 718638 721373 722825 724713 725110 727669 734986 743170 748334 748738 751189 753444 754199 758993 761488 773665 778374 814081 814556 820162 ] |
||||||||||||||||||||||||||||||
|
14.83 ms (5.48%) |
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 753444 541303 598822 598721 598782 595375 722825 445274 484057 501718 528639 814556 652978 600128 598084 610183 443120 527860 561929 581617 657057 448588 458778 424165 11393 397065 437710 488725 814081 820162 556442 563618 568897 654317 654403 658728 676498 677341 678580 679375 685537 718638 721373 686414 653561 655346 656045 673178 679084 679105 680808 685807 716036 597823 611498 725110 743170 751189 758993 727669 724713 748738 754199 734986 748334 761488 773665 641737 778374 446634 471978 579580 429945 518921 482532 489875 560645 561621 572687 574540 575770 677356 560478 561710 562265 565402 428385 475894 421660 443549 467889 468757 474590 477004 477734 415257 423767 441397 447432 452896 465908 469917 470187 518279 485629 490788 517864 491926 491941 492746 501653 505021 484278 503947 597982 597501 417952 552131 565954 570494 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (0.98%) |
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 11393 397065 415257 417952 421660 423767 424165 428385 429945 437710 441397 443120 443549 445274 446634 447432 448588 452896 458778 465908 467889 468757 469917 470187 471978 474590 475894 477004 477734 482532 484057 484278 485629 488725 489875 490788 491926 491941 492746 501653 501718 503947 505021 517864 518279 518921 527860 528639 541303 552131 556442 560478 560645 561621 561710 561929 562265 563618 565402 565954 568897 570494 572687 574540 575770 579580 581617 595375 597501 597823 597982 598084 598721 598782 598822 600128 610183 611498 641737 652978 653561 654317 654403 655346 656045 657057 658728 673178 676498 677341 677356 678580 679084 679105 679375 680808 685537 685807 686414 716036 718638 721373 722825 724713 725110 727669 734986 743170 748334 748738 751189 753444 754199 758993 761488 773665 778374 814081 814556 820162 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny anal russian"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые анал русск"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые анал русск"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.58%) |
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.