Query Metrics
7
Database Queries
7
Different statements
192.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.07 ms (88.00%) |
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 10035 17216 53379 53962 54085 54301 54387 229180 381867 383639 384092 384371 385024 385894 390305 397917 411813 411834 411878 414430 417720 423766 429488 447411 462960 464421 468047 476717 477898 479682 489429 491421 494740 495127 503906 513323 514747 516853 528173 530727 531476 533460 535816 536739 542203 542797 543236 563834 565527 566044 574186 575695 577060 586763 588635 591085 592805 594182 595031 598929 599589 600543 601558 602970 609978 611760 611922 619388 619780 625289 626118 634528 636037 636043 643378 646034 647308 649992 666582 669779 673767 677968 683052 687610 699590 702047 704878 705253 714751 715517 716065 716334 716812 716893 717069 720117 722187 722534 723459 723991 726647 727699 732597 733819 736412 737083 737085 743040 745435 752928 755485 756498 782778 784780 785298 788166 799349 808614 810227 ] |
||||||||||||||||||||||||||||||
|
13.24 ms (6.89%) |
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 782778 808614 737083 785298 733819 723991 752928 771267 619388 717069 722534 723459 53962 229180 533460 54301 495127 788166 381867 611922 411878 666582 494740 535816 601558 737085 705253 476717 542797 715517 647308 636043 755485 385024 462960 468047 543236 643378 397917 390305 745435 799349 702047 383639 732597 491421 53379 646034 10035 528173 600543 611760 516853 530727 714751 602970 411813 514747 417720 575695 586763 542203 683052 592805 414430 54085 17216 479682 563834 699590 736412 513323 574186 673767 566044 743040 634528 720117 784780 447411 503906 536739 531476 464421 477898 649992 669779 677968 704878 716334 716893 716065 722187 594182 598929 609978 619780 591085 595031 588635 626118 726647 727699 636037 810227 384092 384371 599589 423766 716812 385894 489429 565527 687610 429488 54387 625289 577060 756498 411834 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.53%) |
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 10035 17216 53379 53962 54085 54301 54387 229180 381867 383639 384092 384371 385024 385894 390305 397917 411813 411834 411878 414430 417720 423766 429488 447411 462960 464421 468047 476717 477898 479682 489429 491421 494740 495127 503906 513323 514747 516853 528173 530727 531476 533460 535816 536739 542203 542797 543236 563834 565527 566044 574186 575695 577060 586763 588635 591085 592805 594182 595031 598929 599589 600543 601558 602970 609978 611760 611922 619388 619780 625289 626118 634528 636037 636043 643378 646034 647308 649992 666582 669779 673767 677968 683052 687610 699590 702047 704878 705253 714751 715517 716065 716334 716812 716893 717069 720117 722187 722534 723459 723991 726647 727699 732597 733819 736412 737083 737085 743040 745435 752928 755485 756498 782778 784780 785298 788166 799349 808614 810227 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"casting blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.76%) |
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.