Query Metrics
7
Database Queries
7
Different statements
209.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.25 ms (86.58%) |
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 95586 95886 96118 96231 97401 129722 381775 385457 387562 395408 395440 398041 401309 404957 410094 412189 414357 415618 415954 417674 417829 426390 427447 428383 434275 444645 446394 448880 451527 452311 454364 454802 460889 461723 465253 466355 473739 476108 477020 478647 479462 481147 508180 513882 513893 516091 516350 522043 531286 536614 537888 558119 565172 572763 582821 597239 599969 601150 602506 606489 615918 621656 629243 630524 632001 632006 633497 637008 647906 647910 651199 663551 668527 670761 671721 672710 678141 678532 679029 683470 683494 685791 686821 697025 699549 700282 704205 708421 710794 713375 715371 720077 721399 721417 725608 725630 728272 729288 733877 737663 738483 738619 741537 743309 748530 748779 748943 750469 764295 769870 770923 774650 775269 775915 776239 789516 806580 820769 826623 827523 ] |
||||||||||||||||||||||||||||||
|
18.49 ms (8.83%) |
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 748943 764295 395408 395440 428383 479462 513893 708421 651199 670761 671721 686821 699549 683470 713375 715371 606489 776239 775915 725630 789516 728272 750469 770923 738483 769870 741537 743309 738619 720077 721399 775269 401309 451527 95886 381775 385457 387562 537888 415618 414357 444645 446394 454364 476108 452311 558119 582821 678141 679029 685791 602506 621656 632006 601150 632001 806580 615918 417674 404957 434275 466355 516350 522043 700282 774650 410094 748530 96118 826623 531286 683494 663551 729288 725608 748779 737663 417829 427447 412189 478647 454802 513882 508180 473739 477020 481147 572763 678532 710794 672710 704205 647906 565172 599969 630524 637008 597239 633497 461723 398041 415954 516091 721417 629243 647910 668527 697025 733877 95586 129722 97401 96231 426390 820769 827523 465253 460889 448880 536614 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen double penetration"
]
|
||||||||||||||||||||||||||||||
|
2.35 ms (1.12%) |
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 95586 95886 96118 96231 97401 129722 381775 385457 387562 395408 395440 398041 401309 404957 410094 412189 414357 415618 415954 417674 417829 426390 427447 428383 434275 444645 446394 448880 451527 452311 454364 454802 460889 461723 465253 466355 473739 476108 477020 478647 479462 481147 508180 513882 513893 516091 516350 522043 531286 536614 537888 558119 565172 572763 582821 597239 599969 601150 602506 606489 615918 621656 629243 630524 632001 632006 633497 637008 647906 647910 651199 663551 668527 670761 671721 672710 678141 678532 679029 683470 683494 685791 686821 697025 699549 700282 704205 708421 710794 713375 715371 720077 721399 721417 725608 725630 728272 729288 733877 737663 738483 738619 741537 743309 748530 748779 748943 750469 764295 769870 770923 774650 775269 775915 776239 789516 806580 820769 826623 827523 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen double penetration"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen double penetration"
]
|
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.