Query Metrics
7
Database Queries
7
Different statements
194.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.79 ms (88.73%) |
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 209931 407538 409121 411131 414849 415928 418707 420266 423928 429239 431316 456411 456883 459156 460724 473099 477763 486147 486970 489087 495623 497130 498880 501475 508924 512932 516138 522306 524618 527309 534719 539086 540637 541783 545740 546809 546829 550333 551227 555462 555607 559414 572108 572403 572424 572682 576326 584378 592451 606097 609567 611366 614244 619650 625774 629695 631743 631762 644296 649832 651479 660270 663938 665287 665789 667360 670761 681187 682763 685935 688047 695270 705712 707323 707981 709489 710536 714007 722158 728984 732184 738010 746125 747950 752918 752940 753761 758268 768013 769004 770146 772454 788245 789686 792412 794413 794535 795353 797459 802255 802641 802874 804368 806958 808642 813598 813726 814162 814761 817498 818620 818884 818991 819095 822797 823030 823078 826163 826842 ] |
||||||||||||||||||||||||||||||
|
13.00 ms (6.68%) |
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 813598 539086 546829 649832 665287 682763 710536 681187 714007 707323 707981 631762 802255 770146 806958 752918 738010 802641 576326 407538 508924 414849 418707 456883 524618 555462 555607 758268 431316 512932 794413 545740 572682 722158 559414 629695 606097 794535 732184 728984 795353 415928 473099 498880 516138 477763 705712 651479 746125 769004 792412 804368 486970 584378 489087 527309 753761 486147 663938 459156 823030 540637 550333 670761 619650 614244 611366 592451 797459 752940 644296 411131 497130 495623 572108 551227 768013 423928 429239 420266 501475 209931 409121 814162 814761 817498 818991 822797 826163 819095 826842 818884 813726 818620 823078 828024 456411 460724 534719 522306 541783 572403 685935 688047 667360 695270 709489 660270 665789 546809 572424 631743 609567 625774 789686 808642 747950 772454 788245 802874 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.27%) |
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 209931 407538 409121 411131 414849 415928 418707 420266 423928 429239 431316 456411 456883 459156 460724 473099 477763 486147 486970 489087 495623 497130 498880 501475 508924 512932 516138 522306 524618 527309 534719 539086 540637 541783 545740 546809 546829 550333 551227 555462 555607 559414 572108 572403 572424 572682 576326 584378 592451 606097 609567 611366 614244 619650 625774 629695 631743 631762 644296 649832 651479 660270 663938 665287 665789 667360 670761 681187 682763 685935 688047 695270 705712 707323 707981 709489 710536 714007 722158 728984 732184 738010 746125 747950 752918 752940 753761 758268 768013 769004 770146 772454 788245 789686 792412 794413 794535 795353 797459 802255 802641 802874 804368 806958 808642 813598 813726 814162 814761 817498 818620 818884 818991 819095 822797 823030 823078 826163 826842 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public hairy pussy"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц волосатая pussy"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц волосатая pussy"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.76%) |
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.