Query Metrics
7
Database Queries
7
Different statements
155.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.23 ms (85.02%) |
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 307633 397004 397494 411813 419325 423381 423383 424769 427143 427818 428543 432734 437999 442426 444196 444437 444455 444932 445419 451210 451628 451892 452576 452751 453712 454057 455009 458466 458513 459349 459989 460814 462259 463557 463607 464035 464349 465205 465745 471313 474292 477488 479298 480351 484070 487355 488573 496083 498563 503450 507222 508744 509112 511931 515418 517220 519575 523840 524127 524890 528058 533561 542266 549615 552794 569530 570955 572887 574036 581090 581597 589169 605956 618846 622922 636125 705708 705709 724044 724771 725183 726746 733083 747613 748167 756680 757145 757252 758576 767705 770958 778162 778193 778219 778319 779670 784425 784798 787607 787822 788152 789144 789409 789505 789995 790979 795775 796043 796067 796144 800416 809851 810805 811517 813832 817791 817793 ] |
||||||||||||||||||||||||||||||
|
13.15 ms (8.46%) |
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 622922 778162 778319 789995 790979 810805 779670 787607 789144 789409 789505 795775 724044 733083 788152 724771 767705 726746 757252 748167 771729 705708 775768 778193 778219 787822 796043 480351 423383 428543 444437 445419 458466 452576 459349 459989 464349 474292 451628 464035 511931 515418 519575 517220 524287 524890 528058 460814 463557 463607 572887 581090 549615 569530 570955 552794 581597 605956 589169 618846 462259 307633 423381 451892 455009 424769 437999 444455 452751 454057 479298 419325 444196 444932 451210 458513 477488 496083 488573 487355 507222 508744 524127 756680 796144 542266 471313 498563 574036 465745 523840 411813 442426 427143 432734 509112 757145 770958 397004 427818 453712 465205 503450 397494 813832 817791 817793 484070 533561 705709 636125 800416 809851 811517 725183 747613 758576 784425 784798 796067 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (2.05%) |
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 307633 397004 397494 411813 419325 423381 423383 424769 427143 427818 428543 432734 437999 442426 444196 444437 444455 444932 445419 451210 451628 451892 452576 452751 453712 454057 455009 458466 458513 459349 459989 460814 462259 463557 463607 464035 464349 465205 465745 471313 474292 477488 479298 480351 484070 487355 488573 496083 498563 503450 507222 508744 509112 511931 515418 517220 519575 523840 524127 524890 528058 533561 542266 549615 552794 569530 570955 572887 574036 581090 581597 589169 605956 618846 622922 636125 705708 705709 724044 724771 725183 726746 733083 747613 748167 756680 757145 757252 758576 767705 770958 778162 778193 778219 778319 779670 784425 784798 787607 787822 788152 789144 789409 789505 789995 790979 795775 796043 796067 796144 800416 809851 810805 811517 813832 817791 817793 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass in leggings"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп лосин"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.97%) |
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.