Query Metrics
7
Database Queries
7
Different statements
177.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.88 ms (85.06%) |
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 387490 391371 402661 403066 403588 411823 412627 415551 439616 440828 442805 443669 443733 452942 453099 455910 456695 460009 463214 465353 465369 468389 472868 474056 475781 475889 478679 486590 494870 497867 499352 507031 509580 511250 513518 517121 518600 518908 518948 524371 525376 526164 527158 528655 532932 536421 537147 540794 540802 540803 541416 546934 547328 547577 555129 558610 559068 563175 563425 573388 574456 577634 578187 579840 581597 586965 589673 590192 590281 591353 595609 598890 601014 604184 604313 619508 631970 635222 639742 663263 664322 664504 665273 668690 669062 670360 673142 699338 710424 714322 714443 714459 718556 719097 722322 727743 727771 731177 732248 744300 758114 761039 767130 767175 769645 769959 770494 774333 777580 785426 786254 789690 790842 798743 800906 801764 801948 804210 807597 815600 ] |
||||||||||||||||||||||||||||||
|
16.86 ms (9.50%) |
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 499352 509580 528655 507031 517121 526164 527158 532932 537147 494870 518908 536421 546934 558610 574456 547328 563425 578187 541416 577634 665273 669062 699338 719097 664322 670360 710424 718556 722322 663263 664504 668690 673142 714322 714443 547577 579840 581597 586965 589673 595609 601014 591353 631970 604313 590192 604184 798743 804210 777580 801764 807597 727743 731177 770494 786254 732248 767175 769959 727771 774333 744300 758114 767130 769645 714459 785426 790842 800906 801948 387490 391371 463214 402661 411823 478679 403066 415551 460009 468389 474056 440828 443669 452942 465369 412627 518600 525376 443733 815600 455910 475781 456695 453099 475889 518948 559068 563175 555129 573388 635222 590281 598890 639742 761039 619508 789690 403588 472868 439616 442805 465353 511250 497867 513518 524371 540802 540803 540794 486590 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.44%) |
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 387490 391371 402661 403066 403588 411823 412627 415551 439616 440828 442805 443669 443733 452942 453099 455910 456695 460009 463214 465353 465369 468389 472868 474056 475781 475889 478679 486590 494870 497867 499352 507031 509580 511250 513518 517121 518600 518908 518948 524371 525376 526164 527158 528655 532932 536421 537147 540794 540802 540803 541416 546934 547328 547577 555129 558610 559068 563175 563425 573388 574456 577634 578187 579840 581597 586965 589673 590192 590281 591353 595609 598890 601014 604184 604313 619508 631970 635222 639742 663263 664322 664504 665273 668690 669062 670360 673142 699338 710424 714322 714443 714459 718556 719097 722322 727743 727771 731177 732248 744300 758114 761039 767130 767175 769645 769959 770494 774333 777580 785426 786254 789690 790842 798743 800906 801764 801948 804210 807597 815600 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature sexy"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature sexy"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature sexy"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.85%) |
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.