Query Metrics
7
Database Queries
7
Different statements
180.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.19 ms (83.05%) |
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 188117 386700 394535 395869 400847 401270 403891 416169 419664 421773 432872 440826 445492 445778 446920 448104 450098 450287 450312 451672 452757 453686 454925 456168 457569 457577 459338 460157 464308 465221 466092 468545 468837 471141 473060 473463 475296 476203 477242 478933 487011 492933 493470 498209 500635 503418 503565 505692 506800 509637 509923 510107 513138 515034 516437 522628 523034 523441 523864 525503 527476 527779 532721 532993 535423 537591 541220 544019 546838 552983 563827 564054 564367 566023 567663 577037 577394 579430 586520 586691 589349 590410 596193 600453 601928 603507 607454 607509 607552 607640 607661 607677 607696 607716 608033 612383 618611 618687 634416 641965 665781 671950 676535 695173 702453 716540 716765 723986 756405 760211 770897 780737 782008 809076 810226 810229 810249 812749 812911 813101 ] |
||||||||||||||||||||||||||||||
|
21.75 ms (12.02%) |
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 468545 468837 473060 509923 516437 523034 532993 537591 460157 493470 546838 579430 541220 567663 564367 695173 577037 634416 589349 603507 612383 601928 607509 607677 590410 809076 760211 782008 810249 812749 723986 607696 608033 780737 810226 419664 432872 445492 465221 466092 394535 446920 450098 492933 188117 416169 445778 477242 510107 716540 586691 607640 618687 770897 813101 600453 607552 607716 535423 473463 403891 452757 459338 464308 515034 525503 509637 563827 544019 665781 607661 596193 618611 812911 702453 395869 401270 421773 476203 513138 498209 454925 453686 506800 456168 386700 400847 440826 450287 478933 448104 450312 451672 457577 471141 457569 475296 487011 503565 505692 522628 523441 532721 500635 503418 523864 527476 527779 566023 552983 577394 671950 716765 676535 564054 607454 586520 810229 756405 641965 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.25%) |
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 188117 386700 394535 395869 400847 401270 403891 416169 419664 421773 432872 440826 445492 445778 446920 448104 450098 450287 450312 451672 452757 453686 454925 456168 457569 457577 459338 460157 464308 465221 466092 468545 468837 471141 473060 473463 475296 476203 477242 478933 487011 492933 493470 498209 500635 503418 503565 505692 506800 509637 509923 510107 513138 515034 516437 522628 523034 523441 523864 525503 527476 527779 532721 532993 535423 537591 541220 544019 546838 552983 563827 564054 564367 566023 567663 577037 577394 579430 586520 586691 589349 590410 596193 600453 601928 603507 607454 607509 607552 607640 607661 607677 607696 607716 608033 612383 618611 618687 634416 641965 665781 671950 676535 695173 702453 716540 716765 723986 756405 760211 770897 780737 782008 809076 810226 810229 810249 812749 812911 813101 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"curvy big ass"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"curvy большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"curvy большая большие жоп"
]
|
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.