Query Metrics
7
Database Queries
7
Different statements
207.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.45 ms (86.49%) |
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 389729 390447 394514 416663 422044 424002 424679 437548 439029 439405 446002 446238 446709 454931 454943 467568 470949 474349 482632 485267 487363 492364 492525 492701 493391 495070 495397 497690 498297 500912 501382 505804 509982 511313 513485 514248 514660 515545 520343 521681 522307 523354 523357 524676 526167 526894 527915 528281 533846 533928 535434 536639 536666 536691 541832 542692 543840 548130 550579 555065 555116 565254 578631 578952 581850 583508 585392 585826 587235 591021 599976 602928 604109 604865 606549 608939 619965 620268 624742 628126 628315 630297 630533 634138 636315 639159 640948 646450 650598 651647 653302 660383 662603 668461 672383 680428 692314 695199 696582 699397 700685 704205 716550 717550 724264 748521 761231 770410 780269 783486 785500 785880 789746 795396 796057 803524 803631 810822 811696 814492 ] |
||||||||||||||||||||||||||||||
|
17.99 ms (8.67%) |
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 651647 811696 785880 660383 780269 650598 487363 541832 599976 585826 662603 695199 716550 692314 555065 604109 724264 796057 748521 770410 795396 454943 390447 591021 803524 389729 526894 630297 814492 470949 536666 696582 699397 548130 555116 717550 585392 761231 581850 446238 700685 606549 783486 640948 495070 620268 602928 467568 533928 533846 526167 639159 521681 474349 522307 424679 446709 535434 493391 497690 810822 439029 680428 509982 439405 543840 514660 578952 520343 542692 628315 785500 416663 513485 528281 619965 454931 636315 485267 587235 583508 630533 515545 482632 646450 394514 492525 500912 492701 803631 789746 424002 704205 527915 492364 536639 437548 624742 498297 505804 550579 565254 514248 634138 501382 495397 523357 446002 578631 628126 653302 511313 524676 536691 668461 672383 608939 422044 523354 604865 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ridding dildo anal"
]
|
||||||||||||||||||||||||||||||
|
2.41 ms (1.16%) |
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 389729 390447 394514 416663 422044 424002 424679 437548 439029 439405 446002 446238 446709 454931 454943 467568 470949 474349 482632 485267 487363 492364 492525 492701 493391 495070 495397 497690 498297 500912 501382 505804 509982 511313 513485 514248 514660 515545 520343 521681 522307 523354 523357 524676 526167 526894 527915 528281 533846 533928 535434 536639 536666 536691 541832 542692 543840 548130 550579 555065 555116 565254 578631 578952 581850 583508 585392 585826 587235 591021 599976 602928 604109 604865 606549 608939 619965 620268 624742 628126 628315 630297 630533 634138 636315 639159 640948 646450 650598 651647 653302 660383 662603 668461 672383 680428 692314 695199 696582 699397 700685 704205 716550 717550 724264 748521 761231 770410 780269 783486 785500 785880 789746 795396 796057 803524 803631 810822 811696 814492 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"наездниц поз дилд анал"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.