Query Metrics
7
Database Queries
7
Different statements
629.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
370.33 ms (58.80%) |
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 382347 384118 391246 395227 396194 411604 414650 423651 424213 425304 425306 425712 427792 432181 435298 437544 444528 446072 446505 455852 458738 460099 464604 465859 466614 470293 474425 475969 477719 480292 481388 484107 486586 486903 489697 494282 499846 508035 511196 511366 512936 514480 514738 514999 515108 516411 516650 517529 518415 520934 521922 522344 523950 524503 524741 525619 527195 527535 529247 532312 532314 536918 538117 539729 540153 543247 543821 544153 545855 549241 551267 551926 552259 552843 557306 558308 560472 561929 562363 564628 565723 565780 569153 570185 571446 572109 572205 572368 574657 574955 575017 581202 581336 584114 591823 598585 600074 600878 605905 606561 607321 614382 615729 615801 617575 617647 619076 620239 623841 642413 655088 660570 660918 672384 673074 675141 683901 707396 798762 ] |
||||||||||||||||||||||||||||||
|
220.71 ms (35.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс в одежд домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
29.22 ms (4.64%) |
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 551267 551926 660570 529247 425304 539729 572205 560472 574657 414650 545855 642413 437544 465859 520934 516650 466614 524503 516411 527195 707396 521922 480292 581202 605905 617575 508035 444528 432181 607321 600074 536918 619076 675141 565723 565780 584114 477719 562363 591823 558308 514738 474425 511366 572368 581336 532312 395227 572109 458738 396194 514999 489697 512936 569153 552843 494282 798762 481388 615729 475969 446072 526388 517529 423651 470293 391246 425306 523950 455852 435298 518415 525619 683901 620239 617647 424213 615801 598585 606561 570185 538117 486586 486903 571446 623841 484107 575017 574955 411604 552259 543821 600878 460099 522344 514480 382347 549241 655088 564628 561929 557306 540153 532314 425712 499846 515108 527535 543247 673074 660918 672384 614382 384118 524741 544153 511196 446505 464604 427792 ] |
||||||||||||||||||||||||||||||
|
3.84 ms (0.61%) |
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 382347 384118 391246 395227 396194 411604 414650 423651 424213 425304 425306 425712 427792 432181 435298 437544 444528 446072 446505 455852 458738 460099 464604 465859 466614 470293 474425 475969 477719 480292 481388 484107 486586 486903 489697 494282 499846 508035 511196 511366 512936 514480 514738 514999 515108 516411 516650 517529 518415 520934 521922 522344 523950 524503 524741 525619 527195 527535 529247 532312 532314 536918 538117 539729 540153 543247 543821 544153 545855 549241 551267 551926 552259 552843 557306 558308 560472 561929 562363 564628 565723 565780 569153 570185 571446 572109 572205 572368 574657 574955 575017 581202 581336 584114 591823 598585 600074 600878 605905 606561 607321 614382 615729 615801 617575 617647 619076 620239 623841 642413 655088 660570 660918 672384 673074 675141 683901 707396 798762 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (0.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"отсос в одежде домашн…"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс в одежд домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.27%) |
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.