Query Metrics
7
Database Queries
7
Different statements
156.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.75 ms (85.60%) |
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 207540 423825 445936 457319 457849 457934 469137 470550 473372 477362 483005 483085 486290 487615 488604 497426 503461 507310 508039 508593 508748 510200 510557 511162 511328 515234 516669 516975 516982 516989 517650 517683 520482 520837 520890 521078 521849 523182 525171 525935 526440 527029 527812 527939 529104 529175 533339 533353 534850 536136 536151 536637 541370 542059 544898 545639 552919 554783 557503 560515 562106 565149 567147 569663 570737 571829 576400 578463 578497 580769 581673 581852 583037 587152 587286 588600 588716 589600 590881 590899 592619 593833 595037 596360 598243 599274 599414 600498 603191 603210 604554 606808 607750 610002 615774 617322 618668 619455 620206 622188 623619 624137 624931 624990 640697 647362 650532 652897 662801 663835 668139 673522 674360 679092 679109 687461 687484 717179 753240 802734 ] |
||||||||||||||||||||||||||||||
|
13.33 ms (8.53%) |
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 523182 640697 457934 445936 517683 511328 503461 527029 508039 571829 576400 662801 668139 674360 650532 588600 592619 599274 618668 588716 619455 607750 587152 536151 527939 544898 560515 647362 717179 600498 603191 624990 802734 511162 521078 554783 673522 525935 526440 527812 570737 652897 598243 590899 595037 615774 508748 473372 603210 623619 606808 470550 488604 510200 516975 536637 542059 557503 565149 569663 580769 545639 578497 679092 663835 687461 589600 622188 624137 596360 599414 497426 520837 753240 469137 483085 487615 516669 520890 533339 552919 578463 581673 583037 679109 620206 604554 617322 587286 593833 624931 529104 483005 510557 525171 517650 536136 508593 610002 457319 423825 207540 590881 520482 533353 541370 477362 529175 562106 581852 567147 457849 687484 486290 507310 534850 515234 516982 516989 521849 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.66%) |
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 207540 423825 445936 457319 457849 457934 469137 470550 473372 477362 483005 483085 486290 487615 488604 497426 503461 507310 508039 508593 508748 510200 510557 511162 511328 515234 516669 516975 516982 516989 517650 517683 520482 520837 520890 521078 521849 523182 525171 525935 526440 527029 527812 527939 529104 529175 533339 533353 534850 536136 536151 536637 541370 542059 544898 545639 552919 554783 557503 560515 562106 565149 567147 569663 570737 571829 576400 578463 578497 580769 581673 581852 583037 587152 587286 588600 588716 589600 590881 590899 592619 593833 595037 596360 598243 599274 599414 600498 603191 603210 604554 606808 607750 610002 615774 617322 618668 619455 620206 622188 623619 624137 624931 624990 640697 647362 650532 652897 662801 663835 668139 673522 674360 679092 679109 687461 687484 717179 753240 802734 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трет вагин"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"трётся пись"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"трет вагин"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.90%) |
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.