Query Metrics
7
Database Queries
7
Different statements
181.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.39 ms (88.32%) |
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 398001 409723 422069 424099 450845 455642 465918 477255 481351 488517 489269 490211 490356 491648 496800 507332 513460 514257 533470 541995 553004 556127 556145 556162 560501 570410 577920 586298 592180 598792 598818 604975 605275 605691 608091 608603 614683 620513 623872 625110 625839 626528 630702 632843 632909 637692 638490 652380 659367 665333 678732 679648 680466 680846 693675 698234 705375 707451 708209 708294 710647 714011 722552 724576 725350 728138 729339 729540 732655 735437 737253 738799 740313 742054 743037 745462 748545 753623 753933 754883 757921 758256 758671 759679 761632 762059 765887 767611 770087 770740 774345 784038 785824 786344 791500 792749 794218 794807 797851 798403 803446 805187 807259 809661 809974 810925 811771 812184 812713 813143 813815 813878 814011 814492 814714 819902 821763 821777 825884 827909 ] |
||||||||||||||||||||||||||||||
|
12.09 ms (6.66%) |
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 821763 821777 708209 722552 665333 680846 604975 623872 632909 813143 725350 728138 797851 798403 732655 743037 770740 748545 770087 698234 556145 491648 813878 556127 708294 626528 794218 809974 812184 762059 745462 738799 758256 785824 553004 577920 632843 791500 729339 608091 638490 786344 740313 630702 455642 465918 507332 605691 807259 625839 489269 814011 819902 533470 659367 707451 705375 592180 620513 810925 753933 794807 737253 759679 724576 735437 758671 774345 729540 812713 477255 556162 637692 481351 409723 424099 814714 813815 811771 805187 757921 765887 614683 710647 784038 809661 488517 792749 490211 496800 814492 827909 570410 541995 693675 652380 679648 586298 598792 761632 422069 450845 514257 678732 680466 608603 767611 803446 490356 513460 398001 560501 598818 825884 714011 625110 605275 742054 753623 754883 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.31%) |
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 398001 409723 422069 424099 450845 455642 465918 477255 481351 488517 489269 490211 490356 491648 496800 507332 513460 514257 533470 541995 553004 556127 556145 556162 560501 570410 577920 586298 592180 598792 598818 604975 605275 605691 608091 608603 614683 620513 623872 625110 625839 626528 630702 632843 632909 637692 638490 652380 659367 665333 678732 679648 680466 680846 693675 698234 705375 707451 708209 708294 710647 714011 722552 724576 725350 728138 729339 729540 732655 735437 737253 738799 740313 742054 743037 745462 748545 753623 753933 754883 757921 758256 758671 759679 761632 762059 765887 767611 770087 770740 774345 784038 785824 786344 791500 792749 794218 794807 797851 798403 803446 805187 807259 809661 809974 810925 811771 812184 812713 813143 813815 813878 814011 814492 814714 819902 821763 821777 825884 827909 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"alone girl"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"alone девушк"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"alone девушк"
]
|
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.