Query Metrics
7
Database Queries
7
Different statements
150.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.00 ms (81.69%) |
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 390508 391423 392517 396334 396699 408240 422074 422382 424646 427592 432692 432790 437204 441519 443333 445050 446028 447007 447116 447951 453544 453690 454145 454534 460663 462757 464837 465267 467910 468956 469403 471190 471300 471330 471996 472399 472692 473222 473476 473748 473974 476975 478712 478833 479141 480714 480767 482925 484087 484423 486204 488948 489271 490171 490250 490518 490742 490879 492495 495607 496149 498423 503644 505803 508052 510456 510990 513552 514024 518451 522053 523330 526466 533409 533948 534494 535431 537960 541629 545814 546752 547865 552395 554552 556973 557930 558490 561844 561988 562883 563031 566557 569980 576516 578492 580418 589278 592956 593787 595549 602553 608725 608751 614689 615903 620291 622932 623388 665923 720132 725119 736470 741656 743068 750668 789868 794135 810697 814944 826874 ] |
||||||||||||||||||||||||||||||
|
17.19 ms (11.42%) |
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 725119 736470 741656 743068 750668 720132 489271 505803 589278 488948 490742 533409 546752 547865 814944 460663 569980 557930 592956 794135 608725 513552 464837 492495 562883 623388 810697 514024 427592 441519 422074 447007 465267 472399 486204 454534 473476 478833 490171 510990 526466 535431 480714 615903 789868 424646 447116 453690 462757 472692 473222 471300 391423 478712 523330 482925 490250 503644 537960 490518 490879 496149 533948 495607 522053 476975 422382 510456 396699 443333 454145 552395 541629 665923 554552 561844 561988 576516 578492 620291 593787 595549 602553 396334 467910 471330 484087 473974 446028 471190 453544 498423 480767 558490 447951 479141 432790 580418 445050 390508 408240 469403 556973 563031 566557 608751 614689 468956 545814 471996 437204 484423 622932 392517 432692 826874 473748 534494 508052 518451 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (2.03%) |
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 390508 391423 392517 396334 396699 408240 422074 422382 424646 427592 432692 432790 437204 441519 443333 445050 446028 447007 447116 447951 453544 453690 454145 454534 460663 462757 464837 465267 467910 468956 469403 471190 471300 471330 471996 472399 472692 473222 473476 473748 473974 476975 478712 478833 479141 480714 480767 482925 484087 484423 486204 488948 489271 490171 490250 490518 490742 490879 492495 495607 496149 498423 503644 505803 508052 510456 510990 513552 514024 518451 522053 523330 526466 533409 533948 534494 535431 537960 541629 545814 546752 547865 552395 554552 556973 557930 558490 561844 561988 562883 563031 566557 569980 576516 578492 580418 589278 592956 593787 595549 602553 608725 608751 614689 615903 620291 622932 623388 665923 720132 725119 736470 741656 743068 750668 789868 794135 810697 814944 826874 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"painful big cock"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"крича вперв большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"крича вперв большие cock"
]
|
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.