Query Metrics
7
Database Queries
7
Different statements
149.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.96 ms (80.87%) |
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 390207 397037 408465 411313 419013 420159 428452 451634 453483 454785 456965 461531 461552 461801 465118 467321 470943 477575 479865 483209 484180 486837 487889 491587 506492 509746 509773 510698 512246 514285 518321 519580 522236 524049 526027 526298 552668 555647 569539 573780 575467 580275 583821 586397 586677 588315 588323 590406 591667 592618 595278 595925 603969 611669 612512 615315 616602 618001 619955 622665 626434 627063 628622 629972 630562 633737 634162 634314 634826 635185 637673 641096 643396 645232 647372 647669 649571 652240 661463 661563 662385 675125 682869 684765 687527 687937 695070 696480 698030 698883 699482 707289 714623 714900 715537 716954 718962 721408 722069 725411 727808 729821 744711 750893 751971 753963 756918 758608 759325 761722 762930 776822 778471 779247 785148 786258 799130 803076 803485 810706 ] |
||||||||||||||||||||||||||||||
|
17.53 ms (11.72%) |
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 698883 699482 718962 649571 661563 662385 675125 684765 695070 696480 707289 714623 714900 721408 645232 647372 647669 652240 661463 682869 687527 687937 715537 716954 722069 552668 555647 569539 573780 575467 580275 583821 588323 595925 615315 626434 633737 592618 595278 611669 612512 634314 643396 586397 603969 616602 622665 628622 629972 635185 637673 586677 588315 590406 591667 619955 627063 630562 634826 778471 785148 810706 776822 779247 803076 751971 799130 727808 762930 758608 729821 750893 759325 761722 725411 744711 753963 756918 618001 634162 641096 698030 786258 803485 397037 420159 451634 390207 419013 456965 461801 477575 461552 465118 470943 479865 408465 454785 411313 428452 453483 461531 467321 509773 510698 514285 518321 524049 526298 483209 484180 491587 512246 486837 506492 519580 522236 526027 487889 509746 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.82%) |
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 390207 397037 408465 411313 419013 420159 428452 451634 453483 454785 456965 461531 461552 461801 465118 467321 470943 477575 479865 483209 484180 486837 487889 491587 506492 509746 509773 510698 512246 514285 518321 519580 522236 524049 526027 526298 552668 555647 569539 573780 575467 580275 583821 586397 586677 588315 588323 590406 591667 592618 595278 595925 603969 611669 612512 615315 616602 618001 619955 622665 626434 627063 628622 629972 630562 633737 634162 634314 634826 635185 637673 641096 643396 645232 647372 647669 649571 652240 661463 661563 662385 675125 682869 684765 687527 687937 695070 696480 698030 698883 699482 707289 714623 714900 715537 716954 718962 721408 722069 725411 727808 729821 744711 750893 751971 753963 756918 758608 759325 761722 762930 776822 778471 779247 785148 786258 799130 803076 803485 810706 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"new cock"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"new cock"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"new cock"
]
|
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.