Query Metrics
7
Database Queries
7
Different statements
221.04 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.83 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.76 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"оргазм худая"
]
|
||||||||||||||||||||||||||||||
| 3 | 17.40 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 576329 555881 578847 580282 618921 597504 641552 440683 462231 475206 502772 494499 486368 511204 514609 519762 499791 598524 492525 416170 427248 644996 821851 449323 447914 451257 463867 508903 531239 537671 537920 537889 538881 479661 541776 560198 564387 565246 566346 666548 666553 680138 649214 569454 587306 598786 604811 629398 604092 611469 642315 586465 600214 601641 734038 635234 702622 467893 396352 420182 434364 444194 447440 413833 435027 512285 514399 513568 516889 493194 338225 816024 813794 813895 498331 560546 569891 570565 552378 671138 682884 700267 652552 708716 698748 567258 570636 572424 622454 620488 634969 644600 589770 597448 774926 782867 786563 792931 783283 783873 793619 796215 804794 734188 766364 782904 786200 793101 794524 810766 811894 738925 766049 724782 773178 730073 730638 751319 755081 768948 ] |
||||||||||||||||||||||||||||||
| 4 | 15.27 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 338225 396352 413833 416170 420182 427248 434364 435027 440683 444194 447440 447914 449323 451257 462231 463867 467893 475206 479661 486368 492525 493194 494499 498331 499791 502772 508903 511204 512285 513568 514399 514609 516889 519762 531239 537671 537889 537920 538881 541776 552378 555881 560198 560546 564387 565246 566346 567258 569454 569891 570565 570636 572424 576329 578847 580282 586465 587306 589770 597448 597504 598524 598786 600214 601641 604092 604811 611469 618921 620488 622454 629398 634969 635234 641552 642315 644600 644996 649214 652552 666548 666553 671138 680138 682884 698748 700267 702622 708716 724782 730073 730638 734038 734188 738925 751319 755081 766049 766364 768948 773178 774926 782867 782904 783283 783873 786200 786563 792931 793101 793619 794524 796215 804794 810766 811894 813794 813895 821851 ] |
||||||||||||||||||||||||||||||
| 5 | 181.43 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 338225 396352 413833 416170 420182 427248 434364 435027 440683 444194 447440 447914 449323 451257 462231 463867 467893 475206 479661 486368 492525 493194 494499 498331 499791 502772 508903 511204 512285 513568 514399 514609 516889 519762 531239 537671 537889 537920 538881 541776 552378 555881 560198 560546 564387 565246 566346 567258 569454 569891 570565 570636 572424 576329 578847 580282 586465 587306 589770 597448 597504 598524 598786 600214 601641 604092 604811 611469 618921 620488 622454 629398 634969 635234 641552 642315 644600 644996 649214 652552 666548 666553 671138 680138 682884 698748 700267 702622 708716 724782 730073 730638 734038 734188 738925 751319 755081 766049 766364 768948 773178 774926 782867 782904 783283 783873 786200 786563 792931 793101 793619 794524 796215 804794 810766 811894 813794 813895 821851 ] |
||||||||||||||||||||||||||||||
| 6 | 1.87 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"оргазм худая"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.48 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.