Query Metrics
7
Database Queries
7
Different statements
205.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.34 ms (88.44%) |
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 400571 412852 414662 421993 432824 432974 434443 443233 443251 443317 448031 452815 452824 454793 459170 462840 466476 469125 469451 470412 471129 471335 473450 475920 477502 486772 493763 494530 500263 500333 505093 511864 512072 514257 516640 518505 526061 531578 531844 531891 534114 534443 534537 535438 538045 541377 541451 542124 545438 548153 548454 548834 550895 550916 553130 553646 556871 559783 560269 567120 575589 576848 578731 579673 583694 586995 587292 588466 588514 589042 591884 594053 596610 598882 601367 602241 607683 607685 608869 619322 626044 631740 634071 634750 641806 658802 665958 678707 687347 697543 709542 720200 722428 740523 743455 744033 749067 749264 752603 752652 752681 752712 752753 752921 757434 758163 766941 770262 784066 784310 785816 785979 788939 789436 792706 808068 811723 813487 824340 827395 ] |
||||||||||||||||||||||||||||||
|
14.44 ms (7.04%) |
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 576848 619322 626044 432824 432974 421993 709542 470412 462840 486772 475920 531891 534443 687347 607683 634750 785816 784310 813487 740523 811723 758163 766941 784066 785979 789436 792706 448031 594053 641806 471335 514257 545438 749264 752753 827395 678707 443317 443251 477502 454793 512072 511864 500333 516640 531578 505093 567120 471129 631740 607685 808068 534114 534537 722428 548153 587292 598882 743455 434443 575589 634071 443233 459170 400571 412852 414662 469451 473450 493763 452824 500263 531844 535438 538045 542124 560269 583694 541451 550895 553646 559783 556871 591884 602241 608869 588514 601367 586995 596610 744033 469125 466476 452815 494530 518505 526061 824340 550916 541377 548454 548834 658802 720200 665958 697543 553130 578731 579673 588466 589042 788939 752603 752681 752921 757434 749067 752652 752712 770262 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.23%) |
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 400571 412852 414662 421993 432824 432974 434443 443233 443251 443317 448031 452815 452824 454793 459170 462840 466476 469125 469451 470412 471129 471335 473450 475920 477502 486772 493763 494530 500263 500333 505093 511864 512072 514257 516640 518505 526061 531578 531844 531891 534114 534443 534537 535438 538045 541377 541451 542124 545438 548153 548454 548834 550895 550916 553130 553646 556871 559783 560269 567120 575589 576848 578731 579673 583694 586995 587292 588466 588514 589042 591884 594053 596610 598882 601367 602241 607683 607685 608869 619322 626044 631740 634071 634750 641806 658802 665958 678707 687347 697543 709542 720200 722428 740523 743455 744033 749067 749264 752603 752652 752681 752712 752753 752921 757434 758163 766941 770262 784066 784310 785816 785979 788939 789436 792706 808068 811723 813487 824340 827395 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge dildo homemade"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные дилд домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.