Query Metrics
7
Database Queries
7
Different statements
145.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.63 ms (82.23%) |
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 146508 233369 382794 392489 403419 411619 421917 422152 423837 424473 428137 428148 439738 439765 439795 443704 444002 445107 448055 457441 460294 462584 464481 465371 465844 465948 466080 466129 466180 466748 468076 470590 473317 474394 474495 475807 475867 477989 479477 483411 483650 484659 486964 490210 491078 491969 492434 496865 502814 504414 505069 505254 509043 509427 510425 510750 517554 517599 519072 520911 524384 524780 525844 525890 528452 533732 538970 539450 546981 549787 549840 555017 555989 557571 560392 560867 563075 563084 563163 563171 563187 563206 563401 564337 569983 573468 590410 601938 605973 612404 618861 620754 714324 725206 733323 738309 741771 742742 747069 751560 752647 754361 758804 759397 761711 761743 762379 765255 765374 765860 766537 767078 779069 794864 796194 797336 799802 803880 807304 807331 ] |
||||||||||||||||||||||||||||||
|
16.79 ms (11.54%) |
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 742742 767078 612404 477989 428148 466129 479477 517554 564337 555989 557571 448055 492434 510425 439738 555017 569983 560392 549787 573468 765860 421917 491969 465948 465844 470590 475807 423837 462584 563206 146508 443704 468076 605973 794864 752647 807304 759397 754361 758804 803880 524780 466180 466748 483650 457441 601938 392489 546981 741771 444002 473317 509427 563163 560867 563171 563075 733323 538970 525844 439765 439795 509043 620754 533732 563401 714324 779069 796194 797336 738309 751560 765255 765374 761711 233369 382794 422152 428137 411619 464481 445107 460294 517599 483411 505069 505254 590410 524384 528452 475867 465371 403419 504414 474394 491078 496865 502814 525890 486964 490210 520911 563187 799802 761743 807331 766537 762379 747069 539450 563084 549840 618861 725206 424473 474495 466080 510750 519072 484659 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.83%) |
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 146508 233369 382794 392489 403419 411619 421917 422152 423837 424473 428137 428148 439738 439765 439795 443704 444002 445107 448055 457441 460294 462584 464481 465371 465844 465948 466080 466129 466180 466748 468076 470590 473317 474394 474495 475807 475867 477989 479477 483411 483650 484659 486964 490210 491078 491969 492434 496865 502814 504414 505069 505254 509043 509427 510425 510750 517554 517599 519072 520911 524384 524780 525844 525890 528452 533732 538970 539450 546981 549787 549840 555017 555989 557571 560392 560867 563075 563084 563163 563171 563187 563206 563401 564337 569983 573468 590410 601938 605973 612404 618861 620754 714324 725206 733323 738309 741771 742742 747069 751560 752647 754361 758804 759397 761711 761743 762379 765255 765374 765860 766537 767078 779069 794864 796194 797336 799802 803880 807304 807331 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian bathroom mature"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск ван mature"
]
|
||||||||||||||||||||||||||||||
|
1.26 ms (0.87%) |
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.