Query Metrics
7
Database Queries
7
Different statements
163.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.18 ms (81.96%) |
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 401757 411561 415342 415834 419982 421605 422141 423913 424002 424191 424292 424637 425562 427065 427364 432954 438978 443170 443856 444248 453419 453497 455241 455380 455514 456045 457804 457872 458472 462704 465122 465965 467825 468984 470611 474188 475252 480329 481461 484111 486112 490178 491439 493539 502707 504746 506209 508588 511155 514609 519123 520067 521896 523702 524023 524174 524638 529423 545510 547877 548680 555973 563213 563423 564656 565018 567098 567411 567585 568802 571406 573981 574550 575076 585818 589550 595470 598538 599476 599499 601880 602714 608558 609185 616551 620073 625018 626127 626193 627095 630448 640776 649094 668622 670742 704039 707894 711761 717336 727038 727707 731325 742214 746525 764589 772763 776907 777456 777686 777750 791095 791425 795123 799459 802091 802220 804894 809967 810388 ] |
||||||||||||||||||||||||||||||
|
20.77 ms (12.69%) |
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 649094 668622 548680 563213 563423 567098 567411 571406 589550 601880 626193 595470 598538 602714 608558 609185 630448 585818 599476 599499 640776 616551 776907 777686 777750 791095 799459 802220 802091 804894 810388 809967 727707 742214 772763 727038 731325 746525 764589 625018 704039 707894 711761 717336 777456 791425 795123 401757 423913 432954 462704 419982 455380 465965 424292 425562 443856 457872 465122 467825 481461 427065 438978 443170 457804 458472 468984 480329 421605 424191 453497 504746 511155 520067 521896 524638 486112 490178 502707 508588 519123 506209 514609 484111 491439 493539 523702 524023 524174 529423 470611 444248 555973 567585 568802 573981 575076 565018 574550 670742 545510 547877 564656 626127 620073 627095 415342 424002 475252 455241 456045 474188 411561 422141 453419 455514 415834 427364 424637 456520 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.40%) |
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 401757 411561 415342 415834 419982 421605 422141 423913 424002 424191 424292 424637 425562 427065 427364 432954 438978 443170 443856 444248 453419 453497 455241 455380 455514 456045 457804 457872 458472 462704 465122 465965 467825 468984 470611 474188 475252 480329 481461 484111 486112 490178 491439 493539 502707 504746 506209 508588 511155 514609 519123 520067 521896 523702 524023 524174 524638 529423 545510 547877 548680 555973 563213 563423 564656 565018 567098 567411 567585 568802 571406 573981 574550 575076 585818 589550 595470 598538 599476 599499 601880 602714 608558 609185 616551 620073 625018 626127 626193 627095 630448 640776 649094 668622 670742 704039 707894 711761 717336 727038 727707 731325 742214 746525 764589 772763 776907 777456 777686 777750 791095 791425 795123 799459 802091 802220 804894 809967 810388 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ukrainian home"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск home"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск home"
]
|
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.