Query Metrics
7
Database Queries
7
Different statements
166.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.95 ms (85.72%) |
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 395207 397201 398979 437450 439285 444691 446994 448275 448790 451142 451383 452682 452783 455779 457806 458368 461027 462229 466394 472067 480080 485294 485414 489157 496476 499288 504109 507278 509921 510947 511924 514975 516388 517186 519820 520869 523175 523640 524177 524809 528663 530458 536062 538565 546039 548149 554713 555171 556352 556706 557613 559301 560060 560745 563293 568823 569283 573936 584884 585331 609554 612715 614584 615147 621104 623238 623280 628630 641128 642462 643537 650046 651785 653289 661591 664723 668279 669989 670265 670278 672831 675897 690746 696117 705428 706826 708594 710458 710836 714468 715287 715289 719573 720459 722155 730872 738532 739749 740986 741726 742276 746785 749468 750662 751427 751435 755022 758210 776162 778498 781352 782094 785245 792147 795426 800989 813054 825703 826348 828836 ] |
||||||||||||||||||||||||||||||
|
15.21 ms (9.12%) |
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 778498 813054 739749 751427 455779 452682 708594 740986 457806 705428 536062 559301 573936 696117 719573 555171 706826 670278 710458 776162 746785 781352 510947 517186 548149 554713 556352 568823 560745 670265 642462 730872 782094 448790 439285 446994 485294 496476 664723 750662 472067 516388 563293 653289 690746 650046 710836 612715 609554 628630 641128 742276 462229 448275 507278 519820 560060 669989 749468 623280 520869 489157 397201 614584 523175 466394 538565 546039 651785 720459 795426 792147 755022 615147 461027 451142 523640 452783 530458 485414 569283 661591 715287 741726 738532 758210 437450 444691 480080 398979 509921 715289 751435 514975 623238 451383 524177 825703 675897 458368 504109 557613 668279 499288 511924 528663 556706 621104 828836 395207 584884 785245 826348 585331 714468 672831 643537 800989 524809 722155 ] |
||||||||||||||||||||||||||||||
|
2.59 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 395207 397201 398979 437450 439285 444691 446994 448275 448790 451142 451383 452682 452783 455779 457806 458368 461027 462229 466394 472067 480080 485294 485414 489157 496476 499288 504109 507278 509921 510947 511924 514975 516388 517186 519820 520869 523175 523640 524177 524809 528663 530458 536062 538565 546039 548149 554713 555171 556352 556706 557613 559301 560060 560745 563293 568823 569283 573936 584884 585331 609554 612715 614584 615147 621104 623238 623280 628630 641128 642462 643537 650046 651785 653289 661591 664723 668279 669989 670265 670278 672831 675897 690746 696117 705428 706826 708594 710458 710836 714468 715287 715289 719573 720459 722155 730872 738532 739749 740986 741726 742276 746785 749468 750662 751427 751435 755022 758210 776162 778498 781352 782094 785245 792147 795426 800989 813054 825703 826348 828836 ] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy close"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy close"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy close"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.84%) |
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.