Query Metrics
7
Database Queries
7
Different statements
155.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.86 ms (81.64%) |
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 13875 21279 28382 79570 177739 187048 384363 391224 397465 401547 401560 401811 403373 405074 408262 419123 420082 421526 426416 445543 445641 446505 457165 458117 459857 464168 468651 468868 477210 492712 507680 515131 516040 521001 522138 526540 528076 528397 530499 533019 537672 537683 540028 545470 552066 553070 560199 561980 571213 580079 582531 583507 583670 585139 594802 597762 604513 618596 623199 623203 623264 626729 630221 632936 634801 636258 641683 643895 648572 650174 650380 666388 671893 674927 677963 682531 682854 702146 714275 718265 726926 731467 731968 734990 737589 740035 747186 753208 760579 760989 767281 770893 771916 772675 773986 774559 788096 793461 797456 798205 800177 801320 801358 802603 804977 808081 809334 809508 810215 810272 810576 811530 811986 812865 813693 814651 814901 815014 ] |
||||||||||||||||||||||||||||||
|
17.03 ms (10.96%) |
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 677963 650174 714275 468868 618596 468651 426416 643895 641683 526540 582531 457165 583670 809508 421526 537672 464168 545470 674927 561980 530499 604513 553070 459857 522138 528076 630221 419123 405074 682531 580079 623203 408262 585139 516040 814901 528397 671893 445543 446505 560199 492712 571213 623264 634801 583507 507680 552066 650380 477210 445641 515131 623199 521001 594802 397465 747186 718265 773986 788096 731467 79570 810272 702146 811986 760579 770893 177739 801320 21279 801358 740035 810576 767281 766674 384363 401560 597762 814651 813693 537683 540028 648572 760989 632936 682854 13875 391224 420082 774419 815014 666388 811530 726926 771916 734990 810215 774559 802603 731968 28382 401547 533019 626729 812865 798205 809334 187048 458117 403373 793461 401811 636258 800177 804977 808081 737589 753208 772675 797456 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (2.13%) |
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 13875 21279 28382 79570 177739 187048 384363 391224 397465 401547 401560 401811 403373 405074 408262 419123 420082 421526 426416 445543 445641 446505 457165 458117 459857 464168 468651 468868 477210 492712 507680 515131 516040 521001 522138 526540 528076 528397 530499 533019 537672 537683 540028 545470 552066 553070 560199 561980 571213 580079 582531 583507 583670 585139 594802 597762 604513 618596 623199 623203 623264 626729 630221 632936 634801 636258 641683 643895 648572 650174 650380 666388 671893 674927 677963 682531 682854 702146 714275 718265 726926 731467 731968 734990 737589 740035 747186 753208 760579 760989 767281 770893 771916 772675 773986 774559 788096 793461 797456 798205 800177 801320 801358 802603 804977 808081 809334 809508 810215 810272 810576 811530 811986 812865 813693 814651 814901 815014 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina sex"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская секс"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская секс"
]
|
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.