Query Metrics
7
Database Queries
7
Different statements
207.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
183.82 ms (88.65%) |
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 401546 411374 433581 437970 452921 461083 466911 469896 475666 475672 475673 475682 475684 476814 485564 494488 507830 510828 513528 513986 515461 517488 524491 526747 529358 529700 531593 535408 537271 538952 542215 544799 545985 546060 546986 554406 556767 561377 570887 570951 573734 576040 578625 579190 585732 586441 587958 594283 595049 598373 604106 607905 610950 614702 614710 618302 628663 648618 649528 661702 665586 667011 669318 669370 670185 672754 679491 679500 679501 687312 692282 697382 699534 700932 708667 710461 710471 710844 714453 735144 738511 741716 741770 742341 742402 742457 744200 748285 751511 751678 752482 757400 757421 757435 757439 757445 758732 770241 772557 777860 778114 778130 781922 782682 784149 784648 785202 788360 791212 793923 796991 800727 800733 800753 800754 801625 803747 806692 812515 812554 ] |
||||||||||||||||||||||||||||||
|
13.74 ms (6.62%) |
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 513986 537271 494488 515461 517488 531593 538952 546986 570887 570951 576040 542215 556767 561377 579190 544799 546060 648618 661702 679500 692282 697382 699534 700932 667011 669318 669370 670185 672754 679491 687312 649528 665586 679501 708667 710461 710844 714453 545985 554406 578625 587958 598373 610950 614702 585732 607905 628663 586441 604106 618302 594283 595049 777860 778114 784149 800727 791212 793923 800753 806692 741716 741770 752482 772557 782682 785202 788360 800754 812515 812554 748285 751511 742341 751678 758732 738511 742402 744200 757400 757439 757445 770241 735144 742457 757421 757435 614710 710471 778130 781922 784648 796991 800733 801625 803747 433581 452921 401546 411374 437970 469896 461083 476814 526747 529700 535408 513528 507830 510828 573734 485564 475666 475672 475684 466911 475673 475682 529358 524491 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.23%) |
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 401546 411374 433581 437970 452921 461083 466911 469896 475666 475672 475673 475682 475684 476814 485564 494488 507830 510828 513528 513986 515461 517488 524491 526747 529358 529700 531593 535408 537271 538952 542215 544799 545985 546060 546986 554406 556767 561377 570887 570951 573734 576040 578625 579190 585732 586441 587958 594283 595049 598373 604106 607905 610950 614702 614710 618302 628663 648618 649528 661702 665586 667011 669318 669370 670185 672754 679491 679500 679501 687312 692282 697382 699534 700932 708667 710461 710471 710844 714453 735144 738511 741716 741770 742341 742402 742457 744200 748285 751511 751678 752482 757400 757421 757435 757439 757445 758732 770241 772557 777860 778114 778130 781922 782682 784149 784648 785202 788360 791212 793923 796991 800727 800733 800753 800754 801625 803747 806692 812515 812554 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"short hair solo"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"short hair соло"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"short hair соло"
]
|
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.