Query Metrics
7
Database Queries
7
Different statements
588.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
357.95 ms (60.79%) |
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 95943 188699 321460 384804 389593 391539 397425 397671 400430 401965 403754 414184 423845 434582 443123 445480 453085 455221 455832 456650 459158 460868 469503 469900 472038 472768 473268 475516 475971 476535 476547 477156 477693 479482 480620 481318 481774 483412 483428 484089 485463 487093 487917 489679 489697 492559 495977 496926 503313 506492 511066 512136 514953 519385 522261 522864 525082 527281 527318 537292 542832 543133 543603 546439 546747 548058 551189 551193 554649 555233 557402 559150 559247 562149 562607 563650 565353 565394 567235 568871 572949 574659 576197 576698 576722 578581 589833 591202 591289 593812 598884 604278 610972 617021 619823 620898 624859 625607 626139 626915 655601 658935 661281 669233 673925 685389 705715 705729 705781 705812 709938 712672 719849 722575 725262 752800 774095 778949 785418 788102 ] |
||||||||||||||||||||||||||||||
|
207.71 ms (35.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 95943 188699 321460 384804 389593 391539 397425 397671 400430 401965 403754 414184 423845 434582 443123 445480 453085 455221 455832 456650 459158 460868 469503 469900 472038 472768 473268 475516 475971 476535 476547 477156 477693 479482 480620 481318 481774 483412 483428 484089 485463 487093 487917 489679 489697 492559 495977 496926 503313 506492 511066 512136 514953 519385 522261 522864 525082 527281 527318 537292 542832 543133 543603 546439 546747 548058 551189 551193 554649 555233 557402 559150 559247 562149 562607 563650 565353 565394 567235 568871 572949 574659 576197 576698 576722 578581 589833 591202 591289 593812 598884 604278 610972 617021 619823 620898 624859 625607 626139 626915 655601 658935 661281 669233 673925 685389 705715 705729 705781 705812 709938 712672 719849 722575 725262 752800 774095 778949 785418 788102 ] |
||||||||||||||||||||||||||||||
|
16.06 ms (2.73%) |
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 389593 591202 565353 514953 453085 543133 554649 619823 414184 574659 598884 778949 576698 626915 572949 476535 477156 512136 576722 661281 489697 555233 568871 658935 593812 95943 489679 527281 685389 543603 551193 562149 610972 423845 620898 722575 705729 589833 617021 475516 472038 469900 548058 546439 456650 527318 321460 511066 384804 391539 673925 472768 506492 559150 476547 455832 477693 496926 469503 522261 655601 719849 725262 788102 752800 774095 785418 522864 559247 578581 705715 705812 525082 403754 519385 624859 591289 400430 563650 401965 480620 485463 487917 546747 625607 483428 542832 626139 397671 397425 479482 434582 483412 551189 565394 567235 443123 484089 492559 562607 669233 709938 473268 459158 445480 495977 481318 481774 503313 537292 475971 487093 188699 460868 576197 557402 705781 712672 604278 455221 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"forest blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лес природ минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.26%) |
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.