Query Metrics
7
Database Queries
7
Different statements
145.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.33 ms (83.27%) |
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 396672 397879 409334 411344 411883 411896 411902 413488 418215 418623 429251 431566 440833 451865 458370 460011 463384 476713 476773 482958 483592 488594 491465 496252 497878 498340 507503 511209 511552 516259 522973 526372 527928 528555 533363 533913 534625 536571 537467 541575 544843 565767 573760 576260 577253 580188 581478 584425 584987 592696 595057 596621 606831 609083 609926 613688 628398 629965 639108 641517 642032 645012 648820 652612 663217 666538 673662 693815 696944 709259 710265 711597 712546 718746 718793 722029 722545 727052 731540 733851 737759 744427 744855 749675 756708 757235 759015 760583 761570 766770 768790 771883 778593 779194 783941 785338 787002 787408 788855 789888 789954 791457 796351 798918 800189 800504 805701 806473 808450 809313 809702 815031 815816 819036 819594 820070 820652 820715 825563 826763 ] |
||||||||||||||||||||||||||||||
|
16.01 ms (10.98%) |
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 573760 522973 796351 737759 527928 476773 565767 411902 491465 496252 673662 696944 693815 722029 592696 606831 779194 778593 791457 805701 809702 744427 760583 759015 800189 541575 609926 411883 820652 819594 826763 820715 458370 482958 476713 533913 483592 576260 709259 710265 712546 722545 652612 596621 788855 789888 789954 798918 787408 800504 808450 731540 744855 766770 768790 727052 761570 733851 629965 787002 806473 809313 411896 409334 577253 718746 711597 641517 757235 785338 749675 756708 771883 613688 718793 783941 528555 516259 534625 526372 645012 666538 628398 411344 440833 463384 507503 648820 544843 642032 584987 581478 663217 639108 595057 418215 609083 533363 396672 397879 413488 429251 431566 418623 819036 815031 815816 820070 825563 451865 460011 497878 511209 511552 536571 498340 537467 488594 584425 580188 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.64%) |
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 396672 397879 409334 411344 411883 411896 411902 413488 418215 418623 429251 431566 440833 451865 458370 460011 463384 476713 476773 482958 483592 488594 491465 496252 497878 498340 507503 511209 511552 516259 522973 526372 527928 528555 533363 533913 534625 536571 537467 541575 544843 565767 573760 576260 577253 580188 581478 584425 584987 592696 595057 596621 606831 609083 609926 613688 628398 629965 639108 641517 642032 645012 648820 652612 663217 666538 673662 693815 696944 709259 710265 711597 712546 718746 718793 722029 722545 727052 731540 733851 737759 744427 744855 749675 756708 757235 759015 760583 761570 766770 768790 771883 778593 779194 783941 785338 787002 787408 788855 789888 789954 791457 796351 798918 800189 800504 805701 806473 808450 809313 809702 815031 815816 819036 819594 820070 820652 820715 825563 826763 ] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сквирт оргазм сперм"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сквирт оргазм сперм"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"squirt and sperm"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.91%) |
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.