Query Metrics
7
Database Queries
7
Different statements
156.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.65 ms (80.36%) |
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 416382 419475 421234 422159 425052 430264 430437 431422 432393 435700 452338 456736 465641 472833 475543 475984 477860 478530 481359 481361 487693 490894 495895 507884 510518 511823 513155 513374 515434 515974 518072 520815 521262 521306 524389 525348 526005 526041 527447 528001 529457 530043 531089 531935 535013 541740 542191 547734 549027 550205 556397 563547 565491 565539 565581 565925 566781 569132 570765 571954 576623 576629 576690 578606 579754 585744 586485 587821 590298 590505 591004 593441 596075 596235 598204 598845 599833 600006 600258 600317 601535 602880 604386 605617 605636 606993 607129 610668 612381 616350 620031 621508 624111 632642 633786 636033 637036 637413 638115 639060 640710 641859 643523 646448 648817 649106 651674 665768 727812 763741 792576 804464 807023 810933 810976 811032 813945 814991 815056 815268 ] |
||||||||||||||||||||||||||||||
|
19.75 ms (12.63%) |
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 586485 604386 598845 610668 590298 596075 600258 600317 810933 811032 763741 621508 422159 481359 416382 465641 475543 425052 432393 510518 525348 487693 528001 530043 511823 814991 472833 507884 513155 565925 549027 550205 556397 565539 565581 649106 565491 587821 590505 598204 593441 643523 596235 605617 810976 792576 640710 419475 478530 481361 435700 475984 524389 490894 495895 520815 521262 531089 515974 569132 576690 571954 648817 566781 576629 591004 606993 638115 633786 605636 601535 804464 807023 431422 531935 815268 518072 576623 612381 585744 624111 727812 430437 421234 529457 535013 456736 579754 665768 563547 636033 637036 599833 813945 430264 477860 513374 541740 651674 600006 620031 616350 632642 639060 527447 526005 526041 641859 515434 542191 570765 646448 602880 607129 637413 521306 815056 452338 547734 578606 ] |
||||||||||||||||||||||||||||||
|
3.41 ms (2.18%) |
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 416382 419475 421234 422159 425052 430264 430437 431422 432393 435700 452338 456736 465641 472833 475543 475984 477860 478530 481359 481361 487693 490894 495895 507884 510518 511823 513155 513374 515434 515974 518072 520815 521262 521306 524389 525348 526005 526041 527447 528001 529457 530043 531089 531935 535013 541740 542191 547734 549027 550205 556397 563547 565491 565539 565581 565925 566781 569132 570765 571954 576623 576629 576690 578606 579754 585744 586485 587821 590298 590505 591004 593441 596075 596235 598204 598845 599833 600006 600258 600317 601535 602880 604386 605617 605636 606993 607129 610668 612381 616350 620031 621508 624111 632642 633786 636033 637036 637413 638115 639060 640710 641859 643523 646448 648817 649106 651674 665768 727812 763741 792576 804464 807023 810933 810976 811032 813945 814991 815056 815268 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom fetish"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom фетиш"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom фетиш"
]
|
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.