Query Metrics
7
Database Queries
7
Different statements
179.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.47 ms (85.17%) |
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 61226 79683 382955 384532 387599 395459 407762 418272 418699 423880 430014 443055 445723 445747 448647 451479 454649 455386 461512 465741 465756 466538 472778 474538 475492 480223 480328 484140 487376 488190 489874 492123 495682 495968 497022 497331 497746 498056 510079 510864 516497 521280 521686 521812 524468 528628 529255 531308 538062 539338 539524 540195 543378 543910 545172 546381 551540 555112 557168 565720 565859 571710 572918 578571 581030 584070 585735 587655 589624 590480 591418 591741 591960 593618 594401 594825 594826 595115 595404 597031 599973 600482 601024 601027 603623 603992 615042 623288 630119 630562 631286 633853 637488 639051 643315 657529 670246 670456 675095 677020 697180 701573 720618 724361 726507 726702 729264 733048 737152 748159 762848 770278 772681 776316 781980 795497 795918 800316 805474 809516 ] |
||||||||||||||||||||||||||||||
|
16.30 ms (9.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 539338 539524 516497 540195 551540 571710 584070 557168 670246 701573 670456 697180 657529 555112 578571 585735 587655 589624 594401 594826 595404 590480 591741 637488 591960 630562 776316 795497 795918 724361 729264 733048 772681 805474 748159 726702 737152 770278 726507 615042 781980 382955 466538 61226 423880 480328 395459 418699 465741 465756 475492 430014 445747 461512 484140 489874 495968 497331 497746 454649 565720 677020 603992 510079 495682 601027 603623 384532 407762 487376 445723 492123 510864 528628 531308 538062 497022 521280 521812 529255 524468 472778 474538 480223 546381 543910 545172 543378 572918 581030 675095 720618 565859 639051 594825 633853 643315 591418 623288 630119 593618 595115 597031 599973 600482 601024 631286 809516 762848 800316 443055 448647 79683 387599 418272 451479 455386 521686 488190 498056 ] |
||||||||||||||||||||||||||||||
|
2.99 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 61226 79683 382955 384532 387599 395459 407762 418272 418699 423880 430014 443055 445723 445747 448647 451479 454649 455386 461512 465741 465756 466538 472778 474538 475492 480223 480328 484140 487376 488190 489874 492123 495682 495968 497022 497331 497746 498056 510079 510864 516497 521280 521686 521812 524468 528628 529255 531308 538062 539338 539524 540195 543378 543910 545172 546381 551540 555112 557168 565720 565859 571710 572918 578571 581030 584070 585735 587655 589624 590480 591418 591741 591960 593618 594401 594825 594826 595115 595404 597031 599973 600482 601024 601027 603623 603992 615042 623288 630119 630562 631286 633853 637488 639051 643315 657529 670246 670456 675095 677020 697180 701573 720618 724361 726507 726702 729264 733048 737152 748159 762848 770278 772681 776316 781980 795497 795918 800316 805474 809516 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sucking and licking"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sucking лиза"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sucking лиза"
]
|
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.