Query Metrics
7
Database Queries
7
Different statements
179.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.17 ms (85.17%) |
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 382460 396570 406957 410687 414001 418363 445946 448722 452391 457301 464426 466709 467638 493201 499332 524755 525226 532952 533007 533983 534848 540511 546308 546785 562376 562796 567360 568560 570150 570171 573309 575909 580653 583947 585573 589551 589754 593608 594583 595421 596061 600296 601544 601599 604515 604575 604614 605461 605581 606725 607080 610615 612855 612959 613122 614993 615846 619487 623910 624436 624653 627372 629965 631194 631214 634471 637687 638533 638555 640008 640798 644967 648925 650011 651166 665930 676427 678053 689376 690105 691254 710259 714900 716292 717770 718388 721062 732547 743822 745051 760676 765482 776822 778055 784151 785093 788924 790894 792569 797659 798275 798569 800288 802682 805112 805424 805932 806089 807641 807766 808775 811840 813074 814664 815201 815396 815525 816441 817781 827290 ] |
||||||||||||||||||||||||||||||
|
16.74 ms (9.31%) |
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 631214 593608 596061 605581 619487 623910 634471 637687 805112 813074 802682 807766 808775 743822 745051 624653 629965 721062 790894 797659 806089 811840 396570 414001 406957 467638 540511 533007 573309 562796 678053 600296 605461 614993 631194 418363 525226 499332 562376 382460 410687 815201 815525 644967 827290 816441 817781 814664 815396 448722 452391 445946 457301 464426 466709 493201 524755 532952 533983 534848 570171 570150 580653 546308 567360 568560 665930 710259 718388 648925 650011 651166 714900 716292 717770 676427 689376 690105 691254 546785 575909 583947 589754 607080 638555 585573 589551 594583 604575 604614 606725 613122 624436 640008 640798 601599 610615 612855 627372 638533 595421 601544 604515 612959 615846 788924 805932 776822 778055 800288 805424 760676 784151 785093 792569 798275 798569 807641 732547 765482 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.48%) |
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 382460 396570 406957 410687 414001 418363 445946 448722 452391 457301 464426 466709 467638 493201 499332 524755 525226 532952 533007 533983 534848 540511 546308 546785 562376 562796 567360 568560 570150 570171 573309 575909 580653 583947 585573 589551 589754 593608 594583 595421 596061 600296 601544 601599 604515 604575 604614 605461 605581 606725 607080 610615 612855 612959 613122 614993 615846 619487 623910 624436 624653 627372 629965 631194 631214 634471 637687 638533 638555 640008 640798 644967 648925 650011 651166 665930 676427 678053 689376 690105 691254 710259 714900 716292 717770 718388 721062 732547 743822 745051 760676 765482 776822 778055 784151 785093 788924 790894 792569 797659 798275 798569 800288 802682 805112 805424 805932 806089 807641 807766 808775 811840 813074 814664 815201 815396 815525 816441 817781 827290 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom milf bbc"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom milf bbc"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom milf bbc"
]
|
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.