Query Metrics
7
Database Queries
7
Different statements
144.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.38 ms (82.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 145336 188561 389976 402138 411516 422720 426100 435566 435616 435632 437496 445227 445273 447729 453141 454597 467086 468003 469421 470820 484173 487783 490618 492959 496846 499372 505382 507776 508913 509936 516362 521247 527504 529639 529731 530416 530645 530710 531591 531760 532370 533312 533487 534732 534857 535292 536146 537474 539059 542235 542724 546164 547496 548179 550913 554492 554864 556164 559314 560228 561347 561975 571193 572926 574338 576437 576597 576618 579478 580914 582836 585861 588056 593184 593740 594312 594396 596028 596090 596414 601824 606315 613002 613503 613806 614673 625678 631129 634895 636138 639573 641753 647000 651651 661327 666606 666977 675897 680772 680950 681748 696459 709679 710439 727561 736864 738279 746575 753702 754516 754598 774081 776459 778045 782520 784137 790128 806194 810802 ] |
||||||||||||||||||||||||||||||
|
14.84 ms (10.28%) |
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 550913 576437 560228 588056 606315 634895 594396 593740 601824 435566 675897 496846 666606 516362 145336 445273 445227 507776 539059 530710 533487 554492 542235 661327 680772 680950 576618 625678 613002 613806 596090 782520 810802 784137 613503 710439 454597 484173 509936 531760 521247 534732 572926 411516 447729 470820 529639 530645 535292 574338 582836 651651 681748 647000 548179 576597 641753 593184 776459 790128 806194 754516 738279 746575 774081 778045 188561 487783 529731 696459 636138 736864 754598 753702 402138 554864 426100 389976 422720 435616 435632 490618 453141 530416 499372 533312 534857 536146 537474 527504 531591 492959 561347 579478 556164 559314 546164 666977 639573 585861 596414 594312 596028 727561 631129 709679 467086 469421 468003 437496 508913 614673 505382 532370 542724 571193 561975 580914 541345 547496 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (2.18%) |
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 145336 188561 389976 402138 411516 422720 426100 435566 435616 435632 437496 445227 445273 447729 453141 454597 467086 468003 469421 470820 484173 487783 490618 492959 496846 499372 505382 507776 508913 509936 516362 521247 527504 529639 529731 530416 530645 530710 531591 531760 532370 533312 533487 534732 534857 535292 536146 537474 539059 542235 542724 546164 547496 548179 550913 554492 554864 556164 559314 560228 561347 561975 571193 572926 574338 576437 576597 576618 579478 580914 582836 585861 588056 593184 593740 594312 594396 596028 596090 596414 601824 606315 613002 613503 613806 614673 625678 631129 634895 636138 639573 641753 647000 651651 661327 666606 666977 675897 680772 680950 681748 696459 709679 710439 727561 736864 738279 746575 753702 754516 754598 774081 776459 778045 782520 784137 790128 806194 810802 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло показыва вагин"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"соло показывают вагины"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло показыва вагин"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.04%) |
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.