Query Metrics
7
Database Queries
7
Different statements
150.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.36 ms (82.03%) |
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 83163 262435 314541 383325 386759 390108 390175 400431 405553 405860 408420 408709 411730 411925 413738 415859 416870 417403 420335 422329 423324 425668 431302 431592 434602 435698 438339 438413 439142 441659 444812 445014 445376 446002 452548 456722 458509 463986 464601 464836 465516 468029 474306 477120 477180 478476 480668 482678 485106 488628 491170 496696 497748 503117 507797 511966 516810 517580 517897 521481 521623 524263 525785 528770 529757 539471 543022 544753 561199 563595 567253 568420 569149 581750 589766 594283 601388 605848 620158 621675 623327 623493 624204 630254 630282 637687 640457 695146 710558 717974 726877 732754 733538 733541 733907 740903 746537 755348 763507 764165 765225 765807 767976 771981 775773 776180 777577 780963 784670 786523 789080 790076 799536 802783 810108 810243 810468 814626 821195 822232 ] |
||||||||||||||||||||||||||||||
|
17.24 ms (11.46%) |
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 589766 605848 623327 630254 637687 594283 640457 776180 780963 790076 802783 810108 810243 740903 784670 789080 732754 733538 733541 771981 746537 755348 763507 764165 726877 767976 620158 623493 630282 710558 717974 775773 383325 413738 435698 468029 262435 408420 83163 390175 445014 516810 386759 561199 528770 400431 405860 416870 420335 438413 463986 478476 458509 482678 568420 777577 733907 431592 452548 417403 511966 517897 521623 491170 496696 521481 524263 464836 539471 525785 517580 474306 567253 601388 799536 425668 544753 765807 444812 624204 445376 464601 477120 485106 465516 488628 529757 543022 563595 569149 581750 695146 621675 810468 765225 480668 439142 503117 497748 415859 456722 786523 446002 477180 507797 314541 390108 405553 423324 408709 422329 434602 438339 441659 411730 411925 431302 821195 822232 814626 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (2.05%) |
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 83163 262435 314541 383325 386759 390108 390175 400431 405553 405860 408420 408709 411730 411925 413738 415859 416870 417403 420335 422329 423324 425668 431302 431592 434602 435698 438339 438413 439142 441659 444812 445014 445376 446002 452548 456722 458509 463986 464601 464836 465516 468029 474306 477120 477180 478476 480668 482678 485106 488628 491170 496696 497748 503117 507797 511966 516810 517580 517897 521481 521623 524263 525785 528770 529757 539471 543022 544753 561199 563595 567253 568420 569149 581750 589766 594283 601388 605848 620158 621675 623327 623493 624204 630254 630282 637687 640457 695146 710558 717974 726877 732754 733538 733541 733907 740903 746537 755348 763507 764165 765225 765807 767976 771981 775773 776180 777577 780963 784670 786523 789080 790076 799536 802783 810108 810243 810468 814626 821195 822232 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass babe"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп babe"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп babe"
]
|
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.