Query Metrics
7
Database Queries
7
Different statements
387.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
237.36 ms (61.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 793883 796395 813057 729534 760318 773319 784978 796423 803734 810554 732130 763864 753059 764094 765343 771712 760190 771160 771657 772625 770359 771289 696922 700731 777375 779462 779666 780748 780830 787898 790512 791766 792381 800781 445583 449037 415475 418291 418397 420591 521518 618797 496458 559319 661976 602450 593910 421472 429165 433929 435315 824464 461866 515046 529491 517699 562659 563714 583242 553012 563273 564358 564908 571840 560973 566915 581584 651743 661350 667799 703970 677143 696345 713760 721418 646581 568838 613246 629195 597213 609687 612682 590445 593148 599448 610521 620669 627522 775541 785358 792878 807460 810563 777725 789900 812807 812844 734192 756877 766716 784992 785356 787638 787722 810107 813416 725716 754887 735005 739886 756279 766473 769522 771770 757142 764213 704341 710337 778277 791453 ] |
||||||||||||||||||||||||||||||
|
139.18 ms (35.89%) |
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 415475 418291 418397 420591 421472 429165 433929 435315 445583 449037 461866 496458 515046 517699 521518 529491 553012 559319 560973 562659 563273 563714 564358 564908 566915 568838 571840 581584 583242 590445 593148 593910 597213 599448 602450 609687 610521 612682 613246 618797 620669 627522 629195 646581 651743 661350 661976 667799 677143 696345 696922 700731 703970 704341 710337 713760 721418 725716 729534 732130 734192 735005 739886 753059 754887 756279 756877 757142 760190 760318 763864 764094 764213 765343 766473 766716 769522 770359 771160 771289 771657 771712 771770 772625 773319 775541 777375 777725 778277 779462 779666 780748 780830 784978 784992 785356 785358 787638 787722 787898 789900 790512 791453 791766 792381 792878 793883 796395 796423 800781 803734 807460 810107 810554 810563 812807 812844 813057 813416 824464 ] |
||||||||||||||||||||||||||||||
|
3.48 ms (0.90%) |
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 415475 418291 418397 420591 421472 429165 433929 435315 445583 449037 461866 496458 515046 517699 521518 529491 553012 559319 560973 562659 563273 563714 564358 564908 566915 568838 571840 581584 583242 590445 593148 593910 597213 599448 602450 609687 610521 612682 613246 618797 620669 627522 629195 646581 651743 661350 661976 667799 677143 696345 696922 700731 703970 704341 710337 713760 721418 725716 729534 732130 734192 735005 739886 753059 754887 756279 756877 757142 760190 760318 763864 764094 764213 765343 766473 766716 769522 770359 771160 771289 771657 771712 771770 772625 773319 775541 777375 777725 778277 779462 779666 780748 780830 784978 784992 785356 785358 787638 787722 787898 789900 790512 791453 791766 792381 792878 793883 796395 796423 800781 803734 807460 810107 810554 810563 812807 812844 813057 813416 824464 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (0.57%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов stepsister"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov stepsister"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов stepsister"
]
|
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.