Query Metrics
7
Database Queries
7
Different statements
183.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.70 ms (85.24%) |
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 91829 181043 376405 381747 388734 389594 390212 397288 397987 398619 404024 406635 412832 417838 419525 420816 424495 425141 427709 429553 429737 432568 432699 432731 437726 439793 441502 442980 446055 446872 454149 456224 457818 463870 464156 464794 465781 468380 468387 489317 493325 493529 493781 499806 500004 503241 510104 511387 513847 514956 518506 521137 521166 521476 521664 522849 527761 534395 535437 536971 544194 549821 552285 554577 565896 573337 591324 592410 606597 609285 613202 613513 614696 616910 621687 624159 625598 626647 626887 645342 656607 660043 676655 685477 686185 689191 711220 714656 716055 716165 720098 720123 723236 724483 730340 742588 747138 757853 757938 759926 760906 761778 765296 771763 779711 790466 796140 796504 799911 802035 802053 802513 802571 805510 819705 823941 826087 826095 827038 827996 ] |
||||||||||||||||||||||||||||||
|
17.32 ms (9.42%) |
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 397288 381747 613513 439793 389594 424495 457818 521476 429737 536971 625598 500004 626647 521166 823941 826095 419525 406635 689191 716165 613202 645342 390212 465781 493529 511387 437726 723236 660043 606597 624159 790466 799911 730340 796140 802513 747138 761778 760906 765296 757853 609285 802035 805510 554577 685477 441502 711220 397987 826087 819705 544194 656607 714656 388734 534395 91829 429553 468387 522849 499806 621687 404024 716055 425141 552285 592410 454149 376405 442980 468380 614696 616910 802053 757938 759926 742588 427709 432699 676655 446872 493781 686185 412832 464156 398619 521137 518506 724483 181043 420816 535437 513847 463870 565896 827038 779711 802571 771763 796504 521664 446055 432731 417838 432568 464794 549821 626887 591324 493325 489317 456224 514956 503241 510104 573337 827996 527761 720098 720123 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.75%) |
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 91829 181043 376405 381747 388734 389594 390212 397288 397987 398619 404024 406635 412832 417838 419525 420816 424495 425141 427709 429553 429737 432568 432699 432731 437726 439793 441502 442980 446055 446872 454149 456224 457818 463870 464156 464794 465781 468380 468387 489317 493325 493529 493781 499806 500004 503241 510104 511387 513847 514956 518506 521137 521166 521476 521664 522849 527761 534395 535437 536971 544194 549821 552285 554577 565896 573337 591324 592410 606597 609285 613202 613513 614696 616910 621687 624159 625598 626647 626887 645342 656607 660043 676655 685477 686185 689191 711220 714656 716055 716165 720098 720123 723236 724483 730340 742588 747138 757853 757938 759926 760906 761778 765296 771763 779711 790466 796140 796504 799911 802035 802053 802513 802571 805510 819705 823941 826087 826095 827038 827996 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"трусы в анал"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трусик нижн бел анал"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 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.