Query Metrics
7
Database Queries
7
Different statements
164.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.99 ms (80.23%) |
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 383597 397530 400196 402001 404292 406206 411201 411790 412363 412433 416364 417631 418833 419882 420223 421219 421318 424443 425027 425028 426409 428451 428477 429985 430630 431117 434282 434723 442726 442946 442994 443704 443737 443796 443819 444238 446718 447890 448793 448798 448842 449880 449886 449914 450318 452080 454267 454658 456615 462483 463098 464935 465307 468754 469017 470254 471443 471848 473037 474745 476123 477200 478877 480429 481581 482367 483152 484377 484914 485749 491478 492336 497337 497889 513189 514587 518931 519226 519903 522883 524895 525349 527428 530833 530884 535021 541373 541602 550960 562106 563079 565539 577366 581300 582617 586805 587098 591369 596534 598225 606738 607293 607637 610247 611241 612053 614023 622714 640022 671746 675537 688041 688663 690124 788225 807363 807386 815017 815735 820871 ] |
||||||||||||||||||||||||||||||
|
21.76 ms (13.23%) |
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 411790 421219 412363 418833 421318 429985 442994 820871 815735 448793 449880 452080 454658 456615 465307 471443 473037 449886 449914 535021 497889 497337 514587 525349 527428 464935 478877 482367 541373 562106 565539 541602 563079 581300 688663 688041 582617 586805 614023 640022 591369 596534 606738 607637 807363 807386 622714 400196 448798 463098 424443 468754 447890 471848 481581 419882 425028 454267 491478 492336 518931 484914 485749 484377 522883 430630 788225 383597 402001 404292 406206 412433 417631 442726 425027 428477 434282 428451 431117 815017 448842 450318 476123 483152 530833 513189 519226 524895 530884 519903 477200 577366 675537 690124 671746 550960 607293 598225 610247 611241 612053 587098 416364 443704 443737 443796 443819 420223 434723 469017 426409 446718 470254 474745 397530 442946 444238 462483 480429 411201 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (2.02%) |
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 383597 397530 400196 402001 404292 406206 411201 411790 412363 412433 416364 417631 418833 419882 420223 421219 421318 424443 425027 425028 426409 428451 428477 429985 430630 431117 434282 434723 442726 442946 442994 443704 443737 443796 443819 444238 446718 447890 448793 448798 448842 449880 449886 449914 450318 452080 454267 454658 456615 462483 463098 464935 465307 468754 469017 470254 471443 471848 473037 474745 476123 477200 478877 480429 481581 482367 483152 484377 484914 485749 491478 492336 497337 497889 513189 514587 518931 519226 519903 522883 524895 525349 527428 530833 530884 535021 541373 541602 550960 562106 563079 565539 577366 581300 582617 586805 587098 591369 596534 598225 606738 607293 607637 610247 611241 612053 614023 622714 640022 671746 675537 688041 688663 690124 788225 807363 807386 815017 815735 820871 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy pussy facesitting"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая pussy фейсситтинг"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая pussy фейсситтинг"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.99%) |
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.