Query Metrics
7
Database Queries
7
Different statements
365.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.84 ms (56.92%) |
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 186793 187786 383722 384082 389623 393872 397014 397656 397906 401876 407683 411752 420474 423486 429953 432663 433449 440339 447789 451040 452189 452767 453710 453996 461397 462595 464210 468348 476136 477209 478035 481047 481165 481169 482678 484876 493186 493220 493316 494659 496997 504296 508782 509024 513839 525497 533040 543094 543250 543738 547274 550360 552370 555094 560346 561443 563234 565257 570155 573270 577385 582197 592462 598194 606546 619520 625521 641156 649516 666396 668537 669189 701476 702309 709612 720719 721230 722371 759967 763182 765860 770501 773475 777003 777043 784345 790504 790882 795033 795574 796440 800191 800633 801235 801348 802414 811007 812824 815080 815559 817268 817358 817527 817633 817721 819735 820376 824700 824957 825295 826017 826019 826113 826606 826750 826850 828588 828700 ] |
||||||||||||||||||||||||||||||
|
135.90 ms (37.22%) |
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 186793 187786 383722 384082 389623 393872 397014 397656 397906 401876 407683 411752 420474 423486 429953 432663 433449 440339 447789 451040 452189 452767 453710 453996 461397 462595 464210 468348 476136 477209 478035 481047 481165 481169 482678 484876 493186 493220 493316 494659 496997 504296 508782 509024 513839 525497 533040 543094 543250 543738 547274 550360 552370 555094 560346 561443 563234 565257 570155 573270 577385 582197 592462 598194 606546 619520 625521 641156 649516 666396 668537 669189 701476 702309 709612 720719 721230 722371 759967 763182 765860 770501 773475 777003 777043 784345 790504 790882 795033 795574 796440 800191 800633 801235 801348 802414 811007 812824 815080 815559 817268 817358 817527 817633 817721 819735 820376 824700 824957 825295 826017 826019 826113 826606 826750 826850 828588 828700 ] |
||||||||||||||||||||||||||||||
|
14.14 ms (3.87%) |
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 795574 796440 802414 397014 432663 817268 815559 815080 468348 477209 484876 493220 533040 482678 573270 555094 563234 565257 669189 720719 649516 668537 625521 592462 598194 606546 777043 790882 800191 801348 801235 784345 765860 773475 759967 619520 777003 790504 811007 812824 447789 452767 407683 508782 397656 433449 461397 481165 525497 493186 560346 582197 547274 702309 666396 701476 709612 721230 552370 641156 795033 763182 384082 462595 423486 481169 494659 504296 186793 411752 550360 800633 509024 513839 770501 476136 481047 440339 453996 464210 493316 817721 478035 570155 763214 722371 429953 401876 452189 577385 187786 389623 397906 451040 453710 496997 383722 393872 420474 817358 822751 824957 825295 826017 826019 826606 817633 819735 824700 826750 826850 817527 820376 826113 828700 828588 543250 543094 561443 543738 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother hard"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин hard"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин hard"
]
|
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.