Query Metrics
7
Database Queries
7
Different statements
167.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.52 ms (81.07%) |
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 355579 384239 386823 394204 400233 403761 414008 415584 418971 419014 420238 444135 451545 451715 453129 453155 453453 455320 455351 457224 457302 458233 458692 460059 460174 460424 464008 464459 465996 470716 471003 471821 471973 472160 473981 474122 474142 480639 481797 481851 482923 483567 485286 485754 486441 492553 494959 494967 497441 499010 499065 500643 501028 501915 503949 504195 504384 508723 509360 512249 512739 513051 513832 514694 516834 518145 518980 519433 519659 522265 523729 525980 526463 526687 532999 534278 542602 545895 546631 548024 548788 550502 561886 562291 565773 567405 570199 573371 573716 577364 578495 581901 584128 584152 591004 591061 591514 591549 599010 599720 609271 610112 619582 620054 620430 621687 622410 631253 642404 663875 680904 682187 682234 687190 725722 731048 796552 801426 802074 810421 ] |
||||||||||||||||||||||||||||||
|
21.55 ms (12.89%) |
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 599720 512739 561886 546631 621687 591514 591549 465996 481851 610112 599010 642404 500643 522265 534278 578495 494959 573716 508723 474122 663875 457224 471973 499065 403761 458233 482923 584128 485286 472160 542602 386823 503949 570199 573371 394204 509360 584152 415584 526687 591061 497441 513832 514694 567405 518980 581901 501028 471003 577364 464459 474142 455320 550502 562291 622410 526463 486441 519659 516834 464008 451545 504195 525980 682187 619582 420238 418971 501915 513051 451715 483567 519433 481797 485754 458692 492553 453453 453155 457302 523729 480639 545895 682234 680904 731048 473981 460424 548788 532999 499010 620054 609271 444135 414008 565773 470716 453129 504384 687190 518145 512249 460174 460059 494967 455351 471821 419014 548024 620430 355579 802074 801426 796552 631253 725722 810421 591004 384239 400233 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (1.99%) |
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 355579 384239 386823 394204 400233 403761 414008 415584 418971 419014 420238 444135 451545 451715 453129 453155 453453 455320 455351 457224 457302 458233 458692 460059 460174 460424 464008 464459 465996 470716 471003 471821 471973 472160 473981 474122 474142 480639 481797 481851 482923 483567 485286 485754 486441 492553 494959 494967 497441 499010 499065 500643 501028 501915 503949 504195 504384 508723 509360 512249 512739 513051 513832 514694 516834 518145 518980 519433 519659 522265 523729 525980 526463 526687 532999 534278 542602 545895 546631 548024 548788 550502 561886 562291 565773 567405 570199 573371 573716 577364 578495 581901 584128 584152 591004 591061 591514 591549 599010 599720 609271 610112 619582 620054 620430 621687 622410 631253 642404 663875 680904 682187 682234 687190 725722 731048 796552 801426 802074 810421 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кухн секс"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"kitchen sex"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кухн секс"
]
|
||||||||||||||||||||||||||||||
|
1.50 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.