Query Metrics
7
Database Queries
7
Different statements
153.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.72 ms (83.32%) |
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 58237 131726 464235 472564 472860 486755 493064 493392 502934 504041 510197 529580 534887 546096 551658 559206 565634 587119 587723 588236 589198 592190 593721 603943 604705 610490 615607 619371 625483 625953 628187 628458 631056 636687 645571 648123 651708 652449 653648 656551 666412 666568 668962 669951 670900 677534 695016 709320 709323 709833 709988 714635 715655 716987 717248 721884 722060 723993 724048 725029 726256 729562 733285 733309 736252 739773 742342 742568 748768 751289 758405 761793 762543 765953 766484 766518 773374 773783 773844 776331 777112 778683 778763 779748 780244 780502 783744 783859 784920 788029 791638 791834 792512 792776 793692 794995 795230 797579 797739 797969 798762 799670 803805 803897 803953 804520 805007 807833 811329 811956 812378 813116 814674 816804 818952 818969 823909 825756 826492 ] |
||||||||||||||||||||||||||||||
|
15.28 ms (9.97%) |
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 653648 670900 559206 748768 795230 766518 803953 758405 715655 778763 803805 807833 651708 656551 726256 717248 779748 797739 546096 666412 677534 709320 709833 628458 631056 709323 472564 587723 792512 733309 766484 771522 784920 58237 826492 797969 733285 751289 493064 811329 773374 818952 588236 593721 788029 777112 811956 723993 742568 773844 765953 722060 529580 493392 714635 797579 791638 792776 793692 803897 805007 652449 628187 625483 666568 587119 615607 636687 721884 818969 565634 780244 736252 472860 486755 589198 773783 716987 780502 794995 816804 791834 504041 668962 645571 648123 669951 695016 551658 619371 729562 762543 783744 814674 464235 592190 798762 804520 783859 812378 502934 534887 625953 776331 739773 742342 778683 724048 813116 725029 603943 510197 610490 604705 709988 761793 823909 799670 131726 825756 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.84%) |
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 58237 131726 464235 472564 472860 486755 493064 493392 502934 504041 510197 529580 534887 546096 551658 559206 565634 587119 587723 588236 589198 592190 593721 603943 604705 610490 615607 619371 625483 625953 628187 628458 631056 636687 645571 648123 651708 652449 653648 656551 666412 666568 668962 669951 670900 677534 695016 709320 709323 709833 709988 714635 715655 716987 717248 721884 722060 723993 724048 725029 726256 729562 733285 733309 736252 739773 742342 742568 748768 751289 758405 761793 762543 765953 766484 766518 773374 773783 773844 776331 777112 778683 778763 779748 780244 780502 783744 783859 784920 788029 791638 791834 792512 792776 793692 794995 795230 797579 797739 797969 798762 799670 803805 803897 803953 804520 805007 807833 811329 811956 812378 813116 814674 816804 818952 818969 823909 825756 826492 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"just домашн любительск секс"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"just homemade fuck"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"just домашн любительск секс"
]
|
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.