Query Metrics
7
Database Queries
7
Different statements
154.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.52 ms (84.08%) |
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 3793 250215 412532 416111 422147 424092 426628 440706 447064 447554 457872 459094 462721 465481 466053 466402 467992 468091 468962 468965 469371 470513 470823 471065 472573 472578 472586 474269 474955 478157 479522 480819 481069 482718 483414 484843 487628 490018 493191 495769 501735 502674 502678 502717 502823 504686 505435 506397 511610 512244 512271 514121 515822 515906 521963 521980 523837 523954 523983 528565 538217 538405 548621 549830 551664 554475 562322 564486 567585 573015 580002 586199 596172 608784 614675 618633 626618 635781 636742 641071 653272 656081 657713 658360 659305 665872 679353 689132 700908 705422 706410 707081 707518 721497 727064 731065 736174 737438 740157 742157 742356 754017 755045 758365 766892 781358 784400 791501 791929 792128 797258 800790 803230 810898 811819 818028 824596 825800 828449 ] |
||||||||||||||||||||||||||||||
|
14.64 ms (9.50%) |
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 659305 653272 707518 548621 573015 626618 586199 614675 641071 784400 792128 791501 737438 758365 736174 766892 740157 742356 754017 727064 636742 440706 480819 422147 447064 466053 470513 416111 457872 468962 470823 250215 465481 467992 469371 412532 426628 462721 466402 478157 501735 511610 514121 502674 502823 506397 521963 538217 538405 502717 504686 512271 483414 502678 505435 515822 521980 523983 482718 474269 472573 472578 472586 564486 567585 554475 424092 479522 468091 471065 447554 459094 474955 523954 484843 487628 493191 490018 495769 512244 515906 523837 528565 549830 468965 803230 3793 818028 824596 825195 825800 828449 481069 551664 562322 679353 689132 656081 657713 665872 700908 706410 707081 658360 705422 721497 580002 608784 618633 635781 596172 791929 797258 800790 810898 811819 742157 781358 731065 755045 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.99%) |
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 3793 250215 412532 416111 422147 424092 426628 440706 447064 447554 457872 459094 462721 465481 466053 466402 467992 468091 468962 468965 469371 470513 470823 471065 472573 472578 472586 474269 474955 478157 479522 480819 481069 482718 483414 484843 487628 490018 493191 495769 501735 502674 502678 502717 502823 504686 505435 506397 511610 512244 512271 514121 515822 515906 521963 521980 523837 523954 523983 528565 538217 538405 548621 549830 551664 554475 562322 564486 567585 573015 580002 586199 596172 608784 614675 618633 626618 635781 636742 641071 653272 656081 657713 658360 659305 665872 679353 689132 700908 705422 706410 707081 707518 721497 727064 731065 736174 737438 740157 742157 742356 754017 755045 758365 766892 781358 784400 791501 791929 792128 797258 800790 803230 810898 811819 818028 824596 825800 828449 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ванной русское"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ван русск"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.