Query Metrics
7
Database Queries
7
Different statements
165.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.51 ms (84.37%) |
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 392517 396334 396699 416138 417841 420853 422074 423464 424646 429715 432647 432690 432732 432777 432778 435177 436437 439135 441519 441848 443333 445340 447116 452636 453598 454145 454534 454926 461306 461968 462757 463810 463922 464578 464811 464837 465267 467910 470425 472399 472692 473222 474670 476975 478833 480714 482769 486204 490171 491802 492495 493172 496616 500884 500938 500955 503271 508560 514024 517854 518451 523541 524319 535431 537960 538266 541629 541732 547865 552395 554552 556445 558490 561844 563082 574643 576516 579469 580418 586897 592614 593787 595549 603725 609878 611348 618364 622932 623968 632096 632114 634600 637802 665923 680422 695900 696081 708276 709781 717820 720132 725119 735195 736470 740871 741656 742320 743068 750668 751432 761048 761481 761583 766996 778593 793472 794135 796168 801259 814944 ] |
||||||||||||||||||||||||||||||
|
15.44 ms (9.34%) |
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 464578 579469 696081 623968 740871 736470 743068 766996 750668 435177 452636 432778 463922 461968 500955 416138 441848 461306 508560 574643 709781 695900 609878 611348 618364 793472 725119 761048 500938 500884 491802 482769 708276 634600 796168 778593 742320 761481 741656 751432 632096 717820 720132 517854 637802 632114 432777 454926 593787 420853 496616 443333 432690 465267 454145 454534 474670 535431 464837 680422 554552 595549 470425 422074 445340 486204 490171 480714 552395 563082 541629 561844 576516 794135 447116 462757 473222 396334 537960 514024 493172 503271 396699 432732 463810 472399 478833 556445 424646 472692 592614 417841 441519 814944 547865 665923 801259 735195 429715 464811 492495 436437 392517 439135 432647 467910 541732 586897 761583 622932 476975 518451 523541 558490 580418 603725 423464 453598 524319 538266 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (2.05%) |
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 392517 396334 396699 416138 417841 420853 422074 423464 424646 429715 432647 432690 432732 432777 432778 435177 436437 439135 441519 441848 443333 445340 447116 452636 453598 454145 454534 454926 461306 461968 462757 463810 463922 464578 464811 464837 465267 467910 470425 472399 472692 473222 474670 476975 478833 480714 482769 486204 490171 491802 492495 493172 496616 500884 500938 500955 503271 508560 514024 517854 518451 523541 524319 535431 537960 538266 541629 541732 547865 552395 554552 556445 558490 561844 563082 574643 576516 579469 580418 586897 592614 593787 595549 603725 609878 611348 618364 622932 623968 632096 632114 634600 637802 665923 680422 695900 696081 708276 709781 717820 720132 725119 735195 736470 740871 741656 742320 743068 750668 751432 761048 761481 761583 766996 778593 793472 794135 796168 801259 814944 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð▓ ð¥Ðçð║ð¥ Ðü ð▒ð¥ð╗ÐîÐÄ ð© ð║ÐÇð©ð║ð░ðÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал крича вперв крича вперв"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.