Query Metrics
7
Database Queries
7
Different statements
363.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.14 ms (57.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass cumshot"
]
|
||||||||||||||||||||||||||||||
|
131.82 ms (36.27%) |
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 69956 80900 81214 382073 390827 396066 410884 412136 419253 423384 423606 432618 432702 434429 434767 434848 440390 441708 441845 442107 444672 446999 451074 452812 453268 461757 468239 477850 478111 479656 480829 486036 487443 489894 493751 499964 518146 529137 531100 546582 553256 558865 564994 566305 579547 584112 584476 586268 590402 595314 602862 604144 605055 605283 605871 606604 610163 611006 614842 617953 620224 621433 624194 629585 629593 641318 646942 653245 655159 658793 689028 690250 695319 705729 707175 709672 710941 715563 720443 721869 721885 723716 724102 724103 726052 726232 727972 728369 731111 742072 742356 750247 751252 757576 759599 759747 761680 764280 768078 778288 778931 779558 780125 784220 785789 786778 790389 791101 792050 793830 799164 800611 801322 805259 809898 810352 811076 812596 813987 826181 ] |
||||||||||||||||||||||||||||||
|
14.08 ms (3.87%) |
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 720443 690250 705729 646942 655159 695319 707175 709672 546582 586268 605871 617953 624194 590402 595314 602862 629593 610163 621433 778288 779558 793830 800611 812596 809898 810352 750247 786778 791101 792050 724103 726052 742072 761680 723716 724102 726232 727972 728369 759747 751252 757576 764280 768078 614842 629585 641318 710941 721885 778931 784220 785789 799164 412136 423606 69956 419253 487443 584112 390827 826181 558865 689028 653245 605283 604144 780125 441845 396066 434848 606604 611006 805259 499964 81214 432702 423384 440390 451074 452812 480829 489894 453268 461757 478111 531100 479656 564994 553256 579547 584476 566305 658793 715563 605055 620224 790389 731111 759599 742356 721869 801322 811076 432618 434767 434429 441708 444672 410884 493751 518146 529137 486036 80900 382073 442107 813987 446999 468239 477850 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (0.95%) |
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 69956 80900 81214 382073 390827 396066 410884 412136 419253 423384 423606 432618 432702 434429 434767 434848 440390 441708 441845 442107 444672 446999 451074 452812 453268 461757 468239 477850 478111 479656 480829 486036 487443 489894 493751 499964 518146 529137 531100 546582 553256 558865 564994 566305 579547 584112 584476 586268 590402 595314 602862 604144 605055 605283 605871 606604 610163 611006 614842 617953 620224 621433 624194 629585 629593 641318 646942 653245 655159 658793 689028 690250 695319 705729 707175 709672 710941 715563 720443 721869 721885 723716 724102 724103 726052 726232 727972 728369 731111 742072 742356 750247 751252 757576 759599 759747 761680 764280 768078 778288 778931 779558 780125 784220 785789 786778 790389 791101 792050 793830 799164 800611 801322 805259 809898 810352 811076 812596 813987 826181 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп cumshot"
]
|
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.