Query Metrics
7
Database Queries
7
Different statements
597.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
367.50 ms (61.54%) |
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 129246 392165 398436 400563 401935 410328 488848 506571 507114 516061 520472 528880 530638 541565 541996 542443 545798 547941 549951 554706 554709 560342 563408 566737 574656 579523 589083 589374 592741 599763 601948 606212 611541 621004 625750 632224 633052 633563 633664 634289 638947 644857 647126 650692 661347 662480 667820 669896 680612 680954 681234 690441 691231 692436 695980 695997 701604 705736 706642 707812 709855 710042 715121 724318 727036 728188 733983 734261 735235 736510 744034 744568 747535 751377 752145 754885 755737 758155 760932 761069 768042 768669 773584 778925 780884 784050 785562 786948 788141 789650 791579 799010 800663 802816 803156 812230 812238 814166 817403 817519 817788 819438 819452 820475 820504 820564 821037 821140 821143 823157 825538 828036 828046 828047 828065 828098 828243 828376 828402 ] |
||||||||||||||||||||||||||||||
|
207.95 ms (34.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
13.66 ms (2.29%) |
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 633563 706642 709855 599763 760932 828402 410328 516061 520472 541996 554706 681234 691231 705736 661347 647126 667820 680954 690441 692436 632224 621004 784050 747535 788141 791579 744034 754885 768669 761069 785562 803156 644857 554709 634289 786948 727036 606212 507114 129246 392165 400563 817403 817519 820504 820564 821143 819438 819452 821037 822935 823157 814166 817788 821140 828065 828243 825538 542443 541565 566737 547941 611541 592741 789650 734261 812230 812238 733983 736510 744568 735235 751377 780884 799010 800663 398436 488848 528880 773584 680612 710042 669896 633664 625750 768042 633052 545798 589083 701604 707812 828046 828098 828376 828047 549951 758155 724318 828036 579523 563408 752145 715121 662480 401935 506571 560342 650692 638947 601948 820475 530638 574656 695980 695997 589374 778925 802816 755737 728188 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (0.48%) |
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 129246 392165 398436 400563 401935 410328 488848 506571 507114 516061 520472 528880 530638 541565 541996 542443 545798 547941 549951 554706 554709 560342 563408 566737 574656 579523 589083 589374 592741 599763 601948 606212 611541 621004 625750 632224 633052 633563 633664 634289 638947 644857 647126 650692 661347 662480 667820 669896 680612 680954 681234 690441 691231 692436 695980 695997 701604 705736 706642 707812 709855 710042 715121 724318 727036 728188 733983 734261 735235 736510 744034 744568 747535 751377 752145 754885 755737 758155 760932 761069 768042 768669 773584 778925 780884 784050 785562 786948 788141 789650 791579 799010 800663 802816 803156 812230 812238 814166 817403 817519 817788 819438 819452 820475 820504 820564 821037 821140 821143 823157 825538 828036 828046 828047 828065 828098 828243 828376 828402 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public ass"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц жоп"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.26%) |
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.