Query Metrics
7
Database Queries
7
Different statements
213.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.52 ms (87.34%) |
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 102235 394184 396665 404353 408695 435728 463083 471170 473773 491299 492125 499856 504948 507795 507806 507948 508422 508452 512533 514817 515168 516704 516757 518181 521750 523151 524187 526857 527220 532180 532364 532782 534266 534273 534275 534298 534300 534313 534825 539058 546393 550821 554442 564767 578500 579138 584663 586675 587567 589211 591011 597432 597852 598851 600812 604066 604463 605335 610666 615318 624365 630227 630558 633132 636108 640691 641931 642504 645010 645230 645240 647945 648046 650847 651489 669275 672777 673964 676145 681027 684088 702075 704729 720401 724619 725408 726827 727744 732323 732357 732765 734085 737153 738766 738785 760812 770490 774771 789494 789702 790034 790063 790852 792616 792655 792801 793704 801087 803557 807187 808505 808804 809289 810978 814817 814883 814914 815789 816260 816553 ] |
||||||||||||||||||||||||||||||
|
16.14 ms (7.56%) |
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 499856 516757 523151 534266 504948 516704 527220 532180 532782 534275 534300 514817 521750 546393 579138 564767 647945 681027 702075 645230 645240 669275 648046 672777 704729 720401 589211 600812 615318 633132 604066 641931 586675 587567 624365 591011 630558 790063 792801 793704 724619 726827 732765 770490 801087 808505 725408 734085 738766 727744 737153 732323 732357 610666 630227 807187 810978 394184 404353 408695 539058 507795 492125 435728 578500 512533 102235 814914 816553 645010 814817 814883 815789 816260 473773 463083 518181 534313 534825 507806 534273 534298 508422 532364 507948 508452 515168 471170 550821 584663 554442 676145 650847 673964 684088 651489 598851 604463 636108 597432 597852 605335 642504 790034 792655 809289 789494 790852 803557 760812 789702 792616 738785 640691 774771 808804 396665 491299 524187 526857 ] |
||||||||||||||||||||||||||||||
|
4.16 ms (1.95%) |
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 102235 394184 396665 404353 408695 435728 463083 471170 473773 491299 492125 499856 504948 507795 507806 507948 508422 508452 512533 514817 515168 516704 516757 518181 521750 523151 524187 526857 527220 532180 532364 532782 534266 534273 534275 534298 534300 534313 534825 539058 546393 550821 554442 564767 578500 579138 584663 586675 587567 589211 591011 597432 597852 598851 600812 604066 604463 605335 610666 615318 624365 630227 630558 633132 636108 640691 641931 642504 645010 645230 645240 647945 648046 650847 651489 669275 672777 673964 676145 681027 684088 702075 704729 720401 724619 725408 726827 727744 732323 732357 732765 734085 737153 738766 738785 760812 770490 774771 789494 789702 790034 790063 790852 792616 792655 792801 793704 801087 803557 807187 808505 808804 809289 810978 814817 814883 814914 815789 816260 816553 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy ebony"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy чернокожая"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy чернокожая"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.70%) |
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.