Query Metrics
7
Database Queries
7
Different statements
212.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
187.10 ms (88.13%) |
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 6666 151062 401764 410663 413958 432625 448636 451213 457228 459963 462763 470400 492176 519772 536432 539275 541678 552697 564103 564524 568093 575846 586006 592300 592644 603391 603785 604362 618360 619273 619828 619974 624196 625599 625960 627362 627788 632111 640457 656931 657177 662142 662181 663721 669003 670904 683092 683270 687317 694132 704377 711870 714672 720103 724048 724074 726282 727739 730347 731346 735602 739230 739389 740009 740241 740819 740882 745135 745682 746884 750265 752565 754070 756551 757178 759759 759926 761594 761706 762085 765234 765285 765353 765657 765756 765835 765940 766600 766680 767017 767235 767326 771041 775686 783271 784740 785832 788592 788650 788897 790515 790523 791416 792100 795628 795822 796126 796142 796162 797065 797189 797310 800508 800633 817721 818327 819431 820165 824028 827484 ] |
||||||||||||||||||||||||||||||
|
15.30 ms (7.21%) |
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 766680 759759 767017 765756 714672 726282 797065 401764 541678 575846 711870 619974 604362 656931 752565 657177 817721 824028 767235 745682 740819 745135 740241 539275 820165 564103 788592 765835 739230 470400 586006 603391 783271 800508 740882 754070 761594 767326 735602 765353 739389 746884 765657 784740 788650 790523 791416 410663 662181 618360 592644 765940 759926 790515 792100 756551 730347 731346 462763 662142 663721 670904 603785 795628 761706 762085 765285 771041 625960 640457 704377 627788 724048 151062 519772 819431 796142 750265 775686 413958 451213 459963 669003 720103 796162 797189 765234 766600 795822 796126 797310 457228 683270 683092 632111 800633 757178 619828 624196 592300 619273 627362 785832 727739 724074 687317 6666 492176 448636 536432 564524 694132 568093 625599 552697 432625 818327 827484 788897 740009 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.32%) |
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 6666 151062 401764 410663 413958 432625 448636 451213 457228 459963 462763 470400 492176 519772 536432 539275 541678 552697 564103 564524 568093 575846 586006 592300 592644 603391 603785 604362 618360 619273 619828 619974 624196 625599 625960 627362 627788 632111 640457 656931 657177 662142 662181 663721 669003 670904 683092 683270 687317 694132 704377 711870 714672 720103 724048 724074 726282 727739 730347 731346 735602 739230 739389 740009 740241 740819 740882 745135 745682 746884 750265 752565 754070 756551 757178 759759 759926 761594 761706 762085 765234 765285 765353 765657 765756 765835 765940 766600 766680 767017 767235 767326 771041 775686 783271 784740 785832 788592 788650 788897 790515 790523 791416 792100 795628 795822 796126 796142 796162 797065 797189 797310 800508 800633 817721 818327 819431 820165 824028 827484 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hard anal homemade"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hard анал домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hard анал домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.80%) |
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.