Query Metrics
8
Database Queries
8
Different statements
232.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.73 ms (88.64%) |
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 137159 400861 405777 409060 420308 421437 424234 428177 432696 434342 435512 439292 439704 440910 441579 444928 446626 448374 452202 452772 453033 453040 453727 455668 456220 460503 461681 462285 465545 466027 475474 478073 478387 478564 481748 482433 483579 487883 489014 491040 493568 496504 496743 496746 496772 497507 499869 500546 508684 514839 523465 525878 526082 533745 539928 544189 544423 558885 574927 579858 580595 582557 583449 586019 589185 605144 616790 620233 620661 621246 631356 633243 640346 660821 663772 679646 685404 695803 700846 702031 702040 702130 710418 714771 716572 720174 723455 726974 729299 731471 732262 734324 736784 739946 740826 742343 744970 749920 750248 757726 758509 758510 759717 760859 760940 761108 765512 765721 777634 792546 793877 795316 796905 797151 797461 800442 802151 804309 813559 818824 ] |
||||||||||||||||||||||||||||||
|
15.81 ms (6.81%) |
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 496743 533745 500546 514839 526082 539928 460503 482433 489014 544423 583449 679646 685404 695803 702031 702130 663772 702040 586019 620661 640346 589185 616790 621246 620233 633243 605144 802151 726974 732262 749920 758509 765512 765721 797461 804309 734324 742343 744970 760940 736784 740826 757726 731471 716572 720174 796905 441579 444928 465545 478387 434342 461681 453033 478073 508684 496504 487883 475474 497507 579858 580595 574927 440910 800442 456220 452772 462285 439704 491040 420308 544189 760859 525878 137159 793877 631356 405777 813559 818824 448374 710418 714771 723455 660821 700846 558885 777634 797151 750248 729299 739946 758510 759717 761108 792546 795316 424234 466027 582557 523465 400861 409060 439292 432696 421437 435512 428177 452202 481748 455668 446626 453040 453727 496746 499869 496772 478564 483579 493568 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.15%) |
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 137159 400861 405777 409060 420308 421437 424234 428177 432696 434342 435512 439292 439704 440910 441579 444928 446626 448374 452202 452772 453033 453040 453727 455668 456220 460503 461681 462285 465545 466027 475474 478073 478387 478564 481748 482433 483579 487883 489014 491040 493568 496504 496743 496746 496772 497507 499869 500546 508684 514839 523465 525878 526082 533745 539928 544189 544423 558885 574927 579858 580595 582557 583449 586019 589185 605144 616790 620233 620661 621246 631356 633243 640346 660821 663772 679646 685404 695803 700846 702031 702040 702130 710418 714771 716572 720174 723455 726974 729299 731471 732262 734324 736784 739946 740826 742343 744970 749920 750248 757726 758509 758510 759717 760859 760940 761108 765512 765721 777634 792546 793877 795316 796905 797151 797461 800442 802151 804309 813559 818824 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен анал fucked"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.72%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01–\x1AM1ZrA¬xÌ·¨\x08\f«"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife anal fucked"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен анал fucked"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.64%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.