Query Metrics
7
Database Queries
7
Different statements
209.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.00 ms (88.36%) |
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 38452 122925 390714 396404 409046 419423 421415 421633 422236 422295 422444 423060 425910 429460 429909 437926 442691 447426 452901 452933 453539 459784 464343 465604 466535 467340 467383 467933 468106 470539 470776 471666 473226 474155 474652 478533 478907 483542 484674 484705 485963 489373 491107 492111 493121 496017 496024 496270 497199 497666 501718 504376 507370 507696 508737 509292 511492 511762 512147 513070 514897 515892 516684 517865 522519 524638 525399 536865 542580 543725 543823 550604 552662 558855 559200 563220 565645 565874 567877 569568 569579 573377 573788 573789 574196 574512 574828 576056 578164 578460 578463 585144 588595 594913 596871 599190 599295 603150 603218 605524 608772 609603 609694 610082 632258 632642 640525 647905 654421 681214 691224 692453 704205 765225 787564 788810 802122 803455 807619 823500 ] |
||||||||||||||||||||||||||||||
|
15.72 ms (7.51%) |
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 558855 802122 466535 543823 423060 565874 692453 409046 390714 524638 467933 543725 574196 691224 552662 588595 599190 609694 422295 38452 422236 565645 567877 512147 823500 485963 569579 478907 578164 491107 507370 569568 464343 609603 453539 573377 573789 787564 497199 497666 559200 578460 654421 765225 573788 594913 610082 470776 471666 681214 807619 421633 419423 522519 788810 437926 574828 640525 421415 467383 465604 473226 511762 468106 396404 452901 422444 122925 501718 474155 563220 574512 452933 509292 467340 605524 429460 525399 513070 576056 496024 507696 578463 470539 536865 478533 496017 429909 442691 515892 517865 459784 489373 474652 484674 484705 550604 599295 508737 511492 514897 425910 542580 585144 493121 608772 603218 632258 496270 647905 483542 704205 504376 596871 803455 492111 447426 603150 516684 632642 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.39%) |
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 38452 122925 390714 396404 409046 419423 421415 421633 422236 422295 422444 423060 425910 429460 429909 437926 442691 447426 452901 452933 453539 459784 464343 465604 466535 467340 467383 467933 468106 470539 470776 471666 473226 474155 474652 478533 478907 483542 484674 484705 485963 489373 491107 492111 493121 496017 496024 496270 497199 497666 501718 504376 507370 507696 508737 509292 511492 511762 512147 513070 514897 515892 516684 517865 522519 524638 525399 536865 542580 543725 543823 550604 552662 558855 559200 563220 565645 565874 567877 569568 569579 573377 573788 573789 574196 574512 574828 576056 578164 578460 578463 585144 588595 594913 596871 599190 599295 603150 603218 605524 608772 609603 609694 610082 632258 632642 640525 647905 654421 681214 691224 692453 704205 765225 787564 788810 802122 803455 807619 823500 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anna sex"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.68%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.31 ms (0.63%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"anna секс"
]
|
||||||||||||||||||||||||||||||
|
1.21 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"anna секс"
]
|
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.