Query Metrics
7
Database Queries
7
Different statements
156.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.04 ms (83.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 326158 366354 382443 389458 390058 397366 402125 420593 421851 422161 422188 424931 439635 439791 443375 443538 446173 449360 453230 455523 456960 457432 457542 458942 461989 462943 463051 465996 466288 468804 469781 470799 472063 479027 479916 481851 485754 490001 492553 497005 499295 499323 500046 501030 505622 507647 511132 511778 511789 511803 512215 512544 512549 513393 513563 514570 514693 518016 518980 519151 521932 522987 523213 523850 525610 526026 526058 527060 527731 528128 528659 531063 533877 542745 545492 546393 548158 548684 551443 552071 559960 560366 561830 565321 566107 567429 567436 569289 569581 574062 581901 582554 588802 591004 591453 591539 592386 592797 593835 602601 605486 610544 615622 621136 625089 666486 697002 705346 711685 726538 768844 770947 791730 796105 797756 803428 807374 809502 811000 823364 ] |
||||||||||||||||||||||||||||||
|
16.28 ms (10.44%) |
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 513393 511803 382443 711685 625089 402125 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 499323 453230 533877 561830 559960 527731 485754 457432 518016 470799 499295 552071 726538 770947 803428 457542 458942 823364 422188 449360 422161 512544 511132 466288 439791 523850 569581 514693 479916 548684 588802 507647 500046 420593 610544 542745 479027 519151 490001 472063 591004 511789 522987 567436 443538 518980 531063 569289 581901 505622 567429 512215 366354 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.44%) |
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 366354 382443 389458 390058 397366 402125 420593 421851 422161 422188 424931 439635 439791 443375 443538 446173 449360 453230 455523 456960 457432 457542 458942 461989 462943 463051 465996 466288 468804 469781 470799 472063 479027 479916 481851 485754 490001 492553 497005 499295 499323 500046 501030 505622 507647 511132 511778 511789 511803 512215 512544 512549 513393 513563 514570 514693 518016 518980 519151 521932 522987 523213 523850 525610 526026 526058 527060 527731 528128 528659 531063 533877 542745 545492 546393 548158 548684 551443 552071 559960 560366 561830 565321 566107 567429 567436 569289 569581 574062 581901 582554 588802 591004 591453 591539 592386 592797 593835 602601 605486 610544 615622 621136 625089 666486 697002 705346 711685 726538 768844 770947 791730 796105 797756 803428 807374 809502 811000 823364 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс кухн"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob kitchen"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс кухн"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.10%) |
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.