Query Metrics
7
Database Queries
7
Different statements
153.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.39 ms (82.78%) |
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 192551 238115 326207 343350 382652 383784 384095 384098 387000 389442 389610 391546 392527 392981 405191 411675 420475 424477 426177 426424 430567 430585 434838 447248 448047 448054 448067 448078 449262 449264 449265 449267 451631 454241 456363 457797 459345 460980 462240 464544 464546 465476 466163 466327 468616 470173 472917 475586 477037 477683 482547 482564 482566 482594 487026 487382 489863 490903 491321 491442 492340 494185 496114 499417 500977 503773 506344 506581 511155 511162 513978 515378 516985 521144 521201 522847 523778 524355 526728 527214 533498 534853 538891 540357 541597 542344 542397 544466 551055 560265 561757 570146 570966 573226 576121 577134 586889 588825 591996 603095 612796 613956 619474 631923 632706 667257 687150 692038 709306 711275 722510 732747 743380 745036 784925 817158 818812 825255 825973 826592 ] |
||||||||||||||||||||||||||||||
|
17.05 ms (11.08%) |
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 448047 448054 489863 491442 506581 487026 392981 570966 454241 521201 420475 466163 523778 238115 392527 430585 825973 466327 533498 540357 516985 496114 534853 542344 667257 561757 573226 612796 745036 709306 382652 387000 192551 384095 389610 426177 482564 570146 449262 405191 472917 511162 515378 522847 603095 586889 631923 491321 492340 326207 389442 430567 411675 817158 826592 482566 482594 447248 448067 465476 449265 459345 460980 464546 464544 477683 500977 524355 494185 577134 692038 743380 732747 619474 711275 391546 470173 462240 424477 426424 449267 477037 521144 526728 487382 632706 482547 468616 449264 503773 499417 513978 544466 542397 687150 588825 613956 591996 784925 475586 434838 457797 511155 490903 383784 384098 343350 818812 825255 451631 456363 448078 506344 527214 538891 560265 541597 551055 576121 722510 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.83%) |
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 192551 238115 326207 343350 382652 383784 384095 384098 387000 389442 389610 391546 392527 392981 405191 411675 420475 424477 426177 426424 430567 430585 434838 447248 448047 448054 448067 448078 449262 449264 449265 449267 451631 454241 456363 457797 459345 460980 462240 464544 464546 465476 466163 466327 468616 470173 472917 475586 477037 477683 482547 482564 482566 482594 487026 487382 489863 490903 491321 491442 492340 494185 496114 499417 500977 503773 506344 506581 511155 511162 513978 515378 516985 521144 521201 522847 523778 524355 526728 527214 533498 534853 538891 540357 541597 542344 542397 544466 551055 560265 561757 570146 570966 573226 576121 577134 586889 588825 591996 603095 612796 613956 619474 631923 632706 667257 687150 692038 709306 711275 722510 732747 743380 745036 784925 817158 818812 825255 825973 826592 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"slave lick pussy"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"доминирован лиза pussy"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"доминирован лиза pussy"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.87%) |
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.