Query Metrics
7
Database Queries
7
Different statements
245.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
222.29 ms (90.36%) |
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 382805 415029 415452 426426 428616 443824 446551 456030 458069 466288 468778 469248 470995 471007 471030 474096 477556 485363 487352 487618 488993 491402 505353 505384 510662 510938 510944 512518 515258 515883 517929 519818 520841 521486 524639 525468 526732 536279 541422 541479 543242 544468 544475 544898 546039 554459 557468 557720 558314 559412 560403 560672 562979 571214 576692 577666 580121 582382 584053 584974 585308 586688 590958 591161 592985 595367 602466 603359 606254 614810 623544 623840 629815 637245 660013 661424 664504 666672 690410 694098 697307 702906 703909 715687 726641 726723 730839 734590 734976 736339 736539 740105 744003 744225 745629 748679 765134 771560 772573 794425 804005 810463 814611 815120 815372 815845 815872 816618 816826 817064 817112 817851 817883 818351 819185 819773 821023 823502 825051 ] |
||||||||||||||||||||||||||||||
|
13.12 ms (5.33%) |
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 730839 734590 765134 726723 736339 736539 744003 744225 745629 748679 726641 734976 740105 697307 702906 703909 715687 794425 810463 428616 584053 477556 524639 510938 510944 519818 512518 515258 544468 544898 554459 557720 560403 557468 558314 562979 541479 577666 580121 660013 666672 690410 661424 694098 559412 582382 585308 592985 602466 586688 590958 591161 623840 637245 629815 796642 772573 614810 415452 456030 525468 466288 816826 469248 470995 446551 468778 487352 474096 505353 487618 488993 544475 546039 576692 560672 664504 571214 584974 606254 603359 595367 771560 382805 415029 458069 443824 471007 471030 510662 515883 521486 505384 485363 541422 426426 517929 804005 623544 526732 520841 817112 817851 817064 817883 818351 819773 823502 814611 815372 819185 825051 815120 815845 815872 816618 821023 536279 491402 543242 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.07%) |
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 382805 415029 415452 426426 428616 443824 446551 456030 458069 466288 468778 469248 470995 471007 471030 474096 477556 485363 487352 487618 488993 491402 505353 505384 510662 510938 510944 512518 515258 515883 517929 519818 520841 521486 524639 525468 526732 536279 541422 541479 543242 544468 544475 544898 546039 554459 557468 557720 558314 559412 560403 560672 562979 571214 576692 577666 580121 582382 584053 584974 585308 586688 590958 591161 592985 595367 602466 603359 606254 614810 623544 623840 629815 637245 660013 661424 664504 666672 690410 694098 697307 702906 703909 715687 726641 726723 730839 734590 734976 736339 736539 740105 744003 744225 745629 748679 765134 771560 772573 794425 804005 810463 814611 815120 815372 815845 815872 816618 816826 817064 817112 817851 817883 818351 819185 819773 821023 823502 825051 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"long hairy pussy"
]
|
||||||||||||||||||||||||||||||
|
2.21 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"длинные волосатая pussy"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"длинные волосатая pussy"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.68%) |
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.