Query Metrics
7
Database Queries
7
Different statements
186.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.82 ms (88.04%) |
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 4250 386925 397353 401124 402340 404402 423714 438562 440667 441936 444819 445188 445331 479690 487389 501690 512865 515218 540306 548080 560238 561906 562318 573349 575344 583082 585638 600083 602413 607062 609854 614878 620614 625540 626481 635840 636982 641408 642926 650402 654882 665714 667268 677284 678940 680781 690032 699881 701500 702515 702630 706929 712583 713838 716529 717088 720138 726171 729923 729955 737553 742011 743278 744840 746364 748339 748906 751083 755373 757564 757673 758501 758959 758984 762780 765278 765484 765768 766223 770541 770958 771596 773480 777260 778937 781772 782505 786806 789511 789827 790038 790719 792175 792376 793727 794088 794917 794993 795858 798495 798618 799045 799349 799980 800104 800197 803038 804065 805107 805536 805995 810726 813562 813915 815456 818045 818660 819361 821369 823760 ] |
||||||||||||||||||||||||||||||
|
12.29 ms (6.60%) |
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 540306 512865 560238 667268 701500 778937 781772 789511 793727 798618 743278 744840 758501 758984 803038 805107 758959 729955 798495 4250 401124 440667 404402 445331 823760 815456 548080 665714 716529 706929 717088 573349 792175 795858 800104 748339 762780 794993 746364 757564 765768 770541 751083 771596 699881 702630 790719 799349 444819 386925 423714 813562 821369 479690 702515 677284 607062 625540 626481 782505 794088 810726 777260 792376 786806 794917 757673 748906 766223 799045 397353 402340 445188 819361 818045 818660 487389 515218 501690 654882 678940 561906 562318 602413 614878 636982 641408 642926 799980 737553 742011 773480 804065 755373 765278 770958 765484 720138 790038 800197 805536 805995 438562 441936 813915 575344 583082 712583 713838 650402 680781 690032 609854 600083 585638 635840 620614 789827 726171 729923 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.26%) |
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 4250 386925 397353 401124 402340 404402 423714 438562 440667 441936 444819 445188 445331 479690 487389 501690 512865 515218 540306 548080 560238 561906 562318 573349 575344 583082 585638 600083 602413 607062 609854 614878 620614 625540 626481 635840 636982 641408 642926 650402 654882 665714 667268 677284 678940 680781 690032 699881 701500 702515 702630 706929 712583 713838 716529 717088 720138 726171 729923 729955 737553 742011 743278 744840 746364 748339 748906 751083 755373 757564 757673 758501 758959 758984 762780 765278 765484 765768 766223 770541 770958 771596 773480 777260 778937 781772 782505 786806 789511 789827 790038 790719 792175 792376 793727 794088 794917 794993 795858 798495 798618 799045 799349 799980 800104 800197 803038 804065 805107 805536 805995 810726 813562 813915 815456 818045 818660 819361 821369 823760 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex rough"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс rough"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс rough"
]
|
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.