Query Metrics
7
Database Queries
7
Different statements
137.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.89 ms (85.21%) |
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 440468 452215 452250 452939 454019 474181 475656 490389 497341 499335 514827 516649 520904 523380 523603 524272 526747 530398 530410 530568 530569 531058 531986 532118 532134 536756 540563 543951 544013 545971 546137 546142 547411 553699 554546 555189 555205 555210 555735 556769 563541 563970 566568 570936 573929 574438 575297 576605 577185 578169 578177 580910 584620 592897 592948 592965 593065 603377 606051 607703 610141 618682 619593 639647 643447 659938 660397 664389 665802 681227 692701 700900 704911 708530 710577 710732 714223 715111 715133 724649 724693 726107 726138 731153 731186 731236 732164 734272 739585 740112 741692 742680 746200 746567 746687 750412 761394 761403 761946 762186 767726 770194 780668 781925 790380 796816 804423 804430 804431 804486 808164 812534 812535 812555 823994 826603 826700 826856 826914 827630 ] |
||||||||||||||||||||||||||||||
|
10.63 ms (7.75%) |
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 526747 514827 826700 826856 826914 827630 823994 530398 530410 543951 544013 546137 555205 555210 555735 575297 804423 740112 761394 812534 812535 812555 724649 724693 761403 770194 731186 746567 761946 726138 731153 731236 532118 563541 664389 554546 592948 592897 475656 692701 592965 452939 523380 580910 619593 750412 741692 781925 440468 474181 520904 563970 574438 573929 826603 497341 531058 536756 556769 566568 546142 576605 804430 808164 804431 734272 762186 732164 739585 767726 726107 618682 715133 780668 804486 532134 530569 531986 577185 584620 708530 710732 681227 704911 710577 714223 659938 700900 715111 603377 643447 606051 610141 593065 607703 639647 524272 742680 790380 499335 578177 555189 746687 530568 540563 553699 547411 660397 665802 570936 452215 454019 452250 490389 523603 516649 578169 545971 796816 746200 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.96%) |
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 440468 452215 452250 452939 454019 474181 475656 490389 497341 499335 514827 516649 520904 523380 523603 524272 526747 530398 530410 530568 530569 531058 531986 532118 532134 536756 540563 543951 544013 545971 546137 546142 547411 553699 554546 555189 555205 555210 555735 556769 563541 563970 566568 570936 573929 574438 575297 576605 577185 578169 578177 580910 584620 592897 592948 592965 593065 603377 606051 607703 610141 618682 619593 639647 643447 659938 660397 664389 665802 681227 692701 700900 704911 708530 710577 710732 714223 715111 715133 724649 724693 726107 726138 731153 731186 731236 732164 734272 739585 740112 741692 742680 746200 746567 746687 750412 761394 761403 761946 762186 767726 770194 780668 781925 790380 796816 804423 804430 804431 804486 808164 812534 812535 812555 823994 826603 826700 826856 826914 827630 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade erotic mature"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск эротик mature"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.