Query Metrics
7
Database Queries
7
Different statements
171.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.61 ms (85.99%) |
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 154162 190891 263548 383294 384871 401508 420647 436828 437608 444281 462118 470664 470828 474248 481375 488332 504480 513587 516723 519040 520405 531603 541669 542215 546152 546320 550123 553126 556751 556897 558727 563955 567077 569135 569361 574115 574138 581555 582010 583238 583797 586363 587547 588937 589903 590478 590702 593098 599386 601138 602792 604793 604943 605853 606601 610139 615073 617021 618304 618553 618769 620817 621785 623279 625050 629808 638059 640894 644840 649024 650948 652232 652716 659282 662072 665083 665094 672901 672904 680785 680800 680802 689056 691897 704669 709916 719471 719563 721953 736018 739151 739556 742555 742767 750739 751316 751407 755741 760657 766003 766436 768785 769010 773499 774416 774575 785961 786660 801587 803948 805228 806362 810909 814057 817479 818781 820656 824666 827080 ] |
||||||||||||||||||||||||||||||
|
13.97 ms (8.14%) |
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 516723 546320 629808 803948 384871 569135 582010 689056 620817 773499 769010 820656 818781 462118 574115 574138 581555 649024 680802 665094 709916 650948 659282 546152 556897 569361 604793 610139 618304 618769 805228 810909 739151 766003 766436 751407 618553 383294 750739 739556 774575 154162 817479 644840 481375 541669 583797 546559 553126 691897 719471 672901 672904 719563 721953 589903 605853 606601 621785 638059 786660 760657 768785 742555 751316 623279 625050 704669 436828 263548 742767 444281 519040 583238 437608 520405 567077 680800 556751 590702 470828 470664 401508 420647 774416 531603 550123 558727 563955 652232 652716 587547 590478 588937 640894 785961 801587 806362 755741 736018 602792 504480 814057 617021 190891 827080 824666 474248 513587 488332 542215 680785 662072 665083 586363 604943 615073 593098 599386 601138 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.65%) |
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 154162 190891 263548 383294 384871 401508 420647 436828 437608 444281 462118 470664 470828 474248 481375 488332 504480 513587 516723 519040 520405 531603 541669 542215 546152 546320 550123 553126 556751 556897 558727 563955 567077 569135 569361 574115 574138 581555 582010 583238 583797 586363 587547 588937 589903 590478 590702 593098 599386 601138 602792 604793 604943 605853 606601 610139 615073 617021 618304 618553 618769 620817 621785 623279 625050 629808 638059 640894 644840 649024 650948 652232 652716 659282 662072 665083 665094 672901 672904 680785 680800 680802 689056 691897 704669 709916 719471 719563 721953 736018 739151 739556 742555 742767 750739 751316 751407 755741 760657 766003 766436 768785 769010 773499 774416 774575 785961 786660 801587 803948 805228 806362 810909 814057 817479 818781 820656 824666 827080 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation in car"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.99%) |
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.