Query Metrics
7
Database Queries
7
Different statements
180.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.84 ms (86.69%) |
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 47220 338731 386041 386650 388379 396563 397519 397988 425320 434492 467632 482154 501499 517691 529120 529649 530078 530384 530486 530487 530503 531155 532245 532913 535091 535505 536806 537203 537670 538074 538241 538910 540405 540983 542698 542699 544287 548116 554257 555850 556054 557238 559162 563854 567343 573926 576588 581960 583067 587751 595707 604021 615440 615894 630526 630546 631009 631972 632261 632978 633124 633458 641881 644757 645284 645858 646029 646242 646427 655719 658192 659521 664447 666876 669704 674927 676024 676097 678128 684106 695181 706454 709079 711558 711566 716416 717175 717219 717678 720018 725333 737306 737657 738430 746320 749144 750238 753894 758023 764748 770201 784461 784492 810006 813121 821241 821411 821689 822393 822458 822575 822667 822822 822941 823305 823342 823565 823758 825213 826530 ] |
||||||||||||||||||||||||||||||
|
14.63 ms (8.09%) |
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 530384 530486 530503 535505 532913 537203 530487 537670 540405 559162 556054 567343 573926 645858 646242 674927 676024 646029 666876 676097 678128 631972 615440 630526 633124 633458 425320 434492 467632 501499 386650 386041 822458 823565 822393 821411 823342 538074 538910 542699 658192 717678 720018 709079 554257 615894 631009 810006 725333 750238 784492 753894 737657 738430 770201 749144 644757 388379 531155 695181 630546 532245 645284 646427 632261 604021 632978 536806 482154 581960 746320 396563 544287 548116 542698 583067 669704 684106 711558 717219 641881 784461 813121 737306 764748 529120 535091 563854 555850 557238 587751 595707 706454 758023 338731 47220 397519 397988 822941 823758 826530 822667 822822 823305 821241 821689 822575 825213 517691 529649 538241 530078 540983 576588 711566 716416 717175 655719 659521 664447 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (1.87%) |
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 47220 338731 386041 386650 388379 396563 397519 397988 425320 434492 467632 482154 501499 517691 529120 529649 530078 530384 530486 530487 530503 531155 532245 532913 535091 535505 536806 537203 537670 538074 538241 538910 540405 540983 542698 542699 544287 548116 554257 555850 556054 557238 559162 563854 567343 573926 576588 581960 583067 587751 595707 604021 615440 615894 630526 630546 631009 631972 632261 632978 633124 633458 641881 644757 645284 645858 646029 646242 646427 655719 658192 659521 664447 666876 669704 674927 676024 676097 678128 684106 695181 706454 709079 711558 711566 716416 717175 717219 717678 720018 725333 737306 737657 738430 746320 749144 750238 753894 758023 764748 770201 784461 784492 810006 813121 821241 821411 821689 822393 822458 822575 822667 822822 822941 823305 823342 823565 823758 825213 826530 ] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc sperm"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc сперм"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc сперм"
]
|
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.