Query Metrics
7
Database Queries
7
Different statements
139.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
114.59 ms (82.01%) |
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 382839 413524 413808 421915 423517 428833 428867 429867 432393 433429 433441 435600 439676 451507 453091 455034 455479 459098 460124 466402 466878 468278 472569 473460 474867 475752 475951 477554 477555 478990 494684 499840 515535 515550 515618 515634 515702 516393 516937 517222 517813 519371 522184 522795 523824 524774 526569 527176 528345 531724 535089 538009 540713 542978 543253 543400 543774 545490 545498 545645 546213 546906 546908 547827 552757 555044 556467 557244 559188 560064 561526 562905 564381 565691 569002 571128 572712 573388 573746 578106 578531 584366 589129 591972 593416 596520 601118 605108 617781 618856 622321 629208 663399 663474 663490 663912 665386 666719 670974 694308 725527 730688 751570 761517 764604 771004 801087 824258 ] |
||||||||||||||||||||||||||||||
|
15.68 ms (11.22%) |
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 433441 413808 473460 515618 535089 515550 515702 531724 540713 560064 663474 663912 694308 545490 564381 622321 629208 591972 596520 764604 751570 428833 433429 453091 382839 435600 466402 517813 519371 527176 423517 771004 451507 824258 459098 460124 474867 515634 517222 515535 516937 494684 543400 543253 546906 559188 578106 542978 664464 665386 666719 545498 546908 593416 801087 725527 730688 761517 605108 468278 478990 428867 499840 522184 526569 584366 466878 472569 475752 556467 557244 543774 569002 571128 545645 562905 670974 546213 552757 555044 589129 601118 617781 455034 561526 547827 572712 663399 663490 413524 429867 432393 477555 522795 523824 516393 538009 524774 573746 578531 573388 455479 421915 528345 477554 565691 618856 439676 475951 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.95%) |
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 382839 413524 413808 421915 423517 428833 428867 429867 432393 433429 433441 435600 439676 451507 453091 455034 455479 459098 460124 466402 466878 468278 472569 473460 474867 475752 475951 477554 477555 478990 494684 499840 515535 515550 515618 515634 515702 516393 516937 517222 517813 519371 522184 522795 523824 524774 526569 527176 528345 531724 535089 538009 540713 542978 543253 543400 543774 545490 545498 545645 546213 546906 546908 547827 552757 555044 556467 557244 559188 560064 561526 562905 564381 565691 569002 571128 572712 573388 573746 578106 578531 584366 589129 591972 593416 596520 601118 605108 617781 618856 622321 629208 663399 663474 663490 663912 665386 666719 670974 694308 725527 730688 751570 761517 764604 771004 801087 824258 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"legs milf"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"legs milf"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"legs milf"
]
|
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.