Query Metrics
7
Database Queries
7
Different statements
167.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.16 ms (86.54%) |
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 123271 181804 210768 233029 233504 233617 346210 361315 365880 386194 388215 388544 390213 397410 401124 402693 406657 409820 412137 412150 418244 418459 422330 426674 428966 435045 443366 443998 444228 445274 445336 453605 453621 453901 454119 455641 456454 457798 461461 461468 462170 462528 462544 464782 465784 465993 466974 469851 471572 476728 477015 479758 480638 484342 484813 486027 489376 489663 490866 491155 494401 496235 496776 496882 501718 506812 510677 511122 512304 512754 513446 516295 516751 519725 523022 523965 526053 526287 527792 527945 528648 537960 537987 541110 541727 543584 545670 554562 561880 569341 573667 573702 574534 595361 595375 595396 595477 597062 597215 597498 597951 597969 598084 598458 598553 598721 600118 655077 655385 660503 688927 722825 743634 762277 771840 775836 782131 783609 785048 ] |
||||||||||||||||||||||||||||||
|
13.64 ms (8.13%) |
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 412150 462544 465784 516751 233617 426674 401124 574534 595375 722825 418459 445274 457798 506812 527945 484342 490866 512304 476728 543584 597062 444228 494401 489376 510677 491155 466974 346210 462170 523965 496776 412137 660503 123271 402693 461461 388215 688927 782131 397410 406657 597215 422330 456454 537987 541727 569341 595477 597951 595361 598084 598553 597969 453621 477015 455641 523022 526287 528648 496882 537960 486027 489663 516295 783609 790453 762277 233029 361315 409820 386194 600118 479758 598458 435045 573667 573702 464782 428966 471572 445336 453605 526053 554562 775836 743634 233504 443998 469851 512754 496235 655077 655385 771840 443366 462528 390213 461468 388544 513446 210768 181804 365880 541110 484813 561880 545670 598721 597498 595396 454119 480638 453901 418244 465993 527792 501718 511122 519725 785048 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.67%) |
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 123271 181804 210768 233029 233504 233617 346210 361315 365880 386194 388215 388544 390213 397410 401124 402693 406657 409820 412137 412150 418244 418459 422330 426674 428966 435045 443366 443998 444228 445274 445336 453605 453621 453901 454119 455641 456454 457798 461461 461468 462170 462528 462544 464782 465784 465993 466974 469851 471572 476728 477015 479758 480638 484342 484813 486027 489376 489663 490866 491155 494401 496235 496776 496882 501718 506812 510677 511122 512304 512754 513446 516295 516751 519725 523022 523965 526053 526287 527792 527945 528648 537960 537987 541110 541727 543584 545670 554562 561880 569341 573667 573702 574534 595361 595375 595396 595477 597062 597215 597498 597951 597969 598084 598458 598553 598721 600118 655077 655385 660503 688927 722825 743634 762277 771840 775836 782131 783609 785048 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"rus 18 sex"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск 18 секс"
]
|
||||||||||||||||||||||||||||||
|
1.25 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск 18 секс"
]
|
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.