Query Metrics
7
Database Queries
7
Different statements
149.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.58 ms (82.91%) |
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 53477 204849 336704 357806 357886 381769 383778 385096 385192 386068 386503 387264 387487 389142 390039 390698 396569 397162 397477 398126 399595 402601 403236 403317 408074 409646 412237 414765 417202 417278 418003 418514 418545 422219 422316 422380 428513 432975 434012 435563 436174 442225 444460 444968 448200 448652 453513 453817 454648 455438 455929 459752 459859 463394 463824 468519 468658 469105 477810 486924 492266 495733 496464 500689 501404 509254 530527 538888 539598 543499 544405 569370 614049 614072 617749 620850 622695 624475 641435 662851 670133 672475 672486 690147 716911 726463 735684 746038 750941 756189 757687 758747 758980 760602 765482 770237 771290 771381 772230 772272 772777 773131 790064 793674 793841 795509 796217 799196 800009 802716 804067 804101 805571 806819 810591 814920 819024 819225 823579 825204 ] |
||||||||||||||||||||||||||||||
|
16.90 ms (11.34%) |
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 793674 495733 381769 459752 804101 614072 805571 444460 501404 814920 530527 509254 500689 641435 758747 414765 771381 569370 496464 492266 819225 396569 804067 386068 772272 735684 806819 387487 773131 397477 463394 442225 444968 750941 772230 746038 390698 204849 459859 800009 469105 765482 770237 422316 432975 662851 760602 453513 823579 422380 793841 772777 386503 403317 538888 455438 624475 620850 417202 453817 357886 468519 412237 477810 617749 539598 434012 771290 802716 357806 448200 409646 383778 336704 422219 690147 418514 448652 454648 726463 757687 544405 399595 418003 435563 468658 397162 398126 486924 390039 825204 53477 403236 543499 756189 799196 716911 672486 672475 758980 810591 385192 614049 796217 790064 418545 819024 670133 622695 795509 402601 389142 417278 385096 436174 387264 455929 428513 408074 463824 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.68%) |
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 53477 204849 336704 357806 357886 381769 383778 385096 385192 386068 386503 387264 387487 389142 390039 390698 396569 397162 397477 398126 399595 402601 403236 403317 408074 409646 412237 414765 417202 417278 418003 418514 418545 422219 422316 422380 428513 432975 434012 435563 436174 442225 444460 444968 448200 448652 453513 453817 454648 455438 455929 459752 459859 463394 463824 468519 468658 469105 477810 486924 492266 495733 496464 500689 501404 509254 530527 538888 539598 543499 544405 569370 614049 614072 617749 620850 622695 624475 641435 662851 670133 672475 672486 690147 716911 726463 735684 746038 750941 756189 757687 758747 758980 760602 765482 770237 771290 771381 772230 772272 772777 773131 790064 793674 793841 795509 796217 799196 800009 802716 804067 804101 805571 806819 810591 814920 819024 819225 823579 825204 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big pussy oil"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие pussy масл"
]
|
||||||||||||||||||||||||||||||
|
1.19 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие pussy масл"
]
|
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.