Query Metrics
7
Database Queries
7
Different statements
212.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.27 ms (87.00%) |
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 400490 401987 414516 418419 418459 419492 423612 425752 426139 426148 426762 427497 427909 430366 434319 434670 436040 436139 437963 438987 442611 443202 443986 455739 457798 461737 463811 466916 468579 470011 473526 474914 481939 482916 483531 483551 488600 489583 489618 495812 497690 497715 498468 498989 501384 501658 502190 503361 504276 506475 506665 508695 508846 510769 510851 511235 511401 512022 512830 516425 521923 522995 523540 524005 525282 525601 525935 526996 527965 534172 537926 551273 552919 554912 556330 556406 558088 563259 563797 569197 571468 571724 571968 573917 576270 577593 579958 581683 585890 585942 586474 590413 590959 593966 594007 597060 597141 597793 597947 598786 598794 599664 600123 600565 601237 603732 604142 606017 609648 617632 623204 623812 640708 640732 644674 655591 714109 731947 788315 811998 ] |
||||||||||||||||||||||||||||||
|
17.61 ms (8.27%) |
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 569197 571468 573917 579958 585890 585942 597060 599664 600565 597947 590413 617632 594007 597141 597793 601237 609648 811998 731947 623812 788315 418459 425752 427497 442611 466916 414516 461737 400490 418419 426139 426762 427909 437963 438987 457798 481939 455739 503361 506665 516425 522995 524005 526996 534172 483531 501658 504276 508695 508846 511235 527965 489583 489618 495812 498468 498989 512830 521923 525282 525601 483551 488600 497715 501384 502190 510851 511401 401987 434319 436139 468579 497690 523540 537926 525935 552919 556330 571724 558088 571968 554912 556406 563259 563797 576270 577593 581683 714109 655591 551273 598786 598794 600123 606017 640708 640732 586474 590959 593966 604142 623204 603732 644674 443986 470011 473526 474914 423612 430366 436040 419492 426148 434670 443202 463811 506475 512022 482916 510769 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.32%) |
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 400490 401987 414516 418419 418459 419492 423612 425752 426139 426148 426762 427497 427909 430366 434319 434670 436040 436139 437963 438987 442611 443202 443986 455739 457798 461737 463811 466916 468579 470011 473526 474914 481939 482916 483531 483551 488600 489583 489618 495812 497690 497715 498468 498989 501384 501658 502190 503361 504276 506475 506665 508695 508846 510769 510851 511235 511401 512022 512830 516425 521923 522995 523540 524005 525282 525601 525935 526996 527965 534172 537926 551273 552919 554912 556330 556406 558088 563259 563797 569197 571468 571724 571968 573917 576270 577593 579958 581683 585890 585942 586474 590413 590959 593966 594007 597060 597141 597793 597947 598786 598794 599664 600123 600565 601237 603732 604142 606017 609648 617632 623204 623812 640708 640732 644674 655591 714109 731947 788315 811998 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cute skinny"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cute худые"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cute худые"
]
|
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.