Query Metrics
7
Database Queries
7
Different statements
199.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.23 ms (87.24%) |
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 96484 107495 107651 193342 343369 388936 389610 396593 410163 414123 416195 418886 418959 421571 424497 424679 425622 428685 431687 433694 434609 435207 438398 443103 443373 443383 444778 447706 448042 448054 448058 450639 452273 453788 454220 454273 454700 456215 456779 456818 459099 460412 462949 463078 463756 463764 466572 469498 469566 470173 471965 473101 474856 477864 478033 479226 482377 482564 484458 484486 491444 491661 491667 491669 491784 491977 504336 506038 508438 508469 509064 509660 511554 513690 517564 517720 519104 519161 519729 520104 521144 521200 521701 525462 525999 528317 533260 550051 550684 553946 558620 561068 566833 568475 568480 576053 582790 584484 585583 586803 594338 603610 614057 629388 634185 640321 650486 652596 668512 668992 669589 681052 693269 696865 698847 719025 791110 797949 817158 827940 ] |
||||||||||||||||||||||||||||||
|
15.36 ms (7.69%) |
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 450639 550684 447706 462949 433694 418959 504336 519104 517720 519161 568475 561068 566833 693269 603610 797949 456779 478033 506038 343369 640321 585583 474856 424679 456818 471965 456215 558620 576053 438398 614057 96484 424497 719025 668512 791110 629388 521200 454700 525999 460412 634185 466572 418886 425622 459099 443383 509660 508438 525462 463756 550051 463078 491667 511554 652596 107495 389610 444778 827940 482564 469498 479226 453788 477864 696865 669589 107651 416195 448058 443373 448054 443103 584484 582790 650486 469566 491784 193342 388936 396593 414123 410163 817158 452273 454220 508469 528317 533260 521701 553946 681052 668992 594338 586803 431687 470173 421571 428685 434609 473101 448042 454273 509064 520104 484458 484486 491444 491661 491669 491977 521144 513690 519729 698847 435207 463764 568480 482377 517564 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.45%) |
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 96484 107495 107651 193342 343369 388936 389610 396593 410163 414123 416195 418886 418959 421571 424497 424679 425622 428685 431687 433694 434609 435207 438398 443103 443373 443383 444778 447706 448042 448054 448058 450639 452273 453788 454220 454273 454700 456215 456779 456818 459099 460412 462949 463078 463756 463764 466572 469498 469566 470173 471965 473101 474856 477864 478033 479226 482377 482564 484458 484486 491444 491661 491667 491669 491784 491977 504336 506038 508438 508469 509064 509660 511554 513690 517564 517720 519104 519161 519729 520104 521144 521200 521701 525462 525999 528317 533260 550051 550684 553946 558620 561068 566833 568475 568480 576053 582790 584484 585583 586803 594338 603610 614057 629388 634185 640321 650486 652596 668512 668992 669589 681052 693269 696865 698847 719025 791110 797949 817158 827940 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde bondage"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.81%) |
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.