Query Metrics
7
Database Queries
7
Different statements
221.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
192.59 ms (86.90%) |
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 75852 388690 399358 404234 416236 416583 419403 423987 425694 430975 433694 438638 445017 445741 446331 447855 453202 457145 457751 460706 462470 463262 468006 471859 472448 472914 473094 473735 475698 478491 480429 483079 486696 499334 499668 504379 505172 509543 512329 514798 514847 516686 517819 518935 519105 524440 529286 533799 533931 534237 536092 536542 549977 550314 552704 555807 555814 556312 558156 558581 560184 560314 562128 562333 565372 571269 573238 575411 575734 580318 580329 582393 586463 586631 587928 589756 590244 591067 592358 594868 595582 597005 597113 597120 597242 597947 598020 599923 601253 601266 601710 601755 602203 602296 603978 604451 604541 604595 604597 604849 605105 605224 622583 630292 636053 646846 649576 649830 657865 660405 672140 676073 680198 689005 702634 714464 722825 743159 747004 ] |
||||||||||||||||||||||||||||||
|
18.16 ms (8.19%) |
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 550314 556312 660405 676073 657865 646846 604849 597005 597242 586463 597113 598020 601253 622583 630292 636053 589756 590244 595582 597120 607257 743159 601710 601755 602296 404234 478491 423987 399358 425694 416236 504379 505172 519105 462470 514847 586631 460706 473735 480429 516686 445017 416583 453202 445741 472448 472914 473094 517819 518935 536542 499334 533931 536092 558156 555807 582393 571269 649830 680198 649576 672140 689005 702634 549977 555814 560184 560314 565372 575411 591067 592358 599923 602203 604451 587928 597947 604595 594868 601266 603978 605224 747004 604597 722825 75852 430975 438638 446331 463262 388690 471859 468006 475698 512329 486696 499668 483079 509543 419403 604541 605105 433694 447855 457145 457751 524440 533799 514798 529286 534237 558581 580329 552704 562128 562333 714464 573238 575734 580318 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.31%) |
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 75852 388690 399358 404234 416236 416583 419403 423987 425694 430975 433694 438638 445017 445741 446331 447855 453202 457145 457751 460706 462470 463262 468006 471859 472448 472914 473094 473735 475698 478491 480429 483079 486696 499334 499668 504379 505172 509543 512329 514798 514847 516686 517819 518935 519105 524440 529286 533799 533931 534237 536092 536542 549977 550314 552704 555807 555814 556312 558156 558581 560184 560314 562128 562333 565372 571269 573238 575411 575734 580318 580329 582393 586463 586631 587928 589756 590244 591067 592358 594868 595582 597005 597113 597120 597242 597947 598020 599923 601253 601266 601710 601755 602203 602296 603978 604451 604541 604595 604597 604849 605105 605224 622583 630292 636053 646846 649576 649830 657865 660405 672140 676073 680198 689005 702634 714464 722825 743159 747004 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black худая"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black skinny girl"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black худая"
]
|
||||||||||||||||||||||||||||||
|
1.75 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.