Query Metrics
7
Database Queries
7
Different statements
138.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
112.71 ms (81.19%) |
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 390642 395676 398968 400196 415630 419120 426423 438219 439682 442194 442726 442997 444733 445661 449872 450318 451464 454052 454228 454317 454558 454563 454567 456615 458757 461821 463098 464978 466160 467066 467628 468717 469227 469560 470461 470498 470918 472154 475289 478107 481670 481878 482304 484065 486539 490025 493204 493411 493980 494314 495905 496057 496851 503859 504093 505671 505976 508257 510750 512896 513123 513992 517010 517687 518588 518594 518918 518948 523796 524073 525204 526052 527040 535459 536664 541602 541607 541625 541887 543181 549968 550864 554319 554784 554790 555402 555420 557534 558261 559350 559692 561588 565984 568101 575329 576700 583913 584336 584352 584481 584627 592477 593294 599273 611345 612904 612964 615721 615741 619140 635998 640716 641377 678486 725314 808621 813244 814892 815490 815600 ] |
||||||||||||||||||||||||||||||
|
16.84 ms (12.13%) |
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 503859 513123 523796 508257 513992 493980 541887 555402 555420 558261 584481 584627 549968 554319 561588 568101 678486 575329 599273 592477 615721 619140 635998 808621 438219 449872 454228 470918 454052 467628 398968 470498 444733 461821 496851 525204 496057 493411 505671 475289 468717 395676 415630 442194 815490 543181 445661 472154 494314 495905 517687 469560 484065 550864 559350 584352 612964 612904 615741 640716 641377 442997 467066 419120 439682 454567 478107 454558 481670 454563 464978 470461 510750 504093 536664 512896 517010 524073 527040 526052 469227 583913 584336 426423 815600 814892 456615 481878 490025 454317 518594 518948 535459 518588 518918 557534 541625 559692 565984 541602 541607 576700 593294 813244 611345 400196 463098 451464 390642 466160 505976 486539 725314 458757 554784 554790 493204 442726 450318 482304 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.59%) |
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 390642 395676 398968 400196 415630 419120 426423 438219 439682 442194 442726 442997 444733 445661 449872 450318 451464 454052 454228 454317 454558 454563 454567 456615 458757 461821 463098 464978 466160 467066 467628 468717 469227 469560 470461 470498 470918 472154 475289 478107 481670 481878 482304 484065 486539 490025 493204 493411 493980 494314 495905 496057 496851 503859 504093 505671 505976 508257 510750 512896 513123 513992 517010 517687 518588 518594 518918 518948 523796 524073 525204 526052 527040 535459 536664 541602 541607 541625 541887 543181 549968 550864 554319 554784 554790 555402 555420 557534 558261 559350 559692 561588 565984 568101 575329 576700 583913 584336 584352 584481 584627 592477 593294 599273 611345 612904 612964 615721 615741 619140 635998 640716 641377 678486 725314 808621 813244 814892 815490 815600 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shower hairy milf"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"shower волосатая milf"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"shower волосатая milf"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.09%) |
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.