Query Metrics
7
Database Queries
7
Different statements
169.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.33 ms (83.97%) |
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 78976 79388 382344 386545 386611 389612 389640 391150 396413 396570 396594 399089 400802 401773 417050 421435 432418 432421 433618 434207 434327 437733 443662 444695 445266 445946 450065 455967 456405 461756 461830 463828 465109 467076 468041 468348 468371 468476 472052 472804 475463 476663 478476 481673 482705 485225 487020 493262 499717 500932 503816 505096 506304 508070 508282 508428 508775 515777 516704 517299 518187 519181 519386 523151 524870 525678 529275 530063 539416 540979 556312 576886 579106 581580 584212 585251 585752 586244 587266 590499 591926 592384 593416 596479 604849 605196 613932 621752 633972 638555 644059 660405 661969 663749 675065 675441 675645 680242 691724 715533 715553 720924 729181 731481 733271 733307 739089 741307 744261 745037 746827 750466 757402 771366 776035 784814 788863 805112 811872 823929 ] |
||||||||||||||||||||||||||||||
|
17.31 ms (10.21%) |
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 729181 733307 746827 757402 771366 731481 739089 715533 776035 784814 788863 432418 434207 461830 437733 456405 433618 434327 472804 508070 515777 517299 487020 506304 508282 499717 79388 468041 621752 586244 733271 750466 811872 396413 587266 396594 744261 382344 805112 741307 715553 396570 78976 468348 468476 691724 593416 585752 644059 481673 399089 508775 591926 389640 445946 661969 720924 638555 386611 389612 386545 745037 443662 584212 585251 633972 391150 400802 401773 421435 432421 417050 445266 444695 823929 613932 482705 455967 478476 450065 465109 472052 461756 463828 467076 475463 476663 485225 493262 503816 505096 523151 525678 516704 524870 529275 539416 500932 508428 518187 519181 519386 530063 468371 579106 540979 556312 576886 660405 675065 675441 675645 680242 663749 581580 590499 592384 604849 605196 596479 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.70%) |
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 78976 79388 382344 386545 386611 389612 389640 391150 396413 396570 396594 399089 400802 401773 417050 421435 432418 432421 433618 434207 434327 437733 443662 444695 445266 445946 450065 455967 456405 461756 461830 463828 465109 467076 468041 468348 468371 468476 472052 472804 475463 476663 478476 481673 482705 485225 487020 493262 499717 500932 503816 505096 506304 508070 508282 508428 508775 515777 516704 517299 518187 519181 519386 523151 524870 525678 529275 530063 539416 540979 556312 576886 579106 581580 584212 585251 585752 586244 587266 590499 591926 592384 593416 596479 604849 605196 613932 621752 633972 638555 644059 660405 661969 663749 675065 675441 675645 680242 691724 715533 715553 720924 729181 731481 733271 733307 739089 741307 744261 745037 746827 750466 757402 771366 776035 784814 788863 805112 811872 823929 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife black"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен black"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен black"
]
|
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.