Query Metrics
7
Database Queries
7
Different statements
157.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.21 ms (80.22%) |
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 129640 191356 385970 388764 400185 404582 406303 409774 429775 443748 444238 444736 450849 456618 457783 460731 464664 466074 467712 468071 468611 469434 469766 470585 470917 476128 482512 482938 484017 484090 484387 484557 484690 487729 494289 496101 501248 506051 510396 510750 512057 521418 524858 526133 526553 528435 531155 532839 532975 533014 534631 535016 536287 536289 536291 540483 541379 541588 541698 541721 541833 541863 542187 556046 569922 576726 582540 583989 586419 598024 599880 599913 599955 599961 600006 600014 600019 600296 603163 603205 603693 604569 604890 609953 611558 617427 619407 619830 628332 628336 630552 631194 632258 632585 632642 633491 634218 635800 636033 637036 637092 637148 637438 639719 639774 639818 641698 641700 642039 645012 662137 675020 676428 678117 679019 686843 687461 716870 725598 803459 ] |
||||||||||||||||||||||||||||||
|
20.62 ms (13.11%) |
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 460731 632258 540483 541698 645012 457783 641698 598024 604569 532839 583989 582540 603205 631194 456618 444736 512057 429775 541863 678117 569922 600296 641700 599913 599961 633491 600019 619830 494289 482938 637438 599955 468071 400185 482512 510750 526133 496101 662137 637092 501248 603693 191356 385970 609953 611558 628336 487729 536291 628332 716870 803459 443748 521418 484090 603163 725598 467712 635800 542187 484690 541379 470585 637036 510396 639818 556046 636033 679019 535016 528435 409774 533014 632585 388764 526553 464664 470917 406303 476128 469766 524858 466074 450849 484017 484557 536289 687461 444238 469434 536287 129640 534631 576726 675020 404582 604890 468611 541721 541833 642039 617427 541588 506051 484387 532975 676428 639719 586419 637148 531155 686843 599880 600014 600006 632642 630552 634218 639774 619407 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (2.19%) |
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 129640 191356 385970 388764 400185 404582 406303 409774 429775 443748 444238 444736 450849 456618 457783 460731 464664 466074 467712 468071 468611 469434 469766 470585 470917 476128 482512 482938 484017 484090 484387 484557 484690 487729 494289 496101 501248 506051 510396 510750 512057 521418 524858 526133 526553 528435 531155 532839 532975 533014 534631 535016 536287 536289 536291 540483 541379 541588 541698 541721 541833 541863 542187 556046 569922 576726 582540 583989 586419 598024 599880 599913 599955 599961 600006 600014 600019 600296 603163 603205 603693 604569 604890 609953 611558 617427 619407 619830 628332 628336 630552 631194 632258 632585 632642 633491 634218 635800 636033 637036 637092 637148 637438 639719 639774 639818 641698 641700 642039 645012 662137 675020 676428 678117 679019 686843 687461 716870 725598 803459 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"милфы в групповухе и Ñ%…"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"милф в группов секс"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"милф в группов секс"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.99%) |
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.