Query Metrics
7
Database Queries
7
Different statements
352.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.42 ms (59.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
123.08 ms (34.90%) |
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 450663 452552 459215 461790 470462 475347 495585 498436 507018 509585 516016 517573 517719 518415 526013 527727 532367 533118 533257 535868 536043 538527 545671 552555 553312 562564 565546 568632 571959 586323 590238 602760 612877 615275 616827 618458 622758 627142 627345 627639 629179 633252 635893 640315 641781 642821 643658 644024 644143 650364 650968 657469 660649 667796 674229 676430 680933 686414 689155 690265 690621 697844 698081 698344 699209 702274 709952 715596 716312 716428 718487 725721 727230 727343 727889 728839 729235 730672 733521 734907 735674 736955 737378 745464 745956 746914 747877 750768 756369 757754 757763 761397 763563 766341 775441 776672 778978 779347 779387 780208 782312 787394 788332 793659 795203 795937 796611 798629 798778 798915 800414 801029 812108 814100 819961 823883 824541 826085 827652 ] |
||||||||||||||||||||||||||||||
|
11.63 ms (3.30%) |
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 746914 702274 718487 778978 779387 780208 475347 516016 553312 828293 571959 545671 716428 667796 616827 602760 643658 793659 730672 736955 735674 725721 756369 795203 800414 495585 527727 532367 660649 798778 727343 757763 727230 733521 716312 689155 763563 826085 814100 819961 824541 827652 823883 452552 450663 459215 650364 698344 650968 697844 552555 568632 640315 618458 627639 627345 776672 750768 761397 787394 729235 727889 734907 757754 747877 633252 715596 775441 779347 812108 461790 509585 507018 526013 498436 470462 517719 533257 536043 517573 533118 518415 535868 538527 565546 657469 674229 686414 699209 676430 680933 690265 690621 698081 709952 562564 615275 622758 644143 627142 635893 644024 590238 612877 586323 629179 641781 642821 782312 795937 798629 788332 796611 801029 766341 798915 728839 737378 745464 745956 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (0.89%) |
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 450663 452552 459215 461790 470462 475347 495585 498436 507018 509585 516016 517573 517719 518415 526013 527727 532367 533118 533257 535868 536043 538527 545671 552555 553312 562564 565546 568632 571959 586323 590238 602760 612877 615275 616827 618458 622758 627142 627345 627639 629179 633252 635893 640315 641781 642821 643658 644024 644143 650364 650968 657469 660649 667796 674229 676430 680933 686414 689155 690265 690621 697844 698081 698344 699209 702274 709952 715596 716312 716428 718487 725721 727230 727343 727889 728839 729235 730672 733521 734907 735674 736955 737378 745464 745956 746914 747877 750768 756369 757754 757763 761397 763563 766341 775441 776672 778978 779347 779387 780208 782312 787394 788332 793659 795203 795937 796611 798629 798778 798915 800414 801029 812108 814100 819961 823883 824541 826085 827652 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife and neighbor"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен neighbor"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен neighbor"
]
|
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.