Query Metrics
7
Database Queries
7
Different statements
161.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.10 ms (84.15%) |
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 16851 401052 409795 415834 417835 418883 421840 421861 421875 422141 422152 424124 434335 437960 438018 438316 439685 439712 439763 439813 440265 440601 440693 440954 442629 447094 449190 454801 455333 455343 455798 455993 457194 458348 459457 459513 460562 463191 464628 465344 465381 467569 469494 470559 474146 476707 478991 481406 484440 485666 486854 486859 487228 490517 490996 494421 494938 495686 502868 503476 504450 509609 510930 516483 516780 517885 518941 521168 523902 525713 527955 534020 534023 539561 543708 553653 553921 557267 557810 558814 564377 564555 565937 568317 570832 571711 577080 577087 578803 580159 580642 591452 593785 598899 599669 600411 601444 603201 603420 603716 605498 605529 607023 614696 615721 623211 624990 641059 652758 661970 668139 719112 720206 724637 732905 760169 761088 792599 799350 ] |
||||||||||||||||||||||||||||||
|
15.71 ms (9.71%) |
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 421861 424124 465344 523902 623211 605498 593785 495686 600411 440693 439813 553921 599106 591452 641059 401052 474146 534020 534023 580159 570832 799350 719112 469494 577080 577087 724637 486854 437960 490996 484440 543708 668139 614696 624990 732905 761088 603420 418883 527955 409795 455798 459513 440954 464628 447094 509609 485666 564377 564555 578803 652758 565937 571711 598899 421875 422141 481406 503476 517885 494421 516483 486859 504450 440601 440265 459457 490517 454801 457194 478991 521168 510930 518941 553653 558814 568317 661970 557810 599669 605529 603201 607023 601444 421840 422152 415834 439685 439763 455333 455343 465381 417835 434335 470559 516780 487228 502868 525713 438018 442629 458348 449190 467569 455993 476707 539561 494938 557267 580642 615721 603716 792599 760169 720206 463191 16851 438316 439712 460562 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.70%) |
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 16851 401052 409795 415834 417835 418883 421840 421861 421875 422141 422152 424124 434335 437960 438018 438316 439685 439712 439763 439813 440265 440601 440693 440954 442629 447094 449190 454801 455333 455343 455798 455993 457194 458348 459457 459513 460562 463191 464628 465344 465381 467569 469494 470559 474146 476707 478991 481406 484440 485666 486854 486859 487228 490517 490996 494421 494938 495686 502868 503476 504450 509609 510930 516483 516780 517885 518941 521168 523902 525713 527955 534020 534023 539561 543708 553653 553921 557267 557810 558814 564377 564555 565937 568317 570832 571711 577080 577087 578803 580159 580642 591452 593785 598899 599669 600411 601444 603201 603420 603716 605498 605529 607023 614696 615721 623211 624990 641059 652758 661970 668139 719112 720206 724637 732905 760169 761088 792599 799350 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf amateur real"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf любительск real"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf любительск real"
]
|
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.