Query Metrics
7
Database Queries
7
Different statements
181.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.83 ms (84.01%) |
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 16882 88591 89346 151179 154133 154240 154257 154972 248347 290366 340567 352189 357499 388962 389144 391915 402619 410694 413341 413673 415300 415879 416531 416631 416695 428729 431439 436639 439071 446949 448604 448854 452810 453221 454172 460765 464951 468943 470473 471132 473450 476163 477761 483738 486772 498318 511857 518187 521540 529713 529714 530368 530679 531839 532530 535438 540945 545439 547480 547489 554100 561036 561346 564289 580069 589185 590370 597190 597534 602251 625227 628104 628105 628106 634071 648869 657527 658774 658816 658850 660382 660385 660411 660419 661455 662026 668660 669035 669057 669071 670372 671008 671018 671045 672939 683297 686106 686130 713142 722382 739139 745092 745111 752592 752630 752632 752660 752669 752753 752767 761430 770261 770324 770386 792092 792726 799693 803135 806938 ] |
||||||||||||||||||||||||||||||
|
18.21 ms (10.01%) |
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 722382 752753 770261 739139 16882 413673 431439 671008 580069 589185 628105 806938 628106 248347 352189 389144 597534 446949 452810 436639 415300 473450 535438 464951 357499 448604 416531 151179 89346 154257 531839 154133 154972 88591 410694 416695 483738 416631 792092 561346 340567 402619 290366 413341 439071 453221 454172 471132 518187 532530 476163 564310 547489 547480 561036 668660 669071 672939 686130 648869 660385 660419 670372 713142 660382 660411 669035 669057 671018 671045 683297 686106 545439 634071 597190 625227 799693 752632 752660 752767 602251 468943 470473 498318 154240 529713 529714 530368 540945 658816 662026 564289 590370 628104 745092 792726 745111 752669 752630 770386 415879 460765 477761 448854 511857 391915 554100 803135 761430 752592 770324 428729 388962 486772 521540 530679 657527 658850 658774 661455 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (1.89%) |
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 16882 88591 89346 151179 154133 154240 154257 154972 248347 290366 340567 352189 357499 388962 389144 391915 402619 410694 413341 413673 415300 415879 416531 416631 416695 428729 431439 436639 439071 446949 448604 448854 452810 453221 454172 460765 464951 468943 470473 471132 473450 476163 477761 483738 486772 498318 511857 518187 521540 529713 529714 530368 530679 531839 532530 535438 540945 545439 547480 547489 554100 561036 561346 564289 580069 589185 590370 597190 597534 602251 625227 628104 628105 628106 634071 648869 657527 658774 658816 658850 660382 660385 660411 660419 661455 662026 668660 669035 669057 669071 670372 671008 671018 671045 672939 683297 686106 686130 713142 722382 739139 745092 745111 752592 752630 752632 752660 752669 752753 752767 761430 770261 770324 770386 792092 792726 799693 803135 806938 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal masturbation dildo"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал мастурбац дилд"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал мастурбац дилд"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.91%) |
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.