Query Metrics
7
Database Queries
7
Different statements
213.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
193.10 ms (90.25%) |
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 118316 382107 389388 399648 401456 404412 404478 404491 405224 406204 406288 409109 414714 415710 417416 417870 418704 424502 434429 438533 441005 451040 453513 454727 466219 471305 471609 472214 477896 478887 489958 490790 493478 501760 501784 505397 507165 507549 509675 510362 519594 519841 519848 521888 528066 529676 534319 542737 543499 551283 551293 551352 551359 559958 561356 568369 571819 575823 576280 576379 586675 591968 592065 595493 599451 603576 604864 606831 617743 618337 620340 624722 624731 644225 644536 651885 651924 654390 660242 660522 665277 669157 673093 676130 676927 677029 693946 702546 708471 714248 720985 721408 721447 727728 744463 748450 749623 750376 756227 758938 769185 770096 773027 778853 782524 797698 800738 802179 807777 808221 814586 815428 815544 816963 818394 818780 820582 821542 822818 828420 ] |
||||||||||||||||||||||||||||||
|
11.47 ms (5.36%) |
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 424502 519594 519848 389388 405224 415710 595493 519841 617743 586675 471609 510362 528066 665277 807777 406204 404412 660242 404491 559958 501760 591968 624722 471305 749623 770096 409109 414714 490790 644225 551352 822818 708471 758938 489958 404478 417416 604864 441005 821542 507549 118316 816963 576280 651885 651924 677029 720985 673093 676927 721408 721447 568369 603576 727728 466219 815428 693946 676130 669157 714248 543499 505397 534319 493478 551283 399648 434429 472214 401456 561356 818780 818394 828420 702546 451040 406288 808221 654390 576379 624731 454727 477896 618337 778853 800738 750376 660522 773027 820582 551359 606831 542737 417870 744463 478887 592065 438533 551293 756227 453513 501784 507165 509675 521888 748450 782524 802179 769185 815544 418704 575823 620340 599451 814586 529676 644536 797698 382107 571819 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.98%) |
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 118316 382107 389388 399648 401456 404412 404478 404491 405224 406204 406288 409109 414714 415710 417416 417870 418704 424502 434429 438533 441005 451040 453513 454727 466219 471305 471609 472214 477896 478887 489958 490790 493478 501760 501784 505397 507165 507549 509675 510362 519594 519841 519848 521888 528066 529676 534319 542737 543499 551283 551293 551352 551359 559958 561356 568369 571819 575823 576280 576379 586675 591968 592065 595493 599451 603576 604864 606831 617743 618337 620340 624722 624731 644225 644536 651885 651924 654390 660242 660522 665277 669157 673093 676130 676927 677029 693946 702546 708471 714248 720985 721408 721447 727728 744463 748450 749623 750376 756227 758938 769185 770096 773027 778853 782524 797698 800738 802179 807777 808221 814586 815428 815544 816963 818394 818780 820582 821542 822818 828420 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits massage"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ массаж"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ массаж"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.81%) |
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.