Query Metrics
7
Database Queries
7
Different statements
216.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
191.74 ms (88.55%) |
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 393690 400342 427488 481117 481120 484221 486118 490967 492140 505664 506321 507214 508929 514242 514913 516593 518418 522629 522633 526848 527437 527472 528370 529056 529128 530250 536209 537188 538029 538537 539340 541436 544609 545334 546354 546566 546848 546890 547846 550929 553253 554406 554674 555266 555305 556180 556290 558476 560060 570409 573224 573485 576433 577166 579042 583536 583567 584178 584390 584454 584718 587987 588548 589324 589700 590922 591556 592944 594412 595625 595985 596564 598525 598792 599401 600467 600473 601458 603318 605387 606402 607044 607246 607752 608007 608083 612057 612301 616085 616503 618430 619068 619670 622277 622886 629144 629638 632940 634076 637898 638413 639164 639991 644160 662011 662425 664545 664958 665601 666126 666686 668757 669281 671991 675527 681501 686753 725082 746433 792253 ] |
||||||||||||||||||||||||||||||
|
14.31 ms (6.61%) |
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 584178 584390 588548 595625 618430 634076 591556 603318 607246 619670 622886 639991 644160 612057 589324 590922 594412 601458 605387 606402 607044 608007 612301 616085 619068 629144 608083 639164 587987 393690 400342 481120 530250 481117 490967 541436 579042 558476 584454 573224 577166 666686 665601 629638 637898 596564 595985 632940 792253 746433 725082 427488 486118 536209 537188 546848 607752 484221 505664 506321 538537 514242 514913 527472 529128 538029 507214 518418 522629 526848 528370 529056 539340 508929 516593 522633 527437 492140 547846 550929 573485 576433 583536 583567 544609 545334 546354 546566 553253 555266 555305 556180 556290 560060 570409 669281 671991 675527 662425 664545 664958 681501 662011 666126 668757 686753 546890 554406 554674 584718 598525 598792 600467 616503 622277 638413 589700 592944 599401 600473 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.11%) |
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 393690 400342 427488 481117 481120 484221 486118 490967 492140 505664 506321 507214 508929 514242 514913 516593 518418 522629 522633 526848 527437 527472 528370 529056 529128 530250 536209 537188 538029 538537 539340 541436 544609 545334 546354 546566 546848 546890 547846 550929 553253 554406 554674 555266 555305 556180 556290 558476 560060 570409 573224 573485 576433 577166 579042 583536 583567 584178 584390 584454 584718 587987 588548 589324 589700 590922 591556 592944 594412 595625 595985 596564 598525 598792 599401 600467 600473 601458 603318 605387 606402 607044 607246 607752 608007 608083 612057 612301 616085 616503 618430 619068 619670 622277 622886 629144 629638 632940 634076 637898 638413 639164 639991 644160 662011 662425 664545 664958 665601 666126 666686 668757 669281 671991 675527 681501 686753 725082 746433 792253 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"щель"
]
|
||||||||||||||||||||||||||||||
|
2.21 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.79%) |
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.