Query Metrics
7
Database Queries
7
Different statements
164.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.18 ms (79.99%) |
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 359011 382304 391562 396330 397879 398719 405528 415004 422134 430374 434358 441106 448002 452638 453332 455793 460208 460218 467047 467872 467893 467908 468142 475647 475649 486126 490232 490831 492732 493606 494231 502064 505724 506516 510395 512029 512057 519316 526894 527409 529213 531181 533598 534734 542280 545451 545460 555035 555133 559377 568189 573760 575336 576925 584267 591476 596929 601535 602259 604537 618855 629962 630793 631937 632107 633237 636320 637036 642032 642315 643027 643100 648820 676549 697628 710360 717550 719902 720249 721750 724153 725598 728145 730015 731142 732627 734038 747098 751637 755958 756614 759847 765349 770501 775817 775853 783278 786604 789710 796071 796306 799695 800656 800672 801206 807589 808614 810675 810892 811296 812564 813568 813706 815317 815448 815969 815975 816007 818371 826880 ] |
||||||||||||||||||||||||||||||
|
18.96 ms (11.56%) |
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 467908 453332 533598 502064 475647 573760 717550 422134 486126 492732 452638 601535 398719 796306 815969 531181 505724 542280 545451 786604 807589 512029 770501 415004 460208 527409 529213 648820 642032 636320 637036 815975 575336 710360 618855 591476 808614 775853 810892 783278 732627 724153 751637 810675 455793 596929 643027 405528 475649 396330 430374 755958 519316 559377 568189 629962 632107 728145 747098 725598 775817 441106 493606 359011 812564 576925 799695 730015 765349 756614 630793 697628 721750 545460 494231 382304 397879 448002 490232 434358 796071 719902 526894 813568 816007 490831 467047 468142 506516 512057 720249 555133 631937 642315 643100 602259 811296 734038 604537 467872 467893 460218 391562 510395 731142 826880 759847 815317 813706 815448 818371 534734 555035 584267 676549 633237 789710 800672 800656 801206 ] |
||||||||||||||||||||||||||||||
|
4.71 ms (2.87%) |
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 359011 382304 391562 396330 397879 398719 405528 415004 422134 430374 434358 441106 448002 452638 453332 455793 460208 460218 467047 467872 467893 467908 468142 475647 475649 486126 490232 490831 492732 493606 494231 502064 505724 506516 510395 512029 512057 519316 526894 527409 529213 531181 533598 534734 542280 545451 545460 555035 555133 559377 568189 573760 575336 576925 584267 591476 596929 601535 602259 604537 618855 629962 630793 631937 632107 633237 636320 637036 642032 642315 643027 643100 648820 676549 697628 710360 717550 719902 720249 721750 724153 725598 728145 730015 731142 732627 734038 747098 751637 755958 756614 759847 765349 770501 775817 775853 783278 786604 789710 796071 796306 799695 800656 800672 801206 807589 808614 810675 810892 811296 812564 813568 813706 815317 815448 815969 815975 816007 818371 826880 ] |
||||||||||||||||||||||||||||||
|
3.57 ms (2.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"оргазм у зрелой женщине"
]
|
||||||||||||||||||||||||||||||
|
2.54 ms (1.55%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"оргазм зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.92%) |
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.