Query Metrics
7
Database Queries
7
Different statements
437.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.38 ms (48.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"поз adorable 69"
]
|
||||||||||||||||||||||||||||||
|
201.29 ms (45.97%) |
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 2291 86510 357513 357806 383950 384063 384181 386624 388638 389933 399930 405860 413145 415380 416304 417937 419668 422349 423884 424492 426150 428071 429065 430286 439469 439909 440803 441215 442871 443581 444199 445035 445926 446456 446762 447482 447496 448697 451008 453153 455386 457729 461556 462022 462944 463265 463496 465374 465942 466351 466602 466879 467386 470184 470756 472557 473979 479327 479487 479509 479878 481731 482404 485980 488602 489178 495831 497811 499018 500176 501003 501696 504321 505364 505518 506327 509498 509635 512287 512411 517566 519137 521881 521936 525234 528182 547987 552271 552995 553090 555158 557245 558213 563148 563193 563235 563415 563436 572634 574598 574839 575063 590303 594023 594195 596347 604149 719118 733468 738329 746376 780372 788970 793805 798101 807933 811949 817088 817724 ] |
||||||||||||||||||||||||||||||
|
14.26 ms (3.26%) |
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 428071 509498 547987 552995 558213 413145 430286 445035 2291 512411 497811 499018 386624 384063 86510 817724 817088 572634 553090 719118 604149 793805 811949 788970 798101 746376 738329 733468 780372 807933 357513 388638 389933 383950 357806 405860 417937 419668 429065 441215 443581 439469 440803 482404 446456 446762 448697 453153 463496 479487 445926 451008 466602 466879 470184 501003 501696 505518 509635 463265 563235 557245 563436 574839 575063 563148 574598 552271 555158 563193 563415 590303 596347 594023 594195 384181 447482 447496 462022 462944 466351 399930 439909 465374 470756 479327 479509 479878 481731 423884 426150 457729 473979 415380 416304 442871 444199 461556 465942 472557 422349 424492 455386 467386 500176 517566 519137 521881 525234 528182 485980 504321 505364 512287 521936 495831 506327 513753 488602 489178 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (0.64%) |
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 2291 86510 357513 357806 383950 384063 384181 386624 388638 389933 399930 405860 413145 415380 416304 417937 419668 422349 423884 424492 426150 428071 429065 430286 439469 439909 440803 441215 442871 443581 444199 445035 445926 446456 446762 447482 447496 448697 451008 453153 455386 457729 461556 462022 462944 463265 463496 465374 465942 466351 466602 466879 467386 470184 470756 472557 473979 479327 479487 479509 479878 481731 482404 485980 488602 489178 495831 497811 499018 500176 501003 501696 504321 505364 505518 506327 509498 509635 512287 512411 517566 519137 521881 521936 525234 528182 547987 552271 552995 553090 555158 557245 558213 563148 563193 563235 563415 563436 572634 574598 574839 575063 590303 594023 594195 596347 604149 719118 733468 738329 746376 780372 788970 793805 798101 807933 811949 817088 817724 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"69 adorable"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"поз adorable 69"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.35%) |
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.