Query Metrics
7
Database Queries
7
Different statements
152.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.29 ms (83.86%) |
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 322090 382567 382827 384025 384422 396859 399952 401574 401584 402404 402901 419099 419238 424095 427517 428173 430365 441656 450671 452853 459786 459792 460006 461460 461476 462248 462622 462724 463310 464523 464745 465841 467689 469095 470141 472192 474500 475577 476761 478274 478726 478850 479980 480651 481158 481218 485343 486361 487446 488786 488791 488793 492661 505035 510504 511959 514785 518058 519665 519680 519871 521872 524526 540730 542072 546019 547604 552159 552206 558856 561695 561972 565551 570299 570366 573848 578503 598390 603712 605814 621872 656044 656089 656468 657603 658608 659091 659656 660476 676527 689458 693236 697322 704599 705009 711050 722853 723599 741261 743700 754829 761471 761797 764107 771736 772588 773826 777169 777799 778226 778761 781087 781120 782969 789926 792455 796701 804871 807434 811626 ] |
||||||||||||||||||||||||||||||
|
13.76 ms (8.99%) |
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 723599 540730 547604 656089 658608 659656 660476 656468 657603 659091 689458 704599 705009 711050 656044 598390 778761 792455 778226 781120 796701 761471 741261 754829 761797 764107 772588 743700 771736 621872 781087 399952 519665 552159 570366 561972 573848 676527 693236 697322 546019 605814 782969 777169 777799 811626 789926 804871 773826 722853 384025 465841 382567 474500 401574 488793 479980 462248 486361 552206 570299 807434 603712 401584 459792 461476 462622 464523 480651 396859 460006 463310 478274 402404 452853 461460 464745 481158 322090 382827 402901 427517 459786 478726 450671 469095 481218 485343 492661 488786 488791 514785 424095 384422 419238 565551 578503 542072 558856 561695 441656 475577 419099 428173 470141 467689 478850 462724 476761 430365 472192 511959 518058 519680 519871 521872 524526 487446 505035 510504 ] |
||||||||||||||||||||||||||||||
|
2.52 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 322090 382567 382827 384025 384422 396859 399952 401574 401584 402404 402901 419099 419238 424095 427517 428173 430365 441656 450671 452853 459786 459792 460006 461460 461476 462248 462622 462724 463310 464523 464745 465841 467689 469095 470141 472192 474500 475577 476761 478274 478726 478850 479980 480651 481158 481218 485343 486361 487446 488786 488791 488793 492661 505035 510504 511959 514785 518058 519665 519680 519871 521872 524526 540730 542072 546019 547604 552159 552206 558856 561695 561972 565551 570299 570366 573848 578503 598390 603712 605814 621872 656044 656089 656468 657603 658608 659091 659656 660476 676527 689458 693236 697322 704599 705009 711050 722853 723599 741261 743700 754829 761471 761797 764107 771736 772588 773826 777169 777799 778226 778761 781087 781120 782969 789926 792455 796701 804871 807434 811626 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful russian"
]
|
||||||||||||||||||||||||||||||
|
2.18 ms (1.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая русск"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.23%) |
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.