Query Metrics
7
Database Queries
7
Different statements
156.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.23 ms (84.66%) |
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 11969 395166 399659 408248 412018 428347 447693 463084 465480 469484 477104 480780 485426 532373 536365 537000 537804 540435 543862 555612 557170 561566 565047 574369 574445 579737 595374 603425 604880 604911 606853 609806 612918 613792 618181 625451 642213 644253 645052 645805 652190 654174 662030 662039 668457 669196 679708 680947 683668 688335 693535 693987 698920 699011 700385 701733 702154 706995 712527 715006 715844 715904 716841 716852 718398 721184 721751 724261 724453 725451 726179 727282 728483 735435 735864 738847 741064 741608 741899 744651 755157 758267 761417 761546 765308 769217 772525 776582 776865 776954 797385 798271 801913 802966 803081 807411 813068 813693 815288 815460 818429 818434 818857 818907 819263 819381 819486 819852 820131 823538 823927 824262 824559 824737 826863 826992 828264 828516 828535 828679 ] |
||||||||||||||||||||||||||||||
|
13.01 ms (8.33%) |
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 818429 818434 820131 813693 819263 819486 824737 679708 683668 700385 662030 721751 603425 776865 772525 807411 699011 721184 537804 595374 741899 724453 824559 826992 824262 536365 693987 802966 769217 11969 815288 815460 485426 532373 574445 579737 702154 798271 758267 609806 555612 761417 738847 465480 480780 716852 712527 728483 755157 469484 803081 823927 688335 718398 680947 652190 613792 604911 776582 744651 716841 776954 828264 828679 828516 447693 574369 725451 463084 428347 828535 537000 565047 715844 612918 604880 797385 741608 765308 724261 727282 715904 813068 412018 826863 819852 698920 715006 735864 735435 741064 761546 399659 408248 654174 395166 477104 540435 642213 726179 818907 818857 819381 823538 543862 557170 561566 701733 706995 645052 645805 662039 668457 669196 693535 644253 606853 618181 625451 801913 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.96%) |
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 11969 395166 399659 408248 412018 428347 447693 463084 465480 469484 477104 480780 485426 532373 536365 537000 537804 540435 543862 555612 557170 561566 565047 574369 574445 579737 595374 603425 604880 604911 606853 609806 612918 613792 618181 625451 642213 644253 645052 645805 652190 654174 662030 662039 668457 669196 679708 680947 683668 688335 693535 693987 698920 699011 700385 701733 702154 706995 712527 715006 715844 715904 716841 716852 718398 721184 721751 724261 724453 725451 726179 727282 728483 735435 735864 738847 741064 741608 741899 744651 755157 758267 761417 761546 765308 769217 772525 776582 776865 776954 797385 798271 801913 802966 803081 807411 813068 813693 815288 815460 818429 818434 818857 818907 819263 819381 819486 819852 820131 823538 823927 824262 824559 824737 826863 826992 828264 828516 828535 828679 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big cock milf"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие cock milf"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие cock milf"
]
|
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.