Query Metrics
7
Database Queries
7
Different statements
390.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.45 ms (54.61%) |
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 282864 423187 428852 462822 502377 513896 531043 540957 542494 542513 543146 543925 552012 566412 566418 582239 587629 589739 592708 596404 604698 604985 606491 613885 622155 622171 626814 632251 635794 635863 638542 644057 645966 649226 651310 651318 651422 651906 653384 654256 654621 654678 654765 655392 656023 657996 658035 658681 659280 663328 665114 665342 665476 666754 666798 667656 668881 669417 669783 673359 673361 680974 681117 681129 681159 692454 692470 693037 693870 694322 696009 696167 697508 710212 715191 716819 716879 720966 721933 723967 724802 727903 732666 733150 733178 735078 736481 740764 742197 742219 742695 742886 744744 760060 770788 770790 773947 775054 775799 776528 787575 800342 800709 800915 801129 801894 802651 803399 805819 805842 809941 814574 815060 815138 815421 817416 817618 820106 820662 820690 ] |
||||||||||||||||||||||||||||||
|
157.28 ms (40.24%) |
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 282864 423187 428852 462822 502377 513896 531043 540957 542494 542513 543146 543925 552012 566412 566418 582239 587629 589739 592708 596404 604698 604985 606491 613885 622155 622171 626814 632251 635794 635863 638542 644057 645966 649226 651310 651318 651422 651906 653384 654256 654621 654678 654765 655392 656023 657996 658035 658681 659280 663328 665114 665342 665476 666754 666798 667656 668881 669417 669783 673359 673361 680974 681117 681129 681159 692454 692470 693037 693870 694322 696009 696167 697508 710212 715191 716819 716879 720966 721933 723967 724802 727903 732666 733150 733178 735078 736481 740764 742197 742219 742695 742886 744744 760060 770788 770790 773947 775054 775799 776528 787575 800342 800709 800915 801129 801894 802651 803399 805819 805842 809941 814574 815060 815138 815421 817416 817618 820106 820662 820690 ] |
||||||||||||||||||||||||||||||
|
13.80 ms (3.53%) |
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 665114 666798 669417 681117 692470 657996 658035 668881 693037 651318 654256 654765 658681 681159 693870 696167 613885 638542 592708 632251 635863 589739 724802 800915 655392 587629 531043 733150 805819 282864 502377 423187 775054 773947 800342 809941 710212 787575 776528 817618 651422 604985 801129 542513 604698 659280 543146 428852 513896 694322 596404 716819 775799 635794 805842 770788 542494 669783 644057 803399 742695 716879 760060 645966 733178 770790 814574 815060 721933 622171 606491 723967 742197 801894 802651 654621 815421 582239 540957 667656 715191 651310 680974 622155 735078 742219 736481 742886 732666 697508 817416 820690 820662 543925 552012 566412 649226 665476 692454 673361 720966 651906 663328 666754 626814 740764 744744 727903 800709 462822 820106 815138 566418 653384 654678 681129 696009 665342 673359 656023 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob sex"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.36%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член секс"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.33%) |
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.