Query Metrics
7
Database Queries
7
Different statements
188.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.38 ms (85.03%) |
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 188242 233018 233353 249873 252068 384422 387359 390206 392675 396758 397054 398936 401952 403323 411336 411383 411393 411694 422299 424423 424435 424439 424481 427668 430936 443170 443692 443728 443794 443962 444127 447494 453855 454222 455409 461481 462937 462947 465332 466114 466890 467427 467547 469857 470156 479145 481466 482386 484615 484857 489048 490884 491362 491442 491981 492676 494238 497536 498921 502347 506223 509742 511161 511565 512646 513501 517999 518844 520864 521865 522305 526726 529246 538213 542640 545769 546622 546917 549772 549775 558020 558213 560613 562288 571452 572489 573621 573633 573678 573720 573861 573956 574832 576073 578367 581145 582583 590348 590404 598033 598910 599139 617211 623831 649094 655704 678696 680682 691407 693331 695790 699197 701266 708237 751618 781743 782246 785932 787552 810157 ] |
||||||||||||||||||||||||||||||
|
16.68 ms (8.84%) |
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 466114 233018 411383 465332 529246 506223 520864 576073 424423 392675 233353 502347 511565 522305 494238 655704 701266 691407 249873 538213 397054 401952 443692 511161 390206 545769 678696 398936 403323 384422 574832 680682 787552 708237 782246 810157 489048 484857 590404 542640 571452 252068 573720 512646 572489 573621 573633 699197 590348 785932 469857 461481 558020 444127 443962 558213 598033 188242 430936 481466 411694 751618 453855 582583 546622 581145 549772 549775 560613 424435 424481 482386 466890 422299 424439 462947 411393 427668 447494 454222 517999 490884 491362 497536 509742 492676 573956 573861 693331 695790 781743 491442 526726 513501 578367 649094 455409 573678 562288 617211 491981 479145 443794 546917 411336 387359 467547 467427 521865 484615 518844 598910 623831 498921 396758 599139 443728 462937 443170 470156 ] |
||||||||||||||||||||||||||||||
|
4.22 ms (2.24%) |
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 188242 233018 233353 249873 252068 384422 387359 390206 392675 396758 397054 398936 401952 403323 411336 411383 411393 411694 422299 424423 424435 424439 424481 427668 430936 443170 443692 443728 443794 443962 444127 447494 453855 454222 455409 461481 462937 462947 465332 466114 466890 467427 467547 469857 470156 479145 481466 482386 484615 484857 489048 490884 491362 491442 491981 492676 494238 497536 498921 502347 506223 509742 511161 511565 512646 513501 517999 518844 520864 521865 522305 526726 529246 538213 542640 545769 546622 546917 549772 549775 558020 558213 560613 562288 571452 572489 573621 573633 573678 573720 573861 573956 574832 576073 578367 581145 582583 590348 590404 598033 598910 599139 617211 623831 649094 655704 678696 680682 691407 693331 695790 699197 701266 708237 751618 781743 782246 785932 787552 810157 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ðÁð▒ÐâÐé ÐÇÐâÐüÐüð║ÐâÐÄ ÐüÐéÐâð┤ðÁð¢ÐéðÔÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс русск студент"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.80%) |
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.