Query Metrics
7
Database Queries
7
Different statements
157.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.34 ms (83.95%) |
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 33781 53379 101932 181397 278764 382110 382352 383801 384580 389616 390086 392928 394804 396759 403467 404311 408024 408085 410844 411821 415580 428889 430703 435487 443645 449605 450313 457994 469301 469343 471894 483387 486416 491228 502252 506501 509837 520674 532281 533568 536291 552047 569536 587161 590761 599997 604905 604911 605055 619482 623945 623948 625755 632267 640321 643095 643264 644265 644270 648255 658793 660749 667339 673101 673142 684126 688577 691561 692477 714886 715114 717069 718925 720833 721807 722678 723460 724875 726038 727087 737449 741308 748254 752799 755411 755652 756260 761217 774357 774534 775956 787754 788812 788937 790025 790335 798943 801376 801835 802250 802616 804681 805269 805700 805717 806167 807906 810824 812944 813789 816040 816517 816938 817680 818615 818678 819086 823515 826671 827887 ] |
||||||||||||||||||||||||||||||
|
14.38 ms (9.12%) |
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 435487 644270 383801 449605 660749 590761 604911 623945 755411 33781 483387 787754 755652 509837 801376 720833 643095 410844 813789 816040 714886 802616 807906 804681 806167 644265 775956 408085 101932 382110 826671 816517 818678 823515 817680 819086 827887 532281 502252 648255 722678 718925 667339 721807 723460 625755 643264 790025 805269 790335 812944 761217 802250 805700 805717 756260 726038 737449 717069 392928 818615 520674 688577 389616 692477 278764 658793 605055 724875 394804 53379 673142 619482 457994 382352 430703 741308 569536 727087 752799 774534 450313 491228 411821 404311 469301 691561 684126 810824 774357 390086 536291 715114 816938 640321 748254 801835 469343 181397 471894 552047 604905 623948 632267 587161 788937 788812 408024 443645 415580 533568 384580 403467 506501 673101 599997 798943 396759 428889 486416 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (2.10%) |
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 33781 53379 101932 181397 278764 382110 382352 383801 384580 389616 390086 392928 394804 396759 403467 404311 408024 408085 410844 411821 415580 428889 430703 435487 443645 449605 450313 457994 469301 469343 471894 483387 486416 491228 502252 506501 509837 520674 532281 533568 536291 552047 569536 587161 590761 599997 604905 604911 605055 619482 623945 623948 625755 632267 640321 643095 643264 644265 644270 648255 658793 660749 667339 673101 673142 684126 688577 691561 692477 714886 715114 717069 718925 720833 721807 722678 723460 724875 726038 727087 737449 741308 748254 752799 755411 755652 756260 761217 774357 774534 775956 787754 788812 788937 790025 790335 798943 801376 801835 802250 802616 804681 805269 805700 805717 806167 807906 810824 812944 813789 816040 816517 816938 817680 818615 818678 819086 823515 826671 827887 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"busty milf blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"busty milf минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"busty milf минет оральн секс"
]
|
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.