Query Metrics
7
Database Queries
7
Different statements
183.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.75 ms (86.46%) |
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 122425 385389 389388 390832 390950 396013 399352 405224 406433 407054 407507 407646 408489 409646 411012 411555 412068 413104 414714 415189 415710 417662 418933 420032 420834 428583 443380 444635 447004 447357 447545 449254 450530 450656 453295 460960 462673 467273 469675 472212 474050 476812 486931 487514 489618 496549 498544 499834 501720 507168 510244 511263 516536 518328 518400 519841 520599 521318 530718 531471 533000 534318 541033 551320 551321 551388 551435 558617 559958 560848 563796 564621 565940 572010 572016 573776 575730 594500 596908 600276 601618 602725 603096 603583 606831 614726 615674 618883 622986 624722 628989 630616 634755 651883 653247 663381 663494 667675 667894 670270 672485 672528 672540 672547 672561 672564 676576 689325 689743 701449 701469 722820 727482 744621 749553 758980 767504 813228 814917 815751 ] |
||||||||||||||||||||||||||||||
|
14.78 ms (8.05%) |
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 385389 411012 472212 634755 411555 407054 428583 498544 530718 600276 447545 449254 749553 667675 409646 460960 518400 606831 531471 399352 558617 551321 563796 572016 575730 572010 653247 663381 594500 603096 603583 565940 407646 564621 667894 614726 601618 443380 413104 815751 476812 450656 521318 722820 390832 396013 450530 510244 573776 618883 813228 469675 415189 406433 516536 501720 511263 520599 489618 390950 418933 518328 507168 467273 672540 689325 651883 672528 672547 672561 551435 622986 602725 630616 758980 744621 814917 727482 447357 615674 407507 412068 560848 596908 417662 444635 453295 663494 499834 487514 496549 389388 405224 415710 447004 541033 519841 486931 551320 767504 420032 462673 474050 408489 701449 628989 551388 670270 533000 559958 122425 624722 676576 689743 672485 672564 701469 534318 414714 420834 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.49%) |
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 122425 385389 389388 390832 390950 396013 399352 405224 406433 407054 407507 407646 408489 409646 411012 411555 412068 413104 414714 415189 415710 417662 418933 420032 420834 428583 443380 444635 447004 447357 447545 449254 450530 450656 453295 460960 462673 467273 469675 472212 474050 476812 486931 487514 489618 496549 498544 499834 501720 507168 510244 511263 516536 518328 518400 519841 520599 521318 530718 531471 533000 534318 541033 551320 551321 551388 551435 558617 559958 560848 563796 564621 565940 572010 572016 573776 575730 594500 596908 600276 601618 602725 603096 603583 606831 614726 615674 618883 622986 624722 628989 630616 634755 651883 653247 663381 663494 667675 667894 670270 672485 672528 672540 672547 672561 672564 676576 689325 689743 701449 701469 722820 727482 744621 749553 758980 767504 813228 814917 815751 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage big cock"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"массаж большие cock"
]
|
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.