Query Metrics
7
Database Queries
7
Different statements
194.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.30 ms (84.44%) |
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 74135 381966 401810 412180 415965 416508 416525 416634 416675 416703 419834 428174 434523 439010 439033 441042 441081 447151 461610 469615 473413 483730 484809 486776 497471 497696 499931 500313 511866 515490 524675 529296 531255 532727 532778 533379 533519 534149 534229 534561 545305 548857 563992 564520 567127 568251 568501 573461 574178 574376 583385 584374 586759 592259 592396 595396 599937 601338 614730 625780 628115 632283 632887 634100 634109 639809 641950 642044 642149 647905 647914 647993 656173 656907 658819 662049 662072 666535 666550 666850 666855 666878 666902 666968 668154 668305 669565 674968 676075 679801 695872 695875 696593 720101 722382 729691 735130 735133 735260 738515 740357 745087 745107 752603 752712 752753 758599 761155 761621 770261 782808 782836 792761 796763 799759 804939 806924 820162 825027 ] |
||||||||||||||||||||||||||||||
|
17.86 ms (9.18%) |
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 567127 592259 625780 531255 647993 632283 641950 533519 666550 647914 412180 416703 416634 533379 676075 595396 599937 441042 439033 500313 820162 825027 497471 529296 512930 574178 584374 564520 656173 666855 668154 720101 656907 548857 568251 642149 586759 782808 799759 806924 740357 758599 796763 804939 735130 761155 735133 738515 745087 745107 735260 74135 401810 511866 524675 662049 695875 592396 628115 782836 792761 752603 752712 761621 381966 473413 639809 532727 666968 679801 428174 484809 447151 486776 497696 532778 563992 583385 601338 614730 439010 534561 674968 419834 568501 695872 722382 658819 662072 669565 696593 668305 632887 634100 634109 729691 752753 770261 534229 545305 666535 666878 647905 666902 666850 573461 642044 534149 434523 416525 415965 483730 499931 515490 574376 416508 441081 416675 461610 469615 ] |
||||||||||||||||||||||||||||||
|
3.60 ms (1.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fisting anal teen"
]
|
||||||||||||||||||||||||||||||
|
3.43 ms (1.76%) |
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 74135 381966 401810 412180 415965 416508 416525 416634 416675 416703 419834 428174 434523 439010 439033 441042 441081 447151 461610 469615 473413 483730 484809 486776 497471 497696 499931 500313 511866 515490 524675 529296 531255 532727 532778 533379 533519 534149 534229 534561 545305 548857 563992 564520 567127 568251 568501 573461 574178 574376 583385 584374 586759 592259 592396 595396 599937 601338 614730 625780 628115 632283 632887 634100 634109 639809 641950 642044 642149 647905 647914 647993 656173 656907 658819 662049 662072 666535 666550 666850 666855 666878 666902 666968 668154 668305 669565 674968 676075 679801 695872 695875 696593 720101 722382 729691 735130 735133 735260 738515 740357 745087 745107 752603 752712 752753 758599 761155 761621 770261 782808 782836 792761 796763 799759 804939 806924 820162 825027 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг анал teen"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"фистинг анал teen"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.89%) |
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.