Query Metrics
7
Database Queries
7
Different statements
848.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
613.61 ms (72.28%) |
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 397916 414125 415294 418122 418145 418423 422464 426802 428758 429009 429069 436132 436695 437156 437587 438372 438377 439725 440041 446437 446920 447287 447392 447936 448570 448696 448773 449222 451560 452909 454585 455861 458022 459198 462967 463409 465182 465534 466118 467684 467872 467882 467888 467904 470717 473963 475508 477114 483687 484673 486510 489676 490093 491171 492168 498294 500288 502338 502503 508512 508524 508541 510505 512381 513081 513655 514051 514434 518611 518782 519331 522363 522713 523493 523931 524587 524786 525011 533461 534035 536105 540794 542978 552270 555124 556882 557926 564716 568655 569386 571999 573175 579935 583615 587272 597997 598250 605774 611572 613268 620648 624120 624139 650624 653487 656935 664431 677917 686106 693269 700291 718785 751546 751615 779037 790930 801280 801610 813265 814443 ] |
||||||||||||||||||||||||||||||
|
208.76 ms (24.59%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
18.55 ms (2.19%) |
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 620648 611572 801280 813265 429009 465182 415294 451560 467904 467684 449222 459198 498294 513081 486510 489676 492168 502338 512381 514434 455861 426802 418423 470717 467888 552270 693269 677917 579935 801610 467872 467882 437587 397916 422464 429069 477114 458022 502503 462967 446920 536105 542978 656935 686106 790930 779037 751615 751546 447392 437156 436695 447936 491171 514051 483687 605774 428758 510505 569386 564716 573175 587272 598250 439725 466118 525011 624120 436132 452909 414125 440041 463409 557926 465534 523931 524587 540794 522363 583615 484673 555124 534035 571999 568655 653487 700291 664431 597997 454585 438372 438377 448570 418145 490093 513655 518782 448773 448696 473963 418122 508541 613268 500288 447287 475508 522713 533461 519331 446437 518611 523493 524786 814443 508524 508512 556882 650624 718785 624139 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (0.31%) |
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 397916 414125 415294 418122 418145 418423 422464 426802 428758 429009 429069 436132 436695 437156 437587 438372 438377 439725 440041 446437 446920 447287 447392 447936 448570 448696 448773 449222 451560 452909 454585 455861 458022 459198 462967 463409 465182 465534 466118 467684 467872 467882 467888 467904 470717 473963 475508 477114 483687 484673 486510 489676 490093 491171 492168 498294 500288 502338 502503 508512 508524 508541 510505 512381 513081 513655 514051 514434 518611 518782 519331 522363 522713 523493 523931 524587 524786 525011 533461 534035 536105 540794 542978 552270 555124 556882 557926 564716 568655 569386 571999 573175 579935 583615 587272 597997 598250 605774 611572 613268 620648 624120 624139 650624 653487 656935 664431 677917 686106 693269 700291 718785 751546 751615 779037 790930 801280 801610 813265 814443 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск огромные сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian huge tits"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.19%) |
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.