Query Metrics
7
Database Queries
7
Different statements
185.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.70 ms (87.27%) |
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 420730 422392 426680 427406 446125 447076 447094 453638 455356 456387 456858 462533 466491 472765 474809 475860 475907 475986 479955 479962 479964 480191 485258 485619 490816 490945 491391 492158 492341 492986 493367 497574 499018 499021 499073 500134 500576 501415 503165 504220 506230 507625 507627 507630 509110 510122 510521 511820 513344 514131 518970 519335 520093 520361 521725 522513 524105 524180 524314 524359 526865 526872 527175 527316 527851 528590 528660 530307 530578 533653 534119 534744 535050 535640 535746 535748 537971 552798 555701 565420 565769 566371 566585 569788 572943 574387 575539 575557 581213 582920 584465 591275 591389 591728 597152 602944 603783 604257 609235 610952 612068 622830 623211 623495 623815 625771 626015 650197 660664 665990 670056 671886 671888 690943 691137 696429 712763 727828 733319 783237 ] |
||||||||||||||||||||||||||||||
|
15.39 ms (8.31%) |
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 462533 455356 510521 524180 492158 507625 514131 519335 524359 527316 420730 490816 671886 650197 610952 727828 497574 524314 491391 530578 534119 509110 575539 581213 696429 665990 671888 591728 604257 712763 500134 533653 506230 535050 572943 555701 660664 479962 520093 528590 485619 507630 527175 537971 511820 534744 535746 530307 569788 552798 565769 783237 622830 527851 535640 492341 499018 456387 480191 475986 521725 566585 574387 566371 625771 475907 479964 479955 447076 504220 510122 513344 526865 522513 524105 492986 499021 520361 427406 456858 474809 623495 591389 623815 475860 422392 426680 528660 485258 490945 499073 453638 518970 503165 565420 472765 623211 612068 493367 691137 582920 597152 602944 603783 733319 507627 575557 690943 626015 609235 535748 591275 447094 500576 501415 584465 670056 466491 446125 526872 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.34%) |
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 420730 422392 426680 427406 446125 447076 447094 453638 455356 456387 456858 462533 466491 472765 474809 475860 475907 475986 479955 479962 479964 480191 485258 485619 490816 490945 491391 492158 492341 492986 493367 497574 499018 499021 499073 500134 500576 501415 503165 504220 506230 507625 507627 507630 509110 510122 510521 511820 513344 514131 518970 519335 520093 520361 521725 522513 524105 524180 524314 524359 526865 526872 527175 527316 527851 528590 528660 530307 530578 533653 534119 534744 535050 535640 535746 535748 537971 552798 555701 565420 565769 566371 566585 569788 572943 574387 575539 575557 581213 582920 584465 591275 591389 591728 597152 602944 603783 604257 609235 610952 612068 622830 623211 623495 623815 625771 626015 650197 660664 665990 670056 671886 671888 690943 691137 696429 712763 727828 733319 783237 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur porn"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск porn"
]
|
||||||||||||||||||||||||||||||
|
1.14 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск porn"
]
|
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.