Query Metrics
7
Database Queries
7
Different statements
571.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.03 ms (37.60%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро бдсм"
]
|
||||||||||||||||||||||||||||||
|
209.73 ms (36.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс втро бдсм"
]
|
||||||||||||||||||||||||||||||
|
122.16 ms (21.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 218026 396005 397306 404904 412925 419378 422595 423267 423657 424523 425609 427851 429810 429999 430389 431133 431442 437686 442173 442831 443558 443659 447759 447790 448035 449060 453550 453877 459488 459805 463094 463783 464932 466572 468631 470430 475833 475927 477340 478511 481359 482180 484571 484821 486694 487742 491169 491398 491885 491887 491905 491915 493197 494171 494513 506496 509875 510747 510821 511171 512215 512870 515934 516683 516767 516770 516775 516875 519107 523509 525622 529343 531227 533831 535028 535045 536335 536787 541644 543854 546828 548666 550063 550085 551995 559183 560445 561107 563844 568480 575806 582841 601841 601887 609958 610734 628312 637553 640614 643013 644998 647877 650851 651938 669574 670239 678973 693269 695184 705832 715595 716496 720364 784304 784315 789665 789724 792554 815648 816499 ] |
||||||||||||||||||||||||||||||
|
19.05 ms (3.33%) |
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 546828 551995 550063 548666 463783 443558 535045 716496 695184 637553 419378 218026 430389 815648 447790 478511 487742 477340 550085 720364 705832 447759 423267 510747 397306 404904 442831 459805 531227 494513 511171 536787 512215 486694 715595 669574 601841 601887 610734 784304 643013 481359 482180 429810 443659 516770 491398 491915 609958 442173 427851 816499 453877 453550 493197 533831 509875 516767 582841 792554 463094 448035 516683 559183 425609 470430 491905 494171 693269 628312 789724 431133 650851 568480 541644 510821 516775 651938 431442 412925 543854 512870 459488 647877 529343 468631 516875 789665 525622 484571 429999 640614 449060 670239 424523 644998 536335 535028 519107 484821 560445 563844 784315 396005 515934 523509 422595 437686 423657 491887 506496 464932 575806 678973 561107 466572 475927 475833 491169 491885 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (0.38%) |
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 218026 396005 397306 404904 412925 419378 422595 423267 423657 424523 425609 427851 429810 429999 430389 431133 431442 437686 442173 442831 443558 443659 447759 447790 448035 449060 453550 453877 459488 459805 463094 463783 464932 466572 468631 470430 475833 475927 477340 478511 481359 482180 484571 484821 486694 487742 491169 491398 491885 491887 491905 491915 493197 494171 494513 506496 509875 510747 510821 511171 512215 512870 515934 516683 516767 516770 516775 516875 519107 523509 525622 529343 531227 533831 535028 535045 536335 536787 541644 543854 546828 548666 550063 550085 551995 559183 560445 561107 563844 568480 575806 582841 601841 601887 609958 610734 628312 637553 640614 643013 644998 647877 650851 651938 669574 670239 678973 693269 695184 705832 715595 716496 720364 784304 784315 789665 789724 792554 815648 816499 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"threesome bdsm"
]
|
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.