Query Metrics
7
Database Queries
7
Different statements
141.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.81 ms (86.19%) |
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 384453 449930 452783 471049 478798 483444 488908 493820 503372 516364 536895 541414 544990 545155 546016 546167 552915 553226 554861 554869 555022 557635 558734 559414 559422 559425 561781 563977 569283 572682 575922 576424 576784 579496 581381 594375 596542 600548 607906 607953 607965 609569 609727 610198 612979 614460 614936 618515 622629 636172 637303 640361 641652 643326 646044 647211 648960 660036 660808 661028 661591 666142 666178 669259 670399 670437 670802 675897 676696 679296 681220 683046 695757 699544 709694 710875 710901 713885 715285 715287 723030 740255 742702 743753 744027 744801 744805 746308 746777 748263 749656 752573 754338 760566 777988 781273 783171 784174 785315 787069 788447 790449 792369 793122 796405 796863 797184 798153 801662 801815 804663 805040 806803 807060 807872 810753 813366 ] |
||||||||||||||||||||||||||||||
|
10.56 ms (7.47%) |
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 471049 555022 541414 545155 579496 581381 563977 572682 576784 648960 660808 676696 699544 709694 647211 660036 661028 670399 670437 670802 710875 723030 646044 666142 666178 669259 715285 546167 552915 553226 554869 558734 559414 559422 559425 561781 575922 576424 600548 610198 594375 614936 636172 607953 609727 612979 622629 643326 588152 596542 614460 641652 796405 801815 793122 797184 801662 804663 744027 744801 783171 784174 785315 792369 807060 744805 754338 740255 746308 743753 746777 749656 752573 760566 710901 777988 781273 783198 784870 788447 796863 798153 807872 810753 384453 503372 536895 679296 805040 618515 683046 695757 607965 640361 607906 609569 813366 787069 748263 742702 806803 675897 488908 493820 637303 790449 478798 483444 452783 449930 516364 546016 554861 569283 544990 557635 661591 681220 713885 715287 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.90%) |
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 384453 449930 452783 471049 478798 483444 488908 493820 503372 516364 536895 541414 544990 545155 546016 546167 552915 553226 554861 554869 555022 557635 558734 559414 559422 559425 561781 563977 569283 572682 575922 576424 576784 579496 581381 594375 596542 600548 607906 607953 607965 609569 609727 610198 612979 614460 614936 618515 622629 636172 637303 640361 641652 643326 646044 647211 648960 660036 660808 661028 661591 666142 666178 669259 670399 670437 670802 675897 676696 679296 681220 683046 695757 699544 709694 710875 710901 713885 715285 715287 723030 740255 742702 743753 744027 744801 744805 746308 746777 748263 749656 752573 754338 760566 777988 781273 783171 784174 785315 787069 788447 790449 792369 793122 796405 796863 797184 798153 801662 801815 804663 805040 806803 807060 807872 810753 813366 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy close-up solo"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy close up соло"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy close up соло"
]
|
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.