Query Metrics
7
Database Queries
7
Different statements
814.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
635.73 ms (78.02%) |
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 386719 414688 415833 472352 399023 512838 491143 549306 571643 559902 715453 552192 792057 399306 476060 619435 789213 699602 382957 382545 425590 424181 435520 457979 470794 440986 538191 575485 564461 561734 636270 388378 436642 820416 558619 569878 570354 542144 553722 558987 566867 569852 571893 575070 657066 677343 718561 721426 656466 663414 674216 554540 556362 571887 572436 573685 576307 598812 607203 613471 622210 623628 635236 596545 596653 606749 611754 611924 600063 624240 607285 804753 730642 730764 740331 754128 753814 755178 743877 612106 613155 714439 721793 386204 474072 390592 382734 812143 389728 500712 536096 501678 561725 564086 679372 680616 710970 608426 742035 806045 811814 728196 771740 745012 623209 785922 790966 418659 476266 820122 577614 548660 572508 570525 573286 558573 569913 570672 571585 574978 ] |
||||||||||||||||||||||||||||||
|
169.53 ms (20.81%) |
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 382545 382734 382957 386204 386719 388378 389728 390592 399023 399306 414688 415833 418659 424181 425590 435520 436642 440986 457979 470794 472352 474072 476060 476266 491143 500712 501678 512838 536096 538191 542144 548660 549306 552192 553722 554540 556362 558573 558619 558987 559902 561725 561734 564086 564461 566867 569852 569878 569913 570354 570525 570672 571585 571643 571887 571893 572436 572508 573286 573685 574978 575070 575485 576307 577614 596545 596653 598812 600063 606749 607203 607285 608426 611754 611924 612106 613155 613471 619435 622210 623209 623628 624240 635236 636270 656466 657066 663414 674216 677343 679372 680616 699602 710970 714439 715453 718561 721426 721793 728196 730642 730764 740331 742035 743877 745012 753814 754128 755178 771740 785922 789213 790966 792057 804753 806045 811814 812143 820122 820416 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (0.30%) |
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 382545 382734 382957 386204 386719 388378 389728 390592 399023 399306 414688 415833 418659 424181 425590 435520 436642 440986 457979 470794 472352 474072 476060 476266 491143 500712 501678 512838 536096 538191 542144 548660 549306 552192 553722 554540 556362 558573 558619 558987 559902 561725 561734 564086 564461 566867 569852 569878 569913 570354 570525 570672 571585 571643 571887 571893 572436 572508 573286 573685 574978 575070 575485 576307 577614 596545 596653 598812 600063 606749 607203 607285 608426 611754 611924 612106 613155 613471 619435 622210 623209 623628 624240 635236 636270 656466 657066 663414 674216 677343 679372 680616 699602 710970 714439 715453 718561 721426 721793 728196 730642 730764 740331 742035 743877 745012 753814 754128 755178 771740 785922 789213 790966 792057 804753 806045 811814 812143 820122 820416 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (0.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy маленькая"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy маленькая"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy small"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.18%) |
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.