Query Metrics
7
Database Queries
7
Different statements
148.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.21 ms (84.29%) |
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 397244 418540 419143 419832 420882 421594 422032 424932 434874 436639 438763 439439 439465 440761 441040 441041 441050 442548 445192 446641 449273 449687 451081 455258 458096 458612 461617 461655 467751 472285 473103 475482 476739 481494 484134 485187 485556 486278 488085 488088 489050 489128 491585 494123 494487 494489 496135 504112 510175 515590 517780 519479 520477 522044 525365 528024 532483 541676 541714 548017 555508 555521 557423 558654 559828 563368 563562 564076 564858 565298 566098 566331 568373 571789 572309 572901 575355 578574 587687 589079 592025 592059 592067 593840 595954 596035 596954 597250 602608 607050 608441 612771 614501 615665 625893 629151 631572 636732 649114 654295 688376 730722 730862 731472 731971 747655 755331 756345 756609 762646 770404 773890 777322 786720 789799 793448 803112 806877 809720 812876 ] |
||||||||||||||||||||||||||||||
|
14.88 ms (10.02%) |
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 572901 629151 595954 631572 596954 612771 592059 615665 418540 438763 496135 510175 472285 566331 608441 777322 812876 522044 439439 439465 424932 440761 422032 441041 442548 458612 488088 491585 475482 494123 504112 486278 557423 541714 564076 565298 575355 564858 566098 571789 649114 568373 578574 589079 593840 636732 607050 596035 597250 625893 731472 773890 730862 731971 770404 397244 458096 476739 419832 449687 485187 525365 541676 484134 494489 520477 419143 747655 755331 517780 420882 421594 434874 441040 461655 489128 449273 485556 451081 519479 528024 532483 489050 558654 555521 555508 654295 688376 548017 559828 563368 563562 572309 592067 592025 602608 587687 614501 786720 793448 789799 803112 806877 730722 756609 762646 756345 809720 473103 446641 461617 467751 436639 441050 445192 455258 481494 515590 488085 494487 ] |
||||||||||||||||||||||||||||||
|
2.22 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 397244 418540 419143 419832 420882 421594 422032 424932 434874 436639 438763 439439 439465 440761 441040 441041 441050 442548 445192 446641 449273 449687 451081 455258 458096 458612 461617 461655 467751 472285 473103 475482 476739 481494 484134 485187 485556 486278 488085 488088 489050 489128 491585 494123 494487 494489 496135 504112 510175 515590 517780 519479 520477 522044 525365 528024 532483 541676 541714 548017 555508 555521 557423 558654 559828 563368 563562 564076 564858 565298 566098 566331 568373 571789 572309 572901 575355 578574 587687 589079 592025 592059 592067 593840 595954 596035 596954 597250 602608 607050 608441 612771 614501 615665 625893 629151 631572 636732 649114 654295 688376 730722 730862 731472 731971 747655 755331 756345 756609 762646 770404 773890 777322 786720 789799 793448 803112 806877 809720 812876 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"petite amateur"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"petite любительск"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.32 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"petite любительск"
]
|
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.