Query Metrics
7
Database Queries
7
Different statements
184.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.51 ms (85.84%) |
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 413044 415109 415954 416989 420125 420291 421234 421520 439534 443323 448878 463808 486975 491873 493128 493477 494274 496270 499174 500634 501104 503405 509560 510396 513575 514800 515972 516769 520778 521579 522521 522871 524018 525731 525864 528682 529530 530030 530306 530369 530479 530495 530703 530763 531097 531251 532762 532843 533536 533727 533982 534199 534480 534928 534988 536403 536676 537114 537184 537584 540317 541584 541848 542167 543657 543860 544825 546816 558218 559197 560871 561132 561296 566316 573345 576055 578299 582644 586889 588798 593502 626096 628245 634138 634784 637882 642359 647003 649596 665922 669003 669585 677920 683012 683560 692967 695469 706929 710316 711269 716751 765593 765752 769119 770258 781063 788950 789128 791106 793724 795061 796769 797949 802106 802516 810414 810581 814075 815023 817750 ] |
||||||||||||||||||||||||||||||
|
14.77 ms (8.00%) |
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 791106 817750 534199 533536 665922 710316 716751 647003 711269 677920 588798 628245 637882 793724 796769 769119 509560 413044 415109 421520 420125 448878 530030 530479 532843 503405 516769 520778 534988 513575 531251 536403 521579 528682 531097 532762 537114 537584 544825 649596 634138 415954 421234 463808 496270 533727 493477 522871 525864 493128 529530 561132 642359 586889 797949 814075 815023 530306 501104 534928 540317 543657 558218 566316 576055 542167 546816 683012 669585 683560 560871 593502 626096 788950 789128 795061 810581 802106 802516 810414 770258 765593 781063 486975 491873 559197 765752 499174 522521 561296 420291 443323 416989 515972 525731 536676 510396 524018 530703 537184 530763 514800 530495 533982 543860 541848 634784 439534 530369 494274 500634 534480 541584 573345 578299 582644 669003 692967 695469 706929 ] |
||||||||||||||||||||||||||||||
|
4.45 ms (2.41%) |
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 413044 415109 415954 416989 420125 420291 421234 421520 439534 443323 448878 463808 486975 491873 493128 493477 494274 496270 499174 500634 501104 503405 509560 510396 513575 514800 515972 516769 520778 521579 522521 522871 524018 525731 525864 528682 529530 530030 530306 530369 530479 530495 530703 530763 531097 531251 532762 532843 533536 533727 533982 534199 534480 534928 534988 536403 536676 537114 537184 537584 540317 541584 541848 542167 543657 543860 544825 546816 558218 559197 560871 561132 561296 566316 573345 576055 578299 582644 586889 588798 593502 626096 628245 634138 634784 637882 642359 647003 649596 665922 669003 669585 677920 683012 683560 692967 695469 706929 710316 711269 716751 765593 765752 769119 770258 781063 788950 789128 791106 793724 795061 796769 797949 802106 802516 810414 810581 814075 815023 817750 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bondage hardcore"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.86%) |
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.