Query Metrics
7
Database Queries
7
Different statements
146.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.20 ms (85.49%) |
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 33443 385437 390754 425526 445080 457639 458506 464964 474456 478106 483539 491225 491244 492399 492426 492441 497792 505342 505350 509176 517540 519753 529841 529877 530398 530651 530668 531632 532202 533115 536772 537384 538696 538730 538731 538743 538770 544799 550040 554953 555597 557496 557513 558165 561494 562150 562717 576468 580333 585475 586355 588230 590306 599473 600414 601153 602295 604988 609376 615074 617065 617816 618020 619902 620344 626369 631615 633190 636028 640996 642962 647133 648005 650435 651066 662446 678924 687616 703950 714369 714386 715473 738297 754626 770173 774740 778563 781831 781862 781865 781957 788802 794471 798457 807012 807878 808951 811267 813729 813753 816702 819257 819437 819641 819643 823774 823781 824042 824106 824120 824634 826388 826497 826602 826603 827243 827399 827630 827736 ] |
||||||||||||||||||||||||||||||
|
12.04 ms (8.22%) |
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 714386 555597 562150 602295 633190 617816 715473 576468 550040 788802 781865 492399 519753 531632 590306 33443 662446 588230 600414 808951 636028 816702 824634 492426 492441 457639 491225 474456 509176 538743 537384 538770 538696 557496 562717 557513 580333 687616 703950 650435 647133 651066 678924 554953 561494 585475 599473 604988 620344 626369 586355 604910 618020 619902 601153 615074 642962 781957 807012 811267 774740 798457 794471 754626 738297 770173 609376 617065 640996 781831 807878 425526 458506 445080 464964 505342 631615 781862 478106 505350 558165 544799 648005 714369 778563 517540 385437 390754 823774 823781 826497 826388 826602 826603 824120 827243 827630 827399 813729 819641 824106 813753 819257 819437 819643 824042 827736 483539 491244 497792 529841 529877 530398 530668 532202 533115 536772 538730 538731 530651 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.55%) |
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 33443 385437 390754 425526 445080 457639 458506 464964 474456 478106 483539 491225 491244 492399 492426 492441 497792 505342 505350 509176 517540 519753 529841 529877 530398 530651 530668 531632 532202 533115 536772 537384 538696 538730 538731 538743 538770 544799 550040 554953 555597 557496 557513 558165 561494 562150 562717 576468 580333 585475 586355 588230 590306 599473 600414 601153 602295 604988 609376 615074 617065 617816 618020 619902 620344 626369 631615 633190 636028 640996 642962 647133 648005 650435 651066 662446 678924 687616 703950 714369 714386 715473 738297 754626 770173 774740 778563 781831 781862 781865 781957 788802 794471 798457 807012 807878 808951 811267 813729 813753 816702 819257 819437 819641 819643 823774 823781 824042 824106 824120 824634 826388 826497 826602 826603 827243 827399 827630 827736 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"saggy boobs solo"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"saggy boobs соло"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"saggy boobs соло"
]
|
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.