Query Metrics
7
Database Queries
7
Different statements
185.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.50 ms (85.10%) |
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 134210 387033 387850 388856 422273 423321 423351 423651 427958 432589 436588 442957 444651 447551 447919 452334 452808 453426 458923 459539 460126 461927 463036 463584 464089 465109 465891 467049 467118 468188 468685 475489 477198 480363 480393 480889 485856 486363 501960 503429 505867 507245 507451 511506 512339 514373 514408 517673 518104 519017 521624 524370 524956 525462 525521 525785 525814 525817 526436 526917 528009 529769 535611 539170 541465 545729 548304 551820 555574 558624 558897 559986 561754 562203 567116 569357 576128 576995 577980 582362 584200 584942 591747 592645 601738 604225 605727 605774 605864 607363 610777 615429 617730 618293 627442 638870 640427 652633 699520 727668 741805 745622 746510 755141 755921 761474 765743 772700 790338 800311 823452 ] |
||||||||||||||||||||||||||||||
|
17.05 ms (9.21%) |
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 464089 480889 507451 562203 699520 652633 505867 423651 800311 755141 823452 452808 627442 745622 617730 465891 525814 387850 467049 535611 601738 461927 529769 610777 134210 444651 442957 576995 558624 567116 582362 638870 755921 761474 772700 485856 525785 452334 480363 790338 741805 591747 765743 436588 465109 511506 555574 468188 524956 453426 526436 539170 561754 605727 727668 427958 447919 432589 459539 468685 604225 387033 423321 423351 463584 475489 584200 584942 640427 477198 463036 525817 528009 577980 618293 503429 558897 559986 422273 467118 447551 486363 545729 746510 518104 514373 460126 507245 501960 541465 576128 514408 519017 525521 551820 388856 592645 480393 525462 524370 517673 526917 605864 458923 548304 605774 569357 521624 512339 615429 607363 ] |
||||||||||||||||||||||||||||||
|
3.07 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 134210 387033 387850 388856 422273 423321 423351 423651 427958 432589 436588 442957 444651 447551 447919 452334 452808 453426 458923 459539 460126 461927 463036 463584 464089 465109 465891 467049 467118 468188 468685 475489 477198 480363 480393 480889 485856 486363 501960 503429 505867 507245 507451 511506 512339 514373 514408 517673 518104 519017 521624 524370 524956 525462 525521 525785 525814 525817 526436 526917 528009 529769 535611 539170 541465 545729 548304 551820 555574 558624 558897 559986 561754 562203 567116 569357 576128 576995 577980 582362 584200 584942 591747 592645 601738 604225 605727 605774 605864 607363 610777 615429 617730 618293 627442 638870 640427 652633 699520 727668 741805 745622 746510 755141 755921 761474 765743 772700 790338 800311 823452 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass in jeans"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп jeans"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп jeans"
]
|
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.