Query Metrics
7
Database Queries
7
Different statements
153.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.54 ms (85.18%) |
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 147369 149622 150261 305824 345303 396944 400409 401875 421597 426781 443591 452702 470915 473298 476377 485497 485848 493080 508256 537389 543925 552793 554576 560254 565607 566193 568788 578933 591440 602818 612513 613288 613338 619936 624989 625298 626894 642130 647259 648658 648715 653006 658457 661425 661449 662585 664649 668698 671501 671824 674257 674549 675503 683649 686148 689177 691807 697199 707865 712380 712639 713766 713989 716311 719491 720953 722352 723087 742097 742808 743892 745954 749900 754401 754935 756470 757835 760517 761611 761633 761642 761812 764616 766059 766220 767973 768705 769119 771919 772537 773910 775429 777618 778245 780080 782035 782036 782125 783815 784322 784777 784886 786072 787587 789622 790294 791720 793039 793198 793632 793787 793816 794409 795217 800128 802000 802073 810083 811828 812848 ] |
||||||||||||||||||||||||||||||
|
13.36 ms (8.72%) |
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 671824 508256 150261 743892 719491 791720 642130 749900 648658 613288 777618 707865 768705 767973 782035 775429 789622 661425 691807 625298 761812 742097 742808 568788 602818 648715 722352 766059 783815 713989 658457 771919 793198 683649 757835 662585 674257 675503 613338 626894 716311 723087 787587 554576 578933 565607 790294 452702 782036 713766 674549 305824 761633 761642 793039 764616 778245 560254 476377 647259 766220 802000 810083 470915 780080 686148 689177 624989 712380 784886 794409 795217 811828 756470 772537 345303 782125 493080 485497 537389 671501 619936 661449 149622 793632 793816 784322 754401 720953 400409 473298 697199 552793 443591 396944 786072 664649 668698 612513 793787 800128 421597 426781 754935 566193 401875 653006 760517 543925 745954 761611 712639 784777 147369 773910 769119 802073 485848 812848 591440 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.75%) |
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 147369 149622 150261 305824 345303 396944 400409 401875 421597 426781 443591 452702 470915 473298 476377 485497 485848 493080 508256 537389 543925 552793 554576 560254 565607 566193 568788 578933 591440 602818 612513 613288 613338 619936 624989 625298 626894 642130 647259 648658 648715 653006 658457 661425 661449 662585 664649 668698 671501 671824 674257 674549 675503 683649 686148 689177 691807 697199 707865 712380 712639 713766 713989 716311 719491 720953 722352 723087 742097 742808 743892 745954 749900 754401 754935 756470 757835 760517 761611 761633 761642 761812 764616 766059 766220 767973 768705 769119 771919 772537 773910 775429 777618 778245 780080 782035 782036 782125 783815 784322 784777 784886 786072 787587 789622 790294 791720 793039 793198 793632 793787 793816 794409 795217 800128 802000 802073 810083 811828 812848 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"домашнее жена с друго%…"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск жен друг"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.91%) |
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.