Query Metrics
7
Database Queries
7
Different statements
152.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.58 ms (84.34%) |
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 48159 55349 78786 79720 79765 97445 122488 132148 187709 358849 382089 382182 384585 385787 388132 390022 391108 391931 391932 391959 392952 395662 395924 397666 398527 398746 400653 403973 415777 417130 419537 426531 426549 439658 439709 440933 443837 444156 444708 445460 454548 454551 456010 457605 460318 465677 468096 468354 468359 469253 470722 472677 473325 474969 475266 478582 479094 487993 493172 494454 496514 496831 497344 502108 503836 506833 509192 511827 514205 517069 520908 521137 523835 526050 526526 526737 536995 537263 537264 538864 540799 544190 545891 547423 549231 555066 555927 588911 599676 627361 710510 710531 726756 726984 726996 727034 727732 733117 734015 734332 736207 739994 740991 742389 757240 757241 757277 782508 788518 788520 790860 791916 796051 797252 797254 799357 801096 803498 803522 823351 ] |
||||||||||||||||||||||||||||||
|
14.00 ms (9.18%) |
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 48159 417130 397666 78786 479094 526737 511827 384585 382089 382182 97445 55349 390022 788520 796051 757241 801096 726756 734015 757240 733117 742389 788518 797252 797254 358849 475266 132148 395924 392952 79765 440933 460318 468096 469253 473325 445460 457605 502108 496514 468359 549231 555066 710510 799357 803498 803522 727732 739994 757277 791916 391959 395662 79720 454551 470722 478582 388132 403973 474969 439709 444156 494454 503836 517069 537263 487993 496831 509192 520908 523835 547423 536995 426531 521137 187709 444708 588911 734332 736207 726984 710531 385787 419537 398527 465677 415777 426549 454548 506833 627361 526050 526526 493172 391931 391932 823351 472677 400653 456010 443837 538864 544190 555927 727034 740991 514205 122488 391108 398746 726996 545891 439658 497344 540799 537264 599676 782508 790860 468354 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.90%) |
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 48159 55349 78786 79720 79765 97445 122488 132148 187709 358849 382089 382182 384585 385787 388132 390022 391108 391931 391932 391959 392952 395662 395924 397666 398527 398746 400653 403973 415777 417130 419537 426531 426549 439658 439709 440933 443837 444156 444708 445460 454548 454551 456010 457605 460318 465677 468096 468354 468359 469253 470722 472677 473325 474969 475266 478582 479094 487993 493172 494454 496514 496831 497344 502108 503836 506833 509192 511827 514205 517069 520908 521137 523835 526050 526526 526737 536995 537263 537264 538864 540799 544190 545891 547423 549231 555066 555927 588911 599676 627361 710510 710531 726756 726984 726996 727034 727732 733117 734015 734332 736207 739994 740991 742389 757240 757241 757277 782508 788518 788520 790860 791916 796051 797252 797254 799357 801096 803498 803522 823351 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"измены зрелых жен"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен зрелая женщин жен"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.98%) |
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.