Query Metrics
7
Database Queries
7
Different statements
184.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.77 ms (85.89%) |
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 391959 392006 406012 452215 452250 452940 454019 454517 455475 474181 475319 484776 490389 500905 503836 507643 513568 513623 517509 518598 520904 520908 523603 526837 530402 530568 531058 531892 531986 532134 534578 536756 539741 540563 544108 545971 547411 552569 553221 553224 554488 554543 555009 555407 556769 561019 563970 566568 570936 573193 576479 577185 578169 580910 584620 592965 593065 602782 603377 606051 607703 615950 618507 618682 619593 632094 639647 643447 660397 681227 692701 700900 701235 701237 704911 708530 710732 715111 715133 733446 741688 741692 742351 742358 742359 742410 742680 746200 746687 749245 750412 761946 762186 765497 765634 766503 766509 780668 781925 791916 796816 797160 801620 803503 803510 803542 803544 803883 804430 804431 804452 804486 807422 808125 808164 819861 825426 826603 826973 827399 ] |
||||||||||||||||||||||||||||||
|
16.19 ms (8.76%) |
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 765497 761946 765634 803510 406012 454517 517509 534578 530402 544108 554488 555009 555407 561019 573193 580910 553224 602782 619593 618507 742351 749245 750412 741692 742410 742358 742359 781925 474181 526837 503836 520904 692701 592965 563970 553221 452940 518598 826603 819861 827399 531058 531892 536756 556769 566568 804430 808164 804431 803883 808125 762186 618682 715133 780668 803503 803542 803544 804486 532134 531986 554543 577185 584620 708530 710732 681227 704911 700900 715111 603377 615950 643447 606051 593065 607703 639647 632094 701235 513623 507643 570936 733446 742680 746687 392006 452215 454019 452250 490389 523603 539741 500905 576479 578169 545971 552569 701237 801620 807422 796816 766509 766503 741688 746200 791916 804452 391959 455475 475319 520908 484776 530568 540563 547411 660397 797160 513568 825426 826973 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.56%) |
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 391959 392006 406012 452215 452250 452940 454019 454517 455475 474181 475319 484776 490389 500905 503836 507643 513568 513623 517509 518598 520904 520908 523603 526837 530402 530568 531058 531892 531986 532134 534578 536756 539741 540563 544108 545971 547411 552569 553221 553224 554488 554543 555009 555407 556769 561019 563970 566568 570936 573193 576479 577185 578169 580910 584620 592965 593065 602782 603377 606051 607703 615950 618507 618682 619593 632094 639647 643447 660397 681227 692701 700900 701235 701237 704911 708530 710732 715111 715133 733446 741688 741692 742351 742358 742359 742410 742680 746200 746687 749245 750412 761946 762186 765497 765634 766503 766509 780668 781925 791916 796816 797160 801620 803503 803510 803542 803544 803883 804430 804431 804452 804486 807422 808125 808164 819861 825426 826603 826973 827399 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo homemade mature"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло домашн любительск mature"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло домашн любительск mature"
]
|
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.