Query Metrics
7
Database Queries
7
Different statements
373.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
341.80 ms (91.60%) |
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 381783 386813 402088 407136 407687 412875 415286 418272 419625 426944 427971 431523 436776 438363 438364 439617 442441 443017 443107 443801 444041 444399 445324 445475 448255 450172 454052 454649 454917 454992 457045 459248 463663 466342 467552 468186 470443 473627 474077 474821 475183 476714 484836 486532 486862 488541 488809 489197 489388 494496 495138 495682 498405 498457 498511 500175 501713 503418 506436 507797 509726 510079 511085 516713 517831 518975 519845 521152 531197 531935 532351 532915 533807 539147 539662 542275 546419 550689 551559 556502 558804 559884 561338 561345 565077 565720 575441 579470 580398 580642 581450 592921 598667 607454 620057 620093 622063 630639 633818 635577 639253 647305 660582 661286 684704 686207 697006 699611 726475 747195 747228 747231 747236 756212 756585 762400 766616 785421 792555 813250 ] |
||||||||||||||||||||||||||||||
|
20.49 ms (5.49%) |
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 792555 486532 476714 474077 532915 558804 542275 620093 747195 747228 762400 756212 438364 454052 466342 445475 489197 488809 445324 474821 495138 498405 531197 509726 519845 533807 539662 531935 546419 559884 660582 699611 661286 607454 785421 747231 756585 407687 419625 426944 444041 468186 444399 454917 511085 418272 486862 427971 498457 503418 518975 473627 489388 579470 686207 551559 580642 592921 635577 622063 813250 448255 402088 412875 439617 443801 470443 498511 488541 386813 415286 561345 581450 726475 620057 475183 521152 647305 436776 442441 501713 484836 495682 454649 457045 454992 516713 556502 639253 747236 438363 463663 506436 517831 494496 381783 407136 459248 467552 500175 539147 575441 580398 550689 565077 697006 630639 633818 443017 510079 450172 507797 532351 565720 561338 684704 598667 766616 431523 443107 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (0.75%) |
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 381783 386813 402088 407136 407687 412875 415286 418272 419625 426944 427971 431523 436776 438363 438364 439617 442441 443017 443107 443801 444041 444399 445324 445475 448255 450172 454052 454649 454917 454992 457045 459248 463663 466342 467552 468186 470443 473627 474077 474821 475183 476714 484836 486532 486862 488541 488809 489197 489388 494496 495138 495682 498405 498457 498511 500175 501713 503418 506436 507797 509726 510079 511085 516713 517831 518975 519845 521152 531197 531935 532351 532915 533807 539147 539662 542275 546419 550689 551559 556502 558804 559884 561338 561345 565077 565720 575441 579470 580398 580642 581450 592921 598667 607454 620057 620093 622063 630639 633818 635577 639253 647305 660582 661286 684704 686207 697006 699611 726475 747195 747228 747231 747236 756212 756585 762400 766616 785421 792555 813250 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sucking big boobs"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (0.55%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sucking большие boobs"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sucking большие boobs"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.45%) |
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.