Query Metrics
7
Database Queries
7
Different statements
398.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.44 ms (52.08%) |
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 6609 6656 24944 385225 387160 398811 400834 401456 406210 406361 406372 406641 406688 410651 411307 411804 412991 415591 420308 423505 426434 426475 428220 428583 431504 432675 433002 433132 433507 439822 440032 441057 441063 441841 444022 445103 446022 446079 448845 450791 452832 454420 454777 457429 457943 458001 458965 460330 463840 464042 464617 464951 465062 465528 467946 468148 469260 470434 473450 475837 476117 476136 476166 483561 487711 503256 519071 524798 526449 531279 533733 534552 545250 545461 547471 555056 555337 568060 592587 595309 596886 602602 604497 619652 624753 635450 716897 720357 722442 723573 726877 729280 731312 733677 737554 744975 752589 759401 761754 765567 765729 767194 778139 780799 788450 791419 800360 802925 814754 815142 815542 815751 815927 816529 817242 817786 820559 820641 822002 825304 ] |
||||||||||||||||||||||||||||||
|
164.08 ms (41.20%) |
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 6609 6656 24944 385225 387160 398811 400834 401456 406210 406361 406372 406641 406688 410651 411307 411804 412991 415591 420308 423505 426434 426475 428220 428583 431504 432675 433002 433132 433507 439822 440032 441057 441063 441841 444022 445103 446022 446079 448845 450791 452832 454420 454777 457429 457943 458001 458965 460330 463840 464042 464617 464951 465062 465528 467946 468148 469260 470434 473450 475837 476117 476136 476166 483561 487711 503256 519071 524798 526449 531279 533733 534552 545250 545461 547471 555056 555337 568060 592587 595309 596886 602602 604497 619652 624753 635450 716897 720357 722442 723573 726877 729280 731312 733677 737554 744975 752589 759401 761754 765567 765729 767194 778139 780799 788450 791419 800360 802925 814754 815142 815542 815751 815927 816529 817242 817786 820559 820641 822002 825304 ] |
||||||||||||||||||||||||||||||
|
18.65 ms (4.68%) |
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 716897 780799 788450 802925 24944 433132 6656 448845 604497 454777 476117 439822 454420 6609 398811 816529 817786 820559 815542 815751 815142 722442 635450 778139 761754 767194 791419 800360 731312 737554 729280 733677 765729 720357 387160 406361 441841 460330 473450 531279 533733 503256 534552 464951 476166 568060 545250 555337 547471 624753 592587 744975 465062 423505 519071 765567 428583 433002 433507 411804 420308 431504 467946 595309 465528 415591 814754 468148 555056 446022 445103 545461 483561 444022 411307 426434 440032 458001 463840 401456 476136 457429 487711 406210 464042 602602 406688 410651 426475 825304 723573 817242 820641 822002 815927 469260 446079 526449 524798 619652 596886 759401 752589 726877 385225 400834 406641 406372 412991 432675 441057 428220 441063 452832 457943 470434 450791 475837 458965 464617 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf oil anal"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf масл анал"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf масл анал"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.45%) |
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.