Query Metrics
7
Database Queries
7
Different statements
190.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.02 ms (86.66%) |
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 326158 382443 389458 390058 397366 402125 420593 421851 422161 424931 439635 439791 439856 443375 446173 449360 453230 453453 455523 456960 457432 457542 458942 461989 462350 462943 463051 465996 466288 468804 469781 470799 472063 473913 479027 479916 481851 482289 483022 485754 490001 492553 497005 499295 500046 501030 503321 507647 509414 511132 511778 511789 511803 512544 512549 513393 513563 514570 514693 518016 518980 519151 521932 522987 523213 523850 525610 526026 526058 526176 527060 527731 528128 528659 533877 542745 545492 546393 548158 548684 551443 552071 559960 560366 561830 565321 566107 567436 569581 574062 582554 588802 591004 591453 591539 592386 592797 593835 602601 605486 615622 621136 622360 625089 666486 697002 705346 711685 726538 768844 770947 775473 791730 796105 797756 803428 807374 809502 811000 823364 ] |
||||||||||||||||||||||||||||||
|
14.18 ms (7.45%) |
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 453453 462350 483022 622360 473913 775473 509414 526176 513393 511803 382443 711685 625089 402125 482289 574062 523213 528659 605486 439635 443375 469781 511778 621136 397366 461989 593835 326158 527060 528128 546393 566107 548158 582554 592797 602601 791730 809502 697002 462943 421851 811000 390058 446173 492553 455523 456960 705346 560366 591539 615622 591453 592386 796105 513563 501030 525610 807374 666486 468804 424931 463051 497005 526026 545492 565321 551443 768844 797756 465996 481851 514570 526058 512549 389458 521932 453230 533877 561830 559960 527731 485754 457432 518016 470799 499295 552071 726538 770947 803428 457542 458942 823364 439856 449360 422161 512544 511132 466288 439791 523850 569581 514693 479916 548684 588802 507647 500046 420593 542745 479027 519151 490001 503321 472063 591004 511789 522987 567436 518980 ] |
||||||||||||||||||||||||||||||
|
4.17 ms (2.19%) |
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 326158 382443 389458 390058 397366 402125 420593 421851 422161 424931 439635 439791 439856 443375 446173 449360 453230 453453 455523 456960 457432 457542 458942 461989 462350 462943 463051 465996 466288 468804 469781 470799 472063 473913 479027 479916 481851 482289 483022 485754 490001 492553 497005 499295 500046 501030 503321 507647 509414 511132 511778 511789 511803 512544 512549 513393 513563 514570 514693 518016 518980 519151 521932 522987 523213 523850 525610 526026 526058 526176 527060 527731 528128 528659 533877 542745 545492 546393 548158 548684 551443 552071 559960 560366 561830 565321 566107 567436 569581 574062 582554 588802 591004 591453 591539 592386 592797 593835 602601 605486 615622 621136 622360 625089 666486 697002 705346 711685 726538 768844 770947 775473 791730 796105 797756 803428 807374 809502 811000 823364 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"kitchen blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кухн минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.