Query Metrics
7
Database Queries
7
Different statements
268.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
240.73 ms (89.82%) |
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 28242 213604 237362 382766 382770 393855 394160 395668 403136 407382 414807 420324 422287 425207 429905 449270 457521 466422 469114 470359 471460 476086 478641 479877 484011 504229 514237 515961 524688 526236 526508 528142 531075 533241 536419 536441 539940 540132 543296 545030 545213 551723 552844 553115 555859 555954 557201 563301 567833 573382 574469 576087 580928 581170 583547 584463 584768 585175 585571 586047 588221 588618 589487 591596 592319 594557 597665 602485 607432 609614 619167 636057 639702 642176 646052 659262 672701 675581 676657 678180 679297 687259 687355 688403 695158 697219 700379 709181 710541 716669 717202 724396 726920 727778 728702 737644 740037 742727 743806 747239 747673 748035 750940 756804 759908 759921 761012 761018 765715 769474 791567 794071 796158 803532 808084 808480 810931 811435 811528 825117 ] |
||||||||||||||||||||||||||||||
|
13.36 ms (4.98%) |
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 607432 395668 407382 659262 687355 700379 716669 636057 808084 726920 737644 724396 728702 740037 765715 697219 717202 584463 555859 592319 414807 449270 479877 528142 466422 457521 514237 574469 646052 675581 676657 553115 588618 796158 803532 759921 748035 747239 710541 403136 382766 515961 540132 545030 555954 672701 597665 585571 642176 588221 808480 811435 794071 750940 743806 811528 28242 237362 476086 429905 382770 393855 394160 478641 469114 580928 584768 576087 581170 543296 552844 557201 687259 688403 695158 545213 551723 585175 602485 810931 761018 759908 761012 769474 531075 484011 526236 470359 504229 524688 213604 422287 420324 425207 825117 471460 526508 533241 536441 536419 539940 563301 567833 583547 678180 679297 573382 586047 589487 591596 594557 619167 639702 609614 791567 747673 727778 742727 756804 709181 ] |
||||||||||||||||||||||||||||||
|
6.09 ms (2.27%) |
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 28242 213604 237362 382766 382770 393855 394160 395668 403136 407382 414807 420324 422287 425207 429905 449270 457521 466422 469114 470359 471460 476086 478641 479877 484011 504229 514237 515961 524688 526236 526508 528142 531075 533241 536419 536441 539940 540132 543296 545030 545213 551723 552844 553115 555859 555954 557201 563301 567833 573382 574469 576087 580928 581170 583547 584463 584768 585175 585571 586047 588221 588618 589487 591596 592319 594557 597665 602485 607432 609614 619167 636057 639702 642176 646052 659262 672701 675581 676657 678180 679297 687259 687355 688403 695158 697219 700379 709181 710541 716669 717202 724396 726920 727778 728702 737644 740037 742727 743806 747239 747673 748035 750940 756804 759908 759921 761012 761018 765715 769474 791567 794071 796158 803532 808084 808480 810931 811435 811528 825117 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggystyle brunette"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"doggystyle черноволосая"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"doggystyle черноволосая"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.71%) |
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.