Query Metrics
7
Database Queries
7
Different statements
123.67 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.63 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.04 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"фут-фетиш"
]
|
||||||||||||||||||||||||||||||
| 3 | 18.35 ms |
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 509288 511463 509620 518881 527430 403789 814376 472917 500469 515378 538267 520704 528749 584358 691221 691200 586485 607146 598845 600054 621494 589716 623229 467727 465641 515331 519973 490553 494043 487693 497869 527716 514959 519954 536215 568762 563861 565332 648583 582334 626647 607227 605617 641949 433434 509290 513564 524608 510853 495608 525727 531106 536689 571954 581996 553129 562176 576629 628424 591079 478978 528067 520426 532839 618128 622686 565105 546370 571213 687522 600297 520310 517048 559279 572885 573920 575436 553031 560114 595155 642766 511601 506434 570765 602923 521306 560188 591135 624428 ] |
||||||||||||||||||||||||||||||
| 4 | 2.40 ms |
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 403789 433434 465641 467727 472917 478978 487693 490553 494043 495608 497869 500469 506434 509288 509290 509620 510853 511463 511601 513564 514959 515331 515378 517048 518881 519954 519973 520310 520426 520704 521306 524608 525727 527430 527716 528067 528749 531106 532839 536215 536689 538267 546370 553031 553129 559279 560114 560188 562176 563861 565105 565332 568762 570765 571213 571954 572885 573920 575436 576629 581996 582334 584358 586485 589716 591079 591135 595155 598845 600054 600297 602923 605617 607146 607227 618128 621494 622686 623229 624428 626647 628424 641949 642766 648583 687522 691200 691221 814376 ] |
||||||||||||||||||||||||||||||
| 5 | 96.14 ms |
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 403789 433434 465641 467727 472917 478978 487693 490553 494043 495608 497869 500469 506434 509288 509290 509620 510853 511463 511601 513564 514959 515331 515378 517048 518881 519954 519973 520310 520426 520704 521306 524608 525727 527430 527716 528067 528749 531106 532839 536215 536689 538267 546370 553031 553129 559279 560114 560188 562176 563861 565105 565332 568762 570765 571213 571954 572885 573920 575436 576629 581996 582334 584358 586485 589716 591079 591135 595155 598845 600054 600297 602923 605617 607146 607227 618128 621494 622686 623229 624428 626647 628424 641949 642766 648583 687522 691200 691221 814376 ] |
||||||||||||||||||||||||||||||
| 6 | 1.64 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"футфетиш"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.47 ms |
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.