Query Metrics
7
Database Queries
7
Different statements
166.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.73 ms (88.63%) |
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 21576 114153 117388 117755 150336 232978 233443 254478 309276 386460 386915 387428 388772 390908 391317 392048 392623 395278 396186 400957 402032 404276 410308 410741 411033 417021 419028 426021 426134 443549 453484 463819 463943 465993 472773 473228 474021 484279 500446 501647 505021 509082 509426 524514 534127 535648 536236 543661 544421 549785 552075 556331 556335 561658 561685 561716 561883 565957 576078 595396 596625 597040 597798 598451 598470 598788 598789 598812 600104 605791 615059 621733 637690 652247 652596 652927 653533 662803 663232 663250 676931 677345 677365 677450 678981 709825 717713 719214 721307 721322 721390 722585 722623 727327 727824 732401 742234 742458 743232 744631 745075 745363 747147 747402 750316 753809 753885 756196 759357 759364 760961 770880 775895 786274 788414 795858 805939 806194 806330 ] |
||||||||||||||||||||||||||||||
|
10.55 ms (6.33%) |
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 534127 552075 747147 390908 473228 524514 509426 426134 400957 536236 653533 402032 597798 395278 721322 742234 598788 388772 150336 595396 721390 788414 753885 756196 392623 719214 727824 743232 745075 727327 576078 472773 750316 117755 114153 535648 805939 605791 410741 598451 600104 795858 747402 426021 417021 386460 463943 744631 387428 543661 556335 722585 565957 637690 652927 615059 770880 742458 760961 709825 117388 453484 505021 233443 465993 663250 309276 663232 721307 717713 396186 411033 662803 677450 598789 786274 806330 753809 759364 254478 391317 621733 678981 598812 232978 392048 404276 484279 443549 561685 463819 410308 501647 677365 806194 732401 759357 561658 561883 561716 419028 474021 21576 556331 722623 598470 597040 549785 775895 745363 500446 596625 7308 386915 509082 544421 652247 676931 652596 677345 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.53%) |
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 21576 114153 117388 117755 150336 232978 233443 254478 309276 386460 386915 387428 388772 390908 391317 392048 392623 395278 396186 400957 402032 404276 410308 410741 411033 417021 419028 426021 426134 443549 453484 463819 463943 465993 472773 473228 474021 484279 500446 501647 505021 509082 509426 524514 534127 535648 536236 543661 544421 549785 552075 556331 556335 561658 561685 561716 561883 565957 576078 595396 596625 597040 597798 598451 598470 598788 598789 598812 600104 605791 615059 621733 637690 652247 652596 652927 653533 662803 663232 663250 676931 677345 677365 677450 678981 709825 717713 719214 721307 721322 721390 722585 722623 727327 727824 732401 742234 742458 743232 744631 745075 745363 747147 747402 750316 753809 753885 756196 759357 759364 760961 770880 775895 786274 788414 795858 805939 806194 806330 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian blonde teen"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск беловолосая teen"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск беловолосая teen"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.79%) |
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.