Query Metrics
7
Database Queries
7
Different statements
159.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.36 ms (82.80%) |
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 119927 182118 382304 385688 388440 400199 409317 411998 431566 437494 443168 445409 447924 448002 460208 460618 463840 469554 471088 477587 482780 486768 493606 495566 496772 502064 502868 509991 511277 511520 512447 512938 515031 515068 518848 524792 524798 526189 529213 531949 532161 533598 534625 539416 541276 541317 545325 548162 552844 555982 555984 559372 559377 577290 591661 592696 604891 608428 609083 610039 619396 624810 626378 629962 630083 632107 639274 642032 645012 649921 655153 661568 666736 667536 681081 695803 695871 705558 710161 710265 712546 718784 720308 720950 721168 722029 725598 728316 731204 735912 744427 744598 747098 748154 750285 751611 751615 752759 759015 761294 761570 766335 772884 775817 788109 788818 790804 794672 797771 798918 804498 805490 811119 813568 814852 815031 815396 815759 815801 820070 ] |
||||||||||||||||||||||||||||||
|
17.04 ms (10.66%) |
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 502064 681081 477587 632107 747098 725598 775817 443168 502868 515031 409317 815801 486768 661568 695803 667536 626378 182118 766335 437494 471088 524792 814852 815031 820070 555982 666736 718784 721168 722029 624810 639274 604891 731204 790804 744427 608428 705558 720308 788818 804498 524798 548162 541317 552844 655153 710265 712546 591661 798918 761570 805490 493606 482780 559377 119927 511520 526189 610039 619396 431566 448002 545325 541276 811119 751611 797771 728316 748154 752759 761294 772884 460618 518848 445409 534625 512447 788109 629962 645012 533598 495566 382304 815396 559372 695871 592696 735912 750285 744598 759015 720950 794672 447924 511277 577290 512938 609083 532161 515068 469554 509991 555984 710161 813568 463840 630083 460208 400199 531949 539416 388440 385688 411998 815759 496772 649921 751615 529213 642032 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.76%) |
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 119927 182118 382304 385688 388440 400199 409317 411998 431566 437494 443168 445409 447924 448002 460208 460618 463840 469554 471088 477587 482780 486768 493606 495566 496772 502064 502868 509991 511277 511520 512447 512938 515031 515068 518848 524792 524798 526189 529213 531949 532161 533598 534625 539416 541276 541317 545325 548162 552844 555982 555984 559372 559377 577290 591661 592696 604891 608428 609083 610039 619396 624810 626378 629962 630083 632107 639274 642032 645012 649921 655153 661568 666736 667536 681081 695803 695871 705558 710161 710265 712546 718784 720308 720950 721168 722029 725598 728316 731204 735912 744427 744598 747098 748154 750285 751611 751615 752759 759015 761294 761570 766335 772884 775817 788109 788818 790804 794672 797771 798918 804498 805490 811119 813568 814852 815031 815396 815759 815801 820070 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature большие сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature big squirt"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature большие сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.11%) |
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.