Query Metrics
7
Database Queries
7
Different statements
180.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.19 ms (86.44%) |
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 46580 145502 422389 433445 434530 439564 446735 447248 447501 450995 451943 453035 454752 454844 455906 457241 464949 480486 488496 495715 496475 496667 497386 498817 505397 519090 528003 531160 531574 533977 534319 536402 543893 553175 561883 563252 571481 573308 594481 595665 595676 595706 595730 595747 595751 598666 599497 600045 600945 604510 606136 606873 607126 607610 609756 612401 612429 615647 615846 631595 644562 646213 647621 651909 666418 672588 676374 681597 682352 682989 687119 688351 707356 716409 716641 719832 722234 722546 725601 726612 728625 730444 730902 733498 737450 747436 749735 751688 755377 755399 755854 766486 771795 772681 774716 775101 776314 780046 784396 784973 788208 792622 793358 793628 798307 802846 805526 807355 810607 812943 813816 817233 818297 818335 819569 820644 821373 821473 823804 825115 ] |
||||||||||||||||||||||||||||||
|
13.64 ms (7.55%) |
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 433445 434530 464949 818297 447248 480486 561883 646213 716409 688351 644562 776314 802846 755854 447501 446735 422389 531160 825115 455906 450995 681597 707356 612401 631595 755377 755399 792622 805526 812943 454844 533977 531574 793358 536402 817233 819569 820644 818335 823804 505397 519090 534319 543893 571481 651909 666418 676374 722546 647621 719832 573308 607126 595665 600045 604510 615846 784973 733498 747436 813816 784396 451943 498817 728625 749735 439564 528003 722234 595747 595751 725601 788208 726612 563252 751688 810607 595730 453035 496475 496667 145502 682352 716641 687119 798307 807355 737450 730444 775101 780046 495715 821373 821473 672588 682989 553175 595706 609756 615647 594481 606873 774716 766486 772681 730902 771795 607610 612429 793628 497386 454752 606136 598666 457241 600945 46580 599497 488496 595676 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (1.91%) |
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 46580 145502 422389 433445 434530 439564 446735 447248 447501 450995 451943 453035 454752 454844 455906 457241 464949 480486 488496 495715 496475 496667 497386 498817 505397 519090 528003 531160 531574 533977 534319 536402 543893 553175 561883 563252 571481 573308 594481 595665 595676 595706 595730 595747 595751 598666 599497 600045 600945 604510 606136 606873 607126 607610 609756 612401 612429 615647 615846 631595 644562 646213 647621 651909 666418 672588 676374 681597 682352 682989 687119 688351 707356 716409 716641 719832 722234 722546 725601 726612 728625 730444 730902 733498 737450 747436 749735 751688 755377 755399 755854 766486 771795 772681 774716 775101 776314 780046 784396 784973 788208 792622 793358 793628 798307 802846 805526 807355 810607 812943 813816 817233 818297 818335 819569 820644 821373 821473 823804 825115 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"поз 69 глубокийминет минет оральн секс gagging"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"поз 69 глубокийминет минет оральн секс gagging"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"69 deepthroat gagging"
]
|
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.