Query Metrics
7
Database Queries
7
Different statements
184.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.22 ms (87.95%) |
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 232973 233151 388261 389526 391237 391502 392037 392054 400842 400852 400858 409843 420127 423953 424273 426772 428904 429800 432557 433418 439650 439689 442855 442932 451500 454771 455877 459645 461619 461983 462030 464244 465746 466281 467650 467928 475872 478121 484664 485087 486325 487217 488535 490881 490892 490902 506045 507487 511593 515618 515855 528112 538725 543733 543985 547882 552095 554553 555039 555096 556330 558928 562910 568593 579547 580248 590563 596179 601981 620661 626492 631260 635770 651822 663192 672819 680562 684714 686989 688155 705408 724809 738331 739250 741046 741855 745742 746580 747725 752077 754030 760777 763435 764403 764659 766787 768950 772150 779577 781513 782235 782495 783051 786755 788100 788715 789779 790459 791518 792014 793143 795202 798019 799730 800248 801681 803091 803631 818003 ] |
||||||||||||||||||||||||||||||
|
13.06 ms (7.08%) |
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 543985 400858 433418 515618 538725 579547 547882 555096 663192 688155 672819 680562 554553 620661 626492 782235 790459 801681 803091 803631 760777 763435 766787 741855 768950 724809 741046 389526 391237 409843 432557 490902 439689 391502 459645 486325 232973 426772 464244 465746 420127 428904 429800 467650 451500 485087 818003 511593 543733 558928 651822 684714 686989 562910 590563 623802 596179 631260 779577 782495 783051 788100 788715 792014 795202 789779 791518 798019 800248 752077 781513 786755 793143 772150 745742 746580 764403 738331 739250 747725 764659 635770 705408 799730 601981 442932 442855 507487 467928 478121 466281 515855 528112 400842 461619 461983 580248 424273 475872 423953 388261 487217 490892 488535 233151 555039 556330 400852 484664 568593 754030 392037 490881 552095 439650 392054 454771 462030 455877 506045 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.34%) |
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 232973 233151 388261 389526 391237 391502 392037 392054 400842 400852 400858 409843 420127 423953 424273 426772 428904 429800 432557 433418 439650 439689 442855 442932 451500 454771 455877 459645 461619 461983 462030 464244 465746 466281 467650 467928 475872 478121 484664 485087 486325 487217 488535 490881 490892 490902 506045 507487 511593 515618 515855 528112 538725 543733 543985 547882 552095 554553 555039 555096 556330 558928 562910 568593 579547 580248 590563 596179 601981 620661 626492 631260 635770 651822 663192 672819 680562 684714 686989 688155 705408 724809 738331 739250 741046 741855 745742 746580 747725 752077 754030 760777 763435 764403 764659 766787 768950 772150 779577 781513 782235 782495 783051 786755 788100 788715 789779 790459 791518 792014 793143 795202 798019 799730 800248 801681 803091 803631 818003 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русский чулках"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.76%) |
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.