Query Metrics
7
Database Queries
7
Different statements
158.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.36 ms (84.30%) |
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 465855 493875 498961 500878 505231 506218 506603 507739 508250 508364 509379 509387 509394 510872 511305 512806 514765 516650 516869 519438 519833 520219 520755 520885 525460 527157 527453 527765 528338 528555 529381 530104 534575 536154 536205 537130 537340 537824 539561 539801 542155 546579 547427 549750 550337 554733 556150 557022 557510 559546 559818 561379 563016 563652 565033 565456 565774 568140 568742 568849 569092 569111 573731 575607 576006 577584 579512 580771 582449 582459 583112 583218 584560 585454 586066 587302 587928 588237 588261 588449 589174 590877 591092 597144 598121 599196 599485 599761 600686 602232 602578 603164 604856 605458 605902 606744 606776 607034 607380 607530 608253 612092 614060 614493 621392 621448 625520 626283 628711 636478 644098 644399 650307 660013 661365 663172 668807 670742 684660 685732 ] |
||||||||||||||||||||||||||||||
|
15.84 ms (10.01%) |
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 500878 506603 520219 520885 525460 528555 529381 537340 509387 510872 516650 516869 519438 520755 505231 506218 511305 512806 519833 527157 527453 527765 536154 536205 537824 539561 539801 498961 507739 508250 508364 509379 509394 514765 528338 530104 534575 537130 465855 493875 542155 547427 557510 563652 565033 576006 577584 579512 583218 554733 556150 563016 565456 582459 550337 557022 559546 561379 565774 568140 568742 568849 569092 569111 573731 575607 580771 660013 668807 684660 650307 663172 670742 661365 685732 546579 549750 559818 582449 583112 584560 587302 589174 590877 606744 606776 607380 628711 585454 586066 587928 591092 597144 598121 599761 614060 626283 636478 588261 599196 599485 600686 602578 604856 607034 614493 621448 588237 588449 602232 603164 605458 605902 607530 608253 612092 621392 625520 644098 644399 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.55%) |
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 465855 493875 498961 500878 505231 506218 506603 507739 508250 508364 509379 509387 509394 510872 511305 512806 514765 516650 516869 519438 519833 520219 520755 520885 525460 527157 527453 527765 528338 528555 529381 530104 534575 536154 536205 537130 537340 537824 539561 539801 542155 546579 547427 549750 550337 554733 556150 557022 557510 559546 559818 561379 563016 563652 565033 565456 565774 568140 568742 568849 569092 569111 573731 575607 576006 577584 579512 580771 582449 582459 583112 583218 584560 585454 586066 587302 587928 588237 588261 588449 589174 590877 591092 597144 598121 599196 599485 599761 600686 602232 602578 603164 604856 605458 605902 606744 606776 607034 607380 607530 608253 612092 614060 614493 621392 621448 625520 626283 628711 636478 644098 644399 650307 660013 661365 663172 668807 670742 684660 685732 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трога my"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"touch my"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"трога my"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.