Query Metrics
7
Database Queries
7
Different statements
161.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.45 ms (86.22%) |
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 4463 48235 89895 100642 182135 188014 188337 188403 188699 320078 326115 346209 346979 358264 381972 385461 388350 395592 395724 395974 398800 402346 408009 409316 412984 413283 415292 417015 428919 432618 432852 441207 443371 446274 448002 449094 457585 458083 464929 465522 466559 466679 468434 470234 471975 472581 473486 476074 478413 479821 485136 485311 489953 493758 493899 499617 505252 506069 511027 513114 522614 545342 547464 547476 556899 559360 562225 565164 568478 576641 597165 600179 604306 610960 617825 632650 639736 641879 646661 664087 668672 669016 686009 699594 699744 699745 702463 707319 716055 716703 719929 720815 721027 723643 733537 739868 747292 750554 751627 756642 760604 761570 771974 777361 785859 786763 798255 800495 801959 802610 805434 805738 807196 807352 809122 811118 813115 815093 819078 821065 ] |
||||||||||||||||||||||||||||||
|
13.24 ms (8.19%) |
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 771974 798255 805738 733537 747292 756642 632650 721027 777361 471975 358264 398800 604306 466679 188699 188337 395974 346979 381972 402346 470234 493899 446274 443371 646661 417015 432618 385461 182135 819078 815093 821065 556899 576641 699594 716703 641879 813115 760604 801959 807196 739868 699744 699745 707319 395724 408009 448002 489953 807352 409316 449094 473486 428919 457585 720815 346209 568478 188014 413283 4463 545342 547464 547476 559360 565164 669016 686009 716055 600179 597165 800495 805434 809122 750554 785859 786763 811118 751627 761570 617825 639736 702463 388350 89895 320078 802610 395592 476074 432852 506069 668672 326115 48235 466559 468434 479821 464929 485311 719929 441207 499617 522614 513114 100642 412984 458083 478413 485136 493758 465522 562225 610960 188403 415292 505252 723643 472581 511027 664087 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.56%) |
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 4463 48235 89895 100642 182135 188014 188337 188403 188699 320078 326115 346209 346979 358264 381972 385461 388350 395592 395724 395974 398800 402346 408009 409316 412984 413283 415292 417015 428919 432618 432852 441207 443371 446274 448002 449094 457585 458083 464929 465522 466559 466679 468434 470234 471975 472581 473486 476074 478413 479821 485136 485311 489953 493758 493899 499617 505252 506069 511027 513114 522614 545342 547464 547476 556899 559360 562225 565164 568478 576641 597165 600179 604306 610960 617825 632650 639736 641879 646661 664087 668672 669016 686009 699594 699744 699745 702463 707319 716055 716703 719929 720815 721027 723643 733537 739868 747292 750554 751627 756642 760604 761570 771974 777361 785859 786763 798255 800495 801959 802610 805434 805738 807196 807352 809122 811118 813115 815093 819078 821065 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal mother"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.30 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.