Query Metrics
7
Database Queries
7
Different statements
187.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.82 ms (85.67%) |
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 239112 323088 384810 388434 395862 397111 397530 399700 399739 399824 402008 407168 410090 410218 413889 416332 424364 425028 425784 431022 433212 433231 445248 446084 446105 446906 447835 448832 449362 451893 464378 467614 471494 472124 474120 475033 478084 481581 483392 486596 487435 492267 492605 493420 494266 497923 499498 501226 505023 505041 509879 511239 512263 512821 514700 514841 517865 520347 520639 521907 522883 523859 523863 524897 525704 525866 528571 531072 550681 554004 559029 559766 560113 560462 561816 565061 565163 565395 565539 567159 571629 574538 575722 576024 576043 576412 581821 584711 587901 590866 593343 593743 596990 598122 598386 603536 603663 609276 614739 622005 622229 644636 649150 652263 672584 716298 721738 721795 725409 726589 745939 746889 763313 770278 802109 810685 815982 818447 823242 827940 ] |
||||||||||||||||||||||||||||||
|
16.99 ms (9.05%) |
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 425784 492605 565539 567159 481581 593743 399824 560113 523859 413889 517865 475033 433231 514841 399700 483392 388434 565395 559029 448832 581821 523863 522883 802109 512263 576043 472124 501226 416332 565163 486596 745939 598386 449362 431022 487435 397530 402008 499498 445248 576412 598122 531072 474120 554004 574538 493420 451893 407168 410218 520639 424364 464378 524897 446084 525866 525704 492267 575722 587901 818447 239112 622005 590866 721738 395862 323088 471494 770278 763313 514700 384810 399739 593343 512821 827940 478084 447835 397111 721795 550681 746889 716298 810685 649150 815982 596990 410090 571629 576024 672584 521907 565061 511239 446906 528571 644636 614739 560462 505041 823242 584711 725409 497923 559766 505023 494266 425028 603663 726589 467614 433212 446105 561816 509879 609276 603536 520347 622229 652263 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.24%) |
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 239112 323088 384810 388434 395862 397111 397530 399700 399739 399824 402008 407168 410090 410218 413889 416332 424364 425028 425784 431022 433212 433231 445248 446084 446105 446906 447835 448832 449362 451893 464378 467614 471494 472124 474120 475033 478084 481581 483392 486596 487435 492267 492605 493420 494266 497923 499498 501226 505023 505041 509879 511239 512263 512821 514700 514841 517865 520347 520639 521907 522883 523859 523863 524897 525704 525866 528571 531072 550681 554004 559029 559766 560113 560462 561816 565061 565163 565395 565539 567159 571629 574538 575722 576024 576043 576412 581821 584711 587901 590866 593343 593743 596990 598122 598386 603536 603663 609276 614739 622005 622229 644636 649150 652263 672584 716298 721738 721795 725409 726589 745939 746889 763313 770278 802109 810685 815982 818447 823242 827940 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс втроем с красоткой"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро красивая"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.84%) |
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.