Query Metrics
7
Database Queries
7
Different statements
157.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.77 ms (84.36%) |
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 154133 290847 382681 386858 389273 390096 390818 398099 398940 400513 402625 406012 411211 413525 424448 445943 452968 456230 457998 460208 463162 466245 467886 467903 467929 471081 471107 472864 474126 493700 510333 512503 513963 515546 515964 516120 517332 520910 523837 531892 536404 537172 546422 547426 547492 561015 565110 565119 568530 569050 573204 574109 576605 577344 583460 590297 590372 595438 596796 599834 602293 605026 605133 605219 615022 615921 624409 629962 630078 632026 634027 642004 650305 658788 661008 665975 669018 669387 672937 674307 681755 683284 704478 716543 718538 720289 725739 727560 730083 731779 734380 741752 745121 746199 747098 752619 752759 757438 758790 758803 760859 762264 765367 765617 770602 781326 790494 794296 795420 797284 799683 800528 801309 810076 812751 813819 817189 817352 820171 821434 ] |
||||||||||||||||||||||||||||||
|
14.29 ms (9.08%) |
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 820171 817352 642004 632026 734380 746199 821434 568530 583460 683284 672937 674307 634027 590372 624409 800528 801309 730083 731779 745121 757438 765367 765617 718538 595438 725739 154133 390096 402625 413525 472864 515964 536404 515546 546422 565110 547426 547492 565119 716543 615022 741752 770602 389273 386858 398940 471107 400513 517332 790494 817189 813819 531892 537172 681755 658788 576605 797284 762264 704478 590297 650305 781326 463162 466245 810076 577344 596796 602293 795420 812751 727560 752759 758790 382681 574109 493700 290847 390818 510333 513963 569050 573204 669387 720289 669018 661008 665975 561015 599834 605133 605219 629962 615921 630078 605026 758803 747098 760859 794296 467886 467903 424448 520910 523837 752619 799683 398099 474126 445943 512503 457998 467929 471081 406012 460208 411211 452968 456230 516120 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.89%) |
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 154133 290847 382681 386858 389273 390096 390818 398099 398940 400513 402625 406012 411211 413525 424448 445943 452968 456230 457998 460208 463162 466245 467886 467903 467929 471081 471107 472864 474126 493700 510333 512503 513963 515546 515964 516120 517332 520910 523837 531892 536404 537172 546422 547426 547492 561015 565110 565119 568530 569050 573204 574109 576605 577344 583460 590297 590372 595438 596796 599834 602293 605026 605133 605219 615022 615921 624409 629962 630078 632026 634027 642004 650305 658788 661008 665975 669018 669387 672937 674307 681755 683284 704478 716543 718538 720289 725739 727560 730083 731779 734380 741752 745121 746199 747098 752619 752759 757438 758790 758803 760859 762264 765367 765617 770602 781326 790494 794296 795420 797284 799683 800528 801309 810076 812751 813819 817189 817352 820171 821434 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.02%) |
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.