Query Metrics
7
Database Queries
7
Different statements
216.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
194.62 ms (89.89%) |
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 494718 514470 522695 532050 532053 538271 539381 539915 544337 544349 544350 549258 552599 559605 565545 566522 566984 568018 579950 646343 650002 650951 652252 653220 653737 654619 654717 655062 656361 656751 657420 657434 658014 658296 659642 661670 661905 663377 663502 664492 666769 669344 670313 670486 674256 674536 675514 675742 678763 680036 682600 683536 683608 683774 683804 684101 684203 684583 685355 685562 685612 686065 686700 687187 687492 689323 689579 691197 691827 693217 693433 694540 694541 695849 696260 696272 697168 697288 697299 699009 702084 702087 702674 704722 704788 704877 706298 706321 708399 708431 709703 709982 710959 712919 712982 713441 715300 715326 715415 716468 716482 719342 719997 720376 720505 720634 720766 722656 722658 815888 818073 818379 819376 819993 821699 822137 823534 823915 827889 827964 ] |
||||||||||||||||||||||||||||||
|
12.45 ms (5.75%) |
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 815888 818073 818379 819376 819993 821699 822137 823534 823915 827889 827964 522695 532053 514470 494718 532050 538271 539381 539915 552599 566522 579950 544337 549258 565545 566984 544349 544350 559605 568018 650951 652252 653220 653737 655062 657420 657434 664492 670313 675514 680036 683536 683608 683774 683804 684101 685355 685612 686700 691197 697288 697299 699009 706298 708399 708431 713441 715326 716468 716482 719997 720376 720505 720634 646343 654717 658296 659642 661905 663377 663502 666769 669344 674256 675742 678763 682600 684583 685562 686065 687492 689579 691827 694541 696260 697168 704877 706321 715300 715415 719342 720766 722656 722658 650002 654619 656361 656751 658014 661670 670486 674536 684203 687187 689323 693217 693433 694540 695849 696272 702084 702087 702674 704722 704788 709703 709982 710959 712919 712982 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.37%) |
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 494718 514470 522695 532050 532053 538271 539381 539915 544337 544349 544350 549258 552599 559605 565545 566522 566984 568018 579950 646343 650002 650951 652252 653220 653737 654619 654717 655062 656361 656751 657420 657434 658014 658296 659642 661670 661905 663377 663502 664492 666769 669344 670313 670486 674256 674536 675514 675742 678763 680036 682600 683536 683608 683774 683804 684101 684203 684583 685355 685562 685612 686065 686700 687187 687492 689323 689579 691197 691827 693217 693433 694540 694541 695849 696260 696272 697168 697288 697299 699009 702084 702087 702674 704722 704788 704877 706298 706321 708399 708431 709703 709982 710959 712919 712982 713441 715300 715326 715415 716468 716482 719342 719997 720376 720505 720634 720766 722656 722658 815888 818073 818379 819376 819993 821699 822137 823534 823915 827889 827964 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old young and"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old young"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.69%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old young"
]
|
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.