Query Metrics
7
Database Queries
7
Different statements
364.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.61 ms (57.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на mature улиц жен"
]
|
||||||||||||||||||||||||||||||
|
131.83 ms (36.18%) |
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 232085 397932 440939 459918 465246 472812 472814 507114 512424 522772 534628 535408 536066 540054 540055 540104 541071 541565 548022 548104 551891 552283 553610 553932 555319 556673 558095 566912 570931 575028 577002 578772 580944 581180 585091 589580 592159 593028 599763 606052 607017 610023 615014 618189 619646 635357 643241 651741 655542 659956 661576 664655 666991 669930 676760 677916 692683 692713 692721 692763 696432 698802 700177 707562 709987 712660 713951 716137 717600 724731 726886 728261 728276 730665 731002 734030 738950 740747 746098 746840 761159 765796 768048 768456 769508 778934 779722 779767 779797 780827 783525 785526 786200 787021 787145 787485 788795 788988 791308 791309 791317 794489 797920 798709 805072 808710 810105 813298 814058 818987 819001 819148 819314 819521 823775 823841 824888 828016 828098 828315 ] |
||||||||||||||||||||||||||||||
|
13.45 ms (3.69%) |
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 698802 692683 635357 791308 786200 791309 740747 768048 700177 548022 696432 692713 731002 607017 819314 823841 522772 746840 615014 746098 581180 787145 797920 472812 814058 548104 541071 823775 664655 783525 791317 734030 459918 788795 558095 726886 730665 541565 810105 512424 232085 824888 540054 593028 606052 651741 713951 787485 738950 765796 717600 580944 507114 828098 659956 661576 676760 779722 768456 813298 619646 728276 577002 655542 692763 709987 712660 692721 666991 669930 707562 716137 592159 779767 805072 808710 724731 728261 769508 787021 788988 589580 535408 818987 465246 553932 570931 677916 599763 610023 778934 794489 780827 779797 798709 397932 551891 555319 643241 761159 566912 472814 578772 440939 552283 575028 819521 536066 819001 585091 556673 553610 828315 534628 618189 785526 819148 828016 540055 540104 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (0.77%) |
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 232085 397932 440939 459918 465246 472812 472814 507114 512424 522772 534628 535408 536066 540054 540055 540104 541071 541565 548022 548104 551891 552283 553610 553932 555319 556673 558095 566912 570931 575028 577002 578772 580944 581180 585091 589580 592159 593028 599763 606052 607017 610023 615014 618189 619646 635357 643241 651741 655542 659956 661576 664655 666991 669930 676760 677916 692683 692713 692721 692763 696432 698802 700177 707562 709987 712660 713951 716137 717600 724731 726886 728261 728276 730665 731002 734030 738950 740747 746098 746840 761159 765796 768048 768456 769508 778934 779722 779767 779797 780827 783525 785526 786200 787021 787145 787485 788795 788988 791308 791309 791317 794489 797920 798709 805072 808710 810105 813298 814058 818987 819001 819148 819314 819521 823775 823841 824888 828016 828098 828315 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.54%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public mature wife"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на mature улиц жен"
]
|
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.