Query Metrics
7
Database Queries
7
Different statements
141.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.27 ms (84.97%) |
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 6643 148101 191246 222222 382419 384562 385172 390387 392439 401549 405972 408017 408150 408811 412018 413978 426486 434961 453874 476327 479825 494760 506883 528903 535191 599909 601522 604009 605520 611276 613096 614030 614217 619413 623596 624212 629852 637705 663463 663497 664277 665361 669171 675172 677354 682923 684018 688668 690446 692412 696769 696931 697085 701752 702793 707886 709994 710339 716315 716722 717058 718528 719802 719874 721767 726620 728254 729891 734215 735375 738436 741624 746571 752103 756901 760834 769905 772759 776304 776639 778931 779595 781578 781814 783415 789523 790553 792314 794954 795135 795537 796717 798039 799717 800684 801345 801623 801947 802451 802696 805625 806239 808045 808121 809551 809798 810682 811428 815518 815937 816313 816904 816922 818117 818251 818402 818599 819390 820727 821079 ] |
||||||||||||||||||||||||||||||
|
12.51 ms (8.84%) |
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 728254 717058 719802 778931 816313 664277 808121 816922 760834 746571 434961 819390 605520 601522 783415 741624 222222 385172 392439 426486 818251 818117 820727 821079 669171 696769 707886 684018 702793 663497 614030 790553 776304 781814 809798 781578 794954 738436 637705 779595 611276 453874 535191 506883 675172 682923 709994 772759 413978 476327 716722 191246 408811 408150 816904 599909 776639 756901 796717 729891 769905 710339 619413 806239 810682 390387 792314 401549 382419 815518 818402 528903 688668 604009 789523 801623 726620 721767 808045 811428 384562 408017 479825 405972 818599 815937 494760 663463 665361 677354 716315 690446 692412 719874 614217 623596 624212 629852 799717 802451 809551 805625 795135 795537 798039 800684 801947 752103 734215 735375 613096 696931 697085 701752 718528 801345 802696 6643 412018 148101 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.74%) |
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 6643 148101 191246 222222 382419 384562 385172 390387 392439 401549 405972 408017 408150 408811 412018 413978 426486 434961 453874 476327 479825 494760 506883 528903 535191 599909 601522 604009 605520 611276 613096 614030 614217 619413 623596 624212 629852 637705 663463 663497 664277 665361 669171 675172 677354 682923 684018 688668 690446 692412 696769 696931 697085 701752 702793 707886 709994 710339 716315 716722 717058 718528 719802 719874 721767 726620 728254 729891 734215 735375 738436 741624 746571 752103 756901 760834 769905 772759 776304 776639 778931 779595 781578 781814 783415 789523 790553 792314 794954 795135 795537 796717 798039 799717 800684 801345 801623 801947 802451 802696 805625 806239 808045 808121 809551 809798 810682 811428 815518 815937 816313 816904 816922 818117 818251 818402 818599 819390 820727 821079 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"busty blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"busty минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"busty минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.