Query Metrics
7
Database Queries
7
Different statements
181.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.88 ms (85.48%) |
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 392006 439737 452329 454517 457427 457461 460745 462082 462104 465387 466120 466748 467855 477706 478269 478380 483624 484421 484702 493175 493254 493681 494967 495227 496003 496871 497206 500289 500796 502813 504509 507003 513654 517810 518868 520745 520875 520910 521133 522442 523837 523848 523907 525315 543577 544108 546448 547952 548024 549231 549825 549843 552285 555009 555066 555076 555093 555095 555096 555109 555125 556519 560391 578169 587881 589679 602782 618507 619521 619536 619987 620224 620233 620259 620645 621196 621339 621366 651741 663772 669324 673420 680794 695691 712558 714895 714911 738365 739689 739725 745336 754649 781651 781727 785876 795131 801025 802151 803076 803728 803729 803899 807332 807337 816629 817273 824195 824213 824312 825360 826015 826478 826484 826531 826585 826586 827035 827142 827973 828555 ] |
||||||||||||||||||||||||||||||
|
16.15 ms (8.91%) |
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 520910 525315 493254 494967 496871 497206 500796 502813 504509 507003 513654 517810 521133 522442 523848 484421 493175 495227 500289 523837 549825 549843 460745 478269 439737 466120 478380 466748 457427 452329 457461 477706 523907 483624 484702 560391 824213 826478 826484 826586 827035 827142 824312 825360 826585 828555 493681 548024 546448 651741 621366 587881 801025 803729 754649 795131 803728 739689 739725 738365 745336 803899 392006 816629 817273 824195 826531 826015 827973 462082 465387 454517 518868 496003 520745 520875 462104 467855 544108 549231 555066 547952 552285 555009 556519 578169 543577 555095 555096 669324 673420 680794 695691 712558 663772 714895 714911 555076 555093 555109 555125 589679 602782 619987 620259 620645 621339 619521 620233 618507 619536 620224 621196 781651 781727 802151 785876 803076 807332 807337 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.68%) |
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 392006 439737 452329 454517 457427 457461 460745 462082 462104 465387 466120 466748 467855 477706 478269 478380 483624 484421 484702 493175 493254 493681 494967 495227 496003 496871 497206 500289 500796 502813 504509 507003 513654 517810 518868 520745 520875 520910 521133 522442 523837 523848 523907 525315 543577 544108 546448 547952 548024 549231 549825 549843 552285 555009 555066 555076 555093 555095 555096 555109 555125 556519 560391 578169 587881 589679 602782 618507 619521 619536 619987 620224 620233 620259 620645 621196 621339 621366 651741 663772 669324 673420 680794 695691 712558 714895 714911 738365 739689 739725 745336 754649 781651 781727 785876 795131 801025 802151 803076 803728 803729 803899 807332 807337 816629 817273 824195 824213 824312 825360 826015 826478 826484 826531 826585 826586 827035 827142 827973 828555 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian mature wife"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск mature жен"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск mature жен"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.86%) |
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.