Query Metrics
7
Database Queries
7
Different statements
187.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.97 ms (86.20%) |
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 417107 436066 441566 441757 442957 443461 448939 449126 449238 449265 449332 451028 451671 456418 458086 461168 462422 463940 464149 464546 466356 466892 470420 476142 477154 478515 482547 482566 485892 487860 488089 488951 489285 489446 490959 491126 491909 494000 494164 495633 497681 498195 499179 500977 503342 505837 506901 506902 507297 507799 507947 508679 508884 508966 511019 513366 520933 522082 523143 523337 527061 527876 527882 528362 528853 529325 536460 536463 537132 539518 539667 540115 542095 542381 542392 542411 547428 548124 550747 555047 555917 559726 562211 563183 564373 568498 569579 582829 584971 586360 588825 589106 591996 592023 594338 603999 604329 606268 609198 610209 613956 619358 630063 633215 666436 675148 689156 692676 699325 706457 732834 738099 738636 750115 761169 761746 771213 777762 793114 798605 ] |
||||||||||||||||||||||||||||||
|
16.02 ms (8.52%) |
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 441566 441757 442957 436066 443461 417107 482566 482547 449238 449332 451671 456418 458086 463940 466356 476142 478515 485892 448939 449265 451028 464149 464546 470420 488089 488951 489446 449126 462422 466892 489285 491126 494164 495633 500977 505837 506902 507799 507947 508966 513366 522082 527882 536460 497681 503342 506901 523143 523337 528362 528853 529325 536463 537132 540115 499179 508884 520933 527876 539518 539667 498195 507297 508679 511019 527061 461168 477154 487860 490959 491909 494000 542411 555047 562211 542095 542392 547428 555917 559726 568498 584971 542381 548124 564373 582829 666436 675148 689156 692676 699325 706457 550747 563183 569579 589106 592023 606268 609198 588825 594338 603999 604329 613956 586360 591996 610209 633215 619358 630063 777762 798605 761746 793114 738636 771213 738099 750115 761169 732834 ] |
||||||||||||||||||||||||||||||
|
3.15 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 417107 436066 441566 441757 442957 443461 448939 449126 449238 449265 449332 451028 451671 456418 458086 461168 462422 463940 464149 464546 466356 466892 470420 476142 477154 478515 482547 482566 485892 487860 488089 488951 489285 489446 490959 491126 491909 494000 494164 495633 497681 498195 499179 500977 503342 505837 506901 506902 507297 507799 507947 508679 508884 508966 511019 513366 520933 522082 523143 523337 527061 527876 527882 528362 528853 529325 536460 536463 537132 539518 539667 540115 542095 542381 542392 542411 547428 548124 550747 555047 555917 559726 562211 563183 564373 568498 569579 582829 584971 586360 588825 589106 591996 592023 594338 603999 604329 606268 609198 610209 613956 619358 630063 633215 666436 675148 689156 692676 699325 706457 732834 738099 738636 750115 761169 761746 771213 777762 793114 798605 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"submissive wife"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"доминирован жен"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.73%) |
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.