Query Metrics
7
Database Queries
7
Different statements
207.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.96 ms (85.88%) |
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 383638 391306 425491 435642 437173 443649 443994 444594 449194 451333 456742 456743 456745 458741 458744 458751 458784 458786 461540 463151 466493 477209 477779 478526 478527 480774 481663 483594 483807 486920 487024 487086 487114 488705 488725 488829 489621 491967 492167 493203 493359 496528 497992 500463 502109 504758 511731 511743 512243 512251 512665 513876 514668 516877 517596 518401 518756 523127 524414 524706 524707 525957 526415 526571 533195 542062 542082 542513 547814 556318 556436 558436 565449 566849 574396 575520 576077 577460 588136 590369 591932 603641 603973 605410 630150 632405 654481 654771 654810 654844 655048 655074 655624 655627 655720 655728 655983 656406 656461 656681 656747 656963 657322 657329 657346 657388 657391 657403 657438 657654 658077 659093 697604 715534 734696 769559 788702 790796 797164 ] |
||||||||||||||||||||||||||||||
|
19.93 ms (9.62%) |
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 511743 523127 659093 788702 657329 477779 456745 493359 478526 565449 575520 514668 488725 500463 435642 518756 657403 657391 556436 504758 654837 391306 630150 487086 487114 656461 566849 383638 524707 657346 656963 734696 458741 456743 425491 511731 542062 558436 458784 547814 456742 518401 533195 480774 461540 437173 458786 512251 486920 497992 657438 654771 655627 477209 576077 444594 451333 489621 526415 524706 483594 797164 655720 483807 526571 658077 654844 769559 657654 590369 655074 657388 697604 491967 542082 492167 502109 656406 478527 493203 458751 513876 512243 517596 715534 512665 516877 574396 603641 654481 458744 481663 496528 463151 603973 525957 487024 488705 524414 542513 605410 655983 656747 577460 654810 588136 790796 655728 655624 657322 591932 488829 655048 632405 443994 466493 443649 449194 556318 656681 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.16%) |
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 383638 391306 425491 435642 437173 443649 443994 444594 449194 451333 456742 456743 456745 458741 458744 458751 458784 458786 461540 463151 466493 477209 477779 478526 478527 480774 481663 483594 483807 486920 487024 487086 487114 488705 488725 488829 489621 491967 492167 493203 493359 496528 497992 500463 502109 504758 511731 511743 512243 512251 512665 513876 514668 516877 517596 518401 518756 523127 524414 524706 524707 525957 526415 526571 533195 542062 542082 542513 547814 556318 556436 558436 565449 566849 574396 575520 576077 577460 588136 590369 591932 603641 603973 605410 630150 632405 654481 654771 654810 654844 655048 655074 655624 655627 655720 655728 655983 656406 656461 656681 656747 656963 657322 657329 657346 657388 657391 657403 657438 657654 658077 659093 697604 715534 734696 769559 788702 790796 797164 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"куколд после секса"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куколд посл секс"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куколд посл секс"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.74%) |
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.