Query Metrics
7
Database Queries
7
Different statements
156.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.81 ms (83.62%) |
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 78786 420235 420310 425223 440977 444615 446551 446553 447908 448319 453925 454416 455800 457049 457057 457112 457668 457723 457726 457730 457767 457776 457778 457787 458528 459160 459470 461274 462297 466530 467174 467999 468928 468942 469229 469230 469234 469248 469249 469254 472038 472131 473206 473649 483757 484250 485483 486197 486842 488214 488221 488233 488716 489796 494661 494866 494975 495499 498111 499565 499720 501235 503449 503907 504415 505430 506520 507216 508588 509492 510570 510734 519101 519366 519811 519815 522416 523137 534347 534354 534946 543016 544454 544610 545352 548403 552716 553178 553774 558113 559110 559584 559609 560901 567591 571479 572851 572862 578101 579661 579896 596131 596463 600875 601826 613320 614417 615426 619785 634448 651678 670208 671886 680210 683300 699044 721908 744924 748464 795913 ] |
||||||||||||||||||||||||||||||
|
15.83 ms (10.12%) |
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 469254 558113 495499 559609 454416 634448 469234 494866 457057 613320 523137 503907 457049 472038 501235 467174 680210 670208 457787 579896 519366 651678 744924 459470 671886 683300 473206 559110 467999 544610 486197 457726 721908 489796 484250 448319 440977 505430 78786 615426 488221 455800 560901 462297 457112 614417 508588 469248 483757 425223 486842 488214 519815 795913 472131 494975 572862 596131 453925 468928 619785 420310 469230 469249 468942 469229 458528 499565 488716 447908 457730 457776 506520 548403 578101 601826 498111 543016 559584 600875 572851 494661 420235 446551 534946 545352 552716 553774 579661 457778 509492 553178 504415 699044 519101 485483 503449 567591 571479 510734 473649 596463 466530 444615 748464 507216 522416 499720 459160 534347 457723 534354 488233 457767 446553 457668 510570 519811 544454 461274 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.85%) |
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 78786 420235 420310 425223 440977 444615 446551 446553 447908 448319 453925 454416 455800 457049 457057 457112 457668 457723 457726 457730 457767 457776 457778 457787 458528 459160 459470 461274 462297 466530 467174 467999 468928 468942 469229 469230 469234 469248 469249 469254 472038 472131 473206 473649 483757 484250 485483 486197 486842 488214 488221 488233 488716 489796 494661 494866 494975 495499 498111 499565 499720 501235 503449 503907 504415 505430 506520 507216 508588 509492 510570 510734 519101 519366 519811 519815 522416 523137 534347 534354 534946 543016 544454 544610 545352 548403 552716 553178 553774 558113 559110 559584 559609 560901 567591 571479 572851 572862 578101 579661 579896 596131 596463 600875 601826 613320 614417 615426 619785 634448 651678 670208 671886 680210 683300 699044 721908 744924 748464 795913 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скрыт на улиц секс"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hidden public sex"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"скрыт на улиц секс"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.01%) |
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.