Query Metrics
7
Database Queries
7
Different statements
161.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.58 ms (81.62%) |
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 418440 419197 420353 420696 420737 421580 421660 422382 422805 425469 426944 431523 433350 435716 438291 438363 439617 440613 441536 443017 443107 444041 445324 445756 448396 452619 453986 454992 457282 457378 457965 458462 462331 463663 466376 467837 470610 471299 474447 477395 478126 478213 481533 485551 486872 486903 487872 489127 489388 493942 494496 495469 495484 496404 497580 500175 501033 502639 503702 504482 507309 509493 509726 510771 510881 511077 511085 513695 517831 518975 519845 520059 520272 521686 522089 522584 525985 527878 531935 534594 538223 539240 543420 543901 549814 551559 561338 562765 565376 569312 578795 579470 580398 591960 593279 595115 596069 600193 612068 620057 620093 628447 629189 633461 643315 645003 646752 648685 655456 677892 679863 690961 691724 715859 741821 760295 777322 792189 797883 813250 ] |
||||||||||||||||||||||||||||||
|
18.90 ms (11.72%) |
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 496404 509493 478126 645003 691724 457378 501033 420737 440613 578795 502639 690961 792189 445324 509726 531935 534594 543901 438291 439617 470610 777322 741821 715859 591960 629189 520272 562765 431523 760295 580398 628447 438363 458462 452619 425469 595115 495484 421660 513695 518975 579470 646752 478213 551559 420696 422382 489127 527878 448396 474447 467837 485551 457282 486872 489388 565376 444041 487872 420353 457965 481533 643315 445756 510771 521686 511077 549814 648685 569312 507309 419197 520059 422805 797883 538223 441536 495469 493942 677892 679863 543420 612068 504482 433350 539240 486903 655456 813250 522584 510881 418440 454992 443017 443107 497580 593279 519845 477395 426944 561338 620057 463663 503702 517831 494496 435716 453986 620093 633461 511085 525985 522089 596069 466376 462331 421580 471299 500175 600193 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.47%) |
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 418440 419197 420353 420696 420737 421580 421660 422382 422805 425469 426944 431523 433350 435716 438291 438363 439617 440613 441536 443017 443107 444041 445324 445756 448396 452619 453986 454992 457282 457378 457965 458462 462331 463663 466376 467837 470610 471299 474447 477395 478126 478213 481533 485551 486872 486903 487872 489127 489388 493942 494496 495469 495484 496404 497580 500175 501033 502639 503702 504482 507309 509493 509726 510771 510881 511077 511085 513695 517831 518975 519845 520059 520272 521686 522089 522584 525985 527878 531935 534594 538223 539240 543420 543901 549814 551559 561338 562765 565376 569312 578795 579470 580398 591960 593279 595115 596069 600193 612068 620057 620093 628447 629189 633461 643315 645003 646752 648685 655456 677892 679863 690961 691724 715859 741821 760295 777322 792189 797883 813250 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов sucking минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
2.18 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov sucking blowjob"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов sucking минет оральн секс"
]
|
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.