Query Metrics
7
Database Queries
7
Different statements
147.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.40 ms (82.46%) |
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 106347 152276 156525 184985 185861 383697 384986 385105 387077 389147 389756 390185 395920 396013 401479 401492 414849 445233 447529 447545 447882 448119 454066 458538 459126 465789 469672 482069 489318 498698 501805 503215 507175 518032 518347 518483 525533 526821 526824 526834 531416 531471 543791 551244 551289 551321 551329 551334 551340 551384 551432 551741 555944 557337 558617 561672 562881 564619 569824 569827 572013 572030 579227 580372 582197 583669 584726 585910 595865 598112 600628 603096 605875 621418 622039 623327 624285 626877 628345 641663 643436 643443 644093 653247 654137 659165 661107 663391 663533 666324 671703 676118 677030 677041 681411 689591 703275 720458 722098 726544 727454 728067 738927 740007 741631 744475 747345 747351 757977 768164 771354 773068 773098 782420 800069 806220 813478 816038 820452 825204 ] |
||||||||||||||||||||||||||||||
|
15.03 ms (10.21%) |
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 531416 156525 185861 389756 561672 564619 572030 543791 551244 663533 595865 585910 626877 628345 773098 771354 773068 518483 722098 383697 395920 551432 551340 569824 677041 551334 605875 622039 624285 621418 643443 782420 744475 757977 728067 741631 727454 641663 800069 459126 389147 384986 184985 584726 569827 825204 703275 659165 666324 654137 661107 677030 643436 738927 747345 747351 531471 401479 414849 458538 469672 448119 447882 498698 518347 526821 551289 551384 558617 551321 653247 603096 726544 445233 465789 482069 447529 454066 503215 518032 489318 507175 501805 525533 526834 526824 390185 681411 598112 740007 387077 816038 820452 551329 720458 663391 813478 768164 396013 447545 106347 551741 557337 572013 582197 580372 671703 676118 689591 555944 562881 579227 583669 600628 623327 644093 152276 401492 385105 806220 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.94%) |
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 106347 152276 156525 184985 185861 383697 384986 385105 387077 389147 389756 390185 395920 396013 401479 401492 414849 445233 447529 447545 447882 448119 454066 458538 459126 465789 469672 482069 489318 498698 501805 503215 507175 518032 518347 518483 525533 526821 526824 526834 531416 531471 543791 551244 551289 551321 551329 551334 551340 551384 551432 551741 555944 557337 558617 561672 562881 564619 569824 569827 572013 572030 579227 580372 582197 583669 584726 585910 595865 598112 600628 603096 605875 621418 622039 623327 624285 626877 628345 641663 643436 643443 644093 653247 654137 659165 661107 663391 663533 666324 671703 676118 677030 677041 681411 689591 703275 720458 722098 726544 727454 728067 738927 740007 741631 744475 747345 747351 757977 768164 771354 773068 773098 782420 800069 806220 813478 816038 820452 825204 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage dick"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"массаж член"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж член"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.12%) |
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.