Query Metrics
7
Database Queries
7
Different statements
152.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.74 ms (84.18%) |
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 404395 404399 404406 415958 415992 416718 417414 421899 428160 443913 444638 447407 448096 449592 449679 450881 451574 451602 453921 458307 459584 459663 460043 460792 467735 470206 471593 472094 475179 475252 477533 477665 478893 479633 481248 481956 483202 483815 488131 489188 493269 496354 496454 499333 499593 501219 509139 511637 512167 512992 513248 513661 513719 513995 516466 516731 517637 519397 524536 524908 525692 527028 528430 529449 533801 542984 543766 545681 548117 549532 549813 551451 557252 559242 575703 583757 592971 597720 603036 603044 615984 620073 624482 625711 626495 633959 636434 636592 636633 638429 638605 642813 649609 662556 681546 697008 699916 725339 725719 730320 731446 733068 751971 758024 762388 768186 776154 779190 779618 784981 788342 789968 790742 798053 799704 801226 804914 806212 811029 821848 ] |
||||||||||||||||||||||||||||||
|
14.95 ms (9.78%) |
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 636633 638429 642813 603044 776154 788342 799704 804914 798053 811029 725719 751971 784981 725339 731446 762388 768186 730320 697008 806212 478893 477533 513995 483202 483815 519397 404406 415958 416718 821848 449679 448096 460043 512167 527028 529449 533801 496454 516731 475179 549813 583757 543766 545681 542984 548117 575703 649609 681546 551451 636592 638605 615984 633959 625711 626495 636434 801226 779190 790742 789968 733068 758024 699916 404399 443913 459584 481956 451574 477665 479633 458307 450881 459663 472094 489188 499593 509139 513661 501219 524536 511637 512992 513719 525692 528430 415992 447407 449592 453921 493269 496354 499333 524908 460792 549532 557252 559242 662556 592971 603036 620073 624482 597720 779618 404395 417414 451602 475252 421899 428160 444638 467735 471593 481248 470206 516466 517637 488131 513248 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.66%) |
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 404395 404399 404406 415958 415992 416718 417414 421899 428160 443913 444638 447407 448096 449592 449679 450881 451574 451602 453921 458307 459584 459663 460043 460792 467735 470206 471593 472094 475179 475252 477533 477665 478893 479633 481248 481956 483202 483815 488131 489188 493269 496354 496454 499333 499593 501219 509139 511637 512167 512992 513248 513661 513719 513995 516466 516731 517637 519397 524536 524908 525692 527028 528430 529449 533801 542984 543766 545681 548117 549532 549813 551451 557252 559242 575703 583757 592971 597720 603036 603044 615984 620073 624482 625711 626495 633959 636434 636592 636633 638429 638605 642813 649609 662556 681546 697008 699916 725339 725719 730320 731446 733068 751971 758024 762388 768186 776154 779190 779618 784981 788342 789968 790742 798053 799704 801226 804914 806212 811029 821848 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"xxx met"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"xxx met"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"xxx met"
]
|
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.