Query Metrics
7
Database Queries
7
Different statements
181.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.16 ms (87.19%) |
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 82252 382839 384070 385607 390889 403081 409274 411883 411885 411896 412001 415588 416226 426709 427523 428996 429244 444383 450213 453395 454960 454986 455262 457393 457962 468687 468719 468735 468758 470126 471866 472610 473195 474734 474751 489294 506266 508647 509412 509837 511378 512683 518796 522123 524918 525655 525660 526782 528689 530747 530769 531467 536701 545330 550364 555940 555952 565157 566061 572858 575720 579813 582760 589031 589263 591598 591658 597665 598456 600359 601101 607191 607590 614030 621385 627781 629388 630079 631654 631692 631944 632015 634553 638412 638533 640731 641344 641487 642725 647675 648222 649131 688672 692804 702152 705741 710706 716848 716911 719139 721113 725970 725980 729864 733598 737070 737079 737174 740599 741313 744593 745759 748159 755846 758492 761347 777570 784490 784494 817242 ] |
||||||||||||||||||||||||||||||
|
14.71 ms (8.11%) |
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 740599 545330 630079 641487 614030 710706 384070 702152 638412 472610 457393 411883 474751 390889 455262 509837 506266 555952 721113 737079 597665 629388 531467 509412 582760 627781 566061 411896 427523 575720 591598 729864 745759 716911 526782 453395 600359 631944 716848 692804 565157 761347 468719 579813 705741 621385 784490 744593 468687 474734 403081 426709 550364 572858 649131 688672 641344 755846 640731 525660 473195 382839 411885 634553 638533 444383 409274 530747 512683 508647 555940 648222 607191 631654 598456 591658 589263 725980 725970 741313 737174 758492 733598 601101 536701 784494 82252 511378 748159 632015 468758 454986 524918 647675 607590 468735 416226 528689 450213 429244 470126 415588 454960 428996 518796 412001 777570 385607 817242 489294 530769 457962 719139 589031 631692 642725 525655 522123 737070 471866 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.33%) |
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 82252 382839 384070 385607 390889 403081 409274 411883 411885 411896 412001 415588 416226 426709 427523 428996 429244 444383 450213 453395 454960 454986 455262 457393 457962 468687 468719 468735 468758 470126 471866 472610 473195 474734 474751 489294 506266 508647 509412 509837 511378 512683 518796 522123 524918 525655 525660 526782 528689 530747 530769 531467 536701 545330 550364 555940 555952 565157 566061 572858 575720 579813 582760 589031 589263 591598 591658 597665 598456 600359 601101 607191 607590 614030 621385 627781 629388 630079 631654 631692 631944 632015 634553 638412 638533 640731 641344 641487 642725 647675 648222 649131 688672 692804 702152 705741 710706 716848 716911 719139 721113 725970 725980 729864 733598 737070 737079 737174 740599 741313 744593 745759 748159 755846 758492 761347 777570 784490 784494 817242 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кастинг минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"casting blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.73%) |
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.