Query Metrics
7
Database Queries
7
Different statements
261.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
237.44 ms (90.69%) |
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 383593 418801 466354 466845 513122 515487 530134 530167 531391 533582 533887 534015 534712 535721 536260 536823 540055 540124 542878 547442 548003 555438 570893 576154 579472 581180 585617 587552 590226 593052 593108 594035 595409 597517 598307 603130 605080 610242 613339 620112 625841 627640 628514 630519 632282 637988 638463 660356 663552 680609 682229 682714 695594 696149 696157 697330 699089 706361 710457 715963 719962 719988 722291 723446 723950 730547 733659 734013 738249 739397 740640 744709 745660 745665 746009 746651 749071 749572 751395 751436 752319 752893 753098 753994 754980 755052 755886 756512 759059 760570 768848 769538 770081 771756 773172 773204 778537 784468 785401 786186 787145 787533 787633 789762 790421 791038 804412 804826 816106 816123 818577 819148 819807 820161 824408 824502 825029 825732 826902 827335 ] |
||||||||||||||||||||||||||||||
|
13.77 ms (5.26%) |
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 706361 719962 680609 576154 579472 594035 595409 605080 628514 630519 587552 593052 597517 598307 610242 620112 627640 593108 603130 784468 751395 625841 466354 535721 744709 824408 816106 819807 825732 826902 827335 819148 825029 816123 818577 820161 533582 534712 531391 536823 540124 540055 542878 570893 581180 547442 548003 660356 663552 710457 719988 682229 699089 715963 722291 695594 697330 723446 555438 613339 638463 585617 590226 637988 804412 789762 733659 740640 755052 755886 759059 760570 787633 752319 752893 723950 734013 745665 749071 754980 768848 773204 730547 738249 746651 751436 756512 769538 770081 753098 771756 632282 791038 787533 383593 824502 466845 513122 790421 778537 739397 746009 753994 787145 749572 745660 773172 785401 786186 804826 418801 515487 696157 696149 682714 530134 534015 536260 530167 533887 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (1.20%) |
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 383593 418801 466354 466845 513122 515487 530134 530167 531391 533582 533887 534015 534712 535721 536260 536823 540055 540124 542878 547442 548003 555438 570893 576154 579472 581180 585617 587552 590226 593052 593108 594035 595409 597517 598307 603130 605080 610242 613339 620112 625841 627640 628514 630519 632282 637988 638463 660356 663552 680609 682229 682714 695594 696149 696157 697330 699089 706361 710457 715963 719962 719988 722291 723446 723950 730547 733659 734013 738249 739397 740640 744709 745660 745665 746009 746651 749071 749572 751395 751436 752319 752893 753098 753994 754980 755052 755886 756512 759059 760570 768848 769538 770081 771756 773172 773204 778537 784468 785401 786186 787145 787533 787633 789762 790421 791038 804412 804826 816106 816123 818577 819148 819807 820161 824408 824502 825029 825732 826902 827335 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur erotic"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск эротик"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.59%) |
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.