Query Metrics
7
Database Queries
7
Different statements
233.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.52 ms (88.61%) |
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 7170 95873 188621 322815 383000 387782 388219 389790 391920 400942 405848 410272 411384 415936 430543 437470 440944 443334 443387 443389 443771 444684 448632 448832 451451 452813 467592 468631 476671 477071 477878 479074 479126 484735 486243 486445 497886 507591 511254 511272 512509 512561 513964 516375 517847 522157 522882 522913 523868 530791 530837 531070 533382 534532 538824 541849 549799 556029 561136 563265 564542 566503 571136 597018 599851 599861 599958 599964 600359 601584 603238 613032 617428 620794 621656 629409 631178 632650 636299 639752 639759 641303 647939 650188 658784 662069 674129 674492 678514 678529 686615 690827 692804 697261 703097 703523 704248 707570 708441 717615 721113 724109 725598 726654 728215 728555 743066 772714 775477 788783 794832 803459 803656 807196 810828 814646 815467 816484 817080 819506 ] |
||||||||||||||||||||||||||||||
|
16.49 ms (7.08%) |
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 531070 484735 388219 430543 410272 415936 512509 522157 533382 516375 523868 511254 530791 517847 556029 566503 541849 650188 678514 704248 647939 678529 708441 561136 599861 601584 621656 599964 639752 639759 636299 617428 620794 631178 437470 448832 452813 387782 468631 448632 512561 507591 522913 486445 188621 7170 95873 389790 400942 814646 817080 815467 816484 486243 534532 538824 522882 479074 563265 658784 690827 721113 686615 697261 703097 707570 662069 674492 692804 703523 717615 571136 600359 613032 629409 597018 641303 788783 724109 743066 772714 803656 807196 728555 728215 632650 383000 549799 443771 443334 479126 443389 511272 530837 467592 564542 440944 405848 411384 819506 476671 477071 477878 513964 674129 599958 603238 599851 810828 794832 803459 725598 726654 451451 443387 391920 497886 775477 322815 444684 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.18%) |
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 7170 95873 188621 322815 383000 387782 388219 389790 391920 400942 405848 410272 411384 415936 430543 437470 440944 443334 443387 443389 443771 444684 448632 448832 451451 452813 467592 468631 476671 477071 477878 479074 479126 484735 486243 486445 497886 507591 511254 511272 512509 512561 513964 516375 517847 522157 522882 522913 523868 530791 530837 531070 533382 534532 538824 541849 549799 556029 561136 563265 564542 566503 571136 597018 599851 599861 599958 599964 600359 601584 603238 613032 617428 620794 621656 629409 631178 632650 636299 639752 639759 641303 647939 650188 658784 662069 674129 674492 678514 678529 686615 690827 692804 697261 703097 703523 704248 707570 708441 717615 721113 724109 725598 726654 728215 728555 743066 772714 775477 788783 794832 803459 803656 807196 810828 814646 815467 816484 817080 819506 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf mature double"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf mature double"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf mature double"
]
|
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.