Query Metrics
7
Database Queries
7
Different statements
181.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.46 ms (86.86%) |
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 199058 281431 382028 382294 388638 389794 392864 397836 409369 414595 421053 423364 439103 450683 453209 453210 469741 473278 503298 504078 517360 524058 529025 530968 531767 550724 553560 554623 559981 574319 581542 581675 584219 595067 599347 605791 611207 611260 613943 614559 617571 621004 628562 630419 640483 641422 641536 650719 652169 654693 658939 662867 669655 672212 684843 684855 684888 684891 691686 697660 702354 702910 706553 708974 711737 719401 719535 721486 732063 736051 738300 741500 742454 742914 743259 744138 744139 747183 748497 749584 750362 751018 751065 752572 754049 754171 754647 755542 765293 767680 768719 770886 773186 774065 774312 782138 782874 782950 782987 783570 785645 785649 785971 786091 787051 787153 789074 790443 790447 790551 791181 793064 796410 797039 807060 807648 809630 810768 813134 825372 ] |
||||||||||||||||||||||||||||||
|
13.58 ms (7.49%) |
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 789074 732063 751065 721486 531767 791181 750362 281431 473278 503298 517360 553560 550724 581542 650719 654693 669655 672212 684888 684891 662867 684843 684855 574319 584219 640483 641536 641422 611207 613943 617571 630419 782138 807648 785649 786091 755542 785971 790443 796410 809630 741500 748497 749584 754049 738300 742454 767680 742914 747183 754647 768719 736051 702354 702910 711737 785645 787153 790447 797039 813134 782950 743259 793064 783570 765293 388638 450683 529025 524058 423364 439103 414595 469741 453209 605791 389794 504078 787051 719535 599347 628562 782874 782987 392864 382294 825372 453210 559981 581675 697660 708974 719401 621004 595067 810768 744138 752572 770886 790551 807060 751018 754171 774312 773186 744139 774065 397836 382028 409369 199058 421053 530968 658939 691686 652169 706553 554623 611260 614559 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.69%) |
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 199058 281431 382028 382294 388638 389794 392864 397836 409369 414595 421053 423364 439103 450683 453209 453210 469741 473278 503298 504078 517360 524058 529025 530968 531767 550724 553560 554623 559981 574319 581542 581675 584219 595067 599347 605791 611207 611260 613943 614559 617571 621004 628562 630419 640483 641422 641536 650719 652169 654693 658939 662867 669655 672212 684843 684855 684888 684891 691686 697660 702354 702910 706553 708974 711737 719401 719535 721486 732063 736051 738300 741500 742454 742914 743259 744138 744139 747183 748497 749584 750362 751018 751065 752572 754049 754171 754647 755542 765293 767680 768719 770886 773186 774065 774312 782138 782874 782950 782987 783570 785645 785649 785971 786091 787051 787153 789074 790443 790447 790551 791181 793064 796410 797039 807060 807648 809630 810768 813134 825372 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодая девушк мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen girl masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.87%) |
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.