Query Metrics
7
Database Queries
7
Different statements
166.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.76 ms (82.90%) |
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 387320 391537 395276 396747 405252 406705 407028 408692 410843 411608 420178 420276 421887 421889 425588 425603 431126 434635 435550 437663 440032 441448 443124 443150 443573 443945 443994 446002 446034 447509 448542 448640 448991 449073 450172 452304 452772 452838 453243 455318 456809 457294 457784 458770 459956 460079 460258 462030 463803 464791 465061 466383 466750 466779 467072 467957 468388 469374 469386 469542 470918 470935 472640 473435 473743 473908 474087 474520 478423 480645 482801 483754 486883 487509 489301 489947 491525 492128 501497 502222 507616 508558 516205 517743 518325 518581 520204 524361 524538 528931 529265 531685 532101 541078 541620 543255 546744 555967 555969 555983 555986 561505 563028 570928 570933 570954 574756 575656 578180 580921 591014 591768 609085 612050 620257 627654 659385 662390 715869 804927 ] |
||||||||||||||||||||||||||||||
|
18.38 ms (11.06%) |
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 478423 486883 543255 574756 575656 541078 555969 570928 570933 570954 578180 580921 659385 662390 715869 591014 591768 612050 804927 408692 443124 443945 464791 465061 468388 396747 405252 446002 467072 470918 470935 395276 406705 420178 421887 421889 425603 443150 452772 391537 435550 455318 459956 462030 466750 472640 407028 447509 453243 466383 473435 473908 518581 524538 489301 518325 520204 483754 502222 507616 508558 517743 501497 528931 620257 627654 609085 492128 524361 387320 425588 411608 420276 431126 440032 441448 443573 410843 434635 437663 443994 449073 450172 456809 463803 467957 482801 446034 448991 458770 466779 480645 448542 448640 452304 452838 457294 457784 460079 460258 469374 474520 487509 529265 516205 532101 531685 469386 469542 473743 474087 489947 491525 541620 546744 555967 561505 563028 555983 555986 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.80%) |
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 387320 391537 395276 396747 405252 406705 407028 408692 410843 411608 420178 420276 421887 421889 425588 425603 431126 434635 435550 437663 440032 441448 443124 443150 443573 443945 443994 446002 446034 447509 448542 448640 448991 449073 450172 452304 452772 452838 453243 455318 456809 457294 457784 458770 459956 460079 460258 462030 463803 464791 465061 466383 466750 466779 467072 467957 468388 469374 469386 469542 470918 470935 472640 473435 473743 473908 474087 474520 478423 480645 482801 483754 486883 487509 489301 489947 491525 492128 501497 502222 507616 508558 516205 517743 518325 518581 520204 524361 524538 528931 529265 531685 532101 541078 541620 543255 546744 555967 555969 555983 555986 561505 563028 570928 570933 570954 574756 575656 578180 580921 591014 591768 609085 612050 620257 627654 659385 662390 715869 804927 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"naked mature"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"голые mature"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"голые mature"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.85%) |
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.