Query Metrics
7
Database Queries
7
Different statements
187.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.97 ms (87.51%) |
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 391539 397425 397671 400430 401965 403754 411962 415099 423845 434582 443123 445480 455221 455832 456650 459158 460868 469503 472038 472768 475516 475971 476535 476547 477156 477693 479482 480620 481318 481774 483247 483412 483428 484089 484165 485463 487093 487917 488844 489679 489697 492559 495977 496926 501079 503313 506492 511066 512136 517869 519385 522261 522483 522864 525082 525652 527281 527318 537292 542832 543603 543615 546439 546747 548058 551189 551193 552705 555233 557402 559150 559247 562149 562607 563650 565394 567235 568871 572949 576197 576698 576722 578581 589833 591289 593812 598884 604278 610972 617021 620898 624859 625607 626139 626915 655601 658935 661281 669233 673101 673925 685389 705715 705729 705745 705781 705812 712672 719849 722575 725262 752800 774095 778949 785418 788102 803203 ] |
||||||||||||||||||||||||||||||
|
14.21 ms (7.58%) |
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 598884 778949 576698 626915 572949 476535 477156 512136 576722 661281 705745 489697 555233 568871 658935 593812 95943 489679 527281 685389 543603 551193 562149 484165 610972 423845 620898 722575 705729 589833 617021 475516 673101 472038 548058 546439 456650 527318 321460 511066 391539 673925 472768 506492 501079 559150 476547 455832 477693 496926 469503 522261 655601 719849 725262 788102 752800 774095 785418 522864 559247 578581 705715 705812 803203 525082 403754 519385 624859 591289 400430 563650 401965 480620 485463 487917 546747 625607 483428 488844 542832 626139 397671 397425 415099 479482 434582 483412 552705 551189 565394 567235 443123 484089 492559 562607 669233 459158 445480 495977 481318 481774 503313 537292 475971 487093 188699 460868 576197 557402 705781 712672 604278 455221 522483 525652 483247 543615 517869 411962 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.44%) |
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 391539 397425 397671 400430 401965 403754 411962 415099 423845 434582 443123 445480 455221 455832 456650 459158 460868 469503 472038 472768 475516 475971 476535 476547 477156 477693 479482 480620 481318 481774 483247 483412 483428 484089 484165 485463 487093 487917 488844 489679 489697 492559 495977 496926 501079 503313 506492 511066 512136 517869 519385 522261 522483 522864 525082 525652 527281 527318 537292 542832 543603 543615 546439 546747 548058 551189 551193 552705 555233 557402 559150 559247 562149 562607 563650 565394 567235 568871 572949 576197 576698 576722 578581 589833 591289 593812 598884 604278 610972 617021 620898 624859 625607 626139 626915 655601 658935 661281 669233 673101 673925 685389 705715 705729 705745 705781 705812 712672 719849 722575 725262 752800 774095 778949 785418 788102 803203 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс лес природ"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс лес природ"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob in forest"
]
|
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.