Query Metrics
7
Database Queries
7
Different statements
146.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.16 ms (81.98%) |
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 383643 425486 428532 453472 453746 462370 464219 472396 472778 475454 476721 477049 477073 477131 481679 487479 493307 495737 496686 496772 499207 499485 503996 506783 510024 512340 512459 512687 512923 513125 518919 521613 521750 521773 522576 524618 525176 525273 526026 526909 526961 527280 529322 529545 529551 530610 530713 531133 533195 533932 534757 535261 537240 537912 538624 540073 540690 541890 542369 542422 542945 543179 543595 543867 546830 546838 546856 546857 546936 549287 549391 549922 551041 551044 551049 551063 551535 551984 555264 557391 558819 560281 562884 566563 569423 569698 569742 571671 571998 573230 574421 577970 578492 585366 591565 591590 594896 595789 598125 600501 602099 619204 621387 622345 624229 626376 626872 629730 629886 631503 638416 649147 650350 650793 666532 710403 732917 733364 804487 806113 ] |
||||||||||||||||||||||||||||||
|
16.92 ms (11.54%) |
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 526909 526961 534757 540690 496772 499207 503996 506783 512459 513125 518919 522576 525176 525273 527280 529322 530610 530713 531133 533932 537240 538624 540073 495737 496686 499485 510024 512340 512687 512923 521613 521750 521773 524618 526026 529545 529551 533195 535261 537912 462370 464219 472396 472778 477049 477073 487479 493307 542422 542945 543595 546838 549287 549922 551041 551984 555264 557391 558819 569742 542369 543179 546936 551044 566563 569423 574421 541890 543867 546830 546856 549391 551535 560281 569698 573230 649147 650350 666532 650793 546857 551049 551063 562884 571671 571998 577970 578492 621387 624229 629730 585366 622345 626376 626872 638416 594896 595789 600501 619204 629886 631503 591565 591590 598125 804487 806113 732917 733364 602099 710403 383643 453472 453746 475454 476721 477131 481679 425486 428532 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.67%) |
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 383643 425486 428532 453472 453746 462370 464219 472396 472778 475454 476721 477049 477073 477131 481679 487479 493307 495737 496686 496772 499207 499485 503996 506783 510024 512340 512459 512687 512923 513125 518919 521613 521750 521773 522576 524618 525176 525273 526026 526909 526961 527280 529322 529545 529551 530610 530713 531133 533195 533932 534757 535261 537240 537912 538624 540073 540690 541890 542369 542422 542945 543179 543595 543867 546830 546838 546856 546857 546936 549287 549391 549922 551041 551044 551049 551063 551535 551984 555264 557391 558819 560281 562884 566563 569423 569698 569742 571671 571998 573230 574421 577970 578492 585366 591565 591590 594896 595789 598125 600501 602099 619204 621387 622345 624229 626376 626872 629730 629886 631503 638416 649147 650350 650793 666532 710403 732917 733364 804487 806113 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf domination"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf domination"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf domination"
]
|
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.