Query Metrics
7
Database Queries
7
Different statements
200.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.61 ms (86.81%) |
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 18 38292 91532 97694 108221 382421 382918 383987 384065 388069 395654 395849 396676 397382 397793 413106 413160 416928 418724 420275 421020 424549 425131 425491 426596 428147 429040 430564 442238 443847 447407 448399 448794 450826 451708 452995 456676 460974 460980 463110 464265 465645 466721 468007 470852 475100 476180 476712 477338 479345 480425 483309 483378 484886 486201 486659 488337 489173 489523 491255 491472 491776 493876 502488 503774 506501 514818 515391 515936 517659 518048 518143 518917 521946 524207 525776 526941 529829 531264 533285 534359 538463 540370 546800 550681 556331 559198 568477 578910 580259 580338 597079 597215 603071 603482 604014 614654 624229 639715 650320 681137 692381 693988 705530 721454 728540 743928 781693 783412 804943 814625 815523 817123 817128 817143 817191 818812 819720 824921 ] |
||||||||||||||||||||||||||||||
|
16.09 ms (8.04%) |
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 817123 603071 824921 526941 546800 464265 447407 91532 503774 521946 538463 517659 476180 650320 614654 489523 817143 484886 783412 382421 382918 397382 429040 413106 814625 460980 540370 502488 506501 525776 493876 568477 578910 597079 604014 448399 463110 395654 491472 518048 524207 425131 705530 451708 681137 108221 817191 529829 804943 384065 580338 426596 395849 420275 416928 466721 456676 476712 486659 534359 514818 556331 550681 624229 425491 518143 413160 480425 483378 383987 489173 518917 475100 430564 819720 815523 817128 18 533285 639715 421020 488337 448794 728540 479345 515391 491776 693988 418724 470852 97694 442238 450826 477338 465645 580259 597215 595204 603482 743928 397793 428147 443847 483309 491255 692381 468007 559198 515936 388069 396676 424549 818812 452995 486201 531264 721454 781693 38292 460974 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.44%) |
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 18 38292 91532 97694 108221 382421 382918 383987 384065 388069 395654 395849 396676 397382 397793 413106 413160 416928 418724 420275 421020 424549 425131 425491 426596 428147 429040 430564 442238 443847 447407 448399 448794 450826 451708 452995 456676 460974 460980 463110 464265 465645 466721 468007 470852 475100 476180 476712 477338 479345 480425 483309 483378 484886 486201 486659 488337 489173 489523 491255 491472 491776 493876 502488 503774 506501 514818 515391 515936 517659 518048 518143 518917 521946 524207 525776 526941 529829 531264 533285 534359 538463 540370 546800 550681 556331 559198 568477 578910 580259 580338 597079 597215 603071 603482 604014 614654 624229 639715 650320 681137 692381 693988 705530 721454 728540 743928 781693 783412 804943 814625 815523 817123 817128 817143 817191 818812 819720 824921 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde bondage"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.78%) |
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.