Query Metrics
7
Database Queries
7
Different statements
183.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.07 ms (81.83%) |
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 7308 79677 117755 323044 386460 386862 387428 388769 388772 390195 390938 391163 391875 391881 392599 395910 400715 400987 404178 404276 410251 417304 418430 423333 423750 426666 443549 445026 459740 462347 464527 469908 470102 472094 475143 475574 476535 476596 478127 481849 485394 485437 488955 503002 504167 505252 505648 509975 515542 521942 523876 527347 543655 548604 549785 551180 558307 561649 576078 585524 597798 598812 609835 621733 652596 653246 654317 655539 663250 672884 678981 682883 689212 697727 700969 709825 719214 722071 722833 723599 723687 725321 731889 736856 741201 742458 743818 745063 745075 745076 746148 747147 747805 750004 753809 754185 754539 754696 759586 760426 760961 761471 762003 773514 776191 776369 778697 779881 783637 784095 785941 786664 787156 788473 788824 791819 794001 805939 808351 813576 ] |
||||||||||||||||||||||||||||||
|
17.03 ms (9.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 79677 523876 400715 745063 551180 475143 423333 700969 549785 400987 543655 404276 750004 504167 417304 443549 784095 745075 388769 723687 808351 760426 418430 754185 386460 776369 746148 445026 488955 515542 745076 731889 410251 323044 723599 778697 794001 527347 521942 391881 747147 773514 576078 426666 779881 805939 761471 725321 743818 561649 505252 663250 722833 558307 762003 459740 672884 395910 462347 485394 653246 390195 787156 609835 387428 813576 652596 682883 697727 476596 481849 391875 476535 585524 472094 753809 621733 485437 404178 386862 423750 742458 785941 788473 654317 475574 478127 390938 469908 470102 719214 678981 392599 760961 722071 783637 548604 791819 689212 736856 759586 7308 117755 503002 655539 598812 509975 597798 741201 786664 754539 747805 754696 709825 776191 464527 391163 788824 505648 388772 ] |
||||||||||||||||||||||||||||||
|
8.50 ms (4.63%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.31%) |
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 7308 79677 117755 323044 386460 386862 387428 388769 388772 390195 390938 391163 391875 391881 392599 395910 400715 400987 404178 404276 410251 417304 418430 423333 423750 426666 443549 445026 459740 462347 464527 469908 470102 472094 475143 475574 476535 476596 478127 481849 485394 485437 488955 503002 504167 505252 505648 509975 515542 521942 523876 527347 543655 548604 549785 551180 558307 561649 576078 585524 597798 598812 609835 621733 652596 653246 654317 655539 663250 672884 678981 682883 689212 697727 700969 709825 719214 722071 722833 723599 723687 725321 731889 736856 741201 742458 743818 745063 745075 745076 746148 747147 747805 750004 753809 754185 754539 754696 759586 760426 760961 761471 762003 773514 776191 776369 778697 779881 783637 784095 785941 786664 787156 788473 788824 791819 794001 805939 808351 813576 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob russian blonde"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс русск беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.82%) |
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.